PROFESSIONAL SUMMARY:

• 15+ years of overall IT experience that includes SAP Business Objects Data Services/Data Integrator, Data Quality Tools on ETL with Business Objects Reporting development.
• Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Blueprinting, System Configuration, Data modeling, Unit testing, Integration testing, Cut - Over activities, Go-live strategies and Post Go-Live Stabilization Maintenance Activities
• Extensive experience on full life cycle implementations on SAP/Non-SAP Data Migration that includes Legacy Data Conversion and Data Syndication (Data HUB).
• Extensive data migration using SAP BPDM/AIO Best Practices, Data Hub and LSMW.
• Good Experience on extracting legacy data to HANA database.
• Developed complex mappings in SAP BODS to load the data from various sources into the Data Mart using different transformations like Query, Table Comparison, Merge, Case, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation .
• Worked with Match and Associate Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality .
• Proficient in using SAP Business Objects Data Services/Integrator to load data from Flat files involving both fixed width as well as Delimited files and also from the relational databases.
• Experienced with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary , Data Profiling, Data Quality, Data Hub and Data Model Standards by using SAP Information Steward .
• Extensively worked on development of mappings and worked with Business Object Data Services/BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation
• Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly Changing Dimension) Type 1, Type 2 and Type 3 .
• Extensive experience in SAP Data Services or SAP BO Data Integrator platforms
• Extensively worked on real time data replication from SAP to HANA by using SLT
• Experience in Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems into SAP ECC for various SAP modules through IDOCS and BAPI .
• Loaded data into Customer master, Material master, Material & Batch Characteristics and Vendor master using DEBMAS, MATMAS, CLFMAS and CREMAS IDOCS
• Involved in upgrading SAP Data Services from 3.2, 4.1 to 4.2
• Good Knowledge on loading data into SAP HANA database using BODS
• Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models
• Experience in resolving the issues related to clustered network architecture and simple architecture on BODS .
• Extensively used Business Objects reporting functionalities such as Master/ Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked extensively in developing and implementing Crystal reports on BEx queries.
• Good Experience on Global delivery model by interacting with offshore and onshore on various projects.
• Good Team player with excellent skills in business partnership, technical leadership and team building

TECHNICAL SKILLS:

ERP: ECC 6.0/EHP6

ETL Tools: SAP BO Data Services (Designer, DS Repository, DS Server Manager, DS Management Console) / SAP BO Data Integrator, CMC, SAP Data HUB, SLT

Reporting Tools: SAP Business Objects Xcelicius, WEBi, Crystal Reports, Information Steward

Data Modeling: Erwin, TOAD, Developer 2000, SQL*Loader.

Language: SQL, PL/SQL

Database: Oracle, SAP HANA, MS SQL Server 2005 & 2008, DB2, MS Access

General Tools: MS Office, SOAP UI, TOAD, SQL Developer, ATG

Operating Systems: MS Windows, Unix and Linux

Adapters: SalesForce, Hybris

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Extensive experience on full life cycle implementations on SAP/Non-SAP Data Migration that includes Legacy Data Conversion and Data Syndication (Data HUB).
• Extensive data migration using SAP BPDM/AIO Best Practices, Data Hub and LSMW.
• Good Experience on extracting legacy data to HANA database.
• Developed complex mappings in SAP BODS to load the data from various sources into the Data Mart using different transformations like Query, Table Comparison, Merge, Case, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation .
• Worked with Match and Associate Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality .
• Proficient in using SAP Business Objects Data Services/Integrator to load data from Flat files involving both fixed width as well as Delimited files and also from the relational databases.
• Experienced with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Profiling, Data Quality, Data Hub and Data Model Standards by using SAP Information Steward .
• Extensively worked on development of mappings and worked with Business Object Data Services/BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation
• Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly Changing Dimension) Type 1, Type 2 and Type 3 .
• Extensive experience in SAP Data Services or SAP BO Data Integrator platforms
• Extensively worked on real time data replication from SAP to HANA by using SLT
• Experience in Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems into SAP ECC for various SAP modules through IDOCS and BAPI .
• Loaded data into Customer master, Material master, Material & Batch Characteristics and Vendor master using DEBMAS, MATMAS, CLFMAS and CREMAS IDOCS
• Involved in upgrading SAP Data Services from 3.2, 4.1 to 4.2
• Good Knowledge on loading data into SAP HANA database using BODS
• Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models
• Experience in resolving the issues related to clustered network architecture and simple architecture on BODS .
• Extensively used Business Objects reporting functionalities such as Master/ Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked extensively in developing and implementing Crystal reports on BEx queries.
• Good Experience on Global delivery model by interacting with offshore and onshore on various projects.