Smiriti Mittal

As a Senior Consultant at Ernst & Young, I deliver data-driven solutions to optimize business strategies, improve efficiency, and automate reporting using tools like SQL, Python, Tableau, and Power BI. I collaborate with stakeholders to turn complex data into actionable insights, aligning business goals with technical execution.

Key Responsibilities:

• Data-Driven Business Strategy: Spearhead data analytics and reporting efforts for a wide range of clients, advising on business strategies, sales performance, and IT solutions to drive data-informed decision-making across diverse sectors, including banking and finance.
• KPI Development & Monitoring: Define, implement, and monitor KPIs to assess and track business success, identify emerging trends, and recommend data-driven improvements in operational and strategic initiatives.
• Advanced Analytics & Tool Utilization: Leverage industry-leading tools (SQL, Python, ETL, Tableau, Power BI) to manage data extraction, transformation, and visualization, providing actionable insights that support client business goals.
• Automation of Reporting: Lead the end-to-end automation of client reporting processes using Tableau and other business intelligence tools, improving accuracy and operational efficiency.
• Stakeholder Collaboration: Work closely with senior stakeholders, collaborating to bridge the gap between business and technology teams, translating complex data into clear, actionable business insights and recommendations.

Key Achievements:

• Kudos FY22 Q4 Award: Recognized for delivering exceptional value to clients by optimizing data infrastructure, enabling improved reporting capabilities, and enhancing analytics strategies.
• Optimized Client Data Infrastructure: Led efforts to redesign and optimize clients’ data warehousing, reporting systems, and analytics frameworks, driving business process improvements and performance efficiencies.
• Reusability and Efficiency Gains: Developed reusable models and code that improved data processing and reporting efficiency, enabling quicker decision-making and increased client satisfaction.
• Impactful Insights for Strategic Decisions: Delivered high-impact data insights that directly informed critical business decisions for clients, leading to optimized resource allocation, cost savings, and improved market positioning.

As the lead of the Data Analytics team, I supported strategy and client servicing teams with customer insights, campaign management, feedback mechanisms, and NPS calculation for apparel and footwear brand accounts.

Key Responsibilities:

• Analyzed CRM campaign effectiveness using SQL and Power BI to provide actionable insights for trade and seasonal planning.
• Utilized Python and SQL to develop customer segmentation models and manage data warehousing solutions.
• Developed a sentiment analysis engine for BATA India Ltd. using Python, categorizing NPS feedback for stores globally.
• Created performance measurement tools (Store Panel/Adin Panel) in Power BI with tailored views for different management levels.
• Designed brand-specific KPI dashboards for clients such as Fabindia, Bata, PVR, and Vmart using Tableau.

Key Achievements:

• Star Performer (2019): Recognized for exceptional contributions to client success and team performance.
• Supported Bata's CSR initiative to reduce paper bag usage through a loyalty point-based rewards program, promoting sustainable practices.
• Achieved 2X sales for FabIndia during the festive season through targeted segmentation.
• Developed a WhatsApp bot-based solution (Shopster) using Elasticsearch and Python for inventory management, enhancing product tracking and driving revenue growth.

Supported credit checks and trade analysis across the front, middle, and back office, leveraging Tableau, Python, and SQL for risk assessment and data-driven insights.

Key Responsibilities:

• Performed credit checks for trades using Tableau and Python, supporting risk and compliance monitoring.
• Analyzed intraday deals and published insights through Tableau dashboards to assist decision-making.
• Assisted the onshore team in data identification, testing, and implementing solutions for process optimization.
• Worked with complex SQL queries and database procedures to implement system enhancements.

Key Achievements:

• Best Team Award (Q4 2017) for exceptional team performance.
• Shining Star Award (2 consecutive years) for consistent excellence in analysis and project delivery.
• Gold Award from CACIB, Paris for outstanding contributions.

Key Responsibilities:

• Designed and prototyped new features for the core product.
• Presented designs to stakeholders and conducted usability testing.
• Developed responsive web interfaces using JavaScript, Bootstrap, jQuery, HTML, and CSS.