Data Migration Analyst
Jebel Ali Free Zone, Uae
CHALHOUB GROUP, U.A.E. MAY 2013 TILL DATE Job profileDATA MIGRATION ANALYST1. Develop custom scripts for validation and data transformation (items) to Oracle Retail Management System using PL/SQL stored procedures, UNIX, MS-Dos, and MS-Excel 2010.2. Solution design of item migration process from legacy system to oracle standard.3. Understand the existing functional process and analyze item data from legacy system.4. Put forward the cleansing methods of data… Show more CHALHOUB GROUP, U.A.E. MAY 2013 TILL DATE Job profileDATA MIGRATION ANALYST1. Develop custom scripts for validation and data transformation (items) to Oracle Retail Management System using PL/SQL stored procedures, UNIX, MS-Dos, and MS-Excel 2010.2. Solution design of item migration process from legacy system to oracle standard.3. Understand the existing functional process and analyze item data from legacy system.4. Put forward the cleansing methods of data between the systems and agree the same with master data management team and data owners.5. Design the cleansing templates and ensure data consistency and accuracy.6. Reconcile the data and make the data ready for sign offs.7. Trouble shoot the integration of items to down streams like SIM.8. Write SQL queries/ procedures for troubleshooting of the bugs. Identify and fix bugs.9. Support the item ranging activities.10. Support the stock and stock aging migration process from legacy to oracle standard.11. Migration of six months transactional history data to Oracle POS and reconciliation.12. Support the retail and distribution history migration into Retail and EBS BI respectively.13. Reconciliation of customers and suppliers in Oracle EBS.14. Implemented the data migration activities for Kuwait, JAZFA-UAE and Egypt.15. Developed excel macros for improving the work performance at various stages of implementation.16. Assisting in Post Go Live support activities and generating operational reports.Tools Oracle 10g (SQL,PL/SQL, Stored Procedures), Oracle RMS, Oracle POS,MS-Excel,VBA,VB-6,SQL-Server 2000,OS- Unix(SQL*Loader) Show less