AAKRITI CHAUHAN
Delhi
Summary
I am an aspiring data analyst with hands-on experience in data analysis projects through a professional certification. I have successfully completed two projects using SQL, Excel, and Power BI, demonstrating strong analytical and problem-solving skills.
Overview
2
2
years of professional experience
Work History
Data Processing Associate
Genpact
Gurugram
11.2024 - 05.2025
- I worked extensively on validating, updating, and maintaining structured datasets related to agent records, financial details, and identity information. This required strong attention to data accuracy, compliance, and process analysis, which naturally aligns with my role as a Data Processing Associate.
- Performed data quality checks on high-volume datasets related to agent records and financial information to identify discrepancies, duplicates, and inconsistencies.
Resolving Analyst
Optum Global Solutions (United Healthcare Group)
Gurugram
08.2023 - 10.2024
- As a Resolving Analyst at Optum, I handled healthcare appeals, where I reviewed medical records and policy guidelines to determine accurate outcomes. My role required strong analytical judgment, the ability to analyze large datasets, performed root-cause analysis on overturned, upheld, and adjustment data where strict compliance with HIPAA and UHG standards is maintained with accuracy.
Education
Bachelor of Commerce -
Motilal Nehru College
Delhi, India01.2023
School -
Kendriya Vidyalaya Arjan Garh
Delhi, India01.2020
Skills
- Excel
- SQL
- Power BI
- Python
- Medical policy interpretation
- presenting insights clearly
- Report generation
Affiliations
Project on SQL (Retail Data Analysis):
1. Handling complex SQL queries involving JOINs, subqueries, CTEs, GROUP BY, HAVING, and window functions.
2. Identified top-performing products, high-value customers, and low-performing categories to support data-driven decision-making. Performed data cleaning and validation by handling null values, duplicates, and inconsistent records. Generated insights related to monthly sales trends, customer purchase behavior, and revenue contribution by category.
3. Calculated key business metrics such as revenue, average order value, identified peak sales periods, and seasonal demand trends to support inventory planning. Analyzed product-wise, region-wise, and category-wise sales to identify top-performing segments.
1. Handling complex SQL queries involving JOINs, subqueries, CTEs, GROUP BY, HAVING, and window functions.
2. Identified top-performing products, high-value customers, and low-performing categories to support data-driven decision-making. Performed data cleaning and validation by handling null values, duplicates, and inconsistent records. Generated insights related to monthly sales trends, customer purchase behavior, and revenue contribution by category.
3. Calculated key business metrics such as revenue, average order value, identified peak sales periods, and seasonal demand trends to support inventory planning. Analyzed product-wise, region-wise, and category-wise sales to identify top-performing segments.
Certification
Data Analyst Course, AnalytixLab
Hobbies and Interests
- Travelling (Exploring diverse cultures and gaining global perspectives through travel.)
Timeline
Data Processing Associate
Genpact
11.2024 - 05.2025
Resolving Analyst
Optum Global Solutions (United Healthcare Group)
08.2023 - 10.2024
Bachelor of Commerce -
Motilal Nehru College
School -
Kendriya Vidyalaya Arjan Garh