Learn Data Skills
Beta
dereck katuli

dereck katuli

Data Analyst

Mzuzu University | Lilongwe, Malawi

Technologies

My Portfolio Highlights

My New Course

Understanding Cloud Computing

My New Course

Understanding Cloud Computing

Data Analyst | Data Engineer

My Work

Take a look at my latest work.

course

Intermediate Importing Data in Python

course

Understanding Cloud Computing

course

Introduction to Python for Developers

course

Intermediate Importing Data in Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Global Health Informatics Institute | Dec 2022 - Present

Data Analyst

Preparing reports based on stakeholder indicators on time and where necessary stating trends, patterns, and predictions using relevant data Preparing final analysis reports for stakeholders to understand the data-analysis steps enabling data-driven decisions Understanding data storage and data sharing methods, identify, analyze and interpret trends or patterns in complex datasets Converting or visualizing data into usable information that is easy to understand using different tools to suit the relevant stakeholders Quarterly reporting utilizing R and Python for comparison analysis before submission to stakeholders Working with engineers and leads to identify process improvement opportunities,proposed modifications and new process improvement opportunities Training end-users on new reports and dashboards Researching solutions to overcome data analytics challenges Involved in increasing data use activities among stakeholders Developing internal visualization using Metabase
Show More

Telekom Networks Malawi | Jul 2022 - Dec 2022

Bi and Analytics Specialist

Facilitated PORI reconciliations and provided monthly dealer incentives reports. Ensured that dealer’s PORI performance daily updates were up to date. Provided ad hoc reports to various stakeholders in a timely manner. Monitored the Qlik application daily to ensure accurate reporting. Ensured timely loading of files for reporting and monitored daily CDR reconciliations. Monitored and maintained disk space and table space on reporting servers, ensuring system availability. Managed data partitioning and retention processes. Developed backup scripts for data loading and reporting tasks. Created CBS data loaders and ad hoc scripts for pulling data from Gauss DB. Drove data-driven decision-making across various aspects of the business. Ensured efficient ETL processes from various data sources into the staging area.

Telekom Networks Malawi | Feb 2020 - Jun 2022

Data Analyst

Reconciled PORI data and provided monthly dealer incentives reports. Ensured that dealer’s PORI performance daily updates were up to date. Ensured timely provision of ad-hoc reports to various stakeholders. Monitored Qlik monitoring app daily. Ensured all files were loaded in time for reporting and monitored daily CDR reconciliations. Ensured all reporting and BI systems were available by monitoring disk space and table space on reporting servers. Managed data partition and retention. Developed backup scripts for all data loading and reporting scripts. Developed CBS data loaders.

My Education

Take a look at my formal education

Bachelors of Science in Information and Communication TechnologyMzuzu University | 2019

About Me

dereck katuli

I am a Data Enthusiast skilled in transforming raw data into actionable insights. Excels in end-to-end data processing, from extraction and cleaning to creating compelling visualizations. Proficient in MySQL, PostgreSQL, Python, R, Qlik, and Metabase

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free