AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 1+ years in Excel, Power BI & SQL
Practical experience building end-to-end dashboards and reports across Excel & Google Sheets (VLOOKUP/XLOOKUP, Pivot Tables, Pivot Charts, Power Query), SQL (MySQL – SELECT, WHERE, JOIN, GROUP BY, CTES, Window Functions), and Power BI, having cleaned, validated, and analysed datasets of up to 38,500+ records. Operational Reporting Experience: Over 1 year of experience maintaining MIS trackers, preparing recurring performance reports, and ensuring data accuracy and consistency for management review – directly translating to building and maintaining reporting workflows and dashboards. Analytical Foundation: Structured, hypothesis-driven problem-solving sharpened through the McKinsey Forward Program, the Google Data Analytics Professional Certificate, and an ongoing Post Graduate Diploma in Data Science, supported by strong quantitative aptitude from competitive exam preparation.
Symbiosis Centre for Distance Learning
Post Graduate Diploma · Data Science
April 1, 2025 – Present
IGNOU
Master of Arts · Sociology
January 1, 2019 – January 1, 2021
DAVV, Indore
Bachelor of Arts · Sociology
January 1, 2015 – January 1, 2018
Gupta Arora & Co., Chartered Accountants
Business Operations Executive (MIS & Data)
April 1, 2025 – Present
Bhopal, Madhya Pradesh, India
Blinkit Grocery Sales Analytics Dashboard
June 1, 2025 – June 1, 2026
Built a 5-page interactive Power BI dashboard with 10+ DAX-based KPIs (Total Sales, Sales per Outlet, Average Rating, Category Contribution) analysing 8,500+ transaction records across outlets, products, and locations to support business decision-making. Independently validated all dashboard KPIs using SQL queries (GROUP BY, ORDER BY, aggregations) in MySQL, ensuring absolute consistency between BI outputs and source data. Generated business insights revealing that medium-sized outlets contributed ~42% of revenue, Tier 2 locations showed the highest sales efficiency per outlet, and Fruits & Vegetables emerged as the top revenue category, translating findings into recommendations for outlet expansion and category-led promotions.
Bank Loan Risk & Portfolio Performance Analysis
June 1, 2025 – June 1, 2026
Designed a 2-page Excel analytics dashboard with 12 business KPIs (Recovery Rate 108.56%, Good/Bad Loan %, Total Funded Amount, Average Interest Rate, Average DTI) to monitor loan portfolio performance and credit-risk exposure across 38,500+ borrower records. Engineered 12+ borrower segmentation features – including Risk Segment, Income Band, DTI Risk Level, Loan Size Category, and Employment Category – to enable risk profiling at the individual borrower level. Identified key default drivers – including High-Risk borrowers (26.65% default rate), Small Business loans (25.62%), and Low-Income borrowers (16.10%) – providing a data-driven basis for targeted risk management recommendations.
McKinsey Forward Program
McKinsey & Company
June 1, 2026 – Present
Google Data Analytics Professional Certificate
Coursera
August 1, 2025 – Present
Power BI Certification
Tutedude
August 1, 2025 – Present
SQL Certification
Tutedude
July 1, 2025 – Present
Cultural Fit Analysis
The candidate's project diversity, covering grocery sales analytics and bank loan risk analysis, shows adaptability to different business domains. The ongoing Post Graduate Diploma in Data Science and multiple certifications (Google Data Analytics, Power BI, SQL, McKinsey Forward) highlight a strong commitment to continuous learning and professional development, which aligns well with a growth-oriented culture. The current role as a Business Operations Executive (MIS & Data) indicates a practical, results-oriented approach.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical and problem-solving skills, evidenced by their ability to identify key drivers and generate insights from data. Their experience in stakeholder communication and handling ad-hoc data requests suggests good operational fit for roles requiring interaction with business teams. The McKinsey Forward Program and Google Data Analytics Professional Certificate indicate a proactive attitude towards structured problem-solving and continuous learning.