Vandana Singh
Data Analyst
Gurgaon
Summary
Data Analyst with 3+ years of experience in SQL, Python, Power BI, and Excel, specializing in automated dashboards, MIS reporting, and KPI analysis. Strong expertise in data cleaning, EDA, revenue and payment analytics, and translating data into actionable business insights.
Overview
4
4
years of professional experience
Work History
Data Analyst
MakeMyTrip
05.2023 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Reduced manual MIS reporting effort by 40% by developing and maintaining automated Power BI dashboards for payment reconciliation and revenue tracking.
- Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.
- Decreased reconciliation discrepancies by 25% by creating optimized SQL queries and validation checks for payment processes.
- Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
Operations Analyst
DBMCI
04.2022 - 04.2023
- Analyzed enrollment and performance datasets to improve operational reporting and program monitoring.
- Implemented data cleaning and validation processes in Excel, increasing dataset reliability and consistency.
- Collaborated with academics, sales, and marketing teams to deliver actionable insights.
- Managed multiple projects simultaneously, delivering results within tight deadlines while maintaining high-quality standards.
Education
MCA -
Hindustan Institute of Management & Computer Studies
Mathura, India05.2019
BCA - undefined
Dr. Bhim Rao Ambedkar University
01.2016
Skills
Microsoft Power BI
SQL
Advance Excel
MIS Reporting
DAX
Pandas
EDA
Data Modeling
Windows Function SQL
Data analysis
Data Visualization and Presentations
Data Cleaning
ETL Process
KEY ACHIEVEMENTS
Reporting Automation, Successfully automated reporting and analytics processes that improved decision-making efficiency
Timeline
Data Analyst
MakeMyTrip
05.2023 - Current
Operations Analyst
DBMCI
04.2022 - 04.2023
BCA - undefined
Dr. Bhim Rao Ambedkar University
MCA -
Hindustan Institute of Management & Computer Studies