Jan 2019 - Mar 2020
Vertech
DEPCOM Power
Renewable Energy
As the sole resource on this project, I was in charge of designing and delivering the system to the client. The goal was to create an analytics system capable of replacing Depcom's current Excel workbook system, which was used by their performance engineers to relay aggregated data from various local sites to upper management and the owners/providers of the sites. Excel is a great software, but it has its limitations, especially with an company starting to accumulate too much data in their local historians. We chose to use SeeQ, a software used in the automation industry to consume time-series process data and signals, and capable of some advanced signal smoothing, aggregation techniques, and some machine learning (e.g. Linear/Polynomial Regression, Principal Component Analysis (PCA), etc.). I created a regex mapping file to create an asset tree out of all of their solar sites, and isolate the most important signals needed for the final analyses. I then proceeded to create the analysis for one of the sites (the most complex) to completion, and then swapped the site asset to test model viability for all of the other site assets. I am a published author on this topic, in an high-level overview article published by ControlsPR for SeeQ. If you are interested, feel free to contact me and I can help you find it.
Seeq, MSSQL