Senior SAP BO/BODS Consultant, Lead SAP Data Consultant, Lead SAP BODS/Migration Consultant

Client National Grid, Hinckley (through AgilityWorks)
Role Lead SAP BODS/Migration Consultant
Technologies/Environment SAP S/4 HANA, BODS 4.2, BO 4.2, Information Steward (IS) 4.2,Information tool, Webi, SAP IS-Oil, PM
, Oracle 11g
Duration May'16 to Aug'2016

Employed as SAP BODS Consultant for IDQ project (Data Quality).
Responsibilities:
* Responsible for preparing Technical design spec.
* Data extraction using SAP DS from SAP ECC, ESRI application database (Oracle).
* Database views design and development for SAP Information Steward (IS) rules.
* IS Rules development.
* Development of Data Quality dashboard/reports design and Development (Webi).

Technologies/Environment SAP BODS 4.2, BO 4.2, Information Steward 4.2, Back Office Associates (DS Migration Accelerator,
Information Steward Accelerator), GOS, SAP SD, MM, WM, FI(O2C,P2P)
Duration April'15 to April'16

Employed as SAP BODS Consultant for a Large Global SAP Implementation project (Data Migration).
Responsibilities:
* Responsible for preparing functional/Technical design specs and Field Mapping Documents.
* Work with business data owners to process map operational procedures for cleaning against
source data from multiple systems.
* Pre-mapping Analysis, Data profiling, Data cleansing & Transformation.
* ETL Job(s) design, development and testing.
* Loading data to SAP using IDOCs and LSMW/LTMC.
* BODS Jobs maintenance and Scheduling.
* Reporting(Migration): Business Objects Universe, Webi reports, Dashboards design and
Development.
* Work with and support the program team during test/UAT project phases on all aspects of data,
conversion, pre/post load validation and sign-off.
Client Agilityworks, UK (End clients: Vodafone, Camelot, GSK Pharma)
Role Senior SAP BODS Consultant
Technologies/Environment SAP BODS 4.2, BO 4.2, Information Steward 4.2, SAP SD, MM, HR, SRM, SAP MDM, SAP BI, S/4 HANA,
Oracle 11g , Sybase, SQL Server.
Duration Oct'14 to April'15

Employed as SAP BODS Consultant to work for their end clients Vodafone, GSK (GlaxoSmithKline) and
Camelot (National Lottery) in SAP Data Migration, Business Intelligence (DWH) & Data Quality
projects.

Responsibilities:
* Responsible for gathering requirements and preparing functional/Technical design specs and
Field Mapping Documents.
* Premapping Analysis, Data profiling etc.
* SAP BODS upgrade for one of Camelot projects.
* Data Quality Management and Information Governance prior to Migration.
* BODS Batch and Real Time jobs design and development.
* Jobs Maintenance and Scheduling.
* BI Reports: Business Objects Universe, Webi reports, Dashboard design and Development.

Technologies/Environment SAP BODS 4.1,BO 4.1, Information Steward 4.1, SAP IS-Retail, SD, MM, FI,WM,SCM, CRM, MS SQL Server
2008
Duration Feb'14 to Nov'2014

Employed as Senior SAP BODS Consultant for STORM Data Migration project.
Responsibilities:
* Responsible for gathering requirements and prepare design and mapping documents.
* Analyze source data and fix the issues before migration.
* Design and Development of ETL jobs for Article Master, Customer Master, Inventory, PO, Sales
Order, Finance (FI)data migration.
* Sending data to SAP ECC through IDocs.
* Transfer data to SAP ECC using RFC from SAP Data Services.
* Reviewing others ETL jobs and UNIT testing.
* SAP BO Universe design and development and Webi reports development.

Technologies/Environment SAP BODS3.2,BOXI 3.2, MS SQL Server 2000/03/05/08, Oracle, SalesForce CRM, Flat files
Duration Oct'13 to Jan'14

Employed as SAP BODS Developer to develop a data warehouse and associated data marts for KIMERA
project.
Responsibilities:
* Responsible for gathering requirements and prepare design documents and mapping documents.
* Analyze and interpret complex data on target systems.
* Design and Development of ETL jobs which includes reusable Data flows and Custom functions.
* Jobs scheduling and Maintenance.
* BO Universe design and development.
* Helping in fixing some production issues and BAU issues.

Technologies/Environment SAP BODS4.0, BOXI 4.0, BI(BW) 7.0, Information Steward 4.0, FI, SD, Oracle 11g, MS SQL Server
2000/03, HP ALM
Duration March'13 to Oct'13

Employed as SAP BODS developer to work on Data Migration and Data warehouse projects.
Responsibilities:
* Coordinate with ETL team to implement ETL procedures for all new projects and maintain
effective awareness of production activities according to required standards and provide
support to all existing applications.
* Responsible for gathering requirements and created design documents and mapping documents.
* Worked extensively with Sales, Finance teams to design data migration from Legacy system to
SAP.
* Configured the Data services to connect to the SAP R/3, BI and Loaded data to SAP BW.
* Analyze and interpret complex data on target systems.
* Design and Development of reusable Data flows.
* Development of BO Universe for new RDM reports.
* Provide support to Jobs schedule and maintain compliance to same.
* Solving moderately complex issues in target data architecture design processes (e.g. data
management process modeling, data entity matrix design).
* Document all test procedures for systems and processes.
* Coordinate with business analysts and users to resolve all requirement issues and maintain
quality for same.
* Guides junior staff on considerations in the design of architecture building blocks.

Technologies/Environment SAP BO12.5, BODS3.2/4.0, MYSQL 5.1,MS SQL Server 2005/8,Oracle 10i/11g, Salesforce , InterSystems
Cache DB.
Duration June'11 to Feb'13

Employed as SAP BODS Consultant to develop a data warehouse and associated data marts for
ProjectPlane,Ad's and CH Projects (Data Migration).
Responsibilities:
* Installation and Configuration of SAP BODS/BO Server and Client.
* Gathering Requirements from Customer/Client and preparation of Technical spec.
* Designing of the Migration from legacy systems to MYSQL server database.
* Analyse Legacy systems data, Development of extract, transform and load routines.
* Maintenance of SAP Data Services data flows.
* Tuning of SDS workflows.
* Developing several data marts, Reusable Objects, Scripts and Custom-Functions.
* Managing and Monitoring data loads with full update and delta mechanism and optimised the
performance by adjusting data selections.
* End to End development and interpret the requirements.
* Development of Informatica jobs in SAP BODS.
* Production Technical Support on ETL jobs and BO reports.
* Providing technical help and reviewing other developers work.
* Design and Develop a New Universe as per client requirements.
* Provide training and technical help to junior staff and other colleagues.
* Manage off-shore & on-site team and provide necessary support.

Technologies/Environment SAP ECC 6, BI (BW) 7.0, SAP BO3.1, BODS3.2,CRM,CMS,FI, Oracle 10g,TOAD
Duration May'2009 to May'11

Technologies/Environment SAP BW (BI) 7.0, BO, SD, MM, SCM, SRM,EPOS, Oracle, SQL Server 05.
Duration Jan '08 - April' 2009

Employed as a Business Objects Developer to develop Data Warehouse reports.
Responsibilities:
* Analyse business requirement and drill downs required for development of the project
* Design & Creation of Universes required to get the data in the desired format to get
published.
* Customizing new reports using Business Objects functionalities like queries, slice and dice,
drill down, cross tab, master detail reports, formulas, etc.
* Staging the data for cleaning & accuracy from the production server to warehouse at a schedule
time with the help of stored procedures.
* Standardizing the reports by minimizing the manual intervention with the help of stores
procedures & Packages.
* Designing the Sales & Purchase BO reports' Layouts as per user requirements.
* Identifying the Scope of the reports as per the respective region.
* Identifying the data sources required to generate the high level business performance report.
* Designing the database & Normalizing different tables into a standard data structure.
* Due to heavy size of the databases of difference sources, table partitions have been used to
enable quick processing of queries.
* Merging different tables into a single materialized view to keep up the pace.
* Cleaning the data as per the required format with the help of cursors on daily basis.

Technologies/Environment SAP BW 3.5, BEx, SQL Server 2000/05.
Duration Feb'04 - Dec'2007

Responsibilities:
* Extracted transaction data from SAP R/3, using Generic extractors.
* Multidimensional Data Model using Extended Star Schema, Developed Info cubes, ODS, Info Source
and Data Source.
* Created, Start Routines, Transfer rules and Update rules for Info Sources and Info Cubes.
* Provided support for data load, validation, performance monitoring and tuning.
* Involved in troubleshooting data load in the information supply chain to enable successful
implementation.
* Creation of DataSources for attributes, texts and hierarchies
* Data modelling and implementation of InfoObjects
* Support at data corrections of ODS objects and InfoCubes.
* Development of transfer and update rules in ODS objects and InfoCubes.
* Creation of transformations and Data Transfer Processes (DTP).
* Preparation of Infosets, Service InfoCubes and Multiprovider (MP).
* BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.
* Created queries with Variables, Filters, conditions, and Restricted & Calculated Key figure.
* Developed BEx Reports for Various reports.