Python
JOHN MUTURI
Data Analyst
Nairobi
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
2
2
years of professional experience
4
4
years of post-secondary education
1
1
Certificate
Work History
Data Analyst
ALX Data Analytics Project
3 2024 - 7 2024
- Developed Complex SQL Queries: Designed and executed complex SQL queries to analyze and aggregate water source data, including filtering and joining multiple tables to produce actionable insights
- Advanced Data Analysis: Utilized Common Table Expressions (CTEs) to perform advanced data aggregation and analysis, including calculating percentage access to water sources and evaluating infrastructure upgrade costs
- Ranking and Prioritization: Applied window functions to rank projects based on criteria such as number of people served, helping prioritize resource allocation and project implementation
- Provinces Analysis: Analyzed town-level data to identify provinces where all towns had less than 50% access to home taps, providing critical information for targeting improvement efforts.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Research Assistant
Kenya National Bureau of Statistics (KNBS)
11.2023 - 01.2024
- During the Foreign Investment Survey, I secured 25 out of 28 returns from resident enterprises despite institutional hostility.
- Maintained data quality by educating investors on survey objectives for government statistics on the balance of payment (BOP) and international investment position (IIP).
- Enhanced research quality by meticulously collecting and analyzing data from various sources
- Ensure confidentiality of data from local enterprises on cross-border transactions.
- Address concerns of investors hesitant to share financial information for the survey.
- Guarantee data protection as required by the statistical act on confidentiality.
- Organized research materials, maintaining a well-ordered workspace conducive to productivity
- Participated actively in regular meetings with fellow researchers to discuss project updates, challenges faced, and lessons learned during ongoing activities.
Benefits Department Intern
National Social Security Fund (NSSF)- Kiambu, Kenya
07.2022 - 06.2023
- Generated Detailed Reports: Prepared monthly reports for the benefits department, tracking claims received and paid. Supported decision-making and identified operational improvements.
- Collaborative Data Analysis: Analyzed complex datasets with data analysts during the NSSF internship and compiled a board report. Findings resulted in a 40% reduction in rejected claims
- Improved Data Quality: Conducted data quality checks and cleaning, reducing errors and ensuring reliable reports for management.
- Data Entry: Processed benefit claims from customers and uploaded them to the EDMS (Electronic Data Monitoring System).
- Critical Contribution: Contributed significantly to the benefits department by managing the disbursement of retirement benefit claims, including verifying legal and endorsement letters.
- Handled sensitive information with discretion while maintaining confidentiality at all times
Education
BSC, Applied Statistics with Computing -
Karatina University
09.2017 - 05.2021
Skills
Data Analysis
Personal Information
Nationality: Kenyan
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
[Data Analyst ]Training - [21 Hours Long]
Software
My SQL, PostgreSQL, SQL Server
Power Bi
Timeline
[Data Analyst ]Training - [21 Hours Long]
06-2024
Research Assistant
Kenya National Bureau of Statistics (KNBS)
11.2023 - 01.2024
Benefits Department Intern
National Social Security Fund (NSSF)- Kiambu, Kenya
07.2022 - 06.2023
BSC, Applied Statistics with Computing -
Karatina University
09.2017 - 05.2021
Data Analyst
ALX Data Analytics Project
3 2024 - 7 2024
Similar Profiles
Aman ModyAman Mody
Data Analyst at MIS, BUSINESS DATA MANAGEMENT & DATA ANALYTICS PROJECTData Analyst at MIS, BUSINESS DATA MANAGEMENT & DATA ANALYTICS PROJECT
Stephen PowersStephen Powers
Director of Project Management – Director of Operations & Data Analytics at Director of Project Management – Director of Operations & Data AnalyticsDirector of Project Management – Director of Operations & Data Analytics at Director of Project Management – Director of Operations & Data Analytics
Sampath Kumar Reddy SomaSampath Kumar Reddy Soma
Data Engineer at Project: Telecom Network Data Aggregation and AnalyticsData Engineer at Project: Telecom Network Data Aggregation and Analytics
Samuel IgutaSamuel Iguta
ACCOUNTANT at MEDPLUS HEALTHCARE SOLUTIONS LIMITEDACCOUNTANT at MEDPLUS HEALTHCARE SOLUTIONS LIMITED
ANITA JOAN CARPENTERANITA JOAN CARPENTER
Enterprise Channel Account Manager at Exclusive Networks Kenya LtdEnterprise Channel Account Manager at Exclusive Networks Kenya Ltd