Ivan Hernandez Email & Phone Number

Foster City, California, United States

Supported the implementation and maintenance of software applications to drive drug discovery research, such as Dotmatics, Biovia Pipeline Pilot, Biovia ELN, and similar applicationsDeveloped and implemented custom scripts to ETL scientific data to appropriate data warehouses, enabling efficient data processing, analysis, and utilization by in-house applicationsProficient in writing SQL queries in relational databases such as Microsoft SQL Server and Oracle SQL to ensure data accuracy, generate reports, and perform data corrections for scientists.Developed and maintained an efficient Extract, Transform, Load (ETL) process to extract Workday data and utilized the data to analyze resource allocationServed as the primary point of contact and support for all research personnel, acting as the system owner for BIOVIA ELNGenerated comprehensive ELN reports on a monthly basis, ensuring adherence to regulatory requirements and providing critical insights for departmental decision-makingServe as the go-to Linux expert for the entire research organization, providing guidance and support in installing, configuring, and troubleshooting open-source software such as AlphaFold, Rosetta, and slurm.Setup and configured a high-performance computing (HPC) slurm cluster enabling parallel processing and resource allocation for computationally intensive research workloads

San Diego, California, United States

• Extracted and transformed data from multiple sources in preparation for exploratory data analysis, and reporting• Characterized manufacturing health and developed key metrics to drive efficiency and improvements in new product development• Collaborated with Development, R&D, Manufacturing, and other departments as needed to addressissues and set appropriate specifications for manufactured products• Developed and implemented new processes to collect data and analyze the health of production areas• Leveraged MySQL, Transact SQL, and R programming to wrangle and analyze data• Implemented Tableau to visualize cleaned data and created dashboards for stakeholders• Comfortable using GitHub to manage version control and data workflow

San Diego, California, United States

San Francisco Bay Area

• Specialized on the product lifecycle management of the MiSeq and NovaSeq platforms• Performed data analysis on manufacturing test data to determine process reliability of biotechnology instruments• Collaborated with managers and subject matter experts to understand instruments and define analysis expectations• Prepared raw test data using excel then analyzed it using a statistics software JMP (SAS) to determine reliability• Produced official manufacturing reports on my findings and presented to the manufacturing team

Los Angeles, California

• Acted as the Plant Liaison between Water Reclamation Division, contractors, consultants, and other divisions on CIPs in various stages of planning and construction.• Managed the construction of a 10 million gallon per day ozone injection system to disinfect wastewater • Analyzed plant process performance on a monthly basis to determine areas for improvement and communicate those to senior staff• Prepared monthly performance reports to track water flows, efficiency of removal, and chemical expenditures and communicate these to upper management• Prepared Special Plant Accommodations and coordinated activities associated with construction•Reviewed, distributed, and finalized on Submittals, Requests for Information, and Special Plant Accommodations•Conducted Plant tours for students, City employees, and the general public

Grand Forks, North Dakota Area

Partnered with PhD candidates to develop three distinct oxygen carriers for chemical looping combustion systemsOperated fluidized two bed reactors of varying sizes using LabVIEW to execute tests on oxygen carriersConsulted with scientists from three different departments to maximize oxygen carrying capacityCompiled performance data using a thermogravimetric analyzer then interpreted data using Microsoft Excel

Pasadena, Ca

Conducted chemical synthesis under guidance from lead research chemistsVerified synthesis results via Column Chromatography, NMR Spectroscopy, Mass Spectroscopy, and HPLCRevised chemical synthesis plan with lead chemist after product analysis was complete

Pasadena, Ca

Completed Amgen’s Biotechnology volunteer program to prepare students for a career in biotechnologyGained experience in cell culture techniques, making Agar plates with and without ampicillin antibiotics, electrophoresis to visualize transformed DNA, and operated centrifuges, pipettes, and autoclavesFamiliarized with OSHA regulations regarding lab safety and requirements

Los Angeles, California

Chemical Engineering

Associate Of Science - As, Mathematics