Summary
Overview
Work History
Education
Skills
Certification
Interests
Timeline
Generic

Harshal Panchal

Irvine

Summary

Over 18 years of experience in SAP BW/HANA Worked as Lead/Developer and Application Manager roles for various full life cycle Implementation, Rollout, Upgrade, Migration and Production support projects in SAP BW/HANA. Industry experience: Auto, Retail, Pharmaceutical, Manufacturing, Healthcare, Insurance, Apparel, Consumer goods, Energy, Oil and Gas Services. SAP Certified: Application Associate - Reporting/Modeling and Data Acquisition with SAP BW/4HANA 2.x, SAP BDC SAP Key skills: SAP BW/4HANA, SAP BW/HANA, SAP Analytics Cloud (SAC), SAP Business Objects SAP Datasphere, SAP BDC SAP Versions (Latest): BW/4HANA, HANA 2.0/1.0, BW on HANA 7.5, BO 4.2 SAP Functional Knowledge: S/4 HANA, SAP TM, SAP EWM, SAP ECC-FICO, SD, MM, PP, PS, CRM, UCM, SAP GTS, SAP MDG.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Sr. SAP BW/HANA Developer Analyst

Yamaha Motor Co
01.2018 - Current
  • Leading SAP BW/HANA developments for SAP TM, EWM and SCM Modules. Lead the effort to gather, analyze and model business data, KPI’s, using various analytical tools and techniques to develop quantitative and qualitative business insights and improve decision-making.
  • Involved in Greenfield S/4 HANA and BW/4HANA implementation.
  • Implement SAP BW/HANA specific modeling like; Advanced DSO's, Composite Providers, Open Hubs, Operational Data Providers, BW Extractors, Bex Queries, SDI Flowgraphs, etc.
  • Created Complex calculation views, stored procedures, Table functions and Custom tables. Used different Join types, Unions, Rank and Aggregation nodes. Created complex Calculated and Restricted columns, using expressions- CE Functions and SQL script. Input parameters/Variables.
  • SAP Analytics Cloud- Created Data Models, Stories, Dashboards for Logistics and Sales data.
  • SAP Datasphere- Created Spaces, Connections with SAP and Non-SAP systems, Created data flows. Certified in SAP BDC.

Lead Consultant- SAP HANA

Infosys Inc.
08.2015 - 01.2018
  • Worked as Lead Consultant- SAP HANA. Leading the full life cycle Native HANA (SPS10) implementation project. Involved in Architectural design, requirement gathering, and Converting Functional specs to Technical specs, Entity relationship, Development, testing, Cutover and Go-live activities.
  • Modeling- Created complex graphical/scripted calculation views for domain- Simple Finance (S/4 HANA), Sales, PPM, Purchasing and Manufacturing. Created stored procedures, Table functions and Custom tables. Strong experience in using Joins, Unions, Rank and Aggregation nodes. Creating Calculated/Restricted columns, Input parameters/Variables.
  • SLT Replication- Used SLT replication cockpit and Data provisioning for replicating tables from SAP in real-time. Adding filters and transformation rules to tables using SLT cockpit. Analyzing data load statistics.
  • Performance Tuning- Analyzing Calculation view performance using Visualization plan, Explain plan, SQL Plan, SQL Tracing and take decisions based on the statistics, optimizing HANA views for better performance.
  • Change Manager/ALM- Using Change Manager/ALM tool to create/maintain Change Id’s.
  • ChaRM- Working as a ChaRM lead for HANA object migration, creating Change documents, maintaining HANA Change id’s using ALM tool and HANA studio. Migrating objects to QA and Production.

Lead SAP BW HANA Consultant

Globus IT Solutions
02.2015 - 06.2015
  • Worked as SAP BW HANA Consultant for client ITT Cannon (world leader in the design and manufacture of highly engineered connector solutions).
  • Managing a team of 10 developers for SAP BW and HANA development and migration project. Primary point of contact for the project to interface customer with project team, communicating status updates, leading meetings, managing project deliverables, etc.
  • Interacting with business users for understanding requirements, requirement gathering, Preparing functional and technical specifications, etc.
  • BW-HANA migration- Includes migration infoproviders from SAP BW to HANA. Converting BW to HANA optimized infoproviders, building reports based on HANA views. Utilizing SAP BW 7.4 functionality for new infoproviders. Creating Attribute, Analytic and Calculation views. SQL scripting & stored procedures using HANA. Data provisioning using SLT, DXC and BODS.
  • SAP BW, BO for Management reporting- Developed Finance, Sales, Production planning and Inventory reports using BEx query designer and WebI.
  • SAP BW data modeling- Created infocubes, Multiprovider, DSO’s, enhanced data sources, and created transformation routines to meet custom requirements.
  • SAP XI/PI- Integrating SAP XI/PI with Supplier portal and SAP BW

Sr. SAP BW HANA Consultant

IGATE Technologies Inc.
09.2013 - 01.2015
  • Worked as SAP BW HANA Consultant for SAP BW HANA migration project.
  • Performing SAP BW to HANA migration activities- Analysis, design, pre-migration and post-migration activities and testing. Converting BW infoproviders into HANA optimized infoproviders. Creating Attribute, Analytic and Calculation views. Integrating SAP HANA with SAP ECC, BW, BOBJ reporting tools using SAP SLT, Data services, DXC, etc. Creating Analytic privileges.
  • The role focuses on SAP BW Application Management- SAP BW- GL, AP, AR and Supplier portal. Complete application responsibility Technical & functional.
  • Interacting with users and functional consultants, understanding requirements, requirement gathering, converting functional documents to technical documents
  • Developing new BW reports such as Payment services reports, Capital and Fixed asset reports, Project systems reports, Actuals/Budget/Forecast variance reports, Sales reports etc.
  • The major tasks include Data Modeling, Datasource enhancements, Extraction and Reporting for Financial and logistics data.
  • Extracting data from SAP and legacy systems standard and generic extractors
  • Data transformation using ABAP code at extractor and transformation level to create useful data for reporting. Created transformation routines, infoobject routines, also used BADI etc for data transformation.
  • Created Open hub services to export BW data to 3rd party systems.
  • Utilizing new features in BW 7.3 modeling such as Hybrid providers, Partitioning, etc.

Lead SAP BW/BO Integration Lead

Ernest & Young Consulting
03.2013 - 08.2013
  • Worked as an SAP BW/BO Integration Lead Consultant for customer Merck & Co. for Asia-pacific region.
  • Integrated non-SAP and SAP systems in to SAP BW system.
  • SAP BW back end development: extractor enhancement, function module development, data modeling, transformation routines, user exists.
  • Enhanced standard SAP extractors, developed generic extractors for Flat file, SAP, DB source systems to extract data from legacy systems in to SAP BW. Used ABAP code to transform and migrate legacy data in to SAP BW. Developed transformation routines, function modules, infoobject routines.
  • BEx report development: Created reports in in Sales: Billing document, Backorder, Open delivery status, Daily Sales reports, Stock on Hand report, etc. Project Systems: Project status report, Currency variance report, Monthly/Quarterly/Yearly reports, Project System Master data report (WBS element) etc.
  • BO 4.0 WebI report developments and dashboard designing, BO 3.x WebI report and Universe developments.
  • Also working as an Advisory consultant for the customer on BW-on –HANA, Spotfire on HANA and BW technology for strategic planning.
  • Every Angle Operations Management BI and Spotfire dashboards support and development

SAP BW BO Consultant

Spectrum Technologies Inc.
06.2011 - 12.2011
  • Worked as a SAP BW BO Consultant. Single point of contact for any issues related to BI system. Managed a team of ten.
  • Gathering requirements from end users for Finance, Project systems data. Solving BEx reporting issues.
  • Involved in Information Broadcaster implementation. Configuring & troubleshooting Precal server. Broadcasting BEx queries and workbooks to set of User groups.
  • Worked actively on creating/maintaining Infocubes, DSO, Multiproviders, Master data objects etc.
  • Developed Ad-hoc BEx queries, workbooks to satisfy User’s requirement. Worked on BEx query Designer, Analyzer, Portal etc.
  • Creating User roles and profiles. Data Loading- Past year data loading, historical data loading using Delta and Full loads. Support pack upgrades on SAP BI 7.0 system. Successfully delivered the project.

Sr. SAP BI BO Consultant

IBM
03.2010 - 05.2011
  • Worked as a Sr. SAP BW Consultant in Full life cycle implementation environment. Managed a team of six.
  • Involved in Full Life Cycle implementation of Finance (FI) and Project Systems (PS) modules. Involved in Requirement gathering, Technical specifications design and approvals, Development, Integration Testing, Cutover activities, Go-Live and support.
  • Developed following Reports for Finance: Order to Cash Report, Balancesheet report, P&L Report, Local currency report by Cost Centers, % Aging report etc.
  • Project systems: Project Financial Report, Project System Status Report, Capital Currency variance Report, Project Master Data Report, Capital Pricing Approval CPA Report, Capital Project Appropriation report.
  • Developed FI-GL, AR, AP datasources, Infocubes and DSO’s. Developed Project systems datasources and data targets for Actual, Budget, and Commitment values.
  • Created BEx queries and SAP Business objects reports based WebI (Web Intelligence designer).
  • Converted BEx queries to Web queries, created Universes based on FI Infocubes and created Dashboards using Xcelsius. Used ABAP coding to create User exit variables and transformation routines.
  • Integration of external systems to SAP BI using Open Hub destinations.
  • Understanding the User requirement converting user requirement to Technical design specifications. Unit and Integration testing, creating Test scripts in HP Quality center.
  • Performance tuning of the report and data loads.
  • Worked on FTP (Funds Transfer Pricing) project to extract data from FI-PCA (Profit Center Accounting) to BW
  • Prepared Technical Design Document (TDD), involved in Functional Design Document (FDD), getting approvals for TDD’s, involved in other implementation processes like Unit Testing, UAT, SIT and Go-Live
  • Worked on BI-CRM for following areas CRM Leads, opportunity, sales orders, services
  • Worked on following DataSources CRM Leads (DataSources 0CRM_LEAD_H, 0CRM_LEAD_I), CRM Activity (DataSources 0CRM_SALES_ACT_1, 0CRM_SALES_ACT_I), CRM Opportunities (DataSources 0CRM_OPPT_H, 0CRM_OPPT_I) and Master data DataSources like Customer number, vendor number, CRM Billing data, etc
  • Worked with CRM data targets like 0MKTG_C01 (CRM Leads), 0SAL_DS01, 0CSAL_C01 (CRM Activities), 0CRM_OPPH, 0CRM_OPPI, 0CRM_C04 (CRM Opportunities)
  • Worked on CRM reports like Sales Analysis reports, Top-n Won Leads, Top-n Lost Leads, Lead Analysis, Compensation Sales etc. Interacting with Business analysts and users for gathering reporting requirements, prepare technical and functional specifications and sign offs
  • Integrating SAP BI Reports on CRM WebUI. Created RFC connection between SAP BI and CRM. Maintained required authorization objects, roles for the CRM users. Integrated standard BI web templates on CRM home page. Setup Information Broadcaster in SAP BI 7.0 to automate distribution of reports to users directly

Sr. SAP BI/BO Consultant

Spectrum Technologies Inc.
08.2009 - 02.2010
  • Worked as a Sr. SAP BI/BO Consultant in Development/production support environment
  • Main responsibilities include User interaction, Requirement gathering, Analyzing issue, Prepare implementation related documents like Blueprint, Project charter, Effort estimation, Functional/Technical specifications, etc and also Development and enhancement in the existing data flow. The major supported SAP modules were SD, MM, FI, CRM, APO, HR
  • FI modules GL, AP, AR, implemented FI data sources for GL account, Vendor and customer DataSources like 0FI_GL_4, 0FI_GL_8, 0FI_AP_1 , 0FI_AP_4, 0FI_AR_4 etc
  • Worked on SD Datasources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_13_VDITM
  • Worked with CRM data targets like 0MKTG_C01 (CRM Leads), 0SAL_DS01, 0CSAL_C01 (CRM Activities), 0CRM_C04 (CRM Opportunities)
  • Owned responsibilities for Queries and Broadcasting related issues. Created queries and workbooks using BEx Query Designer, BEx Analyzer, created interactive Web-templates using Web Application Designer WAD. Created user exit variables using ABAP to create QTD, YTD reports and for currency variance calculations.
  • Worked on Business Objects (XI R3) with Desktop Intelligence, Web Intelligence, Universe Designer, Voyager, Xcelsius for creating different reports. Created reports using Deskl and WebI. Created interactive dashboards using Voyager and Xcelsius
  • Involved in integration of SAP BI with Business Objects XIRel 3 with the integration kit
  • Experience in Building Universes on SAP BI 7.0 using BO XI REL 3 version, creating connection between BI and BO. Creating Datasources for SAP. Created Universes on SAP BI InfoCubes and other data providers to retrieve data to BO. Retrieving data using Universes, Personal data files, stored procedures and freehand SQL methods
  • Worked on building and enhancing Universes, retrieving data using Universes, Personal data files, stored procedures and freehand SQL methods
  • Expertise in resolving loops by using Aliases and Contexts. Excellent knowledge in DW concepts and Architecture using fact Tables and Dimension tables. Experience in different OLTP and OLAP databases
  • Involved in testing Universes and reports for correct mapping of the objects and data correctness
  • Experience with Central Management Console (CMC) and Central Management System (CMS)Administration for maintaining User profiles for Authorizations, Publishing and Scheduling Reports to Users and Importing, handling security and routing request to other servers, Exporting Universes etc.
  • Involved in implementing concept of Simulation of Account determination for Billing documents in R/3 and BW, involved in extractor logic creation in ABAP, data flow design in BW and data loading
  • Creating Users, roles, profiles and authorization objects. Analyzing and solving Authorization related issues using RSECADMIN, RSSM, RSSMQ
  • Implemented Precalculation server and Broadcaster in BW, creating Broadcaster settings and workbooks, publish it to user/portal
  • Implemented successfully change of data flow for Remote cube for APO data, adding characteristics and key figures to existing data flow, changing transformation and uploading data in BW
  • Batch Jobs, R/3 jobs monitoring, Monitoring Precalculation Server/Broadcaster Jobs, debugging aborted process chains, monitor logs regarding Precalculation and restart settings, etc. Starting/stopping Precal server and excel processes and BWProcess chain Monitoring.

Sr. SAP BI/BO Consultant

Northstar Technologies
10.2007 - 06.2009
  • Involved in Integration of Business Objects XI R3 with SAP BI 7.0
  • Created Universes on SAP FI, COPA, SDInfoCubes and other dataproviders. Created many reports and dashboards using Desktop designer, Web-Intelligence Designer Crystal Reports
  • Created complex and Ad-hoc reports having features like slice and dice, Drill capabilities, complex freehand SQL queries, @Functions, Master Detail and Cross Tab tables with multiple breaks
  • Published BO reports, dashboards to different users using CMC, CMC Administration, creating user profiles according to the user status, publishing and scheduling reports for daily broadcasting. Maintaining Import and Export of Universes
  • Worked extensively in developing and implementing Crystal Reports/WebI on Business Objects Enterprise XI REL3, Crystal Enterprise 8.0
  • Involved infull Implementation of BI for SD and FI modules.Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc
  • Created Transformation mappings, DTPs, Infopackages for all above DSOs
  • Enhanced following datasources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_13_VDITM, 2LIS_11_VASCL, 2LIS_01_S601, 2LIS_01_S602, 1CO_PA_YPH1_NEW (COPA). Created Transformation Routines, Start Routines, End Routines and Info object routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines. Creation of tables, creation of Generic datasources, Function modules in R/3 system (ECC6.0)
  • Created Infopackages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side
  • Created and maintained MultiProviders ZSD_M01 for above Sales Distribution DSO. Maintained Characteristics and key figure assignments in the MultiProviders as per the reports requirement
  • Created and maintained Master data objects. Created different Hierarchies. Created and maintained Process chains in RSPC to schedule daily loads
  • Created Queries and Workbooks using BEx Designer and Analyzer for SD management like Sales Growth (MTD, QTD, YTD), Sales Products, Sales Distribution, Sales Hospitals, Sales Opportunity for Sales Representatives, Sales History, etc. Publishing queries to the Roles, Portals and broadcasting queries to Customers and Sales Representative by emails
  • Development and production support for SAP BI 7.0 for FI, BCS and HCM modules
  • Queries - Created number of new queries in BEx Query Designer for Finance and BCS modules like Consolidated Balance sheet, Consolidated Income statement, Working capital Balance changes, Trade Account Payables, Trade Account Receivables, General Analytical tool for BCS, Selling and Administrative expenses, etc
  • Worked on complex BEx Workbooks and reports using BEx Analyzer. Created interactive graphs/charts for Working capital balance changes and Days in AP and AR, etc
  • Solved issues regarding Queries/workbooks. Worked with different BCS Hierarchy related issues. Extensively helped end users to get the exact query output/report to meet the management requirements. Worked several times on Query Performance Issues using Transaction code RSRT
  • Created RRI Jump queries using RSBBS Tcode (Maintain Sender/Receiver Assignment) like to jump from a report to R/3 Tcode FAGLL03 (G/L Account Line Item display)
  • Extensively worked on Data Validation from BI and BCS side. Used BCS Consolidation Workbench (Tcode- UCWB) for BCS data verification. Also done data validation with Third party ERP (HYPERION) with BI7.0 data
  • Huge experience in Web Application Designer for creating web templates for FI, BCS, PP, QM modules.
  • Frequently used Information Broadcaster for broadcasting Pre-calculated Queries/Web templates to Portal. Published FI, HCM, PP, QM, and SD Dashboards to portal. Created many I Views in EP6.0 to publish.
  • Worked on General Ledger Balances Cubes (0FIGL_C10), Planning Reporting cube (ZPP_CRP1) Real time cube; General Ledger Transaction Figures (0FIGL_O10), GL Key Figures (ZFIGL_KF) with datasources 0FI_GL_8 & 0FI_GL_10 respectively
  • Created BCS Multiproviders which contains Reporting cube and planning cubes
  • SAP-HCM Migration Project: Migration of different HR cubes data flow from BW 3.5 to BI 7.0.
  • Worked on Business Objects XI Release 2, to get data from HYPERION, BI and SAPECC

SAP BW/ABAP Consultant

Siemens Ltd
07.2004 - 09.2005
  • Full Life cycle Implementation of SAP BW 3.1C and production support.
  • Understood the business process, organization structure and functional specifications after a series of requirement analysis sessions.
  • Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW Loaded custom hierarchies, from flat files, to enable drill-down reporting.
  • Created Master Data InfoSources for Attributes, Texts and Hierarchies.
  • Managed ODS &InfoCubes objects. Worked on deleting requests, rollup of requests within ODS & Infocube.
  • Populated the InfoObjects, ODS Objects and InfoCubes with Master data and Transactional data from SAP R/3 via Data Staging area (PSA).
  • Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements

Trainee/Apprentice Engineer

Century Enka Ltd.
11.2003 - 06.2004
  • Trainee Electrical Engineer

Education

Master of Business Administration -

University of East Anglia
01.2013

PG Diploma - Management Consulting

University of East Anglia
01.2013

Bachelor of Engineering - Electrical Engineering

University of Pune
05.2002

Skills

    SAP BW

    SAP HANA

    SAP Datasphere

    SAP Analytics Cloud

    SAP BDC

Certification

  • SAP Certified Application Associate - Reporting / Modeling and Data Acquisition with SAP BW/4HANA 2.x
  • SAP Certified Application Associate - SAP HANA 2.0 (SPS05)
  • Introducing SAP Business Data Cloud

Interests

  • Hiking
  • Backpacking
  • Team Sports
  • Artificial Intelligence (AI) and Machine Learning

Timeline

Sr. SAP BW/HANA Developer Analyst

Yamaha Motor Co
01.2018 - Current

Lead Consultant- SAP HANA

Infosys Inc.
08.2015 - 01.2018

Lead SAP BW HANA Consultant

Globus IT Solutions
02.2015 - 06.2015

Sr. SAP BW HANA Consultant

IGATE Technologies Inc.
09.2013 - 01.2015

Lead SAP BW/BO Integration Lead

Ernest & Young Consulting
03.2013 - 08.2013

SAP BW BO Consultant

Spectrum Technologies Inc.
06.2011 - 12.2011

Sr. SAP BI BO Consultant

IBM
03.2010 - 05.2011

Sr. SAP BI/BO Consultant

Spectrum Technologies Inc.
08.2009 - 02.2010

Sr. SAP BI/BO Consultant

Northstar Technologies
10.2007 - 06.2009

SAP BW/ABAP Consultant

Siemens Ltd
07.2004 - 09.2005

Trainee/Apprentice Engineer

Century Enka Ltd.
11.2003 - 06.2004

PG Diploma - Management Consulting

University of East Anglia

Bachelor of Engineering - Electrical Engineering

University of Pune

Master of Business Administration -

University of East Anglia

Similar Profiles

CREATE PROFILE
Harshal Panchal