Senior SAP BW, BW on HANA, BW/4HANA, BW-IP, SAC Consultant

Project # 11
Company: DXC Technology
Role: Associate Manager for Application Development
Project Name: Inventory Standard Cost
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: Aug 2021 - Jul 2022
Environment: BW/4HANA, S/4HANA, SAC, SAP BI tools, Eclipse for HANA, ABAP and BW developments

Responsibilities:
* Responsible for efficiently delivering the project and supervising the implementation team.




* Prepared the design and support documents
* Presented the support model of the developed project with full details
* First point of contact and taking requirement by participating the project stake holders meeting
* Implemented Graphical Calculation Views
* Involved in design and development of Advanced DSOs and Composite providers.
* Exposing Inventory Data Models into SAC using live connection.
* Successfully created Sample Dashboard story in SAC using Canvas and Responsive pages
* Prepared Transport Management from dev tenant to prod SAC tenant.
* Tested and resolved data issues in SAC Dashboard stories
* Worked on In Built Models to analyze data from HANA System
* Implemented stories using different features of SAC.
* Developed Invenotry Model KPIs in SAC Story using Live Connection
* Developed BW HANA Models to generate External HANA Views and provided the authorizations
* Developed ADSOs to generate External HANA Views to be consumed in CV
* Expert level exposure to In-Memory Computing, Structure of SAP HANA studio, Configure
Perspectives & Create Package, Enterprise HANA and BW on HANA.
* Creating Calculation Views of type Dimension/ Cube/ Cube with Star Join.
* Creating the Attribute Views /Analytical View and consumed into Calculation View
* Created Calculated Measures and Restricted Measures in Aggregation node to serve different
business requirements.

Project # 10
Company: DXC Technology
Project Name: Finance Platform Transformation (FPT)
Role: Associate Manager for Application Development
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: June 2019 - July 2021
Environment: S/4HANA, Eclipse for HANA, ABAP and BW developments, BW 7.5 Embedded, Embedded BPC,
SAP BI tools, Lumira Designer

Responsibilies:
* Managed transition of projects to DXC with respect to the business requirement and logic
implemented in the system and checked the Technical and Functional design handover documents
as per the transition.
* Support the solution 24/7 as key resource and on-call support even where the critical tickets came
and communicate with the user's timely manner to update the progress of the resolution.
* Replicated data using SLT and handled the Entire Master data loadings from the various legacy
systems to the S/4HANA system.
* Involved in supporting the various planning sequences and planning issues when input reports in AO
or Lumira not working. Debugged the ABAP/AMDP codes in various objectives such as planning
functions, transformations, Classes and Methods and Custom code in variables of BEx Queries.
* Created change requests in case any design functionality is not working and developed the resolution
and moved the transports using the active control.
* Support the enable now to handle the access issues and contacted the SAP if needed implement the
OSS notes as suggested by the SAP support team.
* Supported BW integrated planning to handle the copy forward and other excel functionality handle
by planning sequences and automated using the process chains by placing the flatfiles in the
application servers.




* Supported various ODP extractions build on the calculation views, CDS views full and delta
extractors. Developed the authorization roles for users to access specfici data for reports.
* Worked in the transactions RSECADMIN, RSRT, DBACOCKPIT to check the user access, performance
of reports and BW objects consumption space in S/4HANA system.

Project # 9
Company: Hewlett Packard Enterprise
Role: Business Analyst
Project Name: Tax External Reporting
Client: Uniper, Germany (Power Generation Company)
Duration: June 2018 - May 2019
Environment: S/4HANA, Eclipse for HANA, ABAP and BW developments, BW 7.5 Embedded, Lumira reports

Responsibilities:
* Involved in the report requirement gathering with project stakeholder. Handled project
management activities during various stages.
* Designed & Developed reports in FI area in BO Analysis for office(A4O), Design Studio and Creation
of Dashboard Reports
* Created different type of objects Calculation View, Attribute View, Analytical View
* Developed ABAP related programs, FMs, BADIs and transformation routines.
* Worked on Scripted Views and Comfortable with SAP SQL scripting.
* Customized Composite provider, ADSO, ODP data source in BW/4 HANA.
* Worked on Business objects 4.1 & Lumira 2.0 reports.
* Created Data models to handle the frequent planning and Created Input Queries.
* Involved complete life cycle of the project including cutover and handover to service management
* Handle the proper handover to service team and trained them to support the solution

Project # 8
Company: Hewlett Packard Enterprise
Role: Professonal Desinger
Project Name: Supply Network Operation
Client: STILL Company, Germany (Steel Manufacturing)
Duration: May 2016 - May 2018
Environment: BW 7.4 on HANA, SLT, BODS, Eclipse for HANA, ABAP and BW objects, Query Designer, Web
Templates, SAP BI

Responsibilities:
* Involved in mapping and matching with the business to collect the business requirement.
* Preparing the gap sheets and SOW as compared with the Canadian solution.
* Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
* Replicated data using SLT and BODS and created models as per requirement.
* Involved in moving Information models to BW as transient provider and created Reports.
* Created SPOs and in memory Cubes and DSOs. Utilized most of the new features of BW 7.4.
* Migrated In memory Cubes and DSOs to Hana studio and modified as per requirement to create
Calculated and Analytic views.
* Created Decision tables and performed various calculations using the functions provided by Hana.
* Created Query and process chain log documents




* Created and maintained reports using Crystal reports Database expert, Grouping expert and Cross
tab expert.
* Created process flow module documents and Scheduled SPM loads through Portal.
* Involved in Unit Testing and Business Acceptance Testing using HP Quality Center
* Interacted with Business users and collected requirements and provided solutions accordingly.

Project # 7
Company: Hewlett Packard Enterprise
Role: Professonal Desinger
Project Name: Enhancements and Performance Analysis
Client: British Petroleum, United Kingdom (Oil and Gas Company)
Duration: August 2014 - April 2016
Environment: BW 7.3 on HANA, Query Designer, Web Templates, SAP BI

Responsibilities:
* Helped the users to understand the gaps and preparing the gap sheets. Analyzed the gap sheets and
provided the solutions and prepared the design documents
* Created and enhanced queries using structures, with restricted keyfigures, calculated keyfigures,
variables, cell definitions.
* Worked on repartitioning of infocubes and carried request reduction activities to improve load and
query performance.
* Identified the number range objects and buffered the objects to improve loading performance.
* Involved in moving Information models to BW as transient provider and created Reports.
* Used MFT(managed file transfer) as middleware technologies to send data from a BI system to
windows based SAP BPC system.
* Involved in managing of Info cube, which involves Info cube content, performance issues like Indices,
Statistics, and compression of Info cube.
* Developed BI Infrastructure to export data into MS based BPC system through Created Open Hub
Files to interface with BPC system and custom Start & End Routine created to propagate client
required data
* Created Query and process chain log documents
* Scheduled Daily/Weekly/Monthly data loads schedule new jobs.
* Involved in Unit Testing and Business Acceptance Testing using HP Quality Center

Project # 6
Company: Hewlett Packard Global Soft India Limited
Role: Lead Consultant
Project Name: NA Freight Solution Discovery and Implementation
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: September 2013 - July 2014
Environment: BW 7.4 on HANA, Query Designer, Web Templates, SAP BI


Responsibilities:

* Involved in mapping and matching with the business to collect the business requirement.
* Preparing the gap sheets and SOW as compared with the Canadian solution
* Preparing the CPS for the next phase development and involve in all communication with business
for integration
* Developing the solution in BW and creating all the required BW reports and web reports.




* Preparing test cases for Unit test, SIT, BAT and providing support for key users during testing.
* Responsible for moving the solution to the production environment.
* To provide the hyper care support to end users after the cutover and trained the SM to handle the
solution.
* Resolved the issues during the hyper care period very quickly without loss of business and closed
the tickets based on the user's sign-off.

Project # 5
Company: Hewlett Packard Global Soft India Limited
Role: Lead Consultant
Project Name: Global and Regional SAP BW DVM application
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: December 2012 - December 2013
Environment: BW 7.3 on HANA, Bex Designer and Web templates

Responsibilities:
* Lead the team and maintaint the project schedules.
* Share the activities equally within the team and helped in the critical scenarios.
* Involved in mapping and matching with the business to collect the business requirement.
* Worked on Functional design and technical design, to escort the business need.
* Presenting the solution to the governance team for design approval.
* Helped the ABAPer to understand the logic perfectly to build the logic as per the expectation
* Developing the solution in BW and creating all the required BW reports and web reports.
* Preparing test cases for SIT, BAT and also providing support for key users during testing.
* To provide the hyper care support to end users after the cutover.

Project # 4
Company: Hewlett Packard Global Soft India Limited
Role: Senior Consultant
Project Name: Phase In and Phase Out
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: December 2012 - July 2013
Environment: BW 7.3 on HANA, Bex Designer Tools, SAP ECC 6.0, SAP APO

Responsibilities:
* Designed the BW data flow for the business requirement of PIPO.
* Consulting with customers on the requirement and clarification on the fields information
* Developed the objects that are required for the project.
* Coordinating with ABAP folks to develop Logic for PIPO.
* Worked on BSP to load the data to direct DSOs. Worked on Process Chains to automate the loading.
* Worked on generic extractor for 5 source systems and extracted the data to BW side & load the
Cube
* Worked on infosets and multi provider and also worked on Query designer and workbooks.
* Supporting the customer During Unit testing, SIT and BAT.
* Worked on Transports to move TPs across BW landscape.
* Worked on currency conversions and unit of measure conversions.
* Provided Training to Customers during the SIT and BAT on how to test the BW reports.

Project # 3
Company: Hewlett Packard Global Soft India Limited
Role: Senior Consultant
Project Name: Asia/EMEA/NALA/Global Chemicals TOM Enhancements
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: July 2011 - November 2012
Environment: BW 7.3, BWA, BW 7.3 on HANA, Bex Designer Tools, SAP ECC 6.0

Responsibilities:
* Involved in GAP Analysis and Designed the BW data flow for the business requirement of Asia
Chemicals.
* Consulting with customers on the requirement and clarification on the fields information
* Developed the objects that are required for the project.
* Coordinating with ABAP folks to develop Logic for ACTE.
* Worked on Open Hub Destination to send the files to application server.
* Worked on Process Chains to automate the loading and File sending process.
* Worked on Query designer and Web templates and worked in currency conversion logic.
* Worked on Information Broadcasting to send Reports to Users through Email.
* Supporting the customer During Unit testing, SIT and BAT.
* Worked on Transports to move TPs across the BW landscape.
* Worked on Change management process to rollout

Project # 2
Company: Hewlett Packard Global Soft India Limited
Role: Consultant
Project Name: Global APO DP IDF
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: July 2010 - June 2011
Environment: BW 7.0, Bex Designer Tools, SAP APO, Terra Data System

Responsibilities:
* Designed the global IDF solution
* Worked on the cubes, transformations and DTPs along with fiters for each region
* Worked on master data loading process chains
* Worked on CIB interface for the RTF system to APO DP as well as BW systems for the five regions
* Worked only the ABAP programs and improved the performance of the all the IDF project programs
with the help of the ABAPers
* Supporting the customer During Unit testing, SIT and BAT.
* Maintained good co-ordination with the team as well as the RTF team
* Follow-up with the ERP guys to support of change management process.
* Worked on Transports to move Transports across BW landscape.
* Provided Training to Customers during the SIT and BAT on how to test the BW reports.
* Worked on Change management process to rollout the development to Production Box.
* To work on hyper care support once the Project goes live.

Project # 1
Company: Hewlett Packard Global Soft India Limited
Role: Consultant
Project Name: APO DP Global Rollout Wave 1 and Wave 2
Client: Procter and Gamble, Cincinnati (Manufacturing and Retail Business)
Duration: January 2007 - June 2010
Environment: BW 3.X, BW 7.0, BEx Designer Tools, SAP APO

Responsibilities:
* APO DP (Advanced Planner & Optimizer Demand Planning) primarily focuses on forecasting the
demand for the products of P&G based on Historic Data.
* Implemented APO DP for Latin America, North America and Central Europe Region
* Created Info cubes, ODS, Info Sources, data sources.
* Created Transformations DTPs as per requirement with the design.
* Data loads from R/3, APO, Source one (Oracle Database of P&G) and from flat files using PSA. The
data loads for master data as well as transaction data.
* Created various Process Chains for Daily and Weekly Data Loads from Source one & APO and
incorporated in the regional chains.
* Designed various reports using BEx Query Designer.
* Worked on workbook creation and transports.
* Extensively worked on transports Management.
* Successfully trained and handover to SM