Confident, accomplished and versatile IT professional with extensive experience in business intelligence, ETL, data warehousing, analysis, problem-solving, research and development with over 17 years’ experience in the field. I’m well known for my lively personality and approach to both clients and colleagues which has helped in delivering the most advanced software solutions to top level businesses across the globe. I am looking for my next career challenge and an opportunity to apply my knowledge and expertise on a larger scale.
Analytical and Critical Thinking
GL Financial Performance and Profitability Data cubes (Finance House)
managing and develop a complete project to which include DataMart and data cubes for corporate business of the organization.
The Highlights:
· Providing and designing the mapping in between core applications and financial services.
· Developed All the ETL tools which is require to feed the DataMart’s.
· Developed the data cubes for performance & profitability including the hierarchies with different level.
· Design all related reports including the balance sheet and profit & loss.
Tools: Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services
Risk Management Department (RMD) Data Mart (Finance House)
Designing and building the RMD Data model which is collecting the required data from all core applications (Cards system, Core Banking system, Collection system and customer relationship system)
The Highlights:
· Providing and designing the mapping in between core applications and data model.
· Developed All the ETL tools which is require to feed RMD DataMart.
· Design all related reports including the balance sheet and profit & loss.
Tools: Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services
Card Management System Data warehouse (Finance House)
Designing and building the CMS DW Data model which is collecting the required data from (Cards system, Core Banking system)
The Highlights:
· Providing and designing the mapping in between core applications and data model.
· Developed All the ETL tools which is require to feed CMS DW Stage.
· Design and develop all related reports which is require for card Ops and and retail finance.
Tools: Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services
Anti-Money Laundering (Finance House)
Designing and building the Data model stage which is collecting the required data from (Cards system, Core Banking system) to feed the AML system
The Highlights:
· Providing and designing the mapping in between core applications and data model.
· Writing the SQL Script for data massaging.
· Developed All the ETL tools which is require to feed AML system.
· Design and develop all related reports which is require for card Ops and retail finance.
Tools: Microsoft SQL Server, SQL Server Integration Services.
Oracle Financial Services Analytical Applications & OBIEE
Was involved as data analyst in designing the Staging Schemas which was as middle layer in between the core applications and the Financial services moreover also in the complete setup for the environment.
The Highlights:
· Providing and designing the mapping in between core applications and financial services.
· Complete setup for the environment.
· Managing and administrating the financial services.
· Integrating the solution with multiple reporting services.
Tools: SQL Developer, OBIEE reporting services, BO XI, Weblogic, SSH
Hyperion Financial Management & Hyperion Financial Data Management (HFM&FDM)
Managing complete Solution and working closely with central account department in maintaining Rules, developing Data grids & reports and integrating it with financial services.
The Highlights:
· Managing complete application as system admin.
· Upgrading and migrating Hyperion solution from to 11.1.1.3-11.1.1.4 tell 11.1.2.3.
· Integrating it with OFSAA Using FDM ETL Service Tool.
· Complete setup for DR environment.
· Writing Rules based on business requirement.
· Preparing reports with SmartView using excel.
Tools: SQL developer, OBIEE, VBA, Financial management Console,Shared services, Weblogic, Smartview
Raking Part ifrs Bank-wide project for degradation and implementation of a new core banking applications Suite.
Working closely with all parties involved in the implementation of a core banking application that would replace the existing application, which includes integration with existing environments and applications through direct interaction with development teams
As well as following up with the end user from business to ensure a proper testing is in place, as well as the development of existing applications to make sure they are upgraded and in sync with the newly setup core banking application suite
The Highlights:
· Requirement Analysis for the new changes which related to new core
· Enhancing and developing the existing application based on the new requirement of the new core
· Building and implementing new environment which holding all enhanced applications
· Involve in complete round of Pre UAT’s & UAT’s and supporting the end users.
· Migrating the exist application into production environment.
Tools: Oracle database, Microsoft SSIS, SQL server 2005, Dot net 3.0, 3.5, ASP.Net
Organization Profitability System Inhouse Development Enhancement – MashreqBank Dubai
Leading team responsible managing full project cycle
The Highlights:
· Designing profitability system
· Data mining
· Developing OPS system
· Technical Documentation
· Active Directory implementation
Tools: JAVA J2EE, SQL Server Database, SQL DTS, SQL Analysis services
IPS Sendero – products transfer pricing – Mashreqbank Dubai
Complete managing for the solution and processing the month end and enhance the system based on the new Core banking requirement.
The highlights:
· Develop the preprocess for the system to accept the data from banksys/core banking
· Creating the data mining and the procedures
· Technical documentation
· Develop the post process for the system to transfer the data to the data cubes which is used to generate the reports.
Tools: Oracle database, Microsoft SSIS, SQL server 2005, Dot net 3.0, 3.5, ASP.Net
Active Control List for Operational Risk management- Mashreq Bank
Build and develop Active control List Repository for Operational Risk management which fetches the data from all the over the systems on the organization.
The Highlights:
· Requirement gathering
· Complete technical Documentation
· Design and development
· Gap Analysis
· Implementation and maintenance
· Support the business users
Tools: ASP.Net, SQL Server 2005, SSIS, SSRS
Egypt Regulatory Reports- Mashreq Bank Egypt
Was involved as BI Analyst in analyzing MIS requirements for implementation of Egypt Regulatory Reports.
The Highlights:
· Requirement Analysis
· Documentation
· Design & Development
Tools: ASP.Net, SQL Server 2005, SSIS, SSRS
RBG – Data Marts (MIS Reporting) – Mashreq Bank
Was involved as team lead to migrate Mashreq’s Retail banking users from BO 6.5 to BO-XI R2. Established SSO (Single Sign On) and row based security for data to be always in safe hands.
Tools: Business Objects XI-R2 & SQL Server 2000.
Data Acquisition Gateway System implementation- Central Bank of Sudan
As vendor for this project, was involved as team Lead to manage and implement the full project life cycle.
The Highlights:
· Offsite support
Tools: J2EE, Servlets tech JSP, Java beans, Oracle 10g, JDeveloper, Oracle Application server, Apache Tomcat, SQL Server 2000 DTS
Business Objects Implementation - Oracle CRM - MIS Reporting - National Bank of Dubai
Was involved as a Business Intelligence Analyst for designing Oracle CRM canned reports and universes using Business Objects 6.1 Technologies & Oracle 9i.
The Highlights:
· Provides management power to know their customer better using ad-hoc day to day reports requirements.
· Implementation of BO Web Intelligence, BO Broad Cast Agent
· Data Security based on user access control in separate security layer from reports.
· Web Based reports access.
· Reports Bursting for faster reports access. Complex reports refresh response time in seconds.
· Zero-Footprint Administration Business Objects implementation.
Tools: Business Objects 6.5 & Oracle 9i
The Highlights:
· Data Warehouse is a repository of integrated information, available for queries, analysis and forecasting.
· Data and information are extracted from heterogeneous sources as they are generated. This makes it much easier and more efficient to run queries over data that originally came from different sources.
Age : 44
Place of Birth : Abu Dhabi
Nationality : Yemeni
Marital status : Married
Project Management Institute Gulf Arabian Chapter
Integration Services 2792 New Horizons
Core Data Access 2541 New Horizons
Advanced Data Access 2542 New Horizons
Core Web Application Technologies 2543 New Horizons
Advanced Web Application Technologies 2544 New Horizons
M-DA100 Analyzing Data with Microsoft Power BI 2021
Abu Dhabi