Software Developer Information Technology Senior DDBA
Resume:
PROFILE
An enthusiastic Database
Administrator and software developer
& with excellent communication and
time management skills.
ADRESS
KICUKIRO-NIBOYE
CONTACT
PHONE: +(250-*********
EMAIL:***********@*****.***
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