SAP Data Migration Consultant
Accenture - IRC
Total years of experience :15 years, 2 Months
•Responsible for data migration (ETL) and conversion activities such as extracting, transforming, migrating, validating and reconciliation of data.
•Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements
•Develop “as is” and “to be” business processes to understand system requirements and identify dependencies between systems and with back end data sources and systems
•Develop validation programs to cross check all the data before and after the data loading
•Identify problematic areas and conduct research to determine the best course of action to correct data
•Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution
•Peer reviews of BP310 ( Business Blueprints ) & AP322 (Configuration manuals) functional documents
•Develop AP356 Functional Designs for Data conversion and migration
•Assisting develop LSMW migration programs for data conversion of SAP Plant Maintenance, Project System and Real Estate Flexible Management Objects
•Develop data migration strategies from GIS, Ventyx Ellipse, MapInfo, to SAP and GEO.e to implement LAM(Linear Asset Management)
•Enrich and transform data for various legacy systems including Ventyx Ellipse, Property Management System (PMS), Infor, Tammari, ALM (Asset Lifecycle Management), BRAMS (Brisbane Roads and Asset Management System )
•Optimization of Brisbane Transport and fleet management
•Preload and post-load validation and verification during trial conversion cycles
•Responsible for data deliverables for TC (trial conversion), DR (dress rehearsal), cutover and actual cutover data conversion cycles
•Develop LSMW, ABAP, and Excel solutions for data migration
•Define and ensure that data quality thresholds are met through active collaboration and review data quality assessments with business
•Develop “as is” and “to be” business processes to identify business opportunities and risks
•Extract data from legacy enterprise systems and Data Gap Analysis
•Transform, enrich and cleanse legacy data
•Redesign Functional Location (including Reference Functional Locations)
• Implement Construction Types and Sub-Assemblies (Legacy system used Functional Locations Bill of materials)
• Cleanse and Align Plant Maintenance data objects as per the master data standards
• Master data validation in 1SAP system
• Project phases / deliverables for: mock, cutover rehearsal 1 and 2, actual cutover and post implementation support
• Modelling BPMN in Microsoft Visio
I was responsible for
•SAP technical, configuration, and business processes modelling in PM/CS module.
•Implement SAP BAPI (Business Application Programming Interface) for auto-creation of notifications based on DCS XML messages
•Identify incomplete and incompatible data with customization
•Identify process variations which was caused by master data changes
•Identify the key users to assist in data conversion and optimization
•Design functional specifications of data extracting, mapping and conversion rules
•Organize peer reviews of function specifications
•Organize meetings and discussions to finalize the key decisions
•Develop extract and conversion strategy
•Help with data migration (ETL) processes
•Build upload dependency diagram for data conversion of SAP objects
•Ensure timely completion of data extraction, enrichment and transformation for mock, cutover and actual cutover data conversion cycles
•Organize preload validation and post-load validation of upload files
•Arrange business demo sessions for data and business processes sign-off
•Develop “as is” and “to be” business processes to identify business opportunities and risks
•Responsible to organize unit, system and user acceptance testing cycles of the solution
Responsible for day to day business support by answering the queries related to CRM and in-house softwares.Customized reporting for adhoc business requests to identify the sells data.
Debugging and testing change requests in softwares
3.02 GPA