Data Architect
Nasaq for Computer Services
Total years of experience :24 years, 6 Months
- Gathering business needs and transforming them into a feasible technical solution plan.
- Data collection and analysis.
- Data modelling.
- Decided on best data integration practices.
- Oversaw data pipelines building.
- Reviewed and enhanced database design.
- Oversaw building data marts.
- Oversaw development of reports, visualizations and dashboards.
- Managed and directed whole activities related to data conversion from Bankmaster core banking system to Oracle Flexcube core banking system.
- Liaised with business users, IT users and vendor.
- Outlined the mapping between source systems and target system.
- Supervised ETL team & data cleansing team.
Key Project To Credit:
• Oracle Data Warehouse Phase II, - Jordan
Highlights:
• Achieved substantial reduction in time required for execution of project development lifecycle by fast debugging ETL (Extraction Transform Loading) procedures.
• Improved speed and efficiency through automation of OS-level script files development process.
• Successfully reduced time and efforts involved in running ETL programs by restructuring the indexes built on the tables.
Key Clients Handled:
Housing Bank.
• Oversaw major issues pertaining to planning, administration and maintenance of Data Warehouse System at Housing Bank for both client side (RM, TP & PA Modules) and server side (database and OFSA engine).
• Analyzed requirements and negotiated Data Warehouse Technical Support & Maintenance contracts to strike the best deal for the company.
• Provided technical support to the implementation team for resolving all technical issues associated with Oracle database and Oracle Warehouse Builder (OWB) to ensure smooth ETL development cycle.
• Developed and implemented Data Quality PL/SQL procedures to verify the accuracy of data stored in the DWH repository.
• Devised PL/SQL procedures. Performed ETL Programming using OWB and PL/SQL packages.
BSA (Board of Supreme Audit - Iraq).
• Proffered Oracle 10g training to the end users in areas of SQL, PL/SQL, Forms, Reports and Oracle Administration I & II whilst ensuring all training standards are adhered to.
• Performed database tuning, upgraded existing applications to improve performance/ usability and ensure smooth ongoing operations.
• Assisted the clients in identifying and resolving Oracle database administration related issues. Enforced and maintained database constraints to ensure database integrity and manage effective resource sharing amongst applications.
Key Projects To Credit:
• Oracle Data Warehouse, Arab Bank - Bahrain
- Provided technical support to the implementation team for resolving all technical issues pertaining to within Oracle database, OWB and ETL cycle procedures.
• Oracle GL, Arab Bank - Jordan
- Development of Data Migration/Conversion PL/SQL Procedures.
• Oracle HRMS, Jordan Telecom - Jordan
- Commissioning of Business Intelligence Reporting system using Oracle Developer Reports and Oracle Discoverer Reports.
• Oracle CRM, Jordan Telecom - Jordan
- Development of Business Intelligence Reporting system using Oracle Developer Reports and Oracle Discoverer Reports.
• Oracle Data Warehouse Security Enhancement, Housing Bank - Jordan
- Design and implementation of database-level & application-level security solution. Development of migration utility to migrate database objects using Oracle SQL, PL/SQL & Forms.
• Oracle Data Warehouse, Bank of Jordan
- Development of utility to run ETL cycle procedures to store DWH using Oracle SQL, PL/SQL & Forms.
Highlight:
• Single-handedly managed a wide range of Oracle products:
- Oracle Database 9i
- Oracle Applications 11i (E-Business Suite)
- Oracle Financial Services Applications (OFSA)
- Oracle Warehouse Builder
- Oracle Application Server
- Oracle Discoverer
- Oracle Financial Analyzer
- Oracle Sales Analyzer
- Oracle Budgeting & Planning
Key Responsibilities:
• Compiled user requirements to design detailed program specifications encompassing user interfaces, security/control and performance requirements.
• Installed and configured Oracle Web Listeners, Forms/Report Servers and Concurrent Manager for the clients.
• Recommended upgrades to existing systems, developed backup/recovery strategy using RMAN as well as disaster recovery setup using Oracle Data Guard and extended 24x7 support/guidance to users for resolving technical issues.
Key Project to Credit:
• Ross Financials, National Electric Power Co- Jordan
- Managed and executed data migration from RDB database on OpenVMS machine to Oracle database on Unix machine for 11 systems.
- Liaised with customer.
- Developed data quality PL/SQL procedures to detect data errors and perform automatic correction for the same.
Key Responsibilities:
• Provided internal and on-site support to customers for installation, tuning and troubleshooting of the following Oracle products:
- Oracle Database 8i/9i
- Oracle Collaboration Suite
- Oracle Designer
• Delivered training to individuals/corporate customers on the following:
- Developer 6i/9i Track: Courses: SQL, PL/SQL, Forms, Reports
- Database 8i/9i Administration Track: Courses: Fundamentals I & II, Backup & Recovery.
- Designer 6i Track: Courses: Systems Modeling, Forms Design & Generation, Server Design & Generation
Systems Analyst.
Oracle Programmer.