Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Sneha Dutta

Dhanbad

Summary

Results-driven Executive Analyst at Coffee Day Global Limited with expertise in Power BI and data visualization. Successfully developed real-time dashboards that enhanced business performance visibility, optimizing report loading times by 20%. Adept at cross-team collaboration and analytical thinking, delivering impactful insights that drive strategic decision-making.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Executive Analyst

Coffee Day Global Limited
Banglore
01.2023 - 03.2025
  • Developed and maintained a real-time CEO dashboard providing daily updates on key sales metrics, including net sales, AQPD (Average Quantity Per Day), ASPD (Average Sales Price Per Day), QPD (Quantity Per Day), and SPD (Sales Price Per Day), enabling immediate visibility into business performance.
  • Ensured timely and accurate updates of daily and monthly dashboards, maintaining data integrity, and providing real-time visibility into business performance.
  • Analyzed data from diverse sources to deliver actionable analytical information to management, supporting strategic planning and business growth.
  • Developed and maintained a camera analytics system to provide daily reports to the CEO on customer demographics (new/returning), sales, and unique customer counts for CCD cafes.
  • Designed and implemented interactive Power BI reports and dashboards for CCD cafes, providing key performance indicators (KPIs), and actionable insights to management.
  • Extracted, transformed, and loaded (ETL) data from diverse sources, including SQL Server and Excel, to populate reporting databases, and ensure data accuracy.
  • Collaborated with cross-functional teams (sales, marketing, operations) to understand their reporting needs, and deliver data-driven solutions that support business objectives.
  • Optimized Power BI data models and DAX queries, resulting in a 20% reduction in report loading time, and improved user experience.
  • Created a suite of reports and dashboards for the sales and marketing teams, providing insights into customer behavior, sales trends, and marketing campaign effectiveness.

Associate System Engineer

Xilontech Solution Pvt Ltd
Hyderabad
08.2021 - 12.2022
  • Created comprehensive sales, inventory, trial balance, and financial reports, and dashboards, enabling data-driven decision-making across the organization.
  • Provided data-driven insights and analytical support to key clients, including Ezone, Trimex, Darshan, Hikoki, Protiviti, Robert Bosch, and Thalappakatti, contributing to their business success.
  • Developed and maintained a daily mobile app analytics dashboard for management, providing key insights into app trends, downloads, registrations, and user demographics by OS system.
  • Created BI Reports like Creating Sales Report, OBCB Report, GRN Details and Calculating consumption on the basis of BOM items.

Education

B-Tech - CSE

K.K College of Engineering And Management
Dhanbad
07-2021

Skills

  • Power BI and Dax Proficiency
  • Excel, Google analytics
  • SQL, SharePoint, Azure, D365 & AX
  • Data Modeling
  • Query writing to extract and pull data for analysis
  • ETL processes
  • Cross-team collaboration
  • Data visualization
  • Customer analytics
  • Dashboard development
  • Ability to work independently and within a team structure, consistently delivering flawless work solutions within aggressive, and changing, time constraints
  • Analytical thinking

Certification

  • NPTEL Certificate on IOT

Timeline

Executive Analyst

Coffee Day Global Limited
01.2023 - 03.2025

Associate System Engineer

Xilontech Solution Pvt Ltd
08.2021 - 12.2022

B-Tech - CSE

K.K College of Engineering And Management
Sneha Dutta