Elisha Agyapong
Stratford,CT
Summary
Senior Data Analyst with experience delivering data-driven insights using Excel, SQL, Power BI, and statistical analysis. Proven ability to translate complex datasets into actionable insights for senior management and cross-functional stakeholders, with applied experience analyzing Medicaid and CHIP datasets, including pharmacy utilization and preventive care quality measures, to support outcome measurement and performance monitoring.
Overview
2025
2025
years of professional experience
1
1
Certification
Work History
Senior Data Analyst, Client Account Analytics
Group1001
Stamford, USA
01.2021 - 01.2025
- Led a team of four in the development of an automatic system validation of premium, coverage levels, and other eligibility requirements for large client enrollment data, reducing enrollment data processing time by 30%.
- Developed and presented a loss analysis report under stressed scenarios to identify stop loss points of a client's lease portfolio.
- Conducted deep-dive analyses on claims, coverage and client enrollment data for $100 million to $500 million policies to identify trends, root causes, and performance drivers, translating findings into actionable insights for leadership and client.
- Built, updated, and maintained comprehensive Power BI and Excel dashboards tracking KPIs such as risk exposure, portfolio maturity, concentration risk, premium performance and claim severity for insurance clients to support data-driven decision-making.
- Developed and updated monthly, quarterly, and annual forecasting models using 10+ years of historical data, seasonality, and trend analysis to support financial planning and growth initiatives.
- Queried enterprise data warehouses using SQL to produce and present customized loss run reports and premium summaries for clients and brokers for risk assessment, underwriting pricing and financial planning purposes.
- Identified and implemented process improvements in claims and enrollment workflows through root cause analysis, stakeholder feedback and cross-functional collaboration, which reduced average processing time by 30% and improved data mapping accuracy.
- Partnered cross-functionally with IT and risk teams to gather requirements, define data logic and mapping for vendor data, leading to a 10% reduction in processing time and improving data availability for internal stakeholders.
- Built and maintained strong relationships with over 25 stakeholders including insurance clients, brokers, analytical services clients, and vendors; served as the primary liaison for all account-related data and reporting activities.
- Executed ETL processes including data extraction, validation, cleansing, transformation, and reconciliation of client enrollment and claims data (ranging from 50 - 30,000 rows) to ensure accuracy and policy compliance.
- Provided training and oversight to junior staff, and delegated ad-hoc analytical tasks as needed, fostering team development and ensuring timely delivery.
Medicaid Drug Spending Concentration Analysis (CMS
ABC
- Analyzed Medicaid drug utilization and reimbursement data at the product (NDC) level, applying reproducible SQL workflows to evaluate spending concentration patterns.
- Aggregated and ranked drug products by total Medicaid reimbursement to identify high-impact cost drivers.
- Identified HUMIRA PEN, BIKTARVY, TRULICITY, JARDIANCE, and INVEGA SUSTENNA as top-spend drugs, with no single product dominating overall Medicaid spending.
- Performed Pareto analysis showing that ~6% of drugs (~522 products) accounted for ~80% of total Medicaid drug spend, while the top 15 drugs contributed ~21%.
- Translated aggregate claims data into insights relevant to formulary management and cost-containment strategies.
Medicaid & CHIP Preventive Care Utilization Analys
XYZ
- Analyzed state-level trends in child and adolescent well-care visit rates using Medicaid and CHIP Core Set data.
- Calculated national and state-level averages, year-over-year changes, and multi-year trends to assess preventive care utilization.
- Ranked states by improvement and decline in well-care visit rates from 2021–2023.
- Developed Power BI visualizations (trend lines, heatmaps) to support payer-style performance monitoring.
Education
MA - Economics
City College of The City University of New York
New York City, NY06.2016
Skills
- R (statistical analysis)
- SQL (SQL Server, Snowflake, BigQuery)
- Advanced Excel
- Power BI
- Tableau
- Insurance product and claims analytics
- Healthcare and claims analytics (Medicaid, CHIP, CMS public data)
- Project management
- Analytical leadership
- Data storytelling
- Executive reporting
- Problem solving
- Cross-functional collaboration
- Stakeholder communication
- Health economics
Certification
Google Data Analytics Professional Certificate
Additional Information - Leadership
Structural Head, Boame Helping Hands, Darien, CT
Timeline
Senior Data Analyst, Client Account Analytics
Group1001
01.2021 - 01.2025
Medicaid Drug Spending Concentration Analysis (CMS
ABC
Medicaid & CHIP Preventive Care Utilization Analys
XYZ
MA - Economics
City College of The City University of New York