Senior Data Analyst with BI, ETL, and Data Quality Expertise

Geeta Pittampalli

Email:********************@*****.*** Location: Austin, TX, 78641

Contact No: +1-512-***-****

LinkedIn: geeta-gp-6a119b34a

Professional Summary:

Over 8+ years of experience as a Senior Data Analyst with expertise in Data Modeling, Data Warehousing, Data Visualization, ETL, BI, OLAP, and Client/Server applications.

●Experienced in Informatica Data Quality (IDQ) and Informatica Data Analyst (IDA), with expertise in Data Profiling, Data Cleansing, and Data Validation to ensure high-quality and accurate Data Management across various platforms.

●Extensively used Informatica Power Center, Informatica Data Quality (IDQ) as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.

●Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.

●Experience in using HTML, Python, Tableau, MATLAB, Excel and AWS.

●Good Knowledge in AWS concepts and Amazon Redshift tools.

●Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development.

●Skilled in using advanced statistical analysis and Data Modeling to derive insights from large datasets in the Pharmacy Benefit Management (PBM) domain.

●Expert in creating and designing interactive dashboards and reports using Tableau/Power BI/ Cognos/Qlikview, with additional skills in Matplotlib and Plotly for advanced data visualization.

●Good Knowledge on SAS Macros, SAS SQL, SAS Stat and SAS Graph in UNIX environment.

●Extensive experience working as a back-end tester by writing SQL Queries and PL/SQL scripts on large enterprise data warehouse systems. Expertise in the MS SQL Server suite of products like SSRS, SSIS, and SSAS.

●Expertise in handling SQL queries and optimizing them in Oracle, SQL Server, MS Access and Teradata.

●Extensive experience in Data Mining, generating data visualization solutions to various business problems, and generating Data Visualizations using R Programming Language and Python.

●Extensive experience with OLTP/OLAP System and E - R Modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional Modelling.

●Well versed with Medicaid Management Information Systems (MMIS) and familiar with Patient Protection and Affordable Care Act (PPACA), Health benefit Exchange.

●Adequate knowledge in Health Administration - Claims processing (auto adjudication), COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrolment, EDI, Medicare, Medicaid, CDHP (consumer driven health plans)

●Familiar with HIPAA EDI transactions such as 835, 837 (P, D, me) 276, 277, 278 etc.

●Experience with HEDIS Healthcare Effectiveness Data and Information Set for benchmarking managed care effectiveness and evaluating provider-payer relationships.

●Extensive experience in development of T-SQL, DML, DDL, DTS, Stored Procedures, Triggers, Sequences, Functions and Packages.

●Experienced in large data migration projects from on-prem databases to Azure SQL and Azure Data warehouse.

●Defining Test Cases, creating Test Scripts, analysing bugs, and interacting with QA / Development teams in fixing errors and User Acceptance Testing (UAT).

●Hands-on expertise in drafting the Unified Modeling Language (UML) diagrams.

●Experienced with reviewing and writing BRD, FRD, Technical Specification documents.

●Established processes for data tracking, monitoring, and trend analysis to ensure data accuracy and integrity.

●Constructed engaging Tableau Stories, featuring interactive Tableau dashboards & Monitored Key Performance Indicators (KPIs) through data-driven evidence, delivering valuable insights to technical and non-technical stakeholders.

●Extensive use of MS Office tools with great expertise in MS Excel and others like MS Access, MS Word, and MS PowerPoint MS Project for Data Migration into the CI System Knowledge Data Base in Microsoft SharePoint.

Technical Skills:

●Data Science Tools: Python (Pandas, NumPy), Jupyter Notebook.

●Data Visualization: Tableau, Matplotlib, Seaborn, Excel, PowerBI.

●Statistical Methods: Statistical Inferences, Descriptive Statistics, Exploratory Data Analysis (EDA

●Database Languages: SQL

●Cloud Services: GCP

●Programming & Scripting: Python, Korn Shell Scripts, HTML.

●Data Governance & Healthcare Standards: HL7, HIPAA, Meaningful Use.

●Office & Documentation Tools: MS Office Suite (Excel, Word, PowerPoint, Project, Visio), Rational Rose, Get Pivot, VLOOKUP in Excel.

Professional Experience:

MCNA Medical - Medicaid Enrollment JULY 2025 - Till date

Business Systems Analyst - (Healthcare Medicaid/Medicare Enrollment & Claims Systems)

●Analyzed and supported Medicaid enrollment and eligibility systems, ensuring accurate member coverage and alignment with state and plan requirements.

●Collaborated with business stakeholders to gather, document, and validate requirements (BRD/FRD) for enrollment, claims, and EDI processes.

●Performed data analysis and validation using SQL and Excel to identify discrepancies in member eligibility, enrollment records, and claims processing.

●Conducted root cause analysis for issues such as eligibility mismatches, missing enrollments, and claim denials, and provided data-driven solutions.

●Worked extensively with HIPAA EDI transactions including 834 (Enrollment), 837/835 (Claims), 270/271 (Eligibility), and 276/277 (Claim Status).

●Validated and reconciled EDI 834 enrollment files with internal systems to ensure accurate member data and coverage periods.

●Tested the HIPAA EDI transactions 834(X12), 837/835, 276/277, and270/271 according to the required test scenarios.

●Designed and developed interactive dashboards using Tableau and Power BI to track KPIs, enrollment trends, and operational performance.

●Supported ETL processes using Informatica and Azure Data Factory for integrating data from multiple healthcare systems.

●Automated data cleansing and transformation workflows using Python to improve data quality and reduce manual effort.

●Ensured compliance with HIPAA and HL7 standards while handling sensitive healthcare data.

●Participated in EMR/EHR system implementations, ensuring accurate integration of clinical and enrollment data.

●Performed functional testing, regression testing, and UAT to validate system changes and ensure business requirements were met.

●Supported data warehouse and reporting solutions, including data modeling, SQL development, and report validation.

●Generated reports and performed analysis using Excel (Pivot Tables, VLOOKUP) to support business decisions and audits.

●Coordinated with cross-functional teams including claims, enrollment, IT, and state agencies to resolve data and system issues.

HCA Healthcare, Houston, TX APR 2024 - JUNE 2025

Sr. Data Analyst

●Conducted Exploratory Data Analysis (EDA) using Python and visualized complex data patterns with Matplotlib and Seaborn, delivering actionable business insights.

●Designed and implemented Tableau dashboards showcasing key performance indicators (KPIs), trends, and data-driven insights to enhance stakeholder decision-making processes.

●Participated in the development of ETL pipelines using Informatica and Azure Data Factory to integrate and cleanse data from multiple clinical and administrative sources.

●Developed efficient data cleansing and transformation workflows using Python, automating repetitive tasks to improve productivity and data quality.

●Ensured compliance with HL7 and HIPAA standards in handling sensitive healthcare data, maintaining data security and regulatory adherence.

●Worked to maintain eligibility for members with Medicaid and Medicare with the support of the Medicaid Management Information System (MMIS).

●Involved in Healthcare system implementation, including enterprise Electronic Medical Records (EMR) and Electronic Health Records (EHR) software.

●Integrated systems with HEDIS, using Tableau for data visualization and clinical data analytics. Collaborated across multidisciplinary teams and excelled in healthcare data analytics techniques like machine learning.

●Tested the HIPAA EDI transactions 834(X12), 837/835, 276/277, and270/271 according to the required test scenarios.

●Participated in Forward and Backward Mapping analysis of ICD 9 - ICD 10.

●Utilized SAS for advanced statistical analysis and predictive modeling to support population health programs and risk stratification.

●Participated in Facets Table Data Modelling planning, designing, implementation of the data warehouse and conducted testing by developing complex SQL queries.

●Participated in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

●Building, publishing customized interactive reports and dashboards, report scheduling using Cognos.

●Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.

●Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.

●Created a road map for the client for the planning, developing, and implementing of MDM solutions, enabling consolidation of MDMdata following Mergers and Acquisitions.

●Participated in large-scale data migration projects, moving critical healthcare data from on-premises SQL databases to Azure SQL and Azure Synapse Analytics (formerly Azure Data Warehouse).

●Validated data accuracy and generated statistical reports using Excel tools, including VLOOKUP, Pivot Tables, and statistical tool packs, transforming raw datasets into meaningful narratives.

Virginia Department of Health (VDH), Richmond, VA MAR 2021 – MAR 2024

Senior Data Analyst

●Analyzed healthcare claims and enrollment data to support business decisions across Medicare, Medicaid, and commercial insurance lines.

●Developed and optimized SQL queries to extract and manipulate large datasets from internal data warehouses, including claims, member, and provider information.

●Built automated dashboards and reports using Power BI and Tableauto track performance metrics such as medical cost trends, utilization rates, and risk scores.

●Developed and maintained dimensional data models and Snowflake schema designs in data warehouses to support scalable analytics and regulatory reporting.

●Employed Python (pandas, NumPy, matplotlib) for data cleaning, statistical analysis, and ad-hoc investigations into clinical and financial performance.

●Supported the Medicare Risk Adjustment team by identifying coding gaps and trends that impact CMS revenue and patient outcomes.

●Utilized Facets data structures to analyze member enrollment, eligibility, provider contracts, and claims data for performance monitoring and compliance.

●Interfaced with EMR/EHR systems (e.g., Epic, Cerner) to analyze clinical data, track outcomes, and enhance integration with administrative and claims data.

●Interpreted EDI (837, 835) transaction sets for claims and remittance data analysis, contributing to billing cycle optimization and revenue reconciliation.

●Applied ICD-10, CPT, and HCPCS coding standards to categorize services and diagnoses in claims data, ensuring accurate classification and cost attribution.

●Designed and validated ETL pipelines within enterprise data warehouse environments (on premise and GCP) to streamline reporting processes and support population health initiatives.

●Collaborated with cross-functional teams in actuarial, provider analytics, and care management to deliver insights aligned with strategic goals.

●Applied data validation techniques to ensure the accuracy and completeness of data used in regulatory reporting and internal audits.

●Participated in the migration and integration of legacy data systems into a unified cloud-based platform (Azure), improving accessibility and scalability.

●Conducted root cause analysis on anomalies in healthcare cost and quality metrics, recommending actionable improvements to business leaders.

●Assisted in population health analytics initiatives to identify high-risk members and support proactive care coordination strategies.

●Utilized Microsoft Visio to document data flows and system architecture, Excel for advanced data analysis and pivot reporting, and Word to create technical documentation and business requirement specifications.

Tenet Healthcare, Dallas, TX JAN 2018 – FEB 2020

Data Analyst

●Led data analysis initiatives to support clinical, operational, and financial decision-making across multiple hospital networks.

●Developed and optimized SQL queries for extracting, transforming, and loading (ETL) data from on premise systems and cloud-based sources into Azure SQL Database and Azure Synapse Analytics.

●Designed and maintained complex SQL queries and stored procedures to extract, clean, and analyze large volumes of healthcare data from diverse sources, including EHRs and claims systems.

●Collaborated with business stakeholders, data engineers, and clinical teams to define data requirements and translate them into actionable analytics solutions.

●Collaborated with data architects and governance teams to model dimensional data structures and support scalable analytics across Tenet’s data platforms.

●Developed interactive dashboards and reports using Power BI and Tableau to visualize trends in patient care quality, readmission rates, and operational KPIs.

●Conducted root cause analyses and statistical modeling to identify inefficiencies in hospital workflows and recommend evidence-based improvements.

●Ensured compliance with HIPAA regulations and internal data governance standards by managing data access controls and audit documentation.

●Parsed and transformed XML-based healthcare data (e.g., HL7, CCD) for integration with enterprise systems and for use in compliance reporting.

●Provided mentorship and technical guidance to junior analysts, promoting best practices in data wrangling, visualization, and healthcare metrics interpretation.

●Automated recurring data processes to improve reporting turnaround times and reduce manual errors in regulatory and internal reporting.

●Utilized Python for data cleaning, transformation, and statistical analysis, including libraries such as pandas, NumPy, matplotlib, seaborn, and scikit-learn.

●Implemented Python-based validation scripts to ensure data accuracy and completeness during data migration to Azure cloud environments.

●Supported enterprise Master Data Management (MDM) strategies by ensuring accurate, consistent, and de-duplicated reference data for patients, providers, and facilities.

●Created rule-based validation and reconciliation logic in Informatica to uphold data quality standards and improve confidence in reporting outputs.

CVS Pharmacy, Woonsocket, RI APR2016 – DEC 2017

Data Analyst

●Analyzed pharmacy and retail data to identify trends in medication sales, customer behavior, and store performance across multiple regions.

●Understand the internal summarization of the GDPR requirements and perform a gap analysis of all Business and IT processes, systems, procedures and controls, producing a gap analysis summary report as an initial deliverable.

●Monitored PBM performance metrics, such as rebate tracking, drug cost trends, and generic substitution rates, supporting efforts to optimize formulary design.

●Created interactive dashboards using PowerBI, Tableau to visualize pharmacy claims data, aiding in operational decision-making.

●Extracted and transformed EMR/EHR data (from Epic, Cerner) and integrated it with PBM claims to enable comprehensive care quality and utilization analysis.

●Collaborated with cross-functional teams (marketing, operations, and IT) to align data strategies with CVS's retail and healthcare service goals.

●Analyzed real-world evidence (RWE) and claims data to support medication therapy management (MTM) initiatives and gap-in-care reporting.

●Ensured that all models developed complied with regulatory and business constraints, maintaining the integrity and legality of PBMoperations.

●Performed root cause analysis on key metrics such as prescription drop-off rates, customer churn, and supply chain delays.

●Automated routine reporting processes using Power Query and VBAto reduce manual effort and improve report delivery timelines.

●Cleaned, transformed, and validated large healthcare datasets from internal and external sources, ensuring high data quality for analytics initiatives.

●Ensured regulatory and audit compliance by preparing data extracts and documentation for CMS, HIPAA, and internal audits related to PBM operations.

●Utilized Jira to create and manage user stories, tasks, and epics, ensuring seamless tracking of data analysis projects from inception to completion.

●Implemented predictive models to forecast prescription demand, helping optimize inventory levels and reduce medication stock outs.

●Supported marketing campaigns by analyzing loyalty card data and customer segmentation to improve targeting and ROI.

●Worked with SQL and ETL tools to streamline data extraction and processing from CVS's enterprise data systems.

●Collaborated with client account teams to deliver customized PBMperformance reports and insights to employer groups and health plan partners.

Education:

●BA (BeAd) from Osmania university 2002.

●Salesforce admin certification.

Contact this candidate