Established in 1964, the African Development Bank (AfDB) is the premier pan-African development institution, promoting economic growth and social progress across the continent. There are 81 member states, including 54 in Africa (Regional Member Countries). The Bank’s development agenda is delivering the financial and technical support for transformative projects that will significantly reduce poverty through inclusive and sustainable economic growth. To sharply focus the objectives of the Ten-Year Strategy (2024 – 2033) and ensure greater developmental impact, five major areas (High 5s) have been identified for scaling up, namely, energy, agro-business, industrialization, integration and improving the quality of life for the people of Africa. The Bank is seeking to build a management team that will lead the successful implementation of this vision. The Asset and Liability Management Division (FIFM1) is responsible for developing and directing the Asset and Liability Management functions of the Bank Group entities, including financial policies, financial modelling and projections, and balance sheet management activities involving risks related to changes in interest rates, exchange rates and the liquidity position. The Corporate IT Services department (TCIS) is responsible for the provision of efficient, effective and modern IT infrastructure and application services to support, optimize and transform Bank’s business process for developing Africa. Under the leadership of the Bank’s Information System’s Director, TCIS department is mandated by the Bank to deliver the best possible IT services for Bank staff and help achieve the results that will get the Bank closer to accomplishing its development goals.
The objective is to implement full financial statements projections as well as manage liquidity and interest rate risks in AMBIT Focus/Balance Sheet Manager (BSM) for the Bank and the Fund (ADF). In this regard, TCIS, on behalf of FIFM1 that is the main user of AMBIT Focus/BSM, is looking for a qualified Senior financial Consultant to provide services in the configuration and testing of AMBIT Focus/BSM as well as to coordinate applications development and training of team members within FIFM1 and TCIS.
B. Scope of work
The consultant duties will include the following:
i. AMBIT Focus/BSM application development Assist in the definition of user requirements and specifications and contribute to their implementation in the ETL with the promotion of good practices and code standards. Liaise with stakeholders and IT Management to study systems flow, data usage and work processes. Gather and update relevant data and inputs from the Bank’s systems or from data providers. Conduct the data mapping between AMBIT Focus/BSM and other systems of the Bank. Drive the data reconciliation process and aid in the research of inaccuracies to ensure that source files are aligned with data retrieved in AMBIT Focus/BSM. Provide guidance and assistance to business users in any aspect of AMBIT Focus/BSM configuration, testing and documentation. Assist in the System Integration Testing (SIT), User Acceptance Testing (UAT) and remediation of issues. Provide support in diagnosing and resolving AMBIT Focus/BSM complex user problems. Contribute to the review, maintenance, and validation of the ETL. Document controls, analyses and model enhancements. Contribute to the parallel run between AMBIT Focus/BSM and existing models. Provide training to the team. Provide expert advice and guidance to ensure a successful AMBIT Focus/BSM product is delivered. Keep track of industry best practices and latest regulatory developments. Keep the system procedures manual up to date.
ii. IRRBB and ADF MBO implementation in AMBIT Focus/BSM Contribute to the specification of the banking book/trading book classification and its implementation in Ambit Focus/BSM. Implement and test EVE and NII sensitivity shock scenarios. Contribute to the validation of IRRBB results and the benchmarking with peer institutions Explore the possibility of implementing ADF Market Borrowing Option (ADF MBO) projections in the Ambit Focus/BSM environment.
iii. Generation of BSM Reports Generate the following reports: o Dynamic reports (financial forecasts) o IRRBB reports o Interest Rate Gap reports o Liquidity Gap reports
Upgrade financial forecast model to include two additional dimensions: o Region o Industries
iv. BSM System Configuration Work with FIS to configure and test the following additional modules: o Transformations o Funds Transfer Pricing o Profit & Loss o Liquidity Risk Document and report configuration and testing outcomes.
C. Deliverables Expected
The expected deliverables during the assignment are the following: Full documentation of all implemented solutions and new methodologies to enhance AMBIT Focus/BSM financial projections. Configuration of BSM for ADF’s financial projections. Configuration and testing of new BSM modules. Support, review and validation of the ETL processes. Documentation of issues diagnosis and corrective measures. Review of existing procedures and writing of the user manual. Training of both technical and functional users.
D. Duration and Timetable for the Assignment
The assignment duration is six (6) months spread over twelve (12) months, on a partial time basis.
E. Bank Contribution and Institutional Arrangement
The consultant will receive a monthly lump sum rate based on his experience. No additional benefits or per diem will be paid. The individual consultant is responsible for his/her own health insurance and own accommodation cost.
F. Duty Station
The assignment duration is six (6) months spread over twelve (12) months, on a partial time basis.
G. Essential Specialized Skills/Knowledge/Competencies
• The Consultant shall be a professional of high repute, who has at least 5 years working experience in supporting and maintaining FIS/SUNGARD AMBIT FOCUS in a Financial Institution environment. • Minimum of 5 years’ experience in supporting and maintaining Microsoft Technologies. • Extensive experience in configuring and working with: AMBIT Focus GUI modules, Dynamic Asset and Liabilities Management (ALM) and Liquidity Risk. • Detailed level of knowledge and experience working with: Focus database input DB, Focus DB, Results DB and Focus Cubes. • Senior SQL development skills for DB development and writing dynamic SQL (Microsoft SQL server). • Experience working with SSIS packages, complex ETL processes and scripting (command line, PowerShell, etc.). • Technical depth and breadth to work closely with internal systems (Summit, SAP and Numerix) and various teams. • A detailed oriented person with a general understanding of financial instruments, terminology and regulations (NSFR, LCR and IRRBB). • Experience in working with the AGILE methodology, Microsoft Application Lifecycle Management (TFS and Microsoft Project) is also a plus. • Understanding of the AfDB’s business, policy mandate and products, and ability to adapt to new or challenging situations. • Excellent organizational skills to work efficiently to achieve agreed-upon results and meet deadlines. • Excellent team player and ability to work with colleagues from diverse backgrounds. • Excellent written and communication skills.
H. Supervisor
The consultant will report to the FIFM1 Division Manager.
Consultancy Input Days
130.00
Qualifications
Qualification
Assessment
Regular Consultant
Less than 32 years old at the time of signing the contract and during contract execution
