Dereck Katuli
Data Analyst
C/O Mr. R. Katuli
P.O.Box 2381,
Blantyre, Malawi
Cell : +265 - / +265 -
Email :-LinkedIn : https://www.linkedin.com/in/dereck-katuli-057b14171/
Github: https://github.com/DaOriginal
ㅡ
Profile Summary
Skilled Data Analyst | 4+ Years of Experience in Statistical Analysis &
Business Intelligence
Data enthusiast with expertise in collecting, analyzing, and presenting
statistical data to drive growth. Proficient in data mining, statistical
analysis, and business intelligence, with a focus on actionable insights. A
creative problem solver and reliable communicator, delivering concise
reports to support informed decision-making.
ㅡ
Skills
➔ Proficiency in Excel, Metabase, Qlik Sense and familiarity with
Tableau for data visualization and analysis.
➔ Proficiency in Python, R, SQL.
➔ Knowledge of relational databases (MySQL, PostgreSQL, Oracle)
and non-relational databases (MongoDB).
➔ Experience with data manipulation libraries like Pandas, NumPy.
➔ ETL pipeline development using tools like dbt, Apache Airflow
and PySpark.
➔ Experience with version control tools such as Git and GitHub.
➔ Proficiency in data cleaning and ensuring data quality.
➔ Translating complex data into actionable insights.
➔ Identifying trends and forecasting outcomes through trend
analysis.
➔ Strong critical-thinking and problem-solving abilities.
➔ Communicating technical concepts to non-technical audiences.
➔ Ensuring accuracy in data analysis through attention to detail.
➔ Adapting to new tools and technologies in data analytics.
ㅡ
Experience
Global Health Informatics Institute / Data Analyst
December 2022 - PRESENT, LILONGWE, MALAWI.
➔ Develop reporting scripts and quarterly reports using Python
and MySQL for PEPFAR and the Ministry of Health, delivering
actionable insights to improve health program outcomes.
➔ Conduct data quality audits to ensure database accuracy,
providing recommendations that enhance reliability for
decision-making.
➔ Create and maintain SOPs for data quality assessments, data
requests, and reporting workflows, streamlining processes and
ensuring compliance.
➔ Build and maintain ETL pipelines with Apache Spark to enable
seamless data integration and accessibility for real-time insights.
➔ Prepare visualizations using Metabase, R, and Python,
empowering stakeholders with tailored, data-driven insights.
➔ Train end-users on dashboards and respond to data requests,
fostering independent data utilization and informed
decision-making.
Telekom Networks Malawi / BI and Analytics Specialist
JULY 2022 - DECEMBER 2022, BLANTYRE, MALAWI.
➔ Led and optimized PORI reconciliations, ensuring timely and
accurate monthly dealer incentives reports to support
decision-making and maintain strong partner relationships.
➔ Delivered ad hoc reports to key stakeholders with a focus on
actionable insights, enhancing business strategies and enabling
data-driven decisions across departments.
➔ Streamlined ETL processes from diverse data sources into the
staging area, improving data quality and availability for
downstream analysis, thus reducing delays and ensuring timely
access to critical business information.
➔ Developed and maintained CBS data loaders and custom scripts
to extract and integrate data from the newly deployed Gauss
database, enhancing data accessibility and enabling more
efficient reporting and analytics.
➔ Designed and implemented backup scripts for data loading and
reporting tasks, ensuring business continuity and reducing risks
associated with data loss or downtime, thus safeguarding
business operations.
Telekom Networks Malawi / Data Analyst
FEBRUARY 2021 - JUNE 2022, BLANTYRE, MALAWI.
➔ Automated ETL processes, managed data partitioning and
retention, and developed backup scripts to enhance reporting
workflows, significantly improving data processing efficiency and
ensuring timely, accurate insights for business decisions.
➔ Monitored reporting and BI systems to ensure the timely loading
of CDRs and reconciliation processes, optimizing system
performance and resource availability (disk and table space),
which directly supported uninterrupted business operations and
data accessibility.
➔ Provided valuable insights from enterprise data using advanced
analytics tools, enabling key stakeholders to make data-driven
decisions that aligned with business goals and improved overall
organizational performance.
➔ Delivered ad hoc reports and facilitated monthly dealer
incentive reports, ensuring that business stakeholders received
actionable information on time, driving improved dealer
relations and aligning with performance-based objectives.
Telekom Networks Malawi / Graduate Trainee
FEBRUARY 2020 - JANUARY 2021, BLANTYRE, MALAWI.
➔ Assisted in automating ETL processes, streamlining data flows
and reducing manual efforts, which improved data accessibility
and processing speed, enhancing overall reporting efficiency.
➔ Managed data retention and actively monitored reporting
systems to ensure the timely availability of critical business data,
supporting seamless decision-making and minimizing disruptions
in business operations.
➔ Supported stakeholders by generating ad hoc reports,
reconciling data, and preparing dealer performance and
incentive reports, enabling more informed decisions that
fostered stronger partner relationships and performance-based
growth.
➔ Analyzed enterprise data using analytics tools to provide
actionable insights, empowering stakeholders with the
information needed to make strategic decisions that contributed
to business growth and operational improvements.
ㅡ
Education
JAIN Online / Master of Computer Applications - Data Analytics
DECEMBER 2024 - DECEMBER 2026, Online, India..
Mzuzu University / Bachelor of Science In Information and
Communication Technology
AUGUST 2015 - SEPTEMBER 2019, Mzuzu, Malawi.
Michiru View Boys Secondary School / Malawi Schools Certificate
of Education
AUGUST 2009 - SEPTEMBER 2013, Blantyre, Malawi.
ㅡ
References
●
●
●
James Mandiza, BI & Reporting Manager, TNM-Noordeen Malango, Data Scientist, FCB-Steve Chanza, IT & Innovations Manager, PCL-