Summary of skills:

• Around 8 years of Software Industry experience services and product development
• 6 years of experience in Analysis, Design and Development of various Data Warehousing /Data Migration projects using SAP BODS/BODI and Informatica.
• Certified SAP Certified Application Associate Business Object Data Integrator XI R2.
• Extensively worked on BODS/BODI Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Implemented 2 complete Lifecycle Data Services projects including requirement gathering, data modeling, extractions, data staging, data cleansing, data quality and transformations and reporting
• Involved to define the validation rules and bind those rules to against the specific columns.
• Involved to setup the Scorecards and associate the Data Quality dimensions.
• Develop Information Steward Exception Reports for project.
• Includes scheduling reports and notifying 'End Users' when there are exceptions.
• Involved in Migration of Jobs and workflows from Development to Test and to Production Servers to perform the integration and system testing.
• Worked on different Data Quality transforms and Data Integration transforms and Platform transform.
• Worked on Change Data Capture on both SOURCE and TARGET level and implemented the SCD Slowly changing Dimension Type 1, Type 2 and Type 3.
• Design, Develop and Debug complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Data Integrator/SAP Data Services with Oracle, SQL Server.
• Extensively worked on data loads from BODS to BW System.
• Involved in Development, Migration, Support and Admin activities.
• Have good Experience in Management Console i.e. Scheduling, monitoring jobs .
• Extensively worked on simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows.
• Extensively worked on Performance Tuning of the jobs.
• Extensively worked on BODS Administration Tasks like Repository Configuration, Job Server configuration, Local Repository configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Extensively worked on Data Extraction from SAP ECC or Legacy Systems to SAP BW system as a Target By using SAP BODS.
• Installed Information Steward 4.x and configured with data services.
• Associated the job server to registered IS Repository by using Server Manager.
• Extensive experience and proficient in Designing and Developing ETL routines using Business Objects Data Services Data Migration with All In One AIO best practices methods and Pl/SQL.
• Good experience in LSMW, ABAP flows, BDC, and IDOC's integrated with Data Services.
• Installed and configuring the Business Objects Data Services 4.1, with SAP BI handling SAP DS admin activities and Server configuration
• Experience in migration of objects from one environment to other environment by using Promotional Management.
• Created the Users and Groups for setup the user security as for business by using BO CMC.
• Experience in creation of users and assigning rights to users and security related.
• Migrating Promoting also updating content between multiple Business Objects Environments.
• Design and write jobs to fetch data from SAP BW using the Open Hub Destination, kicking off the process chains and also pushing the data to the BW DSOs using the external source system configurations.
• Extensively Created SAP BW connection to interact with SAP BODS using RFC connection.
• Good knowledge for Create Info Object, Data Source, Info Source, Info Area for SAP BW.
• Worked on User Defined Transform Global Address cleaning, Match transformations to clean the data by using Data Quality transformations in BODI/BODS.
• Worked on UTD Quality Transformation and wrote Python Expression Script for eliminating the Invisible Special Characters in source system And loaded into BW Target System.
• Worked on loading data into different IDOCS for Customer Master, Material Master and Vendor Master using DEBMAS, MATMAS and CREMAS IDOCS by referencing SAP AIO jobs.
• Analysis and development of mappings using needed transformations using Informatica.
• Extensively worked on Informatica ETL Tool.
• Used ABAP Data flows to extract huge volume of data from SAP Systems.
• Based on the volume if the data we have scheduled multiple Jobs from Management Console..
• Good Experience on Hana system for data loads from legacy system to Hana System
• Good knowledge on UNIX and Shell scripting.
• Involved in Hadoop connectivity configuration for BODS 4.1.
• Good Knowledge on data loads from Hadoop to Hana Data Base for using BODS As ETL.
• Exposure on data loads from COBOL .CPY file to Hana System for using BODS.
• Highly skilled, self-motivated team player, outstanding organizational and excellent communication and interpersonal skills with results oriented dedication towards goals.

Technical Skills

• Operating Systems: Windows 98, Windows NT, Windows 2000,Unix
• ETL Tools: SAP BODS/DI 4.1/4.0/3.2,Infomatica
• Languages: SQL,PL/SQL, Core Java
• Databases: Oracle 11g/10g/9i,Sql Server 2000/2005/2008,Sybase IQ,Hana 1.0
• ERP: SAP BW,SAP ECC
• Reporting Tools: SAP BEx, SAP BO 4.0 XP2
• Admin: SAP BODS,SAP BO

PROJECT EXPERIENCE

Confidential

SAP BOIS/DS Consultant

• Preparation Technical Design documents based on Functional documents.
• Involved to define the validation rules and bind those rules to against the specific columns.
• Involved to setup the scorecards and associate the Data Quality dimensions.
• Develop Information Steward Exception Reports for project.
• Includes scheduling reports and notifying 'End Users' when there are exceptions.
• Configured Email notification to Business users when rules refresh happened.
• Created multiple data store configurations in Data services local object library with different databases to create unified data store.
• Extensively work on Installations and configure the repositories and establish the data source connections.
• Participating in all Technical discussions, meetings and mounting the discussion points.
• Sharing his knowledge among the team.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows
• Providing visibility into the work on regular basis.
• Complying to the Policies of the engaging company and client company, if any.
• Working with the project team, peers, Managers and other stakeholders to achieve the objectives and delivering maximum value to the project success.

Confidential

SAP BODS Consultant

Responsibilities:

• Installed and configuring the Business Objects Data Services 4.1, with SAP BI, ECC handling SAP DS admin activities and Server configuration.
• Involved in writing validations rules and generate score cords, Data insights, Matapedia, Cleansing package builder by using Information Steward 4.x
• Configured different repositories Local, Central, and Profiler and job server.
• Involved in meetings with functional users, to determine the flat file, Excel layouts, data types and naming conventions of the column and table names.
• Prepared mapping documents capturing all the rules from the business.
• Created SAP BW connection to interact with SAP BODS using RFC connection.
• Created Info Object, Info Source, Info Area for SAP BW.
• Created multiple data store configurations in Data services local object library with different databases to create unified data store.
• Using Data services Created Batch and Incremental load Change data capture and wrote initialization scripts which control Workflows Data flows
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows.
• Created Data Flows for dimension and fact tables and loaded the data into targets in SAP BW
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs in different ways like indexing the source tables and using Data transfer transformation.
• Scheduling jobs to run daily.

Environment: SAP BODS 4.1, Oracle11g, SAP ECC, SAP BW 7.3,SAP BO 4.0, Windows.

Confidential

SAP Data Services Consultant

Responsibilities:

• Installed Business objects Data services version 4.0 and configured different repositories Local, Central, and Profiler and job server.
• Involved in Installation of SAP HANA 1.0.17, SAP BODS and SAP BO.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA.
• Involved in meetings with functional users, to determine the Oracle layouts, data types and naming conventions of the column and table names.
• Prepared mapping documents capturing all the rules from the business.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs in different ways like indexing the source tables and using Data transfer transformation.
• Created Attribute, Analytical and Calculated views as per the requirement needs.
• Created procedures in HANA Database.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed testing scripts and performed UT, SIT and UAT.
• Migrated HANA content from development, testing environment to Production Environment using delivery units.
• Scheduling jobs to run daily.

Environment: SAP BODS 4.0, Oracle11g, SAP HANA, Windows.

Confidential

SAP BODS Developer and Data Migration Consultant

Responsibilities:

• Extensively worked on AIO All In One methodology, an SAP preferred methodology for migrating the data to SAP.
• Worked on Material Master, Bank master and Media Objects.
• Analysed Mapping sheet and raised Issues in the Issue log if any.
• Worked on Defects and CR's during the data loads.
• Created delta Jobs to load data from legacy source to SAP system based on the business rules provided.
• Analysed the error log for trouble shooting batch jobs.
• Interacted with Functional team to fix the load errors at ETL end.
• Supported in all the phases Dev, QA and Production of Project.
• Supported 24 7 during the data loads.
• Participated in the Daily and weekly status calls and reporting the Object status and communicating Object Issues.

Environment: SAP BODS 4.0 3.2, Oracle 10g, SAP ECC, Windows

Confidential

ETL Developer

Responsibilities:

• Mainly involved in ETL Development/Enhancement.
• Analyzed the sources, targets, transformed the data, and mapped the data and loading the data into Targets using BODS.
• Developed various Jobs, Workflows, Data Flows and Transformations for migration of data using BODS Designer.
• Designed various mappings for extracting data from various legacy Systems.
• Using designer to create source definitions, design targets, create jobs and develop transformations.
• Created different transformations for loading the data into oracle database e.g. Merge, SQL, Query, Table Comparison, Map Operation and History Preserving transformations.
• Created Scripts using BODS Designer.
• Involved in Unit Testing and prepared Test Case.
• Resolving if any issues in transformations and mappings with help of Technical Specifications.

Environment: SAP BODS 4.0, 3.2, Oracle 10g, Windows

Confidential

ETL Developer

Responsibilities:

• Involved in the development and implementation of the Enterprise Data Warehousing EDW process and Data Warehouse.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations etc .
• Extensively used ETL to load data from flat file and also from the relation database.
• Extracted data from different sources such as Flat files, Oracle to load into Sybase IQ database.
• Ensuring proper Dependencies and Proper running of loads Incremental and Complete loads
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Environment: SAP BODS 3.2, Oracle10g, Sybase IQ, Windows.