SUMMARY

• 9+ years of experience in SAP Data Migration, Development and Support projects.
• Involved on the analysis, design and development in client/server environment focusing on data warehouse and data migration applications (EIM/ETL/OLAP).
• Experienced in data warehouse life cycle: requirement analysis, understand trade - offs between different schema designs and their implementation, worked with DBA to implement data models in RDBMS and support enhancements.
• Worked with ERP systems (SAP, Oracle Applications) in manufacturing Oil & Gas, Retail, SD, purchasing and inventory (MM) modules, FICO modules.
• Implemented/customized Rapid Marts for SAP for sales and distribution, purchasing and inventory and custom-built demand forecasting.
• Worked in Implementing/custom-defined processes for SAP data migration to integrate data from multiple sources like SAP, flat files, Oracle, XML files etc., for various stages like mapping, filter, de-duplication, validate, data completeness, data cleansing and enrichment processes.
• Designed staging of ODS, ERP applications' extract for enterprise data warehouse/data mart and assisted data warehouse architect in design/dimensional data modelling of the data warehouse data storage strategy / technique and implementing the best practices for efficiency and optimization.
• Worked in full lifecycle of Data Warehouse development using Business Objects Suite namely - SAP Business Objects Data Services (BODS 4.2/ 4.0 / 3.2/ 3. x / BODI) and Business Objects (4.1, 6.x), Designer, Supervisor (Central Management Console), broadcast agent, web-intelligence,
• Worked in mentoring the teams (On-Site / Off-Shore model) on the industry standard best practices, performance tuning and guidelines for process improvement, reliability and data correctness.
• Handled Administration Tasks like Installation / Configuration / Up-gradation of versions of SAP Business Objects Data Services / Data Integrator components (Job Servers, Repositories, Profiler Servers, Access Servers), handled User / User Groups, Data Profiling and Data Cleansing, Code Promotion / Version Management using Central Repository and usage of Metadata Reports to Document current data flows, design mappings for various sources/destinations of the data including data distribution and replication.
• Prepared unit test plans and test cases and ETL documentation and involved in various levels of testing like unit testing, integration testing and user acceptance testing.
• Writing first level basic test-cases for the unit testing.
• Used DQ transformations based to cleanse the address and data conversion. Hands on experience in Integrating SAP BW with Business Objects Data Services
• Experienced in Production Support role 24/7 to resolve the issues. Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player

TECHNICAL SKILLS

Data Migration experience: End to end Migration experience with SAP ECC to SAP S/4 HANA and BW/4 HANA.

ETL: SAP Data Services 4.2 DMC-LTMC,LSMW.

Data Loading Tool: SAP BODS(IDOC/BAPI), DMC-TMC

Reporting and Analystics Tool: SAP BW/BI and BO Tools, Tableau.

RDBMS: Oracle 9i, MS-SQL Server, HANA 1.x/2.x

ERP/Legacy Application: SAP ECC 6.x, SAP BW 7.x

Ticketing System: BMC Remedy, JIRA, ServiceNow and HP ALM Tool

Languages: Oracle SQL

Platforms: Windows XP/2000/windows 11

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Experience implementing and upgrading existing SAP S/4 instances to SAP S/4 HANA 1909, and 2020
• Technical experience with all the SAP BODS application modules (Extract, Transform, Load)
• Experience using SAP RDM templates and migration cockpit.
• Experience in BODS Designer Components- Projects, Jobs, Workflow, Data Flow, Scripts, Data Stores and Formats.
• Experience in BODS performance tuning techniques using parallel processing (Degree of Parallelism), Multithreading, Partitioning, and Database Throughputs to improve job performance.
• Experience in Data Services Management Console for monitoring, execution, and scheduling BODS jobs.
• Experience in SAP ABAP development for Enterprise Data Management
• End to End Implementation experience, Upgrade Knowledge, Enhancements, Development, Rollout and Production Support experience in SAP MM, SD, IM/WM, PM, FI, CO modules.
• Developing effective standards, best practices, procedures, and key metrics to enhance operational stability SAP Business Objects Data Services performing ETL for Data Migration / Conversion / Data Warehouse / Data Marts.
• Analysing and gathering project requirements, developing, and designing business objects data services programs customized to meet specific business needs.
• Design, develop and implement the Data Model and work on the development of project.
• Design, Develop and Debug complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions
• Extensively worked on various transformations like Map Operation, Table Comparison, Key Generation, Query, Validation, History preserving, and Case transformation
• Implemented incremental load for extract data from source tables to staging tables.
• Configured and managed Repositories using administrator console as per business requirements.
• Worked as a developer and migrated data using IDOC and Migration cockpit.
• Test, review code and documentation for the deliverables designed and developed by the team.
• Track changes, deliverables, testing status during project life cycle and status reporting for the same.
• Successfully handled change requests, new requirement, defect fixes and resolution, debugging of complex code in BODS with zero or minimal escalations during Mock cycles.
• Created a standard template for data migration as a best practice job & can be reused for future rollouts.
• Posting IDocs to the target SAP system from SAP and Non-SAP source systems.
• Involved in the migration of the code from Dev to QA and then to Production environments.
• Developed custom functions, documents and followed the best practice naming conventions to pull the data into a required shape.
• Configured database Data Stores and File Formats to allow Data Services to connect to the source or target database and files.
• Worked on Central repositories for Version checking of Data services objects.
• Supporting and executing performance investigations and Tuning concepts such as Explain plan, auto trace and hints.
• Worked on Performance tuning by understanding the user requirements and rewriting the existing code to yield better results.
• Responsible for setting up the BODS environment during development, MOCK and UAT phase.

Confidential

Responsibilities:

• Gathering business requirements and translating the requirements into systems solution by preparing a technical document.
• Overseeing the development, testing, and implementation of the technical solution, and validating the final product satisfies the defined requirements.
• Interact with Client Process owners to understand requirements and to validate Functional design specifications.
• Involved with all contractual agreement related technical document building such as Technical Specification Build, Test Strategy build, Development Guide Document build for Data Services.
• Production Support of monthly BODS Jobs and trouble shooting.
• Promoted changes in mappings in Production environments.
• Maintained existing mappings to take advantage of the new features that improve performance.
• Wrote SQL scripts to support mappings in SQL translation.
• Posting IDocs to the target SAP system from SAP and Non-SAP source systems.
• Involved in the migration of the code from Dev to QA and then to Production environments.
• Developed custom functions, documents and followed the best practice naming conventions to pull the data into a required shape.
• Configured database Data Stores and File Formats to allow Data Services to connect to the source or target database and files.
• Worked on Central repositories for Version checking of Data services objects.
• Supporting and executing performance investigations and Tuning concepts such as Explain plan, auto trace and hints.
• Worked on Performance tuning by understanding the user requirements and rewriting the existing code to yield better results

Confidential

Responsibilities:

• Interacted with Business Analysts and Architect to understand the business requirements.
• Designed complex with SQL queries to extract the data from field to field.
• Experience in writing technical and functional specifications for various ETL processes designed in Data Integrator.
• Pre-migration and post migration testing of processes because of server’s physical moved to another location.
• Design Data load jobs in SAP BODS and Scheduling the batch jobs
• Primary and On-call support for production support in monitoring file feeds, job triggers, Processes dependencies etc. and provide resolution or escalation on rotational basis.
• Analyzed the source data and design of data warehouse and ETL processes.

Confidential

Responsibilities:

• Created technical specification as per the client’s requirement.
• Designing Jobs in BODS to fetch the data from Legacy system as per the client requirement.
• Created a standard template in SAP BODS for data migration as a best practice job & can be reused for future rollouts.
• Loaded the data into SAP system using BAPI /Idoc.
• Worked on Data store creation, Query transform, SQL transform, Conditional transform, Merge transform, Pivot/Reverse pivot transform, lookups while designing BODS job.
• Worked on End-to-end ETL testing and prepared test cases.
• Executed jobs in UAT environment and fixed issues and bugs.
• Designed complex with SQL queries to extract the data from field to field.
• Pre-migration and post migration testing of processes because of server’s physical moved to another location.
• Design Data load jobs in SAP BODS and Scheduling the batch jobs
• Primary and On-call support for production support in monitoring file feeds, job triggers, Processes dependencies etc. and provide resolution or escalation on rotational basis.
• Analyzed the source data and design of data warehouse and ETL processes.