We provide IT Staff Augmentation Services!

Resume

Ptp Mm Senior Data, ConsultanT

PROFILE:

  • 10 years of experience in IT Technology, 3 years in the BW module, and over 10 years specialized experience in SAP R/3.
  • SAP Data Migration Experience in PTP, HCM, and SRM module. His education has given him strong communication and analytical skills.
  • Confidential has demonstrated expertise with the MM, IM, WM, PP, PTP, CRM, SRM, HCM, and IP SAP modules.
  • His experience in several concentrations gives Confidential a holistic view of SAP, a vital skill in large, multinational migrations.
  • With this knowledge, Confidential has become an excellent communicator who displays great confidence in the work he completes.
  • His technical and analytical skills, as well as his knowledge of the BackOffice Data Migration Methodology and Tools, make him a significant investment for any data migration project.
  • He has developed the work ethic and perception needed to successfully obtain a Boring Go Live®.
  • These skills and the BackOffice Data Migration Methodology and Tools make Confidential a great team member for a data migration project.
  • Extensive knowledge of Database Programming with MS Access, SQL Server 2000, BEx query, and CranSoft®.
  • Over 10 years of specialized experience in SAP R/3

TECHNICAL SKILLS;

Extensive knowledge in: MM, IM, WM, PP, PTP, CRM, SRM, HCM, and IP SAP Modules.

Experiences with: SAP BW 3.x and Netweaver 2004s.

Strong technical skills in operating systems: Windows NT/Me/XP/9x, UNIX, DOS.

Technical skills include Databases: Oracle 11.x, MS SQL Server, MS - Access;

Programming Languages: ABAP/4, SQL, PL/SQL, C, C++, HTML, PERL; OS UNIX;

Data Warehouse Tools: SAP BIW3.0;

Web Technologies: HTML, Dreamweaver, HTML, KML, XML, Fireworks, CorelDraw, Photoshop, PageMaker, and Flash.

SAP PROJECT EXPERIENCE;

Confidential

PTP / MM Senior Data Consultant

Responsibilities:

  • Primarily focused in migrating Vendor Master Data along with partner function and Characteristics Data from existing SAP to new PROD SAP.
  • Primarily Responsible for Map, Transform and de-Dup of Vendor Master Data based on business requirements and load the data into SAP Prod.
  • Responsible for creating Master Data Management (MM, P2P, and OTC) data governance report along with MDM metrics related reports.
  • Developed Integrate BDC Load programs to use and optimize the performance of the loads using Standard SAP load methods:
  • Vendor Class and Charateristic
  • Close PO
  • Responsible for creating new dspCompose requests for Material Master mass update along with easy to use mass upload template.
  • Responsible for creating new dspCompose business validations rules and business process rules to make the process user friendly and more automated for the business user to do mass data load directly into PROD SAP.
  • Responsible for creating PO Close app to collect Vendor PO related data from SAP and present it to client with complex business rules, automated workflows, and easy to use cAMGEN application.

Confidential

MM Senior Data Consultant

Responsibilities:

  • Primarily focused in migrating Material Master Data and Class & Characteristics Data from Legacy Source Systems - Baan, SAP, Louxor, DLX FR - to Mariposa D3 SAP. Manage Data Migration activities across multiple process areas.
  • Primarily Responsible for MM & Classes & Characteristics Objects.
  • Responsible for extracting Legacy Source Data, CTSX and Adept SQL code promotion to 3 Tier DSP platform, Creating custom Data Construction Server pages for user to manage data, Data transformation, and Data load in to SAP.
  • Assist team, business users, and functional team with object field mappings, data analysis, defect resolution and provide support in Pre and Post load verification activities.
  • Developed DSP® custom Material De-Dup DataConstructionServer™ WebApp pages to support De-Duping activities.
  • Developed Object reports (Informational, Error, and Reconciliation Reports) to identify gaps and work with SME’s on defects for a resolution to ensure master and transactional data loaded successfully in SAP.
  • Developed LSMW Load programs to use and optimize the performance of the loads using Standard SAP load methods:
  • LSMW Direct Input load method (RMDATIND) to load Material Master Data (views) in SAP.
  • BODS Load Program - Idoc load method (CLFMAS) to load Material Classification data in SAP.
  • LSMW BAPI load method (Message Type MATMAS BAPI) to load Material Sales View data in SAP.
  • WINSHUTTLE load method to post Delta Classes and Characteristics in SAP.
  • Developed Delta Load Process for Material Master and Classes & Characteristics in SAP.
  • Helped with Technical DSP Environment set up when needed on Demand based on previous experiences

Confidential

BackOffice Migration Consultant

Responsibilities:

  • Created Standard Operating Procedures (SOP) related to Data Migration Activities
  • Created Standard Work Instructions (SWI) related to Data Migration Activities
  • Created Installation Qualifications and Quality Qualification process documents related to Data Migration Activities
  • Executed Installation Qualifications and Quality Qualification process documents related to Data Migration Activities
  • Created Source Rules (sr), Source Views (sv), Source Tables (st), Target Tables (tt), and reconciliation processes.
  • Created SQL stored procedures and DTS packages using SQL Management Studio.
  • Performed Tests and debugged it.

Confidential

BackOffice Migration Consultant

Responsibilities:

  • Performed SQL Server Infrastructure and Security role.
  • Assisted teams with configuring, debugging, tuning, and optimizing SQL queries and store procedures.
  • Design and implementation of SQL database replication strategies.
  • Determine, implement, and manage SQL database backup and recovery strategies.
  • Ongoing SQL database performance tuning.
  • Implement and enhance SQL database security using proven methodologies.
  • Strong understanding of, and experience with, server-client computing and relational database environments.
  • Experience with data management and data processing flowcharting techniques.
  • Knowledge of reporting and query tools and practices.
  • Technical documentation skills.
  • Performed CranSoft® Infrastructure and Security role.
  • Helped creating CranSoft® LDAP authentication and debugged CranSoft® LDAP authentication.
  • Created custom WebApps, WebApp pages with workflow / email notification.
  • Helped Team with WebApp related issues, questions, and upgrades.

Confidential

BackOffice Migration Consultant

Responsibilities:

  • Created Source Rules (sr), Source Views (sv), Source Tables (st), Target Tables (tt), and reconciliation processes.
  • Created stored procedures and DTS packages using SQL Server.
  • Performed ETL Process.
  • Loaded objects into SAP using BDCdirect®.
  • Created and modified complex DataDialysis® reports.
  • Performed Tests and debugged it.

Confidential

Migration Consultant

Responsibilities:

  • Created Source Rules (sr), Source Views (sv), Source Tables (st), Target Tables (tt), and reconciliation processes.
  • Created stored procedures and DTS packages using SQL Server.
  • Performed ETL Process.
  • Performed Tests and debugged it.

Confidential

BackOffice Migration Consultant

Responsibilities:

  • Assisted the GPS team in collecting and analyzing Reporting/Data warehouse requirements for the BMS US Pharmaceutical products.
  • Created stored procedures and DTS packages using SQL Server.
  • Created technical documents for GPS related Global Products and Medicaid Global Products.
  • Created Source Rules (sr), Source Views (sv), Source Tables (st), Target Tables (tt), and reconciliation processes.
  • Performed ETL Process.
  • Performed Tests, debugs, and check diagrams.

Confidential

BackOffice Senior Consultant

Responsibilities:

  • Assisted the Back to Basic Reporting team in collecting and analyzing Reporting/Data warehouse requirements for the Mexico, LATAM, Canada, North America, and Japan Consumer Companies.
  • Participated in the development, maintenance, integration, and enhancement of databases within project deadlines.
  • Primarily focused at a global MD&D, SYN, and Pharma company migrating data from Legacy Source Systems - MARS, Oracle, JDE, CrossRoads, LYNX, and SLR to SAP. Manage Data Migration for entire SAP Module, coordinate resources across multiple teams.
  • Primarily Responsible for Data Quality Reports, MM, IM WM, CRM, Contracts, & PP-PI Objects data loads via Integrate BODS, and Winshuttle.
  • Responsible for extracting legacy source data, data transformation and data load in to SAP.
  • Lead and assist the Winshuttle and Data Quality Team, business users and functional team with data analysis, data loads, and defect resolution.
  • Developed DSP® custom DataConstructionServer™ WebApp pages to support unstructured data.
  • Providing data analysis for business relevancy and accuracy of the source data.
  • Developed Object reports (Informational and Error Reports) to identify gaps and work with SME’s on defects for a resolution to ensure master and transactional data loaded successfully in SAP.
  • Developed Object reports (Pre-load and Post-Load Reports) for business to verify the data before and after the load.
  • Identify Winshuttle, LSMW, BAPI, and BODs Load programs to use and optimize the performance of the loads using Standard SAP load methods
  • LSMW BAPI load method (MATMASS BAPI Create Change) to load Material data in SAP.
  • BDC Direct Input load method to Label Data (views) in SAP.
  • BODS load method to load Bill of Materials and Recipes.
  • Utilized productivity tools (i.e. Microsoft Office) to make gains in proficiency in preparing accurate and thorough proposals, system designs, program specifications, test plans, procedures, and other documentation.
  • Assisted in project plan / schedule development and maintenance, risk assessment, change management, and issue management.
  • Created InfoObjects, InfoCube, ODS, InfoSource.
  • Created update rules to DSO/ODS.
  • Created Communication Structure.
  • Created MS Access database, SQL Server Database, and CranSoft® Database.
  • Performed Tests, debugs, and check diagrams.
  • Created stored procedures and SSIS packages using SQL Server.
  • Created Ad-hoc queries and Bex queries.

Confidential

Web Designer Analyst

Responsibilities:

  • Edited images with Adobe Photoshop, Macromedia Flash MX and Fireworks.
  • Gathered requirements by interviewing clients.
  • Actively participated in documenting and maintaining requirements documents.
  • Tested, Debugged, and Checked computer programs.
  • Provided technical and application consultation.
  • Developed and recommended innovative solutions and alternatives for complex problems.
  • Installed and troubleshoot computer hardware and software.

Hire Now