Hello, I’m Terrence. I’ve worn a lot of hats in my life, from leading a team of international power technicians in an active war zone to running my own businesses and now leveraging my extensive experience, university education and certified skills towards an analyst role.

I’m a whiz with excel, a workhorse in SQL, experienced with Python, in love with Power BI and overall a friendly, flexible, driven and curious person.

I’m passionate about the environment, cultural exchange, alt energy and technology. I cook a solid Gallo Pinto, do an ok breast-stroke and drink too much coffee.

Education

Environmental Economics (B.S.) :: Michigan State University
Power Technology Diploma :: MIAT

Certifications

East Bay Area Residential Water Use

  • This project was completed as the capstone for my Data Analysis focus at Michigan State University.

  • It analyzes residential water use trends in the East Bay Area of San Francisco over the 2012-2019 drought.

  • Tools: Python (pandas, seaborn, numpy), Excel, Power Point.
    Github Link :: Blog Link

Web Scraping, Costa Rica real estate

  • This project scrapes the real estate data on over 1300 houses in Costa Rica from Coldwell Banker’s Tamarindo office website. Data is then wrangled, cleaned and transformed resulting in a clean data set ready to be imported to an SQL server.

  • Tools: Python(BeautifulSoup, requests, regex), Excel (search and replace)
    Github Link :: Blog Link

Excel Dashboard

  • This is a minimalistic, functional dashboard made in Excel.

  • It expands the raw data to generate key performance indicators which are then visually presented and can be dynamically parsed by category.

  • Toos: Excel (pivot tables, nested functions, graphs, slicers)
    Github Link :: Blog Link

Financial Analysis: Public Utilities

SQL Certification Practice

  • Some example queries using SMSS as practice for Intermediate SQL Certification from LCC.

  • Tools: SMSS, SQL (multiple joins, aggregate functions, filtering)
    Blog Link

  • This project audits and edits an excel file regarding mixed use road lanes created without considering accessibility so that it adheres to best practices for including those with visual and reading issues.

  • Tools: Excel (formatting, accessibility principles)
    Github Link :: Blog Link

Accessibility Audit

Data Mining, Costa Rica real estate

  • A report generated for the Lansing Board of Water and Light on some of their KPI’s and financial ratios as well as a 5 year cash flow projection.

  • Tools: Excel (formatting, projection graphing)
    Blog Link

  • This project continues from our web scraping - loading the data we harvested onto a SSMS database for SQL querying/joining, then uses our results to build out a report in Power BI to gain insights.

  • Tools: SSMS, SQL (joins, cleaning), Power BI (mapping, drill-through, conditional formatting, slicing).
    Report Link :: Blog Link