Post Job Free

Resume

Sign in

Data Warehouse, Database development, Data Analysis

Location:
Renton, WA
Posted:
July 07, 2015

Contact this candidate

Resume:

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



Contact this candidate