We provide IT Staff Augmentation Services!

Senior Lead - Data Analyst Resume

Providence, RI

PROFESSIONAL SUMMARY:

  • Have 8+ years’ Experience in SQL, TABLEAU Dashboards, Microsoft Excel (Pivot Tables, VLOOKUP'S, Macros) and Healthcare Industry Claims submission and Data Analysis, auditing, ICD9/10, CPT, Modifiers, Medical Records check, Project Management and Team Handling.
  • Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per AGILE Methodologies.
  • Good Hands on Experience with Healthcare ad Financial Data Analysis and Put the analysis result into the Reports as Graph or Pivot Tables.
  • Good Hands on Experience with SQL, Tableau and Excel and Excellent understanding on Tableau Workbooks and Background Tasks for Targeted Interactions Validation.
  • Having Good Hands on Experience about Healthcare revenue cycle and accounts receivable management, including payment cycles, key trends, and critical success criteria
  • Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.
  • Have Strong Experience in transferring the data with in Multitiered system by using Business Object (BO) techniques.
  • Have Good Experience to create Visualization Dashboard by using Tableau for the Data.
  • Strong Knowledge of Medical Billing Rules and Regulations to bill the claims to the Insurance offices to get paid.
  • Having Good Experience with denial management and appeals processes
  • Strong knowledge to handle the 835 and 837I, 837P claims Data Analysis and Strong Experience in Provider Credentialing. Good Hands on Experience with EDI Systems.
  • Able to identify performance issues, assess root cause and develop successful action plans for the Production and Quality improvement.
  • Have good Hands on Experience working with Physician Claims (HCFA or CMS1500) and Hospital claims (UB04).
  • Having Good knowledge in US Healthcare Industry end to end (Billing Rules and Regulations, Hospital Claims, DME Claims, Physicians office Claims submission and Insurance office all type of Claims adjudication).
  • Good Hands on Experience to use ICD 9 codes and Good and Strong Experience on EMR files. Good Knowledge of ICD 10.
  • Have Management Experience to handle the team, Project and deliver the quality reports and explain upfront of the management about the Quality of production.
  • Have strong experience to generate and deliver the Revenue reports Weekly, Monthly, Quarterly and yearly based.
  • Have an Experience Hiring Employees, Appropriate Training and Performance updates to Higher Management and Result in Appraisals.
  • Having Experience in billing claims to Insurance Company and adjudicate Physician office claims and Hospital claims as per the plan benefits.
  • Strong Experience to work with EDI Claims (submitting and processing claims).
  • Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
  • Have Good Experience to Contact all type of Insurance plans like Medicare, Medicaid, HMO, PPO and POS.
  • Have good Experience to Adjudicate and analysis plan and making payment process to the Payer.
  • Involved in all type of Insurance adjudication process and Solid work Experience with Medicaid, HMO, PPO and POS.
  • Total Highest Direct Reporters in One Project are 30 Direct Reportees.
  • Good Hands on Experience to make Pivot Tables and VLookup to analysis the data and making reports.
  • Lead the Project and Team members to accomplishment of Project on Time.
  • Have good knowledge about financial management skills, including budgeting, forecasting and benchmarking.
  • Able to work in a fast - paced, service oriented environment
  • Having excellent communication, interpersonal skills and ability to demonstrate emotional intelligence.
  • Able to perform multi-task and work with a sense of urgency

TECHNICAL SKILLS:

HL7 and Claims billing tools: -All Scripts, Misys, Medical Billing S/w, JACADA and Main Frame.

Data Modeling Tools: Power Designer and Oracle SQL Developer.

Cloud Platforms: Amazon (AWS) EC2, EC3, Elastic Search, Elastic Load Balance.

Operating System: Windows 8/10, UNIX, Sun Solaris.

Database Tools: Microsoft SQL Server 16.0, PostgreSQL and MS Access.

BI Tools: Tableau 10, Tableau server, Tableau Reader, Crystal Reports

Packages: Microsoft Office 2016, Microsoft Project 2016, and Microsoft Visio, Share point Portal Server.

Programming Languages: UNIX Shell Scripting

Methodologies: Agile and have knowledge about Waterfalls.

PROFESSIONAL EXPERIENCE

Confidential, PROVIDENCE, RI

SENIOR LEAD - DATA ANALYST

RESPONSIBILITIES:

  • Involved in Business and Data analysis during requirements gathering.
  • Worked to make User Stories and responsible to complete the stories on time. Worked in Agile Process, handle all the escalations from team if they have any Road Blocks
  • Performed segmentation to extract Data and create lists to support direct marketing mailings and marketing mailing campaigns.
  • Generated and reviewed reports to analyze Data using different excel formats Documented requirements for numerous Ad-hoc reporting efforts
  • Troubleshooting, resolving and escalating Data related issues and validating Data to improve Data quality.
  • Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
  • Involved in UAT and Integration testing
  • Metrics reporting, Data mining and trends in helpdesk environment using Access
  • Gather Data from Help Desk Ticketing System and write Ad-hoc reports and, charts and graphs for analysis.
  • Report on trends that come up as to identify changes or trouble within the systems using Access and Crystal Reports.
  • Performed User Acceptance Testing (UAT) to ensure that proper functionality is implemented.
  • Guide, train and support teammates in testing processes, procedures, analysis and quality control of Data, utilizing past experience and training in SQL, Unix and relational databases.
  • Maintained Excel workbooks, such as development of pivot tables, exporting Data from external SQL databases, producing reports and updating spreadsheet information.
  • Modified user profiles, which included changing users cost center location, changed users authority to grant monetary amounts to certain departments - monetary amounts were part of the overall budget amount granted per department
  • Deleted users from cost centers, deleted user’s authority to grant certain monetary amounts to certain departments, deleted certain cost centers and profit centers from database
  • Created a report, using Tableau feature that showed which are claims have paid fully, and where the claims received in huge count.
  • Created the Quality Reports by using TABLEAU before submitting the Medicaid data.
  • Worked with Tableau to create Dashboard to show the visualization about the Healthcare claims data and Federal and State Insurance data.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables. Worked on issues with migration from development to testing.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the Data
  • Validated cube and query Data from the reporting system back to the source system. Tested analytical reports using Analysis Studio

ENVIRONMENT: CPT, ICD9/10, HCPCs, Modifiers, Medicare and Medicaid, SQL, Oracle 11g, SQL Server 2014, PostgreSQL, Windows 7, Tableau, MS Excel, MS Access, Manual Testing UAT.

Confidential, CA

PROJECT LEAD - DATA ANALYST

RESPONSIBILITIES:-

  • Worked as Senior Analyst in Agile Process for Migration Project over the servers.
  • Worked with MongoDB, SQL, Involved in Gathering information for New Project and setup the Environment.
  • Worked in Agile Process, Used to Make stories for all the Sprints and responsible handle all the stories and assign to the teams.
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Have good hands on experience to analysis the Claims data and submitting the Medicaid data to state govt. Used to show the all the possible visible information by using TABLEAU.
  • Collected, analyze and interpret complex data for reporting and/or performance trend analysis
  • Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects. Maintaining testing metrics and circulating it to key stakeholders.
  • Work with business users, system analysts, designers and programmers to create and analyze various required project documents.
  • Created various dashboards by using TABLEAU.
  • Hands-on technical Test lead performing test planning and execution of Test Integration activities across multiple platforms/applications.
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Created SQL tables with referential integrity, constraints and developed queries using SQL.
  • Performed GAP analysis of current state to desired state and document requirements to control the gaps identified.

ENVIRONMENT: CPT, ICD9/10, HCPCs, Modifiers, Medicare and Medicaid, PL/SQL, TABLEAU, SQL and MS Excel, MS Visio, MS Access, Power Point, MS Outlook.

Confidential, PAJ

SR. DATA ANALYST

RESPONSIBILITIES:

  • Worked in Agile process and Good experience to gathering the Environment requirement and Claims Data analysis.
  • Preparing input files for 3rd party data processing, Gathering the Required information for Project and for further Project accomplishment.
  • Analyzing the data results and making changes if needed, before presenting the data to project managers and internal consultants
  • Able to interpret, scrub, process, and explain data
  • Proficiency with Microsoft Office Suite, especially Excel
  • Analytical thinker, able to assess problems logically
  • Provide data and competitor analytics that enhance and drive sales strategy
  • Perform client research and collaborate with sales and leadership team members to determine a comprehensive view of client historical operational, financial and quality data
  • Analyze client data to understand historical performance relative to potential performance of products and programs, identify performance gaps and highlight performance improvement opportunities and created useful graphs and dashboards by Using TABLEAU and Excel Pivot tables.
  • Review analytics against Center for Medicare and Medicaid Services (CMS) model to identify revenue potential
  • Develop customized client analytics reports to support sales proposal development and sales presentations
  • Ability to understand client operations, financial and quality data
  • Ability to identify data discrepancies and produce accurate data analyses.
  • Created Various visible graphs about the claims data by using TABLEAU to show to all the stake holders and internal management.
  • Worked with Business Object to get the data with Multitiered application.
  • Knowledge of managed health care industry, health plans and large group physician organizations
  • Extensive Knowledge of CMS programs
  • Ability to effectively communicate with all levels of an organization both internally and externally
  • Excellent analytical, decision making, organizational, creative problem solving, verbal and written skills are required
  • High level of proficiency in use of existing software packages and data analysis tools (PowerPoint, Excel, Microsoft Word, etc.)
  • Ability to work independently within a team environment with multiple priorities

Environment: CPT, ICD9, HCPCs, Modifiers, MS Office, MS Visio, Tableau, MS Access, SQL, Windows 2000.

SENIOR PROCESS EXECUTIVE

Confidential

RESPONSIBILITIES:

  • Worked as an internal quality auditor Promoted by Client and Manage the Total project for Production and Quality. Generated the Reports to update to VP of my Project.
  • Worked for Enrollment, Insurance Billing and Claims Adjudication.
  • Worked on Premium, Self and Individual billing.
  • Billing for Group Health insurance, self-insurance and Individual Insurance.
  • Being as an Auditor solving all the Queries within the team.
  • Assigning the Work to the Processors and auditing work.
  • Attend the calls twice in a week for new process and Business updates from client end.
  • Took the training classes for new updates, any new scenarios.
  • Have good experience to Conducted the errors sessions. Explaining the errors which were captured in internal auditing or External Auditing. And Giving the Preprocess steps to the team members to do not come across the same error in later days.
  • Used to give all the possible ways to remove the error if any error has been tagged to offshore team.
  • Processed Health information transformed from System to system individually (HIE and HIX).
  • Holding the Claims Adjudication Experience, Prepared the notes for Adjudication process for HCFA and UB04 Claims. And supporting the team to give the correct payment to the provider with an appropriate adjudication process (if it is a big amount Process only will be done by our team, amount will be released by Client).
  • Strong experience to work with EDI Cla ims processing.
  • Good Knowledge and work experience with Medicare, Medicaid and Medical claims for Health, Vision and Dental Plans.
  • Strong Hands on experience to work on Workers Compensation claims.
  • Wrote a Rebuttal statement with an appropriate reason to remove the error which is charged by External auditing team (MTM Auditing).
  • Maintained the quality to make the team as a best team and preparing the team production reports on daily, weekly and monthly basis.
  • Prepared the Reports for Internal audit purpose within the Organization.
  • Worked for all type of insurance adjudication process Medicaid, HMO, PPO and POS
  • Took an initiative to prepare the PKT (Process Knowledge Test) paper for every month.
  • Preparing and presenting project deliverables and findings to senior project stakeholders and practice area leadership as required, through the TABLEAU and Excel graphs, tables, and other strategic information to summarize analyses and results.
  • Have good Experience to Creating Dashboards by using TABLEAU and giving demo about the Medicaid data and its analysis to Internal management and Client management as well.
  • Contributing to an innovative and team-oriented work environment with individual accountability and ownership to the success of the practice.
  • Knowledge development and continuing to educate and sharing knowledge with QA team members.
  • Conducted the training sessions related to the process and Conducted Health care-oriented sessions. Leading and Motivating the team.
  • Conducted the Training sessions on the new process or after Client training is over, review of training programmers use to conduct and explain each and every information to the team mates to make the process very easy and appreciated from client.
  • Meeting the Production and Quality as per the set targets and standards.

ENVIRONMENT: SQL, TABLEAU, MS Office Suit (Excel, PowerPoint, Word) Claims Database, All Scripts, ICD9, Diagnosis codes, HCPCS codes, CPT Codes, EDI Claims Processing.

Confidential

MEDICAL, DENTAL AND VISION CLAIMS ADJUDICATION

RESPONSIBILITIES:

  • Worked for Claims adjudication process with the following all the Parameters of Claims Adjudication process (Co-Pay, Coinsurance and Deductible) and Managing the Team and Project.
  • Paid the claims with the correct adjudication process as per the Plan benefits.
  • Worked on Physician Claims (HCFA - 1500) and Hospital Claims (UB04).
  • Worked on Medical, Vision and Dental claims.
  • Worked for Preexisting claims. (How to determine the Preexisting condition and what are the benefits and how to pay the claims).
  • Worked on Other Insurance, Duplicate claims and Auto accident claims.
  • Worked on Corrected claims and Secondary payer claims.
  • Being as and Experienced Associate took an Initiate to Explain all the Plans benefits, how to adjudicate a claim for specific treatment as per the plan benefits.
  • Handled total 40 plans.
  • Took an Initiative to solve the entire team members Queries regarding all the claims.
  • Took Initiative to work with EDI Claims and handling claims data base every week.
  • Worked for all the insurance adjudication process Medicaid, HMO, PPO and POS
  • Handled the Workers Compensation Claims alone in team.
  • Strong work Experience with Medicare and Medicaid claims for Medical, and Vision plans.
  • Conducted the training sessions on Health care orientation and Claims adjudication process (Explained about CPT codes, Diagnose codes and importance of Modifiers).
  • Took an initiative when my team SME / TL absent collated and send the production report and quality report to the Manager on daily, weekly and monthly basis.
  • Writing rebuttal statement to remove the error which tagged by onshore team. (Whenever they charged an error mistakenly).
  • Apart from the adjudication, worked in Quality department for measuring the Process quality if any errors found charge it to the Respective associate and revised it correctly.
  • Meeting the Production and Quality as per the set targets and standards.
  • Used to give all the possible tips to the People who are working on Coding process how to code and how to use the code as the geographical area and to make the Physician benefits.
  • Having good hands on Experience on Coding the ICD9 Diagnosis codes.
  • Having good exposure on CPT codes and Modifiers.
  • Good knowledge about the adjudicating the claims and to releasing the checks to the Provider’s offices.
  • Building collaborative methods to develop and share internal reports with peers.
  • Expert in Healthcare Knowledge end to end (Physician Billing and Hospital billing and adjudication as well).
  • Have Good Experience to Handle the Project with good Planning and managing the team to meet the current goal with good Quality.

ENVIRONMENT:SQL, MS Office Suit, Excel, PowerPoint, Word, Claims Database, All Scripts, ICD9, Diagnosis codes, HCPCS codes, CPT Codes, EDI Claims Processing, MS Access.

Confidential

DATA ANALYST

RESPONSIBILITIES:

  • Responsible to enter the Office Visit and Emergency Charge Entry for allotted clients. Gathering Required information and placed in dashboard to be available to Management.
  • Checking patient eligibility with the concerned insurance company.
  • Responsible for Capturing the Charge and Billing the claims to insurance companies.
  • Responsible for cash posting for allotted clients once we received the EOB.
  • Responsible to post the payments which are received while working in AR Process.
  • Responsible to make calls to the INS offices to know the denial status of claims.
  • Responsible to Coding the Diagnosis code as per the Geographical area and HIPAA rules.
  • Leading the Team and Project Management. Client Management.
  • Worked in AR process, responsible for Claims which are in 0-30days, 60-90days and 90-120days
  • Worked on Denials and Correspondence claims.
  • Taking an appropriate action to appeal for Denial claims.
  • Worked on Denial Management and Collect the appropriate amount form Payers by submitting all the proofs.
  • After done my Initial Performance Review got a chance to look over the Project and work maintenance to manage up to date all the time and update the Provider database as well.
  • Responsible for allotted clients to prepare the appeal letters for Denials and cover letter for incorrect denials which received from Insurance Companies.
  • Worked for Rejections which are received from clearing House and Insurance Company from Pre-adjudicate Department.
  • Responsible to submit the claims thru EDI and refile the claims thru EDI if any comes back as Rejected or Denied.
  • Worked with Medicare, Medicaid, HMO, PPO and POS organizations for Denial or Rejections management and appropriately used to make appeal too.
  • Worked on ICD9 codes (Coding Dx for doctors Listed Symptoms of Patient to send to Insurance office to get claims paid).
  • Worked with SQL to analysis the claims as per specialist wise and making a graph to know the claims data and revenue management.
  • Maintaining the ageing report to collect the outstanding amount from the Insurance Company to Provider Office.
  • Worked on Medicare IVR Calls.
  • Good Hands on Experience with Misys and All scripts.

ENVIRONMENT:SQL, TABLEAU, MS Office Suit, Excel, PowerPoint, Word, Claims Database, All Scripts, ICD9, Diagnosis codes, HCPCS codes, CPT Codes, EDI Claims Processing, MS Access.

Hire Now