SUMMARY:

• SAP ABAP Consultant with 4 months of experience in Development and Production Support.
• Extensively worked on SAP IDOCS, BAPI and LSMW and Winshuttle for Data migration Projects
• Worked on the Custom Infoset & Logical Database with Winshuttle
• Functional and technical understanding of SAP transaction systems.
• Design and build data conversion/quality solutions using BODS for the identified needs of the client.
• Strong fundamental understanding of data conversion (ETL) and data quality concepts.
• Expertise in extraction, transformation and loading the data directly from different heterogeneous source systems like Excel, flat files and CSV files and databases.
• Experience in performing analysis, requirement gathering, and estimation and reviews the issues and suggest solutions. 
• Involved in data reconciliation at various data staging levels within BODS and between SAP R/3 and BW.
• Good understanding of Material management and Production Planning.
• Working experience in SAP - SD/MM/FI/PP module.
• Testing and preparation of test plans, Initial test data creation and provide application

TECHNICAL SKILLS:

ABAP/4: Data Migration, IDOCS and BAPI s. Legacy system migration workbench

Data Services: Detailed understanding of Data Warehouse concepts and Data Warehousing Architecture. Transformation, Workflow, Dataflow, Validation, Merge, Script etc. Data services XI 3.2 installation.

Winshuttle: Detailed understanding & Working experience in Winshuttle for Data Migration Projects

SAP BW: Data Modeling Creating and managing the Info Areas, Info Object Catalogs, InfoObjects, InfoCubes, ODS objects, Info sets, Multi providers, Application components, Info sources, Data sources, DSO Objects, Process Chains creation.

SAP HANA: HANA Information Model design (Attribute, Analytic and Calculation Views)

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr Programmer Analyst

Responsibilities:

• Gathering Requirement from Client team.
• Analyzing user requirements and database structure.
• Designed the Technical Specification Document.
• Used Transformation query to transform data.
• Built the jobs using the ABAP workflows to optimize the performance
• Filtering and de-duplicating the data using various functions and Query transforms to get the scope records
• Used Global variables and scripts to control the execution of the job
• Experience in working with ABAP data flows to extract the data from SAP Applications.
• Performed field level validations to ensure the target file is generated as per the business rules and the specified file format.
• Using Winshuttle to load Customer Master & Material Mater and Some transaction Data objects( Purchase order & Sales order/Billing..etc) into SAP ECC Helped Business users on how to run Scripts for the Winshuttle to load into SAP
• Winshuttle to migrate the Long text data
• Winshuttle to manage Billing/Invoice data in SAP
• Worked on the data governance for the various data objects
• Supporting the post go-live activities on all the BOBJ objects Master and Transactional.
• Created test cases for carrying out unit testing and part of functional testing.
• Document the unit and regression test results and fix issues.
• Ensure compliance of overall design with the enterprise development standards.
• Reviews, evaluates, designs, implements and maintains ETL Programs

Environment: Winshuttle, Business Objects Data Services 4.2, Sql Developer, SAP ECC

Confidential,  LakeForest, IL

SAP CONSULTANT

Responsibilities:

• Gathering Requirement from Client team.
• Analyzing user requirements and database structure.
• Designed the Technical Specification Document.
• Created JOBS for extraction of data from SAP & Non system based on requirement and load into SalesForece environment
• Worked on the Excel data movement to Winshuttle for the Brewing data
• Winshuttle to migrate Material/Customer & Vendor data into SAP
• Winshuttle to update payment terms data in SAP
• Worked on optimizing Winshuttle Quires to load data into SAP
• Helped Business users on how to execute Winshuttle Quires Used Transformation query to transform data.
• Conducted trainings for Winshuttle tool overview for the business & functional team
• Built the jobs using the ABAP workflows to optimize the performance
• Filtering and de-duplicating the data using various functions and Query transforms to get the scope records
• Used Global variables and scripts to control the execution of the job
• Worked on creating

Environment: Winshuttle, Business Objects Data Services 4.2, Sql Developer, SAP ECC & SalesForce

Confidential  

SAP CONSULTANT  

Responsibilities:

• Gathering Requirement from Client team.
• Worked on the Customer Master & material Classification data loads with Winshuttle
• Analyzing user requirements and database structure.
• Designed the Technical Specification Document.
• Created JOBS for extraction of data from SAP system based on filter requirement.
• Used Transformation query to transform data.
• Built the jobs using the ABAP workflows to optimize the performance
• Filtering and de-duplicating the data using various functions and Query transforms to get the scope records
• Used Global variables and scripts to control the execution of the job
• Used scripts to delete the duplicate records after the validation part
• Worked on different versions to generate Flat file structure for LSMW and IDOC output files for SAP. Generated XML output files and flat structures for analysis
• Winshuttle to migrate Material/Customer & Activity Types/Cost Centers data into SAP
• Winshuttle to update payment terms data in SAP
• Worked on optimizing Winshuttle Quires to load data into SAP
• Helped Business users on how to execute Winshuttle Quires Used Transformation query to transform data.
• Conducted trainings for Winshuttle tool overview for the business & functional team
• Involved in resolving the technical issues of the remaining objects that are held at offshore and onsite
• Created jobs to extract and load the lookup tables data from source and target system
• Quality check and maintenance of each objects weather they meet the client requirement or not Moderating

Confidential 

SAP CONSULTANT 

Responsibilities:

• Gathering Requirement from Client team.
• Analyzing user requirements and database structure.
• Designed the Technical Specification Document.
• Created JOBS for extraction of data from SAP system based on filter requirement.
• Used Transformation query to transform data.
• Validate the Records between legacy and SAP system.
• Written a Custom function for changing of data automatically based on requirement.
• Created Flat files according to LSMW structure.
• Resolved defects for SD, MM, PP and FI modules in quality system.
• Perform unit testing and integration testing.
• Extensively involved in Data Extraction, Transform and Loading (ETL Process) from Source
• To target systems using BODS.
• Created jobs to load data from source into Target using Flat File format, Query Transform, Case Transformation, Lookup function, Table Comparison Map-Operation and Key Generation.
• Involved in data validation & data cleansing.
• Extensively worked with Data transformations using Data services designer. Implemented performance tuning in ETL jobs and created Complex jobs.
• Performed Data Extraction, Complex Transformations.

Environment: Business Objects Data Services 3.2, Oracle 11g and TOAD

Confidential

SAP DEVELOPER

Responsibilities:

• Implementing SAS code in BODS
• Providing Support - working through new/modified requirements
• Working under the Agile methodology to meet aggressive deadlines
• Design, implement and cross train team members on key functionalities including type II SCD, source based CDC, batch processing and loading data into Sales force
• Training and mentoring team members in BI best practices and in the use of the BODS tool
• Designed the Technical Specification Document.
• Created JOBS for extraction of data from SAP system based on filter requirement.
• Used Transformation query to transform data.
• Validate the Records between legacy and SAP system.
• Written a Custom function for changing of data automatically based on requirement.
• Implemented performance tuning in ETL jsobs and created Complex jobs.
• Perform unit testing and integration testing.
• Coordinating with business users to identify requirements and prioritize them
• Creating and updating functional and technical specification documents based on user input
• Build and optimize jobs, workflows and dataflow to meet challenging deadlines.
• Scheduling nightly incremental runs using the BODS Management console
• Part of the On-Call Team, providing 24/7 production support
• We implemented SCD to load current and Historical Data
• Analyzing the ABAP program and Modifying the ABAP program to improve the Performance of the Program for Large set of table data into BODS Staging area
• Using Sql Quires like inner joins, Outer joins and DDL, DML commands to testing the data at the database level.

Environment: Business Objects Data Services 4.0, BW & ABAP Oracle 10g and Sql Developer

Confidential 

SAP Software Engineer  

Responsibilities:

• 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 SAP ECC tables, Flat files to load into Sybase IQ database.
• Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads)
• Designed the Technical Specification Document.
• Perform unit testing and integration testing.
• Downstream review on the provided object.
• Attending transition calls before developing TS with FS owners.
• Preparing the Technical Specification (TS).
• Developing the code and to perform the testing with various scenarios.
• Modifying the ABAP Program to apply new ED difference Conditions.

Confidential  

SAP Software Engineer 

Responsibilities:

• Prepared Jobs according to the specifications.
• Designed various Data Flows for extracting data from various sources involving flat files and relational tables.
• Involved in Error Handling
• Using designer to create source definitions, design targets, create Data Flows and develop transformations.
• Created Global variables and Substitution parameters.
• Created different transformations for loading the data into oracle database e.g. Query, case, Pivot, Table Comparison, Validation, Merge, and Key Generation.
• Using BODI designer functions like Lookup ext, decode, Nvl, Gen row num and Previous value functions
• Created Scripts using BODI Designer.
• Involved in Unit Testing and prepared Test Case
• I am also developed custom function module to generate the bill receipt
• Designed various mappings for extracting data from SAP Source systems and relational tables.
• Configured database, SAP application Data Stores and File Formats to allow DS to connect to the source or target database,SAP tables and files.
• Using designer to create source definitions, design targets, create jobs and develop transformations.
• Developed SCD Type2 Effective Date Range by using History Preserving transformation according to the business requirements
• 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.
• Implemented recovery mechanism in the jobs.
• Implemented different loading methods(CDC) in jobs.
• Validate the data using Validation Transformation and audit the data.
• Deployed ETL objects from development to Quality and production.
• Knowledge in designing in implementing scripts, custom functions and used different functions.

Confidential 

SAP Software Engineer 

Responsibilities:

• Involved in the development and Migration activities.
• Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
• Extensively working on SAP BODS Designer Components- Projects, Jobs, Workflows, Data Flows, Data Store and Transformations, Formats.
• Execute the jobs through management console based on client requirement.
• Monitor the jobs & trouble shoots the data load issues.
• Develop & enhance batch jobs based on client change requests.
• Monitor and update the status tables.
• 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.
• Work with different optimization techniques to increase the performance.
• Extract data from different files format and load in to tables, files
• Interactive debugger, setting up of error handling and audit.