Saurabh Patel

Contact: +1-630-***-****

E-Mail: ac9366@r.postjobfree.com

An accomplished & knowledgeable professional worked and excelled in roles of Developer, Module Lead / Technical Project Manager. Looking forward to be part of organization where I can be part the Analytic division and contribute to solutions for current challenging business environment.

SKILLS SET

PROFILE SUMMARY

IT Operations

Requirement Gathering

Business Intelligence

Performance Tuning

Troubleshooting

Release Management

Reporting & Documentation

Risk Analysis

Team Management

A competent professional over 8+ years in SAP BW\HANA. Total 15+ years of experience in IT Industry. During this tenure have performed different leadership role and also part of SAP Implementation and Upgrade Team. Presently working with TCS for close to 13 years.

Hands-on experience in developing & implementing plans for improving business intelligence

Abilities in delivering deep insights with the appropriate analytic methodologies & techniques to help the different department achieve its BI / Analytics goals

Significant exposure of working on standard & customized data sources for LO (Purchasing, Inventory, Sales, Shipping, Billing & PP) FI etc.

Demonstrated abilities in handling projects within time, budget & quality parameters as per project management & best practice guidelines

Sound knowledge of SD, MM Modules

Expertise in handling activities related to design, development & testing of Business Intelligence (BI) components

Well versed with SAP BI, SAP HANA, SAP BO.

An effective communicator with good analytical, interpersonal, planning and problem solving skills

WORK EXPERIENCE

Mar’17 - Till Date SAP BI\HANA Developer

Aug’14 – Feb’17: SAP BI Operation Team Lead

July’10 – July’13: BI Consultant

April’08 – June’10: Onsite Technical Lead

Aug’06 – Mar’08: Windows Application Consultant

Apr’04 – Aug’06: Windows Application Developer

Key Result Areas:

Planning, organizing & coordinating activity in assigned technical area (Business Intelligence) to ensure stable & sustainable operations

Responsible for designing & maintaining reports, reporting processes and supporting documentation as well as providing analytical support

Managing all phases starting with project preparation / requirement gathering, business blueprint, realization, final preparation & go live with hyper care & support

Designing, developing and configuring all SAP BI Objects

Building HANA Graphical views

Expertise on SAP HANA Analytical View, Attribute View, Calculation View. Well verse with SAP HANA Performance Optimization, Modeling using different types of views on Native HANA, BW on HANA and external Table based environments.

Expertise on using Optimized joins while building model to improve performance of models.

Implementing single version of truth in reporting environments using SAP BI Reporting Tools (BEx, Business Objects) to support operational, analytical and management reporting

Responsible for managing major performance improvement drive in BW application area of extraction, data propagation & reporting; implementing processes to streamline BW health check services & maintenance programs.

Ensuring translation of user requirements into specifications for complex logical data models and design ETL procedures to load database BI/BW system

Looking after end-to-end management of multiple projects / programs, monitoring progress of project as per schedule and ensuring timely completion & delivery of project to the client

Developing project plans & revising them in accordance with clients’ requirements; creating, reviewing and evaluating project plans & objectives

Troubleshooting performance issue of queries by fine tuning as per execution plan.

ACCOMPLISHMENTS ACROSS THE TENURE

Merit of appreciation from client on delivering complex quality projects.

Best Performing Team Award in Hexaware.

Have a stellar role in working on 7 BW E2E Implementation Projects, 1 BW Upgrade Project, 1 BW Performance Improvement Project, 1 Enhancement / Rollout & 2 Support Projects

Steered efforts in working on one POC. Implemented Native HANA based modelling and reporting via Webi Interface.

Played a key role in:

oDesigning, implementing & governing BI / BW standards; promoting best practices and configuring All SAP BI/BW objects

oWorking with SAP BI/BW Cube’s and BEX Queries

Significantly worked on:

oBO Tools like WEBI, for validating report with the source environment

oTrained in SAP BODS.

EDUCATION

Bachelor in Engineering in Computer Science from Mumbai University in 2003

IT SKILLS

Well versed with:

oSAP Skills: SAP BW 7.3, SAP HANA, SAP R/3 and ECC 6.0

oLanguages: BI-ABAP, VBScript

oRDBMS: SQL Server 2005 and Oracle

oReporting Tools: SAP Query Designer, Business Object XI (3.1) and Business Object Enterprise (WEBI).

oOperating Systems: Windows 98, NT, 2003, Vista, Windows XP and Windows7

oVarious SAP modules such as MM, SD, PS. etc.

oMicrosoft Windows Installer, InstallShield, Wise, FileMon, Regmon.

PERSONAL DETAILS

Current Address: 948 Altantic Ave, Unit A. Hoffman Estates. IL – 60169. USA.

Permanent Address: B3/1001, Lok Everest, Opp City of Joy, JSD Road, Mulund-W. Mumbai-80.

Language Known: English, Hindi, and Gujarati

Any Valid Visa: H1B valid till June 2022.

Please refer Annexure for projects

ANNEXURE

Client: JP Morgan Chase

Company: TCS

Type: SAP BW Implementation and Enhancement

Technology/Software: SAP BW 7.4 on HANA DB, ECC-6.0, SAP HANA 2

Period: July’17 - Till Date

Designation: SAP BI\HANA Developer.

Roles and Project Detail:

Technical Role:

Develop HANA Graphical Views on BW models built on Tables, Native BW Infoproviders as well as on BW on HANA DB.

Leveraging SQL scripts for lookup and performance.

Performance tuning by having physical \ virtual partition based views.

Adding of filters and restriction at the initial level of HANA views, Create selection fields via user prompts.

Designing Calculated Attributes, Variables, and Input parameters.

Data Modelling using HANA Modeller – Create Graphical calculation views and views using old methodology in off case scenarios.

Create Dictionary External HANA Views for consumption in ABAP.

Creation of Function Modules based API leveraging HANA views in Open SQL queries.

Partitioning tables with more than 2 billion records using Range/Hash/Round robin partitioning methods.

Importing and Exporting HANA contents using Delivery Units and Developer mode.

Generating Auto Documentation of HANA models.

Building Composite Provider, ADSO and dependent HANA views for QlickView and Tableau Dashboards.

Undertaking activities related to development of:

oGeneric Extractors and Enhancement of Standard Extractors R/3 System

oBW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)

oCreating and maintenance of Custom Hierarchy.

oGeneration of Summary based reports for Indirect\Direct Expense leveraging Virtual Characteristic and Link nodes for custom hierarchies.

Accountable for:

oDesigning function module & view/table based extractors and technical & functional specifications

oModifying custom hierarchy program and exit routines for BAU scenarios.

Client: Associated British Ports

Company: TCS

Type: SAP BW Implementation and Enhancement

Technology/Software: SAP BW 7.4 on SQL DB, ECC-6.0, SAP HANA 2.8.8

Period: Mar’17 - Till July’17

Designation: SAP BI Operations Architect.

Roles and Project Detail:

Technical Role:

Evaluation of client environment and setup and configuration for SAP BI.

SLC and SRM module to be implemented and development of parallel BI reports.

SAP HANA reports for creditor, debtors and revenue accruals.

Client: ABB

Company: TCS

Type: SAP BW Implementation and Enhancement

Technology/Software: SAP BW 7.4 on SQL DB, ECC-6.0, SAP HANA 2.8.8

Period: May’14 – Feb’17

Designation: SAP BI Operations Team Lead.

Roles and Project Detail:

Leadership Role:

Ensuring Delivery of all BW / BO work products

Responsible for planning and defining scope of the project

Undertaking activities related to:

oRequirement gathering, communication with client /customer or user’s

oActivity planning & sequencing, risk analysis and managing risks & issues

oDevelopment of schedules & time estimating, resource planning, work allocation and execution of work

Looking after execution & delivery and streamlining the process thus increase client / customer or user satisfaction; monitoring & reporting progress to management

Engaged in board communities of practice, recruiting, upgrade planning etc.

Technical Role:

Expertise on SAP HANA Analytical View, Attribute View, Calculation View. Well verse with SAP HANA Performance Optimization, Modeling using different types of views on Native HANA, BW on HANA and external Table based environments.

Expertise on using Optimized joins while building model to improve performance of models.

Transferring data from Replication servers to SAP HANA using SLT. Data loads into BW on HANA system and provision data validations on HANA views for Tableau reports.

Transporting objects using HANA Developer Mode Export and Import Process.

Undertaking activities related to development of:

oGeneric Extractors and Enhancement of Standard Extractors R/3 System

oBW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)

Accountable for:

oDesigning function module & view/table based extractors and technical & functional specifications

oManaging Info Cubes including compression, rollup, indexing & creating aggregates to improve load & query performance

Directed Basis Team to install new SAP GUI release 7.4 with latest patch level 12.

Responsible for checking Table RSZCOMPDIR before & after migration: Field VERSION in Table RSZCOMPDIR should have value below 100, it means query was in 3.x version, if the value more than 100 means it was already Migrated; took pre & post snap to ensure the queries working fine.

oGeneric Extractors and Enhancement of Standard Extractors R/3 System

oBW objects (Info Cube, DSO, Characteristics, Key Figures, Multi Providers, transformations, DTP’s, Info Packages, etc.)

Accountable for:

oDesigning function module & view/table based extractors and technical & functional specifications

oManaging Info Cubes including compression, rollup, indexing & creating aggregates to improve load & query performance

Ensured migration of queries and work books from BW 3.x to BI 7.10

Directed Basis Team to install new SAP GUI release 7.10 with latest patch level to make sure front end must be in the same version for all systems while migrating queries & work books; especially when we were working on global standard model i.e. onsite & offshore model, need to be very careful in GUI versions of all the systems in the project

Key Reports\Projects Developed E2E:

Title: Inventory by Cycle Count

Project Description:

To display delivered Inventory by Cycle count report to the business users to help them analyze actual physical inventory against the inventory reflecting in SAP system.

To compare the physical inventory and its value established during cycle count against the restricted, unrestricted and material level inventory and its value at plant and respective storage location.

Title: Inventory by Profit Centre

Project Description:

To develop and deliver inventory calculation report against GL balance. To calculate restricted, unrestricted and material level inventory and its value at plant and respective storage location.

To derive GL Account and Profit Centre relation to have granular level relation for individual material against plant, storage location and storage bin.

Title: Purchase Price Variance

Project Description:

To deliver purchase price variance report to the business users to help them analyze the various reasons of price variances. To establish the exact reason of price variance due to various rules that are not available in source system, the reasons should be delivered in SAP BI.

To achieve this custom view based datasource built on SAP standard tables like EKBE and EKPO.

Title: T1 Invoice and T7 Orders Report

Project Description:

To deliver custom Orders and Invoice report for Turbo charging division. These reports are to calculate orders, invoice generation to show cost and expense incurred against an order.

Client: Jaguar Land Rover

Company: TCS

Type: SAP BW Implementation and Support

Technology/Software: SAP BW 7.0 on SQL DB, ECC-6.0

Period: Jan’13 – May’14

Designation: SAP BI Developer.

Roles and Project Detail:

Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation, Multiproviders,

Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.

Involved in front-end BI Components like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.

Uploading master data and transactional data both from flat files and SAP R/3.

Creation of Process Chains, Meta Chains for upload of Transaction Data and Master Data.

Monitoring and Error handling in PSA like modifying the error records and reloading the data.

Installed objects from business content.

BI Reporting & Analysis – Ad-hoc Queries, Query Designer, Bex Analyzer, BW Transformations

BW Operations – Data load management, Job scheduling, Loading (Full /Delta Up-Load), Process Chain Monitoring, Data Reconciliation.

Generic Extractors based on Tables, Views & Function Modules.

BW Transports – Transport strategy, Object Collection & Transports Movements across Landscapes

Monitoring daily, Weekly, Monthly and on demand Process Chains.

Monitoring of data loading through Process chains.

Monitoring of Process chains and analyzing the reasons for frequent failures of Extractions.

Maintaining Work History for all the tickets until it is closed down.

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW is same.

Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.

Used delta upload mechanisms to upload SAP R/3 source system data to SAP BW and also involved in uploading of Master and Transaction data.

Data Extracted from R/3, Creating Info packages, Scheduling and Monitor settings.

Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Key Reports\Projects Developed E2E:

Title: Data integration and modelling

Project Description:

To design workflow to load third party data for turbo division using flat file.

Creation of MI and FI level reporting.

Title: Quotation and Lead to Orders Reporting

Project Description:

To design report for quotations from lead to order.

Title: BI Reporting for Result Analysis and Overheads Report

Project Description:

To create E2E BI modelling to build ECC RA and Overheads report in BI using custom datasource for Faster reporting and Webi graphs.

Client: StateFarm Insurance

Company: TCS

Type: SAP BW Enhancement and Support

Technology/Software: SAP BW 7.0 on SQL DB, ECC-6.0

Period: Aug’12 – Dec’12

Designation: SAP BI Consultant, in USA.

Roles and Project Detail:

Major activity of enhancing flows and reports already available in Production as part of hyper care Support

Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation, Multiproviders,

Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.

Involved in front-end BI Components like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.

Uploading master data and transactional data both from flat files and SAP R/3.

Creation of Process Chains, Meta Chains for upload of Transaction Data and Master Data.

Monitoring and Error handling in PSA like modifying the error records and reloading the data.

Installed objects from business content.

BI Reporting & Analysis – Ad-hoc Queries, Query Designer, Bex Analyzer, BW Transformations.

Client: LyondellBasell Industries

Company: TCS

Type: SAP BW Enhancement and Support

Technology/Software: SAP BW 7.0 on SQL DB, ECC-6.0

Period: Aug’10 – Jul’12

Designation: SAP BI Consultant, in USA

Roles and Project Detail:

Major activity of enhancing flows and reports already available in Production as part of hyper care Support.

Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation, Multiproviders,

Monitoring daily, Weekly, Monthly and on demand Process Chains.

Monitoring of data loading through Process chains.

Monitoring of Process chains and analyzing the reasons for frequent failures of Extractions.

Maintaining Work History for all the tickets until it is closed down.

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW is same.

Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.

Used delta upload mechanisms to upload SAP R/3 source system data to SAP BW and also involved in uploading of Master and Transaction data.

Data Extracted from R/3, Creating Info packages, Scheduling and Monitor settings.

Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Client: LyondellBasell Industries

Company: TCS

Type: Windows Application Packaging and Support

Technology/Software: WISE.

Period: Apr’08 – Jul’10

Designation: Onsite Technical Lead in USA

Roles and Project Detail:

Leadership Role:

Overlooking on development and delivery of projects.

Requirement gathering from Business and preparing technical document for development team.

Quality check control and Auditing.

Billing and Invoice Generation of the team.

New Business generation.

On boarding and recruitment of resource from external vendor\TCS internal at client location.

Technical Role:

Packaging, repackaging and Transforming of MSI’s as per specifications.

Upgrade of already packaged applications.

Patching of already packaged applications.

Create Pseudo packages for deploying the 3rd party msi.

Create custom actions in VB Scripts to run custom code within MSI’s.

Create packages for citrix environment adhering to client requirements and security.

Conduct delivery tests in citrix XenApp5 and XenApp6 environments for the citrix packages.

Actively involved in troubleshooting and providing support for the deployed packages in production environment.

Successfully customized\captured\repackaged SAP GUI and SAP BI software’s. Handled upgrade scenario and have stable environment of client workstation with multiple SAP product co-existing on client workstation

Client: LyondellBasell Industries

Company: TCS

Type: Windows Application Packaging and Support

Technology/Software: WISE.

Period: Aug’06 – Mar’08

Designation: Windows Application Consultant

Roles and Project Detail:

Technical Role:

Packaging, repackaging and Transforming of MSI’s as per specifications.

Upgrade of already packaged applications.

Patching of already packaged applications.

Create Pseudo packages for deploying the 3rd party msi.

Create custom actions in VB Scripts to run custom code within MSI’s.

Create packages for citrix environment adhering to client requirements and security.

Conduct delivery tests in citrix XenApp5 and XenApp6 environments for the citrix packages.

Actively involved in troubleshooting and providing support for the deployed packages in production environment.

Successfully customized\captured\repackaged SAP GUI and SAP BI software’s. Handled upgrade scenario and have stable environment of client workstation with multiple SAP product co-existing on client workstation.

Client: Royal and Sun Alliance

Company: Hexaware Technologies

Type: Windows Application Packaging and Support

Technology/Software: InstallShield.

Period: Apr’04 – Aug’06

Designation: Windows Application Consultant (India and UK)

Roles and Project Detail:

Technical Role:

Packaging, repackaging and Transforming of MSI’s as per specifications.

Upgrade of already packaged applications.

Patching of already packaged applications.

Create Pseudo packages for deploying the 3rd party msi.

Create custom actions in VB Scripts to run custom code within MSI’s.

Training and Knowledge Transfer to other members at onshore, offshore and Client-Side team.

Support to the deployed packages.

Contact this candidate