Candidate

------------------------------
First Name: John
E-Mail Address: joohhnnym@gmail.com
Country: Zambia
Phone: 0970877565
Current Job Designation: Director - ICT
Job Designation Applying For: Manager - ICT, Project Manager, Director
Total Years of Experience: 21 years
Copy your Resume / CV in this box: JOHN MWANZA
Lusaka, Zambia
Phone: +260 970 877 565
Email: joohhnnym@gmail.com
________________________________________
PROFILE SUMMARY
ICT and data systems professional with long experience supporting enterprise operations, improving data quality, and guiding technology work across finance, operations, and administration. Skilled in SQL, reporting architecture, system integration, and the modernization of legacy environments. Strong background in requirements analysis, documentation, and structured development cycles. Known for practical, reliable solutions that improve information flow and support institutional planning.
________________________________________
CORE EXPERTISE
• Database and SQL management
• Power BI reporting and data modelling
• ETL routines and data quality control
• Requirements development and fit-gap analysis
• System integration and interface behaviour
• Migration and decommissioning planning
• Financial and operational reporting
• SDLC participation, testing, and verification
• Information governance and documentation
________________________________________
PROFESSIONAL EXPERIENCE
Director, ICT and Training
Zambian Open University, Lusaka
Jul 2023 – Present
• Manage ICT operations and institutional data for academic, financial, and administrative functions.
• Oversee SQL-based processes, data structures, extraction routines, and dependency reviews.
• Direct the design of Power BI dashboards and analytical products for executive reporting.
• Conduct requirement assessments and prepare technical specifications for system enhancement.
• Support analysis, testing, and user acceptance during system development cycles.
• Document data flows, metadata, system inventories, and integration points.
• Coordinate systems linking finance, HR, and academic datasets.
• Review legacy applications and recommend options for modernization and consolidation.
Selected Achievements
• Improved budget monitoring and operational visibility through new reporting models.
• Reduced reconciliation time by streamlining data pipelines across multiple systems.
• Strengthened data lineage by reorganizing legacy scripts and clarifying metadata.
• Introduced routine data checks that improved accuracy of management reports.
________________________________________
Head, ICT and Training
Tobacco Board of Zambia, Lusaka
Feb 2014 – Jun 2023
• Managed enterprise datasets supporting regulatory and financial activities.
• Maintained SQL applications, optimized queries, and reviewed system structures.
• Built compliance and financial reports used for routine and statutory oversight.
• Led requirement documentation for system improvements and integrations.
• Supported test planning, data validation, and user acceptance cycles.
• Reviewed overlapping systems and recommended consolidation paths.
• Prepared system documents, data dictionaries, and flow diagrams.
• Worked with finance and planning teams to align datasets for reporting consistency.
Selected Achievements
• Built an integrated reporting environment combining SQL, Power BI, and structured repositories.
• Consolidated legacy utilities and spreadsheets into organized databases.
• Improved accuracy of regulatory and financial datasets through standard validation rules.
• Supported data migration efforts by preparing technical transition notes.
________________________________________
Senior Engineer and Training Consultant
ZESCO Limited, Zambia
2002 – 2007
• Supported operational and financial systems and reviewed database behaviour.
• Wrote SQL routines for reporting, extraction, and troubleshooting.
• Assisted in documentation, testing, and updates to processing routines.
• Prepared ER diagrams, data specifications, and technical notes.
• Trained users handling analytical and operational tools.
Selected Achievements
• Strengthened reliability of system reports through improved SQL routines.
• Contributed to redesign of data flows that reduced duplication and improved performance.
• Supported modernization efforts through prototype testing and documentation.
________________________________________
EDUCATION
MSc, Computer Science and Engineering, Shanghai University, China
BSc, Computer Science, Shanghai University, China
School Certificate, Zambia
________________________________________
TECHNICAL SKILLS
SQL • PL/SQL • Power BI • Power Query • DAX • ETL processes • Python • R • VBA
Database schema analysis • ER modelling • Data flow documentation • Microsoft 365
SDLC documentation • IBM Planning and Analytics (familiarity)
________________________________________
ADDITIONAL EXPERIENCE
• Designed information systems for programme tracking and performance monitoring.
• Contributed to studies on technology use and digital process improvement.
• Supported knowledge-sharing and internal training on analytical tools.
________________________________________
LANGUAGES
English (Fluent)
French (Working knowledge)
Chinese (Working knowledge)
________________________________________



REFERENCES
Professor K. Yambayamba, Vice Chancellor, Zambian Open University
Tel: +260 966 755 959 | Email: kavwanga.yambayamba@zaou.ac.zm
Professor Edwin Zulu, Zambian Open University
Tel: +260 977 788 2185 | Email: edwin.zulu@zaou.ac.zm
Mr. Robert Mwale, CEO, Tobacco Board of Zambia
Tel: +260 977 234 233 | Email: robert.mwale@tbz.co.zm

------------------------------