John Gachie Wambui

I'm

```

About

I am a versatile professional with a dual focus: mastering technical electrical systems and leveraging digital tools to solve modern problems.

Electrical Technologist & TVET Trainer.

My career is built on the belief that technical skills should be accessible and practical. Whether I am wiring a control panel or coding a website, my focus is on efficiency and precision.

Degree: Electrical Technology
City: Nairobi, Kenya
Phone: +254 791 226 457
Freelance: Available

Specialization: Control Systems & Electronics
Email: gachiej585@gmail.com
GitHub: ga603
Language: English, Swahili

I am advancing my expertise in Electronics and Control Systems with a focus on applied electrical engineering research. As a TVET Trainer and Mentor, I am committed to developing industry-ready technicians through hands-on training, research-informed instruction, and future-oriented digital skills.

Skills

A blend of Engineering precision and Digital expertise.

Electrical Installation & Tech 100%

Control Engineering 90%

Data Analysis (Excel) 90%

Web Development (HTML/CSS/JavaScript) 90%

Python (Django) 90%

TVET Training & Mentorship 80%

Resume

My academic background, professional training, and community involvement.

Summary

John Gachie Wambui

Innovative Electrical Trainer and Web Developer with a strong passion for teaching and mentorship. Experienced in data analysis using Excel and developing web applications using Python, Django, and Bootstrap.

Nyeri, Kenya
+254 791 226 457
gachiej585@gmail.com

Education

Bachelor of Ed. in Technology (Electrical & Electronics)

2022 - 2025

Dedan Kimathi University of Science and Technology

Specializing in Control Engineering and Electrical Systems.

Full Stack Web Development

Oct 2025 - Dec 2025

eMobilis Mobile Technology Institute

Extensive training in HTML, CSS, JavaScript, Python, and Django framework.

Volunteering & Community

AI HealthBench Evaluator & Researcher

Oct 2025 - Present

OpenAI HealthBench Project

Contributing to the OpenAI HealthBenchmarking Dataset to extend LLM evaluation to African languages.
Validating "LLM-as-a-judge" evaluation approaches on medical prompts.

Language Lead (Kikuyu)

Sep 2025 - Dec 2025

Tonative Community

Served as Language Lead ensuring linguistic accuracy for Kikuyu.
Validated and translated sentences from English to Kikuyu to improve NLP resources.

Certifications & Training

Professional Training in Data Analysis (Excel)

2025

Ajira Digital Program

Developed skills in organizing, cleaning, and analyzing large datasets using Excel.
Learned to create advanced charts, pivot tables, and dashboards.
Gained proficiency in statistical analysis and data-driven decision making.

Data Analytics Training

2025

Data Breeds Africa

Mastered the complete analytics workflow and key fundamentals.
Applied Excel functions for data cleaning and visualization.
Developed skills in SQL, Python, and Power BI for interactive reporting.

Cybersecurity & Emerging Technologies

2025

ICT Authority Kenya & Cyber Shujaa

Gained understanding of cybersecurity fundamentals, threats, and protection measures.
Mastered skills in identifying phishing, malware, and social engineering.
Gained awareness of AI, IoT, and Cloud Computing security risks.

AI for Graphics Design

2025

Ajira Digital Program

Gained proficiency in using AI tools to automate design workflows.
Learned to generate creative visual content using AI technologies.
Developed skills in integrating AI-assisted designs into branding projects.

Virtual Assistance Training

2025

Ajira Digital Program

Proficiency in email management and scheduling (Google Calendar, Calendly).
Skills in managing social media and supporting digital marketing.
Efficient coordination of appointments and client communications.

Introduction to Cybersecurity

2023

Cisco Networking Academy

Foundational knowledge of cybersecurity principles and best practices.
Learned techniques for securing networks and systems.

View Full Resume

Happy Clients Freelance & Design Work

Projects Web, Data & Graphics

Hours Of Support Training & Mentorship

Students Mentored Digital Skills

Portfolio

A showcase of my technical projects, data dashboards, and creative designs.

All Projects
Web Development
Data Analysis
Graphic Design

Student Management Systems

I have developed a suite of robust school management platforms using Python, Django, and Bootstrap. These systems automate administrative tasks, track student performance, and manage fee payments.

1. ElimuTrack SMS

A comprehensive system for student records, exam grading, and fee tracking.

View ElimuTrack Live

2. DundoriSMS

Focused on attendance tracking, automated reporting, and secure staff authentication.

View DundoriSMS Live

1. Data Prep & Cleaning

Ensuring data accuracy using Power Query to remove duplicates and standardize formats.

2. Data Transformation

Merging tables, unpivoting datasets, and creating calculated columns for analysis.

3. Data Analysis

Using advanced logic (IF, VLOOKUP, XLOOKUP) and Pivot Tables to derive insights.

4. Data Visualization

Creating interactive Dashboards with Slicers and dynamic charts to present metrics.

5. Data Management

Structuring databases to ensure data integrity and security and Optimizing systems for efficient and reliable data retrieval.

6. Reporting

Translating technical data into clear, actionable business strategies and well-structured reports that support informed decision-making.

Event Poster Design

A creative promotional poster designed for a corporate event. Focuses on strong typography and hierarchy.

Marketing Flyer

Digital marketing material designed for social media campaigns. Created using Canva and Photoshop.

View Full Graphic Design Portfolio

Services

Providing professional technical solutions in Design, Data, Development, and Engineering Training.

Graphic Design Services

Creative visual solutions to elevate brand identity and communication.

Logo design & brand identity development
Social media graphics (posts, banners, ads)
Posters, flyers & brochures (print & digital)
Business cards, letterheads & stationery
Infographics & presentation design
Photo editing & retouching
Event, political & corporate poster design

Data Analyst & Virtual Assistant

Data Analysis

Cleaning, formatting & preprocessing (Excel/Python)
Visualization (Charts, Dashboards, Power BI)
Data entry, validation & quality assurance
Report writing & insights generation

Virtual Assistance

Email management & inbox organization
Calendar management & appointment scheduling
Document preparation, formatting & research
Social media scheduling & customer support

Full-Stack Web Development

Building modern, responsive, and functional web applications.

Website design & development (Responsive)
Front-end (HTML, CSS, JS, Bootstrap)
Back-end development (Python/Django)
Database design & integration
Web application development
Website maintenance & API integration
Landing pages & portfolio websites

Electrical Engineering Trainer

Professional training for TVET institutions and virtual learning environments.

Freelance Electrical Technology Trainer
TVET Electrical Trainer (Physical & Online)
Curriculum development & practical instruction
Control Systems & Electronics workshops

Testimonials

What my clients and students say about my work and training.

John's mentorship in graphic design was excellent. He simplified complex design principles and showed me exactly how to create professional posters using Canva. I can now handle my own business graphics with confidence.

Daniel Nzomo

Graphic Design Trainee

I requested a series of marketing flyers for my business, and the results were outstanding. John has a great eye for color and layout. The designs were delivered on time and looked very professional.

Sarah Wanjiku

Small Business Owner

The Excel dashboard John created for our sales data was a game-changer. He automated our reporting process using macros and Pivot Tables, saving us hours of work every week. Highly recommended.

Marketing Mentor

Sales Manager

We worked with John on a custom school management system. His technical skills in Python and Django are top-notch, and he was very responsive to our specific requirements regarding student data tracking.