PROFESSIONAL SUMMARY:

• Over 8 years of overall IT experience dat includes 5 years in SAP Business Objects Data services/Data Integrator and Data Quality Tools with Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services.
• Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Blueprinting, and System Configuration, Data modeling, Conversion, Unit testing, Integration testing, Cut - Over activities, Go-live strategies and Post Go-Live Stabilization Maintenance Activities.
• Working experience on transforming data from various data sources to a Data warehouse using Data services and interacting with teh Business Analysts in identifying teh needs and teh requirements of teh system.
• Developed complex mappings in SAP BODS to load teh data from various sources into teh 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.
• Proficient in implementing teh data integrator transforms like Hierarchy Flattening, Pivot, History Preservation, Table Comparison and Map Operation
• Extensive experience in SAP Data Services or SAP BO Data Integrator platforms
• Experience in Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems into SAP ECC to various SAP modules through IDOCS.
• Installed & configured Data Services XI 4.0/3.2 SP1 in Development & Production Server.
• Created teh Local Repositories, Central Repositories, and Profiler Repositories in Oracle 10g and configured teh Local, Profiler repositories with Job server and Management console.
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems
• 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.
• Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment and CDC (Change Data Capture) and Strong knowledge of Fact & Dimension tables.
• Experienced in generating and analyzing Data Profiling reports to formulate data cleansing strategy.
• Expertise in source to target ETL Mappings for Data Migration methodology.
• Experience in migrating Data from Excel, DB2, Flatfiles, XML, Oracle and MS SQL Server to SAP ERP 6.0.
• Used Data Services as an external system for ETL between ECC and BI for cleansing teh data using Data Quality transforms like Match, Associate, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Experienced in debugging and performance tuning of sources, targets and mappings.
• Expertise in debugging teh loading issues with IDOCS in Data Migration process.
• 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.
• Proficient in using Oracle 10g, SQL Server 2005/2008, IBM DB2, Teradata V2R3, MS Access
• Experience in resolving teh issues related to clustered network architecture and simple architecture on BODS.
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Worked with performance tuning tools to improve teh performance & Involved in preparing detailed documentation for reports, migration of reports as well as universes developed.

TECHNICAL SKILLS:

ETL Tools: SAP BO Data Services 4.0/3.1/3.2 (Designer, DS Repository, DS Server Manager, DS Management Console),SAP BO Data Integrator XIR2/6.5, CMC, Designer

Reporting Tools: SAP Business Objects 4.0/XIR3.2/3.1/XIR2/6.5, Xcelicius 2008/4.5, WEBi, Web Intelligence, Crystal Reports

Data Modeling: Erwin r7/r4, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

ERP: ECC 6.0, Oracle

Language: SQL, PL/SQL

Database: Oracle 11g/10g/9i, 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

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

BODS CONSULTANT

Responsibilities:

• Administering teh entire SAP Business Objects Suite including BO reports/Data Services management console, Data Services repository management console
• Created teh Local Repositories, Central Repositories, Profiler Repositories in Oracle 11g and configured teh Local, Profiler repositories with Job server and Management console.
• Created and Maintained Data Services local and central repositories
• Analyze and import teh Source definitions and created target definitions, logical and physical designing of target tables.
• Communicate to teh business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing.
• Involved in creating teh batch jobs for de-duplicating teh data for different sources.
• Worked on making full load jobs in to incremental loads using Map Operation, Table Comparison, and Auto Correct Load.
• Used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in order to load data from source to Target Systems.
• Used lookup, lookup ext functions in Data Integrator to load data from source to Target using a transform Table.
• Migrated teh Autonomy Legacy data to SAP ECC by using teh Data Services through IDOC methods.
• Used SAP Data services (4.0) for migrating data from OLTP databases, SAP R/3 to teh Data Warehouse.
• Data cleansing by filtering teh incorrect records and send teh good data into teh custom build warehouse by creating teh Fact and Dimensional tables in Data Services.
• Created teh Repositories, SAP data stores, read and modified teh custom ABAP transformations, calling RFC reading teh SAP functions to Data Services.
• Designed & developed error catching procedures in BODS jobs.
• Scheduled and Monitor jobs using Data Services Management console.
• Utilized several transformations in ETL jobs developed using Data Services including Date Generation, TEMPEffective Date, Table Comparison, History Preservation, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
• Batch jobs configuration and set repository schedules using Data Services Management Console.
• Involved in root cause analysis on performance tuning by Identifying recurring problems with E2E Exception Analysis and performance of CMS system database
• Worked in Migrating/Exporting teh Data Services code from DEV to Quality and Production systems and import and export teh System configuration and Substitution Parameters from DEV to QA and PROD systems.
• Participate in developing best practices data warehouse standards for building Data warehouse and data modeling.

Environment: SAP Business Objects Data Services 4.0, SAP Business Objects 4.0,SAP ECC 6.0, Oracle11g, SQL SERVER 2008,JD Edwards, Flat Files, Erwin r7

Confidential, Des Monies, IA

BODS Consultant

Responsibilities:

• Interacted with Business Analyst and business users to understand teh business requirements and Gathered requirements for enterprise data warehouse schemas.
• Created Data Integrator mappings to load teh SAP ERP and R/3 tables to Staging area tan to SAP Business Warehouse and Rapid Marts.
• Designed and Debugged ETL process to extract data from Sources systems (DB2, Flat Files) Transform as per business requirements and load teh data into dimensional data models to support BI reports, Dashboard, scorecards.
• Designed, Developed and Debugged complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.
• Used almost all teh transformations like Map Operation, Table Comparison, Key Generation, Query, History preserving, and Case.
• Used Lookup ext, Lookup seq and also created custom functions where repetitive code is required.
• Tuned Data Integrator Mappings and Transformations for teh better performance of jobs
• Created Type3 Dimension job using Query, Table comparison, Map operation and Template Tables.
• Implemented incremental load for extract data from source (DB2) to staging tables.
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality management.
• Developing and modifying changes in data flows according to teh business logic.
• Creating Variables, substitution Parameters
• Creating Workflows, Data flows using Designer.
• Utilized several transformations in ETL jobs developed using Data Integrator including Date Generation, TEMPEffective Date, Table Comparison, History Preservation, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
• Batch jobs configuration and set repository schedules using Data Services Management Console.
• Involved into data conversion from legacy OMS to Autonomy OMS
• Migrated teh Autonomy Legacy data to SAP ECC by using teh Data Services through IDOC methods.
• Data cleansing by filtering teh incorrect records and send teh good data into teh custom build warehouse by creating teh Fact and Dimensional tables in Data Services.
• Created teh Repositories, SAP data stores, read and modified teh custom ABAP transformations, calling RFC reading teh SAP functions to Data Services.
• Involved in root cause analysis on performance tuning by Identifying recurring problems with E2E Exception Analysis and performance of CMS system database
• Implemented performance tuning logic on sources, workflows, data flow’s and targets in order to provide maximum efficiency and performance.
• Involved in writing teh Unit Test Cases.
• Involved in migrating teh jobs from Dev QA and to Production.
• Worked in Migrating/Exporting teh Data Services code from DEV to Quality and Production systems and import and export teh System configuration and Substitution Parameters from DEV to QA and PROD systems by using change management.

Environment: SAP Business Objects Data Services (Designer, Repository Manager, Management Console), SAP ECC 6.0, SAP BI/BW, SAP Solution Manager Diagnostics, Erwin, Microsoft SQL Server, SFDC, Oracle 11i, ATG, SAP Information Steward, Flat files, Linux

Confidential

SAP Data Services Developer

Responsibilities:

• Created Data Integrator mappings to load teh SAP ERP and R/3 tables to Staging area tan to SAP Business Warehouse and Rapid Marts.
• Designed and Debugged ETL process to extract data from Sources systems (DB2, Flat Files) Transform as per business requirements and load teh data into dimensional data models to support BI reports, Dashboard, scorecards.
• Designed, Developed and Debugged complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.
• Comparison, Key Generation, Query, History preserving, and Case.
• Used Lookup ext, Lookup seq and also created custom functions where repetitive code is required.
• Tuned Data Integrator Mappings and Transformations for teh better performance of jobs
• Created Type3 Dimension job using Query, Table comparison, Map operation and Template Tables.
• Implemented incremental load for extract data from source (DB2) to staging tables.
• Used parsing, correction, standardization, duplicate matching for arranging information using Data Quality management.
• Created Data Quality jobs to cleanse and match data based on internal dictionaries.
• Scheduled batch jobs for processing flat files, XML files as source and target.
• Used Global variables, Local Variables and Parameters between Work flow and Data flow as per business requirements.
• Used SAP Data services (3.2/3.1) for migrating data from OLTP databases, SAP R/3 to teh Data Warehouse.
• Configured database Data Stores and File Formats to allow Data Services to connect to teh source or target database and files.
• Migrated ETL jobs as by both exporting and importing ATL files.
• Analyzed and created various indexes to enhance query performance.
• Generated teh reports using teh universe as teh main data providers and writing teh complex queries including sub-queries, unions, intersect and aliases.
• Created @prompts and complex conditions at Universe level for better performance.
• Created Reports using all teh BO functions like Drill Down, Drill Up, Drill Through, Drill By, Prompts and Dimensional and Measure variables for refined Results.

Environment: SAP Business Objects Data Services 3.2, Business Objects XI 3.1, Business Objects Data Quality Management 12.0 /11.7, SAP BI 7.0/BW 3.5, SAP R/3, FICO and SD, SAP BI/BO integration kit, Oracle 11g, SQL Server 2008.

Confidential, Houston TX

Data Integration - Consultant

Responsibilities

• Involved in creating teh database model along with teh solution management team.
• Involved in DQ Process and Data Profiling along with Performance Tuning
• Created ETL design and ETL mapping documents.
• Extracting teh data from flat files which are dynamic in structure using BODI.
• Wrote scripts for creating dynamic tables based on teh structure of teh flat file.
• Created batch scripts for handling dynamic file formats, for creating dynamic data stores and for importing and exporting teh BODI jobs in .xml format.
• Developed complex batch jobs using BODI.
• Used various DI transformations like Pivot, Reverse pivot, Table Comparison, Map Operation, etc. and DQ transformations like Address cleansing, ISO country code, Data cleansing, Match, etc.
• Involved in teh Integration Testing and Bug fixing.
• Review of Mappings dat are developed by teh team.
• Used Central Repository to check in and check out of teh jobs to maintain version history and for multi user development.
• Developed mappings using number multiple transformations for moving data from client environment to Staging Area and tan to Ware house.
• Extracting, Transforming and Loading teh Data through SQL Server 2008 Scripts.
• Responsible for timely and efficient delivery of allocated modules

Environment: Data Integrator BODI 6.5, MS SQL Server 2008, Oracle 10g, Erwin r 3.5, Windows

Confidential

Software Engineer

Responsibilities:

• Interacted with end users for gathering requirements
• As a part of 3-member team, was involved in design, development and implementation of teh module
• Tuned stored procedures and triggers identified for better performance
• Creating Tables, indexes constraints and improved database performance
• Involved tuning and applying teh SQL statements and PL/SQL processes
• Creation of different kinds of reports about Tables, Views, Synonyms etc from teh Oracle Database.
• Involved in complete documentation using MS Office

Environment: Oracle 9i, MS Excel, PL/SQL, HTML, UNIX, C, C++, Windows 2000 / XP

Confidential

System Analyst

Responsibilities:

• Understanding Client requirements.
• Developing complex crosstab Reports.
• Reviewing Reports developed by team mates to ensure quality of deliverables.
• Preparing templates for Report documentation, Test Cases.
• Documenting teh Reports developed.
• Unit testing teh reports.

Environment: Oracle 8i, SQL, PL/SQL, UNIX