PROFILE

An enthusiastic Database

Administrator and software developer

& with excellent communication and

time management skills.

ADRESS

KICUKIRO-NIBOYE

CONTACT

PHONE: +(250-*********

EMAIL:ad4p7j@r.postjobfree.com

GENDER

Male

DATE OF BIRTH

02/18/1985

MARITAL STATUS

Married

NATIONALITY

Rwandese

MUHIRWA

OLIVIER

SENIOR DATABASE ADMINISTRATOR

EDUCATION

Groupe Scolaire St Joseph (Kabgayi)

2003 - 2006

Obtained O-Level Certificate (Option Chemistry & Biology) Adventist University of Central Africa (A.U.C.A)

2006 - 2011

Obtained University Degree in Information Technology University of Colorado

I. Database Management Essentials Certificate

(September 20, 2020)

7 weeks of study, 4-6 hours/week

SKILLS GAINNED

Database (DB) Design, Entity–Relationship (E-R) Model, Database

(DBMS)

SQL

https://coursera.org/share/60fbd143a65666e76b5bc76f5f0dd521 II. Data Warehouse Concepts, Design, and Data Integration Certificate

(October 5, 2020)

SKILLS GAINNED: Extraction, Transformation and Loading (ETL) Pentaho, Data Integration, Data Warehouse

https://www.coursera.org/account/accomplishments/verify/T6ZJSG8F GVNX

III. Relational Database Support for Data Warehouses Certificate

(October 29, 2020)

SKILLS GAINNED: Data Warehousing, Materialized View, Data WarehouseSQL

https://www.coursera.org/account/accomplishments/verify/HXB656JR2 ZFT

LANGUAGES SPEAKING WRITING

English Good Good

French Excellent Excellent

Rwandese Very Fluent Excellent

Swahili Good _

REFERENCES

1. NZAMWITA Richard

Information Technology

Consulting and Software

Engineering Firm

(ALPHA SOFT).

Contact: 078*******

2. Eng. Alain Rutembesa

Management Lead

(Bank of Kigali)

Contact: 078*******

3. RUKUNDO Guillaume

Audit committee

&

IT committee

(COOPEDU PLC).

Contact:

Tel: +(250-*********;

Skype: rukundoguillaume

4. DUSHIMANA Grace

CEO

(Vision Fund Rwanda)

Contact: 078*******

I certify that all the information given

above is true, complete, correct and

given in good faith to the best of my

knowledge.

MUHIRWA Olivier

WORK EXPERIENCE

HOBUKA

June 2010- December 2011: Programming in PHP at HOBUKA Main Responsibilities:

- Develop, test and implement new software programs

- Clearly and regularly communicate with management and technical support colleagues

- Design and update software database. This includes, but is not limited to: Software Applications, Web Sites, Data Communication Processes and User Interfaces

- Test, maintain and recommend software improvements to ensure strong functionality and optimization

- Independently install, customize and integrate commercial software packages

- Facilitate root cause analysis of system issues

- Work with experienced team members to conduct root cause analysis of issues, review new and existing code and/or perform unit testing

- Identify ideas to improve system performance and impact availability

- Resolve complex technical design issues

- Development of technical specifications and plans

- Analyze user requirements and convert requirements to design documents

- Make good technical decisions that provide solutions to business challenges

- Provide comprehensive support to internal customers; achieve resolution to outstanding problems or issues

- Compile timely, comprehensive and accurate documentation and or reports as requested

- Possess up-to-date knowledge of technological developments in the industry

- Communicate effectively and professionally in all forms of communication with internal and external customers

- Possess strong problem solving and decision making skills while using good judgment

- Multi-task and change from one task to another without loss of efficiency or composure

Principal Achievements:

- Design and development of software management for pharmacies

- Tools: MySQL Server for Database

PHP as programming Language

Cristal Report for generating Reports

UMWALIMU SACCO (Savings and Credit Cooperative)

01/01/2012 up to 04/09/2019: Worked as:

- Database Administrator

Main Responsibilities:

- Modify databases according to requests, perform tests and solve database usage issues and malfunctions

- Work with developers in the design and development of new features in the existing core banking

- Work with developers in performing adequate unit and integration testing of in-house and vendors’ software and ensure all requirements have been addressed, all basic functionalities work, and errors are handled properly.

- Liaise with developers to improve applications and establish best practices

- Oversee backup, clustering, replication and failover;

- Monitor and Maintain High availability, Clustering, replication and failover

- Allocating system storage and planning future storage requirements for the database system

- Restore and recover corrupted databases;

- Analyse, consolidate and tune database for optimal efficiency;

- Analyse and sustain capacity and performance requirements;

- Monitoring and tuning performance systems and platforms for availability;

- Install and test upgrades and patches; and Provide support anytime needed.

- Manage user access rights to the institution’s applications and Information Systems to ensure that all inputs are made by appropriately trained and authorized staff;

- Install, patch and maintain all UMWALIMU SACCO databases;

- Implement security standards to ensure confidentiality, availability and integrity of data;

- Work with ISO to design and implement standards to secure data and access

- Work with developers to properly configure and tune databases for maximum performance;

- Work closely with the Systems Administrator to install applications to improve DBMS performance;

- Implement data recovery standards and procedures and stipulated in UMWALIMU SACCO’s Business Continuity;

- Making database backups and performing recovery when necessary;

- Generating various reports by querying from database as per need

- Managing (Alpha core Banking DB, Clearing app DB, EDWH DB)

- User support on the business applications running within Umwalimu SACCO (Alpha Bank, Clearing, Mobile banking, etc..) and performing EOD

To perform any other duties as may be assigned by the Director of the Department

Principal Achievements:

- Administration of Alpha bank software developed in Razor project and SQL Server 2014, Alpha bank has 4 Modules:

- Credits

- Operations

- Accounting

- Contribution on the development of Core Banking System Upgrade From Silverlight to Razor Pages

04/09/2019 – Dec/2020

NIRDA (National Industrial research and Development Agency) Appointment: Database and Application Administrator Duties and responsibilities:

Duties and responsibilities:

– Build database scheme, tables, procedures and permissions;

– Meeting with development managers to discuss the scope of software projects.

–Work closely with Vendor on designing, development and Implementation of Laboratory Information Management System (LIMS)

– Analysing existing programs for modification purposes;

– Develop database utilities and automated reporting

– Create shell scripts for task automation;

– Create, test and execute data management languages; Analyse and sustain capacity and performance requirements of database;

– Analyse, consolidate and tune database for optimal efficiency;

– Monitor systems and platforms for availability;

– Monitor and Maintain High availability, Clustering, replication and failover;

– Perform backups, Restore and recover corrupted databases;

– Implement security and encryption;

– Evaluate and recommend new database technologies;

– Design and document database architecture and Data Modelling. Achievements:

- Design and development of IT Equipment Management Software in ASP.NET Core Razor Pages with SQL Server 2014

- Design and development of Open Call Portal developed in: Framework: Play

Play version: 2.3.8

Programming language: JAVA

UI Programming language: Scala, HTML5, JQuery

(JavaScript), Bootstrap 3

Database: MySQL 5.7

Report: IText Report

Structure: MVC

Passwords are encrypted using md5

- Management of Project Management portal developed in : Database: MySQL 5.7

Framework: Spring Boot

Spring Boot version: 1.5.9

Programming language: JAVA

UI Programming language: Thyme leaf, HTML5, JQuery

(JavaScript), Bootstrap 3

Report: IText Report

01/12/2021 up to now:

VFR (Vision Finance Rwanda)

- Appointment: Senior Database Administrator,

- Acting Head Of Information Technology

Duties and responsibilities:

- Controlling and monitoring user access to the database

- Researching and designing new software systems, websites, programs, and applications.

- System Integration with external application.

- Supports applications with an understanding of system integration,API developpement, test planning, scripting, and troubleshooting.

- Recommending and executing program improvements.

- Maintaining software code and security systems.

- Enrolling users and maintaining system security

- backing up and restoring all databases (Mobile Banking, Core Banking System and BNR Data ware House)

- Daily monitoring of database replications and ensures data’s are updated both at HQ standby and DR site

- Ensure Mobile Banking Application is up and running

- Ensuring BNR Database and the tool that replicates with the oracle database are in sync and have real-time data and Readiness Flag is set to Y

- Ensuring Standby BNR Database at the DR Site and the tool that replicates with the oracle database are in sync and have realtime data and Readiness Flag is set to Y

- Ensuring BNR EDWH have sent daily extraction summary alert of the previous day plus the end month

- Ensuring DR Site Report Server contains real time report templates

- Monitoring performance of our core banking application and managing parameters to provide fast responses to front-end users;

- Ensure systems and reporting structures provide appropriate portfolio and impact information and performance outputs to all levels of management;

- Investigate and analyse system imbalance and advise on the corrective action;

- Provides technical support to branches and all departments on time. Ensure all issues channelled through our helpdesk ticket system are responded and all pending tickets are closed by user upon satisfaction of the services rendered

- Perform trainings to end users on new system and reports where necessary

- Apply licenses to banking systems when new licenses are acquired;

- Allocating system storage and planning future storage requirements for the database system;

- Installing and testing new versions of the DBMS;

- Writing database documentation, including data standards and procedures;

- Controlling access permissions and privileges;

- Monthly reviewing of User access rights to the System and revoke where necessary by consulting HOIT and document by filing

- Working closely with VFR IT team to ensure good collaboration;

- communicating regularly with technical, applications and operational staff to ensure database integrity and security;

- commissioning and installing new applications and customizing existing applications in order to make them fit for purpose;

- Work Closely with the Core Banking Vendor and consultants for new application integrity;

- Perform end financial activities (daily EOD and EOY) regularly;

- Document daily EOD as per the template and file

- Share every Monday the listing of all activities performed of the previous week

- Documenting and communicating database errors logs or any other issue raised by business in case is not able to be fixed internally to the Vendor through JIRA ticketing system http://www.neptunesupport.com/secure/MyJiraHome.jspa ;

- Generating various reports by querying from database as per need;

- Developing and automating reports as per the business requests.

- Full daily Mobile Banking support to the clients by troubleshooting and analysing the error given and working with MNOs where necessary

- Dual control on how users are registered in the system by checking charge account, account mapped and the validity of the phone numbers and share weekly report to Head of Operation and copy IT

- Handling all other Mobile banking tasks raised

- Broadcasting (Message) to clients to advertise M-hano.

- Perform daily backup (EOD dumps) on Tapes and take them offsite to World Vision Rwanda Safe Room as per IT policy.

- Perform once in a month Backup Tape restore and document by filing

- Daily Monitoring of the server room

- Perform monthly backup of Helpdesk System

- Mastering of CRB reconciliation and how it works and provide support to Operation as requested.

- Mastering the daily reconciliation of Mobile Banking with MNO's how it is done

- Mastering IT policy and Business Continuity Plan package

- Mastering IP addressing of all branches

- Keep and maintain IT store room

- Mastering WebLogic administration and Data guard

- Mastering MIS workflow and able to direct MIS officer as per the workflow

- Mastering Savings workflow and able to direct Banking staff as per the workflow

- Mastering all VFR Products, Authorization Limits and Tariffs

- Review all Business Role Units and ensures each department have the right business role as per their Job description

- Report Completion of end month by Product, by Loan Officer, monthly Expected report, Aging and Trend Report and share to management and Operation on time

- Ensure End month VFI Reports are shared to Finance

- Ensure every 5th of the following month CRB report (both Groups and Individuals) are shared to FINANCE Staff in charge of CRB

- Ensure every 1rd of the following month Bankbi report are extracted and uploaded to https://www.bankbiapp.com

- Ensure Daily EOD Reports are sent to the business before start of the day

- Read and get a deep understanding of banking operation as per Operation and Savings manual

- Read and get deep understanding of Finance operation as per Finance manual

- Read and get deep understanding of Oracle Database 12c structures and ensure it is well mastered

- Read and get deep understanding of all existing VFR automated reports, Oracle Views and Procedures and ensure they are all mastered

- Perform daily System administration of all production Servers and ensure are in good state and up running

- Read and get deep understanding of Suse Linux to better administer production servers as they are running on suse enterprise OS

- Perform daily system monitoring, verifying the integrity and availability of all Servers including DR Site,Network Attached Storage, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups

- Perform weekly backup of Mobile Banking logs on Tapes and take them offsite to WVR safe room

- Create, change, review and delete user accounts per request and in reference to IT policy.

- Perform any Other tasks assigned by hierarchical supervisor. Achievements:

- Ensured that systems and reporting structures provided appropriate portfolio and impact information and performance outputs to all levels of management

- Provide Appropriate right to the users

- Perfomed Daily End of Day (EOD) and End Year Closer (EOY) on time and generated financials that are not misleading

- Provided technical support to branches and all departments on time. all issues have been channelled through our helpdesk ticket system are responded and all tickets were closed by user upon satisfaction of the services rendered

- I have ameliorated BNR Database Replication performance

- BNR EDWH reporting is now stable Daily and Monthly report

- Integration of ODK for capturing group loans request via mobile phone, KYC data, photos and GPS locations.

[ ODK Usage ]

1. Client visit/engagement survey: This survey is done at EVERY client contact

2. Group Verification Test

The screening – it contains several parts such as the eligibility test, group quality test, group recognition test, borrowing wisely test, loan management-training test

3. and 4. Loan application and KYC

These are 2 forms, but are done at the same meeting. This captures all the loan information and KYC, pictures of signed loan contract etc… 5. BM/Manager verification Test

Physical verification visit done by BM or supervisor to verify all the above, plus the existence of the group

- Integration of NIDA portal:

- as per the API are populating from NIDA and synchronized in the VFR Orbit-R related fields:

- CivilStatus

- DocumentNumber(NID)

- Sex

- Photo

- Nationality

- ForeName

- Surnames

- Village

- Cell

- Sector

- District

- Province

- DateOfBirth

- DocumentTyp(NID)

- Mobile Telephone Number

- INTEGRATION OF RWANDA INTEGRATED PAYMENT PROCESSING SYSTEM (RIPPS) Whith Vision Fund Rwanda

SKILLS

Operating System

Database Application

Programming languages

Reporting

50%

75%

0.00% 25.00% 50.00% 75.00% 100.00%

LINUX

MS Win Server 2012

40%

93

70%

95%

0.00% 25.00% 50.00% 75.00% 100.00%

NoSql server

Oracle

MySql

SQL Server

70%

100%

25%

75%

0.00% 25.00% 50.00% 75.00% 100.00%

SILVER LIGHT

ASP.NET Core

Angular JS

PHP

85

80

60

0.00% 25.00% 50.00% 75.00% 100.00%

SqL Server Server Reporting

Services (BI)

SAP Cristal Report

Excel

Contact this candidate