Portfolio

Programs

WCF Client Application

Designed and developed a system used to identify, collect, and schedule batch pushing of logged sensor data. Pushed data was processed and transformed prior to insertion into our cloud database. The program was deployed as a Windows Communication Foundation (WCF) service hosted in a managed Windows Service. This allowed for a highly resilient worker service that pushed data even when a user was not logged into the Windows workstation. The system was capable of collecting data from Microsoft SQL Server, SQLlite, PostgreSQL, and XML datasources.

Card Access System and Personnel System Integration Service

Designed and Developed a system dedicated to parsing data from multiple systems (Banner's student information system, and OneCard's Campus Student ID Card Systems) and committed changes to Continuum using Continuum Report's PDI application. The Windows service created for this task served as an integration layer between several independent systems. The processed updates were used to control building and door proximity card access for all faculty and students.

Travel Distance Payment Calculator

Developed an Azure Function used to calculate employee travel pay reinbursement for jobsite visits. This function ran daily examining all job addresses associated with active job codes for the week. Distance from jobsite locations was calculated for each Tri-M office location using Google Map's API. Based on an employee's designated Tri-M office and charged job codes for the week they recieved travel pay automatically. Data was stored economically in Azure Tables.

Yahoo Weather Data Retrieval Service

Created a Windows Service dedicated to retrieving weather data using Yahoo's Weather API. The service's health and the datetimes of each location's most recent weather report were sent out via daily emails. The retrieved weather reports were saved to a cloud server in xml format and made accessible for dashboarding purposes.

Excel 64 bit compatible batch conversion application

Wrote a simple program that examined and edited 1.3 million excel files on the company's network drives. The program replaced sections of VBA code that were incompatible with Microsoft's 64-bit version of Excel. All changes were logged and reversible.

Verified System Reporting Tool

Worked on developing an application used to audit research laboratory room conditions. The application generated a wide range of reports documenting when locations or sensors deviated from their permitted threshold values. Reports could be generated in HTML or PDF format. Reports could also be sent directly to the workstation's default printer once generated. Users could login to add or remove locations and sensors. Users could also configure individual sensor's high and low threshold values.

Power Automate Flow - Vacation Requests

Created a Power Automate flow to automate and streamline the process of submiting vacation requests. The Power Automate Flow utilized Microsoft Teams Aprovals, Office 365 Mail, and Sharepoint connections.

Dashboards

Facility Fault List Dashboard

Developed a dashboard to display building specific data to assist continuous commissioning efforts. The dashboard displayed kWh consumption data and a list of high priority faults for a given time frame. The faults identified were spans of time in which the building automation system's operation deviated from its programmed sequence of operations.

Facility Energy Dashboard

Developed a dashboard to display site wide aggregated energy data. This dashboard was deployed in a corporate lobby and rotates through all screens in a few minutes. In addition to showing energy data the dashboard displays a weather forecast and several screens showcasing the green features of the building.

Utility Usage Breakdown Dashboard

Developed a dashboard to display utility usage data grouped by the type of tenants that consumed the energy. Dashboard could be configured to display kWh, kBTU, or EUI data.

Mobile

Tri-M Group Solar Energy Dashboard

Developed a dashboard for displaying corporate announcements, energy consumption, and solar production data. This dashboard was developed using the Godot 3 game engine. In addition to being displayed in a lobby setting, this dashboard was also deployed to IOS and Android devices.

Safety Audits

Developed a mobile application to allow workers in the field to complete safety audits. Digitizing the safety audit allowed the company to analyze and identify safety concerns in near realtime. Allowing users to upload photos helped the company document good and bad conditions at customer sites. Sites with a high number of reported issues were prioritized for investigation.

Password Policy Management

Developed a mobile application that allowed active employees to retrieve passwords for customer sites. Once users authenticated through Office 365 they would be presented with a list of sites. Each site contained unique password policy information and the application allowed administrators to restrict user access on a site by site basis.

Websites

BASApp

Developed in C# utilizing the MVC framework. This application assisted Engineers, Estimators, and Project Managers by generating documentation. In operation for over 9 years, the BASApp has saved countless hours of documentation. The BASApp also served as a data pipeline for each phase of the building automation system project lifecycle. Data entered during project estimating was exportable as a dmp or xml file for Continuum and EcoStruxure systems as the starting point for the engineering department's projects.

Tri-M Group Corporate Website

Redesigned in 2017 as a mobile friendly website using C# and the MVC framework integrated with the Umbraco CMS. In addition to simple pages promoting each business unit, there were also pages with custom backend integration. For example, there was integration with BambooHR for job postings, integration with LinkedIn for social media, custom code for registering for on-site customer training, and custom code for the "Contact Us" page.

EnerG Test Corporate Website

Redesigned in 2018 as a mobile friendly website using C# and the MVC framework integrated with the Umbraco CMS. Due to the size of the business, this website was built with more of a one page layout in mind. There was backend integration with BambooHR for job postings, integration with LinkedIn for social media, and custom code for the "Contact Us" page.

Building Automation System Data Extraction

This web application integrated with multiple views and procedures to extract data from a variety of sources. For example: Continuum, PME, EcoStruxure SQL Server, EcoStruxure TimeScaleDB, EcoStruxure Security Expert, and ResidentGaurd systems. In some cases data was joined between different database engines like Microsoft SQL Server and PostgreSQL on demand. Data was returned to the user in either PDF, Excel, CSV, or JSON format.

Energy Usage Web Portal

Developed an interactive web portal integrated with the SkySpark analytics engine. This web portal displayed energy consumption and equipment deviation data. The landing page integrated with Google maps to show buildings with energy performance issues at a glance. Year over year performance data was also displayed to show performance trends. The web portal also displayed deeper insights like a list ranking of improperly performing equipment by its estimated cost to the customer.

Curious By Nature Website

Created a wordpress website for a local business that provides hands-on exeperience rich classes for children and parents. The website was integrated with a ticket sales platform called TicketTailor to facilitate the sale of class tickets. Collaborated with the business owner on website design and the implementation of ad-hoc features.

Reports

Engineering Department Time Charged Vs Estimate - Power BI

Constructed a dynamic report to display employee charged time on tasks against job estimates for those tasks. Multiple tabs provided several different views for management to review. Worked closely with management to understand their needs and objectives. Wrote SQL views to merge data from multiple datasources into one common report.

Script Ladder Diagram Generation - AutoCad

Developed a system to generate native AutoCad draw commands from imported facility control system exports. The ladder diagram drawn was snapped to a grid and written using AutoCad blocks and line drawing commands. Bill of material information could also be printed at this time from data that was previously imported into the system.

Input Output Sheets - SSRS

Generated reports from a SQL Server datasource using SQL Server Reporting Services. Reports generated assisted the Engineers, Estimators, and Project Managers in their documentation. Roughly forty reports were created for various departments. Most reports displayed tabular data formatted for printing in ANSI Letter or Ledger format.

SkySpark

Generated several daily digest reports for SkySpark to assist Facility Managers in their review of critical sensor data. Reports also commonly contained simple KPI measures and fault lists. The SkySpark analytics engine was well suited for the processing of large amounts of historical data to catch trends and drifts in system performance over time.

BAS Analytics Reports

Swivel Apps

Created dashboards and views leveraging SkySpark's view engine. Integrated with SkySpark data to display building automation system data to users. Views were interactive and allowed users to specify custom date spans and specify systems to be analyzed.

Resume - Jason G. Ladley

jason@jasonladley.com

Senior Software Engineer

The Tri-M Group, LLC.
Kennett Square, PA
July 2011 – Present

Founding member and lead software engineer for Tri-M's Analytics division.
- Developed software to batch push logged sensor data from facility management systems to a centralized server. Software was deployed as a Windows Communication Foundation (WCF) service hosted in a managed Windows Service with a separate WinForms GUI used for configuration. A MySQL database hosted on an AWS ec2 instance was used in the Extraction Transformation and Loading (ETL) of over 2.5 billion historical records.
- Created a reusable data dashboarding product developed on top of the Godot game engine. Developed a REST API to integrate these dashboards with the SkySpark analytics platform. Dashboards were deployed to Windows, IOS, and Android devices.
- Led the initiative to develop an IoT asset monitoring web portal that provided continuous commissioning guidance to facility owners. Any period of time where facility equipment was operating improperly was identified and presented to the user prioritized based on cost. The web portal was written in C# ASP.NET MVC and integrated with the SkySpark analytics platform via a custom REST API.
Pitched to senior management the idea of a web application that would be used to automate the generation of critical customer documentation. Developed a solution from scratch that would ingest data directly from facility control system dump files to produce documentation. The web application was written in C# ASP.NET MVC with a Microsoft SQL Server database. Reports were built and generated with SQL Server Report Builder.
Redesigned the corporate websites increasing mobile traffic by 45% and overall site traffic by 40% in just two years. Deployed the Umbraco content management system and built flexible templates allowing the Marketing team to manage content without my intervention as the webmaster. Administered and managed the company's AWS account for the corporate websites and for the Analytics division.
Rolled out and managed Azure Devops Git Repos improving collaboration between developers and adding visibility into project progress for management.

Software Engineer

Lockheed Martin IS&GS – Security
Gaithersburg, MD
May 2010 – June 2011

Developed backend functionality for IEC's imagery library driver coded in C++. Implemented functionality for multiple libraries, multiple users, exception testing, stress testing, and availability delay.
Added support for both Windows 7 and Windows XP platforms to PISCES a software delivery tool that automated the installation of software packages and managed dependencies. Developed using VBScript and VB.net.
Created a configurable Perl script used to monitor the performance of Solaris 10 servers for system administrators.

System Integration/Test Engineer Associate

Lockheed Martin IS&GS – Intelligence
King of Prussia, PA
July 2008 – May 2010

Developed a data entry web application that interpreted our database's logical schema and automatically generated the user interface for Create, Read, Update, and Delete operations.
Coded application logic, web services, user reports, and diagram generation scripts in Adobe ColdFusion 8.
Wrote SQL scripts which scrubbed and imported data from legacy databases and spreadsheets.

EDUCATION

MS — Software Engineering

Penn State School of Graduate Professional Studies
Great Valley, PA
August 2009 – May 2013
GPA: 3.89

BA — Computer Science–New Media

Taylor University
Upland, IN
August 2004 – May 2008
GPA: 3.77

PROFICIENCIES

Experience with C#, VB.net, ASP.NET MVC, Java, C++, C, CORBA, Fantom, Axon, GdScript, VBScript, VBA, PowerApps, PHP, Perl, JavaScript, jQuery Framework, CSS, and HTML5.
Database designer and administrator Microsoft SQL Server, MySQL, PostgreSQL, Oracle, SQLite, and Apache Derby databases.
Competent working in Visual Studio, Eclipse, VI editor, Godot, SkySpark, Power BI, Photoshop, MS Report Builder 3.0, Azure Devops, Microsoft SQL Server Management Studio, MySQL Workbench, MSSql Maestro.
Understanding of OOAD, Software Patterns & Tactics, Agile Methodologies, and Data Structures.

CERTIFICATIONS

SEI Software Architect Professional Certificate Holder
AWS Certified Solutions Architect – Associate

SECURITY CLEARANCE

Top Secret/Sensitive Compartmented Information (Active from August 2008 to June 2011)

References available upon request.