Skip to content

Edkiiru/Portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 

Repository files navigation

Edward Kiiru - Career Portfolio

Table of Contents

  1. Introduction
  2. Work History
  3. Projects
  4. Skills
  5. Education and Certifications
  6. Contact

Introduction

I am a dynamic and highly skilled Business Analyst with a BBA in Management Information Systems and over nine years of expertise in leveraging data to drive strategic decision-making. Proven track record in designing and implementing KPI dashboards, optimizing ETL workflows, and delivering tailored technical solutions that align with business objectives. Excels in collaborating with cross-functional teams, streamlining processes, and driving measurable operational improvements through innovative data analysis and insights.


Work History

Business Analyst, Bighorn Freight

  • Ensured data quality and consistency through data investigation and wrangling.
  • Managed ETL processes within MS Fabric, facilitating seamless integration of data from various sources.
  • Designed and developed KPI dashboards and reports using Power BI and SSRS, providing actionable insights for stakeholders.
  • Automated reporting workflows, enhancing data accessibility and data-driven decision-making.
  • Selected and adapted existing programs, structuring data formats to solve problems effectively.
  • Led a continuous improvement initiative, achieving a 25% reduction in operational costs and a 30% increase in efficiency.

Operations Analyst, GENEM LOGISTICS LLC

  • Managed data acquisition, processing, analysis, and reporting using Power BI and Excel power tools.
  • Oversaw daily trucking operations including schedule management, inventory tracking, and invoicing.
  • Implemented process improvements, resulting in streamlined business operations.

Operations Manager, QWETU INC

  • Oversaw comprehensive business management including fleet maintenance, Compliance, Operations and client relations.
  • Optimized profitability and productivity while ensuring regulatory compliance.

Projects

Developed a data-driven recommendation system identifying federal contract-winning companies likely to need data contracting services. This solution streamlined outreach efforts, fostered partnerships, created job opportunities, and provided hands-on experience for Colaberry interns.

This full ETL-to-visualization project cleaned data from diverse sources, created ingestion pipelines using SSIS, built staging databases and warehouses in SQL, and culminated in reporting and visualization using SSRS.

Integrated data sources for a trucking and logistics business to create reports and visualizations. Leveraged Microsoft Fabric, Data Factory, and Notebooks for ETL and Power BI for reporting.

Analyzed chronic disease datasets (2008–2021), revealing trends and patterns. Included stratification by demographics and time-based analysis.

Extracted, processed, and stored job descriptions using Crew AI's multi-agent platform. Tasks included data extraction, feedback collection, adaptive learning, and task orchestration.


Skills

  • Data Analysis: Power BI, SQL
  • Data Integration: SSIS, ETL
  • Machine Learning: LangChain, RAG Implementation, Crew AI
  • Cloud Platforms: Azure, Databricks
  • Cybersecurity: Cryptography, Threats & Vulnerabilities, Governance and Compliance (GRC), Cloud Security, MS Security Copilot, MS Entra
  • Other Skills: Problem Solving, Solution Architecture, Deployment and Maintenance

Education and Certifications

Data Analytics
Colaberry School of Data Analytics– Plano, TX

Bachelor of Business in Management Information Systems
Amberton University – Garland, TX

Associate of Science in Business
Richland College – Richardson, TX

Diploma in Computer Studies
Starehe Technical Institute - Nairobi, Kenya

Certifications:

  • CompTIA A+
  • CompTIA Security+
  • Microsoft Certified: Power Bi Data Analyst Associate
  • Microsoft Certified: Azure Data Fundamentals

Continuous Education:


Contact


About

No description or website provided.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published