SUMMARY

• Over 10+ years of experience in Information Technology field with strong emphasis in ETL, Data Warehousing, Information Steward, ABAP and Web DYNPRO ABAP.
• Around 8 years of experience with Data Services Architecture design, Admin and Developer as an ETL tool and Data Migration Tool. Over one year experience with Information Steward.
• Around 5 years of experience with ABAP Developments like Reports, BDC, BAPI’s, RFC, LSMW, BADI’S, ALE/IDOCS, and Dialog Programming.
• Worked on complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Worked with Information Steward to define validation rules, identify duplicated, involved in profiling of data.
• Strong experience in building Custom Data Cleansing Packages using Cleansing Package Builder.
• 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.
• Worked on Profiling and Auditing in migration.
• Strong experience in the integration of BODS with SAP modules and Non - SAP data sources.
• Monitored the performance of jobs and the Job Server Utilization
• Created Job Server groups to distribute the work load of the jobs
• Configure, create repositories and apply security policy on CMC
• Backup and recovery mechanism implemented by backing up the central repository, FRS and CMS data bases.
• Worked on both real-time and batch jobs creation and performance optimization.
• Performs backups on entire system or server settings or and BI content.
• Configure data stores and push them as ATL to all the repositories for use.
• Created security roles for users and maintaining of roles to groups.
• Configured repositories, Moved data between environments, Performance monitoring.
• Integrated different SAP Systems to data services and configured the data stores.
• Implemented the Disaster Recovery Mechanism and monitoring of Jobs for improving the performance of Jobs and the Systems.
• Performance Tuning of Jobs and tuning the DS to SAP Systems by using ABAP DataFlows etc.
• Worked extensively on custom extractors.
• Involved from understanding of the legacy system and creating mapping documents with functional team.
• Involved in creating gap analysis from the existing mapping documents.
• Used Open Hub Services to push data out of SAP BI using Data Services into RDBMS.
• Worked on hierarchy flattening to convert the SAP Hierarchies into RDBMS tables.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created repositories (Local, Central, Profile and Cleansing ) and configured them with Designer, Management console
• Used Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing, Canada Data in Data Quality.
• Extensively workedonData Extraction, Transformation, and Loading with RDBMS, Flat files and XML.
• Worked with IDOCS to extract and to load data in SAP.
• Designed Classical, Interactive, OO-ABAP Reports, RF Screens.
• Developed & Supported Custom tool for Data Migration.
• Performance Tuning of Reports to optimize the Cost & Runtime.
• Used Data Migration Techniques - Datasets, BDC’s.
• Worked on SAP Scripts and Smart Forms as per user specifications and for printing Zebra Labels.
• Hands on Experience with Dictionary objects - Search Help Exits, Table Creation, Lock Objects.
• Worked on User Exits, Enhancements, IDOCS.
• Experience in all stages of application development, design analysis, evaluation of customer needs, analyzing functional requirements, technical requirements, testing and business process.
• Have knowledge on BADI’s, Workflows and Adobe Forms.
• Have basic knowledge on MM, WM, Yard Management, FI and SD modules.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance using Compression, Aggregates, Partitioning and Indexing of Info cubes and use of statistics for same.
• Worked on loading data into different SAP systems like SAP ECC, CRM, PCM, ERP, PPM, WM
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Analysis, Design, Development, Maintenance, Enhancements, Testing., Migrating, Administrating, security management and production support in Business Objects
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse(EDW) and data marts.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.
• Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI Jobs.
• Performed complex transforms in dataflow using data services.
• Expertise in Relational Database Systems such as Oracle 11g/9i, MS SQL Server 2008/2005 and MYSQL.
• Programming Knowledge in Developing SQL and PL/SQL.
• Excellent in documenting Business Requirements, Technical Designs, Unit Test plans, System Test plans, User Acceptance test plans and User Training manuals.
• Experience in user training and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project.
• Prepared test scripts and test cases to validate data and maintaining the data quality.

TECHNICAL SKILLS

SAP Technologies: Information Steward, SAP ECC 4.6C, 5.0 and 6.0, Work bench tools, Reports, BAPI, RFC, ALE/IDOC, Conversions (BDC, LSMW), Smart forms and ABAP Performance tuning.

SAP Net Weaver: Enterprise Portal 7.02/7.3, Web DYNPRO ABAP/JAVA.

ETL tools: SAP BO Data Services XI 4.0 SP1, SAP BO Data Services XI 3.2 SP1

IDE Tools: Net Weaver Developer Studio (NWDS), Eclipse.

Software/Databases: Oracle 11g/9i/8i/7i, MS SQL Server 2008/2005 and DB2

Languages: SQL, PL/SQL, C, C++, Java, HTMLOperating Systems MS-DOS, Windows XP/2000/NT/98, UNIX

Other Tools: TOAD, MS Office Products (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis

SAP BODS Consultant

Responsibilities:

• Involved in understanding project requirements and done gap analysis for some of the requirements.
• Involved in creating FRD and TRD.
• Downloaded AIO jobs from SAP market place and customize them as per the requirements.
• Involved in creating jobs, workflows and data flows using DI and DQ transforms.
• Involved in data enrichment, data profiling, and data cleansing activity.
• Involved in understanding business rules and created source to target mapping document.
• Created and configured Data Stores to SAP BI, ECC and BPCS, Oracle Systems.
• Helped creating the architecture for BODS 4.2.
• Setup the DS System configurations for all the source systems.
• Created CR’s for creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
• Exported the ATL jobs from dev to shared path and imported them to QA as part of code migration.
• Worked on profiling of data, creating scoreboards, validation, matching strategy and finding duplicates using Information Steward 4.0.
• Extracted data from various source systems and merge them into single source for reporting needs.
• Worked on data cleansing data profiling tasks. Performed Data Quality tests.
• Use control tables to find easy ways to identifying the problem/job failures.
• Used parameters, variables and Global variables depending on necessity.
• Shutdown and startup of servers depending on the necessity.
• Configured repositories in Oracle and DB2 environments.
• Worked on DS workbench in designing the jobs based on business needs.

Environment: SAP Business Objects Data Services XI 3.2, 4.2, Information Steward 4.0. SAP ECC, SAP BI, Flat Files, Oracle, MS excel 2007, Windows 2008 server/XP.

Confidential, NH

SAP BODS Consultant

Responsibilities:

• Involved in created business rules and data mapping.
• Worked closely with functional team on analyzing the data gathering requirements.
• Created and configured Data Stores to SAP BI, ECC, SRM and DB2 Systems.
• Helped creating the architecture for BODS 4.2 and Information Steward 4.2.
• Created System configuration in all 3 (DEV, QA, PROD) environments.
• Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
• Worked on profiling of data, creating scoreboards, validation, matching strategy and finding duplicates using Information Steward 4.2.
• Worked on DS workbench in designing the jobs based on business needs.
• Debugged existing jobs and done performance tuning on the existing jobs.
• Loaded data to different dimensions and fact tables.
• Used try catch blocks for error check.
• Worked on creating user roles in Information Steward
• Worked in creating data store connection and using flat files as sources.
• Worked on cleansing data. Performed Data Quality tests.
• Worked on validation rules and scorecard in IS.
• Use control tables to find easy ways to identifying the problem/job failures.
• Used parameters, variables and Global variables depending on necessity.
• Shutdown and startup of servers depending on the necessity.
• Configured repositories in DB2 environment.
• Worked on DS workbench in designing the jobs based on business needs.
• Debugged existing jobs and done performance tuning on the existing jobs.

Environment: SAP Business Objects Data Services 4.2(Designer, Repository ManagerManagement Console, Server Manager, CMC, CMS), Information Steward 4.2., SAP ECC, SAP BI, Flat Files, DB2, MS excel 2007, Windows 2008 server/XP.

Confidential, Houston, TX

SAP BODS Consultant

Responsibilities:

• Involved in creating functional specs and gathering req.
• Worked closely with functional team on analyzing the data gathering requirements.
• Involved in created business rules and data mapping.
• Created and configured Data Stores to SAP BI, ECC and Oracle Systems.
• Helped creating the architecture for BODS 4.2.
• Created System configuration in all 3 environments.
• Worked on creating local and central repository and providing user roles and maintaining groups and configured job server to local repositories.
• Involved in code promotion.
• Worked on profiling of data, creating scoreboards, validation, matching strategy and finding duplicates using Information Steward 4.0.
• Worked in creating datastore connection and using flat files as sources.
• Worked on cleansing data. Performed Data Quality tests.
• Worked on validation rules and scorecard in IS.
• Use control tables to find easy ways to identifying the problem/job failures.
• Migrated jobs from 3.2 to 4.2 and also performance tuning of the jobs.
• Used parameters, variables and Global variables depending on necessity.
• Shutdown and startup of servers depending on the necessity.
• Configured repositories in Oracle environment.
• Worked on DS workbench in designing the jobs based on business needs.
• Debugged existing jobs and done performance tuning on the existing jobs.
• Loaded data to different dimensions and fact tables.
• Used try catch blocks for error check.
• Worked on creating real-time jobs with Webservice for DataQuality.
• Used the XSD for the Webservice as source and performed Data Quality and produced output to XML and Flatfiles.
• Setup access server for the real-time jobs and configure webservice with max and min instance for optimizing the Real Time job based on input frequency.
• Used transaction control to manage commit and rollback and to control the order of execution in a dataflow in DataServices.
• Supporting the existing jobs, enhancements to the existing jobs and also building new jobs.
• Analysis on MDM data.
• Use of global local and parameters as required and passing parameter values to variable level.
• Moved Jobs between environments, scheduling of jobs.

Environment: SAP Business Objects Data Services XI 3.2, 4.2(Designer, Repository ManagerManagement Console, Server Manager, CMC, CMS), Information Steward 4.0. SAP ECC, SAP BI, Flat Files, Oracle, MS excel 2007, Windows 2008 server/XP.

Confidential, CA

SAP BODS Consultant

Responsibilities:

• Involved in creating functional specs and gathering req.
• Created and configured Data Stores to SAP BI, SAP ECC and Oracle Systems.
• Helped creating the architecture for BODS 4.0.
• Created System configuration in all 3 environments.
• Involved in code promotion.
• Use control tables to find easy ways to identifying the problem/job failures.
• Created delta logic and full loads based on data.
• Used parameters, variables and Global variables depending on necessity.
• Shutdown and startup of servers depending on the necessity.
• Worked on DS workbench in designing the jobs based on business needs.
• Debugged existing jobs and done performance tuning on the existing jobs.
• Loaded data to different dimensions and fact tables.
• Used try catch blocks for error check.
• Used transaction control to manage commit and rollback and to control the order of execution in a dataflow.
• Supporting the existing jobs, enhancements to the existing jobs and also building new jobs.
• Use of global local and parameters as required and passing parameter values to variable level.
• Moved Jobs between environments, scheduling of jobs.
• Worked Supplier self-registration configuration and customization of SAP standard Web DYNPRO applications.
• Worked on replication of SRM Business partner to ECC using RFC’s and BDC.
• Developed Remote Enabled Function Modules (RFCs).
• Developed reservation print smart form. Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC(DEBMAS06), Vendor Master IDOC(CREMAS05).
• Inserted the additional fields in Additional Data A Tab of Header of Sales Order by appending structure in VBAK table.
• Developed a BDC call transaction program to load Customer Master Data into SAP system from legacy system using transactionXD01.
• Developed a Report to display all delivery items and customer details based on the particular delivery number.
• Performance tuning of a custom report which describes the Sale Order Status, in which Tuning is done using proper coding standards, Parallel Cursor and Performance Techniques.
• Worked on Print Work Bench IS U CA INSTPLAN SF the letter is printed in-house immediately after the plan is created. Installment agreement is given to the customer to sign and accept the arrangements contract of an installment plan.
• Worked on print workbench FI CA CORR DUNNING SAMPLE SF to create and send payment reminders or dunning letters to the business partners to remind them of overdue payables and to request payment.
• Worked on user exit AIST0002 to add the custom fields Condition, Criticality, Utilization are to be maintained on transaction AS01 and AS02 for asset master data creation maintenance respectively.
• The Department of Water debt collection process involves handing over receivable which are more than 60 day overdue to a third party company for collection. The submission file will be generated by running transaction code FP03DM.Enhanced the file format items fields with FQEVENTS Function module FKK SAMPLE 5063.
• Used WE05 transport code to check the IDOC status.

Environment: SAP Business Objects Data Services 4.0(Designer, Management Console, Server Manager, CMC, CMS),SAP ECC 6, SAP BI, Flat Files, Oracle, MS excel 2007, Windows 2008 server/ Windows 7.

Confidential, Minneapolis MN

SAP BODS Consultant

Responsibilities:

• Involved in created business rules and data mapping.
• Worked closely with functional team on analyzing the data gathering requirements.
• Created and configured Data Stores to Salesforce system, MS SQL server 2008.
• Helped creating the architecture for BODS.
• Involved in designing the warehouse architecture.
• Trained and guided resources on Data Services.
• Debugged existing jobs and done performance tuning on the existing jobs.
• Developed DQ jobs used Data Cleanse, Address Cleanse and Match transform to cleanse all Health care information. Performed optimization on the job.
• Worked on creating real-time jobs with Webservice for Data Quality.
• Used the XSD for the Webservice as source and performed Data Quality and integration transforms to produced output to XML and Flatfiles.
• Setup access server for the real-time jobs and configure webservice with max and min instance for optimizing the Real Time job based on input frequency.
• Loaded data to different dimensions and fact tables.
• Used try catch blocks for error check.
• Worked on extraction of data from MDM and different source systems and build and BIG application for maintaining the Vendor hierarchy.
• Analysis on MDM data.
• Use of global local and parameters as required and passing parameter values to variable level.
• Created scripts to pull data from FTP server and trimming the file names, Archiving data.
• Created scripts to check existence of files before involving the object, email Job Success.
• Performing Audit on the tables loaded, Performed optimization on handling 1 billion records data in one job.
• Created incremental loads and full loads.
• Moved Jobs between environments, scheduling of jobs.
• Worked on documenting the jobs and Performed both unit and system testing.
• Adding of user and group roles in CMC.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), Sales Force, Flat Files, Eloqua System, MS excel 2007, Windows 2008 server/XP.

Confidential

EIM Consultant 

Responsibilities:

• Involved with business in getting the understanding of the legacy system and migration using mapping documents and filling up gap-analysis.
• Installed EIM Suite Business Object Platform with BI and BODS and monitored all the servers.
• Monitored the performance of jobs and the Job Server Utilization.
• Created Job Server groups to distribute the work load of the jobs.
• Configure, create repositories and apply security policy on CMC.
• Backup and recovery mechanism implemented.
• Configure data stores and push them as ATL to all the repositories for use.
• Created and configured Data Stores to i-Series system, made ODBC connections to the system.
• Helped creating the architecture for BODS and SAP Clients and environment.
• Trained and guided resources on Data Services and SAP.
• Debugged existing jobs and done performance tuning on the existing jobs.
• Installed BPDM jobs in Data services.
• Gathered requirements from business and mapped it to IDOC.
• Worked on loading master data in MDM (Single version of Truth) from different source company’s data like Genex, CRI, AGS, CLA.
• Configured ABAP dataflow to get data from SAP and validate the data.
• Worked extensively on custom extractors.
• Moved Jobs between environments.
• Moved Jobs between environments. Analyzing all the all downstream systems and enable data stewardship and/for higher data quality.
• Worked on Staging the data and modifying the existing BPDM’s.
• Worked on Objects like Fixed Assets, AP/AR.
• Worked on scheduling jobs.
• Analysis of MDM data after loading.
• Loaded data into SAP using IDOC’s
• Checked status of posted IDOC and validate the data.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, AS400 (JBA), Oracle 10i, JDE, i-series, MS excel 2010, Windows 2008 server/XP.