Data Analyst Business Intelligence

NAME: VIVEK PABBATHI

EMAIL ID: *******.******@*****.***

CONTACT NO: 281-***-**** Beavercreek, Ohio

PROFESSIONAL SUMMARY

• Over 5 years of experience as a Healthcare Data Analyst with expertise in data mapping, transformation, and integration for PBM data. Proven skills in requirement gathering, gap analysis, change management, user acceptance testing, data analysis, and business analysis. Extensive experience with ETL frameworks, data pipelines, workflow automation, and BI testing in the healthcare region. Strong understanding of healthcare interoperability standards, including FHIR, HL7, X12 EDI, and NCPDP.

• In-depth knowledge of Python, Java, PL/SQL, SAS, R, No SQL Databases, ETL tools.

• Experience in developing Business Intelligence assets using tools like Informatica PowerCenter, Informatica Data Quality OBIEE, Tableau, Oracle, and others.

• Proficiency in Business Intelligence, Oracle, Database, Informatica, SQL Developer

• Very good understanding and experience in User Acceptance Testing, Smoke Testing, Regression Testing, Performance Testing and Functional Testing

• Involved in IT Business Analytics, Data Analytics and Data Profiling tasks with business to make data more accurate and result oriented

• Understanding the internal technical needs of an organization and recommend solutions as per timelines

• Expertise in various types of software development life cycles like water fall and agile.

• Proficient in Medicare and Confidential billing

• Interact with clients for requirement gathering and prepare Functional Specifications

• Excellent knowledge of Health Insurance Portability and Accountability Act (HIPAA) Standards and Compliance issues

• Proficient in ICD - 9-CM and ICD -10-CM coding and claims processing.

• Extensive experience in gathering Business/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements Document (BRD)

• Involved in facets system implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and Extensions, Load and Extraction programs involving HIPPA and proprietary format files and reports development.

• Worked with providers and Medicare and or Medicaid entities to validate the EDI transaction sets or internet portals.

• Act as a liaison between client and technical solutions/support groups, using advanced communication skills to elicit, document, analyze and validate client requirements

• Strong analytical and problem resolution skills with ability to plan, prioritize, and work efficiently in a multi-tasking environment

• Defining the AS-IS and TO-BE processes, and developing requirements through gap analysis.

• Provide support on production issues including troubleshooting, coordination with IT, and end user communication related to data issues

• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively

• Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, R, SAS, UNIX Shell Script ETL Tools: Informatica 9.5/9.1x/8.6x/7.x (Power Center) (Designer, Workflow Manager, Workflow Monitor, Repository), AWS Step Functions

Databases: Oracle 9i/10g/11g, SQL Server 2008/2005, Teradata, Sybase 11.5, DB2, PL/SQL, Snowflake, Redshift, BigQuery, Databricks

Operating Systems: Windows 2000/ XP/ Vista, LINUX, UNIX, DOS, Windows 2003 server. Tools: SQL Loader, SQL*Plus, TOAD, SQL Developer, Erwin Big data analysis / Statistical programming: using Python, SAS, R; Rapid miner, Arena, Spark Development Programming: Python, C#, JavaScript, Java, R, Eclipse, GitHub Python Libraries: Numpy, Scipy, Matplotlib,, MDP, Mlpy, NetworkX, Pandas, Scikits-learn Data Visualization: Tableau, Power BI, Looker

PROFESSIONAL EXPEREINCE

Client: CVS Health – Jackson, MS. May 2023 – Present Role: Healthcare Data Analyst

Responsibilities:

• Played a key role in the System Development Life Cycle process consisting of design and gap analysis, business requirements, systems requirements, test criteria and implementation to have the outputs of projects that dealt with the automation of correspondence directed to the insurance policy owners.

• Led data mapping, transformation, and integration for PBM data, optimizing accuracy in data pipelines and automating workflows using AWS Step Functions.

• Performed advanced data analysis with SQL, Python, and Spark, managing cloud data warehouses (Snowflake, Redshift, BigQuery) and ensuring seamless data integration.

• Developed interactive dashboards and reports using Tableau, Power BI, and Looker, while ensuring compliance with healthcare interoperability standards (FHIR, HL7, X12 EDI, NCPDP).

• Responsible for interacting with the business analysts and the business partners to identify information needs for the business requirements for DAR.

• Involved in Facets System implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and extensions, Load and Extraction programs involving HIPPA 835 and proprietary format files and reports development.

• Worked with the ETL specialists to migrate data into DWH & involved in data modeling.

• Responsible for checking member eligibility, provider enrolment and member enrolment for the Medicaid and Medicare claims.

• Defined functional test cases documented and executed test scripts in the Facets system.

• Performed data mapping for the application, confirmed and vacillated the requirements at time of testing. Environment: SQL 2012, RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2007 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003 and HTML, Python. Client: Global Health Ltd Dec 2019 – Dec 2022

Role: Data Analyst

Responsibilities:

• Worked with providers and Medicare or Medicaid entities to validate the EDI transaction sets or internet portals. This includes HIPAA 837, 835, 270/271, and others.

• Gathered requirements and modeled the data warehouse and the underlying transactional database & performed Gap analysis of the processes to identify and validate the requirements.

• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

• Developed customer view Reports (Ad Hoc Reports, Frequency Reports, Summary Reports) using python

• Developed dashboards (Java, Python, SQL) on safety-tagged documents of incidents and cost tables by time series

• Analyze Format data using Machine Learning algorithm by Python Scikit-Learn.

• Experience in python, Jupyter, Scientific computing stack (numpy, scipy, pandasand matplotlib).

• Perform troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team.

• Write Python scripts to parse JSON documents and load the data in database.

• Generating various capacity planning reports (graphical) using Python packages like Numpy, matplotlib.

• Analyzing various logs that are been generating and predicting/forecasting next occurrence of event with various Python libraries.

• Provided data analysis from both within and outside of department. Prepared executive level presentations on off label drugs utilization for management and clients.

• Converted all SAS programs for reoccurring reports and analysis to R, Python & SQL using various tools R studio, Teradata SQL Assistant.

EDUCATION

Master in Business Analytics Trine University - Angola,IN

Contact this candidate