Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic
GAURAV KANUNGO

GAURAV KANUNGO

PHOENIXVILLE,US

Summary

Gaurav has over 14+ years of consulting experience selling, managing and delivering large business transformation programs including designing and delivering SAP Technology and Analytics solutions. He has proven leadership in SAP Implementations, is highly accomplished and results driven executive. His area of expertise include program management, developing strategy & roadmap for Reporting & Analytics solutions, architecting client requirements into the best optimal reporting solution and environments, complemented with rigorous planning and successful delivery. He is a certified SAP BW consultant with strong experience in SAP HANA, SAP Analytics for Cloud, SAP ABAP CDS and SAP Business Objects. He is also a certified Agile and Scrum practioner. Gaurav has implemented multiple large scale BI reporting and Analytics projects and has experience with domestic and international clients including Germany, USA and India. He has also spent 1.5 years with Deloitte Germany serving some of the firm’s biggest auto clients. His industry experience includes Fin-tech, Pharmaceuticals, Food & Beverages, Retail and Utilities. Gaurav has led Analytics engagements with team sizes upto 35 and is well versed with Deloitte’s High-Tech consulting model. He has implemented projects with both Waterfall and Agile methodologies. Gaurav leads Deloitte's COE for SAP Datasphere , next gen of SAP Analytics. He has presented with client (C-suite) at almost all major SAP conferences including ASUG, SAP Insider, Sapphire, BI & Analytics and BI Insider. He has recieved awards such as Spotlight award for exceptional performance and Certificate of Achievement in Best Practice/ Innovation.

Overview

16
16
years of professional experience

Work History

Data & Analytics Lead - Consumer Industry

Deloitte
06.2021 - Current
  • Client is a leading bakery giant
  • Project: ERP+ Data and Analytics
  • As a Reporting and Analytics leader at Flower foods, I was responsible to implement a cohesive and long term Reporting strategy
  • Played an instrumental role in formalizing the Design and Requirement phase of the project and implemented Deloitte's flagship Analytics First model for the most critical Financial KPIs
  • Data & Analytics plays a pivotal role in connecting all functional workstreams as Reporting and Analytics is the key to measure the success of all other modules
  • Evaluated and helped Flower Foods finalize the key frontend and backend tools that balances their current budget and fulfills long term requirements
  • Led a highly productive onsite/offshore team of 35 to collect requirement for 200+ reports and prepare a strong SAP foundation for Management and Operational KPIs
  • Implemented the finalized requirements with Agile methodology using JIRA toolset
  • Additionally, finalized the path for future deployments with the client
  • Planned and executed 5 mock cutovers and planning the final cutover before Go-Live
  • Successfully went live and exit the 6-week hypercare with no major issues.

Data & Analytics Lead- Life Sciences

Deloitte
04.2020 - 05.2021
  • Client is a leading global healthcare and pharmaceutical giant
  • Project: Johnson & Johnson SigniFi Reporting and Analytics
  • Led the delivery for Master data and Hierarchies to support the overall Analytics reporting and planning solutions
  • Conceptualized the overall solution to deliver master data for reporting and planning applications including selection of tools
  • Managed the offshore-onsite SAP project scrum team of 10+
  • Architected the Analytics and Data solution to deliver master data
  • Presented the Analytics team in the Leadership and core team meetings
  • Managed and channelized various client business divisions and other project teams to make sure dependencies are taken care both upstream and downstream to achieve utmost productivity
  • Managed the hierarchies and master data lifecycle and optimizing business processes to minimize the duplication
  • Conceptualized and implemented a custom solution to deliver a web interface using UI5 to manage the self service of hierarchy creation and management directly by business process owners
  • Technical Environment: SAP S/4HANA, SAP HANA Enterprise, SAP BW4HANA, Tableau


Analytics Project Lead, Consumer Industry

Deloitte
03.2019 - 03.2020
  • Client is a major foodservice distributor in North America selling products such as meats, seafood, vegetables, condiments, cleaning supplies, and equipment to restaurants and other prepared food outlets
  • Project: Gordon Foods SAP ONE S/4 HANA Implementation
  • Overall Reporting & Analytics Lead responsible for design and deployment of 100+ Operational reports for US and CA covering Record to Report, Order to Cash, Procure to Pay for 500+users
  • Operational and Management Reporting Strategy
  • Leading requirement gathering workshops and designing SAP S/4HANA reporting solution based on CDS views and SAP FIORI
  • Conducting Workshops for Management Reporting and KPIs to consolidate and publish a ONE KPI definition model
  • Subject Matter Expert on Google Cloud Data Lake team instrumental in designing Management reporting solution and SAP integration to Data Lake
  • Managing Report testing in various ITC cycles and cutover activities to support Go-Live
  • Leading a diverse onsite/offshore technology team, conducting daily checkpoints and reporting weekly status to Deloitte/Client leadership, ensuring SLA compliance, monitoring/maintaining team cadence
  • Technical Environment: SAP S/4HANA, ABAP CDS, SAP HANA Enterprise, SAP FIORI, Google Cloud Platform


Project Manager, Consumer Industry

Deloitte
07.2018 - 02.2019
  • Client is member services company for large international coffee and donut chain having more than 8500 stores in USA and Canada
  • Project: National DCP SAP HANA Data Warehouse & Analytics
  • Modules Involved: SAP HANA 2.0, SAP BOBJ 4.2, SLT, SDI, Manhattan, SAP, directly responsible for design and delivery of a custom Data Warehouse solution to facilitate Business Analytics and Reporting
  • Managing Client Relationship and Project Finances
  • Managing the project scope and schedule
  • Preparing SAP HANA and Business Objects Solution Implementation strategy
  • Leading a diverse onsite/offshore technology team, conducting daily checkpoints and reporting weekly status to Deloitte/Client leadership
  • Preparing project plan, reviewing and finalizing architecture
  • Defining project roadmap and milestones
  • SAP Business Objects and Mobile Architect
  • Facilitating and Leading Business Requirement Workshops
  • Managing the Deloitte security team to assist the BOBJ-HANA implementation
  • Concluding the project to successful Go-Live and Business Rollout, facilitating transition to AMS
  • SAP Hybrid Agile Project Management

Reporting Architect and Lead, Financial Services

Deloitte
03.2017 - 06.2018
  • Client is a Germany based multinational Automotive-Financial services company
  • Project: Daimler Financial Services – Get One BI
  • DFS aims to implement a harmonized IT system (SAP Bank Analyzer) landscape for entire Europe
  • Module Involved: SAP HANA, SAP BOBJ 4.2, BW 7.3, and SAP Bank Analyzer
  • Leading the implementation for Management review dashboard for Sales and Controlling department
  • Part of the core HANA and Tools Infrastructure team primarily responsible for all Front End related topics
  • The team provides guidance to functional teams
  • Preparing reporting strategy and guide the project team on SAP Business Objects Front end reporting using tools like SAP Web intelligence, SAP Design Studio and SAP Analysis for Office
  • Design and development of SAP HANA Core Warehouse layer for a streamlined staging of basic HANA views to be utilized for Functional reporting
  • Design and development of SAP Design Studio (Lumira) dashboard for the client technical team related to ticketing system
  • Design and development of complex Web Intelligence solution for the Risk Instrument department
  • Coaching and quality assurance for development on SAP Business Objects

Reporting Architect, Financial Services

Deloitte
03.2016 - 01.2017
  • Client is a US based multinational e-commerce company
  • Project: A global Finance Transformation Project
  • Goal is to clarify finance processes and the language of data, drive end user enablement and personal accountability and execute for business outcomes that are targeted on boosting capabilities and fostering a progressive work environment
  • The mission is to build a one-source platform for entire reporting
  • The solution is based on a HANA environment, leveraging the SAP Bank Analyzer and a SAP BW with front end reporting through variety of tools
  • Currently business blueprint is in progress
  • Module Involved: SAP HANA Studio, SAP BOBJ 4.2, BW 7.3, and SAP Bank Analyzer
  • Key Responsibilities:
  • Lead the Blueprint phase with Requirement Gathering and Reporting Functional Specification development
  • Strategy to transform the current Excel based fragmented reporting solution into a HANA and Business Objects based consistent solution
  • Prepared the end to end report testing strategy and mapped Functional Test Scenarios to reports

BW - Business Objects Lead and Architect

SAP
07.2014 - 02.2016
  • Client is a well-known pharmaceutical giant with businesses across the globe
  • Project: SAP Business Objects 4.2 solutions and consulting
  • Module Involved: SAP BOBJ 4.1, BW 7.3, SAP ERP SD, MM, PP, FI-CO and SAP HANA
  • Key Responsibilities:
  • To lead a Deloitte team of 7 consultants (offshore/onsite) working on various SAP BW and SAP Business Objects projects across client departments
  • To prepare a Business Objects strategy around the right tool of choice for various reporting and dashboarding needs
  • Single point of contact in finance team for all the BO related issues, worked with SAP team to get resolutions for patch/upgrade related issues
  • Designed and implemented an innovative scheduler tool for the users to ease the report bursting process
  • To lead a team to develop Proof of Concepts using various BOBJ tools such as Design Studio, Xcelsius and Web Intelligence
  • To work with client team to create dashboard and visualization strategy for various analytics needs across departments
  • To do a comparative analysis for various dashboard tools available; specifically BO Design Studio, Lumira, BO Dashboards and Tableau
  • To work on a long term growth and delivery model for Deloitte
  • To create a strong confidence oriented relationship with client to sustain the current delivery and shoot for further growth of Deloitte team
  • To interview and grow our resource pool with best available Deloitte consultants
  • To help client prepare the system for upcoming SAP HANA deployment and consult on best practices

Analytics Consultant and Architect

Deloitte
06.2013 - 07.2014
  • Client is a well-known retailer of children’s clothing and accessories with business in US, Canada and countries.
  • Project: SAP ERP Implementation and Data Warehousing Implementation with SAP BW and Cognos.
  • To prepare a reporting strategy to drive the Blue Printing phase for the requirements.
  • To apply Deloitte’s EVD methodology to lay out a systematic approach towards various phases of the project and documentations to be delivered.
  • To attend the functional workshops, understand and take notes of critical facts about the reporting related facts and requirements.
  • Prepared Requirtement repository
  • Assisted the functional teams in writing of reporting related specifications.
  • Converted the functional specifications into data requirement specifications and eventually the technical specifications.
  • Led the development of SAP BW objects and handover the data to Cognos /DW system for further reporting and in some cases deliver the reports in SAP BW itself.
  • Led the testing cycles and manage all the defects raised and changes required.
  • Led the BW cutover activities (3 mock cutover, Dress Rehearsal and Final cutover)
  • Go-Live and post Go-Live hyper-care support.
  • Developed a strategy to merge the solution with a possible HANA implementation.

Analytics Consultant - Consumer Industry

Deloitte
09.2011 - 07.2013
  • Client: Heinz is a Food and Beverage client. It is world’s leading Ketchup and processed Foods Company and has several offices worldwide.
  • Project: ERP and Data warehousing implementation with Business Objects and SAP BW integration.
  • Created business and technical requirements documentation and developed solution designs for analytics implementation.
  • Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices.
  • Captured and documented customers' business and technical requirements.
  • Provided analytics domain expertise, consultation and troubleshooting internally and for customers.
  • · Designed and developed planning layouts for Trade and Promotions management.
  • · Led and designed the architecture for implementing Executive KPI dashboard with more than 60 high level organization KPIs.
  • Working with C-Suite executives to understand their Analytics pain points and stroy boarding their requirements

BW Functional Consultant, Consumer Industry

Deloitte
05.2011 - 09.2011
  • Is a retail and manufacturing client out of New York and has its operations in many countries including Canada and Brazil
  • Project: Blueprint and Functional Specs for Finance and Marketing Team
  • Module Involved: SAP-FI, CRM, SD
  • To understand the reporting requirements of the Finance and Marketing team and capture them in the form of functional specification document
  • To understand the requirements from BW point of view and make design documents to assist the realization phase
  • To discuss the master data model with functional consultants and prepare the design documents accordingly for BW considering all the important issues regarding the future requirements for the project
  • To educate the client counterparts regarding SAP BW and its implementation
  • To develop and design the reporting strategy

BW - Business Objects Consultant Utilities

Deloitte
11.2009 - 05.2011
  • (SCE) is an electric utility company, which provides electric services to central, coastal and southern California
  • Project: Implementation of SAP BO Web Intelligence reports for the Operations Support department of SCE
  • Module Involved: SAP-SCM, PM, Finance, SAP-BI, SAP Business Objects
  • To understand the reporting requirements of the Operations Support business unit and accurately capture them in the form of DRS (Data Requirement Specification) document
  • Designing the data model and development of BEx queries, Universe and Web Intelligence reports related to Supply Management and Accounts payable
  • Technical assessment of Business Object XI 3.X SP2/3 and upgrade
  • Analyzing the legacy system interface to fetch data into SAP BI
  • Participating in Go-Live cut over and Post Go-Live support activities
  • SAP BI and Business Objects maintenance related activities
  • Extensive testing for both back end and front end objects
  • Coordinating the Security role and QA/QM related activities
  • Technical Environment:, ,SAP BO Web Intelligence, Business Objects XI 3.1

SAP Consultant, Utilities

Deloitte
12.2008 - 11.2009
  • (SCE) is an electric utility company, which provides electric services to central, coastal and southern California
  • Project: Implementation of BO Xcelsius dashboards (WISER Executive Dashboards) and Web Intelligence reports (CRO- Capital Related Orders) for the TDBU department of SCE
  • Module Involved, -ECC, PM, SCM, Finance, SAP-BI, SAP Business Objects
  • To understand the Key Metrics of the Transmission and Distribution business unit and accurately capture them in the form of DRS (Data Requirement Specification) and DES (Data Element Specifications) documents
  • Designing the end to end template for the Xcelsius dashboard development
  • The template was used by the team to replicate into 18 dashboards
  • Designing the Business Objects and SAP connectivity model
  • Iterative approach while preparing mock dashboards and finalizing the template
  • To analyze the manual reports being used by the CRO section of TDBU and grouping them logically into high-level groups and subsequently designing the backend model for the same
  • Analyzing the Power Plant interface (Finance legacy system) to fetch data into SAP BI
  • Extensive testing for both back end and front end objects

System Engineer

Tata Consultancy Services
07.2007 - 11.2008
  • Client is a leading Cement manufacturer.
  • The scope was to implement BI 7.0, develop reports on information for various modules and provide end user training. Cross module, reporting and highly customized Logistics analysis reports were some of the key challenges.
  • Learning and acclimatizing the business processes of Client.
  • Presentation to client’s IT team and activation of Demo Cubes and Queries from Business Content for demonstration purpose.
  • Requirement Gathering for the BI Reports for, FI, CO, SD Logistics, and MM (which included Purchasing, Inventory, and Production Planning).
  • Preparing Blueprint for the BI 7.0 Implementation and Reports’ developments.
  • Project Documentation including user manuals, configuration documents, Training documents, support documents etc.
  • Development of customized reports, customized data sources and enhancement of LO Cockpit data sources.
  • Creation of Info Cubes, ODS Objects, Multi-providers, info-set, aggregates, Info Packages, Info Object Catalogue, Info Objects, Navigational attributes, Transfer rules, Update rules, Transformations, Data Marts, Business Content.
  • As part of Information Consumer Layer, designed; BEx Reports providing insight of Business Intelligence to Business Analysts for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Exception, Conditions, Cell Restriction, Filter and Variables.
  • ABAP coding for user exits, enhancement of data sources, etc.
  • Workbooks, User Authorizations, Unit and integration testing, Transportation Activities, Patch Application.

Education

B-Tech - Mechanical Engineering

Sardar Vallabhbhai National Institute Of Technology
Surat India
06.2007

Skills

  • Scrum Methodology
  • Project Planning Software
  • Architectural Design
  • SAP Implementation
  • Client Requirements
  • Visualization
  • Tableau
  • SAP Analytics for Cloud
  • SAP HANA cloud
  • AZURE Cloud
  • AWS Cloud
  • GCP Cloud
  • Data Lake
  • Analytics Architecture

Affiliations

  • ‘Net Weaver 2004s BI Solution Consultant’
  • Harvard Certification for Stepping up to management.
  • Harvard Certification for Leadership Transitions.
  • Agile/Scrum SAP Business Objects and SAP HANA. Internal training for SAP R/3, SAP BIW and Project Life cycles.
  • Training courses on Project Management, Analytical Ability, Team Skills, Business Communication, Technology Management and Quality Management. Six-sigma awareness training.
  • Training on Business Objects. CRM overview. IBM Websphere DataStage Essential v8 Publications White Paper on BI Inventory Management Data Loading. White Paper on BO Xcelsius Dashboard Template Creation.
  • Presentations : Presented on “Utilizing SAP Business Objects to help meet the return on investment of equipment over its entire life cycle” at ASUG fall focus 2010, Orlando. Presented on “SAP Experience app and HANA RDS” in SAP Insider Track New York and BI Insider in Las Vegas.
  • Foreign Language Skills Japanese- Elementary German - Basics

Timeline

Data & Analytics Lead - Consumer Industry

Deloitte
06.2021 - Current

Data & Analytics Lead- Life Sciences

Deloitte
04.2020 - 05.2021

Analytics Project Lead, Consumer Industry

Deloitte
03.2019 - 03.2020

Project Manager, Consumer Industry

Deloitte
07.2018 - 02.2019

Reporting Architect and Lead, Financial Services

Deloitte
03.2017 - 06.2018

Reporting Architect, Financial Services

Deloitte
03.2016 - 01.2017

BW - Business Objects Lead and Architect

SAP
07.2014 - 02.2016

Analytics Consultant and Architect

Deloitte
06.2013 - 07.2014

Analytics Consultant - Consumer Industry

Deloitte
09.2011 - 07.2013

BW Functional Consultant, Consumer Industry

Deloitte
05.2011 - 09.2011

BW - Business Objects Consultant Utilities

Deloitte
11.2009 - 05.2011

SAP Consultant, Utilities

Deloitte
12.2008 - 11.2009

System Engineer

Tata Consultancy Services
07.2007 - 11.2008

B-Tech - Mechanical Engineering

Sardar Vallabhbhai National Institute Of Technology

Similar Profiles

CREATE PROFILE
GAURAV KANUNGO