Snr Business Data Analyst / Project Manager
Abu Dhabi Islamic Bank
Total years of experience :23 years, 3 Months
Senior Business Data Analyst / Project Manager for Enterprise wide Archiving Solution Implementation covering Core Banking / Core Cards System / EStatement / Credit Origination / Online Channels / Call Center and Other transaction systems.
Finance Transformation / Change Management
• Accountable Executive for SAS Data ware House Implementation with Focus on Finance Specific Data mart (BI Implementation for Finance) - Go Live Jan 2019
• Process Re - engineering and optimization of 200+ processes / reports /templates /Macros within the Financial Reporting / GL Control / Regulatory reporting and MI.
• Implementation of Data Governance Framework.
• Part of IFRS 9 System Implementation and automation of IFRS 9 output reports.
• Key Member of system implementations within Finance - Core Banking (T24) Upgrade / Oracle ERP (Corporate GL) Implementations / Profit Distribution System.
• Coordination with cross-functional teams to enhance existing systems/ processes to achieve optimized MI.
• Review and prep of project scope /development of work plans, estimates, and timelines for Finance related projects (ALM / Profit Distribution / VAT Integration).
• Analysis and documentation of business requirements / risks identification to support the design and development of process solutions.
• Key member of Finance Project Managements Team.
• Established SLAs and Policies and Procedures for Budgeting and MIS/GL Control.
• Created a specific unit of GL Control for Balance Sheet Substantiation via approved Risk Matrix and implementation of Controls across Core Systems.
Finance Architecture / Data Base Management
• Implemented a Bank wide MIS Data Mart to support the Finance department / Bank in the absence of a governed BI solution.
• Managing a Hyperion Desktop Studio and Oracle EPM run on an SQL Server 2010 (DB and SSIS Data Integration Tool) within the Finance department, integrated with Core Banking / ERP and Cards staging databases.
• Maintenance of Finance Architecture for effective Finance Reporting
MIS and Performance Management
Performance Management and MIS
• Monthly Business Units Performance Management Packs Prep with detailed supporting MI (Yield /Margin (FTP - Matched Maturity) analysis, Rate/Volume analysis, Budget Comparison/Tracking, KPI tracking, Forecasting, comparison with previous year, Cost Allocation Tracking)
• General Admin Expenses and HR costs tracking against budget for monthly circulation.
• Engage in Cost Knockdown initiatives on a Half Yearly basis based on the financial forecasts.
• Monthly Customer Wise Profitability reports prep for Wholesale Banking Group / Treasury Banking Group linked to Relationship managers /Sectors and regions.
• Branch / Product Wise Profitability reports for Personal Banking Group.
• Coordinate for Balances Score Cards updates and circulation on Quarterly basis for Board and CEO Reporting.
• Coordinate and Lead the Annual Budgeting and Planning process alongside the CFO including setting up detailed Business unit segment targets / detailed Workforce plans / Cost (Opex/Capex) and Revenues planning templates.
• Conduct Quarterly / Annual Forecasting.
• Peer Analysis / Banking Industry Benchmarking prep on a Quarterly basis.
• CEO Management Performance Reviews / Board and Management Packs Preparation
• Assist Business Units for their Adhoc and regular MI requests related to Revenues / Costs Deep dive / Products / Customer drill downs.
• Prep and analysis of Segment Note for Financial Statements
• Assist Investor Relations team in relation to annual Rating Agency reviews / Sukuk Program Updates / Investor Presentations.
I am currently working as a Business Analyst/Project Manager and Business Relationship Manager for all MIS and RISK related projects within the Bank. I have been actively involved in the Requirements/Vendor Coordination/Vendor Assessment/Solution Assessment and automation for all the core MIS/RISK Requirements of the bank, some of which are below
-Bank Wide Business Intelligence Implementation - SAP BI- for Retail/Corporate/WholeSale/Wealth Management (SAP)
-Asset Liability Management and Funds Pricing System (SunGard)
-Central Bank Reports Automation-(SAP-BI)
-Central Bank Risk Bureau Reporting Automation-(SAP-BI)
-Bank Profitability Reporting Models -(SAP-BI)(Customer/Region/Branch/RelationShipManger/BusinessUnit/)
-Collection System Implementation (Nucleus)
-Customer Segmentation and Financials Automation -(SAP-BI)
-Treasury Risk Reporting -(SunGard)
-Integration with Credit Bureau-EmCredit
-Currently working on the Basel II Automation. (Algorithmics/SunGard)
-Enterprise Operational Risk Management (SunGard)
-Early Warning System (Loxon)
My role as a Business Analyst involves assessing the needs for the target business unit and accordingly suggest need for automation. It involves
-Understanding and Documenting Business Needs and Assessing Need for Automation
-Requirements Gathering and Mapping
-Creating and distributing RFPs
-assessing responses
-Vendor and Solution evaluations
-Engaging the Vendors
-Contracts and Negotiations
-Ensuring completeness of Functional Specifications
-Critically handling Change Requests
-Project Management-
-Application Awareness Sessions -
-Training in house IT Resources for Support and Post Live support.
-Conducting Steering Committee Meetings
-Regular Project Updates
Web Applications Development and Database Managments
Masters in Business Administration with Major in Management Information Systems
Bachelors in Computer Sciences