Profileimage by SanjayGupta Dogiparthy SAP BW on HANA/BW4HANA Solution Designer, SAP BW on HANA Solution Designer, HANA Senior Consultant from Inkollu

Sanjay Gupta Dogiparthy

available
Contact

Last update: 19.10.2020

SAP BW on HANA/BW4HANA Solution Designer, SAP BW on HANA Solution Designer, HANA Senior Consultant

Graduation: Bachelors degree
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

Sanjay Gupta SAP BW HANA Solution Designer India.docx

Skills

SAP BW4HANA POC Project, multiple SAP BW, HANA projects, Agile Scrum Methodology, SAP HANA, SDI, Fair, SAP BW/4HANA, SAC, SAP BW, HANA, SAP BI, IBM, SAP BW4HANA, SAP BW 7.5 on HANA, Embedded BPC, BW 7.4, BI 7.0, 3.X and BW, ABAP, Native HANA 1.0 and 2.0, SLT, BODS, SAP Webi, Analysis for Office, HADOOP, Hive, SAP, requirement gathering, Stored Procedures, Scrum, BPC, data model, FI, coding, dataflow, data consistency, OLAP, broadcast, data extraction, SAP R/3, data layers, Objects

Project history

02/2019 - 07/2020
SAP Embedded BPC, BW on HANA Solution Designer Client
Nestle Tech Mahindra
Tech Mahindra, Barcelona Spain

Roles and Responsibilities:
* Supporting SAP BW BPC Project.
* Analyzing the issues identified by the Users while planning.
* Fair knowledge on Embedded BPC architecture
* Understanding functional specification documents and requirement gathering from Functional
team for designing the KPI
* Validating existing flows and data as per the business requirement
* Estimating and scheduling the development and testing activities
* Preparing architecture and build spec documents on SAP BW 7.5 on HANA, Native HANA and BO Dash
Board required for development for offshore.
* Creating required Stored Procedures and Tables functions in native HANA and updating them with
Build specs
* Handling project in Scrum model assisting offshore team with the development where it is
required.
* Updating business people time to time with the development status.

05/2018 - 07/2020
SAP BW on HANA/BW4HANA Solution Designer
Tech Mahindra

07/2017 - 01/2019
SAP BW HANA Solution Designer
Nestle Tech Mahindra
Tech Mahindra, Budapest Hungary/ Barcelona Spain

Roles and Responsibilities:
* Understanding functional specification documents and requirement gathering from Functional
team for designing the KPI
* Validating existing flows and data as per the business requirement
* Estimating and scheduling the development and testing activities
* Preparing architecture and build spec documents on SAP BW 7.5 on HANA, Native HANA and BO Dash
Board required for development for offshore.
* Creating required Stored Procedures and Tables functions in native HANA and updating them with
Build specs
* Handling project in Scrum model assisting offshore team with the development where it is
required.
* Updating business people time to time with the development status.

07/2017 - 05/2018
SAP BW on HANA Solution Designer
Tech Mahindra

11/2016 - 06/2017
SAP BW HANA Developer
Client - Nestle Tech Mahindra
Tech Mahindra, Bangalore India

Roles and Responsibilities:
* Built data flows using LSA++ data model architecture as per the build spec provided by the
lead.
* Developed complex Bex queries for multiple Invoices reports for FI-AP.
* Understanding business rules of the existing data flow and accordingly enhancing the flow as
per the build spec and functional specification.
* Enhanced standard data sources and created generic extractor as per the requirement.
* Implemented new BW and HANA concepts like AMDP transformations, ADSOs, Composite providers,
CDS Views, Table Functions, Stored procedures, Calculation Views and Purning Tables concepts
for improving the performence of data loads and reports.
* Involved in complex ABAP coding required for the KPI logic
* Handled incidents related to multiple live reports in FI.

10/2016 - 06/2017
HANA Senior Consultant
Tech Mahindra

11/2015 - 10/2016
SAP BW HANA Developer
SAB Miller ITC Infotech
ITC Infotech, Bangalore India

* Understanding the business rules for the existing flows.
* Created stored procedures in SAP HANA for daily deletion and reload of data as per the
Business rules.
* Monitoring of complex Process Chains. Taking care of Daily and Weekly Jobs as per client
requirements.
* Troubleshooting the process chains and keeping track of the issues that occur.
* Created dataflow for Open Hub destination.
* Helped BODS team in understanding SAP BW system and accessing Open Hub's in SAP BW.
* Sending daily status reports users on the availability of reports.
* Created Process Chains with the reference of existing flows.
* Checking data consistency, aggregates and hierarchies through RSRV.
* Performance tuning by maintaining Aggregates, Compression, Partition, indexing of info cubes .
* Analyzed the ABAP code in where it is taking more time while loading.
* Worked on Open hub destinations to send the data bw to Bods.
* Worked on OLAP cache, broadcast setting and 0TCT_CA1 cube for handling performance issues.

10/2012 - 10/2016
HANA Consultant
ITC Infotech

09/2012 - 10/2015
SAP BW HANA Developer
Client - ITC Ltd; ITC Infotech
ITC Infotech, Bangalore India

* Extensively worked on data extraction from SAP R/3 using Generic extraction.
* Extensively worked on data extraction from Flat File.
* Created multiple data layers merging Flat file and SAP data as per business rules
* Installing Business content Info Cubes, DSO Objects, Info Objects.
* Implemented BW Formulas, Field routines as per the logic of functional spec.
* Monitoring Data load activities and recovered failures.
* Worked on Enhancements (Data source enhancements and reporting).
* Extensively worked on LO cockpit and Generic data extraction from SAP R/3.
* Created Attribute views, Analytical Views, Calculation views in HANA for POC.

10/2010 - 09/2012
SAP BI Consultant
IBM India Pvt Ltd

09/2010 - 09/2012
SAP BW Developer
IBM India Pvt Ltd
IBM India Pvt Ltd

* Responsible for daily data loads process chains monitoring.
* Resolving process chain failures and updating user on daily basis.
* Maintained reconciliations to verify the data in SAP R/3 and SAP BW were same or not after the
data loads
* Analyzing the reasons for frequent failures of process and providing permanent solutions
* Supported the client by providing long-term solutions to the tickets by doing root cause
analysis
* Maintained work history for all the tickets.
* Updated data from the DSO to Info Cube using with Delta update.
* Uploaded master and transactional data from flat files. SAP BI and SAP R/3.
* Worked Extensively on Administrative workbench (RSA1).

Contact form

Contact details