<ul><li>Advanced Excel.</li><li>Excel for analyzing Data and Problem Solving.</li><li>Building Dashboard for better Understanding and Analysis using Excel.</li></ul>

Spreadsheet

<ul><li>Completed a practical job simulation involving data quality assessment, analysis, and visualization.</li><li>Interpreted datasets to answer key business questions and produced clear, strategic insights for client presentations.</li></ul>

Data Analytics Job Simulation

Master of Arts

Political Sciences

Bachelor of Science

Mathematics

<ul><li>Engineered interactive Excel dashboards to monitor program impact metrics and KPIs, empowering NGO stakeholders to drive data-informed strategies for core employability initiatives.</li><li>Evaluated the overall operational performance of regional training centers by analyzing complex datasets, uncovering critical trends that supported leadership in optimizing educational delivery.</li><li>Spearheaded year-over-year performance tracking by structuring longitudinal data, providing management with clear, actionable insights to assess long-term training effectiveness and organizational growth.</li></ul>

Data Science & Analytics

Data Analyst

<ul><li>Managed the end-to-end data tracking for daily customer battery allocations within the mobility network, maintaining strict database normalization standards to ensure 100% real-time visibility into asset distribution.</li><li>Audited and reconciled complex inventory discrepancies by cross-referencing multiple data sources, successfully tracking down nearly 85%+ missing batteries over a two week period tracking and minimizing physical asset loss for the company.</li><li>Automated daily reporting on battery swapping and rotation metrics using Advanced Excel, delivering high-fidelity performance dashboards to accelerate management's strategic decision-making.</li><li>Streamlined operational workflows by transforming fragmented field reports into structured, centralized data, significantly reducing manual tracking time and improving the accuracy of the asset lifecycle.</li></ul>

Jiwaji University, Gwalior

India

Detail-oriented Data Analyst with active internship experience driving KPI reporting and operational efficiency. Proficient in MySQL, Advanced Excel, and Power BI, with a proven ability to apply rigorous analytical thinking to complex datasets. Passionate about leveraging business intelligence tools to streamline workflows and deliver actionable strategic insights.

<ul><li>Architected an interactive Bank CRM dashboard in Power BI analyzing 10,000+ customer records via SQL and Excel, establishing a baseline 20.37% churn rate to guide targeted retention initiatives.</li><li>Spearheaded geographic and demographic churn analysis, pinpointing France as the highest attrition risk (800 exits) while identifying Germany as the highest-value market with a $120K average balance.</li><li>Diagnosed critical customer lifecycle friction points by analyzing four years of historical trends, identifying maximum churn risk during years 4 and 5 of tenure to drive early-intervention strategies.</li><li>Evaluated product engagement metrics across the database, revealing a 70.5% credit card adoption rate to help stakeholders formulate personalized cross-selling campaigns for the remaining 2,950 un-carded customers.</li></ul>

Bank CRM 

<ul><li>Data Cleaning &amp; Preparation: Cleansed and validated extensive relational datasets utilizing MySQL window functions and CTEs to eliminate duplicates, establishing a high-integrity data foundation for customer churn analysis.</li><li>Churn and Risk Profiling: Leveraged SQL window functions and CTEs to track monthly customer churn rates, identifying high-risk geographic segments likely to reduce spending.</li><li>Global Sales Performance: Analyzed regional revenue streams to rank top-selling genres globally and pinpointed top customers by total revenue across different countries.</li></ul>

Chinook Music Store

<ul><li>Conducted in-depth analysis of an IT support ticket management system using Excel to evaluate agent performance and identify areas for improvement.</li><li>Utilized advanced Excel functions e.g., string functions, DATEIF, aggregation, LOOKUP for data cleaning, extraction, and analysis of key metrics, such as resolution time and satisfaction rate.</li><li>Created pivot tables, charts, and dashboards to visualize trends in ticket volume, issue categories, and agent performance, driving recommendations for software upgrades and agent training.</li></ul>

Ankit Yadav

Social Accounts

Achievements

Projects

Bank CRM

Chinook Music Store

IT Ticket Analysis

Experience

Data Analyst

Data Analyst

Education

IGNOU Delhi

Jiwaji University

Certificates

Spreadsheet

Data Analytics Job Simulation

Skills