John Njogu
Data Analyst
Ruiru, Kiambu District
Summary
Analytical Excel Expert with advanced skills in data analysis, dashboard creation, and reporting automation. Utilizes advanced Excel functions, PivotTables, Power Query, macros, and VBA to enhance business efficiency and data accuracy. Transforms complex datasets into actionable insights to support management and optimize business operations.
Overview
3
3
years of professional experience
2
2
Certifications
1
1
Language
Work History
Data Analyst
Fiverr.com
01.2024 - 01.2026
- Validated and cleansed data to maintain data integrity.
- Analyzed large datasets, enhancing accuracy and streamlining processes.
- Developed automated Excel dashboards that reduced reporting time by 30%.
- Applied statistical methods to extract insights and create actionable business reports.
- Built interactive reports using PivotTables, slicers, and charts for management review.
- Performed data validation and cleansing to ensure data integrity.
Data Entry Clerk
Fiverr.com
02.2023 - 12.2023
- Prepared weekly and monthly performance reports to track operational trends.
- Maintained accurate records and generated Excel reports to streamline daily operations.
- Verified accuracy of data entered into system to produce error-free reports.
- Updated and ensured accuracy of company databases for reliable data access.
- Used formulas such as IF, SUMIFS, VLOOKUP, and INDEX-MATCH for reporting tasks.
- Organized and analyzed operational data to support business decisions.
- Assisted in preparing weekly and monthly performance reports.
Education
Bachelor of Science - Agribusiness Economics
Jomo Kenyatta University of Agriculture And Technology
Juja, Kiambu District, Kenya 04.2001 -
Skills
- Financial & Data Analysis
- Excel functions
- Data analysis
- PivotTables & PivotCharts
- VLOOKUP, XLOOKUP, INDEX-MATCH
- Data Visualization
- Lookup functions
- Microsoft Office Suite
Accomplishments
- Designed a fully automated Excel dashboard to track sales KPIs and performance trends.
- Created an Excel-based payroll system using formulas and macros to automate salary calculations and reporting.
Additional Information
- Effective communication and teamwork skills
- Excellent attention to detail
- Strong analytical and problem-solving skills
- Ability to work with confidential and sensitive data
Certification
Data Analysis with Excel Certification
Timeline
Data Analyst
Fiverr.com
01.2024 - 01.2026
Data Entry Clerk
Fiverr.com
02.2023 - 12.2023
Bachelor of Science - Agribusiness Economics
Jomo Kenyatta University of Agriculture And Technology
04.2001 -