Shruti Dubey
Mumbai, Maharashtra|+918779707828 |dubeyshruti71@gmail.com |LinkedIn |GitHub|
Data Analyst with 1.4 years of experience in data validation, reporting, and dashboarding using SQL, Power BI, Excel, and Python.
Skilled at collaborating with stakeholders and cross-functional teams to transform business needs into actionable insights. Proven
ability to deliver scalable data solutions, ensure data integrity, and drive operational performance through data-driven
recommendations.
PROFESSIONAL EXPERIENCE
Quess Corp Ltd| | Data Analyst (MIS Executive) | May,2024 – Present
Automated daily, weekly & monthly dashboards in Power BI and Excel, giving leadership real-time visibility into acquisition
funnels, hiring velocity, and ROI per sourcing channel, reducing report turnaround time by 30% and enabling real-time
visibility for 5 regional teams.
Built DAX driven KPIs to track drop-offs, cost-per-joiner, and offer-to-payroll conversions, improving partner onboarding
success by 12%.
Collaborated with regional and HR leads to validate data pipelines across geographies, ensuring consistent and accurate
reporting.
Introduced 3 new business KPIs and visualization layouts, accelerating leadership decision-making by 20%.
Accenture Virtual Case Experience |Data Analyst Intern | Dec,2024 – Jan,2025
Analyzed 7 datasets in Excel & Power BI to identify content engagement trends, strengthening recommendations by 25%.
Delivered and presented a client-ready deck, improving clarity and influencing strategy decisions.
Tata Group Virtual Case Experience | Data Analyst Intern | Jan,2024 – Feb,2024
Cleaned and modeled 100K+ retail rows with Power Query, reducing errors by 20%.
Identified top revenue drivers, presenting actionable insights that informed senior management’s planning.
PROJECTS
Hotel Sales Analysis (SQL |Power BI| DAX) GitHub Repo
Built a dynamic dashboard analyzing hotel partner performance, revenue drivers, and repeat customers. Delivered business-
aligned KPIs through SQL queries and DAX modeling to support executive decisions.
HR Analytics Dashboard (Excel |Pivot Table| Power Query) Live Dashboard
Created a real-time HR dashboard for visualizing recruitment funnel metrics and workforce demographics. Automated data
cleaning, reduced manual reporting effort by 60%, and highlighted performance segments to assist leadership hiring strategies.
Retail Sales Analysis (Python | Pandas | Matplotlib | Seaborn) GitHub Repo
Conducted EDA on festive retail sales to identify high-converting customer segments and visualize revenue patterns. Used
Python libraries to generate insight-rich visualizations and trend summaries.
BFSI Hiring Dashboard (Power BI, Excel, Python) – Ongoing
Designing an executive level dashboard to visualize 3 month hiring trends, recruiter performance, zone wise hiring, and client
conversion rates. Using DAX and Power Query to create interactive insights and track monthly offer vs payroll conversions,
supporting leadership in hiring decisions across BFSI clients
SKILLS
Data Analysis & Reporting: Power BI, Advanced Excel, SQL, Power Query, Data Validation, DAX, Statistical Analysis, Data-driven
Insights, Ad-hoc reporting, Hypothesis Testing.
Data Management: EDA, Data Cleaning, Data Modeling, MySQL, Microsoft SQL Server, Data Wrangling.
Programming & Automation: Python (pandas, matplotlib, seaborn), Optimization Techniques, Logic Building, Reporting Script.
Data Visualization: Power BI, KPI Tracking, Visual Storytelling, Interactive Reporting, Multiple Dashboard Creation.
Soft Skills: Analytical Skills, Problem Solving, Collaboration, Team Player, Stakeholder Communication, Business Consulting.
EDUCATION
University of Mumbai |Bachelor’s in Computer Engineering |CGPA:8.35| Feb’21 May’23
Babasaheb Gawde Institute of Technology, Mumbai | Diploma in Computer Engineering |90.20%| Jun’17 Feb’20
CERTIFICATIONS
• Google Data Analytics Professional Certificate (Google, Coursera)
• Zero to hero in Microsoft Excel: Complete Excel guide (Udemy)
• SQL - MySQL for Data Analytics and Business Intelligence (Udemy)
• Statistics for Business Analytics using MS Excel (Udemy).
RELEVANT COURSEWORK
• Business Statistics • Python for Data Analysis • Data Science • Data Analysis • Exploratory Data Analysis (EDA) •
Introduction to Machine Learning • SQL & Database Management Systems (DBMS) • Hypothesis Testing • MIS Reporting &
Automation • PPT Reporting • Predictive Modeling • A/B Testing
LANGUAGES
• English (Fluent) • Hindi (Native) • Marathi (Native)
