Ted Kaliyapa

Client: The Lilongwe Institute of Orthopaedics and Neurosurgery (LION), Lilongwe, Malawi

• End-to-end patient journey management (registration to discharge)
• Outpatient Department (OPD) and admission management
• Electronic Medical Records (EMR) system
• Pharmacy and drug administration tracking
• Laboratory and radiology integration
• Billing and insurance claims processing
• Inventory management for medical supplies
• Real-time dashboards for clinical and administrative reporting
• Multi-user access with role-based security

Impact: Streamlining healthcare delivery at Malawi's premier orthopedic and neurosurgery facility, improving patient care quality, reducing wait times, and enhancing operational efficiency.

Status: Currently operational and actively used by medical staff for daily operations.

Xtra Healthcare delivers innovative healthcare solutions, leveraging technology to enhance operational efficiency and patient care.

Key Achievements & Responsibilities

• Business & Data Analysis: Tracked and analyzed data to support strategic business transformation initiatives, identifying actionable opportunities for process optimization across the organization.
• Database Management: Utilized SQL expertise to manage, optimize, and troubleshoot core CRM system databases, ensuring data integrity, performance, and reliability.
• Software Configuration & Testing: Defined, tested, and verified configuration changes for in-house software solutions, ensuring alignment with evolving business requirements.
• Application Development Coordination: Led and coordinated multiple software projects simultaneously, managing development schedules to ensure timely delivery and adherence to project milestones.
• Dashboard & Reporting Development: Designed and deployed real-time software dashboards to monitor system performance and key performance indicators (KPIs), enabling data-driven decision-making.
• Workflow Optimization: Analyzed and documented existing business processes, delivering recommendations for increased efficiency and automation that streamlined operations.
• Requirements Translation: Collaborated closely with stakeholders to translate business needs into detailed system change specifications for development teams, bridging the gap between end-users and technical implementation.
• Process Improvement & Documentation: Developed and implemented standards, procedures, and technical documentation to improve software quality, maintainability, and user experience.
• Software Troubleshooting: Diagnosed and resolved application issues promptly, identifying areas for enhancement to improve system stability and performance.
• Technical Support & Training: Provided technical assistance to end-users and programming teams, creating clear documentation to facilitate system adoption and user competency.

Client: Malawi Defence Force College, Salima, Malawi

• Full-featured online learning platform for military education
• Course management and digital content delivery
• Student assessment and grading system
• Virtual classrooms and multimedia support
• Secure access controls and role-based permissions
• Progress tracking and certification management
• Mobile-optimized for field access

Impact: Modernizing military education through technology, enabling distance learning for defense personnel and supporting professional development across the armed forces.

Literacy Management Information System (LMIS)
National Centre for Literacy and Adult Education (NACLAE) – Ministry of Gender, Community Development, and Social Welfare | Malawi

• Developed a comprehensive Management Information System (MIS) to oversee 10,000+ literacy centers nationwide, enabling centralized coordination of adult literacy programs across Malawi.
• Engineered end-to-end functionality including student enrollment, attendance tracking, progress monitoring, instructor management, and resource allocation, ensuring operational efficiency at scale.
• Built performance analytics and reporting dashboards to deliver actionable insights for policymakers, facilitating data-driven decision-making in community development.
• Designed a mobile-responsive interface to enable remote center access, ensuring usability in resource-constrained environments with varying levels of digital infrastructure.
• Aligned system capabilities with Malawi Vision 2063, directly supporting the government's strategic initiative to reduce illiteracy and promote lifelong learning for vulnerable communities.
• Delivered critical data infrastructure to inform policy formulation and resource allocation, strengthening the Ministry's capacity to target interventions where they are most needed.

• Led the end-to-end development of the Teacher Progress Assessment System (TPAS), a national digital platform commissioned by the Government of Malawi.
• Designed the system to automate the appraisal of teacher performance, establishing a standardized framework for evaluating educators across the country.
• Integrated critical workflow logic that directly links performance appraisal outcomes to teacher promotions, enabling the Ministry of Education to streamline human capital management.
• Provided a centralized data solution for government stakeholders to facilitate transparent, merit-based promotion decisions.

Development of Climate Finance Monitoring System (CFMS)
United Nations Development Programme (UNDP) | Government of Malawi

Engaged by the United Nations Development Programme (UNDP) to develop a national Climate Finance Monitoring System for the Government of Malawi, enabling comprehensive tracking of climate financing and expenditure across the country.

Key Deliverables & Impact

• National Climate Finance Infrastructure: Designed and developed a centralized monitoring system to track climate financing flows from government, development partners, and stakeholders, providing a unified view of climate-related investments nationwide.
• Expenditure Tracking & Accountability: Engineered functionality to monitor climate spending across sectors, enhancing transparency and enabling evidence-based reporting on the utilization of climate funds.
• Stakeholder Integration: Built the system to serve multiple user groups, including government ministries, development partners, and other stakeholders, facilitating coordinated approaches to climate finance management.
• Policy Support: Delivered a critical tool to support the Government of Malawi in meeting international climate reporting commitments and strengthening domestic accountability for climate action.
• Strategic Alignment: Aligned system architecture with national development priorities and climate resilience goals, contributing to Malawi's efforts to effectively mobilize and manage climate resources.

• Liaised with third-party agencies for successful resolution of complex issues.
• Maintained quality control by defining and documenting operating procedures.
• Facilitated continuity of service, documenting and tracking all issues and call transactions in the college ICT Lab.
• Worked alongside service desk to provide 1st and 2nd line support to users deskside and remotely.
• Set up emails, phones and general hardware technical support capabilities.
• Managed technical support page by creating FAQs and posting knowledge-based articles.
• Provided technical support throughout development phases of new products.

• Day to day IT administration tasks such as troubleshooting the network and restoring including support of various office products and applications; like MS Word, Spreadsheet with Access and MySQL Databases
• Developing Institutions' In-house Applications; both Desktop and Web Based.
• Designing and updating websites involving the use of PHP, JavaScript, HTML, Bootstrap, Data-tables and Dreamweaver, etc.
• Managed a technical support team, providing timely and effective solutions to clients and maintaining a customer satisfaction rate of 95%
• Oversaw technical training programs for support staff, ensuring a high level of expertise in troubleshooting and customer service.
• Acted as a liaison between customers and product development teams, facilitating the incorporation of client feedback into product enhancements
• Maintained a deep understanding of Microsoft technologies and provided top-tier technical support for complex issues; including Server Administration as well as Management of the Mail Exchange Server for all users; admin staff and students

• Designed and developed several web and desktop applications in using PHP. HTML, JavaScript, Bootstrap, Data-Tables and other web scripting tools.
• Boosted sales potential by presenting new revenue stream to clients using software prototypes.
• Supported innovation objectives by keeping up to date with latest integration solutions.
• Resolved customer complaints to boost loyalty and satisfaction.