John Spicer

Senior Data Analyst at Virtual Business Office Associates
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Columbia, South Carolina, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Visual Studio Code for Web Developers
    LinkedIn
    Aug, 2019
    - Oct, 2024

Experience

    • United States
    • Human Resources Services
    • 100 - 200 Employee
    • Senior Data Analyst
      • Aug 2021 - Present

    • Data Analyst II
      • Apr 2019 - Aug 2021

      Prepared and submitted accurate and timely client and internal deliverables such as client reports, invoices, and ad hoc requests using various reporting tools including Power BI, SSRS, Excel, PowerPoint, and others. Utilized advanced knowledge in SQL Server databases and SQL scripting to update databases and create tables, views, and procedures. Assisted as required with client data loads, import summary reports, new client setup, and pre-project revenue analysis for potential clients. Duties:Prepared and submitted accurate and timely client deliverables.Demonstrated expert knowledge in MS Office Suite with a focus on Excel and PowerPoint, including expertise in charts, formulas, pivot tables, etc. Demonstrated advanced knowledge and skills in SQL Server relational databases, including the ability to update and maintain databases, as well as create tables, views, and procedures using SSMS T-SQL scripting.Assisted Data Analyst I in day-to-day operations, as needed.Provided support for the Data Analyst Manager and Senior Data Analysts in new client setups by analyzing raw data and creating database tables.Assisted Senior Data Analyst in analyzing data to identify and communicate trends to the operations team for all client engagements. Show less

    • Data Analyst I
      • Oct 2018 - Apr 2019

      Loaded client data to database tables and produce import summary reports. Utilized basic to intermediate knowledge in SQL Server databases and SQL scripting to update databases and created tables, views, and procedures. Assisted as required with client, internal, and workflow reports.Duties:Retrieved and reviewed raw files from various file transfer methods (FTP, Email, SharePoint).Scrubbed raw files for pertinent information, transformed and imported data to database tables.Produced daily and weekly reports.Assisted with the activities of a Data Analyst II by preparing and submitting accurate and timely client and internal deliverables (A/R analyses, biweekly reports, ad hoc reports). Show less

    • Associate Trainer
      • Oct 2016 - Oct 2018

      Provided training and development to staff groups across the organization. Performed a variety of training functions including providing new employees with a working knowledge of account follow-up processes prior to the employee being released for client engagement, addressing specific client-related quality concerns, and providing continuing education for technical skills required for advancement. Duties:Mentored/coached all staff members to be proficient in client systems.Consulted with Learning and Education Team Lead to identify and assess training needs associated with changes in policies, procedure regulations, business initiatives and technologies.Provided new-hire training on general billing and follow-up processes, system training, healthcare payer processes, engagement-specific policies, and organization-specific processes.Suggested performance improvement measures and evaluated their effectiveness against predetermined objectives. Executed the development and preparation of job aids, instructional materials, classroom, and online training appropriate to specific objectives.Recommended improvements to client service based upon training observations.Serves as subject matter expert for Healthcare Revenue Cycle processes and issues.Sought diverse views to encourage improvement and innovation, coached and developed staff through timely and meaningful written and verbal feedback. Show less

    • Patient Accounting Associate II
      • Sep 2016 - Oct 2016

      Worked accounts to full resolution – i.e., through payment, adjustment, identification of patient responsibility, and/or client-specified point of return. Resolved accounts and/or performed a secondary review of specific account actions to validate accuracy, completeness and appropriateness of actions taken to resolve accounts in adherence to client, organization, regulatory policies, and procedures. Duties:Possessed a thorough understanding of the hospital revenue cycle with specialization in hospital billing, follow-up, and the account resolution process to include, but not limited to; claims submission, acceptance, and adjudication, transaction reviews, adjustment posting, identification of patient responsibility, etc.Utilized and applied industry knowledge to resolve aged accounts receivable by working various account types. Leveraged available resources and systems (both internal and external) to analyze patient accounting information and took appropriate action for payment resolution. Documented all activity in accordance with organization and client policiesAssisted in mentoring of new hires including, but not limited, to shadowing and answering general collection questions. Show less

    • Patient Accounting Associate I
      • Mar 2016 - Aug 2016

      Analyzed the disposition of aged accounts receivable. Identified necessary actions to resolve the outstanding balance, and took identified resolution steps in adherence to client, organization, regulatory policies, and procedures.

Education

  • South University
    Doctor's Degree, Business Administration and Management, General
    2017 - 2020
  • Strayer University
    Master of Business Administration - MBA, Business Administration and Management, General
    2015 - 2017
  • Strayer University
    Bachelor of Business Administration - BBA, Business Administration and Management, General
    2013 - 2015

Community

You need to have a working account to view this content. Click here to join now