SUMMARY

• 10 years of professional IT experience in analyzing requirements, designing, building, highly distributed mission critical products and Applications.
• Experience working with world class companies like Cap Gemini, Accenture.
• 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) usingBusiness Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS) and Business Objects Web intelligence reporting.
• Experience in analysis, Design, development and Testing of SAP Business Objects Data Integrator/Data Services and Business Objects.
• Experience on parse, cleanse, match and Data profiling/analysis
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts usingAccentual Data stage
• Expertise in SAP ERP extraction from R/3 4.7, ECC 6.0,SAP BW, SAP HANA and non SAP extraction.
• Experience on data mapping between Legacy-to-SAP
• Experience writing the SQL scripts.
• Strong in SAP BODS and IS Skills with SAP and Non-SAP Source
• Worked on SAP Extractors, tables and IDOC as Sources and in Business Objects Data Services.
• Worked on SAP BW source (Open hub Destination) and target (Transfer structures) in SAP BODS.
• Experienced to create and manage Jobs for Data extract and Load.
• Communicate and Co-ordinate with Offshore.
• 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.
• Design and developing SAP Business Objects Data Services jobs using Flat Files, Excel Sheets, Databases as sources & targets.
• Experience in using platform transforms and integration transforms.
• Implemented Multithreading concept and created multiple layers for better performance.
• Designed an ETL Job which integrates Flat file and XML data, loads into single target using XML PIPELINE and MERGE Transforms
• Used BODS Data Integrator Transform PIVOT to apply the row level and column level transformation according to reporting requirement
• 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
• Implemented an ETL logic to identify the Holiday of the Year by adding a new column as indicator in the Time Dimension
• Used the LOOKUP EXT and LOOKUP SEQ 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).
• Experience in the Design, Modeling, Development and Testing of Data warehouse housing and other applications using Object Oriented Analysis, Design and Methodologies.
• Worked in multiple responsibilities includingETL design,analysis and development, writing technical specifications.
• Exposure toSQL,PL/SQL,RDBMS (Teradata 13, Oracle8i/9i/10gandMSSQL Server 2005)
• Created projects, batch jobs, work flows and data flows.
• Creating Users, Installing client software on local machines, Creating Profile server, Configuring Web administrators, creating users to monitor Jobs onCMCofETL tool BO Data Integrator.
• Worked on the DI scripting for different functionalities, including FTP the files to the exchange servers etc.
• 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.
• Worked on Data Migration methodologies specifically SAP to Non SAP systems
• Experience in Automation of jobs through Management console & creating Batch jobs based on Client requirement.
• Configuration of Local Repository for each application Environment.
• Working on windows for Flat files storage & Scheduling jobs.
• Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Project Management and Testing.
• Thorough understanding of Software Development Life Cycle (SDLC), including requirements specifications, design specifications, development, testing and implementation
• 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.
• Having Good Knowledge on Data Quality.
• 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.
• Good knowledge in Design Patterns.
• Experience data migration from SAP ECC into Teradata.
• 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
• Experience in Data Profiling for Data Quality to Achieve Quality Data.
• Experience with using SAP ECC and Legacy systems as source and SAP as a target with SAP Data Services
• Worked in preparing technical documents like Data Mapping Document and Unit testing evidence documents.
• Worked on validations on preproduction and production deployments.
• Experience in Data Migration methodologies, specifically around converting from legacy FC codes to BW codes.
• Handover to the Application teams on the jobs/Modeling/Mapping logics/Transformations.
• Worked on UAT defects and fix provide the resolution under SLA.
• 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

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

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

Packages/Tools: Remedy, HPQC

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

PROFESSIONAL EXPERIENCE

Confidential, Englewood, NJ

Sr. SAP BODS Consultant

Responsibilities:

• Sr. SAP BODS Consultant working multiple projects as ETL developer.
• Extracting the data from SAP ECC Extractors, tables, IDOCs and deliver data to Target Teradata 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
• Worked on Setup, mapping, IS DS profiling, configuration, data conversion and transformation, validations, load to SAP IDOC’s,
• Experience on Creation of single-use, reusable objects and usage of lookup tables
• Design, develop, unit test and implement Extract, Transformation and Load (ETL) processes, programs and scripts. create and manage Jobs for Data extract and Load
• Recorded statistics of files in a database like tracking number of records received, processed, time taken to process, etc., and also handled the exceptions.
• Experience in Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
• Implemented dynamic SQL queries to load the data into target.
• Experienced in SAP BODS and IS Skills with SAP and Non-SAP Source
• 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
• Migrate data to/from data staging tables in Oracle
• 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.
• Involved as SAP BOBJ ETL Developer from Realization phase in End-to-End Data Warehouse implementation project.
• 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.
• Implemented ETL logic by using built in functions ADD MONTHS to extract immediate two months of data (current and immediate previous month) when executing the job in first three business days in an every month and else it should extract only current month data in reaming days in a month.
• 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.
• Used the LOOKUP EXT and LOOKUP SEQ functions to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables
• Involved in reviving the ETL technical specification documents, identified the gaps and updated the technical specs(Mapping Reports)
• Implementing Teradata fast load.
• Communicate and Co-ordinate with Offshore.
• Extracted sample data from SAP ERP ECC 6.0 source system and tested by running the sample reports.
• Involved in SAP-ECC Maintenance activities for Cutover Outage and we work together as a team with Basis during the Down time.
• 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.
• Worked with Source teams in case of any issues with provided source data
• Work with operation different push down operation to increase the performance.
• Enabled the bulked loading at target system.
• Extract data from.xsd files using xml pipeline Transformations.
• Deployed ETL objects from development to production and Quality.
• Involved in Unit Testing and Integration testing.
• As a part of production support, worked on priority defects.
• We Implemented Recovery Mechanism for unsuccessful batch jobs execution.
• Scheduling and monitoring the jobs.
• Created Global variables to read the files from the shared location from the BODS Designer
• Prepared mapping documents and deployment instructions documents and shared them into business folders.
• Creating local and central repositories as per client requirements.
• Extensively worked on management console and running the jobs on Adhoc basis
• Configuring Job Servers with repositories.
• Adhoc execution of the jobs in Management Console.
• Troubleshooting day to day technical issues.
• Maintaining BODS Security as per the client specifications and Interacted with client on daily status calls.
• Worked on data migration SAP ECC Extractor to Teradata
• Worked on HPQC (Quality center) as a part of testing the reports to identify the defects.
• Executed complex jobs in Debug mode and traced out errors using logs.
• Deployed the jobs and validating them in PPD and PROD environments.
• Monitoring the jobs and report failed jobs
• Worked on performance tuning options and Build and maintain mapping tables.
• Good Experience with ETL process and concepts

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.
• Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems.
• Worked on Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
• Coordinated with other teams for code approvals.
• 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.
• Review of Mappings that are developed by the team.
• Sharing Documents in a centralized shared folders
• Exposure to Data Service Architecture data service objects, data service design interface, data sources, Importing Meta data, File formats.
• 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.
• Created workflows using object library and tool palette to execute data flows.
• 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.
• Experience writing the SQL scripts
• Good experience on planning, executing, monitoring and control
• Experience on maintaining strong relationship with client leads and non-SAP application owners in the business.
• Experience on parse, cleanse, match and Data profiling/analysis
• 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.
• Worked on data migration from NON SAP systems to SAP HANA.
• Developed SCD Type2 Effective Date Range by using History Preserving transformation according to the business requirements.
• Good experience on SQL to perform selects, updates, Inserts and Deletes on database tables.
• Checked the output according to the specifications.
• Creating and administering the metadata DS repository in a multi user environment.
• Deployed ETL objects from development to production and Quality.
• Proficient in designing in implementing scripts.
• Implemented Recovery Mechanism for unsuccessful batch jobs execution.
• Used DI objects like transforms, scripts, Data flows, Work flows in initial load and delta load mappings.
• Worked on transforms like query, table comparison, SQL, CDC, merge, case, key, date generation.
• Worked onData-Qualityfor Address cleansing, Data-cleanse.
• Involved in the team of Migration in moving the reports from Development to test and then to production.
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Worked on Data migration from SAP systems to Non SAP systems
• Worked on SAP BODS Information Steward like creating therules, binding the rules and data profiling.
• Actively involved in the production support and also transferred knowledge to the other team members.
• Developed complex queries using different data providers in the same report.
• Worked on HPQC (Quality center) as a part of testing the reports to identify the defects.
• Prepared Technical & Dataflow documents as part of project deliverable.
• Created, Tested and Executed data integrator jobs using designer to transfer data from source to target.

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.
• Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems.
• 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.
• Experience writing the SQL scripts
• 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
• Implemented the changes according to the change request document.
• Review of Mappings that are developed by the team.
• Sharing the Documents in centralized shared folders and test evidences.
• Debugging the jobs and data flows.
• Experience on parse, cleanse, match and Data profiling/analysis
• 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 forcreating mapping and transformationspecifications based on the business requirements from various business teams and implement inData Integrator jobs.
• Provided the technical guidance & knowledge transfer to the application management team on production deployment
• Migrated all the Projects of the team fromDEV 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
• Created Mapping document and handover to ETL Testing team
• Created workflows using object library and tool palette to execute data flows.
• Designed various mappings for extracting data from SAP Source systems and relational tables.
• Analyzed and defined requirement analysis for Business Objects reporting
• Created reports on oracle database using Webi Reports.
• Involved in Scheduling the Webi Reports using CMC and InfoView.
• Supported, modified and maintained Webi reports that are currently in production.
• Created different types of WEBI reports on different Universes.

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.

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