Upasana Purohit
Levittown,NY
Summary
Positive and analytical with knack for turning data into actionable insights. Comprehensive understanding of statistical analysis and data visualization tools such as SQL and Power BI Dedicated to leveraging data-driven strategies to drive success and innovation.
Overview
4
4
years of professional experience
Work History
Data Analyst
CVS
Remote
04.2024 - 11.2024
- CVS is the nation’s largest integrated health solutions provider serving 110M+ members.
- Led multiple claims and utilization reporting projects supporting cost-of-care analytics.
- Automated weekly and monthly dashboards in Power BI, reducing manual reporting time by 60%.
- Developed SQL queries to analyze high-utilization members, cost drivers, and diagnosis-level trends.
- Conducted a forensic analysis of device assignments by cross-referencing data from Mattersight, Verint, and Medallia, successfully exposing gaps in asset tracking.
- Leveraged SQL for data querying and MS Excel for analysis to pinpoint inactive employees still in possession of company hardware.
- Created executive-level Power BI reports that highlighted employees with multiple devices, facilitating a targeted device retrieval strategy.
- Provided Medisked system support to clinical and administrative staff, resolving user issues and ensuring accurate data entry for compliance with state regulations.
Data Analyst
AHRC Nassau
Plainview, NY
05.2021 - 04.2024
- Managed end-to-end claims processing for Medicare and Medicaid billing within the Medisked platform, ensuring compliance with state and federal healthcare regulations.
- Performed monthly reconciliation of billing data against service logs, identifying and correcting errors that significantly reduced claim denials and revenue leakage.
- Provided critical system support for Medisked users, training staff on accurate data entry procedures to ensure valid claim generation and audit readiness.
- Analyzed billing discrepancies using Excel to track trends in denied claims, implementing process improvements that increased first-pass acceptance rates.
- Maintained the integrity of client data within the EHR system, verifying Medicaid eligibility and service authorization to prevent billing gaps.
- Nonprofit organization focused on disability services and Medicaid claims.
Education
Computer Engineering -
New York Institute of Technology
Old Westbury05.2021
Electronics Engineering - undefined
Biju Pattnaik University of Technology
Bargarh, Orissa07.2014
Skills
- Verint
- Excel
- SQL
- Power BI
- SQL (Advanced)
- Snowflake
- Python (Pandas)
- Tableau
- Data visualization and presentations
- Data analysis
- Python programming
- Excel functions
- Data cleaning
- SQL databases
- Analytical problem solving
- Statistical analysis
- Attention to detail
- ETL processes
- Data modeling
Timeline
Data Analyst
CVS
04.2024 - 11.2024
Data Analyst
AHRC Nassau
05.2021 - 04.2024
Electronics Engineering - undefined
Biju Pattnaik University of Technology
Computer Engineering -
New York Institute of Technology