SUMMARY:

• Around 8 years of IT experience with expertise in analysis, design, development and implementation of Data warehousing using ETL with SAP BI/BW, SAP ECC, SAP HANA, Oracle, DB2, MS SQL server and Teradata databases.
• Extensive experience in ETL using SAP BODI/BODS, Teradata FSLDM.
• Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Worked with different SAP data sources like SAP BI/BW as Source and Target, SAP ECC, SAP HANA, ORACLE, MS SQL SERVER, Teradata and Flat Files
• Experience in Data Quality/ Data Profiling with Data services Components
• Implemented Four full life cycle implementations for different modules in SAP ECC,SAP BI/BW which involves Development, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data loading and Production Support. Involved in ETL implementation using SAP BODS 3.2,4.0.
• Capable to implement End to end data migration using SAP BODS to SAP HANA .
• Applied BODS performance tuning techniques using parallel processing (Degree of Parallelism), Multithreading, Partitioning, and Database Throughputs to improve job performance.
• Worked closely with the SAP BASIS to set up the environments and Functional teams in gathering the requirements and resolving the issue in all the phases of the project.
• Implemented Surrogate Key for SCD Type - 2 Dimensions, against standard content which doesn’t have this functionality as per business requirement to capture the history data
• Implemented using BODS features like Query, Merge, Row Generation, Lookup, Hierarchy Flattening, Key Generation and Table Comparison.
• Tested all the BODS ETL Jobs in DEV environment by loading sample data, validated and fixed the bugs
• Deployed all the BODS ETL Jobs from DEV to PROD after testing all the Jobs with the provided test scripts
• Prepared all the documentation related to ETL as part of project like Technical Design document, Data Flow document, migration document, etc
• Experienced handling the data from different files formats like COBOL files, CSV,Excel, and XML.
• Knowledge on Informatica Power Center Client tools and Server Administration (Designer,
• Workflow Manager, Workflow Monitor, Repository Manager) and Microsoft SSIS
• Can efficiently handle Production Support, Bug fixing, and Bug Finding & Fine tuning processes for improving performance. On-Call support for System Maintenance.
• Creating and executing Job, Workflow, Dataflow etc in SAP BODS tool in SAP BW and Teradata environment.
• Experience in Setup environment for cleaning the data using cleansing package and address dictionaries.
• Worked with different variables i.e. Confidential variables, local variables, parameter and substitution parameter those are created at different levels i.e. repository, job, workflow, dataflow etc.
• Proficient in implementing Complex business rules by creating re-usable transformations,
• Expert in handling production support activities during delivery of modules.
• Worked closely with SAP BASIS team for setting up the environments(DEV/QA/PROD)
• Involved in peer review and group review before post production activities.
• Acting as RTT (Request Task Tracker) anchor for the team.
• Periodically involved in the Quality audit.
• Provided great contribution in all the offshore projects, and provided great assistance to onsite.
• Familiar with complete Data warehousing development Lifecycle.
• Exposure to Terdata FSLDM(Financial Services Logical Data Model).
• Exposure on SAP HANA and SAP BI/BW modeling.
• Good exposure to Banking, Insurance and Sales domain.
• Having good exposure on end to end Sustain projects/activities.

TECHNICAL SKILLS:

Technology: SAP BODS, Teradata

Tools: SAP BODataServices 4.2, 4.0, 3.2, BODI (Data Integrator),Informatica, Microsoft SSIS, Teradata SQL Assistant,SAP Solution Manager,Dollar Universe, HP Quality centre, Eroom

Operating Systems: Windows, UNIX

Databases: SAP HANA, Teradata, Oracle, MS SQL, DB2, SAP ECC, SAP BI/BW

Domain Knowledge: Banking, Health Insurance, Retail

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP BODS Sr.Technical Consultant

Responsibilities:

• Building of the BODS Jobs, Workflows, Data Flows, ABAP data flows as per the Mapping Specification.
• Involved in preparing Business Requirement Documents and gathering the requirements from the functional team.
• Preparing the Technical Specification documents
• Loaded weekly and monthly sales data from Source to SAP BW system.
• Worked extensively on different types of transformations and using ABAP data flows for extracting the data from ECC tables.
• Loaded data from sources like Flatfiles, CSV, Oralce, MS SQL Server, SAP ECC, SAP BW to SAP HANA using BODS.
• Created ABAP Data flows and used Shared Directory Data transport method to perform the ETL operation.
• Extensively used ETL to load data from ECC to flat files.
• Update the changes in the BODS code as per the client requirements and perform testing and move the code to different environments
• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases and user guides.
• Created scripts using BODS .
• Setup environment for cleaning data using cleansing package and address dictionaries and Data cleansing Dictionaries.
• Profiling the data received from users and suggesting possible cleaning required.
• Cleaning the address of customers and vendors using BODS quality transforms
• Used BODS as ETL to migrate data from legacy system to SAP.
• Used SAP Best Practices for the Data migration.
• Review of Functional Specifications Document, Design Document (Technical as well as non-technical), Program Specifications and Test Cases.
• Weekly Status meeting with the clients to discuss issues or progress.
• Involved in day to day onsite coordinator interactions and meetings.
• Ensuring proper Dependencies and Proper running of loads (Incremental and Delta loads)
• Prepared the test case document after completion of code development.
• Moving code to Central Repository.
• Prepare the Migration documents to move the code to different environments.
• Giving KT to the support team.

Confidential, NC

SAP Sr.BODS Technical Consultant

Responsibilities:

• Understand the functional specification document(FSD) and gathering the requirements from the business.
• Prepare the High level design document (HLD) and do review with the Client.
• Create project, batch jobs, Dataflows and mappings etc.
• Extracted the data from XML files and loaded to IDOCS .
• Using transformations between source & target and applying business rules as per user request.
• Extensively utilized lookup, lookup ext functions to load data from source to Target using a transform Table.
• Scheduled and Monitor jobs using Data Integrator Management console.
• Prepared the test case document after completion of code development.
• Moving code to Central Repo.
• Involved in TCO activities to move jobs to QA and PROD.
• Releasing the jobs from development to quality.
• Worked closely with the basis team for resolving the issues.
• Interacting with the customer for requirement gathering and for code review.
• Monitoring the jobs in quality and reporting the customer about the jobs status.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in preparation and execution of the unit, integration and end to end test cases..

Confidential

SAP BODS Technical Consultant

Responsibilities:

• Understand the functional specification document (FSD) and gathering the requirements
• Prepare the High level design document (HLD) and do review with the Client..
• Created the datastores and import the metadata of tables or infosources into the datastores (source or target).
• Create project, batch jobs, dataflow's and mappings etc.
• Extracted the data from oracle database and load the data to SAP BW and SAP ECC (through IDOCS) using Data Services.
• Prepared the test case document after completion of code development.
• Moving code to Central Repo.
• Prepare the Migration documents to move the code to different environments.
• Giving KT to the support team.
• Created ODBC for the connectivity with different sources such as SQL server, Oracle and Progress Data sources.
• Upgrade the repositories to XI 3.1 from BODI XI R2 and import the ATL file from the repository.
• Ability to Design and Develop complex ETL solutions by translating design requirements into feasible, reusable and scalable technical implementations. Able to Develop Data Movement, Audit and Error Management processes.
• Ability to follow program specifications to Write, Test, Debug, Document and Implement jobs including Batch Jobs and Real-Time Jobs using complex transformations. Experience in Performance Optimization & Tuning techniques, Data Quality, Data Profiling and Data Management

Confidential

SAP BODS Technical Consultant

Responsibilities:

• Understand the functional specification document (FSD) and gathering the requirements
• Prepare the High level design document(HLD).
• Created the datastores and import the metadata of tables into the datastores(source or target).
• Create project, batch jobs, dataflows and mappings etc.
• Extracted the data from oracle & Sales force and load the data to Teradata using Data Services.
• Used different transforms between source and target to modify the incoming source data as per the business logic.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Confidential Variables
• Responsible for testing the ETL jobs in QA before moving them to Production (3 System Integration testing cycles)
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data
• Used conditional workflows for full or delta loads.
• Created sequence and parallel workflows and data flows.
• Prepared the test case document after completion of code development.

Confidential

SAP BODS Technical Consultant

Responsibilities:

• Involved Business Requirements Document and gathering the Requirements.
• Preparing the Technical Specification documents
• Building of the BODS Jobs, Workflows, Dataflows as per the Mapping Specification.
• Using Datastores to extract data from Databases.
• Extracting data from Oracle, flat files and modifying the incoming data with using transforms and finally generating the CSV files in the job server path as target.
• After loading the data into CSV files and zip those CSV files and put into a folder.
• Triggers the execution of script, which will call the ITK executable passing its some parameters. The ITK executable sends the data by https to Ariba.
• Error handling and Auditing
• Created local and Confidential variables and used the scripting language
• Designed, implemented and documented QA processes for User Acceptance Testing
• Documented the requirements gathering and the design of the solutions provided
• Moving code to Central Repository.
• Prepare the Migration documents to move the code to different environments.
• Giving KT to the support team.
• Involved in TCO activities to move jobs to QA and PROD.

Confidential, Maharashtra, IN

SAP BODS Consultant

Responsibilities:

• Understand the functional specification document (FSD) and gathering the requirements.
• Schedule calls with function team for any clarifications required.
• Prepare the High level design document (HLD) and do review with the Client.
• Created the datastores and import the metadata of tables.
• Create project, batch jobs, dataflows and mappings etc.
• Extracted the data from different legacy systems (Teradata, Oracle and flat files) and load the data to JDA (Oracle) system using Data Services.
• Using transformations between source & target and applying business rules as per user request.
• Wrote custom function and published to the team members to import into the BO Data Services.
• Utilized DI Designer for designing the ETL jobs and scheduled through the job server.
• Designed Information Integration strategy from 15 data sources to load into Oracle Staging Tables. data sources included RDBMS, Flat Files.
• Created data flows and process flow diagrams.
• Applying different joins as per user request.
• Prepared the test case document after completion of code development.

Confidential

Teradata Developer

Responsibilities:

• Involved in Extraction, Transformation, Loading and Implementation
• Analyzing the documents converting HLD’S to LLD’s.
• Designing and coding the solution for the customer problem.
• Creating the transformation views according to the specifications given by the client.
• Involved in unit testing and preparing test cases.
• Uploading the test cases in quality centre.
• Ensuring timely and defect free delivery.
• Performing incremental load.
• Worked closely with the Testing team and DBA
• Receiving the issues from the testing team and resolving them accordingly
• Optimizing the Scripts if a script takes a lot of time to execute.
• Delivering as per schedule.
• Following and preparing Quality Documents conferring to standards.
• Resolved issues faced by the Team.