ISAAC M. MUNTHALI
Chichiri, BLANTYRE
Summary
A seasoned Databases, Data Analyst and Business Intelligence Professional with vast experience in supporting Oracle/PostgreSQL/MySQL database, IT project management with Exceptional analytical skills.
Overview
9
9
years of professional experience
Work History
Prepaid Billing Specialist
TNM
11.2019 - 09.2023
- Developing and supporting adhoc applications for use by stake holders within billing section and customer service sections.
- Documenting of all system/architecture/service changes and standard Operating Procedures.
- Overseeing and being part of solution roll out across TNM Network both on Production platform and the disaster recovery sites.
- Monitoring and maintaining data quality, ensuring accuracy, completeness, consistency of the data and adhere to data governance and privacy standards to protect sensitive information.
- Disaster Recovery planning, execution and testing through Performing Geographical Data Redundancy (GDR) Operations and tests to ensure data consistency between primary servers and Disaster recovery sites so that there should be minimum impact in case of failure on primary server.
- Monitoring database performance and performing database tuning for fast response in case of slow database response.
- Collaborate with commercial and business teams to understand their reporting requirements and goals for data analysis and translating data-driven insights into actionable recommendations that support strategic decisions.
- Conduct Routine Backups and Restore Procedures and Test restore process to ensure backup integrity using both RMAN and Physical Backups.
- System Administration of the Post-Paid and Prepaid Linux/Unix Billing Platform.
- Installing and configuring of the system updates, patches and Linux/Unix system/Operating system for all mission critical Billing systems.
- Configuring new and existing prepaid and postpaid products.
- Integrating third party applications with the convergent billing system using web service and other protocols.
- Developing Standard Operating Procedures for routine and risky business processes and documenting all changes made in the system.
- Automating tasks that are done in bulk such as subscriber creation and allocation prepaid and postpaid products.
IDD & MIS Analyst
TNM
09.2018 - 10.2019
- Understanding reporting requirements and translating them into solutions in form of reports and dashboards.
- Production of reports for performance measurement of various products.
- Churn analysis.
- Providing support and administration of the MIS platform.
- Analyzing business information to identify process improvements for increasing business efficiency and effectiveness.
- Analyzing and Data mining of subscribers’ usage and subscription pattern reports from prepaid and post-paid billing systems.
- Generating and distributing management reports in accurate and timely manner.
- Providing reporting and analytical information support to management.
- Business intelligence.
Solutions Architect
Airtel Malawi
03.2017 - 08.2018
- Maintenance and administration of Linux and UNIX operating systems for Products and Promo System
- Administration, designing, coding, testing and supporting of system databases (Oracle, Informix, MSSQL and MySQL) for OCS, AAA, and Vxview
- Conduct systems OS & DB updates, patching, and housekeeping
- Monitoring database performance and performing database tuning for fast response in case of slow database response
- Managing capacity for the systems and databases by adding resources such as Disk storage(ASM) and Memory
- Conduct Routine Backups and Restore Procedures and Test restore process to ensure backup integrity using both RMAN and Physical Backups
- Ensure data integrity in terms of the billing systems i.e Ensuring that all CDRS are rated reloading in case of loading or rating failure
- Developing/writing Bash/Perl/PHP/java scripts to perform daily health checks and daily backup of system configuration settings and generating reports for all VAS and billing KPI’s
- Shell Scripting/Cron Jobs with Redhut Enterprise Linux, Orale Enterprise Linux and Cent OS
- Perform Database refresh and Rebuilt
- Integrating with other Systems such as Airtel Money, Smart swap AOC, kutchova,Kutapa and Ericson’s Air
- Developing Data Bundles and device bundles using Json scripts for newly activated bundles as requested by marketing team
- Troubleshooting Existing and new products and promo Issues as raised by customer service and Marketing Teams and resolving them as soon as possible
- Generating RCA (route cause analysis) report in case of any Issues such as subscribers being deducted airtime and not getting their Bundles, being deducted Airtime while they have an active bundle.
SENIOR INTELLIGENT NETWORK AND VALUE, SERVICE ENGINEER
ACCESS COMMUNICATIONS LIMITED
08.2014 - 03.2017
- Spearheaded and led administration of the Huawei Online Charging System (OCS), AAA, and Vx-view billing system and systems integration
- Oversaw Administration, designing, coding, testing and supporting of system databases (Oracle, Informix, MSSQL and MySQL) for OCS, AAA, and Vxview.
- Prioritized simultaneous projects to perform effectively under shifting deadlines in fast-paced environment.
- Conduct systems OS & DB updates, patching, and housekeeping.
- Monitoring database performance and performing database tuning for fast response in case of slow database response.
- Managing capacity for the systems and databases by adding resources such as Disk storage(ASM) and Memory.
- Conduct Routine Backups and Restore Procedures and Test restore process to ensure backup integrity using both RMAN and Physical Backups.
- Ensure data integrity in terms of the billing systems i.e Ensuring that all CDRS are rated reloading in case of loading or rating failure.
- Developing/writing Bash/Perl/PHP/java scripts to perform daily health checks and daily backup of system configuration settings and generating reports for all VAS and billing KPI’s.
- Shell Scripting/Cron Jobs with Redhut Enterprise Linux, Orale Enterprise Linux and Cent OS.
- Perform Database refresh and Rebuilt.
- Ensure technical and functional designs meet business requirements.
- Designing and implementing products (IN prepaid management).
- Provisioning of subscribers/subscriber Identifier Modules (SIM CARDs) in OCS, AAA, vxview, and HLR.
Education
Master of Science - Computer science
The Malawi University of Science And Technology
THYOLO2023
Bachelor of Science - Information Technology
University of Malawi, The Polytechnic
Blantyre2014
High School Diploma -
Livingstonia Secondary School
Rumphi2008
ITIL 4 Foundation Certificate JAN-06-2023 No Expiry Date -
2006
Skills
- PROFFESIONAL/TECHNICAL SKILLS
- Programming and Scripting (Python,PHP scripting, Unix Shell Scripting, Oracle SQL/PL SQL, Json/xml Scripting)
- Agile Project Management
- Change and Release management
- Extract, Transform, Load
- Business Intelligence QLik Bi Platform and Power BI
- Database Administration: Oracle 11g/MySQL/Informix/PostgreSQL Database
- Unix/Linux system administration: IBM AIX, HP-UX, Fedora/Red hut, Sun Solaris
Timeline
Prepaid Billing Specialist
TNM
11.2019 - 09.2023
IDD & MIS Analyst
TNM
09.2018 - 10.2019
Solutions Architect
Airtel Malawi
03.2017 - 08.2018
SENIOR INTELLIGENT NETWORK AND VALUE, SERVICE ENGINEER
ACCESS COMMUNICATIONS LIMITED
08.2014 - 03.2017
Master of Science - Computer science
The Malawi University of Science And Technology
Bachelor of Science - Information Technology
University of Malawi, The Polytechnic
High School Diploma -
Livingstonia Secondary School
ITIL 4 Foundation Certificate JAN-06-2023 No Expiry Date -
Similar Profiles
Nick ColemanNick Coleman
Gap Leader at TNMGap Leader at TNM
Alexis CruzAlexis Cruz
Manufacturing Operator at TNMManufacturing Operator at TNM
Jeff HoweJeff Howe
Graphic Designer at Firefly Graphic Arts / TNM Graphic ArtsGraphic Designer at Firefly Graphic Arts / TNM Graphic Arts