Aparna Shrivastava
● Open to Work

Aparna Shrivastava

Data Analyst | Business Intelligence Developer | SQL & Python | Power BI | Generative AI
Bhopal, Madhya Pradesh, India

About Me

Data Analyst with hands-on experience across three internships, building SQL- and Python-driven analyses and Power BI dashboards that support business decisions. Comfortable owning a dataset from raw extraction through stakeholder-ready reporting, with a track record of cutting manual reporting effort (30%) and reducing ad hoc data requests (25%) through dashboard automation.

Skills & Technologies

SQLPythonPower BIDAXData ModelingDrill-ThroughsKPI CardsReport AutomationTableauETL PipelinesData WarehousingPower QueryRDBMSAdvanced ExcelPivot TablesVBA MacrosData CleaningData TransformationPrompt EngineeringGoogle Cloud Gen AI FundamentalsGitJupyter NotebookGoogle ColabExploratory Data AnalysisStatistical AnalysisPredictive AnalyticsKPI TrackingA/B TestingRoot Cause AnalysisRequirements GatheringData StorytellingBusiness ReportingStakeholder CommunicationProblem-SolvingCritical ThinkingAttention to DetailDeloitte Data Analytics Job SimulationHP Data Analytics CertificationData Analytics Certification - CloudyMLIntroduction to Generative AI - Google CloudMicrosoft Excel with AI - Skill Course

Work Experience

Data Analyst Intern

CloudyML
Apr 2026Jun 2026

Cleaned, transformed, and analyzed multiple business datasets using Python and SQL, preparing data for reporting across retail transactions. Engineered 5+ analytical features and built 10+ visualizations to uncover performance patterns, informing customer segmentation strategy. Synthesized 15+ data-backed insights into stakeholder-ready recommendations.

Data Analyst Intern

Elevate Labs
Aug 2025Sep 2025

Designed and deployed multi-page Power BI dashboards with DAX measures, providing senior managers real-time visibility into sales and operational KPIs. Extracted and analyzed large-scale datasets using SQL and Python, uncovering performance trends that informed strategic initiatives. Streamlined recurring Power BI reports and Power Query transformations, improving data accuracy and reducing ad hoc data requests by 25%.

Data Analyst Intern

Future Interns
Jun 2025Jul 2025

Ran end-to-end exploratory data analysis in Python and SQL on business performance data, uncovering a regional demand gap. Built Power BI dashboards adopted by 10+ stakeholders to track weekly performance metrics, improving visibility into business health. Automated recurring Excel and Power BI reports, cutting manual reporting time by 30%.

Projects

Ola Driver Attrition Analysis

Analyzed 19,104 records across 2,381 drivers and 29 cities using Python-based exploratory data analysis, identifying an overall 8.46% attrition rate. Delivered recommendations to improve retention and operational performance.

PythonPandasNumPyMatplotlib+1

Superstore Sales Dashboard

Built a multi-page Power BI dashboard analyzing $2.3M+ in sales across 793 customers and 38K+ units sold. Developed YoY DAX measures revealing 32% profit growth and optimized SQL queries to improve load speed by 50%.

SQLPower BIDAXPower Query

Credit Risk Analysis Dashboard

Analyzed borrower and loan data to identify credit-risk drivers, revealing an overall ~21% loan default rate. Developed a custom Risk Score to segment borrowers into Low, Medium, and High Risk.

Power BIDAXPower Query

Medical Insurance Cost Analysis

Analyzed 1,338 insurance records to identify healthcare cost drivers. Built an interactive dashboard comparing medical costs across various categories.

Microsoft ExcelPivot TablesStatistical Analysis

Education

PGDM in Financial Management

MITSDE, Pune2025 - 2027

Master of Arts, Economics

Economics

DAVV, Indore2020 - 2022

Bachelor of Arts (Hons.), Economics

Economics

Bhopal School of Social Sciences2017 - 2020
Aparna Shrivastava - Data Analyst | Business | HiringAnt