Back to Developers
shital auti

shital auti

Data Analyst

Pune 2+ yrs exp 85 · Excellent

About

Results-driven Data Analyst with 3 years of experience in Operations Analytics, Business Intelligence, and end-to-end KPI dashboard development across IT services and EdTech domains. Proficient in Power BI, Advanced Excel, Power Query, DAX, Python, R, and MySQL, with demonstrated expertise in ETL pipeline engineering, star-schema data modeling, data cleaning, normalization, and multi-source data consolidation. Proven track record of collaborating with cross-functional stakeholders to translate business requirements into scalable, visualization-ready data models — reducing manual reporting effort by 30% and improving executive decision-making speed. Eager to contribute analytical expertise and data-driven problem-solving capabilities to a high-impact Data Analyst or Business Intelligence role in a growth-oriented organization.

Skills & Expertise (15)

Power BI Advanced
8.6/10
3
Years Exp
Data Cleaning Advanced
8.0/10
3
Years Exp
Excel Advanced
7.8/10
3
Years Exp
Python Tableau MySql Pandas NumPy Jupyter Notebooks Anaconda Power Query DAX Data Modeling Data Consolidation KPI Dashboard Development

Work Experience

Packaged Application Development Associate

Accenture

Mar 2024 - Feb 2026

Spearheaded end-to-end Operations Analytics engagement for Calsoft, transforming Excel-based static reporting into scalable Power BI dashboards driving executive decision-making. Engineered automated ETL pipelines using Power Query, consolidating data from multiple Excel sources, reducing manual reporting effort by 30%. Designed and deployed executive-level KPI dashboards in Power BI tracking TAT, SLA Compliance, Utilization Rate, and Productivity per resource. Implemented DAX-based calculated measures and dynamic parameters, enabling real-time KPI threshold monitoring and trend analysis across monthly/quarterly cycles. Migrated legacy Excel static dashboards to Power BI, enabling automated data refresh, improving reporting accuracy and scalability across operations. Conducted data validation and UAT testing on Power BI dashboards, cross-verifying KPI outputs against source Excel data ensuring 100% reporting accuracy before stakeholder delivery. Authored technical documentation including data dictionaries, transformation logic, and dashboard user guides ensuring governance, knowledge transfer, and audit-readiness across reporting workflows. Applied data cleaning and normalization techniques in Power Query — resolving nulls, duplicates, and schema inconsistencies across multi-source operational datasets. Built drill-down dashboards with slicers, filters, and KPI scorecards, reducing executive reporting turnaround time by 40%. Optimized Power BI data models by removing redundant columns and applying star-schema design, enhancing query performance on large Excel datasets. Standardized disparate data schemas using Power Query transformations (pivot, merge, append), improving data reliability and consistency by 25%. Collaborated with operations leadership to define KPI frameworks, translating business requirements into actionable, visualization-ready data models. Delivered end-to-end analytics ownership — from raw data ingestion and transformation to interactive dashboard deployment and stakeholder reporting.

Data Operator

Rubicon Skill Development Pvt. Ltd.

May 2023 - Feb 2024

Spearheaded end-to-end student placement data analysis for CampusEdge, evaluating soft skills training effectiveness using Advanced Excel and Power BI. Consolidated multi-source student datasets — attendance records, placement details, company categories, and package data — using Advanced Excel transformations. Performed data cleaning and validation in Advanced Excel, resolving inconsistencies across attendance and placement records for multiple graduating student cohorts. Designed interactive Power BI dashboards visualizing placement rates, salary packages, company-wise hiring trends, and sector distribution across industries. Conducted training impact analysis by correlating attendance rates with placement outcomes, identifying key drivers of student employability and program success. Tracked placement KPIs — placement rate, average package offered, company category mix, and attendance compliance — improving reporting accuracy by 25%. Generated data-driven insights revealing 35% higher placement rates among students who completed soft skills training, validating program ROI for stakeholders. Delivered executive-level placement reports with dynamic slicers and drill-down filters, reducing leadership reporting turnaround time by 40%.

Education

M. Sc. Mathematics - Modern college of Arts, Science and Commerce Shivajinagar

- 2022 · Afghanistan

B. Sc. Mathematics - Sir Parshuram Bhau College Pune

- 2020 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 10/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMay 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation