HELLO, I'M
Kevin Ndungu
AWS Certified Solutions Architect | BI Developer | Data Analyst
Kevin Ndungu
Cloud Services
AWS | AZURE | GCP
About
MY BACKGROUND
As a certified Solutions Architect and skilled Data Engineer and Analyst, I bring a wealth of experience in data engineering tools, modern ETL processes, data warehousing, and pipeline deployment. My expertise lies in delivering actionable insights and business intelligence that drive informed decision-making and foster growth. Committed to driving transformative change, I excel in implementing agile, data-driven solutions that empower businesses to gain a competitive edge.
PORTFOLIO
Welcome to my portfolio, a showcase of data-driven projects reflecting my proficiency in both Business Intelligence and Data Analytics and aspects of cloud Data Engineering. Each project highlights my dedication to delivering insightful solutions by leveraging cutting-edge technologies and robust data infrastructure. Feel free to explore each project to gain insight into the multifaceted nature of my skills in the realm of data analytics and engineering.
Technical Skills
WHAT I BRING TO THE TABLE
§ Business Intelligence (BI) platforms: PowerBI - Microsoft Fabric's Synapse Family, Tableau and Qlik Sense.
§ Cloud computing techniques: AWS, Infrastructure as Code (IaC), GCP, Azure.
§ Database Systems: Azure Data Studio, SSMS, MySQL Workbench.
§ Data Warehousing: Amazon Redshift, Google BigQuery, Microsoft Azure Synapse Analytics. (OLAP)
§ BigData Processing platforms: EMR & EMR Serverless for Apache Spark, Hadoop.
§ A.I and M.L services: Amazon Bedrock Foundational Models (FMs) for Natural Language Processing (NLP) and LLMs.
§ Statistical Software: SPSS, STATA.
§ Productivity and collaboration tools: Office 365, Slack, Microsoft Teams, Google Workspace. | CRM - Salesforce. | ERP - SAP.
§ Programming languages: SQL - MySQL & PostgreSQL (OLTP & OLAP), & Python. | Version Control - Git and GitHub.
§ Project management: Backlogging workflows using ClickUp or Jira.
§ Teamwork (Cross--functional): Acquainted with the Software Development Life Cycle (SDLC) and Agile methodologies.
PROFESSIONAL LANGUAGES SPOKEN
English.
Swahili.
Professional Experience
WHERE I’VE WORKED
Oct. 2022 – To date.
SILENT NIGHT BEDDING Ltd.
Solutions Architect | BI Developer | Data Analyst.
• Implemented Kimball's Star schema for database design, improving data organization and retrieval efficiency by 25%. Enhanced data warehousing processes, boosting query performance and supporting robust business intelligence and analytics. • Leveraged AWS cloud services with cross-functional teams for data engineering, ETL, and analytics, reducing data processing time by 30% and increasing data accuracy by 25%. • Implemented AI and ML algorithms to analyze customer feedback, using NLP to derive actionable insights, resulting in improved customer experience strategies and a 20% increase in customer satisfaction. • Collaborated with stakeholders to craft insightful dashboards, enhancing decision-making processes for sales and strategies. • Teamed up to develop data models using business intelligence tools (PowerBI, Tableau), improving data processing efficiency by 40% and reducing storage space utilization by 20%. • Contributed to operational efficiency leading to improvements by 20% through scalable data pipelines and automated workflows, enhancing real-time analytics for strategic decision-making.
May 2021 – Aug. 2021
KOPO KOPO Inc. (FinTech)
Data/Credit Analyst.
• Collaborated with the credit team to streamline data flow processes, enhancing overall analysis efficiency and accuracy. • Utilized NLP techniques on customer transaction data to predict credit worthiness, enhancing the accuracy of credit risk assessments and improving loan approval processes. • Led KYC data clean-up in collaboration with Safaricom, increasing merchant onboarding rate by 20%. • Developed dashboards for loan performance and delinquency overwatch, facilitating automated loan transfers to productive businesses. • Conducted predictive trend analysis for merchant transactions, improving forecasting accuracy by 25%. • Optimized Tableau Data models, reducing data processing time by 15%.
Education
WHAT I’VE LEARNED
2023 – 2024
AMAZON WEB SERVICES (AWS) ACADEMY - ALX Africa
AWS certified Cloud Practitioner and Solutions Architect.
2022 – 2023
CORPORATE FINANCE INSTITUTE (CFI)
-
Earned a BIDA certification in Business Intelligence & Analytics.
-
Earned an FMVA certification in Financial modeling and valuation analysis.
2020 – 2020
INTERNATIONAL BUSINESS MACHINE (IBM) – DATA SCIENCE FOUNDATION
Earned a digital credential in Data Science.
2015 – 2018
Jan. 2020 – April 2021
UNIVERSITY OF NAIROBI
Bachelor's Degree in Economics and Statistics.
UNBOUND KENYA (Non-profit organization)
Data officer.
• Developed detailed reports on program impacts, aiding in resource allocation and strategic planning. • Worked with field teams to ensure data accuracy and comprehensiveness, improving the quality of socioeconomic analyses. • Utilized CAPI systems to gather satisfaction data, enhancing targeted intervention effectiveness by 20%. • Collected and analyzed data to provide insights into socioeconomic conditions, supporting targeted interventions for poverty-related issues. • Collaborated with data scientists to boost beneficiaries' performance rate by 15%.
Jan. 2019 – Dec. 2019
KENYA REVENUE AUTHORITY (KRA)
Data Analysis Intern.
• Worked with the corporate data office team to streamline data collection and analysis processes, increasing overall efficiency. • Designed statistical analysis models for taxpayer data, improving tax collection efficiency by 12%. • Collaborated on reporting taxpayer data using Jasper-soft, enhancing service provision to taxpayers by 15%. • Assisted in developing dashboards for visualizing key tax metrics, aiding in strategic decision-making. • Used PowerBI, Excel, and SQL to track tax trends, contributing to a 10% increase in tax revenue.
