Dereck Katuli

Dereck Katuli

$5/hr
Data Analytics
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
29 years old
Location:
Lilongwe, Central, Malawi
Experience:
3 years
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-
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.