SAP Data Services Consultant
(Konsumgüter und Handel, >10.000 Mitarbeiter)
Schlagwörter
Skills
- Having 7 years of IT experience in SAP Data Services
- Experience in Analysis, Design, development, implementation and maintaining of various Data Migration and Data Warehousing Projects using SAP Data Services (4.2), SAP Business Objects BI (4.1/4.2) and SAP HANA 2.0
- Strong experience in using SAP DS as an external system for ETL between ECC and BI and in the integration of SAP and Non-SAP data sources
- Good experience and knowledge in different SAP BODS BPDMs and data migration of various ERP objects like customer master, vendor master, material master, AP, AR and other objects from legacy systems to SAP ECC through IDOC’s
- Having good working knowledge on S/4 HANA data migration cockpit
- Hands on experience with data extraction transfer and loading using SAP DS for loading data from SAP ECC system to SAP HANA and extracting from flat file
- Created complex Jobs, Workflows, Data Flows, and Scripts using various Transforms to successfully load data from multiple sources into a desired target
- Used Central Repository to check in and check out of the jobs to maintain version history and for multiuser development
- Good experience in SCD types implementation
- Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data
- Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
- Having Strong Exposure on SAP Business Objects BI 4.1/4.2
- Hands-on expertise in using Universe Designer (UDT & IDT), Web Intelligence Rich Client, BI Launch Pad
- Experience in Created and managed users and groups, including their rights to folders, objects and applications using CMC (Central Management Console)
- Expertise in creating Semantic layers using OLAP Cubes and OLTP data sources from scratch
- Good experience in SAP HANA modeling and implementation for data modeling using packages, attribute view, analytical view and calculation view
- Involved in Unit Testing and Prepared the documentation on Unit Test cases and Unit test results
Projekthistorie
03/2020
-
bis jetzt
- Responsible for the development of SAP BODS ETL jobs, workflows, data flows and loading of data using IDOCs
- Created Jobs, Workflows and Data flows per the Business requirements and implemented the business logic for Material Master, Fixed Assets, GL Balances and other migration objects
- Coordinated with client SAP team, users and Functional Consultants, and gathered requirement and provided answers to their queries
- Creating and providing preload and post load reports related to legacy and SAP data
- Involved in development of mappings using various transformations according to ETL mapping documents
- Worked on S/4 HANA data migration cockpit to the load profit, cost centers and hierarchies
- Involved in extracting data from flat files
- Used Central Repository to Check-In and Check-Out of the Jobs for multi-user development
- Responsible for monitoring, scheduling and running the ETL jobs by using Data Services Management Console
- Experience in moving the code from one environment to another environment by using central repository
- Worked on production support for solving issues related to BODS
04/2017
-
02/2020
SAP Data Services Consultant
Stanley Black & Decker
(Sonstiges, >10.000 Mitarbeiter)
- Responsible for the development of SAP BODS ETL jobs, workflows, data flows and loading of data using IDOCs
- Created Jobs, Workflows and Data flows per the Business requirements and implemented the business logic for Material Master, Customer Master, Vendor Master and other migration objects
- Coordinated with client SAP team, users and Functional Consultants, and gathered requirement and provided answers to their queries
- Involved in development of mappings using various transformations according to ETL mapping documents
- Involved in extracting data from flat files
- Extensively worked on mappings with DS Transformations like Map Operation, Table Comparison, History Preserving, Key Generation, etc.
- Used Central Repository to Check-In and Check-Out of the Jobs for multi-user development
- Responsible for monitoring, scheduling and running the ETL jobs by using Data Services Management Console
- Experience in moving the code from one environment to another environment by using central repository
- Involved in the Design, Development and Maintenance of universes and reports
- Developed Webi reports in different areas of business process such as Finance and Ageing
- Participation in performance tuning Reports and Universes
- Trained the end users on BI Launchpad
- Worked on production support for solving issues related to BODS jobs, universes and reports
- Created publication and scheduled the reports to end users on daily basis
- Created users and groups, folders and assigned access levels using CMC application
- Involved in Unit Testing
04/2016
-
03/2017
SAP Data Services Consultant
NSL Group
(Konsumgüter und Handel, 5000-10.000 Mitarbeiter)
- Responsible for the development of SAP BODS ETL jobs, workflows, data flows and loading of data using IDOCs
- Used SAP Data Services built in Functions to transform the data, created SAP Data Services Jobs scripts to automate data loads and variables with Parameters
- Creating and providing preload and post load reports related to legacy and SAP data
- Took part in and responsible for complete end to end Loads for various domestic and international sites
- Coordinated with client SAP team, users and Functional Consultants, and provided answers to their questions
- Responsible for configuration, creation of Targets, Sources, Rules and Reports in Data Warehouse and performed Data Audits
- Solved defects assigned in service now and provided detailed explanation for solutions.
- Provided knowledge related to various SAP modules to clients to guide them in Data migration process.
Reisebereitschaft
Verfügbar in den Ländern
Indien
