A Glimpse Into My Journey
Below is a list of projects that I have built or contributed to.
Site Labour Forecasting Tool | North American Construction
Managing job sites around North America requires organization and coordination. At NAC, I contributed to a digital pipeline that allows users on-site to enter relevant data and have a dashboard update dynamically.
Technology Covered
- Automated SQL ETL jobs that generates a staging table
- Advanced Power Apps and Power BI usage.
- Python scripting for automation tasks.
- Examples: Balance Sheet Report
Part-Time Instructor | Data Analytic Tools for Business Decision Making
This course focuses on the practical implementation of the ETL process from end-to-end. We cover topics such as data types, how to set up a local database, data transformations/aggregations and best practices in Data Storage.
Technology Covered
- SQL, Python (pandas, SQLAlchemy, pymysql)
- MySQL Server, MySQL Workbench
- Visualization Tools (Power BI)
COVID-19 Impact Dashboard | Canadian Memorial Chiropractic College (CMCC)
This reporting mechanics helps manage all reported cases, split between Employees, Students and Faculty and acts as a single view into how the institution is doing.
Technology Used
- Input: Microsoft Forms
- Logic Layer: Power Automate
- Output: Power BI
Clinical Activity Dashboard | CMCC
This dashboard informs the Clinic Management Team of all the experiences across their 7 clinic system. This information is useful for numerous purposes whether it be for managing student experiences or reporting to the board or supporting clinical success.
Technology used
- SQL Server Management Studio, T-SQL
- Python
- pandas, pygsheets
PPE Inventory App | CMCC
A tool used to view current inventory, order more supplies and report the history of each PPE item through a PowerApp embedded in Teams.
Technology used
- Microsoft PowerApps integration with Teams
- Microsoft Sharepoint
- Microsoft PowerBI
Twitch Streamer Analytics - Famerly
Developed some of the early data mining scripts based on the Twitch API that involves a scheduled data extraction , retreiving and analyzing collected data and presenting the results in a visualization for consumer use.
Technology Used
- AWS RDS & EC2 Server (Hosting Script, running Cron Job)
- Python/pandas/SQL stack
- Cloud server management
Sentiment Analysis on Student Feedback - GCP NLP API
Every year, CMCC sends out an anonymous ‘Exit Interview’ to the graduating class to gather feedback, extract trends among the responses and use the trends to improve the experience each year. This presents an ideal problem for Natural Language Processesing to build ‘themes’ for as we have a dataset of open-text and the need to extract insights about it.
Technology used
- Python
- pandas
- natural language API
- Google Cloud
Business Intelligence
Scripts to automate error-prone tasks and optimize data processing. These scripts are useful to ensure no human-errors occur on simple, recurring tasks.
Balance Sheet
- Current: ERP system provides robust but stable reporting solution
- Need: To be able to customize the reporting, and extend functionality.
- Solution: “Tie in” to the same Data Mart as the Jonas Construction DM, and reproduce with Python.
- Allows for full customizability.
Workbook
- Instead of asking each student to submit their clinical metrics monthly, why not extract them directly?
- This script is being developed to calculate clinical metrics directly.
cleveland_analytics
- This enhanced version now includes the intern’s comments grouped and directly embedded in the script export.
- Previously, a secondary process of integrating the comments was required.
Financial Summary
- Many times, human error is accountable for mistakes made when running simple reporting.
- This script automates the calculation of each of the financial metrics to ensure consistency.
Operational Scripts
This repo contains scripts that are meant to improve operational efficiency. These scripts will primarily be written in Python or Excel VBA - Little to No Coding experience is required to run these scripts.
BA- Related
- Large File Analysis - Repo
- RAC MACRO - POS Auditing
- CLR - Audit Script
- Extract Clean Data - CLR Column Issue
- Top 5 Partner - YTD Report
- Monthly YTD Report
- Quarterly CLR
- Weekly Channel Mapping Report