Ashmita Singh

Results-driven Data Analyst with over 10 years of experience transforming complex datasets into clear, actionable business strategies across e-commerce, fin-tech, and tech industries. Proven expertise in building scalable data pipelines, writing highly optimized SQL queries, and designing interactive Power BI dashboards that drive leadership decision-making. Adept at managing cross-functional stakeholders, driving operational efficiencies, and translating technical insights into measurable business impact.

Specialist at Google (Operations) (2023-10 – Present)

• Executive Dashboarding: Developed a suite of 8 enterprise-level Power BI dashboards using advanced DAX functions, giving leadership real-time visibility into sales funnels and reducing weekly reporting turnaround time by 45%.
• Process Automation: Spearheaded the migration of legacy Excel-based operational reports into fully automated Power BI data models, saving the operations team 20 hours of manual work per week.
• Business Impact: Formulated a predictive customer retention model using SQL window functions, identifying a major revenue leakage point and directly influencing a campaign that recovered ₹15 Lakhs in annual revenue.

Senior Associate at Google (Operations) (2020-11 – 2023-09)

Senior Business Associate at Accenture Solutions Pvt. Ltd. (2017-06 – 2020-11)

• Database Optimization: Rewrote and optimized complex, multi-table SQL queries, reducing database load times by 35% and accelerating daily ETL data pipelines for high-volume transactional data.
• Data Quality Assurance: Established data validation protocols within Power Query and SQL to clean unstructured data across 5 distinct business units, improving data integrity by 28%.
• Ad-Hoc Analysis: Conducted deep-dive ad-hoc financial analysis using Advanced Excel to support leadership during annual budget planning, identifying ₹5 Lakhs in redundant operational costs.

Research Analyst at High Beam Global Pvt. Ltd. (2016-08 – 2017-06)

• Cross-Functional Reporting: Partnered with Marketing and Sales teams to track and analyze KPI metrics for digital campaigns, managing data arrays exceeding 1M+ rows in Excel using Pivot Tables and Power Pivot.
• BI Implementation: Assisted in the corporate rollout of Power BI, training a team of 15+ non-technical business users on how to interact with self-service reporting tools.
• Insight Delivery: Analyzed supply chain logistics data via SQL, uncovering structural bottlenecks that, once resolved, reduced pan-India product delivery turnaround time (TAT) by 15%.

Data Analyst at Selling Simplified Pvt. Ltd. (2014-11 – 2016-02)

• Data Collection & Cleaning: Extracted daily transactional data from relational databases using fundamental SQL queries (Joins, Group By, Filtering) and prepared daily MIS reports.
• Report Generation: Maintained and updated standard Excel reporting templates and trackers for regional managers, ensuring 100% on-time delivery of baseline business metrics.
• Documentation: Documented data dictionaries and standard operating procedures (SOPs) for the analytics team's daily data extraction processes.

PGDM in Marketing and International Business – Delhi (2014)

Bachelor of Technology in Computer Science Engineering – MDU University (2012)