Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Trainings
Timeline
Generic

Muneer Fadhl

Data Warehouse & BI Specialist
Abu Dhabi,Abu Dhabi

Summary

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.

Overview

17
17
years of professional experience
4
4
years of post-secondary education
2
2
Languages

Work History

Business Intelligence Specialist

Finance House
Abu Dhabi, Abu Dhabi
01.2015 - Current
  • Handled massive quantities of business intelligence data, personally managing as much as terabytes.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Overhauled operational workflow to launch Data Warehouse into new processing platform.
  • Researched and compiled tailored monthly analytics and reports for senior management with Reporting and Analysis Services.
  • Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
  • Devised ETL automated scripts used by developers in managing Core systems to improve performance.
  • Provided Data Analysis operational support for high-volume financial institution in fast-paced 24-hour work environment.
  • Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Deigning and developing ETL processes to normalize/de-normalize data from multiple Core systems into Data Warehouse.
  • Created A data Cubes for financial services to provide performance, profit and loss analytical reports.
  • developed and created a Multiple set of reports using reporting services to serve a different sections and departments.

System Analyst

Mashreqbank
Duabi, Duabi
03.2005 - 05.2015
  • Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
  • Developed applications and designed processes for transformation and data management from company-wide databases.
  • Used Unix and Windows operating systems to complete assigned tasks and create unique data solutions.
  • Devised work plans and adhered to strict deadlines in system or database development, communicating with team members throughout process.
  • Validated warehouse data structure and accuracy.
  • Completed quality reviews for designs, codes, test plans and documentation methods.
  • Performed systems and data analysis using variety of computer languages and procedures.
  • Coordinated troubleshooting support for warehouse personnel.
  • Mapped data between source systems and warehouses.
  • Selected methods and criteria for warehouse data evaluation procedures.

Education

Bachelor Degree - Computer Science

University of Applied Science
Yemen
09.1999 - 07.2003

Skills

    Analytical and Critical Thinking

undefined

Accomplishments

    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:


  • Requirement Gathering
  • Technical Documentation
  • Automation of Test Cases.
  • Analyzing Functional specifications
  • Recommendations for change taken and adopted by the development team
  • Developing Arabic version of GUI
  • Updating the full system with the Arabic script using
  • · 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.

Additional Information

Age : 44

Place of Birth : Abu Dhabi

Nationality : Yemeni

Marital status : Married

Trainings

  • J2EE web Development 2005
    Sun micro system Dubai, UAE
  • Oracle Application Server 10g:R2 Administration І 2006
    Oracle University Dubai, UAE.
  • Oracle Application Server 10g:R2 Administration П 2006
    Oracle University Dubai, UAE
  • Project management professional Course 2008
    Cambridge institute Abu Dhabi, UAE
  • PMI Member of 2008

Project Management Institute Gulf Arabian Chapter


  • Microsoft SQL Server 2005 2008

Integration Services 2792 New Horizons


  • Microsoft Visual Studio 2005 2008

Core Data Access 2541 New Horizons


  • Microsoft Visual Studio 2005 2008

Advanced Data Access 2542 New Horizons


  • Microsoft Visual Studio 2005 2008

Core Web Application Technologies 2543 New Horizons


  • Microsoft Visual Studio 2005 2008

Advanced Web Application Technologies 2544 New Horizons


  • Oracle Essbase 11.1.1 for system Administrators 2012
    Oracle University Dubai,UAE.
  • Oracle Essbase Studio 11.1.1 2012
    Oracle University Dubai,UAE
  • Oracle BI Analysis Overview 2012
    Oracle University Dubai,UAE
  • Oracle BI Suite EE 10g R3 Create Reports and Dashboards 2012
    Oracle University Dubai,UAE

M-DA100 Analyzing Data with Microsoft Power BI 2021
Abu Dhabi

Timeline

Business Intelligence Specialist

Finance House
01.2015 - Current

System Analyst

Mashreqbank
03.2005 - 05.2015

Bachelor Degree - Computer Science

University of Applied Science
09.1999 - 07.2003
Muneer FadhlData Warehouse & BI Specialist