Summary
Overview
Work History
Education
Skills
Timeline
Generic

Mandickel Kamtengeni

Oxford,Oxfordshire

Summary

I am an oxford based Data Engineer. I have extensive experience designing end-to-end solutions from ETL pipelines, algorithms, databases, websites and other software products. I currently work as a database programmer at the University of Oxford.

Overview

7
7
years of professional experience

Work History

Database Programmer/Data Engineer

University of Oxford
Oxford, Oxfordshire
07.2023 - Current
  • Designing and developing ETL pipelines to map de-identified hospital and primary care data to OMOP Common Data Model for observation research projects, leveraging Python and PostgreSQL.
  • Conducting comprehensive data quality checks on newly mapped research datasets via the creation of meticulously crafted SQL scripts.
  • Effectively managing clients and stakeholders across diverse data partnerships and research collaborations.
  • Data extraction and cleaning using SQL, Postgresql, and Python.
  • Performing PostgreSQL database administration with a steadfast focus on maximizing performance and ensuring unwavering reliability of vital database systems.

Application Support Specialist

Universal Leaf Tobacco Company
Lilongwe, Malawi, Kanengo
08.2019 - 06.2024
  • Managed and supported the company's Enterprise resource planning (ERP) system, overseeing SQL Server Database administration and optimization with over 900 active users.
  • Independently developed the company's IT Inventory System, improving asset verification accuracy by 98%.
  • Developed and implemented database solutions with a focus on efficiency, using SSMS, MYSQL, and MS Access.
  • Collaboratively migrated 1 TB data warehouse from former ERP system to current in SQL Server, ensuring data integrity.
  • Implemented data integration strategies by leading ETL initiatives involving tools like SSIS, Python, and SQL scripts to unify diverse data sources.
  • Executed precise database backups and restorations to ensure data availability.
  • Supported disaster recovery operations, ensuring business continuity.

IT Operations Associate

One Acre Fund
Zomba, Malawi, Zomba
01.2018 - 07.2019
  • Leveraged advanced SQL scripting techniques to optimize data extraction and manipulation for the bizops team.
  • Contributed to the development and testing of disaster recovery plans, ensuring data resilience and business continuity.
  • Implemented ETL procedures to seamlessly integrate and transform various data streams, ensuring data consistency and accuracy.
  • Monitored network infrastructure proactively, optimizing performance and ensuring continuous data flow.
  • Analyzed network utilization data to drive strategic capacity planning initiatives.

Data Management Officer

Dignitas International
Zomba, Malawi, Zomba
01.2017 - 12.2017
  • Implemented data cleaning processes using T-SQL, MYSQL scripting, and VBA code to ensure data accuracy and reliability.
  • Executed data merging procedures utilizing ETL processes such as SSIS and SQL scripts, facilitating seamless integration of diverse datasets.
  • Automated data backups using MySQL dump scripts and shell scripts, enhancing data security and accessibility.
  • Created data dashboards to report indicator progress, supporting informed decision-making.
  • Led data modeling and warehousing efforts for comprehensive data analysis and insights.
  • Wrote triggers in SQL databases to optimize functionality and improve data processing efficiency.
  • Conducted data verification and validation activities to ensure data accuracy and compliance.
  • Spearheaded the development of health applications, including HIV testing and treatment systems, to leverage data for societal impact.

Education

Master of Science - Computer Applications

Amity University
India
12-2022

Bachelor of Science - Business Information Technology

University of Greenwich
Greenwich
08-2017

Level 5 Diploma - Business Information Technology

NCC Education
United Kingdom
04-2016

Level 4 Diploma - Business Information Technology

NCC Eductation
United Kingdom
04-2014

Skills

  • Programming Languages: Proficient in Python, SQL, and C#
  • Database Management: Strong understanding of SQL Server, MySQL, PostgreSQL, or NoSQL databases like MongoDB
  • ETL (Extract, Transform, Load): Experience with Python, SQL and SSIS
    Data Modeling: Knowledge of data modeling concepts and tools like ER diagrams and Star Schema
  • Data Pipeline Development: Ability to design and build efficient data pipelines using python and TSQL, Postgresql
  • Data Quality and Governance: Understanding of data quality principles and experience with data governance frameworks
  • Cloud Platforms: Working knowledge of different cloud services provided by AWS, Azure, or Google Cloud Platform (GCP) for data storage and processing
  • Version Control: Proficiency in Git for managing code and collaboration
    Problem-solving Skills: Ability to troubleshoot and solve complex data-related problems
  • Communication Skills: Strong communication skills for effective collaboration with cross-functional teams
  • Continuous Learning: Commitment to staying updated with the latest trends and technologies in data engineering
    Project Management: Ability to manage projects effectively, including scoping, planning, execution, and delivery

Timeline

Database Programmer/Data Engineer

University of Oxford
07.2023 - Current

Application Support Specialist

Universal Leaf Tobacco Company
08.2019 - 06.2024

IT Operations Associate

One Acre Fund
01.2018 - 07.2019

Data Management Officer

Dignitas International
01.2017 - 12.2017

Master of Science - Computer Applications

Amity University

Bachelor of Science - Business Information Technology

University of Greenwich

Level 5 Diploma - Business Information Technology

NCC Education

Level 4 Diploma - Business Information Technology

NCC Eductation

Similar Profiles

CREATE PROFILE
Mandickel Kamtengeni