Data Warehouse Specialist
Panda Retail Company - Saudi Arabia
Total years of experience :22 years, 4 Months
• DWH Architect, designed from scratch a highly scalable data platform as the foundation for countless strategic decisions within corporate’s current and future operation and to accelerate it even further - data insights are an utmost necessity to make the right decisions.
Design and develop automated complex efficient ETL processes in order to ultimately enable the business intelligence reporting
BI Transformation Project implementation for Infra/BI/Applications which support HR, Finance, Operations, Supply Chain & Purchasing modules.
Conserved cost and time by integrating ERP’s with other sub applications over web services
Implementation of Microsoft AX Dynamics (HRMS, Finance, Logistics, ESS)
Implementation of Openbravo (HR, Payroll, Finance, Logistics)
Implementation of Oracle EBS (HRMS, AP, AR) Dubai Civil Defense & KHDA - Dubai
Upgrade Oracle EBS from R11 to R12 Dubai Smart Government
Resolved & Ensured support solutions provided for Business Applications (ERP etc.)
Current Task is to Migrate from 11i to R12.
Implementing Openbravo as an ERP thorough out the enterprise.
Expert in Openbravo Build, Modifications, Administration and database.
Implementing Oracle EBS in Dubai Govt entities under umbrella of Dubai eGovt. 3 Full Cycle implementations experience in HRMS, GL, AP, AR
. Working on AR, AP, GL, SCM(Inventory), HR & Payroll (Techno Functional). Developing new forms, Reports for various modules, developed 15+ reports using Oracle BI (XML) publisher.
Created Oracle Alerts for several requirements likes "When New job posted, email to HR Director"
Uploaded legacy data(Arabic & English) via Oracle eBusiness Suite provided API’s into HR, Payroll, AP, Inventory.
Did customization according to business process & developed 10+ customized reports based on Oracle BI XML Publisher.
Developed 3 Arabic Reports for different modules.
Uploaded data for Oracle SCM - Inventory like (opening balances, creating inventory items, link items to Sub-Inventory Classes etc)
Tool:
Oracle Apps 12, Forms 6i, Reports 6i, SQL Navigator, MS Project, Oracle BI Publisher(XML Publisher)
Upload legacy data(in Arabic and English) via API into HRMS, AP &Payroll. Done customization according to business process and requirements & developed 15+ customized reports(6 reports in Arabic) and published via Oracle BI XML Publisher.
Tools Used in Project:
-----------------------------------------------------------------------------------------------
Oracle Apps 12, Forms 6i, Reports 6i, Oracle BI Publisher (XML Publisher)Toad/SQL Navigator, MS Project
Below projects are for Govt. of Dubai, Dubai Nuterilzation and Residence Department(DNRD):-
RSA Secure Tokens
Developed RSA Secure Tokens Implementation system for DNRD. System includes Arabic reports and 1D bar-coded delivery receipts
---------------------------------------------------------------------------------
eDNRD Residence Module
System allows applying online residence visa from eDNRD website. Designed DB for using Hibernate architecture. Coded business logic in Backend. Implemented Archiving & Auditing from PL/SQL for all transactions.
---------------------------------------------------------------------------------
eDNRD Passport Module:
System allows applying online Passport for UAE Citizens from eDNRD website. Designed DB for using Hibernate architecture. Coded business logic in Backend. Implemented Archiving & Auditing from PL/SQL for all transactions.
Part of Application Continuity Team who audits the Code which causes the problem in live environments for a application(LARA) which is using worldwide in CMA-CGM offices for Shipping system.
Application Desing for CRM Modules, Application Support, Lead of 2 team members. Work on Distributed Database systems(Oracle and Informix) for Online Credit, Debit and loyalty Card transactions and Baack office support.
Team Leader, DB administration, DB designing & analysis for new applications
Administration of Database & Oracle Financials other applications development.
Financial / Shares Application, development & Database support
Involves in shares settlement system support, upgrade, development
Computer Science, Database management, Software Engineering, Artificial Intelligence
Training on Oracle HRMS Release 12 for Functional Use.
MCS
Oracle Financials-fixed Assets
Oracle Financials-Accounts Payable
Passed in 2003 with 56% marks
Bachelors of Commerce from KU. Majors in Finance, Ecnomics, Accounting, Management.
Professional Accountancy. Complete accounting Cycle from invoice to Balance Sheet in a practical and professional way.
Oracle Certified Database Administrator
online certification of Oracle Database from third party. www.u2test.com
6 Months diploma in Oracle Database and Oracle Developer.
Ms.office97 and Windows98