Former Head of MIS and Business Intelligence
Bank Audi - Egypt
Total years of experience :38 years, 6 Months
Direct and control a cross-functional team of developers. Orchestrate a data warehouse environment with and through Oracle Business Intelligence and Qlikview .
Currently; working as the information hub for Bank Audi Egypt. My division provides information bank wide; senior management reports, finance division reports, budgeting and planning. We provide reports that are sent to regulatory bodies such as Central Bank of Egypt. We provide Reports to retail division, Treasury division, branches, and corporate finance and all other lines of business in the bank.
Going back in time to the time I was hired, there were no MIS in the sense of unified source of data, timely fashioned reports…etc. I started at the retail division where I have successfully established Retail-MIS that shed lots of light on the retail activities such as loan booking turnaround time, the level of faulting loans, reports of the delinquent clients that enabled collection department to decrease the retail loan loss provisions.
On the way to establish the centralized MIS division at Bank Audi Egypt I was transferred from Retail to Finance where I can serve bank wide (instead of only Retail) in Bank Audi Egypt. With focus on finance reports, me and my team successful transformed to way information was delivered and time consumed to deliver it. I worked on delivering control reports, providing data to budgeting and planning for reports such as profitability, starting by bank profitability, by line of business, by branch down to by client profitability. Worth mentioning that I kept working with retail while I was moved to finance, in fact I enlarged the scope of MIS to serve new areas, corp. finance, Treasury, Branches, Credit Risk, Audi, and last but not least Senior Management.
In the way to achieve the above MIS have also built some work around solutions (applications) to overcome the absence of some software facilities.
The mission was to establish a Management Information System to provide information and analytical reports for different levels of users within the bank. Starting with the finance division as a main information consumer and MIS system was established to provide a wide range of report varying from income statement
and balance sheet, Head Office reports, CBE reports, Cost of Funds, retail provisions and many more. Due to the absence of an MIS role within the bank everything was built from scratch and despite of the short period spent with BLOM bank Egypt I succeeded to achieve a tremendous change both in time fashion availability of information and in computerizing some manual reporting jobs.
Responsible for tailoring and maintaining a management information system to serve senior management purposes in supporting the decision making. The MIS system aims at providing analytical information to various parties meanwhile to automate functions that due to their manual preparation represent a real burden both time and accuracy wise. Among the functionalities currently incorporated in the MIS Application::
- Financial statements reporting
- Provisions follow up and updates
- Cost/Profit Centers reporting
- Fixed Assets follow up and reporting system
- Automating numerous manually prepared functions such as reporting to Central Bank of Egypt and to our Head Quarters in Bahrain
As information Technology Manager, I am responsible for all issues related to information technology including:
• Designing and establishing the company network to accommodate all current needs and the expected growth of the company.
• Deciding on the Hardware (Servers), Cabling, Switches, Routers, Hubs etc..) and software to be used to serve the company needs.
• Establishing and implementing the Computer Risk Management procedures to ensure safety and recoverability for company’s most valuable resources, the data.
• Deciding on the criteria and selecting my staff according to business growth.
• Database analysis, programming and management to fill in the gap of unavailable ready made packages as well as to cover the special requirements of the company according to its specific business field
• Administering the company’s network including Windows NT, MS- Exchange, MS - proxy and MS SQL server
• Resolve network, PC hardware and PC software problems in an innovative and timely manner.
• Install upgrades to the network, file servers, and PC hardware and applications.
As Senior MIS Consultant, I was heading the Privatization Project—a project led by Arthur Andersen and funded by the United States Agency for International Development which provides technical assistance to the Government of Egypt in its privatization efforts— Information Technology Department. My responsibilities include the following:
• Software technical support for Microsoft Office and other applications on the network
• Lotus Notes administrator and database manager
• LAN administration for Windows NT 3.51 and Novell networks—more than 60 users
• Resolve network, PC hardware and PC software problems in an innovative and timely manner.
• Install upgrades to the network, file servers, and PC hardware and applications.
• Research and develop a disaster recovery plan for their assigned Area
• Database analysis, programming and management for internal project use and privatized entities—tool employed is Microsoft Access
As Supervisor for EDP and Reporting, I was responsible for:
•Technical software support for DOS and Windows applications running on desktop computers
•Operation and support for an IBM System/36 which maintains bank accounting system
•Analysis, design and creation of management information system databases as tools for analysis by management in the Cairo branch and New York headquarters
•Preparation of financial statements reporting and analysis, as well as periodic and on-call reports requested by head office in New York
As Senior Clerk, I was responsible for:
• Management of accounting department data input and reporting of the bank expenses
•Management of petty cash safe
•Nostro accounts reconciliation
•Follow up for payables and receivables
•Preparation of financial statements
Microsoft Certified Professional, Windows NT Server Administration
A 4 years course to obtain a bachelor degree in Accounting