BO/BODS Developer
Keywords
Data Migration
Data Warehousing
SAP Applications
Data Management
Data Analysis
Architecture
Business Intelligence
Profiling
Extract Transform Load (ETL)
Data Quality
Skills
- Strong Practical knowledge of Analysis, Design and Development of various Data Migration, Data Warehousing (Business Intelligence) & Data Quality projects using various SAP tools like BO BODS, IS etc..
- Strong in defining & Implementing Master data strategies for Data Migration and other Data management projects.
- Strong in ETL process using various tools (BODS, Informatica, SSIS, Talend).
- Strong background in Data Migration with experience on a number of full life cycles, including Extraction, Cleaning, Transformation, Remediation, mapping, reconciliation & execution.
- Strong in Data Analysis, Governance, Cleaning, Quality, Profiling & Remediation.
- Strong technical expertise in Data Objects like Sales, Purchase, Material, Finance, HR, Customer etc...
- Strong understanding of OLAP Data warehouse concepts, Architecture, Dimensional Data Model, Star Schema, Snowflake Schema.
Project history
03/2024
-
03/2024
warehouse and associated data marts for their Contract Management and Fleet management systems.
Responsibilities:
* Assisting in the design of the migration from legacy systems to existing SAP contract
management system (CMS).
* Analyse Legacy systems data, perform Extraction, Loading, Cleansing and Transformation.
* Preparing data for migration.
* Developing the data warehouse and associated data marts.
* Developed several template data services jobs, custom functions, scripts to be re-used across
different layers.
* Managing and Monitoring data loads with full update and delta mechanism and optimized the
performance by adjusting data selections.
* Extracting & Transforming data from SAP CMS into staging and data warehouse databases using
Open Hub technology.
* Resolving Production technical issues.
* Developing new Universe and Web Intelligence reports.
* Live Application Support.
* Designed & Developed BO universe on BW(BI) Cubes.
* Creation of Webi / Deski Reports based on Report requirements.
* Created classes and objects and logically grouped them together and defined business names for
the classes and objects.
* The data was represented in the form of dimensions, details and measures for usage in
universes and documents and filtered according to the business needs.
* Implemented contexts and aliases as a method of avoiding loops in the database design.
Responsibilities:
* Assisting in the design of the migration from legacy systems to existing SAP contract
management system (CMS).
* Analyse Legacy systems data, perform Extraction, Loading, Cleansing and Transformation.
* Preparing data for migration.
* Developing the data warehouse and associated data marts.
* Developed several template data services jobs, custom functions, scripts to be re-used across
different layers.
* Managing and Monitoring data loads with full update and delta mechanism and optimized the
performance by adjusting data selections.
* Extracting & Transforming data from SAP CMS into staging and data warehouse databases using
Open Hub technology.
* Resolving Production technical issues.
* Developing new Universe and Web Intelligence reports.
* Live Application Support.
* Designed & Developed BO universe on BW(BI) Cubes.
* Creation of Webi / Deski Reports based on Report requirements.
* Created classes and objects and logically grouped them together and defined business names for
the classes and objects.
* The data was represented in the form of dimensions, details and measures for usage in
universes and documents and filtered according to the business needs.
* Implemented contexts and aliases as a method of avoiding loops in the database design.
06/2019
-
11/2022
Senior SAP BO/BODS Consultant
Birchman group
Technologies/Environment SAP BOE 4.2, BODS 4.2, SAP SD, MM, FI/CO, SuccessFactors, S/4 HANA, S4 migration cockpit,LTMC, SAP
Analytical Cloud, Azure Cloud, BW, Information Steward(IS) 4.2, SQL Server, Oracle.
Duration June'19 to Nov'22
Employed as SAP BODS Consultant to help Birchman's clients in S/4 HANA migration and BI projects.
Responsibilities:
* Monitor, coordinate and respond to support incidents as per SLA's.
* Provide analysis of system defects as and when required.
* Develop and Implementation of ongoing change requests for ETL, Data Quality and Reporting
requirements.
* Responsible for S/4 HANA migration objects like SD, MM, FI, WM etc.
* Design and Development of BO dashboards and reports.
* Undertake root cause analysis and problem investigation.
* Liaise / promote and foster good working relationships with clients.
* Understand / adhere to quality / security standards and processes applicable to the role.
* Create and maintain technical documentation and contribute to project deliverables where
applicable.
Analytical Cloud, Azure Cloud, BW, Information Steward(IS) 4.2, SQL Server, Oracle.
Duration June'19 to Nov'22
Employed as SAP BODS Consultant to help Birchman's clients in S/4 HANA migration and BI projects.
Responsibilities:
* Monitor, coordinate and respond to support incidents as per SLA's.
* Provide analysis of system defects as and when required.
* Develop and Implementation of ongoing change requests for ETL, Data Quality and Reporting
requirements.
* Responsible for S/4 HANA migration objects like SD, MM, FI, WM etc.
* Design and Development of BO dashboards and reports.
* Undertake root cause analysis and problem investigation.
* Liaise / promote and foster good working relationships with clients.
* Understand / adhere to quality / security standards and processes applicable to the role.
* Create and maintain technical documentation and contribute to project deliverables where
applicable.
09/2016
-
05/2019
Lead SAP Data Consultant
Camelot (National Lottery)
Technologies/Environment BODS 4.2, BOE 4.2, Information Steward(IS) 4.2, ECC 6.0, S/4 HANA, MS SQL,DB2, Sybase IQ, Tableau,
Azure, Hadoop, AWS, Talend Big data platform 6.3.1, JIRA
Duration Sep'16 to May'19
Employed as BI Consultant for Data Migration and BI projects.
Responsibilities:
* Perform data analysis on migrating digital sales data into new trading platform and other
projects.
* Responsible for technical and object mapping documents and liaising with functional users to
close the mapping gaps.
* Data extraction from Social media sites and processing.
* Implement BODS routines and scripts to support the data migration process.
* Involved in Big data platform migration and Master data management.
* Implemented SAP Business Objects source setup on AWS EMR.
* Perform business rules validation and unit testing to resolve any logical issues.
* Supporting the UAT and completion process for final phase of project deliverables.
Azure, Hadoop, AWS, Talend Big data platform 6.3.1, JIRA
Duration Sep'16 to May'19
Employed as BI Consultant for Data Migration and BI projects.
Responsibilities:
* Perform data analysis on migrating digital sales data into new trading platform and other
projects.
* Responsible for technical and object mapping documents and liaising with functional users to
close the mapping gaps.
* Data extraction from Social media sites and processing.
* Implement BODS routines and scripts to support the data migration process.
* Involved in Big data platform migration and Master data management.
* Implemented SAP Business Objects source setup on AWS EMR.
* Perform business rules validation and unit testing to resolve any logical issues.
* Supporting the UAT and completion process for final phase of project deliverables.
05/2016
-
08/2016
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).
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).
04/2015
-
04/2016
Senior SAP Data Migration Consultant
Kontron Europe GmbH
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.
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.
02/2014
-
11/2014
Senior SAP BODS Consultant
SportScheck(OTTO Group)
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.
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.
10/2013
-
01/2014
Senior SAP BODS (BODI) Developer
InHealth
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.
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.
03/2013
-
10/2013
SAP BODS Developer
BBC
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.
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.
06/2011
-
02/2013
SAP BODS(BODI) Consultant
The Daily Telegraph
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.
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.
05/2009
-
05/2011
SAP BODS(BODI) Developer
Volkswagen Financial Services
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
Duration May'2009 to May'11
01/2008
-
04/2009
SAP BO Developer
Home Retail Group (Argos & Homebase)
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.
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.
02/2004
-
12/2007
SAP BW Developer
Motability
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.
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.
Local Availability
Open to travel worldwide
