PROFESSIONAL SUMMARY:

• Seven years of experience automating data extraction, cleansing, loading, processing, analyzing, visualizing, and reporting using Python, SQL, VBA, Java, and Excel.
• Promoted to establish and head a newly created Product Validation department, with the goals of designing experiments to assess the performance and identify failure modes of unreleased Chemical Analyzers, and the software platform.
• Served as subject matter expert for the software interfaced to our Chemical Analyzers; responsibilities included: training, supporting internal & external customers, as well as the creation of advanced training materials.
• Supported R&D and QC in the development of blood analyzers in the Medical Device industry through laboratory testing and advanced data analytics which drove innovation and process improvement.

TECHNICAL SKILLS:

• Python
• VBA
• Java
• Matplotlib
• Seaborne
• Basemap
• Excel
• SQL (PostgreSQL & SQLite)
• API’s (requests)
• JSON
• Authentication (OAuth2)
• Web Scraping (Beautiful Soup)
• Text & Excel Files k - Nearest Neighbors
• Linear Regression
• Logistical Regression k-Means Clustering
• Cross Validation
• Linux
• Apache Spark (PySpark)
• Jupiter Notebook
• Eclipse / Eclipse PyDev
• Git Command Line & GitHub wxPython

PROFESSIONAL EXPERIENCE:

Validation Supervisor

Confidential

Responsibilities:

• Promoted to establish and head newly created Validation department.
• Wrote numerous python applications to extract and cleanse flat data from our Chemical Analyzers, then load into a SQL database using a Star schema.
• Utilized complex SQL queries wrapped in python to create data visualizations using matplotlib and xlsxwriter python libraries to describe instrument performance in a simple and digestible manner.
• Predict & extrapolate instrument behavior/performance via sklearn regression modeling.
• Interpreted, analyzed, and simplified large and complex chromatographic and mass spectral data sets then presented findings to interdepartmental groups; typically a non-technical audience.
• Designed many VBA\Excel data analysis applications with robust GUI’s used by QC technicians to automate the processing of instrument specifications testing data from refurbished instruments.
• Provided feedback to R&D and product management regarding functionality and performance of new and upgraded instruments.
• Managed validation projects to quantify the functionality, capabilities, and ease of usability for unreleased GCxGC-TOF Mass Spectrometers and the software interface.
• Designed experiments and documented SOP’s, some included: evaluating mass spectral quality across a wide array of chemical families, long term stability & reproducibility, determination of linear range, sensitivity, instrument detection limits, system resolution, source & detector robustness, and software usability.

Separation Science Training Specialist (Software Subject Matter Expert)

Confidential

Responsibilities:

• Scripted python algorithms to mine instrument data from 2,500+ non-standardized Excel spreadsheets and uploaded data to a SQL database.
• Automated an instrument maintenance scheduling assistant using the VBA editor and the Microsoft Office platform. It monitored a spreadsheet maintained by our secretary, then notified, via e-mail, the corresponding regional field service engineer when a customer was owed a maintenance site visit.
• Wrote application in Python, VBA, and SQL to track and categorize how each team member allocated their work hours. This tool enables projects to be more efficiently managed by accurately estimating timelines, proactively identifying deficiencies, and furthermore it successfully lobbied upper management to increase team head count.
• Created software using Python and SQL to track failure modes and resolutions for our instrument systems in the field. This information improved business decisions when prioritizing future upgrades.
• Designed Java swing application which automated backup procedures to increase the number of customers backing up their instrument database.
• Provided training to both internal and external customers on the use and application of our GCxGC TOF-MS instruments and the software interface.
• Generated training curriculum and supplemental training materials: videos, PowerPoint presentations, and written documents.
• Provided internal and external customer software support via: customer site visits, phone, e-mail, and remote PC access.
• Innovated the training program by creating a live online training program which was highly regarded based upon customer reviews. This reduced training expenses by 97.5% and man hours by 59.7%, over a four year period.
• Created, documented, and implemented a new customer education and installation support process, which improved customer satisfaction by 64%.

Research & Development Systems Scientist

Confidential

Responsibilities:

• Served as data handling specialist for R&D and Quality Control. Wrote software to automate data mining, processing, and reporting procedures previously done by R&D scientists, enabling QC technicians to do so.
• Collaborated with software engineers to validate and verify device performance.
• Designed and trouble shot sensor calibration & QC standard operating procedures then migrated final version to quality control department including training QC technicians.
• Preparation and submission of a Confidential 510(k) premarket notification.

Graduate Student Research Assistant

Confidential

Responsibilities:

• Constructed and calibrated an ultra-high vacuum chemical reactor to study the photocatalytic decomposition of water on a zirconia nanoparticle to generate molecular hydrogen.
• Performed reproducible methods for vacuum deposition of gas phase water molecules onto zirconia nanoparticles to catalyze the cracking of water to produce H2.
• Utilized Quadrupole Mass Spectrometer, UV-vis and IR to build chemical reactor.