Darren Cloutier
Software Architect/Executive particularly interested in Enterprise Application Integration using packaged tools as well as architecting custom solutions. Specialties - Integration, Architecture, ETL, DataStage, Java/J2EE, Supply Chain, Business Intelligence, Software Project Management, Teradata, SQL, Database Design, Analytics, Oracle, LAMP Stack (Linux/Apache/MySQL/PHP).
Personal Projects:

Thermostat Data Warehouse (ThermoTweet)
Leveraging the API in my two Nest thermostats installed in my home, I wrote ThermoTweet to initially post to Twitter the current temperature as well as the status of the thermostat whenever the heat was turned on or off. While this was interesting for sometime, it quickly became apparent that the real value of gathering this data was storing it for analysis over time. ThermoTweet was then transformed into a data warehouse for temperature and thermostat data within my home. Tracking the temperature, target temperature, heat on/off and hold/override settings of each thermostat has provided valuable data and allowed us to adjust our thermostat schedules to provide us with peak comfort and savings. ThermoTweet is written entirely in a LAMP stack with a component on my LAN parsing the JSON data from the local thermostats and transferring this data to my VPS where subsequent programs transform, store and report on it. ThermoTweet has performed 877,774 data readings between 2012-02-01 and 2019-08-24 (Data Last Updated: 2019-08-24 16:10:02).

iTunes Dashboard
The itunes dashboard reports on my listening habits across all my iOS devices. A local component runs on my LAN parsing iTunes' itunes.xml file and transferring the details to my VPS. There a subsqeunt program translates this data into a normalized database where reports are run against it. iTunes dashboard is again written fully in the LAMP stack. iTunes Dashboard currently has statistics for 37,698 unique songs (94,303 song plays!) with play data from 2007-07-13 to 2019-08-24 (Data Last Updated: 2019-08-24 08:44:13).