We provide IT Staff Augmentation Services!

Sap Data Service Consultant - Etl Developer Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Over 12+ years of IT Experience with 10+ years of strong SAP ABAP, Data Migration, Data Conversion, Data Integrator, Data Quality, Data Profiling BODS / BODI, BW,Information Steward 4.2 experience involving several stages of the implementation life cycle including Analysis, Design, Development, Testing, Implementation & Post - implementation support involving 5 end-to-end SAP implementations, 3 SAP Upgrade projects and 8 DATA MIGRATION projects.
  • Expert in Data migration / Data Conversion using BODS/LSMW / BAPI / and IDOCS
  • Involved in complete cycle for 8 SAP DATA MIGRATION projects ( End-to-End )
  • 3+ years of Experience working with SAP Data migration / Conversion / Integration and ETL tools using SAP Data Services -BODS.
  • SAP Business Objects Data Services (Data Integrator and Data Quality), SAP Information Steward, Web Intelligence.
  • BODS - Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS using BODS, Used BW extractors as source, Used ABAP Data flows and Data Transport transform.
  • Expert in Data Quality Transforms- BODS-Used Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
  • Proposed Best Practices in SAP BODS for Data migration projects, Good in proposing Performance Optimization techniques in SAP BODS.
  • Expert on Information Steward - Metapedia,CUSTOM Clensing packages,Match reviews,Data Profiling and Validation Rules, Score card set up .
  • Experience and Knowledge on BODS 4.0 ( Business Object Data Services, SAP HANA Data Provisioning using SAP LT Replication Server (SLT) and Data services .
  • Good Knowledge and experience on SAP BOBJ - WEBI, Crystal Reports, Dashboard Design, Integration HANA with BO tools.
  • Strong Expertise in ABAP-RICEFW which covers project scoping, design, Business Process Layout, Gap Analysis etc. and worked all RICEF’s in ABAP - (Dialog Programming, Standard and Interactive Reports), ABAP Objects(Dynamic Programming using field symbols and OOPS), ALE, EDI and IDOC configurations, Custom IDOC development, Workflow, BADI’s, Smart Forms, SAP Script, Menu Painter and Screen Painter, RFC and used BAPI ‘s, User Exit and Field Exit Development, Data conversions, Programming using BDC, ABAP/4 Workbench, Data Dictionary and Batch Job management . Have exposure to Cursors and native SQL.
  • Good understanding of cross module integration and experienced in Planning and scheduling of objects to be migrated.
  • Experiencing in Preparing Field mapping Templates - SD/MM /QM /PP/LE/PM modules.
  • Good experience working with LSMW / ALE - IDOCS / BAPI / BDC /BODS - specifically for Data migration projects.
  • SQL Query optimization/tuning and learning effective SQL programming techniques.
  • Experience and Knowledge on BODS 4.0 ( Business Object Data Services, SAP HANA Data Provisioning using SAP LT Replication Server (SLT ) and Data services .
  • Experience in proposing strategies for Data conversion and planning the schedules for all the dependant objects for complex Data migration project.
  • Good experience in LSMW Transactions, Developed Interactive and Classical reports, ALV reports, Scripts, BDC, Data Dictionary objects, Interface programs, Dialog programming, User exits.
  • Strong exposures to functional areas like Sales and Distribution (SD), Material Management (MM), Warehouse Management (WM), CRM, Production Planning (PP), Quality Management (QM), IS-Utilities, Plant Maintenance (PM), Project System (PS) and Financial Accounting & Controlling (FI/CO).
  • Excellent analytical, communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, WI

SAP Data Service Consultant - ETL Developer

Responsibilities:

  • Implemented performance optimization for SAP BODS jobs .
  • Experience with loading Master data - Materials and Assets Master data using Inbound IDOC using BODS.
  • Experience in working with Table Comparison, Map Operation, Validate, Case, Data Transfer and Query Transforms.
  • Experienced in Data Quality Transforms - Global Address cleanse, U.S. Regulatory address cleanse - loaded Quality codes - Q1 and Q2 into the target.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Involved in gathering the requirements from the Business users and in the project planning, developing, implementing and managing project deliverables, design documents

Confidential, WI

SAP Data Service Consultant - ETL Developer

Responsibilities:

  • Data Migration - Used techniques like De-duplication for Customer Data, Pattern matching, String matching, Validate transform, Domain value check.
  • Developed the workflows to load the data into all the modules of Material Master using Idoc.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Experienced loading data into BW as Target for CDC type 2, Experience working with BW extractors as source.
  • Testing and making sure to support the business user in all the ways to make sure the data gets loaded successfully with the success rate of 99-100%.
  • Used several ABAP data flows for extracting Vendor master data, BOMs, Work centers and Routings.
  • Developed jobs for the modules like Material Master views, Inventory, Vendor, Customer, and AR/AP Open Items in an efficient way with no performance issues.
  • Upload of the Material Master views - Basic Data, MRP, Purchasing, Work scheduling, Quality view, Accounting, Costing and Warehouse Management view .Used Direct input method and BAPIs for loading the data
  • LSMW - Upload of Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger (G/L),Profit and Loss, GR-Goods Recepit
  • Created an upload program for loading the BOMs and Routings, Long text for Routings .Created LSMW for uploading and changing the Work centers.
  • Developed program using LSMW for Component allocation on Routings
  • QM views,QM info records, Inspection plan and Quality levels, Quality Notifications
  • Program for uploading of Vendor master address information, Company code and Purchasing data. Creation of Purchase Info records using LSMW recording .Handling of Conditions and Scales in PIRs.
  • New program for editing for the Partner information in Vendor Master.Upload of Source Lists, Purchase Info Records, vendor Contact information

Confidential, CO

HANA / DATA MIGRATION Consultant

Responsibilities:

  • Experience with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
  • Migrated various Tables from Non SAP system to SAP using using Data Services .
  • Configuring and loading data from SAP ECC6.0 to SAP HANA
  • BOBJ tools - Created Universe and displayed the data using Visula Intelligence - Dash board and WEBI tools
  • Experience in creating and modifying SQL script code in Calculation views
  • Experience with SAP HANA programming using ABAP code which uses HANA as secondary database .

Confidential, SC

ETL - Team Lead

Responsibilities:

  • Used SAP BODS, SAP Information Steward and SQL Server 2008 extensively for Data Profiling, Data Quality and Data Conversion/Migration tasks.
  • Used Match Transforms, Address Cleanse and Data Cleanse Transforms for Address and Data Cleansing in Data Quality for various countries like US, Mexico, Spain and Germany.
  • Configuring and loading data from Flat file to SAP BI using BODS.
  • Data Profiling - Used techniques like Match Transforms, Pattern matching, String matching, Validate transform, Domain value check, Address Cleanse and Data Cleanse Transforms.
  • Created the Local Repositories, Central Repositories and configured the Local with Job server and Central Management console (CMC).
  • Developed the workflows to load the data into all the modules of Customer Master using the Idocs.
  • Developed highly complicated modules like Vendor, Customer, and AR/AP Open Items in an efficient way with no

Environment: SAP ECC,BODS, SAP PP, QM, FI, MM, LE (WM), SD, PM

Confidential, SC

ELT Developer

Responsibilities:

  • Involved in gathering the requirements from the Business users and in the project planning, developing, implementing and managing project deliverables, design documents
  • Used SAP BODS, Oracle 11g 2008 extensively for Data Conversion/Migration tasks.
  • Configuring and loading data from Flat file to SAP BI using BODS.
  • Data Migration - Used techniques like De-duplication for Customer Data, Pattern matching, String matching, Validate transform, Domain value check.
  • Created the Local Repositories, Central Repositories and configured the Local with Job server and Central Management console (CMC).
  • Developed the workflows to load the data into Material Master Sales and Partner roles from legacy systems.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Material Master IDOC.
  • Developed the workflows to load the data into all the modules of Material Master using Idoc.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Testing and making sure to support the business user in all the ways to make sure the data gets loaded successfully with the success rate of 99-100%.
  • Support in Cutover activities during the go-live.

Confidential

ETL Developer

Responsibilities:

  • Involved in gathering the requirements from the Business users and in the project planning, developing, implementing and managing project deliverables, design documents
  • Used SAP BODS, Oracle 11g 2008 extensively for Data Conversion/Migration tasks.
  • Configuring and loading data from Flat file to SAP BI using BODS.
  • Data Migration - Used techniques like De-duplication for Customer Data, Pattern matching, String matching, Validate transform, Domain value check.
  • Created the Local Repositories, Central Repositories and configured the Local with Job server and Central Management console (CMC).
  • Developed the workflows to load the data into all the modules of Material Master using Idoc.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.

Environment: SAP ECC,BODS4.0, SAP PP, QM, LE (WM)

Confidential

IS Utilities Consultant

Responsibilities:

  • Accountable for handling all technical requirements, trouble shooting, BAU
  • Development & Design of Final settlement – Invoicing, Debt calculation, Reinvoicing & Settlement letter
  • Involved in requirements gathering, design, development and testing
  • Good knowledge on ISU processes – FICA, customer services
  • ALE IDoc configuration, IDoc monitoring, IDoc trouble shooting
  • Data migration through LSMW
  • Enhancements, Payment interfaces

Confidential

Team Lead

Responsibilities:

  • Requirement gathering
  • Concept realization
  • Creating interface for moving data from Non SAP work on tool to SAP ECC 6.0
  • Designing of customizing tables.
  • Created LSMW, BAPIs and used the Direct Input programs for downloading and uploading of the below objects
  • Sales price condition, Schedule agreement, Customer material Info record upload, Download and Upload of correction delivery .
  • Report for downloading and Uploading of SALES PRICE CONDITION – VK11 transaction
  • Extraction old scheduling agreement using customer and material cross reference files.

Environment: SAP ECC, SAP PM /BODS/BOBJ

Confidential

Sr.ABAP Developer

Responsibilities:

  • I was into development of ALV Reports and SAP Script for this client.
  • Involved in creating technical specifications based on the Business requirement.
  • Involved in code review and performance tuning.
  • Correction of the Programs. And performace tuning was carried out using SQL trace and Runtime analysis
  • Accountable for handling all technical requirements, trouble shooting, Helpdesk ticket activities
  • Partner profile settings for outbound IDocs, IDoc monitoring, Debugging, correction
  • Copying and changing of the SAP output type, creation of condition record, fine tuning of messages.
  • Creation of new IDocs, segments, message types
  • Develop reports on 3 levels Cash discount, discount on part payment and credit note issue

Environment: SAP ECC 6.0, SAP PP

Confidential

Team Lead

Responsibilities:

  • Involved in assigning the objects to the consultants,
  • Providing Technical solutions and Quality review for the objects.
  • Upgraded the custom, SPDD and SPAU objects.

We'd love your feedback!