OBJECTIVE

• To take up a challenging career where I can showcase my skills, knowledge, talent, hard work and determination would make my organization and me as successful.

SUMMARY

• Around 4 years of experience at Confidential and Confidential as SAP BODS developer with rich ETL experience using SAP Business Object Data Services.
• Strong knowledge of SAP Business Objects Data Services tool.
• Sound understanding of end - to-end Data Migration process including Extraction and Transformation and Generation of Load ready data files in LSMW format.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
• Sound knowledge of various transforms of Data Services like Query, Validate, Case, Match, Pivot, Reverse Pivot, Base Data Cleanse, Table Comparison and Key Generation transforms.
• Administering and maintaining BO Data Services management console.
• Experience in using BODS Central Repository for storing objects and sharing objects.
• Experience in using in built functions of BODS.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Excellent communication and interpersonal skills with strong work ethics.
• Team player, highly productive, Commitment and Result driven in team Projects.

TECHNICAL SKILLS

Tools: SAP BODS

Database: SAP HANA & SQL Server 2016.

Platforms: Windows 10, Windows 7, Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

SAP BODS Developer

Environment: SAP BODS 4.2, SAP HANA, SAP S4 HANA, SQL Server

Responsibilities:

• Client interaction and requirements gathering.
• Used Rapid data mart package provided by SAP to create jobs to Extract, Transform, Enrich, and load the data into target system.
• Created BODS jobs to process sales related data from heterogeneous sources to our staging tables.
• Design and Implement complex Extraction, Data Transformation and Data Validation jobs and Trigger loads using BAPI, IDOC and LTMC.
• Developed transformations and validations in Business Objects Data Services for generating Load files to be loaded into SAP.
• Expertise in mapping of data from Legacy to Target system
• Hands on experience in Job Performance optimization.
• Designed and built data conversion/quality solutions using BODS for the identified needs of the customer and successfully demonstrated ability to assist the customer about the merits and demerits of proposed solutions.
• Delivered high quality work products independently with minimum assistance.
• Code promotion using Management Console.
• Successfully migrated data from legacy to SAP system.
• Got various Spot Awards for the timely deliverables from Client.
• Supported multiple mock cutovers.

Confidential

Environment: SAP BODS 4.2, SQL Server

Responsibilities:

• Requirement Gathering, going through the technical and functional decompose of the project requirements. Identifying the gaps and seeking clarifications.
• Responsible for design and delivery from offshore for all the Objects which are assigned as a part of delivery.
• Experience in documenting standard development guidelines, functional specification template, providing support to the functional team and other supporting documents for the build.
• The core of this project is to depict extract the legacy system data and stage it into SAP HANA. From these staging tables and final solution must be built based on the Load method either it is a BAPI or a IDOC loading or a custom ABAP program.
• Performing the Technical Unit testing based on the records shared.
• Once the Unit testing is performed, then Functional unit testing is performed to move the object for readiness check.
• Handling the defects management using the security tracker tool where the defects are being assigned for a particular object.

Confidential

Environment: SAP Data Services, SQL Server, SAP ECC

Responsibilities:

• Used Rapid data mart package provided by SAP to create jobs to Extract, Transform, Enrich, and load the data into target system.
• Created BODS jobs to process sales related data from heterogeneous sources to our staging tables.
• Created BODS jobs to extract data from different sources such as Oracle, SQL Server, Flat les and SAP.
• Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations etc.
• Accommodated the dependencies for batch jobs.
• Performing code reviews according to standards. Tracking the defects and fixing the defects.
• Providing accurate status reports to the management and client for the task(s) handled.
• Used different performance tuning techniques like parallel processing, Multi- Threading, Bulk Loading, etc., to improve the extraction and loading performance.
• Used Workflows, Scripts, Global variables and Transformations to pull the data.
• Used Central Repository to maintain version history, Deploy jobs to other environments and for multiuser development.
• Involved in the Unit Testing, prepared test cases and Bug fixing
• Delivered high quality work products independently with minimum assistance.
• Implement Data Profiling and field comparison reports to simplify requirement gathering process.