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
Proficiency in SQL
Effective Communicator
Data Visualization
ETL Processes
Problem Solving
Data Management
Data Storytelling
Business Needs Analysis
Report Preparation
ETL processes
Strong Work Ethic
Reporting Tools
Microsoft Access
Data Exports
Attention to Detail
Google Analytics
Query Tools
Data profiling
Data Mapping
A/B Testing
Text Analytics
Data and Analytics
SQL and Databases
Problem-solving abilities
Business Analysis
Teamwork and Collaboration
Data Collection
Microsoft Office
Research Paper Writing
Research and analysis
Statistical Analysis
Research design
Analytical Thinking
Survey Administration
Time Management
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