SUMMARY:

• 10 years of professional IT experience in analyzing requirements, designing, building, highly distributed mission critical products and Applications.
• Worked as a ETL Developer and SQL developer as a SAP - BODS Technical Consultant using Business Objects Data Integration Data Services(BODI/DS 3.2, 4.0 and 4.2)
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS) and Business Objects Web intelligence reporting.
• Implementing RFC connection and them to interact with SAP systems.
• Implementing ABAP data flows in SAP BODS to extract the data from SAP ECC system.
• Implemented Slowly Changing Dimension - Type 2 (SCD - Type 2) for the required dimensions by using TABLE COMPARIOSN Transform, HISTORY PRESERVING Transform and KEY GENERATION Transform
• Used the LOOKUP EXT functions to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables
• Experience in debugging execution errors using Data Services logs (Trace, Statistics, and Error).
• Tested data flows and scripts against sample data and real data.
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
• Experience in Automation of jobs through Management console & creating Batch jobs based on Client requirement.
• Configuration of Local Repository for each application Environment.
• Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Project Management and Testing.
• Knowledge on developing logical and physical schema of the database using data modeling.
• Experienced with SQL queries, views and stored procedures
• Extensively worked on Metadata management for user provided files.
• Knowledge on Repository Manager Configuration, Job Server configuration, Management Console.
• Experience in Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
• Experience in Release management process including development, testing and production.
• Worked on SAP BODS Information Steward like creating the rules, binding rules, score card setup and data profiling.
• Worked in preparing technical documents like Data Mapping Document and Unit testing evidence documents.
• Worked on validations on preproduction and production deployments.
• Troubleshoot failed jobs in Preproduction and production environments
• Communicate and Co-ordinate with Offshore

TECHNICAL SKILLS:

ETL Tools: Business Objects Data Services XI 3.2/4.0/4.2

ERP: SAP R/3 (4.6 C/4.7), ECC 5.0, ECC 6.0

Databases: SAP HANA, Teradata, Oracle 10g, SQL Server 2005/2008.

Reporting: SAP Business Objects, Web I report

Others: SQL, Big Data Tools HADOOP HDFS, Map Reduce, PIG SQOOP and BPM tool PEGA

MS: Dos, Windows 9X, Advanced 200X Server and Linux

Packages/Tools: Remedy, HPQC

Programming Languages: C, C++, Java, SQL,PL SQL

PROJECTS EXPERIENCE

Confidential

SAP BODS developer

Responsibilities:

• Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts.
• Involved to preparing data mapping reports and built Jobs for different subject areas and tested thoroughly.
• Creating project flow like jobs, Workflows and Data flows
• As part of production support Monitoring daily ETL and Informatica Cloud scheduled jobs.
• Trouble shooting the issues and fixing them.
• Working on code migration from low level envo to high level envo like DEV, QA to PROD
• Scheduling the jobs in CA workload automatation ESP edition and in Informatica cloud
• Creating connections in IC and migrating the code from lower envo to prod envo
• Set up the DS inbuilt and third party schedules
• Run the jobs for monthly end loads on adhoc basis
• Writing SQL scripts for Data base changes
• Working on incidents to fix issues and debugging them to resolve
• Creating batch files and schedule them in third party tool
• Adhoc execution of the jobs in Management Console.
• Used the LOOKUP EXT function to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables
• Resolve the issues based on request submitting by the Users
• Creating new datastores to connect different servers
• We Implemented Recovery Mechanism for unsuccessful batch jobs execution.
• Giving on call support for fixing the issues of failures
• Working on Map operation, Case, Table comparison, history preserve and key generation transformations
• Attending the daily meetings and discuss with requirements and about solving the issues
• Prepared mapping documents and deployment instructions documents and shared them into business folders.
• Maintaining BODS Security as per the client specifications and Interacted with client on daily status calls.
• Reloading the data for the particular period of missing data.
• Create and manage Jobs for Data extract and Load.
• Identifies bad records and root cause of the them and avoid them loading into tables.
• Worked on daily and monthly manual loads.
• Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator.
• Implemented SCD Type2 for the customer selected dimensions using Table Comparison, History Preserving and Key Generation transforms.
• Working with source team for the required source data.
• Daily interaction with the clients to provide business expected results.
• Executed complex jobs in Debug mode and traced out errors using logs.
• Deployed the jobs and validating them in PPD and PROD environments.

Technologies: Business Objects Data Services 4.2, SQL Server 2005, Oracle 10g, CA Workload automation (ESP edition), Informatica cloud

Confidential, Englewood, NJ

Sr. SAP BODS Consultant

Responsibilities:

• As Sr. SAP BODS Consultant worked in multiple projects as ETL developer.
• Extracting the data from SAP ECC Extractors, tables and deliver data to Target Teradata, flat files using SAP BODS.
• Implementing ABAP data flows in SAP BODS environment to extract the SAP ECC tables.
• Implementing RFC connections and testing them to communicate with SAP systems.
• Defined separate data store for each database to allow Data Services to connect to the source or target database.
• Strong experience in Object development using extract, mapping/transform tools
• Experience writing the SQL scripts
• Worked on SAP BW Source and targets like Open hub destination, Transfer structures in SAP BODS
• Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts.
• Worked on SAP BODS Information Steward like creating the rules, binding rules, score card setup and data profiling.
• Set up the DS and IS inbuilt and third party schedules
• Test planning, processing/tracing messages, researching errors and conducting root cause analysis to identify corrective action
• Implemented the changes in jobs according to the change request document.
• Implemented parallel processing (multithreading) for better performance.
• Extracted data from Flat Files, Databases and moving into staging area and transform and finally load into the Oracle as target.
• Developed different phases like Stage, SDL, EDW(EL - Enterprise Layer) to process the data
• Modifying the incoming data through Platform, Data Integrator transforms.
• Creating batch jobs, workflows, dataflow and mappings.
• Creating sequence and parallel workflows and data flows.
• Experience on parse, cleanse, match and Data profiling/analysis
• Implemented SCD Type2 for the customer selected dimensions using Table Comparison, History Preserving and Key Generation transforms.
• Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator.
• Used BODS Data Integrator Transforms PIVOT and REVERSE PIVOT to apply the row level and column level transformation according to reporting requirement and implemented without PIVOT Transforms by wiring the SQL scripts.
• Worked with Source teams in case of any issues with provided source data
• Work with operation different push down operation to increase the performance.
• Deployed ETL objects from development to production and Quality.
• Involved in Unit Testing and Integration testing.
• Creating local and central repositories as per client requirements.
• Worked on HPQC (Quality center) as a part of testing the reports to identify the defects.
• Good Experience with ETL process and concepts

Technologies: Business Objects Data Services 4.2, Teradata, 13, DB2 UDB 9.x, Oracle 10g, SQL

Confidential, Westlake, CA

SAP BODS Consultant

Responsibilities:

• Extracting the data from SAP Extractors, Tables, SAP BWSources, flat files, Excel, Oracle which are dynamic in structure using BODS.
• Implemented dynamic SQL queries to load the data into target.
• Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts.
• Involved to preparing DMRs and built Jobs for different subject areas and tested thoroughly.
• Worked on Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
• Conduct root cause analysis and resolve production problems and data issues Manage reporting meta data and data standardization for end to end integration
• Implemented the changes according to the change request document.
• Sharing Documents in a centralized shared folders
• Worked on SAP BODS Information Steward like creating the rules, binding rules, score card setup and data profiling.
• Set up the DS and IS inbuilt and third party schedules
• Extensively working on SAP BODI Designer Components- Projects, Jobs, Workflows, Data Flows, ABAP Data flows, Data Store and Transformations, Formats.
• Implementing RFC connections to communicate with SAP syatems.
• Designed various mappings for extracting data from SAP Source systems and relational tables.
• Ability to define database Data Stores and File Formats to allow DS to connect to the source or target database and files.
• Good experience on planning, executing, monitoring and control
• 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. Query transformation, Merge, pivot, Case, Table comparison, Key Generation and map operation transformation.
• Created the embedded dataflow to reuse the logic.
• Developed SCD Type2 Effective Date Range by using History Preserving transformation according to the business requirements.
• Implemented Recovery Mechanism for unsuccessful batch jobs execution.
• Worked on transforms like query, table comparison, SQL, CDC, merge, case, key, date generation.

Technologies: Business Objects Data Services 4.0, SAP HANA, SQL Server 2005, Oracle 10g, DB2 9.x, SQL

Confidential

BODS Consultant

Responsibilities:

• Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts.
• Involved to preparing DMRs and built Jobs for different subject areas and tested thoroughly.
• Worked on Business Objects Data-Integrator, and used functions like lookup, date, conversions, etc in mappings.
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the BW open Hub tables to extract the data from the BW.
• Created Global variables to read the files from the shared location from the BODS Designer
• Conduct root cause analysis and resolve production problems and data issues Manage reporting meta data and data standardization for end to end integration
• Sharing the Documents in centralized shared folders and test evidences.
• Worked extensively on the life cycle management, in moving the reports from the environments of developing, testing and production.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
• Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implement in Data Integrator jobs.
• Migrated all the Projects of the team from DEV TO TEST TO PPD TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Resolving the tickets within a specified SLA time.
• Implemented conditional flow to load either full load or delta load.
• Monitoring the jobs and report failed jobs

Technologies: Business Objects Data Services 3.2, SQL Server 2005, Oracle 10g, DB2 9.x, SQL

Confidential

BODS Consultant

Responsibilities:

• Extensively working on SAP BODI Designer Components- Projects, Jobs, Workflows, Data Flows, Data Store and Transformations, Formats.
• Validate the data using Validation Transformation.
• Involved in the exception handling to trace the error log.
• Experienced in designing and implementing different types of data flows which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc, using Business Objects Data Services/Data Integrator.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
• Created project flow like Project, jobs, work flows and data flows based on client standards.
• Created Metadata data jobs and validated
• Prepared mapping documents and new change requests info
• Submitted jobs to run schedule run
• Created and Worked on SAP Components -Data Flows, Data Store and Transformations, Formats.
• Involved for project Deployments in higher environments.
• Implemented change requests and validate them.
• Generated Business Objects webi reports.
• Worked on defect fixing for business objects data services jobs.
• Imported and exported the ATL’s in different environments.

Technologies: Business Objects Data Services 3.2, SQL Server 2005, Oracle 10g, DB2 9.x, SQL, Business Objects (Web Intelligence (Webi))

Confidential

Software Engineer

Responsibilities:

• Scheduling and monitoring the jobs
• Creating local and central repositories as per client requirements.
• Extensively worked on management console and running the jobs on adhoc basis
• Creating Users and providing access to them.
• Configuring Job Servers with repositories.
• Extracted data from Flat Files, Databases and moving into staging area and transform and finally load into the Oracle as target.
• Adhoc execution of the jobs in Management Console
• Troubleshooting day to day technical issues and monitoring the jobs and report failed jobs
• Created workflows using object library and tool palette to execute data flows
• Maintaining BODS Security as per the client specifications.
• Interacted with client on daily status calls.
• Created, Tested and Executed data integrator jobs using designer to transfer data from source to
• Resolving the tickets within a specified SLA time.
• Implemented conditional flow to load either full load or delta load.
• Created Mapping document and handover to ETL Testing team

Technologies: Business Objects Data Services 3.2, SQL Server 2005, Oracle 10g, DB2 9.x, SQL