Data Analyst

Making data simple, meaningful, and actionable.

Hi, I'm Teresia Mwangi, a data analyst with a curiosity grounded in real-world operations. I love uncovering patterns and insights hidden within data, specializing in SQL, Power BI, Excel, Python and the full analysis lifecycle to turn raw information into clear, actionable intelligence.

3+ Years Experience
6+ Projects Completed
2 Industries Explored
SQL Power BI Python Excel
Data Network Visualization

More Than Just a Data Analyst

I believe in the power of curiosity, integrity, and human-centered insights.

I don't just analyze data; I understand where it comes from—and the people it serves.

My journey began not behind a screen, but on the ground in procurement and warehouse management. While managing inventory and coordinating with teams, I learned that every data point represents a real decision, a bottleneck avoided, or an opportunity seized. This hands-on experience taught me to ask better questions and to never lose sight of the human impact behind the numbers.

With a background in Economics and Finance, I naturally gravitate toward insights that matter—those that drive ROI, unlock efficiency, or illuminate hidden patterns. But what truly drives me is curiosity: the desire to understand why things work the way they do, and how we can make them better.

Outside of work, I'm a lifelong learner who enjoys exploring new cultures, staying active, and finding creative ways to solve everyday problems. Whether I'm collaborating with a team or diving deep into a dataset, I bring the same values: integrity, empathy, and a commitment to continuous growth.

My Core Values

The principles that guide my work and life

Curiosity-Driven

I approach every problem with genuine curiosity, always asking "why?" and "what if?" to uncover deeper insights.

Integrity & Transparency

I believe in honest communication, ethical data practices, and building trust through consistent, reliable work.

Continuous Growth

I'm committed to learning, adapting, and evolving—whether mastering new tools or understanding diverse perspectives.

Portfolio

Explore some of my recent data analysis projects and case studies

Bank loan analysis

Bank Loan Analysis Dashboard

End-to-end analytics solution transforming raw banking data into strategic insights for portfolio management, utilizing a complete ETL pipeline.

SQL Power BI DAX Power Query
View Details
Maji Ndogo

Maji Ndogo Water Infrastructure

Interactive Power BI dashboard tracking $147M in water infrastructure investments, monitoring budget allocation and rural-urban resource disparities.

Power BI Data Modeling Budget Analytics SQL
View Details
retail_sales_analysis.sql
Retail Sales SQL queries

Retail Sales Analysis

Analyzed 2,000+ transactions over 24 months using PostgreSQL to uncover revenue patterns, a 162% seasonal surge, and a 64% evening revenue concentration — delivering strategic recommendations for inventory planning and staffing.

PostgreSQL SQL EDA Data Cleaning
View on GitHub

Professional Experience

Transforming operational data into actionable insights across diverse industries

Independent Data Analyst | Technical Projects

Personal Portfolio Development

2025 - Present
  • Bank Loan Analysis Dashboard: Built end-to-end lending analytics solution using MS SQL Server relational database and interactive Power BI dashboard, tracking loan performance, risk analysis, and financial KPIs using advanced DAX calculations and dynamic visualizations.
  • Water Infrastructure Analytics: Developed Power BI report analyzing $147M water infrastructure program effectiveness across five provinces, with interactive bookmark navigation and insights on spending efficiency and rural vs. urban resource allocation.
  • Retail Sales Analysis: Analyzed 2,000+ transactions using PostgreSQL, identifying a 162% seasonal sales surge and 64% evening revenue concentration, delivering strategic recommendations for inventory planning, staffing optimization, and customer segmentation.

Front-end Software Developer

FASI

May - August 2024
  • Debugged and optimized data flow between front-end interfaces and back-end APIs, improving application performance and reducing data loading times.
  • Collaborated in an Agile cross-functional team, participating in daily stand-ups, sprint planning, and code reviews using project management, planning, task tracking, and team collaboration.
  • Consumed and integrated RESTful APIs to display real-time data, strengthening understanding of database structures and the full data lifecycle.
  • Applied analytical problem-solving to troubleshoot software issues, translating technical requirements into functional user interfaces.

Warehouse Clerk

Iprocure Limited

September - December 2022
  • Managed and validated inventory data across 500+ SKUs using an ERP warehouse management system, maintaining 99% accuracy through systematic data quality checks and exception reporting.
  • Analyzed receiving and dispatch patterns to identify bottlenecks, supporting operational efficiency improvements that met 100% of KPIs.
  • Maintained the warehouse management system database, performing data entries and regular audits to ensure data integrity for supply chain decision-making.
  • Generated weekly inventory reports using Excel, tracking stock levels, identifying slow-moving items, and supporting procurement planning and supply chain operations.

Procurement & Stores Officer | Control Clerk

Marble Arch Hotel, Nairobi

August 2019 - July 2022
  • Managed end-to-end procurement operations including vendor sourcing, relationship management, purchase order processing, supplier performance evaluation, and contract negotiation to secure favorable terms.
  • Conducted regular market surveys and price comparison analysis to optimize costs.
  • Utilized hotel management ERP system for stock tracking, receiving, issuing, and logistics coordination across multiple departments.
  • Conducted daily and monthly stock reconciliation, cycle counts, and physical inventory audits while maintaining 99%+ accuracy in stock records.
  • Prepared and analyzed weekly and monthly performance reports for bar, restaurant, and stores operations, identifying trends in cost variance and revenue performance.
  • Controlled daily store issues and transfers across departments using ERP systems, conducting cost analysis and budget tracking to support management decision-making on pricing strategies and operational improvements.

Key Achievements

  • Optimized procurement processes resulting in improved vendor relationships and cost efficiencies.
  • Maintained inventory accuracy above 99% through systematic reconciliation and quality control procedures.
  • Delivered actionable insights through performance reporting that informed management decisions on pricing and operations.

Education & Certifications

Bachelor of Economics and Finance

Mount Kenya University

Relevant Coursework: Econometrics, Statistics, Financial Modeling, Quantitative Analysis, Microeconomics, Macroeconomics, Financial Accounting

Key Skills Developed: Statistical analysis, Financial modeling, Data interpretation, Economic forecasting, Quantitative research methods

Professional Certifications

ALX Certification in Data Analytics

ALX Africa • June - September 2025

Data Analysis Excel SQL Power BI

ALX Python Programming Certificate

ALX Africa • October - December 2025

Python OOP Matplotlib Pandas Numpy

Software Engineering Certification

Moringa School • March - November 2023

Full-Stack JavaScript React Ruby on Rails

Professional Foundations Certification

ALX Africa • March - May 2025

Leadership Communication Project Mgmt Teamwork

Technical Skills

Programming & Databases

Python SQL JavaScript HTML/CSS MySQL PostgreSQL MS SQL Server

Data Analysis

Power BI Excel DAX Statistical Analysis Data Modeling Pandas & NumPy

Tools & Technologies

Git GitHub Jupyter VS Code Power Query ETL Pipelines JIRA ClickUp ERP Systems

Business Skills

Data Storytelling Agile / Scrum Stakeholder Management Problem Solving Cross-functional Collaboration

Domain Expertise

Financial Modeling Supply Chain Analytics Stakeholder Management Cost Control

Get In Touch

Ready to unlock insights from your data? Whether you have a question or just want to say hi, I'm always open to discussing new projects and opportunities.