SAP BODS consultant with S4 implementation and data migration

* Review Functional Specification and analysis for Load approach to meet the functional
requirement and documentation of Technical Specification
* Development of BODS code with extraction, transformation, Validation and Load
* Coordination with different functional teams to integrate the individual objects and finding
the gaps between the functional requirements.
* Preparing & reviewing test cases, test deliverables, test scenarios & conditions against
business requirements
* Monitoring work progress and conducting Weekly refresh with the team members and validating
the results of all the interfaces

Title: Data Migration
Client: Orkla
Team Size: 15
Modules: Quality Info Records, Master Inspection Characteristics.
Tools: SAP BODS 4.2, Oracle, S4 HANA, LSMW
Period: June 2018 to March 2019
Role: BODS & LSMW Data Migration
Description: Orkla is a leading supplier of branded consumer goods to the grocery, out-of home,
specialised retail, pharmacy and bakery sectors. The Nordic and Baltic regions and
selected countries in Central Europe are Orkla's main markets. The Orkla Group also
holds strong positions in selected product categories in India.
Orkla's Branded Consumer Goods business comprises the Orkla Foods, Orkla Confectionery & Snacks,
Orkla Care and Orkla Food Ingredients business areas. Orkla also has operations
organised under the Orkla Investments business area, consisting of its investment in
Jotun (42.5% interest), in addition to Hydro Power and financial assets.
Implementation of New ERP system based on SAP S/4 Hana as core system, but with several
surrounding systems as part of the IT platform .Integrated processes and common ways
of working across the functional scope: Finance, Sales (only back-office), Product
Development, Planning, Procurement, Logistics and Manufacturing.Common Master data
management capabilities.Shared information and data as a basis for increased
collaboration and efficiency.Modernized user interface and technical platform.Common
definitions, metrics and calculations to provide transparency and increased insight:
Common analytics capabilities.Common Solution Governance mechanisms

Responsibilities:
* Development of BODS and LSMW Program to migrate the data from SAP ECC 6.0 to S4 HANA using
Standard/Customized IDOC/BAPI/Recording.
* Gathering the requirements from Client & interpreting it to Technical Design; assisting the Team
comprehend the Business Requirements
* Raised and tracked defects to closure and Document Creations in SOLMAN (Solution Manager).
* Managing and guiding the team members by assigning the deliverables, Tracking and helping to
deliver within timelines.
* Follow up with Business User/ Functional Experts to provide resolutions on defects/issues raised
by team.
* Providing and maintaining Daily Status update on the team deliverables and proactively raising
concerns on defects/issues.
* Reporting Preload and Post load Error Analysis for Business to cleanse the data.

* Managing and coordinating with the offshore team from Onsite
* Gathering the functional requirements from Client and translating it to Technical Design
* Aiding the Offshore Team comprehend the Business Requirements
* Monitoring work progress and conducting Weekly refresh with the team members and validating
the results of all the interfaces
* Leading Data Migration project from legacy system to SAP system and SAP to S4 HANA System.
* Preparing & reviewing test cases, test deliverables, test scenarios & conditions against
business requirements
* Undertaking activities pertaining to Defect Management and Test Execution in HP ALM 11.0/12.0
* Creating test execution and status reports and sent the same to the stakeholders
* Developing Master Test Plan and Test closure report for the work packages

Title: Data Migration
Client: Reckitt Benckiser
Team Size: 30
Modules: Production Planning (Object: Bill of Material) and Financial Accounting (Objects : GL
Balances, GL Profit and Loss)
Tools: SAP BODS 4.0, Microsoft SQL Server
Period: Dec 2016 to May 2018
Role: BODS Data Migration
Description: Reckitt Benckiser Group plc is a British multinational consumer goods company
headquartered in Slough, England. It is a producer of health, hygiene and home
products. It was formed in 1999 by the merger of the UK-based Reckitt & Colman plc
and the Netherlands-based Benckiser NV.
RB's brands include French's Mustard, the antiseptic brand Dettol, the sore throat medicine
Strepsils, the hair removal brand Veet, the immune support supplement Airborne, the
air freshener Air Wick, Calgon, Clearasil, Cillit Bang, Durex, Lysol, Mycil and
Vanish.
Project is about Migration of Data from JDE system having different modules like MM, FI, PM, PP,
WM, SD to SAP ECC 6.0 system. Reckitt Benckiser project manages Data Migration of
data from JDE system to SAP system. Reckitt Benckiser project is moving the data
from Legacy system to SAP system. There are lots of Transformations and Validations
needed while moving the data from legacy to SAP as the behaviour of both the system
is completely different. The BODS Data Migration Team takes care of the readiness
and cleansing of data before moving the data from Legacy to SAP.
Responsibilities:
* Generating Weekly Data Quality Report which presents the readiness of data for all the Interfaces
corresponding to SAP Tables of Process Area
* Coordinating with the team members on Weekly Refresh and validating the interface results
* Managing the offshore team from Onsite, gathering the requirements from Client & interpreting it
to Technical Design; assisting the Offshore Team comprehend the Business Requirements
* Coaching the team to appreciate and create a Global Approach in the development of BODS
interfaces
* Guided the team in creation of Tools which would help client in cleansing the Data quickly by
sending an Error Analysis Report
* Aided the team in creation of a Test Data Generator which identifies coding defects at the very
Early stage of development
* Performing development of BODS jobs to Merge, validate and transform the data to load it from
Legacy to SAP System
* Developing Stored Procedure and Views which gives field level Data Quality analysis and data
readiness report to the client before loading it into SAP; it also helps the developers to find
the issues in BODS coding.
* Creating Custom Functions for the dynamic Transformation and Validation of Fields for an global
approach of different deployments.
* Creating Stored Procedure and automated Tool for generation of Upstream dependency report.


Highlights:
* Developed Excel based Macros helping the Team to reduce the manual efforts and manual errors in
coding such as Table and View Creation, BODS Script Creation using the Design Document
* Automated
* Process of Sending Daily Data Quality Report using Excel based Macros which helped the
Management to reduce efforts, Time and errors in Manual Calculations and Graphs
* Process of BODS job execution based on Dependencies and timings using Scripts and Scheduling

Title: Loblaw EDW
Client: Loblaw EDW
Team Size: 4 to 20 (variable)
Modules: Apparel Retail and Enterprise planning, BOXI UPGRADE, ESB UPGRADE, Ecommerce, Guiding
Stars, Vendor Income: Track 5, PC Bank, TLOG, Loyalty, Vendor Income: MCH0, GK, P&L
(Profit & Loss)
Tools: SAP BO BI 3.1/4.0/4.1, Teradata, SAP BODS 3.1/4.0/4.2, Unix, MIM, WMB, SAP BW/ECC, BTEQ
Scripts, Oracle, Micro strategy/BOXI Reports, SAS GUI, SAS integrator
Period: Nov-2012 to Dec 2016
Role: ETL/Semantic/Reporting QA/Testing
Description: Loblaw EDW project manages ETL processes, BI reporting and real time services (IVR)
for Loblaw, retail giant in Canada. Loblaw acknowledges that supply chain management
is an essential contributor to operational excellence. The retailer recognized that
inadequacies within its existing supply chain capabilities were preventing it from
effectively serving its customers and delivering value to shareholders. Challenges
were particularly pronounced in three key areas: Transportation, Warehousing,
Forecasting and replenishment.
The project acts as a middleware application (using BODS and WMB for Batch and Real-time
applications and Teradata, Oracle and HANA as Database) taking data to and from the
legacy systems, SAP systems and the stores and transforms the data and loads it into
the Loblaw's Data warehouse from where various Loblaw Business systems access the
transformed loaded data and uses them for different purposes like forecasting,
replenishment, inventory, pricing, payroll, transportation tracking and so on.
Responsibilities:
* Prepared & reviewed test cases, test deliverables, test scenarios & conditions against business
requirements
* Undertook activities pertaining to Defect Management and Test Execution in HP ALM 11.0/12.0
* Created test execution and status reports and sent the same to the stakeholders
* Developed Master Test Plan and Test closure report for the work packages
* Monitored of daily and weekly status Report
* Raised and tracked defects to closure in HP ALM
* Managed Testing Timelines and resources for the completion of modules
* Reported at multiple levels for multiple Modules
* Guided team members in different phases of testing
* Assigned, Managed & Prioritized testing tasks
* Validated
* BODS jobs and data processing from heterogeneous sources (Flat File, SAP BW) to Teradata and
vice versa
* Structure, logic and data in Semantic views against base tables
* Universe objects (dimensions and measures) by creating and delivering BI reports as per
business use cases against semantic views
* BTEQ Script and data processing from one Teradata table to other
* BW extractor and data processing from SAP ECC/ POSDM to SAP BW
* Micro Strategy Reports from SAP ECC through SAP BW, BODS, Teradata semantic View (end-to-end
validation)
* Data for Facts and Dimensional Oracle tables populated from different source tables through
SAS Integrator
* Compared
* Reports Functionality, Performance and Data between older and Newer Versions of BOXI
* MIM Interfaces/WMB interfaces Functionality, Performance and Data between older and Newer
Version with same source file / XML message respectively
* Performed verification of alert Generation and validation of case study created from Alert
Generated in SAS GUI


Sensitivity: Internal & Restricted

Executive Profile

* Performance-focused leader with experience in various projects, driving the execution of data
warehousing & data migration activities
* Technical expertise in full life cycle implementation including Analysis, Requirements gathering,
Development, Testing, Reporting, Go-live and Post Go-live support
* Showcased excellent aptitude in management of complex technology projects and multiple
stakeholders, priorities, escalations & risks throughout the project lifecycle; recognized for
customer satisfaction
* A team player with strong communication, analytical, logical & problem-solving skills; capacity
to work under pressure situations and meet deadlines; awarded for coordination from Onsite and
Successful Go Live