DIMPLE WAGHELA +91-720*-****-**
Proven ability to formulate and develop solutions to business problems using technical tools. Excellent interpersonal skills. Competent in forging and maintaining strong client relationships. Close to 7.9 years of experience in areas such as Key business drivers forecasting, Project management and Consulting for Fortune 500 CPG/FMCG/Oil and Gas
Industry Expertise: CPG, Retail, Consumer Insights, Oil and Gas Insights
Technical Tools: Scrum(VSTS), Advanced Excel, VBA, Alteryx, Knime, R, SQL, Azure ADF, SSDT, MSBI tools like SSRS, SSIS and SSAS
Visualization Tools: Spotfire, Power BI, Tableau
Capgemini Mumbai, India;
Analytics Senior Consultant (Lead) and Scrum Master Nov18 – Present
Oil and Gas Insights
Responsible for consulting with Product Owner in migrating while revamping existing Data Model to Azure Cloud.
Create Data Model in Azure ADF with end to end ETL and Automation to trigger Pipelines and process Data Model
Create Power BI dashboards based on Tabular Data Model to answer Business Questions
Conduct Review meeting with Scrum ceremonies like Retrospective, Sprint Review and Sprint Planning
Mentor and train team members to achieve the Sprint Goals in stipulated timeline
Fractal Analytics Mumbai, India;
Analytics Consultant Mar17 – Nov18
Retailer Analytics and Insights
Lead Analyst responsible for end to end project delivery for a major CPG client in Consumer Market domain handling 5 major apps for Asia (120 Country-Categories). Nurturing diverse views and rallying the team towards focused outcomes.
Build ‘Features Scorecard Optimization’ tool – a project to qualitatively decode product coupons/circulars/booklets distributed in the different retailer stores in Asia to gauge activity ROI on business. Solution has high scaling potential across different CPG categories for the client.
Periodically conduct project review meetings with senior clients/stakeholders to understand the business needs and accordingly plan our roadmap ahead.
Demonstrating solutions and techniques that can be re-applied across categories/regions, with client as well as internal teams.
Analyse scope of new projects by engaging with clients and assess requirement vs. resource availability and measure efficiency of existing projects.
Mentoring Fractalites and recognised as a go to person for a broad range of technical skills and problem-solving skills
Conduct assessments and propose improvements to methods, systems and procedures in areas such as operations, records management and communications.
Developed end to end algorithm in knime to determine the promotion effectiveness drivers. (Display/Catalogue/Sales fundamental) for a promotional event.
Analyzed retail, inventory, promotion, sales fundamental, and shopper data to finalize the drivers. Solution well received by business and is now being scaled to Asia Markets
Highly Restricted App Development: developed multiple dashboard for Major CPG clients viz:
1.Incident Management Dashboard
2.Enterprise Risk Monitoring Dashboard
3.Product Supply Scorecard
Senior Business Analyst – Multiple Engagements Jul15 – Feb17
Consumption Forecast & Trade Insights App : Managed a team of 5 Analysts to deliver monthly drumbeat with Insights on What-if scenarios for the business analysts, team leaders, brand managers
Built a model named Anti-Diversion Tool to track the real time diversion of CPG Manufacturer and provide routine checks and predict for deceptive distributors
Developed multiple Dashboards in Excel-VBA, Spotfire and HTML which provide Insights on Shipment, Demand Generation and Consumption across all the stores of one of the largest food retailers in the US
Created ‘Normative Forecasting’ tool to help Demand Generations team and Brand Managers to prepare for new product launch and initiatives
Business Analyst – Multiple Engagements Oct13 – Jun15
Asia BI Database – One stop-shop homogenous database; researched, created and maintained at Fractal. Owned end-to-end administration of set up (Windows server 2008 +SQL Set up and development
Designed Real-time dashboards using Asia BI Database to track change in growth by automated alerts shared with the Business Executive team and Brand Managers.
Total Trade Inventory App and Pages: Understand campaign effectiveness for client brands using Retail data and Shipments data. Identify cumulative inventory and create automated flags of insights in spotfire for the Demand Planners and Business Analyst
Asia Business Newsletters for the CPG client was published on monthly basis with quick recommendations.
Data Analyst – Mar12 – Sep13
Database Administrator on Japan SMO, Database Management and Development for Major CPG client
Designed, developed & stabilized real time, dynamic, web-based business review tools that help understand state of business on a weekly & monthly basis to help Japan President facilitate decision making
Filled in for client’s role from May 2012 – December 2012 and transitioned the database management to the incoming BA
REWARDS AND RECOGNITION
Rewards and Recognitions
Client nominated Excellence award Mar19 – Apr19
Recommended by the manager – Extra Milestone Award Jan19 – Apr19
Rewards and Recognitions – STAR Award
Client nominated Excellence award Apr15 – Oct15
Recommended by the manager for Going Above & Beyond Oct15 – Apr16
Recommended by the manager for Collaboration Oct16 – Mar17
Star Performer Leader award Oct17 – Apr18
Faculty, Fractal Academy of Analytics
Conducted Effective SQL 101 & 201 trainings and ‘Complete Client Engagement’ sessions across Fractal.
Trained 30 member CMK team on databases, vendor tools in Fractal
Active member of BreakFree team: Sports and Cultural event team of Fractal
Volunteer of BAPS Swaminarayan Sanstha
Mumbai University (MU) Mumbai, India
Bachelors of Science in Information Technology July 2013
All India Council for Technical Education (AICTE) Mumbai, India
Diploma in Information Technology July 2009
Marital Status: Unmarried
Hobbies: Cooking, Travelling and Listening to Music.