Victor Odhiambo
Nairobi
Summary
Dynamic Business Intelligence Analyst with proven expertise at The Co-operative Bank of Kenya, skilled in Testing, Oracle SQL Developer and ETL development. Successfully designed dashboards and reports that enhanced decision-making. Adept at collaborating with cross-functional teams, ensuring high-quality deliverables while fostering a culture of continuous improvement. Passionate about leveraging data for impactful insights.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst/Developer
The Co-operative Bank of Kenya
Nairobi
03.2025 - Current
- Supporting user data and analytical requirements for decision making by scripting complex SQL queries using Oracle SQL Developer
- Monitoring of data loads on a daily basis in the warehouse and ensuring data records in both source and target tables is in sync
- Developed intelligence-sharing dashboards, providing company-wide access for transactions, loans, and account processes
- Evaluation of use cases for decision making in the bank through data analysis using Oracle SQL developer
- Worked closely with clients to gather requirements and translate them into technical specifications for implementation
- Developed customized reports, summarizing and presenting data in visually appealing format
- Designed and developed ETL processes to acquire, clean and process data to support data analysis and reporting for the bank
- Created dashboards to monitor and track key performance indicators
Test Analyst
The Co-operative Bank of Kenya
Nairobi
11.2023 - 02.2025
- Developed comprehensive test plans and strategies tailored to the Finacle core banking system, ensuring all functionalities are thoroughly tested
- Created detailed test cases based on system specifications and requirements, covering various scenarios including functional, regression, performance, and usability testing
- Executed manual and automated test cases, meticulously documenting results and identifying defects or issues
- Logged, tracked, and managed defects using appropriate tools, collaborating with development teams to ensure timely resolution
- Tested and validated customizations and changes made to the Finacle core banking system on various modules Core, SSO, CRM and FININFRA, ensuring they meet client requirements and do not impact existing functionalities
- Coordinated and supported UAT activities, working closely with end-users to validate that the system meets their needs and expectations
- Maintained comprehensive documentation of test plans, test cases, test results, and defect reports, ensuring clear communication with stakeholders
- Identified areas for improvement in the testing process and implement best practices to enhance the overall quality assurance process
- Worked closely with cross-functional teams, including developers, business analysts, and project managers, to ensure seamless integration and delivery of high-quality software
- Provided support during the post-implementation phase, addressing any issues that arise and ensuring a smooth transition to production
Quality Analyst-Central Bank of Kenya GDI Project
The Co-operative Bank of Kenya
Nairobi
04.2024 - 10.2024
- The project focused on using secure APIs to enable near-real-time collection of granular data from commercial banks, telcos, and other supervised financial institutions (SFIs) to the Central Bank of Kenya
- Successfully scripted 5 bank datasets into the required CBK reporting standards using Oracle SQL Developer tool and other data modelling tools, such as Excel
- Developed and maintained scalable ETL processes from various sources, including multiple peripheral systems, into a data warehouse, and subsequent submission of data to CBK via APIs
- Developed, maintained, and improved the pipelines into the data analytics platform using procedural SQL, ETL, data virtualization, and databases
- Reviewed process, architectural, information, and data models in collaboration with the Data Architect, Data Engineers, and the rest of the Business Intelligence team
- Tested the 33 APIs created using SoapUI, and ensured that data submitted by the bank is successfully received on the CBK server
- Supported the creation of SQL stored procedures, as well as the building of the data pipeline from the warehouse to various staging phases
Finacle Support Officer
The Co-operative Bank of Kenya
Nairobi
06.2023 - 10.2023
- Monitored and analyzed system logs specifically within the Finacle core banking system to identify and troubleshoot user and system errors
- Performed complex queries on various Finacle tables to support operations related to cash services, account opening, loan modules, treasury, and payment processes
- Provided prompt and effective support to end-users by addressing their technical issues, queries, and concerns related to the Finacle system
- Logged, tracked, and resolved incidents and service requests within the Finacle system, ensuring minimal disruption to business operations and maintaining high levels of user satisfaction
- Supported the testing and deployment of customizations and enhancements within the Finacle system, ensuring they meet business requirements and do not impact existing functionalities
- Provided training and guidance to end-users on the effective use of the Finacle system, helping them to utilize its features and functionalities to their full potential
- Developed and implemented automation scripts within the Finacle system to streamline routine tasks and improve system reliability and accuracy
- Assisted in planning and executing Finacle version upgrades, ensuring minimal disruption to business operations and validating system compatibility with existing customizations
Finacle Tester/SME/Business Analyst
The Co-operative Bank of Kenya
Nairobi
01.2022 - 05.2023
- Worked closely with stakeholders to gather and document detailed business requirements for the new Finacle core banking system
- Developed comprehensive solution architectures and design documents that address business needs and align with the capabilities of the Finacle system such as the cash movement processes for branches/head office
- Performed gap analysis to identify discrepancies between current processes and the desired state, recommending solutions to bridge these gaps
- Developed and execute detailed test plans and test cases for System Integration Testing (SIT) to ensure that all components of the Finacle system work seamlessly together
- Coordinated and support User Acceptance Testing (UAT), working closely with end-users to validate that the system meets their needs and expectations
- Planned and conducted dress rehearsal testing to simulate real-world scenarios and ensure the system is ready for go-live, including end-to-end testing of all functionalities
- Identified, logged, and tracked defects discovered during testing phases, collaborating with development teams to ensure timely resolution
- Performed thorough testing of data migration processes to ensure data accuracy, consistency, and integrity in the new system
- Provided on-site support during dress rehearsal and go-live phases to assist branch staff with any issues or queries related to the new system
- Led the successful go-live of the Finacle core banking project in Kenya, ensuring a smooth transition and minimal disruptions to banking operations
- Successfully conducted training sessions for over 5,000 bank staff, equipping them with the necessary skills and knowledge to use the new Finacle system effectively
Officer - Cash Operations
The Co-operative Bank of Kenya
Homa Bay
04.2018 - 12.2021
- Oversee and manage teller operations, ensuring accurate and efficient processing of cash transactions, including deposits, withdrawals, and cash transfers
- Ensure proper handling, counting, and reconciliation of cash, maintaining accurate records and adhering to cash handling policies and procedures
- Manage the cash vault, ensuring adequate cash levels are maintained and security protocols are followed
- Oversee the management and maintenance of ATMs, ensuring they are operational, stocked with cash, and secure
- Perform regular reconciliation of ATM transactions, addressing any discrepancies and ensuring accurate records
- Address and resolve any issues related to ATM operations, including technical malfunctions and customer complaints
- Manage the account opening process, ensuring all required documentation is collected, verified, and accurately recorded
- Conduct customer verification and due diligence to ensure compliance with regulatory requirements and prevent fraud
- Oversee the maintenance of customer accounts, including updates to account information and resolution of any account-related issues
Officer - Operations
Equity Bank Kenya Limited
Migori
09.2014 - 10.2016
- Oversee and manage teller operations, ensuring accurate and efficient processing of cash transactions, including deposits, withdrawals, and cash transfers
- Ensure proper handling, counting, and reconciliation of cash, maintaining accurate records and adhering to cash handling policies and procedures
- Manage the cash vault, ensuring adequate cash levels are maintained and security protocols are followed
- Oversee the management and maintenance of ATMs, ensuring they are operational, stocked with cash, and secure
- Perform regular reconciliation of ATM transactions, addressing any discrepancies and ensuring accurate records
- Address and resolve any issues related to ATM operations, including technical malfunctions and customer complaints
- Manage the account opening process, ensuring all required documentation is collected, verified, and accurately recorded
- Conduct customer verification and due diligence to ensure compliance with regulatory requirements and prevent fraud
- Oversee the maintenance of customer accounts, including updates to account information and resolution of any account-related issues
Education
Data Science - Machine Learning, Python, SQL
Datamites Global Institute For Data Science
Bangalore10.2024
Bachelor of Arts - Economics
University of Nairobi
Nairobi12.2014
High School Diploma -
Mangu High School
Kiambu11.2008
Python Developer Course -
Datamites Global Institute For Data Science
BangaloreSkills
- Oracle SQL Developer
- Linux scripting
- Finacle Core Banking modules
- Python programming
- SoapUI
- Postman
- Automation
- Selenium
- Debugging
- ETL development
Certification
- Certificate in Data Science from Datamites Global Institute for Data Science.
- Certificate in Python programming from Datamites Global Institute for Data Science.
- Certificate in Oracle SQL Developer from Udemy.
- Certificate in Python programming from Code with Mosh.
- Certificate in Database Management Systems from Udemy.
References
References available upon request.
Timeline
Business Intelligence Analyst/Developer
The Co-operative Bank of Kenya
03.2025 - Current
Quality Analyst-Central Bank of Kenya GDI Project
The Co-operative Bank of Kenya
04.2024 - 10.2024
Test Analyst
The Co-operative Bank of Kenya
11.2023 - 02.2025
Finacle Support Officer
The Co-operative Bank of Kenya
06.2023 - 10.2023
Finacle Tester/SME/Business Analyst
The Co-operative Bank of Kenya
01.2022 - 05.2023
Officer - Cash Operations
The Co-operative Bank of Kenya
04.2018 - 12.2021
Officer - Operations
Equity Bank Kenya Limited
09.2014 - 10.2016
Data Science - Machine Learning, Python, SQL
Datamites Global Institute For Data Science
Bachelor of Arts - Economics
University of Nairobi
High School Diploma -
Mangu High School
Python Developer Course -
Datamites Global Institute For Data Science
Similar Profiles
LAGAT STEPHEN KIPKOSGEILAGAT STEPHEN KIPKOSGEI
Regional channel manager at Co-operative Bank of KenyaRegional channel manager at Co-operative Bank of Kenya
Magdalene Wang’ombeMagdalene Wang’ombe
SPACE & CONTRACTS OFFICER at CO-OPERATIVE BANK OF KENYASPACE & CONTRACTS OFFICER at CO-OPERATIVE BANK OF KENYA
ANGELA R.A. MUGAANGELA R.A. MUGA
Sector Head- Education, Health, and Financial Inst at CO-OPERATIVE BANK OF KENYASector Head- Education, Health, and Financial Inst at CO-OPERATIVE BANK OF KENYA