Aaron Prescott Email and Phone Number

Used advanced programming and data analytics skills to map and reverse engineer multiple relational databases. Automated the process to extend to multiple large-scale databases to increase the efficiency of data engineers in Research IT. Analyzed and crafted solutions to modify vendor application to deliver the power of data-driven decision to scientific researchers. • Evaluated proposed vendor solutions, designing KPIs and dashboard to communicate finding to management, and assisted with coordinating new software implementation in AWS.• Utilized advanced Python coding and Spotfire dashboard design methods to create novel product that will replace legacy software used by 1000 researchers democratizing data across the research organization.• Produced a solution that map large SQL database schemas (>900 tables) and automated Entity Relationship Diagrams (ERD) generation in ERStudio using a combination of Visual Basic and Python. Results helped democratize data by allowing basic SQL developers to determine valid data table joins without advanced database querying skills.• Designed recursive algorithms for cleaning API data calls and uploading into NoSQL graph database (Neo4J) to craft large knowledge tree within an interdisciplinary team to allow for cross-field data analytics.

Acted as senior technical lead of a small data analytics team. Provided direct contributions and guidance while designing, constructing, and coordinating the implementation of multiple user-friendly data analytics tools, databases, and machine learning algorithms to support clinical trial pharmaceutical manufacturing. Communicated key results to relevant stakeholders.• Created an ensemble regressor utilizing linear regression metrics as input features in order to compensate for missing data points resulting in out-of-training predictions improving by >30% over previous implementations.• Designed a hybrid learning algorithm to predict molecular tags on engineered antibodies. Constructed the required evolutionary algorithm and dashboard to discover and analyze optimal values for 22 parameters in 8 ODEs across 24 bioreactors.• Engineered semi-automated report generator requiring the construction of 2 relational databases (PostgreSQL), 1 API call (R code), and 1 dashboard to accept user input (TIBCO Spotfire - IronPython) • Fostered a culture of growth by mentoring 4 junior colleagues and 2 interns in data analytic coding practices. Organized and hosted monthly forums to foster growth and collaboration for data science efforts across the department.

• Acted as lead advisor for $200K project to design and execute a cloud-based data lake solution incorporating >50 streaming and batch data sources. Received 2 awards for exceptional results and completing work delegated to 3rd-party collaborators during project overrun• Produced Power BI dashboard allowing team of 12 researchers to access data stored in SQL and data lake, reducing operational overhead required to acquire data• Developed deep-learning image classifier with >95% validation accuracy utilizing Keras/Tensorflow to identify improper flaring operations

• Advised executive leadership on business and scientific strategies while acting as the primary data science consultant at a small biotech startup• Designed and implement a binary classifier to predict colorectal cancer diagnosis using quantified human serum biomarker data• Designed and constructed a relational database to be used as a long-term storage solution for data produced from in-house laboratory analysis

• Used quantitative analytics and coding expertise to design novel machine learning pipelines useful for analyzing complex chemical networks which led to 2 peer-reviewed publications. • Adaptable and flexible thinking used to improve the productivity of collaborators as evidenced by automating simulation execution leading to >100 man hours saved within a small research group.• Strong investigative and research skills used to create and design computational cancer models that simulate the behavior of 10,000 interacting cells.

• Marked strategic planning and project management skills were utilized while simultaneously conducting 4 experiments/projects spread across 8 distinct locations.• Served as mentor and teacher during the training of 8 graduate/undergraduate researchers in key microbiology and DNA processing techniques.

• Used entrepreneurial mindset and relationship building talent to establish a personal tutoring service with 20 billable hours per week from a client base of over 15 students in 6 different subjects including calculus, chemistry, physics, and statistics.

• Used observational and discovery skills to make contributions in 2 research groups while securing $20K in funding for original research projects in the fields of molecular and microbiology.

• Attention to detail and project organization used while manually converting data for >50K preserved biological specimens into a Microsoft Access database.

• Used client-facing skills and emotional intelligence to lead a team of 5 members in a fast-paced environment while providing superior service to over 200 customers per hour during peak business operations.

• Participated in the monitoring and regulation of chemical and radiological conditions of 2 nuclear propulsion plants aboard a naval aircraft carrier.