Providing business consultancy for FlexCube Retail FCR core bank system with full understanding of the back end database for such products like CASA (Current Accounts/Saving Accounts), Deposits (Term Deposit/ Certificates of Deposit), Credits (Loans/Overdrafts/Collections)
Responsible for many Data Migration project and building and using ETL tools SSIS, DTS, and SQL scripts
Providing suggestions on alternate technical solutions to meet client requirements more efficiently
Handling the communication between the bank and the vendor regarding the open issues and fixes
Executing test scenarios and test scripts and making necessary changes in the projects to meet requirements
Interacting with the SME’s and Stakeholders to get a better understanding of client business processes and gather business requirements, and helping in defining business case.
Performing object oriented analysis and design and developed workflow diagrams using MS Visio.
Utilizing UML methodology to prepare Use Case Models, Flow Charts, Activity Diagrams using MS Visio
Documenting and explaining complex business operations to software developers
Assisting junior developers by assigning tasks, monitoring performance, and ensuring quality of deliverables.
Ensure all projects are delivered with good quality, meeting user requirements, on time and within budget.
Writing Deployment Plans, User Guide, Technical Documentations and other reports
Achievements:
Bank Data Warehouse: Project Leader for building and maintain complete Data Warehouse (ETL, Staging, and Data Marts) for Banking and Operations business areas with clear simplified results to business users.
Egabi Reporting System: Project leader for implementing this generic system to automate all bank reports whether required by Central Bank or not, extracting bank data from different sources (Retail, Corporate, Credit Cards) and representing data in unified and business oriented.
E-Service System: Lead development of E-Service intranet framework to serve all bank’s staff to automate many daily business areas
Data Retention Model: Designed complete solution with proper interface to keep the historical data of the DWH against agreed policies.
Reuters Support Application: Lead development of application to support and help the treasury department in their daily work operations; balancing and managing the daily cash flow and liquidity of funds, handling investments, foreign exchange, asset/liability management and cash instruments.
Data Verification Process: Built model to verify the uploaded data in DWH against the source data in old core bank system, giving final status and validate the data before dependent reports generation.
Modbank DWH Data Dictionary: Designed and documented centralized repository of information about DWH database, including data modeling, RDBMS, data types, default values, access rights, brief textual description, integrity constraint and other general database information.
Trade Finance Migration: Designed solution to migrate TF system data and functionalities from old core bank system to third party application. The system covers customer/banks information, customer accounts(Current/Saving/Overdraft), bank accounts (Nostro/Vostro), LGs (Local/ Foreign), LCs (Import/Export), BCs (Import/Export), Cash Cover information for LGs, LCs and BCs, Collateral Time Deposits.
Barclays Africa Reports/Extracts: Designed financial reports such as Average balances, Daily balances, EOM closing position, GL Income Movements, Loans, and TDs.
- Company industry:
- Banking
- Job role:
-
Information Technology