Data Analyst with Multi-Tool Experience

Mahip Mehta

SAP BI/BW, Power BI, Data Analytics Consultant

Email – *****.*****@*****.***

Phone - +91-999*******

I. Professional Summary

Total 10+ years of experience as Data Analytics Consultant - SAP BI with expertise in following:

SAP BO 4.1 to 4.3 Migration

Implemented and Supported SAP BPC on SAP BI 7.x

Designed complex Finance Reports like Cash Flow, Profit & Loss Report and other Costing and Budgeting reports

Successful implementation & support of SAP BI-IP (Integrated Planning)

Designed Input Queries using Fox Formula in SAP BI-IP

Raw Material Consumption Planning

Sales and Purchase Planning

Finance Planning

Planning P&L

Data Analysis through S4 HANA CDS Views of simple and complex requirements for Multiple Reports and Dashboards and exposed it to BICS Connection to be used in Lumira or Design Studio & Power BI

Trained Key User on How to use Power BI and SAP BO

Also worked on multiple PoCs on Power BI

Connecting SAP HANA with Power BI

Using Different visuals to make a Story in Power BI and SAP BO

Embedded Power BI Reports, Scheduling and Configuring Data Gateway, Publication

Suggest, Strategies and Executed the road map of Implementing SAP BO 4.2 SP5 and SAP Lumira 1.31 on SAP HANA BICS Connection

Constant interaction with the Management Team and end users

Requirement understanding and defining the Scope of Work

Data Visualization through SAP Lumira 1.31

Requirement understanding and defining the Scope of Work

Designing Visualizations through Java based Proprietary tool - Elegant JBI and Data Modeling on SQL

Customer/Partner Engagement through PoC (Proof of Concept) and Training

Support Engineer & Project coordination

Won a Competition of Best Idea which enhance the functionality and usability of the tool

Support Engineer and Maintain and Monitor Process Chain

Requirement understanding and defining the Scope of Work

Requirement understanding and defining the Scope of Work for different WAD Reports

MIS Report Development on different SAP Modules like MM, HR, SD, FI using SAP Standard Extractors like LO Cockpit

II. Skills:

• Depth Installation & configuration Knowledge of SAP BO and Power BI Desktop/Services. 1. Query Designing

2. DAX – Data Analysis Expression – Language of Power BI 3. Table Relationships

4. Dashboard Designing

5. Connection with SAP HANA

6. The Best Practice of Dashboard and Report Designing 7. Report Scheduling

8. Report Broadcasting

9. Predictive Analysis

10. Security and Data Access Permissions

11. Training – (SAP BI/Power BI/Tableau)

12. SAP BPC EPM 10.0

13. SAP BI-IP

14. SAP S4 HANA CDS Views

15. Data Extraction from various Sources & Extractors SAP BI 7.0 o LO Cockpit

o Inventory

o Finance

16. Process Chain Monitoring and Error Correction

17. Designing Process Chains

Tools

Level

Basic Intermediate Expert

SAP BI ●

Power BI ●

Tableau ●

SAP BO ●

SAP Web

Intelligence ●

SAP HANA ●

SAP Lumira ●

Domains

Manufacturing ●

Chemicals ●

Pharmaceuticals ●

III. Project Synopsis

Company Name Industry Duration Role Tools/Environment Easy.DM Pharmaceuticals Aug – 2020 To till Date BI Consultant SAP BO 4.3 Migration Easy.DM Logistics June -2020 To Oct - 2020 Data Analyst Power BI Aray Consulting LLP Engineering May-2019 to Aug – 2019 BI Consultant &

Developer

SAP HANA, SAP BO 4.2

& Power BI

Sintex Plastics Ltd. Plastics/Manufacturing May - 2018 to Jan - 2019 Sr. Executive Analyst SAP HANA 1.1, SAP BIP

4.2, Lumira 1.31 &

Power BI

Elegant Microweb Pvt.

Ltd.

Banking & Insurance Sep - 2017 To Apr - 2018

Business

Analyst

Elegant JBI - Java

Based Proprietary Tool

of the Company

Software/IT Feb - 2017 To Sep - 2017

Business

Analyst

Elegant JBI - Java

Based Proprietary Tool

of the Company

Government Body,

Hospitals, Pharmacy Oct - 2016 To Jan - 2017

Business

Analyst

Elegant JBI - Java

Based Proprietary Tool

of the Company

TCS

Security Equipment Aug - 2015 To Sep - 2016 SAP BI Consultant SAP BI 7.0 & SAP BO

4.2

Textiles Aug - 2014 To Aug - 2015 SAP BI Consultant SAP BI 7.0 & SAP BO

4.2

Chemicals Aug - 2013 To Aug - 2015 SAP BI Consultant SAP BI 7.0, BI-IP & SAP

BO 4.2

PwC

Textile & Furniture Jan - 2013 To Jul - 2013 SAP BI Consultant SAP BI 7.0 & SAP BO

4.2

Pharmaceutic Jan - 20112 To Nov - 2012 SAP BI Consultant SAP BI 7.0 & SAP BPC

10.0

Chemicals Dec - 2011 To Jan - 2013 SAP BI Consultant SAP BI 7.0 Meghmani Organics

Ltd. Chemicals Feb - 2010 To Dec - 2011 SAP Executive SAP MDM & SAP BI 7.0 IV. Project Details

Consultant/Owner

Aug - 2020 To till Date – Easy.DM

Company Name Industry Duration Role Tools/Environment Easy.DM Pharmaceuticals

Aug – 2020 To till

Date BI Consultant SAP BO 4.3 Migration

Roles and Responsibilities

SAP BO Upgrade from 4.1 to 4.3

Responsible for Client Engagement Project Co-ordination

Migrated Web-Intelligence & Lumira objects to new environment of BO 4.3 Consultant/Owner

June - 2020 To Oct - 2020 – Easy.DM

Company Name Industry Duration Role Tools/Environment Easy.DM Logistics

June -2020 To Oct -

2020 Data Analyst Power BI

Roles and Responsibilities

Responsible for Client Engagement Project Co-ordination

KPI and Dashboard Designing for Top Management for faster & better decision making

Designing the logical data flow

Design Queries and Design Dashboards in Power BI

Publishing Power BI reports to end Users

Embedding the Reports to their Intranet Portal.

Gave training on Power BI

Support Activities – E.g., Continues Data Refresh & Report Scheduling Client Partner & BI Lead

Feb – 2019 To July - 2020 – Aray Consulting LLP

Company Name Industry Duration Role Tools/Environment Aray Consulting

LLP Engineering May-2019 to Oct-2019

BI Consultant &

Developer

SAP HANA, SAP BO 4.2

& Power BI

Roles and Responsibilities

Worked as Independent Partner to establish BI Practice in the Organization

Responsible for Client Engagement and Partnership

Suggest, Strategies and Execute the road map of Implementing SAP BI/BO

KPI and Dashboard Designing for Top Management

Constant interaction with the Management Team and end users and requirement understanding and defining the Scope of Work

Data Analysis through HANA CDS Views of simple and complex requirements for Multiple Reports and Dashboards and exposed it to BICS Connection

Designing the logical data flow

Design Queries in SAP HANA and Design Dashboards in Power BI/ SAP BO

Gave training on Power BI, Lumira to clients

Sr. Executive Analyst - SAP BI

May 2018 – Jan 2019 – Sintex Plastics Ltd., Kalol, Ahmadabad Company

Name Industry Duration Role Tools/Environment

Sintex Plastics

Ltd.

Plastics/

Manufac

turing

May - 2018 to

Jan 2019 Sr. Executive Analyst

SAP HANA 1.1, SAP BIP 4.2,

Lumira 1.31, Power BI

Roles and Responsibilities

Suggest, Strategies and Executed the road map of Implementing SAP BO 4.2 SP5 and SAP Lumira 1.31 on SAP HANA BICS Connection

Responsible for deciding which tool to use for Data Viz Designing

Did PoC and Designed couple of Dashboards on Power BI and presented it to the Management.

To give them difference between Power BI and SAP Lumira.

Server & Client Tools Installation

Leveraging the use of SAP BO & Lumira

Defining the best approach of dashboard designing for management

Data Analysis through HANA CDS Views of simple and complex requirements for Multiple Reports and Dashboards and exposed it to BICS Connection to be used in Lumira or Design Studio

Designed Visualizations for Sales, Budget Vs. Actual

Constant interaction with the Management Team and end users and requirement understanding and defining the Scope of Work

Data Visualization on Finance - Account Payable, Account Receivable Business Analyst - BI

Oct. 2016 – April 2018 – Elegant Microweb, Ahmadabad Company

Name Industry Duration Role Tools/Environment

Elegant

Microweb Pvt.

Ltd.

Banking &

Insurance

Sep - 2017 To

Apr - 2018

Business

Analyst

Elegant JBI - Java Based

Proprietary Tool of the Company

Software/IT

Feb - 2017 To

Sep - 2017

Business

Analyst

Elegant JBI - Java Based

Proprietary Tool of the Company

Government

Body, Hospitals,

Pharmacy

Oct - 2016 To

Jan - 2017

Business

Analyst

Elegant JBI - Java Based

Proprietary Tool of the Company

Roles and Responsibilities

Designing Visualization through Java based Proprietary tool - Elegant JBI and Data Modeling on SQL

Requirement understanding and defining the Scope of Work

S/W - Sole responsible for Implementing EJBI for NCGTC - A Governing Body of MUDRA Yojna, Skill Development & etc.

Delivered reports on Education Loan, Mudra Loan, Skill Development Loan and Submitted to NCGTC and PMO

Insurance Client - Was part of Project delivery Team and had to deliver Insurance Sector and Agent related data and report to the company and IRDAI

Delivered reports on Agent Count, Commission, Policy Count by Agent with multiple dimensions which was approved and IRDAI

Gave Training to Client and Technology Partner on leveraging the tool.

Constantly interacting with Client or Partner for day-to-day activity and Technical/Functional support.

Did PoC which is part of Pre-sales activity for Fortis Healthcare, Mastek – MUDRA. IT Analyst - SAP BI Consultant

Sep. 2013 to Sep. 2016 - TCS, Ahmadabad

Company

Name Industry Duration Role Tools/Environment

TCS

Tata

Consultancy

Services

Security

Equipment

Aug - 2015 To

Sep - 2016

SAP BI

Consultant SAP BI 7.0 & SAP BO 4.2

Textiles

Aug - 2014 To

Aug - 2015

SAP BI

Consultant SAP BI 7.0 & SAP BO 4.2

Chemicals

Aug - 2013 To

Aug - 2015

SAP BI

Consultant SAP BI 7.0, BI-IP & SAP BO 4.2

Roles and Responsibilities

Data Analysis through BI Queries and Dashboards

Designed queries of Sales Report, Purchase Report, Inventory Aging, Project Status, Budget vs. Actual Sales/Production Report, Headcount Report, KPI like Lead Conversion, Avg. Sales through different Modes etc.

Successful implementation & support of SAP BI-IP

BI-IP is basically used for Planning & Budgeting. This is an integrated functionality of SAP BI. Designed and Developed Planning Query through which one can enter the planning figures they want.

Developed new reports as per requirement of the client

Support Engineer and Maintain and Monitor Process Chain

Specialized in modules like SD, MM, FI, PS, CRM & HR

Requirement understanding and defining the Scope of Work

Design and Create Report Documents like - FS (Functional Specs.) or TS (Technical Specs.) SAP BI Consultant

Jan. 2012 to Aug. 2013 - PwC, Ahmadabad

Project Name Industry Duration Role Tools/Environment PwC

PriceWaterHouse

Coopers Ltd.

Textile & Furniture

Jan - 2013 To Jul -

2013 SAP BI Consultant

SAP BI 7.0 & SAP BO

4.2

Pharmaceutical

Jan - 20112 To Nov -

2012 SAP BI Consultant

SAP BI 7.0 & SAP BPC

10.0

Chemicals

Dec - 2011 To Jan -

2013 SAP BI Consultant SAP BI 7.0

Roles and Responsibilities

Requirement understanding and defining the Scope of Work for different WAD Reports

WAD is SAP Delivered Tool for dashboard designing which uses BI Query as data source

MIS Report Development on different SAP Modules like MM, HR, SD, FI using SAP Standard Extractors like LO Cockpit

PP - Daily and monthly Power generation & Comparison report and WAD Dashboard.

MM – Monthly purchase report, Inventory Report, Purchase Order Tracking report

FI – AR, AP and GL Balance report and WAD Dashboard

HR – Developed reports on Daily Attendance, Head Count report & Dashboard

PM – Notification Report which gives information about machine Down Time

Implemented and Supported SAP BPC on BI - Designed complex Finance Reports like Cash Flow, Profit & Loss Report and other Costing and Budgeting reports.

Developed complex reports on Finance like cash flow, Product and region wise Costing, Profit and Loss Report, and Sales.

All the reports were designed in SAP EPM 10.0 and the back-end system was SAP BPC. The legacy system was on HFM, so we mapped all the costing heads and accounts with new SAP BPC System. Also developed the User Manual for each report. SAP Support and MDM Executive

Feb. – 2010 to Dec. – 2011 Meghmani Organics Ltd, Ahmadabad Company Name Industry Duration Role Tools/Environment Meghmani Organics

Ltd. Chemicals

Feb - 2010 To Dec -

2011 SAP Executive SAP MDM & SAP BI 7.0

Roles and Responsibilities

MIS Reporting and UAT of different scenarios in Testing Server with User and Consultant Team

Responsible to submit Sales, Purchase, Stock & Production MIS Reports to Management and Senior Managers from System

Responsible for new development and coordinate with the technical team for the same

Master Data Maintenance using BDC and LSMW(Automation)

Responsible for maintaining Material, Vendor, Customer, Tax, BOM Master in SAP System

Training and resolving issues of the end users day-to-day SAP operations

Responsible to develop training material and providing the same to the end users

Involved actively in providing solutions for routine data entry related issues of end user.

Responsible for training to newly recruited staff members for SAP operations

Contact this candidate