Ian Irungu Kiragu
Nairobi
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Analyst | Database Administrator
Tawi Fresh Kenya LTD
06.2023 - Current
- Collaborate with stakeholders to understand their data needs and provide actionable insights
- Create and optimize SQL queries for data extraction, transformation, and loading (ETL) processes
- Conduct data analysis using SQL to support decision-making and identify business trends
- Ensure data accuracy and integrity by performing regular data validation and quality checks
- Develop and maintain data models, datasets, and data flows in Power BI. Fully automated the availability of dashboards by 100%
- Provide training and support to end-users on Power BI and SQL Server functionalities
- Perform ad-hoc data analysis and generate reports as required by business units.
- Optimized data access and storage to improve performance of analytics systems.
- Served as a project manager and successfully launched the "Smart Basket" feature, benefiting over 1,000 end users by enhancing their ordering experience and improving e-commerce platform efficiency.
Contractor | IT Infrastructure: Data Control
NAS Airport Services
02.2023 - 06.2023
- Digitization of Vendor Specification data: Streamlined the company's online presence where each product and its specification are documented on an Espec System
- Worked closely with the Supply Chain Department in reconciliation of historic data to align with current vendors and product specification
- Raised requisitions and orders placed by the company gaining exposure in Microsoft Dynamics 365
- Required to generate executive reports for senior Management
Graduate Trainee | Business (Data) Analyst Intern
SAMA
09.2021 - 11.2022
- Business Risk and Strategic Solutions: Supported risk assessment and contributed to the development and implementation of strategic solutions to enhance operational efficiency.
- Data Analysis and Tools Proficiency: Worked in data-intensive environments, gaining expertise in Excel, Google Sheets, MySQL, Google Cloud Platform, and Google Data Studio for data visualization.
- Database Management: Designed and reviewed database structures to support business requirements, including logical and physical modeling. Implemented effective backup and recovery strategies to ensure data integrity.
- ETL and Decision Support: Conducted ETL processes and performed data analysis to drive informed decision-making.
- Agile and Scrum Methodologies: Actively collaborated in Agile and Scrum environments to achieve project objectives.
- Executive Reporting: Produced executive-level reports and dashboards for senior management, offering actionable insights for strategic planning.
- Quantitative and Qualitative Insights: Synthesized complex data into meaningful insights to support business goals.
Internship | IT Infrastructure Engineer
Britam Holdings PLC
01.2020 - 05.2020
- Data Team:Worked extensively with SQL queries in a test environment, ensuring accuracy and functionality before deployment to production.
Assisted in analyzing and manipulating data to support business needs and improve decision-making processes.
- Project Management Office:Collaborated with developers to maintain and enhance an existing product available to the public.
Gained insight into project lifecycle management, including planning, execution, and delivery phases.
- Help Desk and Support:Provided first-level support for various company software, including ERP systems and internal tools.
Troubleshot and resolved user issues related to software and hardware, ensuring smooth daily operations.
- Systems Support and Server Administration:Created and managed user accounts, ensuring secure and efficient access control.
Managed server storage and provided hardware and software support at the user level.
Monitored system performance to proactively address issues and maintain uptime.
Education
Informatics and Computer Science -
Strathmore University
09.2021
Skills
- MYSQL/ PostgreSQL
- SQL Server
- PowerBI/Looker Studio/Tableau
- Advanced Excel / Google Sheets
- Microsoft Dynamics
- Python
- Microsoft Azure (Systems Admin Entra ID)
- Google Cloud Platform/Big Query
- Jira/Atlassian Software
- SAP
- Git
- Javascript
Certification
Udemy Learning- The Complete Developers Guide(MYSQL,PostgreSQL)
Timeline
Business Analyst | Database Administrator
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
Udemy Learning- The Complete Developers Guide(MYSQL,PostgreSQL)
Informatics and Computer Science -
Strathmore University
Similar Profiles
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
Nurhima SabalNurhima Sabal
Project Engineer at GNA Tawi-Tawi Home Development CorporationProject Engineer at GNA Tawi-Tawi Home Development Corporation