James Cox
Linkedin: www.linkedin.com/pub/jim-cox/b/a14/b23
Day Phone: 425-***-****
Email: acqmjo@r.postjobfree.com
WORK EXPERIENCE
LabCorp Clinical Trials (Formerly Rosetta
Inpharmatics, Merck Research
Labs,Covance Genomics Lab) Seattle, Wa
7/2000 – 6/2015
Senior Software Engineer/Database Administrator, Bioinformatic Data Analyst Designed Oracle database environments to support Laboratory Information Systems in a complex and dynamic environment.
Designed and developed Data Warehouse and Operational Data Store for Quality Control and analytical reporting.
Supported 8 Oracle systems and 2 Sql Server systems, running on Linux, and Windows platforms.
Created software to support the data pipeline from laboratory instruments to analytical systems using PL/SQL, Java, Python, Perl, and Linux Shell scripts. Developed and trained other software professionals in writing PL/SQL functions, stored procedures, and database triggers.
Developed various software systems for processing, extracting and transforming data using Python, Unix shell script, Java and Perl.
Conducted statistical analysis of data in support of laboratory quality program. Created automated pipeline for high throughput processing of Nanostring Gene Expression assays, to include quality analysis and customized reports for clients. Conducted analysis of complex Nanostring Gene Expression projects for clients using R. Developed code base in R for streamlining validation analysis for new clients. Worked with clients to develop analysis requirements.
Conducted Next Generation Sequencing analysis and created and maintained software pipeline for analyzing genomic data. Experience in RNASeq, DNASeq, Copy Number Variation, and Gene Expression analysis using R and various open-source tools. Starbucks Coffee Company, Seattle Wa
Oracle Database Administrator
Provided administration support for Oracle Production databases, to include implementing package solutions, designing and developing backup solutions and monitoring tools, and providing data modeling support for developers. University of Washington, Department of
Molecular Biotechnology High Throughput
Sequencing Lab, Seattle, Wa
Oracle Database Administrator
Supported gene sequencing laboratory for the Rice Genome Sequencing Project. Maintained production Oracle database and created Data Warehouse for data analysis. Developed custom data extract routines to support analysis of sequence data from 250 sequencing machines using Perl and Java.
Starbucks Coffee Company, Seattle, Wa
Technical Lead, Data Warehouse Developer
Served on development team designing and implementing store-level transaction Data Warehouse for Coffee stores throughout North America. Developed Unix scripts and Oracle procedures for coordinating the nightly load process and monthly summary routines. Coordinated requirements gathering with various user communities, and monitored data quality. Developed reports using various query tools. United States Department of Agriculture,
National Agricultural Statistics Service,
Olympia, Wa
Agricultural Statistician
Survey Statistician: managed various agricultural surveys, coordinated and trained data collection personnel, wrote data analysis and survey management software, and prepared estimates from survey data.
Data Processing Statistician: managed local area network for Field Office, provided pc hardware support, and programmed data analysis and telephone survey software. Supervised data entry staff.
Data Warehouse Developer: served on development team designing and implementing national survey Data Warehouse. Developed data extraction routines for survey data, and loading routines for Data Warehouse.
Washington Army National Guard, Spokane,
Wa
Logistics and Administrative Officer Active Guard/Reserve Served as full-time officer in 1st Battalion, 161st Infantry. Supervised logistics and personnel administration sections, supporting over 600 part-time soldiers. Coordinated transportation, equipment requisition, and vehicle repairs. United States Army
Armor Officer
Tank Platoon Leader. Supervised and lead a tank platoon with 15 soldiers and 4 tanks. EDUCATION
Washington State University
Pullman, Wa US
Master's Degree – 12/1990
Major: Agricultural Economics
University of Washington
Seattle, Wa US
Bachelor's Degree - 6/1984
Major: Economics