SUMMARY

• Over 20 years of experience in IT industry and 14 years in Data Warehousing and Business Intelligence, SAP, ETL tools like BODS.
• Experience on SAP HANA S/4 for creating Analytical, Attribute and Calculation views.
• Experience on SAP S/4 HANA Migration Cockpit (LTMC) to load the data into SAP S/4 HANA
• Over 12 years of experience with Data Integrator/Business Objects Data Services ETL tool.
• Experience in cleansing the data using the BODS DQM packages like Data Cleanse, USA Regulatory address cleanse and Global Address cleanse transforms.
• Involved in system design and Architecture of the ETL Systems with different source systems.
• Experience in extracting data from various source systems to data marts.
• Experience in Data Integration, Data Extractions, Data Validation and also worked in Data MDM and creating Data Dictionaries used cleansing packages.
• Design, develop, optimize and maintenance of Business Objects Data Integrator jobs.
• Integration of Business Objects Data Services with SAP and Non - SAP Data Sources like Oracle 11g, 10g, 9i, 8i SQL Server, DB2, and Sybase.
• Hands on experience in installation and configuration of BODS 4.2, IPS 4.0 AND IS 4.0, BODS 3.2.
• Installed and Worked with Information Steward 4.0(Data Insight) to perform Out-of-Box Profiling.
• Experience in working with many Transform types like Integrator, Quality and Platform.
• Experience in SAP MIGRATION Projects. Migrated the data into Customer Master (DEBMAS06), Vendor Master (CREMAS06), and Material Master (MATMAS05). And have very good knowledge on ECM objects (Bill of Materials and Routings).
• Worked with the ATR, OTC teams to migrate transaction data like SD PRICING, AP-AR and other master data FIXED ASSETS.
• Experience in working with LSMW. Migrated the data into FSCM using LSMW.
• Worked with ABAP data flows and transports.
• Done various types of job executions using Work flows in BODS and also many types of job executions using Data flows.
• Used Data services as an external system for ETL between ECC and BI.
• Worked with Data Services as an ETL tool in many of the SAP modules mainly CRM Module.
• Pushed data out of the SAP BI using BODS and Open hub services.
• Made US data cleansing in Data quality by using the transforms Match transform, Address cleanse and Data cleanse in BODS.
• Also made transformations using the Integrator and Platform transforms in BODS.
• Worked with Delta records by using Confidential (Change Data Capture) on both the source level and target for SCD (slowly changing dimension) of Type 1, Type 2 and Type 3.
• Configured the Data services to connect to the SAP R/3.
• Worked extensively on database programming using PL/SQL and SQL in writing the procedures and using functions on SQL Server, Oracle, DB2.
• Created the Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console
• Worked on Profiling and Auditing in migration.
• Experience with Business Objects as an OLAP tool for building report, designing universes and managing user profiles.
• Used the BO XI 3.1,XI R3/R2 as a reporting tool for Business Warehouse data by creating universes using SAP BW infocubes and BEx querries along with Oracle, DB2, SQL Server and Sybase EDW involving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Extensive knowledge in writing various Shell/PERL Scripts for automation and monitoring of databases.
• Strong experience in Migrating and Upgrading Universes & Reports from Business Objects 6.5.1 to XI R3/R2/R1.
• Hands-on experience in Installation, Configuration, migration environments and Upgrades of Business Objects Enterprise XI 3.1/XI R2/6.5.
• Experience in user and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project.
• Prepared test scripts and test cases to validate data and maintaining the data quality.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Self-motivated, Result oriented team player and quick learner of new concepts and technologies. Excellent interpersonal, project management, communication and documentation skills.

TECHNICAL SKILLS

ETL tools: Business Objects Data Services 4.2 SP13, IPS 4.0 SP2, IS 4.0 (Designer, Repository Manager, Management Console, Server Manager), XI 3.1, XI R2(11.7.2.2).

EIM tools: Information Steward 4.0 for profiling the Data.

BI: SAP BI 7.0,3.5

Reporting tools: Business Objects XI 3.1 (Central Management Console, Central Configuration Manager, Central Management Server, DeskI, Import Wizard, WebI, Designer, InfoView, Performance Manager, Dashboard Manager), Business Objects Data Integrator, Business Objects 6.5 (Reporter, Designer, Supervisor), Broadcast Agent (Document Agent/Publisher), WebI X1 3.1/XI R2/R1,Crystal Xcelsius 4.5/2008, Crystal Reports XI R 2/10.0/9.0/8.0 , Live office.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Responsibilities:

• Worked on Installing SAP Data Services 4.2 SP13, IPS, Information Steward.
• Worked with SAP HEC team, Confidential leadership and Splunk technical teams to resolve the issues.
• Worked on data mapping activity, source data cleansing, implemented the cleansing rules
• Worked with work steams to identify the gaps in the data migration/conversion of the data and corrected the validation rules and implemented conversion programs.
• Worked on Cutover plans to implement the phase wise data loads.
• Coordinated with Onsite and Offshore teams to carry out the Cutover plan.
• Worked on JIRA to log the defects, address the defects.

Confidential, Tysons Corner, VA

Responsibilities:

• Worked on Financial Data conversion objects
• Worked on Cost Center, Profit Center, GL Account, Functional Locations, Equipment, Equipment BOM migration objects.
• Worked with OneWeb leads and work steams to identify the gaps in the data migration/conversion of the data and corrected the validation rules and implemented conversion programs.
• Worked on different Mocks and Cutover plans to implement the phase wise data loads.
• Worked on Legacy Migration Cockpit (LTMC) to migrate the data into SAP S/4 HANA.
• Worked on JIRA to log the defects, address the defects.

Confidential, New York, NY

Responsibilities:

• Worked on Fixed Assets conversion and data migration from the Peoplesoft source system to S/4 HANA.
• Worked on Exchange Rate data conversion object.
• Worked on G/L Master Data Object in data conversion.
• Worked closely with Client Leads/Accenture Functional teams to identify the requirements in the data migration/conversion and validation rules and implemented conversion programs.
• Worked on different Mocks and Cutover plans to implement the phase wise data loads.
• Coordinated with Onsite and Offshore teams to carry out the Cutover plan.
• Worked on SAP HANA Studio to develop the Pre-Load reports, Readiness reports, Post-Load reports and Adhoc reports in HANA Calculation views.
• Worked extensively on SAP BODS and implemented different transformations to process the data as per the requirement specifications and validation rules.
• Worked on JIRA to log the defects, address the defects.

Tech Data Management Specialist

Confidential, Philadelphia, PA

Responsibilities:

• Worked on Purchase info records (PIR) data conversion and data migration from the legacy to S/4 HANA.
• Worked on Equipment BOM data conversion object.
• Worked on Purchasing Outline agreements Object in data conversion.
• Worked with FMC Leads/work steams to identify the gaps in the data migration/conversion of the data and corrected the validation rules and implemented conversion programs.
• Worked on different Mocks and Cutover plans to implement the phase wise data loads.
• Coordinated with Onsite and Offshore teams to carry out the Cutover plan.
• Worked on SAP HANA Studio to develop the PreLoad reports, Readiness reports, PostLoad reports and Adhoc reports in HANA Calculation views.
• Worked extensively on SAP BODS and implemented different transformations to process the data as per the requirement specifications and validation rules.
• Worked on Octane to log the defects, address the defects.

PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Worked on Case Management Electronic Filing System (CM/ECF) project, EDW HR Project, EDW CIRIS Project, IEDW Project.
• Involved in Architecture design, Star Schema Data Modeling, implementing the best practices for CM/ECF) project.
• Involved in the meetings to identify the Migrating elements (BODS) and created the Groups to those elements based on dependencies.
• Worked on developing the Real Time ETL Jobs on CM/ECF project.
• Worked on configuring the Real Time Adaptors.
• Worked on creating Batch Jobs to load Initial Data from the Source System (Informix).
• Worked on Validating, Tracing and debugging Real Time Jobs and Batch Jobs.
• Worked on Change Data Capture implementation on real time and batch processing (Initial/Delta load)
• Worked on configuring the Confidential Confidential and Apache MQ on Redhat Linux.
• Processed the data reading from the Apache Message Queues.
• Worked on Pre-Confirm, Post-Confirm processes on IEDW and EDW HR projects.
• Worked on design and implementation of Confirmed Dimensions and data extracts for the IEDW project.
• Worked on T-SQL for writing adhoc queries in SQL Server.
• Created Stored Procedures, functions and exported into data services and used them.
• Worked on various Production Issues, Performance issues on all the above projects.

Environment: SAP Business Objects Data Services 4.2 SP5,Oracle 11g, SQL Server 2014 SP2, Informix 11, Red Hat Linux, Confidential ,, XML File formats for real time processing, Apache Message Queues.

Confidential, Durham, NC

Responsibilities:

• Worked on Sales Compensation/Territory Management project
• Involved in Architecture design implementing the best practices.
• Involved in the meetings to identify the Migrating elements (BODS) and created the Groups to those elements based on dependencies.
• Worked on Customer, Product Hierarchy, Activity and other Data extracts, design interface, Data stores, Importing metadata, File format.
• Implemented the Cleansing packages for the batch job processing using Global Address cleansing and Data cleansing.
• Validating, Tracing and debugging Batch job
• Capturing changes in data (Initial/Delta load)
• ABAP data flow processing Using Data services for migrating the SAP data.
• Worked on Open Hub Destinations to extract the data from BW.

Data Services Architect

Confidential, Chicago,IL

Responsibilities:

• Experience in Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Involved in Architecture design implementing the best practices.
• Involved in the meetings to identify the Migrating elements (BODS) and created the Groups to those elements based on dependencies.
• Implemented the cleansing packages for the batch real time processing using Global Address cleansing and Data cleansing, Match and consolidate packages
• Scheduled the Jobs in Management Console.
• Experience in Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Validating, Tracing and debugging Batch job
• Capturing changes in data (Initial/Delta load)
• Worked on Open Hub Destinations to extract the data from BW.
• ABAP data flow processing Using Data services

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager)/BODS 4.0/3X, SAP ECC 6.0, Oracle 11g, SQL server 2008, MS Access 2000, Windows 2003 server/XP, AIO, Information Steward 4.0.

Data Migration Developer

Confidential, Tires, OH

Responsibilities:

• Worked as Team Lead in extraction and loading of the data.
• Involved in Architecture design implementing the best practices.
• Extensively worked on the OPQ module (Work Centers, Operation sets, Routings, Production Versions) in Data Extraction and Data loading using the LSMW.
• Migrated the PTP Masters like Vendor Master Data, Contacts, Addresses, Tax data using LSMW.
• Worked with OTC team to migrate the SD PRICING through LSMW
• Worked with RTP team to migrate the BOM, BOM Item classifications and loaded into ECC 6.0 using the LSWM and the custom Z programs.
• Involved in the meetings to identify the Migrating elements (By BODS, MANUAL, and LSMW) and created the Groups to those elements based on dependencies.
• Successfully migrated the data into ECC 6.0 through LSMW, IDOC and the Custom Z programs.
• Scheduled the Jobs in Management Console.
• Worked on DQM packages like Global Address cleansing,USA Regulatory address cleansing package and Data cleansing packages to cleanse the Master data.
• Experience in Data services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Validating, Tracing and debugging Batch job
• Implemented the Data Profiling using the Information Steward 4.0.
• Capturing changes in data (Initial/Delta load)
• ABAP data flow processing Using Data services
• Worked on MDM/MDG using Data Steward and created Master Data Dictionaries.
• Worked on Informatica Tool to extract the data from Oracle source system on JDA Interfaces to load into SAP ECC 6.0.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager)/BODS 4.0/3X, Information Steward 4.0, SAP ECC 6.0, Oracle 11g, SQL server 2008, MS Access 2000, Windows 2003 server/XP, AIO.

Data Migration Developer

Confidential

Responsibilities:

• Installed & configured Data Services XI 4.0 SP1 (IPS 4.0,IS 4.0) in Development & Production Server.
• Involved in Architecture design implementing the best practices.
• Created the Local Repositories, Central Repositories, and Profiler Repositories in SQL Server 2008 and configured the Local, Profiler repositories with Job server and Management console.
• Worked with the Information Steward (Data Insight) to profile the legacy data.
• Configured the Data services to connect to the SAP R/3 and SAP BW.
• Involved in the meetings to identify the Migrating elements (By BODS, MANUAL, and LSMW) and created the Groups to those elements based on dependencies.
• Successfully migrated the Customer Master data into ECC 6.0 through DEBMAS06 IDOC by referencing AIO Methodologies.
• Migrated the FSCM (CREDIT MANAGEMENT AND COLLECTION MANAGEMENT) using LSMW.
• Worked with OTC team to migrate the SD PRICING through COND A04 IDOC, by creating separate flows for each Access Sequence and Condition type combination.
• Move the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the Jobs in Management Console.
• Exposure to Dataservices Architecture Dataservices objects, Dataservices design interface, Datastores, Importing metadata, File format,
• Validating, Tracing and debugging Batch job
• Capturing changes in data (Initial/Delta load)
• ABAP data flow processing Using Data services

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, AS400 SYSTEM, SQL server 2008, MS Access 2000, Windows 2003 server/XP, AIO.

ETL Developer

Confidential, NY

Responsibilities:

• Participated in meetings with the Legacy data owners and Functional team for gathering Functional requirements and to model the data warehouse layer..
• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
• Created the Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Loaded the data into Material Master (MATMAS05), by referencing the AIO Methodologies.
• Involved in meetings and Worked with the ATR team to migrate the data into FIXED ASSETS Master data and Transactional data (Account Payable and Account Receivable).
• Based on the requirements, extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool.
• Used Open Hub Services to push data out of SAP BI using Data Services.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Used Data Integrator and Platform Transforms extensively.
• Created jobs, Workflows and Dataflow.
• Worked on Change Data Capture on both Source and Target level for SCD(Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Move the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the Jobs in Management Console.

Environment: SAP Business Objects Data Services XI 3.2 SP1(Designer, Repository Manager, Management Console, Server Manager), DATGA INSIGHT,AIO METHODOLOGIES,SAP BW/BI 7.0, SAP ECC 6.0, SAP Netweaver, Oracle 10g,SQL server, MS Access 2000, Windows 2003 server/XP .

ETL/BO Developer

Confidential, MI

Responsibilities:

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse
• Installed & configured DI 11.7.2 in Production Server (Windows).
• Used Business Objects Data Integrator to load data from source system to data Mart.
• Implemented SCD - Type I & II using normal transformations (Other than Table comparison and History Preserving) in Data Integrator to increase performance.
• Used Business Objects Web Administrator to schedule and monitor Batch jobs
• Implemented Automation process, Polling, Failure and Recovery Mechanism for ETL Job Execution.
• Used Debugger to troubleshoot the mappings between source and target tables.
• Implemented performance tuning logic on Targets, Sources and mappings to provide maximum efficiency and performance.
• Defined Target Load Order Plan for loading data into Target Tables
• Prepared Unit Test Cases.
• Migrated all ETL Jobs and Data Base (Data Mart and Staging) into Production from Development Server
• Handled several issues which came under production support.
• Modified the universe, created classes and objects by retrieving the data from various data sources.
• Worked on Business Objects Reporting and analysis functionalities such as Filters, Ranking, Sections, Sorts, Master Detail Reports, Slice and Dice, Drilling methodology, Cross Tabs and Charts.
• Created Customized Lov’s (List of Values) in the Universe Dimension Objects.
• Checked the integrity of the Universe.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Worked extensively with the major functionality of BO like Breaks, Ranks, inserted calculations, Sorts and Query Prompts.
• Created standard Desktop Intelligence and Web Intelligence reports.
• Created contextual links between Crystal reports and WebI documents using open document feature.
• Formulated project plan outlining scope, requirements and steps required to develop Crystal reports within specific timelines
• Worked on Data warehousing concepts including Star, snowflake schema design, slowly changing dimensions.
• Involved in designing Business Objects Queries, and Reports.
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice.
• Created Crystal Reports using Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the customers' requests
• Improved report response time by tuning BO queries.
• Prepared Technical design documents, unit & integration test plan and unit & integration test script for quality assurance.
• Unit testing, Regression testing of canned reports, ad-hoc reports and Universe as per the client request and migration of reports and universe to different environments.
• Providing Quality Assurance testing and User acceptance testing support and Implementation Support.

Environment Business Objects Data Integrator XIR2,Business Objects 6.5/5.1 (Supervisor, Designer, DeskI), oracle8x, MS SQL Server 2000, MS Access 2000, Windows 2000 Server,

UNIX BO Developer

Confidential, VA

Responsibilities:

• Designed and developed primary database objects (tables, views, indexes).
• Created tracking mechanisms to promote database changes from development to testing, testing to production, which saved database promotion time for the customer.
• Design and implemented process for migrating existing data from MS Access to MS SQL Server.
• Recommended improvements to existing application for performance and scalability requirements.
• Analyzed, designed and created reports for users Using Business Objects.
• Going through the clients requirements and coming up with database design and application architecture.
• Involved in building Conceptual and Physical Data Modeling of the application using Erwin.
• Wrote complex stored procedures and triggers using Transact SQL.
• All drilling functionality within the core reporting tool, giving users the ability to easily drill down into greater detail within a report, or up into higher levels of aggregation.
• Got the Confidential on SAP Business Objects Data Integrator XIR2.