Ian Irungu Kiragu
Nairobi
Summary
Experienced professional with a proven track record of transforming data into actionable insights. Utilizes advanced analytical tools and techniques to drive business growth and efficiency. Recognized for fostering team collaboration and consistently delivering results in dynamic environments. Proficient in data visualization, SQL, and statistical analysis, while maintaining a flexible approach to evolving project requirements.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst | Data Analyst
Tawi Fresh Kenya LTD
06.2023 - Current
- Collaborated with 10+ stakeholders across departments to gather requirements, resulting in a 30% improvement in decision-making speed through enhanced data insights
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Optimized SQL queries, reducing ETL processing time by 40%, leading to faster data availability for analysis
- Conducted data analysis on 1M+ records, identifying trends that contributed to a 15% increase in revenue through strategic decision-making
- Implemented data validation processes that improved data accuracy by 95%, reducing reporting errors and inconsistencies
- Developed and maintained 15+ data models and datasets in Power BI, fully automating dashboard availability to 100%, eliminating manual reporting efforts
- Trained 20+ end-users on Power BI and SQL Server functionalities, increasing adoption rates by 60% across the organization
- Delivered 10+ ad-hoc reports, reducing business units' request fulfillment time by 35%
- Optimized data access and storage, improving analytics system performance by 50% and reducing query execution time from minutes to seconds
- Led the 'Smart Basket' project, benefiting 1,000+ end users, improving order processing efficiency by 25%, and enhancing e-commerce platform usability
Contractor | IT Infrastructure: Data Control
NAS Airport Services
02.2023 - 06.2023
- Digitized 100% of vendor specification data, streamlining the company's online presence by documenting 1,500+ products and specifications in the Espec System
- Collaborated with the Supply Chain Department to reconcile 5+ years of historic data, aligning over 50 vendor records with current specifications, reducing inconsistencies by 85%
- Processed 300+ purchase requisitions and orders, gaining hands-on experience in Microsoft Dynamics 365, ensuring 99% accuracy in procurement transactions
- Generated and delivered 50+ executive reports for senior management, providing actionable insights that supported key procurement and vendor management decisions
Graduate Trainee | Business (Data) Analyst Intern
SAMA
09.2021 - 11.2022
- Business Risk and Strategic Solutions: Conducted 10+ risk assessments, contributing to the development and implementation of strategic solutions that enhanced operational efficiency by 30%
- Data Analysis and Tools Proficiency: Worked with datasets exceeding 5 million records, leveraging Excel, Google Sheets, MySQL, Google Cloud Platform, and Google Data Studio to create 20+ interactive dashboards for data visualization
- Database Management: Designed and optimized 10+ database structures, improving query performance by 40%
- Implemented backup and recovery strategies, ensuring 95% data availability
- ETL and Decision Support: Managed 200+ ETL workflows, reducing data processing time by 50%, leading to faster and more accurate decision-making
- Agile and Scrum Methodologies: Collaborated in 20+ Agile sprints, achieving 95% sprint goal completion while ensuring alignment with business objectives
- Executive Reporting: Developed and delivered 100+ executive reports and dashboards, providing actionable insights that influenced strategic decisions
- Quantitative and Qualitative Insights: Translated complex data into meaningful insights, leading to a 20% increase in operational efficiency and supporting key business objectives
Internship | IT Infrastructure Engineer
Britam Holdings PLC
01.2020 - 05.2020
- Analyzed and manipulated datasets exceeding 2M+ records, supporting business needs and improving decision-making efficiency by 30%.
- Collaborated with developers to maintain and enhance a public-facing product, leading to a 20% improvement in system performance and user engagement.
- Gained hands-on experience in managing 10+ projects, covering the full project lifecycle from planning to execution and delivery.
- Resolved 95% of 200+ software and hardware issues on first contact, ensuring smooth daily operations.
- Provided first-level support for ERP systems and internal tools, reducing downtime by 40% through proactive troubleshooting.
- Created and managed 300+ user accounts, implementing secure access control policies to minimize security risks.
- Optimized server storage and system performance, ensuring 99.9% uptime and preventing critical failures.
- Monitored and addressed system performance issues proactively, reducing server downtime by 25%.
Education
Bachelor of Science - Informatics And Computer Science
Strathmore University
Nairobi09.2021
Skills
- MYSQL/PostgreSQL/SQL Server
- PowerBI/Looker Studio/Tableau
- Advanced Excel and Google Sheets
- Microsoft Dynamics
- Python/JavaScript/Git
- Microsoft Azure/ Google Cloud Platform/ Big Query
- Jira/Atlassian Software/SAP
- Business process improvement/Gap analysis
Certification
The Complete Developers Guide (MYSQL, PostgreSQL), Udemy Learning
Timeline
Business Intelligence Analyst | Data Analyst
Tawi Fresh Kenya LTD
06.2023 - Current
Contractor | IT Infrastructure: Data Control
NAS Airport Services
02.2023 - 06.2023
Graduate Trainee | Business (Data) Analyst Intern
SAMA
09.2021 - 11.2022
Internship | IT Infrastructure Engineer
Britam Holdings PLC
01.2020 - 05.2020
The Complete Developers Guide (MYSQL, PostgreSQL), Udemy Learning
Bachelor of Science - Informatics And Computer Science
Strathmore University
Similar Profiles
Ian Irungu KiraguIan Irungu Kiragu
Business Analyst | Database Administrator at Tawi Fresh Kenya LTDBusiness Analyst | Database Administrator at Tawi Fresh Kenya LTD
Rose MuneneRose Munene
Intern at Standard chartered Ventures ( Tawi Fresh Kenya Limited)Intern at Standard chartered Ventures ( Tawi Fresh Kenya Limited)
ANTHONY KIMEMIAANTHONY KIMEMIA
Logistics Supervisor at Tawi Fresh Kenya LTDLogistics Supervisor at Tawi Fresh Kenya LTD