Resume

Sign in

Business Intelligence Consultant

Location:
Mumbai, Maharashtra, India
Posted:
December 29, 2019

Contact this candidate

Resume:

DIMPLE WAGHELA +91-720*-****-**

ada54z@r.postjobfree.com

SUMMARY

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

WORK EXPERIENCE

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

Capgemini

Rewards and Recognitions

Client nominated Excellence award Mar19 – Apr19

Recommended by the manager – Extra Milestone Award Jan19 – Apr19

Fractal Analytics

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

OTHER ACTIVITIES

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

EDUCATION

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

PERSONAL DETAILS

Location: Mumbai

DOB: 14/04/1989

Passport: M2732391

Marital Status: Unmarried

Hobbies: Cooking, Travelling and Listening to Music.



Contact this candidate