SUMMARY

• Overall 9 years of IT experience with 6 years of SAP implementation and Data warehouse Applications includes 3+ years BO Data services experience
• Completed 5 life cycles of Data migration end to end including Data Extraction, Data profiling, Data cleansing, Data Mapping, Data Transformations/Conversion, Data Validations and Error handling
• Designed and developed BODS objects (Master and Transactional) with Scripts, Jobs, Workflows, Data Flows, Transforms, File formats and Error handling
• Loading Data into Target systems using file formats (Text, Excel, and XML) as source files/messages and targets files/messages
• Efficient experience in implementing and testing of Stored procedures, Views, Packages, Database triggers, cursors, functions at database level using PL/SQL, and Specialized in creating complex query reports using Oracle, PL/SQL developer, SQL Server 2000/2005/2008.
• Analyzing and existing ETL Real Time and Batch Jobs and also be able to build new transformations as well as performance Tuning and Optimizations experience.
• Great understanding of SAP IDOCs and hands on SAP BO AIO methods, Implemented Cost center, Vendor Master, Customer Master, Material Master inbound and outbound interfaces through Batch and Real time jobs.
• Management console usage to check the RFC’s, Web service and other Adapter services as well as job trace and logs.
• Quick learner and adaptive to new and challenging technological environments.
• Experienced in interacting with customers / clients
• Exceptional ability to quickly master new concepts and technologies
• Excellent communication skills and capable of working in a group as well as independently
• Experienced in working offshore & onshore development model and teams

TECHNICAL SKILLS

SAP BO Data Services: Business Object Data Services 3.x/3.2/4.0(Designer, Integrator, Repository, Management Console, & Administration)

Tools: Business Objects Enterprise XI/XIR2/3.0/3.1,Crystal Reports XI R2/2008, Designer, Universe Design, Web Intelligence), BW/BI 3.1C/7.0, Bex Browser, Analyzer, Informatica Power Center 8.6.1

SAP: SAP R/3 4.7, ECC 6.0

Databases: Oracle 7.x/8.x/9x,10g, SQL Server 2000/2005, DB2 and MS Access

Languages: SAP ABAP, Java, PL/SQL, C, C++

Web Languages: ASP, JSP, XML, and Servlets, DHTML/HTML, VBScript, and JavaScript

Application Servers: Web Logic 5.1/4.5, Tomcat 3.2.3, Web Sphere 5.1

OS: Windows 95/98/NT 4.0/2000/XP, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE

Confidential, NJ

SAP Data Migration / BODS Consultant

Responsibilities:

• Designed and developed BODS job to unwrap the XML file extracted from Global PeopleSoft to BODS staging through UPXI middleware
• Designed and developed a real time job to receive either created or changed Cost centers from SAP ECC to BODS staging and to send to SAP IBM Payroll through UPXI middleware
• Involved in defect fixing to support assembly test for E - HR interfaces such Employee master data, Bank Master Data and Organizational structures for daily and delta loads.
• Extracted data from SAP BW ODS into BODS staging and sent to MQ-series
• Extracted data from SAP ECC the negative customers with overdue payments into BODS staging and sent to MQ-series

Environment: SAP Business Objects Data Services 4.0, SAP ECC 6.0, MQ-Series SAP PI SAP BW, TWS, and MSSQL server 2008, Windows XP

Confidential, OH

SAP Data migration / BODS consultant

Responsibilities:

• Collecting the requirements for mapping/conversion and data quality with business users.
• Implemented data process flow from getting the data from legacy to load into SAP and providing error reports at different levels.
• Installing/Maintaining SAP Business Objects Data Services for smooth operation of development work and creating new users and repositories and staging data bases for everyday requirements
• Converting the functional requirements to technical design specs for coding in Data Services, and also necessary logic.
• Defining and designing data quality rules and standardizing the addresses and finding de-dups for customer, and vendor master by using the SAP Business Objects Data Services Address Cleaning transforms
• Designed and Developed Functional/Technical for Data Mapping and cleansing rules for BOBJ development process.
• Designed/developed delta load process for Materials master data.
• Designed Business Objects Universe (Semantic Layer) for error reporting for business to review /verify and consolidation.

Environment: SAP Business Objects Data Services XI 3.2, SAP ECC 6.0, SAP BI 7.2, SAP CRM 6.0 Oracle 7, SQL Server 2005, PeopleSoft, Windows Servers 2003(Servers), Windows XP (Client)

Confidential, Windsor CT

SAP Data Migration- BODS Consultant

Responsibilities:

• Involved in High Level design, Low level Design document, Unit Test Case and Integration Test case Preparation, Performance, and improvement of ETL.
• Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs and redesign the existing mappings for improving the performance.
• Applying Business Rules as required to the source data, and converting to the SAP required format.
• Involved in Administrative Tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Involved in Migration of Jobs and workflows from Development to Test and to Production Servers to perform the integration and system testing.
• Have good Experience with Web Admin/Management Console (i.e. Scheduling, monitoring jobs).
• Worked on BODI/BODS transformations like Query, Hierarchy Flattering, Query, Map, Pivot, Reverse Pivot, Table Comparison, Temp Tables.
• Worked on US Address & Global Address cleaning, Match transformations to clean the data by suing Quality transformations in BODI/BODS.
• Experience in creating SAP Rapid Marts(HR/SALES/FINANCE) by extracting SAP R/3 data.
• Created reusable components like Workflow, Data flows, Batch and Real Time Jobs and Worked with Database functions in Scripts.
• Migration of MS-Access source into SAP R/3 Via IDOCS and LSMW.
• Involved in loading SAP Objects like work center, functional location, equipment, billing master, material master through IDOCS and LSMW.
• Extensively worked on Performance and Tuning of the jobs.
• Extensively used TRY/CATCH blacks to Handle Exceptions and writing Scripting to automate the Job Process.
• Check the validation against SAP T tables like CSKS-Cost Center by using validation transformations.
• Worked on writing Scripts, Functions and used Lookup Ext functions to reference the reference table data.
• Created Custom Functions to make the code the reusable.
• Applying various functions and formulas over the source data.
• Creation of target LSMW file structures to be loaded to the SAP CRM and Worked on map enriches tables loading in SAP Objects loading.
• Implementing AIO methodology in creation of Data Services jobs.
• Involved in SAP Business Objects Data Services - DI / DQ (data quality Like USA Address Cleaning, & Match)

Environment: BODS-BUSINESS OBJECTS DATA SERVICES 3.2(12.2.2), ORACLE, TOAD, SQL Server 2005, SSIS 10G, SQL, PL/SQL, UNIX, WINDOWS XP, Informatica Power centre 8.6.1

Confidential, NJ

SAP Data Migration/ETL Team Lead

Responsibilities:

• Involved in design and development of data migration implementation from mainframe systems and other legacy systems to SAP 4.7 system
• Execution of (Sample and Full) data loads into SAP including documentation and summary.
• Produce errors reports of the loads and distribute / communicate results to the conversion team accordingly
• Support the conversion teams debugging rejects and communicate to the teams with possible solutions.
• And optimize the load process into SAP and develop a way to improve automation
• Support conversion teams in reconciliation between SAP and Legacy (including adjusting or development of individual MRAM Specific reports)
• Completely involved in FS-RI Treaty, Claims, Claim Objects, Workers compensation accounts, Technical Accounting, FS-CD Payments reinsurance areas and Reports
• Import and Export the LSMW object versions between different servers
• Carrying all application errors, Data load errors, and configuration errors to the respective teams ( Treaty, Claims, Accounting and FS-CD) with possible suggested solutions
• Pre and Post migration settings and Configurations
• Activation of Class of Business, Delete Business Partner Role Locks, Open Currency Locks
• Cut over and Production Support

Environment: SAP ECC, SAP BW, SAP PI,Oracle 10g, SQL server 2005, Sql Server 2008, Informatica Power centre 8.6.1

Confidential, Moline IL

SAP Data Migration Consultant

Responsibilities:

• Development of Extraction programs to create flat files and then to load massive data into staging tables of SAP
• Created LSMW Objects for Complete Material Master Data and its dependent Modules as well as Views to load the data into SAP system
• Developed and modified User exits, LSMW( All 4 methods), BDC, ABAP Reports, SAP Scripts for MM, SD, PP, QM and PS modules
• Created / Changed info structures of SD, Customized and Configured Pricing objects
• Developed reports for all Open Sales order and Purchase order
• Created a dash board for Purchase orders overview by Material, Vendor and PO
• Developed Consignment batch/material characteristics and invoice report
• Designed and developed Detailed Credit Analysis Report using BI Publisher which extracts the Markdown reasons and multiple credit requests.
• Worked with Security Manager to implement Object level and data level Security.
• Involved in Review and Quality checking of other team members Code.
• Created Test Cases for Siebel Analytics Admin Functionalities and iBots.
• Configured iBots to deliver analytics content based on schedule to obtain daily reports and sent notification Alerts.
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Worked on webcat, Siebel Analytics webcat replication and Siebel Analytics Web Administration.
• Troubleshooting and Analysis of Defects and providing recommendations to the customer and actively participated in resolving the issues.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.

Environment: SAP R/3 4.6/7, Oracle 10g, Informatica 6.x/7.x (PowerCenter / PowerMart)

Confidential

DW Developer

Responsibilities:

• Responsible for the conversion of reports to Siebel Analytics Dashboards/Reports.
• Performed sanity check / data validation by comparing the Brio reports output with Siebel Analytics reports.

Environment: Siebel Analytics 7.x, SQL*PLUS 8.x/9.x