Summary
Overview
Work History
Education
Skills
PROJECTS
Certification
Work Availability
Work Preference
Languages
Timeline
background-images
Zachary Dokpesi

Zachary Dokpesi

Smithfield

Summary

I'm a professional with strong background in IT support and technical troubleshooting. Skilled in diagnosing and resolving hardware and software issues, managing networks, and providing exceptional customer service. Known for effective team collaboration, adaptability, and delivering results in fast-paced environments. Proficient in various operating systems, network configurations, and IT service management tools. Reliable and flexible, ensuring seamless IT operations and user satisfaction. Detail-oriented, organized, and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Overview

2
2
years of professional experience
2
2
Certification

Work History

IT Support Technician

African Independent Television
01.2024 - 02.2025
  • Analyzed operational data sets to identify trends and provide insights that shaped business strategies.
  • Designed and maintained SQL queries for extracting, cleaning, and reporting data across multiple departments.
  • Implemented Excel-based dashboards to track IT asset usage, reducing downtime and optimizing device allocation.
  • Enhanced networking infrastructure, improving data flow and inter-departmental collaboration.
  • Improved data accuracy and integrity through cleansing and validation processes.
  • Managed database systems for efficient storage and retrieval of analytical data.
  • Assisted in troubleshooting network connectivity problems, enhancing overall system performance.
  • Monitored system performance metrics to identify areas for improvement and recommend upgrades.
  • Trained end-users on best practices for system usage, increasing their productivity and confidence in utilizing technology tools.

IT Technical Support Intern

Salako Adewale & Co.
06.2019 - 08.2019
  • Utilized Excel (PivotTables, VLOOKUP, Conditional Formatting) to streamline financial reporting.
  • Participated in financial data analysis that enhanced reporting accuracy and decisionmaking.
  • Reviewed expense reports and improved efficiency in month-end closing processes.
  • Developed a clear understanding of financial reporting and data accuracy verification.
  • Provided assistance in account balancing and reconciliation for both corporate and individual clients.
  • Assisted in troubleshooting hardware and software issues, enhancing system performance.
  • Conducted routine system checks to ensure operational efficiency and reliability.

Information Technology Intern

Heritage Bank Plc
04.2015 - 05.2015
  • Managed database updates and queries, improving retrieval efficiency and accuracy.
  • Provided IT support by diagnosing and resolving technical issues, ensuring minimal system downtime.
  • Collaborated with teams to update existing systems and enhance IT processes.
  • Learned programming fundamentals and their application in banking operations.
  • Gained understanding of server-client architecture and database communication.
  • Assisted with maintenance routines, data caching, and database updates.

Education

B.Sc. - Information Systems

American University of Nigeria
05.2023

High School Diploma - undefined

Meadow Hall College
Lagos, Nigeria
05.2016

Skills

  • Data Analysis & Visualization (Excel & BI tools)
  • Statistical Analysis & Systemic thinking
  • Programming: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn)
  • SQL (MySQL, Joins, Stored Procedures)
  • Data Cleaning & Preparation
  • Database Management Systems
  • Microsoft Office Suite (Advanced Excel: PivotTables, VLOOKUP, Macros)
  • Troubleshooting (Software & Hardware)
  • Mac OS Expertise
  • Hardware installation
  • End-user training
  • Operating system support
  • Remote desktop support
  • Help desk support

PROJECTS

  • Built a Python-based data pipeline for cleaning and analyzing customer transaction data, reducing reporting errors by 30%.
  • Developed an interactive Power BI dashboard to visualize consumer viewership trends across regions.
  • Designed SQL queries and stored procedures to automate recurring financial reporting tasks.
  • Conducted statistical analysis on survey data using Python (Pandas, NumPy, Seaborn) to support research.
  • Created a Library Management System with Draw.io and created a DFD & UML models.

Certification

  • IBM Systems Analyst Professional Certification
  • Udemy Data Analyst Certification
  • Jobberman Soft Skills Certification
  • Nigerian National Youth Service Corps Certification

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Full TimePart Time

Location Preference

On-SiteRemoteHybrid

Important To Me

Career advancementPaid sick leave401k matchWork from home optionWork-life balanceCompany CulturePersonal development programsTeam Building / Company Retreats

Languages

English
Native or Bilingual

Timeline

IT Support Technician

African Independent Television
01.2024 - 02.2025

IT Technical Support Intern

Salako Adewale & Co.
06.2019 - 08.2019

Information Technology Intern

Heritage Bank Plc
04.2015 - 05.2015

High School Diploma - undefined

Meadow Hall College

B.Sc. - Information Systems

American University of Nigeria
Zachary Dokpesi