kitestring
Accomplished scientific programmer specializing in data engineering, visualization, & analysis. Stack includes Python, SQL, Java, JavaScript, VBA, HTML & CSS.
St. Joseph, Michigan
Pinned Repositories
B-LacBarcoding_08-21-2009
Mines spectrometry data from 4 tab delimited text files exported from a series of 4 blood analyzer units. From this data, calibration constants are calculated which are used to generate a barcode for the corresponding lot of sensors.
B-LacKineticTraceAnalyzer_04-10-2008
ETL kinetic data in the form of % transmittance and plots the 2nd derivative to monitor the behavior of the Lactate blood sensor being developed.
BackupTools
An automated backup tool to provide our customers free software to back up their instrument databases which typically exceed 1TB.
BowlingDataCenter
Python application I wrote for fun. I wanted to learn how to make a dash board using python 3, tkinter and matplotlib. I used csv files extracted from my bowling league website as the source data.
CDxSlideCalibration_11-06-2008
Mines spectrometry data from 24 csv files exported from a series of 3 electrolyte blood analyzer units. From this data, calibration constants are calculated which are applied to the corresponding lot of electrolyte sensors.
ChemicalAnalyzerSoftwareTrainingWebsite
A website to provide a far more efficient mechanism of training our customers, than in a class room setting. The instrument software is highly complex and requires a strong background in chemistry to operate. It is unreasonable to expect customer to figure it out on their own.
DataQuest
Data Science Massive Open Online Course: All the code, notes and supplementary materials generated during the course of my data scientific learning.
DetectorStressQuantification
ETL flat data exported from a Chemical Analyzer instrument (TOF-MS). While the data is still in memory, data is cleansed and linked so that primary and foreign keys can be generated prior to loading into a Postgres managed database using a Star schema. A CLI is implemented to query the DB to generate customizable data visualizations.
SciData
Extracts and cleanses flat data exported from a Chemical Analyzer instrument (Time of Flight Mass Spectrometer), then loads data into a SQL database using a Star schema. A basic CLI is implemented to query SQL database to create data visualizations which describe instrument performance in a simple and digestible manner. The following python libraries are utilized: numpy, pandas, matplotlib, sklearn, statistics, sqlite3, os, time, & datetime.
TimeTrax
This application is a tool designed to help our Service Department managers allocate their man hour resources more efficiently. It enabled projects to be better managed by accurately estimating timelines, proactively identifying deficiencies, and furthermore it successfully lobbied upper management to increase team head count.
kitestring's Repositories
kitestring/DataQuest
Data Science Massive Open Online Course: All the code, notes and supplementary materials generated during the course of my data scientific learning.
kitestring/B-LacKineticTraceAnalyzer_04-10-2008
ETL kinetic data in the form of % transmittance and plots the 2nd derivative to monitor the behavior of the Lactate blood sensor being developed.
kitestring/BowlingDataCenter
Python application I wrote for fun. I wanted to learn how to make a dash board using python 3, tkinter and matplotlib. I used csv files extracted from my bowling league website as the source data.
kitestring/SciData
Extracts and cleanses flat data exported from a Chemical Analyzer instrument (Time of Flight Mass Spectrometer), then loads data into a SQL database using a Star schema. A basic CLI is implemented to query SQL database to create data visualizations which describe instrument performance in a simple and digestible manner. The following python libraries are utilized: numpy, pandas, matplotlib, sklearn, statistics, sqlite3, os, time, & datetime.
kitestring/B-LacBarcoding_08-21-2009
Mines spectrometry data from 4 tab delimited text files exported from a series of 4 blood analyzer units. From this data, calibration constants are calculated which are used to generate a barcode for the corresponding lot of sensors.
kitestring/BackupTools
An automated backup tool to provide our customers free software to back up their instrument databases which typically exceed 1TB.
kitestring/CDxSlideCalibration_11-06-2008
Mines spectrometry data from 24 csv files exported from a series of 3 electrolyte blood analyzer units. From this data, calibration constants are calculated which are applied to the corresponding lot of electrolyte sensors.
kitestring/ChemicalAnalyzerSoftwareTrainingWebsite
A website to provide a far more efficient mechanism of training our customers, than in a class room setting. The instrument software is highly complex and requires a strong background in chemistry to operate. It is unreasonable to expect customer to figure it out on their own.
kitestring/DetectorStressQuantification
ETL flat data exported from a Chemical Analyzer instrument (TOF-MS). While the data is still in memory, data is cleansed and linked so that primary and foreign keys can be generated prior to loading into a Postgres managed database using a Star schema. A CLI is implemented to query the DB to generate customizable data visualizations.
kitestring/TimeTrax
This application is a tool designed to help our Service Department managers allocate their man hour resources more efficiently. It enabled projects to be better managed by accurately estimating timelines, proactively identifying deficiencies, and furthermore it successfully lobbied upper management to increase team head count.
kitestring/DayToDayInstrumentStability_08-25-2016
Mines chromatographic data from 3,000 tab delimited text files exported from our Time of Flight Mass Spectrometer chemical analyzers and upload the relevant data to a SQL database. Then query and view the data by automatically dumping and plotting into an excel file.
kitestring/DFTPP_SpectralAnalyzer
ETL the relevant data from thousands of tab delimited text files exported from our Time of Flight Mass Spectrometer chemical analyzers into an SQL database. The xlswriter python library is utilized to generate the data visualizations.
kitestring/DragonSlayer
The first application wrote using python. Which is a game modeled after one of my childhood favorites called Dragon Warrior on NES.
kitestring/hello-world-1
Indroducing myself to the community.
kitestring/KeepingSharp_SQL_06-08-2017
It's been too many months since I've written any code and I'm getting antsy. The purpose of this repository is to keep my skills sharp.
kitestring/ManHourTracker_Beta_04-11-2016
This application is a tool designed to help our Service Department managers allocate their man hour resources more efficiently. It enabled projects to be better managed by accurately estimating timelines, proactively identifying deficiencies, and furthermore it successfully lobbied upper management to increase team head count.
kitestring/MediaLibrary
kitestring/MortageTracker_04-19-2013
Mines financial data from a *.csv file that I download from the financial institution which holds my mortgage. This tool provides valuable information relative to my financial planning.
kitestring/Playing-with-Git-Hub
Learning to use GitHub
kitestring/PreventativeMaintenanceManager_03-10-2014
Customers who purchased a service contract for their Time of Flight Mass Spectrometer received an annual Preventative Maintenance (PM) site visit. This automates tracking when a given customer was due for PM and what field service engineer was assigned the task based on their location.
kitestring/Reproducibility_08-15-2011
ETL the user defined mass spectral data from “n” .*csv files exported from our Time of Flight Mass Spectrometer chemical analyzers. The data is listed in tables, plotted and basic statistics are calculated. This allows me to draw conclusions on the functionality of the instrument.
kitestring/TimeTraxTrends_06-25-2017
An upgrade to TimeTrax. It adds more powerful querying capabilities allowing the user to define the query conditions to output a scatter plot that visualizes the number of hours worked, on the user defined task per month, for the user defined employee(s).
kitestring/VBAMacroQuickStart
Handy Stuff When I write VBA Macros in Excel