VICTOR ODHIAMBO

• Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Created data analysis tools to allow teams to query acquired information for unique details.
• Collected data from wide-ranging sources.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Translated technical concepts and information into terms parties could easily comprehend.
• Built databases and table structures for web applications.
• 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 data pipelines to acquire, clean and process data.
• Created dashboards to monitor and track key performance indicators.

• Test Planning and Strategy: Develop comprehensive test plans and strategies tailored to the Finacle core banking system, ensuring all functionalities are thoroughly tested.
• Test Case Development: Create detailed test cases based on system specifications and requirements, covering various scenarios including functional, regression, performance, and usability testing.
• Test Execution: Execute manual and automated test cases, meticulously documenting results and identifying defects or issues.
• Defect Management: Log, track, and manage defects using appropriate tools, collaborating with development teams to ensure timely resolution.
• Customization Testing: Test and validate 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.
• Compliance Testing: Ensure that all changes and customizations comply with regulatory and compliance standards relevant to the banking industry.
• Performance Testing: Conduct performance testing to evaluate the system's responsiveness, stability, and scalability under various load conditions.
• User Acceptance Testing (UAT): Coordinate and support UAT activities, working closely with end-users to validate that the system meets their needs and expectations.
• Documentation: Maintain comprehensive documentation of test plans, test cases, test results, and defect reports, ensuring clear communication with stakeholders.
• Continuous Improvement: Identify areas for improvement in the testing process and implement best practices to enhance the overall quality assurance process.
• Collaboration: Work closely with cross-functional teams, including developers, business analysts, and project managers, to ensure seamless integration and delivery of high-quality software.
• Post-Implementation Support: Provide support during the post-implementation phase, addressing any issues that arise and ensuring a smooth transition to production

ACHIEVEMENTS

• Successfully Implemented Finacle Core Banking System in South Sudan: Led the testing and quality assurance efforts for the implementation of the Finacle core banking system in South Sudan, ensuring a smooth and error-free transition.
• Efficient Finacle Patching: Executed and managed 2 patching updates for the Finacle system, significantly reducing downtime and enhancing system stability and performance.
• Customized Cash Services Module: Developed and tested over 50 customizations for the Finacle cash services module, optimizing transaction processing and improving operational efficiency.
• Enhanced Account Opening Module: Spearheaded the customization and testing of the account opening module, resulting in a more user-friendly interface and faster account setup times.
• Introduced New Scheme Codes for Loan Products: Successfully created and tested 5 new scheme codes to support a variety of loan products, expanding the bank’s service offerings and increasing customer satisfaction.

• 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.
• 1. Successfully scripted 33 bank datasets into the required CBK reporting standards using Oracle SQL Developer tool and other data modelling tools, such as Excel.
• 2.Designed and implemented robust data models to support CBK analytics and reporting requirements. 3.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.
• 4. 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.
• 5. Implemented best practices for bank data transformation and cleansing to ensure data integrity and reliability for onward submission to the Central Bank of Kenya.
• 6.Tested the 33 APIs created using SoapUI, and ensured that data submitted by the bank is successfully received on the CBK server.
• 7. Analyzed data collated in manual form from various business streams, and ensured that it complied with the standardized CBK data template form regarding columns and data type.
• 8. Utilized business intelligence tools such as Oracle SQL Developer and Excel to analyze data collated from various business streams, ensuring it complied with the standardized CBK data template regarding columns and data types.
• 9.Supported the technical mapping of bank data to the CBK data integration template to achieve data alignment, focusing on data types, columns, and rows.
• 10.Supported the creation of SQL stored procedures, as well as the building of the data pipeline from the warehouse to various staging phases.

• Log Analysis for Finacle: Monitored and analyzed system logs specifically within the Finacle core banking system to identify and troubleshoot user and system errors.
• Database Querying for Finacle: Perform complex queries on various Finacle tables to support operations related to cash services, account opening, loan modules, treasury, and payment processes.
• Finacle User Support: Provide prompt and effective support to end-users by addressing their technical issues, queries, and concerns related to the Finacle system.
• Finacle Incident Management: 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.
• Finacle System Maintenance: Assisted in the maintenance and administration of the Finacle system, including regular patching, updates, and performance tuning to ensure optimal system performance.
• Customization Support for Finacle: Supported the testing and deployment of customizations and enhancements within the Finacle system, ensuring they meet business requirements and do not impact existing functionalities.
• Compliance and Security in Finacle: Ensured that all system changes and activities within Finacle adhered to regulatory, compliance, and security standards relevant to the banking industry.
• Finacle Documentation: Maintained comprehensive documentation of support activities within the Finacle system, including issue logs, resolutions, and user guides to facilitate knowledge sharing and continuous improvement.
• Collaboration with Finacle Teams: Worked closely with cross-functional teams, including IT, development, and business units, to ensure effective communication and coordination in resolving issues and implementing changes within the Finacle system.
• Finacle Training and Guidance: 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.
• FINRPT Management for Finacle: Managed and supported FINRPT (Finacle Report) services, including the creation, customization, and troubleshooting of various reports to meet business requirements.
• API Management in Finacle: Handled the integration and management of APIs within the Finacle system, ensuring seamless communication and data exchange between different modules and external systems.
• Performance Optimization for Finacle: Identified and implement performance optimization strategies for various Finacle services, enhancing system efficiency and user experience.
• Finacle Automation: Developed and implemented automation scripts within the Finacle system to streamline routine tasks and improve system reliability and accuracy.
• Backup and Recovery in Finacle: Ensured the proper implementation of backup and recovery processes within the Finacle system to protect critical data and ensure business continuity in case of system failures.
• Finacle Version Upgrades: Assisted in planning and executing Finacle version upgrades, ensuring minimal disruption to business operations and validating system compatibility with existing customizations.

Requirement Gathering and Solution Architecturing: Testing in SIT/UAT/Dress Rehearsal: User Training: Data Migration: Branch Support in Dress Rehearsal: Achievements

• Requirement Elicitation: Worked closely with stakeholders to gather and document detailed business requirements for the new Finacle core banking system.
• Solution Design: 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.
• Gap Analysis: Performed gap analysis to identify discrepancies between current processes and the desired state, recommending solutions to bridge these gaps.
• Stakeholder Collaboration: Collaborated with business units, IT teams, and vendors to ensure clear communication and alignment on project objectives and requirements.
• Prototyping: Created prototypes and mock-ups to visualize and validate proposed solutions with stakeholders.
• System Integration Testing (SIT): 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.
• User Acceptance Testing (UAT): Coordinated and support User Acceptance Testing (UAT), working closely with end-users to validate that the system meets their needs and expectations.
• Dress Rehearsal Testing: 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.
• Defect Management: Identified, logged, and tracked defects discovered during testing phases, collaborating with development teams to ensure timely resolution.
• Training Needs Assessment: Identified training needs for end-users based on new functionalities and processes introduced by the Finacle system.
• Training Materials Development: Developed comprehensive training materials, including user manuals, guides, and online resources, to support end-user training.
• Training Delivery: Conducted training sessions for end-users, ensuring they are well-equipped to use the new Finacle system effectively.
• Data Mapping and Transformation: Developed data mapping and transformation rules to migrate data from legacy systems to the new Finacle core banking system.
• Data Migration Testing: Perform thorough testing of data migration processes to ensure data accuracy, consistency, and integrity in the new system.
• Migration Rollout Planning: Assist in planning and executing data migration rollouts, ensuring minimal disruption to business operations.
• Branch Readiness Assessment: Assessed the readiness of branch operations for the new Finacle system, identifying any potential issues or areas for improvement.
• On-Site Support: 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.
• Successful Go-Live of Kenya Core Banking Project: Led the successful go-live of the Finacle core banking project in Kenya, ensuring a smooth transition and minimal disruptions to banking operations.
• Trained Over 5,000 Bank Staff: 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.
• Six Successful Dress Rehearsals: Planned and executed six successful dress rehearsal sessions, ensuring the system was thoroughly tested and ready for go-live.
• Six Successful Data Migration Activities: Conducted and validated six successful data migration activities, ensuring data accuracy, consistency, and integrity in the new Finacle core banking system.

Cash Operations: ATM Custody: Account Opening:

Roles and Responsibilities

• Teller Operations: Oversee and manage teller operations, ensuring accurate and efficient processing of cash transactions, including deposits, withdrawals, and cash transfers.
• Cash Handling: Ensure proper handling, counting, and reconciliation of cash, maintaining accurate records and adhering to cash handling policies and procedures.
• Cash Vault Management: Manage the cash vault, ensuring adequate cash levels are maintained and security protocols are followed.
• ATM Management: Oversee the management and maintenance of ATMs, ensuring they are operational, stocked with cash, and secure.
• ATM Reconciliation: Perform regular reconciliation of ATM transactions, addressing any discrepancies and ensuring accurate records.
• ATM Issue Resolution: Address and resolve any issues related to ATM operations, including technical malfunctions and customer complaints.
• Account Opening Process: Manage the account opening process, ensuring all required documentation is collected, verified, and accurately recorded.
• Customer Verification: Conduct customer verification and due diligence to ensure compliance with regulatory requirements and prevent fraud.
• Account Maintenance: Oversee the maintenance of customer accounts, including updates to account information and resolution of any account-related issues.

Roles and Responsibilities

• Teller Operations: Oversee and manage teller operations, ensuring accurate and efficient processing of cash transactions, including deposits, withdrawals, and cash transfers.
• Cash Handling: Ensure proper handling, counting, and reconciliation of cash, maintaining accurate records and adhering to cash handling policies and procedures.
• Cash Vault Management: Manage the cash vault, ensuring adequate cash levels are maintained and security protocols are followed.

• ATM Management: Oversee the management and maintenance of ATMs, ensuring they are operational, stocked with cash, and secure.
• ATM Reconciliation: Perform regular reconciliation of ATM transactions, addressing any discrepancies and ensuring accurate records.
• ATM Issue Resolution: Address and resolve any issues related to ATM operations, including technical malfunctions and customer complaints.

• Account Opening Process: Manage the account opening process, ensuring all required documentation is collected, verified, and accurately recorded.
• Customer Verification: Conduct customer verification and due diligence to ensure compliance with regulatory requirements and prevent fraud.
• Account Maintenance: Oversee the maintenance of customer accounts, including updates to account information and resolution of any account-related issues.