Data Migration Lead/senior Consultant Resume
0/5 (Submit Your Rating)
SUMMARY:
- 9+ years of experience in I.T Industry with functional, technical and domain experience in food & beverages and Agro - Chemical Industry. Result oriented, persistent and hardworking individual with established record of of handling problems and challenges, which aid in learning new applications and technologies and enhance the technical skills.
- Profound knowledge of data migration process and its troubleshooting in different types of platform.
- Responsible for driving markets, supporting in managing projects to migrate data in SAP.
- Experienced with Data Quality Management, Master Data Management and Data Model Standards.
- Persuasive communicator with management skills with the ability to relate to people at any level of business and management.
- Worked with functional team analyzing the requirements and finding the best possible approach to implement them.
- Experience in reviewing the Technical specifications and Technical mapping designs, attending walk through discussion.
- Experienced in data analysis in SAP, data loading, supporting data integration activities and data reconciliation.
- Worked extensively in numerous Globe Template Implementations in both EMENA and AOA regions
- Good hands on experience in SAP ECC, LSMW, CRM, EWM modules and Informatica.
- Hands on experience in preparing scope/loading plans/strategy and go live/cutover.
- Strong understanding on ERP and business.
- Good Knowledge of SAP data structures and data flow.
- Experienced in working with cross-zone teams and markets.
- Planning and execution simulations and confirm data integrity and functional validation of migrated data.
- Define data migration approach and strategies, provide detailed data load plans for all objects, sequences, systems and responsibilities.
- Strong team player with excellent inter-personal, written oral and communication skills.
- Proven ability to quickly learn and apply new technologies and work with creativity, innovation, and ability in a paced environment.
TECHNICAL SKILLS:
Technology and Tools: BOA DSP migrate/SAP ADM (Certified), SAP LSMW, LTMC, SAP ECC 6.0, SAP EWM, SAP CRM 7.0, Informatica power center, Microsoft office, Requirement Analysis, Microsoft Sql server, My SQL, Mongo DB, Hive Ql, Python NumPy, Pandas, Matplotlib, Seaborn, Tableau.
PROFESSIONAL EXPERIENCE:
Data Migration Lead/Senior Consultant
Confidential
Responsibilities:
- Scoping Legacy Data & understanding the business requirements.
- Initial data profiling.
- Data extraction & data preparation.
- Mapping sheet preparation.
- Build the mapping.
- Implement all transformation & conversion rules.
- Automate & object building.
- Load file preparation.
- Pre-load,post-load and config validation reports.
Confidential
Responsibilities:
- Extracting data from SAP ECC system as per extraction criteria.
- Working with the Blueprint team and Data Architect to set up ADM for migration.
- Mapping sheet Creation (Mapping logic/conversion rule/business rules).
- Implementation of Mapping/conversion/ business rules for data preparation for migration.
- Adding external tables not imported via collect for migration.
- Fallout and error analysis.
- Migration Status,pre-load,post-load and config reports preparation.
- Colleagues on Syniti Dsp migrate.
Confidential
Responsibilities:
- Prepare the data-loading plan for the implementation. Scope the data for additional changes required on Master Data level and replicating these changes to ECC.
- Creating data model in DEV, RTE, PREP for testing and simulating the cutover
- Create and execute integration models to CIF the data from ECC to EWM.
- Maintaining carriers on EWM
- Maintain data for the EWM objects (Storage bins,Fixed bins,WH product update,Packaging specification,Stock).
- Setting up the workflow for Products and Packaging Specification.
Confidential
Responsibilities:
- Data objects required for migration were scoped out and the existing data had to be mapped and transformed to meet data standards of Confidential .
- Based on the project plan, created the load plan and perform cutover simulations which includes with interacting and working with various streams and their data ranging from Material Master to Inventory load, Stock load, AR and AP.
- Using Informatica to validate the quality of the data provided by the market and using LSMW to load the same.
- Replicating the data from MDR and SDR to respective logical system.
Confidential
Responsibilities:
- Based on the project plan, created the load plan and perform cutover simulations which includes with interacting and working with various streams and their data ranging from Material Master to Inventory load, Stock load, AR and AP.
- Used Informatica to validate the data provided by the market and when the data passed the validation using LSMW to load the data in the system.
Confidential
Responsibilities:
- Scope out the data for each market with R&D facility from Europe and Africa, Oceana and Australia regions for data migration and prepare a loading plan (object sequence and dependency).
- Extract the data using queries and tables from the source systems(SAP) and load it in the target system using LSMW.
- Based on the requirement of project, drafted requirements, drew up functional specifications and coordinated the development of new LSMW, Innowera scripts for P2P objects.
Confidential
Responsibilities:
- Prepared Migration Plan and participated in cutover planning meetings with programme manager.
- Coordinated with market data managers, functional teams and Data Migration Counterpart from SAP.
- Created MRDM (Market Data Model) using LSMW and informatica for AOA and EMENA Markets for Post migration testing.
- Migration and reporting done using LTVF tool.
Confidential
Responsibilities:
- Prepare the scope and loading plan based on the requirement from market.
- Run ETL validations to cleanse and improve data quality.
- Coordinate and load the data via LSMW and validate and simulate cutover before Go Live.
Confidential
Responsibilities:
- Prepare the loading plan (object dependency) and cutover strategy.
- Validate the legacy data (Data Information Sheets) from the market using and transform it into loading format using Informatica and load the data into the system via LSMW.
Confidential
Responsibilities:
- Preparing the objects scope list for the migration.
- Preparing the load plan for 2 test cycles and go live.
- Testing the configuration and co-ordinating with various streams and markets for the data collections and corrections for successful completion of test cycles and go live.
- Informatica was used for the validation of the legacy data and LSMW was used to load the data into the system.
Confidential
Responsibilities:
- Create a Market Data Model by extracting and loading the data from respective objects from Production system and loading it in lower environments for markets to test the data after the migration. It consisted of data of all the functional streams on ECC.
- This is involved cross zone coordination with multiple markets at once.