SUMMARY:

• Over 9+ years of experience in SAP and Data Migration with strong emphasis on BODS.
• Data Migration Consultant with good expertise in SAP Data Migration Framework/AIO Methodologies following full ETL processes to ensure successful migration of data from legacy systems to SAP, extraction, transformation and loading the data directly from and to various systems like SAP ECC, SAP BW, SQL Server, DB2, Oracle, flat files.
• Involved in end - to-end implementations from requirement gathering and involved filling the GAP analysis, design and development, testing, go-live and post production support phases.
• Experience in working on loading data into SAP ECC system using IDOC's.
• Experience in implementing RFC enabled BAPI's and FM's and developing LSMW.
• Configured RDS Solutions for Data Migration with SAP ECC.
• Made Address cleansing in Data quality by using the transforms Match transform, Address cleanse and Data cleanse in BODS for the data been migrated to SAP.
• Experience in Parsing, Cleansing, Standardizing the data using DQ transformations.
• Experience in Eliminating the Duplicate entries and consolidating them against the duplicate entries using match transform
• Extensively worked on development of mappings and worked with BODS Transformations like Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc.,
• Experience in Tuning ETL Jobs, Recovery Mechanism, and Error Handling and also set up validation rules.
• Experience in working with many Transform types like Integrator, Quality and Platform.
• Worked extensively on integration of BODS with SAP, Non-SAP systems and BW.
• Integration of Business Objects Data Services with SAP BI, ECC and CRM and Non SAP Data Sources.
• Implemented Rules and Data Quality Scorecards in Information Steward.
• Expertise in EDW extended star schema including Info Cube design, DSO design, Info Objects, Info Sources, Transfer, Update rules/Transformations.
• Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Pushed data out of the SAP BI using BODS and Open hub services.
• Experience in working with BODS using with different data sources (Flat files, Oracle, SAP ECC, JDE ERP, Sales force, Microsoft SQL Server).
• Used Data services as an external system for ETL between ECC and BI.
• Good working knowledge in Data services 4.2 and worked on different Transport methods - Direct download, Shared directory, ftp and custom transfer.
• Design, develop, optimize and maintenance of Business Objects Data Services jobs. Sound Knowledge on Extractors (Generic, CO-PA, LO).

WORK EXPERIENCE:

Sr. SAP Data Migration Consultant

Confidential, Kansas City, MO

Responsibilities:

• Worked on data migration from legacy systems to SAP ECC/CRM. Data provisioning into SAP ECC/CRM done using SAP BODS through IDOCS.
• Responsible for leading Business Partner, Farm and Product Master Data load design and implementation.
• Extensively used the SAP best practices AIO (All-in-one) jobs for Data migration activities.
• Worked on various Data Migration objects like Material Master, Vendor Master, Customer Master, Material BOM, Sales Order, Service orders, Purchase orders etc., and used IDOCs as the load method.
• Created mapping document to map legacy data with ECC/CRM business partner IDOCs.
• Worked on huge volumes of data of more than 100 million records, performed optimization of AIO templates using options available at both BODS and database level.
• Implemented RFC Enabled BAPI's & FM's in BODS and Developed LSMW for Data Migration in SAP ECC.
• Built complex data flows and Jobs to load Business Partner and their relationship data from legacy to ECC.
• Used various data quality transforms like address cleanse, data cleanse and matching transforms to identify duplicate records of Business Partner data for all the producers in the US
• Real-time address validation using Data Quality Management (DQM) of customers and prevent duplication of data, quarterly dictionary updates, etc.
• Configured staging databases, performed business validations and lookup activities.
• Analyzed source data quality using profiling techniques in Information Steward.
• Extensively worked on performance tuning to optimize the data load process.
• Provided assistance in configuring various objects like data stores, setting up repositories for check in and check out operations.
• Actively participated in gathering requirements, design and implementation.
• Worked on implementing CDC. Designed various jobs based on source and target CDC (Change Data Capture).
• Designed complex jobs using History preservation, Key generation (for surrogate Id's) and Table comparison transforms for tables that needed before and after images.
• Data extraction from SAP into Enterprise Data Warehouse (EDW) based on HANA that hosts data across all units of Farm Service Agency, using ABAP data flows and implementing delta load mechanism.
• Data remediation activities to fix data issues post go-live using custom function modules via BODS

SAP Data Migration Developer

Confidential, Dallas, TX

Responsibilities:

• Involved in AIO Methodologies for Data Migration process and set up the whole Migration process.
• Worked on the SAP Data Migration objects like the Master Data VENDOR, MATERIAL and CUSTOMER.
• Worked on Data Migration from the Legacy systems into the SAP.
• Interacted with Business analysts and End users to understand functional and technical requirements
• Installed and configuration of SAP BODS 4.0
• Installed the Information Platform Services and 4.0 in DEV, QA, PRODUCTION
• Profiling data using Information steward like column, address profiling and data redundancy, dependency profiling, validation rules, set up score cards.
• Defined Data Stores to allow Data Services to connect to the source or target database.
• Used ETL extraction, transformation and loading data from heterogeneous source systems.
• Strongly developed various Workflows and Data flows where the data is extracted from the sources including Oracle 11g, SQL Server 2008 then loaded into SAP ECC 6.0.
• Expert in writing DI Scripts for File existence check, daily incremental read, daily Incremental update and Job Dependency
• Used BODS cleansing transformations for de-duplication, house-holding and address parsing.
• Used various transformations including Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Set Matching scores, performed match and consolidation based on business requirements.
• Followed USPS address regulatory, Updated Address Directories Used the SAP inbuilt AIO jobs for customer master
• Scheduled, monitored and fixed the errors of the jobs. Optimize mappings to achieve faster load.
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs.
• Applied aggregate awareness to speed up query time. Extensively worked on reports on help desk and asset inventory.
• Troubleshooting and performance tuning which reduced several jobs from several hours to less than one.
• Scheduling/ Publishing the reports on daily and weekly basis to the users Inbox.
• Involved in administering the ad hoc data environment, developing processes and standards for this environment, testing queries developed by others using DB Artisan for performance issues and supporting users.
• Performance tuning of the SQL queries by restructuring the Joins, creation of required indexes to avoid table scans, error handling of queries etc.
• Created and maintained Enhancement, Bug tracking and Bug fix documents.
• Created new mappings and updated old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.

SAP Data Migration/ETL Consultant

Confidential, San Jose, CA

Responsibilities:

• Responsibilities are from driving the ETL of Data Migration to architecting (Tech design and development) the interface programs between different systems using data services.
• Involved in gathering business requirement from business users and managers.
• Involved in meetings with functional users, determine flat file layouts, data type, naming conventions of the column and table names.
• Involved in mapping using designer and designed workflows using workflow to build dw as per business rules.
• Created new mappings and updated old mappings according to changes in Business logic
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used ETL (Data Integrator) to load data from source to Staging. Used Data Integrator client tool for defining Source and Target definitions and coded the process of data flow from source system to data warehouse.
• Worked with Teradata as extraction from different databases. Implemented Slowly Changing Dimensions - Type I and II in different mappings as per the requirements.
• Involved in Data Load of millions of records and in resolving various data issues using SAP Business Objects Data Services BODS and LSMW.
• Used Business Objects Web Administrator to schedule and monitor ETL Jobs.
• Used Debugger to troubleshoot the mappings
• Worked on data quality / cleansing transformations using BODS (e.g. customer address data cleansing, matching, de-duplication).
• Implement best practices, development standards for Data Services and Information Steward.
• Participate in data quality analysis, standardization and validation, and develop data quality metrics.
• Work directly with IT and business users to validate requirements for cleansing and standardizing e sting legacy master data and provide custom configurations in unique environments.
• Responsible for data migration, data quality, data conversion methodologies and process between legacy and SAP systems.
• Used Central Management Console for Creating users and user groups, restricted access of the users.
• Worked on the Info Steward on building Scorecards, profiling, Address, Redundancy Column, Dependency.
• Involved in BODS with data integration and data quality management.
• Involved various transforms like map operation, table comparisons, row-generation, query history generation, key generation, pivot, reverse pivot and functions like lookup, index search for transforming data. Recovering data from failed sessions and workflows.

Environment: SAP BODS, BO, Non SAP, (Oracle, Sybase, Teradata).

SAP BODS Consultant

Confidential, Atlanta, GA

Responsibilities:

• Involved in business requirements, functional requirements and data specification.
• Business objects data Integrator for ETL data from heterogeneous source systems such as excel, Idocs and flat files.
• Working with various transforms such as sql, table comparison, history preservation, row Generation, query, map operation, merge, look ups, Pivot, Case.
• Define various audit points and rules to ensure that a data flow loads correct data into the data warehouse.
• Used abap data flows, pre-load and post-load commands.
• Involved in linking Job Servers on different machines to a single repository for load balancing using the data integrator server manager.
• Responsible for Testing and debugging various etl jobs.
• Working with data Integrator management console to deploy and schedule batch jobs as database administrator.
• Developed bex queries with calculated and restricted key figures, cell definitions and variables
• Designed wad templates with Analysis, Filters and Chart web items using multiple data providers and developed dynamic content in wad templates using path replacement of variables and filters.
• Involved in RRI configuration of reports to set jump targets. Involved in solving uat issues and change requests.

Jr.SQL/BI Developer

Confidential

Responsibilities:

• Transferring data from various sources like MS Excel, Flat File and SQL Server using SSIS and then creating reports with this data using SSRS
• Created complex Stored Procedures, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Created SQL Server Reports using SSRS Deployment of the reports on to the PRODUCTION server for the end users.