Graduation, Biology, STEM

Andrew Pino

Biologist, Project Manager, QA and Data Analyst
MHA Candidate
Graduation, Biology, STEM
Research Time!

Setting up my station in the genetics lab for a long day of PCR and gel electrophoresis. You must stay organized when working with DNA. Check out that color coding 😊

Card image cap
Technical Experience

I have experience using several Microsoft data tools but primarily SQL for reporting, database updates, and creating stored procedures. I am also comfortable with HTML. I have exposure to C# and Microsoft Visual Studio. I have also written website tests using Java Script.

Card image cap
Software Project Management

I have managed many projects from the time they were requested through deployment. I like to work directly with end-users to gather requirements and see projects through the complete software life cycle. This includes QA testing, creating user manuals, and end-user training.

Resume

  • Project Management

  • Quality Assurance

  • Creating and Keeping Deadlines

  • Data Analysis

  • Problem Solving

  • Microsoft Office Suite

  • SQL

  • Working with data

  • Strong Attention to Detail

  • Excellent Communication and Relationship Building Skills

  • Teamwork and Ability to Work Independently

  • Strong Organizational Skills

  • Critical Thinking

  • Multitasking

  • Reviewing, Reporting, and Research

  • DNA Extraction

  • Primer Design

  • PCR

  • Gel Electrophoresis

  • DNA Sequencing

  • Fragment Analysis

  • Enzyme Restriction Assays

  • LB Plate Prep and Streaking

  • Pipetting

Research Assistant | Genetics ▪ Metropolitan State University Jan 2017 – Jan 2019

  • Developed microsatellite primers to study population structures for Fluminicola spp.

    • DNA extraction and microsatellite primer design

    • PCR and PCR optimization

    • Gel electrophoresis

    • Fluorescently labeled primer pairs using M13 primers

    • Fragment analysis was completed for genotyping and to determine polymorphism at microsatellite loci

Project Business Analyst ▪ Self-employed Jan 2017 – Jan 2018

  • Assisted in the development and implementation of software and website solutions

    • Solved company issues and increased productivity and profits

Software Quality Assurance Analyst and Project Manager ▪ Novus Biologicals Apr 2010 – Nov 2016

  • Conceptualized software solutions for business needs

  • Provided complete SDLC quality assurance testing for in-house web based and desktop applications, new product features

  • Website testing

  • Maintained bug and enhancement requests using agile project management systems

  • Created testing documentation including smoke tests, release notes and training guides

  • Reviewed proteomic data for product updates and the addition of new products

  • Created reports and updated databases using SQL, SSRS and SSIS technologies

Business Development Associate ▪ Pike Studio Jul 2002 – Jan 2010

  • Maintained website content

  • Designed and sent mailers

  • Light human resources work, CRM, and bookkeeping

  • Maintained material inventory and was responsible for purchasing

Masters of Heath Administration ▪ Metropolitan State University of Denver (Current)

  • 3.7 GPA

Bachelors of Science | Biology/Chemistry ▪ Metropolitan State University of Denver Jul 2018

  • 3.5 GPA

  • Diverse coursework including

    • Genetics Principals and Analysis

    • Microbiology

    • Virology

    • Mycology

    • Parasitology

    • Ornithology

    • Animal Ecology

    • Laboratory Techniques

    • Biochemistry I and II

    • Undergraduate Research (2 Semesters)

UNDERGRADUATE CAPSTONE PROJECT

CCR5 Δ32 Mutation Population Study Jan 2017 – Nov 2017

  • Optimized primers that specify the region of DNA containing the CCR5 Δ32 deletion

    • Three primer pairs were developed and cross tested

      • Strong amplification was present in eight of the nine primer pairs tested

  • Restriction enzymes were used to create two fragments for normal DNA, allowing persons that do and do not contain the mutation to be identified

  • Samples were visualized using gel electrophoresis

  • The Data Scientist’s Toolbox

    • Certification

  • Introduction to Software Product Management

    • Certification

  • Auraria Research Conference 2017

    • Certificate of Recognition

  • Introduction to Python Programming

    • In progress

VOLUNTEERISM AND LEADERSHIP

  • MSU Healthcare Leaders

    • Marketing Coordinator

  • UCHealth

    • Research Administration

  • STEM and CO-WY AMP

    • Peer Mentor and Secondary School Science Teaching Assistant

  • Colorado Democratic Party

    • Data Captain

  • C.A.S.S | Connecting Alumni School and Spirit

    • Vice President

  • GLBTQ

    • President

Mass Image Processing Tool

Conceptualized, created requirements, including mockups, and followed through with the completion of the project. This program allows users to import mass numbers of images while still allowing to view and make edits as needed. This increased the Google rank of products on our website and contributed tremendously to the company growing from 2M per year to over 2M per month.

Advanced Product Filter

Conceptualized, created requirements, including mockups, and followed through with the completion of the project. This program allows users to provide basic input and outputs that generate SQL based reports. This dramatically decreased the number of reporting requests for IT, e.g., creating SSRS reports. This also dramatically increased the throughput of the data management team, allowing them to easily clean data and keep it up-to-date. The database holds over 450,000 complex products that are managed by a very small team. This feature also contributed to a higher Google ranking and an over-all better web presence for products.

Legacy Product Management

The above-mentioned product features represent two features of an amazing product management tool. I have ownership of many other features and was also responsible for the prioritization of bug fixes, enhancement requests and processing user stories through the SDLC.

Software Development Data Analyst

Throughout my career I have been responsible for the movement and quality of very large datasets. This includes processing data for companies in acquisition, analyzing the results and creating actionable items for the development and data teams.

Agile Development Administration

I spearheaded the creation of a QA Analyst team and moved IT and marketing from using printed paper tickets to using a project management system, increasing productivity and maximizing communication with stakeholders. This included setting up appropriate workflows, training the development team and stakeholders and setting up and maintaining Scrum, Backlog and Bug queues.

Quality Assurance Lead

Starting as a single QA Analyst, I trained a QA staff of three fulltime employees and one part-time employee. This team now maintains smoke tests and is responsible for testing three websites, one massive legacy data management system and development of a new data management tool that will replace the above-mentioned data management tool as well as another legacy tool that was folded in as the result of acquisition.