Data Migration, Business Intelligence,Quality,SAP BODS, Design Studio, Universe, WEBI, Information Steward.Oracle, MS SQL Server,DB2, Big Data, Hadoop
Aktualisiert am 04.03.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 11.03.2024
Verfügbar zu: 100%
davon vor Ort: 100%
SAP BusinessObjects Data Services
SAP BusinessObjects Web Intelligence
S/4HANA
SAP
Cloud Computing
AWS
Azure
MS SQL Server
SQL
SAP Datenmigration
SAP BusinessObjects
Google Cloud Vision API
amazon Redshift
cloud
sap analytics cloud
SAP Analytics cloud
English

Einsatzorte

Einsatzorte

copenhagen (+200km) denmark (+200km)
Deutschland, Österreich, Schweiz
möglich

Projekte

Projekte

1 Jahr 4 Monate
2022-11 - heute

help one of SAP clients (EASA) in Data Migration and BI projects

Lead SAP Data Migration Consultant, SAP BO/BODS Consultant  SAP BOE 4.2 BODS 4.2 S/4 HANA ...
Lead SAP Data Migration Consultant, SAP BO/BODS Consultant 

  • Requirements gathering, preparation of technical design document for Data Migration ( to S/4 HANA) and BI projects
  • Design and Development of ETL data pipelines
  • Design and Development of New BO Webi dashboards and reports
  • Rebuilt Power BI reports in SAP Business Objects Webi
  • Undertake root cause analysis and problem investigation

SAP BOE 4.2 BODS 4.2 S/4 HANA SQL Server SAP Syniti SAP ECC Power BI
EASA
Cologne
3 Jahre 6 Monate
2019-06 - 2022-11

help Birchman?s clients in S/4 HANA migration and BI projects

Senior SAP BO/ BODS Consultant SAP BOE 4.2 BODS 4.2 S/4 HANA ...
Senior SAP BO/ BODS Consultant

  • 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

SAP BOE 4.2 BODS 4.2 S/4 HANA S4 migration cockpit SAP Analytical Cloud BW Information Steward(IS) 4.2 SQL Server Oracle
Birchman group,
UK
2 Jahre 9 Monate
2016-09 - 2019-05

Data Migration and BI projects

Lead SAP Data Consultant, BI Consultant BODS 4.2 BOE 4.2 Information Steward(IS) 4.2 ...
Lead SAP Data Consultant, BI Consultant
  • 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
  • Identify and resolve data quality issues around master and transactional data
  • Perform business rules validation and unit testing to resolve any logical issues
  • Supporting the UAT and completion process for final phase of project deliverables
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
Camelot (National Lottery)
Watford
4 Monate
2016-05 - 2016-08

IDQ project (Data Quality)

Lead SAP BODS/Migration Consultant, SAP BODS Consultant SAP S/4 HANA BODS 4.2 BO 4.2 ...
Lead SAP BODS/Migration Consultant, SAP BODS Consultant

  • 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)

SAP S/4 HANA BODS 4.2 BO 4.2 Information Steward (IS) 4.2 Information tool Webi SAP IS-Oil PM Oracle 11g
National Grid
Hinckley
1 Jahr 1 Monat
2015-04 - 2016-04

Large Global SAP Implementation project (Data Migration)

SAP BODS Consultant  SAP BODS 4.2 BO 4.2 Information Steward 4.2 ...
SAP BODS Consultant 
  • 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

SAP BODS 4.2 BO 4.2 Information Steward 4.2 Back Office Associates (DS Migration Accelerator; Information Steward Accelerator) SAP SD MM WM FI (O2C P2P)
Kontron Europe GMBH
Germany
7 Monate
2014-10 - 2015-04

SAP Data Migration, Business Intelligence (DWH) & Data Quality projects

Senior SAP BODS Consultant SAP BODS 4.2 BO 4.2 Information Steward 4.2 ...
Senior SAP BODS Consultant

  • 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

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
Vodafone, GSK Pharma (GlaxoSmithKline) and Camelot (National Lottery)
10 Monate
2014-02 - 2014-11

STORM Data Migration project

Senior SAP BODS Consultant SAP BODS 4.1 BO 4.1 Information Steward 4.1 ...
Senior SAP BODS Consultant

  • 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

SAP BODS 4.1 BO 4.1 Information Steward 4.1 SAP IS-Retail SD MM FI WM SCM CRM MS SQL Server 2008
SportScheck (OTTO Group)
Germany (Retail Client)
4 Monate
2013-10 - 2014-01

develop a data warehouse and associated data marts for KIMERA project

Senior SAP BODS (BODI) Developer SAP BODS3.2 BOXI 3.2 MS SQL Server 2000/03/05/08 ...
Senior SAP BODS (BODI) Developer

  • 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

SAP BODS3.2 BOXI 3.2 MS SQL Server 2000/03/05/08 Oracle SalesForce CRM Flat files
InHealth
High Wycombe
8 Monate
2013-03 - 2013-10

Data Migration and Data warehouse projects

SAP BODS Developer SAP BODS4.0 BOXI 4.0 BI(BW) 7.0 ...
SAP BODS Developer

  • 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

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
BBC
London
1 Jahr 9 Monate
2011-06 - 2013-02

develop a data warehouse and associated data marts

SAP BODS (BODI) Consultant SAP BO12.5 BODS3.2/4.0 MYSQL 5.1 ...
SAP BODS (BODI) Consultant

develop a data warehouse and associated data marts for ProjectPlane,Ad?s and CH Projects (Data Migration)

  • 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
SAP BO12.5 BODS3.2/4.0 MYSQL 5.1 MS SQL Server 2005/8 Oracle 10i/11g Salesforce InterSystems Cache DB
The Daily Telegraph
London
2 Jahre 1 Monat
2009-05 - 2011-05

develop data warehouse and associated data marts

SAP BODS(BODI) Developer SAP ECC 6 BI (BW) 7.0 SAP BO3.1 ...
SAP BODS(BODI) Developer

develop a data warehouse and associated data marts for their Contract Management and Fleet management systems

  • 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
SAP ECC 6 BI (BW) 7.0 SAP BO3.1 BODS3.2 CRM CMS FI Oracle 10g TOAD
Volkswagen Financial Services
Milton Keynes
1 Jahr 4 Monate
2008-01 - 2009-04

develop Data Warehouse reports

SAP BO Developer, Business Objects Developer SAP BW (BI) 7.0 BO SD ...
SAP BO Developer, Business Objects Developer

  • 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

SAP BW (BI) 7.0 BO SD MM SCM SRM EPOS Oracle SQL Server 05
Home Retail Group (Argos & Homebase)
Wallington
3 Jahre 11 Monate
2004-02 - 2007-12

Extracted transaction data from SAP R/3

SAP BW Developer SAP BW 3.5 BEx SQL Server 2000/05
SAP BW Developer

  • 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

SAP BW 3.5 BEx SQL Server 2000/05
Motability (Financial Services)
London

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 5 Monate
1996-06 - 2000-10

Bachelors in Computer Science

Management Information Systems and Computer applications, Kakatiya University, India
Management Information Systems and Computer applications
Kakatiya University, India

Position

Position

SAP Data Migration/ BI Consultant

Kompetenzen

Kompetenzen

Top-Skills

SAP BusinessObjects Data Services SAP BusinessObjects Web Intelligence S/4HANA SAP Cloud Computing AWS Azure MS SQL Server SQL SAP Datenmigration SAP BusinessObjects Google Cloud Vision API amazon Redshift cloud sap analytics cloud SAP Analytics cloud

Aufgabenbereiche

SDLC

Produkte / Standards / Erfahrungen / Methoden

Apache Hadoop
Big Data Analytics
BO Universe
BusinessObjects Design Studio
Data quality
HANA
HDFS
MapReduce
sap bo
sap bods
SAP BODS, IS
SAP BusinessObjects
SAP BusinessObjects Data Services
sap information Steward
sap IS
Webi
Profile:
  • Highly motivated and proactive IT Professional with a breadth of experience in Software industry for more than 19+ years, which includes over 15+ years of experience in Business Intelligence (Data Warehouse), Data Migration & Data Quality using Business Objects tools( BO/BOXI, Data Integrator(BODI) / Data Services (BODS), Information Steward)
  • Proven ability to organise and plan project work meeting critical deadlines in a fast paced environment
  • Continuously building on knowledge and skills by taking a proactive approach to unfamiliar areas of work. Now seeking an opportunity to utilise my experience in a challenging team based environment


Professional Summary:

  • 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 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
  • Strong Practical experience of Installation, Configuration, Upgrade and Administration of SAP BO/ BODS Server
  • Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization Improved data load and query performance using Compression, Aggregates, Partitioning and Indexing of Info cubes and use of statistics for same
  • Good Practical experience of SAP BODS software upgrade and jobs migration to higher level versions
  • Strong Practical experience in BI Reporting using Business Objects tool - Universe Designer, Web Intelligence (Webi), Desktop Intelligence (Deski), Dashboard Reports, Xcelsius 2008, Live Office
  • SAP BW/BI Operations - Good knowledge in Design/Implementation, Data Load Management (Extractions), Process Chain, Open Hub technology and Reporting
  • Expertise in MDM extended star schema including InfoCube design, DSO design, Info Objects, Info Sources, Transfer, Update rules/Transformations
  • Good working knowledge of Information Steward & BackOffice - DS Migration Accelerator and IS Accelerator.
  • Good knowledge of SAP Analytics Cloud
  • Expertise in developing Shell Scripts, PL/SQL Queries and Stored Procedures, and Triggers to ensure the successful execution of the ETL processes
  • Practical experience of SAP LSMW/LTMC, IDoc?s, RFC?s
  • Good experience of using REST Web Service in BODS to extract the data from Social media sites, SharePoint
  • Practical experience of migration of data from legacy systems to SAP S/4 HANA
  • Good functional knowledge of SAP ECC (ERP) modules (SD, MM, WM, FICO (O2C,P2P), CRM, HR etc..)
  • Capable of understanding the business environment and translate business requirements into technical solutions
  • Expert in documenting business requirements, functional, technical specifications and test cases
  • Good Knowledge and Experience of various Software Methodologies like Software Development Life Cycle (SDLC), V-model, Agile (XP, SCRUM) and Waterfall models
  • Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and can work as a part of a team as well as independently


Technical:

SAP BW (BI) 7.0, SAP BO, BODS (BODI) 3.X/4.0/4.1/4.2,S/4 HANA Cloud, Information Steward 4.2, BackOffice(DSP), Informatica, MS BI(SSIS,SSRS), Talend 6.3


Functional:

SAP SD, MM, SCM, CMS,CRM, HR and FI/CO(R2R,P2C,O2C), SalesForce Cloud


Reporting tools:

SAP-Bex, BO/BOXI 3.X, 4.X (Webi Reports), SAP Analytical Cloud,Tableau, Crystal Reports 2008, Xcelsius, Microsoft Power BI


Cloud Technologies:

AWS S3, Redshift, GCP BigQuery, Cloudera, Azure, Snowflake

Betriebssysteme

MS-DOS
MS WINDOWS
98/ NT/ XP, Server 2000/ 2003/ 2005
UNIX
Linux

Programmiersprachen

C++
HTML
Python
VB
Java
ABAP/4
C

Datenbanken

Data modelling
DB2
DB2 Query Management Facility
HANA
MS SQL Server
MySQL
SAP Sybase IQ
Talend
Azure
Sybase
ORACLE
8i/ 9i/ 10i/ 11g
SQL Server
2000/ 03/ 05/ 08

Datenkommunikation

Hive

Einsatzorte

Einsatzorte

copenhagen (+200km) denmark (+200km)
Deutschland, Österreich, Schweiz
möglich

Projekte

Projekte

1 Jahr 4 Monate
2022-11 - heute

help one of SAP clients (EASA) in Data Migration and BI projects

Lead SAP Data Migration Consultant, SAP BO/BODS Consultant  SAP BOE 4.2 BODS 4.2 S/4 HANA ...
Lead SAP Data Migration Consultant, SAP BO/BODS Consultant 

  • Requirements gathering, preparation of technical design document for Data Migration ( to S/4 HANA) and BI projects
  • Design and Development of ETL data pipelines
  • Design and Development of New BO Webi dashboards and reports
  • Rebuilt Power BI reports in SAP Business Objects Webi
  • Undertake root cause analysis and problem investigation

SAP BOE 4.2 BODS 4.2 S/4 HANA SQL Server SAP Syniti SAP ECC Power BI
EASA
Cologne
3 Jahre 6 Monate
2019-06 - 2022-11

help Birchman?s clients in S/4 HANA migration and BI projects

Senior SAP BO/ BODS Consultant SAP BOE 4.2 BODS 4.2 S/4 HANA ...
Senior SAP BO/ BODS Consultant

  • 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

SAP BOE 4.2 BODS 4.2 S/4 HANA S4 migration cockpit SAP Analytical Cloud BW Information Steward(IS) 4.2 SQL Server Oracle
Birchman group,
UK
2 Jahre 9 Monate
2016-09 - 2019-05

Data Migration and BI projects

Lead SAP Data Consultant, BI Consultant BODS 4.2 BOE 4.2 Information Steward(IS) 4.2 ...
Lead SAP Data Consultant, BI Consultant
  • 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
  • Identify and resolve data quality issues around master and transactional data
  • Perform business rules validation and unit testing to resolve any logical issues
  • Supporting the UAT and completion process for final phase of project deliverables
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
Camelot (National Lottery)
Watford
4 Monate
2016-05 - 2016-08

IDQ project (Data Quality)

Lead SAP BODS/Migration Consultant, SAP BODS Consultant SAP S/4 HANA BODS 4.2 BO 4.2 ...
Lead SAP BODS/Migration Consultant, SAP BODS Consultant

  • 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)

SAP S/4 HANA BODS 4.2 BO 4.2 Information Steward (IS) 4.2 Information tool Webi SAP IS-Oil PM Oracle 11g
National Grid
Hinckley
1 Jahr 1 Monat
2015-04 - 2016-04

Large Global SAP Implementation project (Data Migration)

SAP BODS Consultant  SAP BODS 4.2 BO 4.2 Information Steward 4.2 ...
SAP BODS Consultant 
  • 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

SAP BODS 4.2 BO 4.2 Information Steward 4.2 Back Office Associates (DS Migration Accelerator; Information Steward Accelerator) SAP SD MM WM FI (O2C P2P)
Kontron Europe GMBH
Germany
7 Monate
2014-10 - 2015-04

SAP Data Migration, Business Intelligence (DWH) & Data Quality projects

Senior SAP BODS Consultant SAP BODS 4.2 BO 4.2 Information Steward 4.2 ...
Senior SAP BODS Consultant

  • 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

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
Vodafone, GSK Pharma (GlaxoSmithKline) and Camelot (National Lottery)
10 Monate
2014-02 - 2014-11

STORM Data Migration project

Senior SAP BODS Consultant SAP BODS 4.1 BO 4.1 Information Steward 4.1 ...
Senior SAP BODS Consultant

  • 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

SAP BODS 4.1 BO 4.1 Information Steward 4.1 SAP IS-Retail SD MM FI WM SCM CRM MS SQL Server 2008
SportScheck (OTTO Group)
Germany (Retail Client)
4 Monate
2013-10 - 2014-01

develop a data warehouse and associated data marts for KIMERA project

Senior SAP BODS (BODI) Developer SAP BODS3.2 BOXI 3.2 MS SQL Server 2000/03/05/08 ...
Senior SAP BODS (BODI) Developer

  • 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

SAP BODS3.2 BOXI 3.2 MS SQL Server 2000/03/05/08 Oracle SalesForce CRM Flat files
InHealth
High Wycombe
8 Monate
2013-03 - 2013-10

Data Migration and Data warehouse projects

SAP BODS Developer SAP BODS4.0 BOXI 4.0 BI(BW) 7.0 ...
SAP BODS Developer

  • 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

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
BBC
London
1 Jahr 9 Monate
2011-06 - 2013-02

develop a data warehouse and associated data marts

SAP BODS (BODI) Consultant SAP BO12.5 BODS3.2/4.0 MYSQL 5.1 ...
SAP BODS (BODI) Consultant

develop a data warehouse and associated data marts for ProjectPlane,Ad?s and CH Projects (Data Migration)

  • 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
SAP BO12.5 BODS3.2/4.0 MYSQL 5.1 MS SQL Server 2005/8 Oracle 10i/11g Salesforce InterSystems Cache DB
The Daily Telegraph
London
2 Jahre 1 Monat
2009-05 - 2011-05

develop data warehouse and associated data marts

SAP BODS(BODI) Developer SAP ECC 6 BI (BW) 7.0 SAP BO3.1 ...
SAP BODS(BODI) Developer

develop a data warehouse and associated data marts for their Contract Management and Fleet management systems

  • 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
SAP ECC 6 BI (BW) 7.0 SAP BO3.1 BODS3.2 CRM CMS FI Oracle 10g TOAD
Volkswagen Financial Services
Milton Keynes
1 Jahr 4 Monate
2008-01 - 2009-04

develop Data Warehouse reports

SAP BO Developer, Business Objects Developer SAP BW (BI) 7.0 BO SD ...
SAP BO Developer, Business Objects Developer

  • 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

SAP BW (BI) 7.0 BO SD MM SCM SRM EPOS Oracle SQL Server 05
Home Retail Group (Argos & Homebase)
Wallington
3 Jahre 11 Monate
2004-02 - 2007-12

Extracted transaction data from SAP R/3

SAP BW Developer SAP BW 3.5 BEx SQL Server 2000/05
SAP BW Developer

  • 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

SAP BW 3.5 BEx SQL Server 2000/05
Motability (Financial Services)
London

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 5 Monate
1996-06 - 2000-10

Bachelors in Computer Science

Management Information Systems and Computer applications, Kakatiya University, India
Management Information Systems and Computer applications
Kakatiya University, India

Position

Position

SAP Data Migration/ BI Consultant

Kompetenzen

Kompetenzen

Top-Skills

SAP BusinessObjects Data Services SAP BusinessObjects Web Intelligence S/4HANA SAP Cloud Computing AWS Azure MS SQL Server SQL SAP Datenmigration SAP BusinessObjects Google Cloud Vision API amazon Redshift cloud sap analytics cloud SAP Analytics cloud

Aufgabenbereiche

SDLC

Produkte / Standards / Erfahrungen / Methoden

Apache Hadoop
Big Data Analytics
BO Universe
BusinessObjects Design Studio
Data quality
HANA
HDFS
MapReduce
sap bo
sap bods
SAP BODS, IS
SAP BusinessObjects
SAP BusinessObjects Data Services
sap information Steward
sap IS
Webi
Profile:
  • Highly motivated and proactive IT Professional with a breadth of experience in Software industry for more than 19+ years, which includes over 15+ years of experience in Business Intelligence (Data Warehouse), Data Migration & Data Quality using Business Objects tools( BO/BOXI, Data Integrator(BODI) / Data Services (BODS), Information Steward)
  • Proven ability to organise and plan project work meeting critical deadlines in a fast paced environment
  • Continuously building on knowledge and skills by taking a proactive approach to unfamiliar areas of work. Now seeking an opportunity to utilise my experience in a challenging team based environment


Professional Summary:

  • 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 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
  • Strong Practical experience of Installation, Configuration, Upgrade and Administration of SAP BO/ BODS Server
  • Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization Improved data load and query performance using Compression, Aggregates, Partitioning and Indexing of Info cubes and use of statistics for same
  • Good Practical experience of SAP BODS software upgrade and jobs migration to higher level versions
  • Strong Practical experience in BI Reporting using Business Objects tool - Universe Designer, Web Intelligence (Webi), Desktop Intelligence (Deski), Dashboard Reports, Xcelsius 2008, Live Office
  • SAP BW/BI Operations - Good knowledge in Design/Implementation, Data Load Management (Extractions), Process Chain, Open Hub technology and Reporting
  • Expertise in MDM extended star schema including InfoCube design, DSO design, Info Objects, Info Sources, Transfer, Update rules/Transformations
  • Good working knowledge of Information Steward & BackOffice - DS Migration Accelerator and IS Accelerator.
  • Good knowledge of SAP Analytics Cloud
  • Expertise in developing Shell Scripts, PL/SQL Queries and Stored Procedures, and Triggers to ensure the successful execution of the ETL processes
  • Practical experience of SAP LSMW/LTMC, IDoc?s, RFC?s
  • Good experience of using REST Web Service in BODS to extract the data from Social media sites, SharePoint
  • Practical experience of migration of data from legacy systems to SAP S/4 HANA
  • Good functional knowledge of SAP ECC (ERP) modules (SD, MM, WM, FICO (O2C,P2P), CRM, HR etc..)
  • Capable of understanding the business environment and translate business requirements into technical solutions
  • Expert in documenting business requirements, functional, technical specifications and test cases
  • Good Knowledge and Experience of various Software Methodologies like Software Development Life Cycle (SDLC), V-model, Agile (XP, SCRUM) and Waterfall models
  • Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and can work as a part of a team as well as independently


Technical:

SAP BW (BI) 7.0, SAP BO, BODS (BODI) 3.X/4.0/4.1/4.2,S/4 HANA Cloud, Information Steward 4.2, BackOffice(DSP), Informatica, MS BI(SSIS,SSRS), Talend 6.3


Functional:

SAP SD, MM, SCM, CMS,CRM, HR and FI/CO(R2R,P2C,O2C), SalesForce Cloud


Reporting tools:

SAP-Bex, BO/BOXI 3.X, 4.X (Webi Reports), SAP Analytical Cloud,Tableau, Crystal Reports 2008, Xcelsius, Microsoft Power BI


Cloud Technologies:

AWS S3, Redshift, GCP BigQuery, Cloudera, Azure, Snowflake

Betriebssysteme

MS-DOS
MS WINDOWS
98/ NT/ XP, Server 2000/ 2003/ 2005
UNIX
Linux

Programmiersprachen

C++
HTML
Python
VB
Java
ABAP/4
C

Datenbanken

Data modelling
DB2
DB2 Query Management Facility
HANA
MS SQL Server
MySQL
SAP Sybase IQ
Talend
Azure
Sybase
ORACLE
8i/ 9i/ 10i/ 11g
SQL Server
2000/ 03/ 05/ 08

Datenkommunikation

Hive

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.