SUMMARY:

• Over 4 years of experience in ETL, Data Migration and Business Intelligence using SAP Business Objects Data Services, SAP Business Objects Suite - Information Steward and We Intelligence.
• Expertise in SAP Business Objects Data services - Data Marts, Data Integrator and Platform Transformations, Debugging, Data Services Management Console and Performance Optimization.
• Strong ETL experience in using legacy source systems like Flat Files, CSV files, Excel workbooks, SAP and Non-SAP systems using SAP Data Services (BODS 3.x/BODS 4.0/4.1/4.2).
• Worked extensively on integration of Business Objects Data services with SAP modules such as SAP ECC, BW, HANA and Non - SAP Data sources like Oracle 11g, Teradata, Microsoft SQL server 2008/2012 and MySQL.
• Expertise in extracting and loading legacy data using SAP BODS to SAP ECC using LSMW tool and IDOCS and using ABAP data flows and Data transports to extract the data from ECC tables.
• Worked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment with SAP Data Services and Information Steward.
• Hands on experience in creating Projects, Jobs, Data stores, Data Flows, Work Flows, Transforms, and Functions, writing Scripts, defining custom functions and declaring variables.
• Responsible for Scheduling Jobs, Validation, Tracing and debugging Batch jobs using break points and examining the logs and error handling using Try and Catch mechanism.
• Worked extensively on Repository Manager, Server Manager and created local, central and profiler repositories and configured local and profiler repositories with the job server and management console.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Resolved technical issues in the ETL development by Architecture and Code modification.
• Experience in recovering the data from failed sessions and workflows.
• Strong Exposure to SQL, PL/SQL and Multi dimensional modelling - Star Schema and Snow Flake Schema.
• Strong experience in Data Services Management Console to monitor, schedule and run jobs, manage Repositories and Metadata Reporting.
• Experienced in SAP HANA Data Provisioning and with Data Extraction Transfer Loading (ETL) using SAP Data Services.
• Have expertise in SAP Basis, BOBJ reporting, Tableau and Qlik Sense.
• Experience in complete life cycle of development and implementation.
• Excellent understanding of Development LifeCycle and expertise in Data Warehousing using Agile Methodology
• Good Team Player with excellent communication, analytical, and documentation skills.

TECHNICAL SKILLS:

ETL Tools: SAP Business Objects Data Services

Databases: SQL Server 2008/2012, MySQL, Oracle 11g, 10g, 9i/ 8i

C, SQL, PL/ SQL,T: SQL, HTML/CSS

Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office, Erwin.

Platforms: Windows, Linux

BI Tools: SAP Business Objects Web Intelligence, BEx Query Designer, BEx Analyzer, Desktop Intelligence and Dashboards.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BO/BODS Consultant

Roles and Responsibilities:

• Attended several meetings to gather the requirements and prepared Functional and technical specification documents.
• Responsible for ETL design and development and BI reporting for the project.
• Developed batch jobs to pull the data from different sources and load the same into Target.
• Integrated data using Platform Transforms such as Query, SQL, Case, Merge and validation transforms.
• Defined separate data store for SAP BW, SAP HANA, Oracle database to allow Data Services to connect to the source and target systems.
• Used Date functions, String functions, and Database functions to manipulate and format source data as a part of Data Cleansing process.
• Experienced in using scripts, local variables, Global variables, Custom functions, Substitution parameters, recovery logic and error handling mechanisms.
• Migrated data flows, workflows, scripts, and jobs between repositories.
• Expertise in extracting and loading legacy data using SAP BODS to SAP ECC using LSMW tool and IDOCS and using ABAP data flows and Data transports to extract the data from ECC tables.
• Documented and maintained Detail Design specifications, Source to target mapping documents, which have detail steps of transformation rules.
• Installed BODS, Created Local repository, Configured Job server, registered local repository to CMC, Used Central Management Console for Creating users and user groups, restricted access of the users.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor and error) and by examining the target data using debug mode.
• Created universe by using Information Design Tool (IDT) from the database.
• Developed complex WEBI Intelligence reports by using BI Launchpad, Web Intelligence with Input controls, Charts, Cross tab reports, Sections, Breaks, hide/show, Drill down, Drill up, Filter bars.
• Created dashboards in Qlik Sense and enhanced the scripts for delta load.

Environment : SAP Business Objects Data Services 4.2, Web Intelligence, Xcelsius 2008, Crystal Reports 2008, Oracle 10g/11g, PL/SQL, Information Design Tool, CMC, Qlik Sense 3.0.

SAP BO/BODS Consultant

Confidential

Roles and Responsibilities:

• Designed and Developed ETL jobs using BODS for migration of data from Source DW to Target system.
• Actively involved in requirements gathering, design discussions, source data analysis, preparing mapping document and design documentation.
• Developed flat file formats to load staging jobs from different sources like flat files, excel workbooks and .csv files. Extensively used lookup, lookup ext functions in Data Integrator to load data from source to target.
• Performed extract, transform and load operations using BODS transformations such as Query transform, SQL Transform, Row generation, Table comparison, History preserving, Map operation and Key generation transform.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation for Slowly Changing Dimensions Type-2.
• Performed incremental loads using Map operation, Table comparison transforms, Auto correct load options based on the operation code to insert/update/delete.
• Used SQL Server to write SQL queries, joins to test ETL tables.
• Created Scripts, declared local Variables, global Variables and fine tuned complex transformations in the data flows.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data Cleansing process.
• Implemented Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level.
• Worked on complex SQL analysis, implementation and testing for change requests and defects.
• Performance tuning of SQL queries like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs, implementation of recovery mechanism, Error handling and setting up validation rules.
• Using Data Services Management Console to schedule and run jobs, Manage Repositories and perform Metadata Reporting.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Stacked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Actively involved in Proof of Concept on usage of SAP HANA 1.0 SP8.
• Experience in SAP HANA Data Provisioning with Data Extraction Transfer Loading (ETL) using SAP Data Services.
• Integrating SAP and Non SAP Data through Data Services into HANA DB.
• Experience in setting up connection to SAP HANA and loading data through data services.

Environment : SAP Business Objects Data Services XI 3.2,4.0/4.2, SAP BI/BO 4.0,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio, SAP HANA.

Confidential

SAP BO Consultant

Roles and Responsibilities:

• Designed and developed ETL Jobs based on the business requirements.
• Developed the Mapping requirements document by converting the functional requirements into technical requirements.
• Extracted data from SAP BW and MS SQL Server into the Business Objects Data Services 4.0 and developed data flows with change data capture at source to extract the data.
• Built jobs with validation, error handling and change data capture capabilities.
• Developed complex source to target mappings based on the reporting requirements for fact and dimension tables.
• Equipped the job with error handling capability in such a manner that the records failing validation are combined with the next load source data and are loaded in the next load.
• Used Slowly changing dimensions for handling the newly incoming data as inserts and updates.
• Unit tested the jobs to analyze the performance and debugged them
• Tuned previously built jobs to optimize performance, reduce runtime and enhanced their error handling capabilities.
• Used SQL, Table Comparision, Validation, Map Operation, Key Generation, Case, Merge, Reverse Pivot transforamtions extensively in developing complex ETL mappings
• Used global varaibles, local variables and parameters to control the data flow through different work flows and different ETL processes
• Used Lookup ext, Lookup seq, Decode and other functions and developed custom functions based on the requirement.
• Developed scripts to control the execution as a part of the integration work.

Environment: SAP Business Objects XI 3.1/3.2, SAP BW 3.5, MS SQL Server 2008.

SAP BO / BODS Consultant

Confidential

Roles and Responsibilities:

• Worked on the design & development of ETL jobs using BODS 3.2.
• Designed data load jobs from various data sources like flat files, Oracle database and .csv files.
• Performed extract, transform and load operations using BODS transformation logic such as Query transform, SQL Transform, Case transform, Row generation, Pivot, Reverse Pivot transform, Date Generation,, Table comparison, Merge and Validation transform and data load of result into target databases such as Oracle by creation of data stores using ODBC connection.
• Used transforms to handle Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimension Tables.
• Used Pre load and Post load command options to handle complex scenarios during incremental load
• Worked on complex SQL analysis, implementation and testing for change requests and defects.
• Performance tuning of SQL queries, implementation of recovery mechanism, Error handling and setting up validation rules.
• Implemented Bulk-loading mechanism to load data into Oracle tables for faster performance.
• Responsible for defining Validation and Audit rules and route the bad data to Error tables.
• Prepared the mapping documents for data sets from each source systems, by conducting multiple workshops with the business users and respective technical teams.
• Management of repositories, scheduling and execution of batch jobs, configuration of repositories for profilers and job servers using Data services Management console.
• Involved in unit testing, system testing and documentation of the same.

Environment: SAP Business Objects Data Services XI3.1, Oracle Database.