SUMMARY

• Over 13 years of experience in Analysis, Design, Development of ETL and Reporting applications like Business Objects Data Services 4.2,4.1,3.2/3.1 and SAP R/3 and SAP ECC 6.0, Information Steward 4x, SAP MDG,SAP BW,SAP HANA, SAP ECC end to end Data migrations, SAP HANA cloud for CRM Migration.
• Around 8 Years of experience in Onshore - Offshore Model, assigning tasks to offshore team, Status Reporting.
• Over 5 years of SAP MDG techno functional experience and successfully completed 4 full life cycle MDG implementations
• Over 9 years of experience in SAP Data Migration/Conversion through SAP BODS using SAP Best Practices.
• Have Data Migration Experience on several ERP systems and legacy systems.
• Using Information Steward, Worked on Business rules set up and Data Quality approach for Global EDM.
• Worked on Customers and Suppliers Address Cleansing for Global Master Data Governance project using Data Quality management best practices jobs .
• Worked as a BODS MDG Data Architect and involved in End to End Project Implementation.
• Experience in authoring Business Requirement Documents (BRD) by gathering the Requirements and expectations from Subject Matter Experts (SMEs) and defining business processes, identifying risks, Performing Gap Analysis, Feasibility Analysis and Impact analysis.
• Worked on Data Migration projects for both Master and Transactional data for many ERP systems.
• Strong Experience in working with Clients/Business users and creating Functional Specification and Technical Specification Documents.
• Expertise in analyzing, architecting, designing and modeling data for various industries like Products, Telecom, Banking, Healthcare.
• Good knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling.
• Strong Experience in Data Quality using Information Steward 4.0.
• Experience in Building therules in Information Stewards and applying for multiple legacy data source data to achieve data accuracy. Performing master data profiling; data redundancy applying appropriate business rules, Address cleansing, Completeness, Accuracy and Consistency of business partner data and Building scorecards for column profiling.
• Experience in Global Address Cleansing, US address cleansing and all Data Quality related transforms.
• Experience in Data Conversion of various data sources like SAP R/3, Oracle, SQL Server, DB2, MS Access, Sybase, Fixed Width, Delimited Flat Files, COBOL files & XML Files,SAP BW,HDFS file systems.
• Experience in LSMW for data loads to SAP R/3 and other concepts like IDOC, BAPI and BADI.
• Having Experience in installation of BODS, Sizing and Working with Infrastructure team in accessing Data bases, UNIX shared Directories, RFC Connectivity between BODS, SAP BW and SAP ECC.
• Extensively worked on BODS - Data Flow, Workflow, Batch Jobs, Scheduling, Management console, CMC.
• Hands on experience with Data Mappings from varied transformation logics.
• Extracted Data from multiple operational sources for loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Extensively worked on Exception handling, Repository Manager, Designer, Metadata Manager, BODI work flows, Data Flows.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Experience in PL/SQL Programming (Stored procedures, Triggers) using Oracle (SQL, PL/SQL).
• Experience in Business Objects, Qlikview Report Development and Dash boards.
• Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables.

TECHNICAL SKILLS

ETL/DQ Tools: Data Services 4.2/ XI 3.2/3.1, Data Integrator 11.7X, 11.5X, Information Steward 4.1, SSIS, SSRS.

SAP Migration Methods: IDOCS (AIO referencing), LSMW, and Data Migration Experience using BODS in all SAP Modules.

Reporting Tools: Business Objects 6.0/5.1/5.0, Qlikview

Data Modeling Tool: Erwin 4.1.

Databases: Oracle 8i/9i, SQL Server2000, DB2/UDB, Sybase. Toad 7.x.

Languages: SQL, Shell Scripting, PL/SQL, C, C++, HTML, DHTML, XML.

Operating Systems: UNIX (Sun-Solaris, HP-UX), IBM AIX, Windows NT/2000/XP

ERP Systems: SAP R/3, SAP ECC 6.0, PeopleSoft SAP BI 7.0/BW, SAP MDM,SAP MDG 6.0

PROFESSIONAL EXPERIENCE

Confidential, St louis, MO

SAP BODS/IS/MDG Data Architect

Responsibilities:

• Successfully implemented 3 full life cycle MDG projects for Confidential NA, Europe and Confidential APAC.
• Involved in gathering requirements, Design and Development and Successful migration from ECC 6.0 to SAP Master Data Governance (SAP MDG) for Confidential North America, Confidential EMEA Confidential APAC and Global Acquisitions.
• Provided SAP MDG solution and implemented for almost all Confidential regions in several rollouts.
• Worked on MDG functional requirements,Org structures, Customers, Suppliers and Business partner requirements.
• End to End Knowledge on MDG functionality from Migration to MDG Replication framework and Data Sync.
• Worked on Data Cleansing, Data profiling, Data Validation using SAP BODS 4.2, SAP Information Steward.
• Worked closely with Business users by getting the data in proper templates using SAP best practices in SAP BODS.
• Having good Techno-Functional exposure in Master Data like (Customers, Suppliers and Materials) .
• Using SAP BODS, created both Batch and real time jobs (SAP Best Practices) for SAP MDM and SAP MDG projects.
• Involved in Confidential Global support for SAP MDG and MDM projects.
• Worked on Global Address Cleanse transform (GAC),United States Address Directory for Global Acquisitions project.
• Well versed with Different country Address directories like US, Canada and Global directories.
• Extracted Customer/Supplier Address data from Flat files or Excel files and outputted the Suggested Address and loaded to SAP MDG system
• Worked closely with SAP BW team in setting up on SAP HANA Data base.
• Strong Experience in Oracle Querying and SAP idoc Processing, using SAP ECC system and SAP MDG UI.
• Involved in BODS 4.2.2 installation, upgrades and worked closely with SAP Basis, Oracle DBAs and Windows Network teams.
• Having Good Knowledge and Experience on SAP HANA, SAP Information steward.

Environment: SAP Business Objects Data Services 4.2.2,4.2,SAP ECC 6.0, SAP BI 7.0, SAP MDG7.0, Information Steward 4.1, SAP HANA 4.0,SAP Data Quality management 4.1,Oracle 11g, Windows 2008 Server, Windows XP (Client).

Confidential, Murray Hill, NJ

Data Architect

Responsibilities:

• Involved in installation of BODS, Oracle, Sizing of the data bases, provided estimations and worked with Infrastructure teams on setting up of Environments.
• Working on Data Migration and Conversion of Master and transactional data from legacy system SAP R/3 4.6C to SAP ECC 6.0, SAP BW/BI 7.0
• Installing and maintaining the SAP Business Object Data Services 4.0/XI 3.2, and Global Address Cleansing packages, with Oracle database on Development, Test and Production environments.
• Experience in extracting data from various data sources like SAP R/3, Fixed Width and Delimited Flat Files, Oracle, SQL Server, DB2.
• Extensively worked on ABAP Dataflow to extract data from SAP R/3 4.6C to staging tables.
• Worked on SAP HANA platform for BODS setup.
• Expertise in SAP HANA Data base querying.
• Performance optimization on HANA Database and performed BODS jobs run in less time.
• Involved in End to End development of Customer Master, Vendor Master, Material Master, Purchase Orders Source List, Sales Order and Vendor Contracts objects development and creating IDoc files.
• Worked with Functional teams on gathering requirements for our Data objects.
• Conducted Preload and Post load validation sessions with Business users.
• Closely worked with ABAP developers to upload IDoc files into ECC 6.0.
• Prepared Error reports and sent to the Business users.
• Designed batch jobs using Business Objects Data Services 3.2/Data Quality for Vendor Master and Customer Master Data cleansing.
• Extracted from different sources, cleansed, converted and loaded the data into BW system.
• Used SAP function modules in Data services to extract Text from SAP 4.6C to staging tables.

Environment: SAP Business Objects Data Services 4.2,4.1/XI 3.2, SAP R/3 4.6C, SAP ECC 6.0, SAP BI 7.0, Information Steward 4.0, Oracle 10g, Windows 2008 Server, Windows XP (Client).

Confidential, Battle Creek, MI

Data Conversion Lead

Responsibilities:

• Worked as a Data Migration lead, managing 6 offshore and 3 onshore resources.
• Worked on around 70 objects in Data Migration including both Master and Transactional Data.
• Involved in 35 Go-lives, cut over weekends during Business critical golives for all objects.
• Worked as a cut-over lead in Golives, working on Business critical timelines with users.
• Worked with SAP MM, PM (Plant Maintenance), SAP FI, controlling teams on Data Migration.
• Worked on complex objects like BOM (Bill of Materials), Purchase orders, Sales orders, Inventory Management, Maintenance-Orders, Project Systems, Project Journals, Budgets and Settlement rules.
• Installing and maintaining the SAP Business Object Data Services 4.0/XI 3.2, and Global Address Cleansing packages, with Oracle database on Development, Test and Production environments.
• Experience in extracting data from various data sources like SAP R/3, Fixed Width and Delimited Flat Files, Oracle, SQL Server, DB2.
• Extensively worked on ABAP Dataflow to extract data from SAP R/3 4.6C to staging tables.
• Involved in Customer Master, Vendor Master, Source List, Sales Order and Vendor Contracts objects development and creating IDoc files.
• Used SAP Best Practices AIO Methodology (BPDM) in data migration.
• Modified Jobs, Work flows and data flows to apply mapping rules as per mapping document.
• Prepared Error reports and sent to the Business users.
• Worked on Dev, QA and Production Environments, moving jobs to Central repository.
• Providing Reconciliation reports to the client before and after load of the data.
• Used SAP function modules in Data services to extract Text from SAP 4.6C to staging tables.
• Conducted pre and post load sessions with business users for data validation.
• Implemented the quality rules in Information Steward 4.0
• Used HP Quality Center to track the defects.
• Experience in SAP HANA cloud (in memory data base)for CRM Data migration.

Environment: SAP Business Objects Data Services 4.2,4.1/XI 3.2,SAP HANA SAP R/3 4.6C, SAP ECC 6.0, SAP BI 7.0,Information Steward 4.0, Oracle 10g, Windows 2008 Server, Windows XP (Client).

Confidential

BODS Developer

Responsibilities:

• Prepared technical specification documents.
• Providing Reconciliation reports to the client before and after load of the data.
• Used SAP function modules in Data services to extract Text from SAP 4.6C to staging tables.
• Created tab delimited flat files ready for LSMW to upload data in to SAP CRM to validate these flat files using LSMW, worked with ABAP developers.
• Conducted pre and post load sessions with business users for data validation.
• Used IT Service Management to track the defects.
• Created jobs with Exception handling using BODS 3.1.
• Worked on DTD schemas and XML using BODS.
• Worked on Oracle for checking back end tables.

Environment: SAP Business Objects Data Services3.1 SAP R/3 4.6C, SAP CRM, Oracle 10g, Unix ServerIT service management.

Confidential

Business System Analyst

Responsibilities:

• Served as a bridge between the Business Users, Technical Team and the Testing team.
• Gathered Requirements from the Business Users on Migration process.
• Facilitating Project Portfolio process with Business users.
• Creating Functional and Technical Specifications for the Release 1 Master
• Recommending appropriate process Improvements and suggesting Reusable solutions.
• Creating Mapping Docs for the Technical team Business Objects (BOBJ)
• Conducting JAD sessions between Technical team (BOBJ and ECC) and Business users on Design Approach.
• Data Validation with the clients before and after the Data Migration.
• Prepared Business Requirements Documents, System Requirements Specifications, System Design Specifications, Functional Specifications and Technical specifications.
• Participated in the preparation of System test cases, and Sample test records (test data).
• Reviewed Use Cases, created the Test Script & Testing Plan.
• Performed Regression testing, System testing and assisted in alpha testing.
• Creating Defects in HPQC if any issue exists and following up with the teams.
• 100% Defect Free Object Delivery.
• Producing Reconciliation reports.
• Understanding Business Processes and recommending appropriate process improvements to the users.
• Analyzing the risks and making sure the change requests will not affect the Project Deadlines.
• Tracking the Job Timings and Load timings in both BOBJ and ECC.
• Creating IT support Requests regarding System outages and following up with DBA or SAP BASIS team.
• Working with Business users and Technical team on the Object Delivery.
• Arranging Back up Support when Primary technical owners is on Vacation.

Environment: /Tools Used: SAP Business Objects Data Services (ETL Tool), SAP ECC MS Office Suite (PowerPoint, Excel, Access), HP Quality Center

Confidential

ETL Developer (BODS)

Responsibilities:

• Worked as BO Data Integrator developer for developing Sales Data Warehouse
• Detailed analysis of source data in SAP R/3 and 3rd party solutions from ETL perspective to merge to Shared Dimensions and identify Slowly Changing Dimensions
• Analyzed the requirements with the business users and write ETL technical specifications.
• Wrote scripts to truncate the dimension table before loading the tables in workflow.
• Change Data Capture (CDC) using Slowly Changing dimension.
• Created data maps for error correction and reload process to update the dimensions.
• Using SSRS 2005 created reports for Enterprise Data Ware house.
• Designed Data Integrator jobs with Error Handling and setting up email notifications.
• Extensively worked on Business Objects to create reports using Deski, Webi with analytical ability and creativity using Multi-data providers, synchronization, BO formulas, variables, sections, breaks, formatting drilldowns, Hyperlinks in Business Objects

Environment: /Tools Used: BODI 11.7.2, BODI 11.5, SQL server Reporting Services 2005, MS Office Suite, and Business objects (WEBI)