Project Manager Data

JEFFREY K. MAGOUIRK

**** *. ***** ***.

WESTMINSTER, COLORADO 80031

(H) 303-***-****

(C) 303-***-****

E-mail: **********@**********.***

QUALIFICATIONS

Over 22 years of experience in health care data, market research, database

design, maintenance, modeling and survey design. Vastly experienced in

financial and economic analysis; ability to manage and solve complex

problems. Skilled in database analysis, applied econometric and statistical

analysis/modeling.

Computer Skills: SAS, SAS/GRAPH,SPSS, MS-SQL Server, MySQL, UNIX shell

scripting, TSQL, PL/SQL, XML, HTML, JavaScript, Cold Fusion, Dreamweaver,

Sharepoint, MS-ACCESS EXCEL MAPINFO, Windows Server administration, Active

Directory and OpenClinica.

Statistical Skills: Multiple regression, Two-stage least squares

regression, Cluster analysis, Receiver Operating Characteristics analysis,

Poisson Regress, Markov Chain Monte Carlo modeling, Random Block design,

Correspondence analysis, Survey design and analysis, Discriminate analysis,

Logit modeling. Data mining and testing of differences, both small and

large samples.

PROFESSIONAL EXPERIENCE

Rocky Mountain Poison and Drug Center, Denver, CO

Biostatistician, March 2010 to present

. Developed Poison Regression analysis of call data to understand the

effect of FDA ban on cold and cough medicine to children under 6 years

of age.

. Validated Markov Chain Monte Carlo model of drug abuse by three digit

zip code.

. Developed Standard Operating Procedures for Clinical Trial data

management.

Aspenbio Pharma, Inc, Castle Rock, CO

Data Manager/Biostatistician, September 2009 to February 2010

. Prepared laboratory result data, clinical trial data for 510(k) FDA

submission.

. Performed statistical analysis on laboratory and clinical trial data.

Analyzed appendicitis score values with receiver operation

characteristic (ROC) analysis for negative and positive predictive

value. Developed third degree polynomial and square-root methods to

test which method of scoring made for a better diagnosis test. Data was

from ELIZA Immunoassay. Compare means of optical density test with t-

test overall and between runs. Imported laboratory data from reference

laboratory into clinical trial database.

. Put project manager application in place to account for the different

projects that were occurring in the laboratory. Determined requirements

for chemical inventory management system and laboratory information

system. Set up Clinical Trial software application to collect data for

pilot studies.

. Set-up data management system in MySQL for results from lab devices.

Used SAS to perform statistical analysis and to model data.

Colorado Clinical and Translational Science Institute, University of

Colorado Denver, Aurora CO

Director of Research Informatics, Data Management Services, December 2005

to August 2009

. Managed all aspects of a Bioinformatics department, including setting up

web-based clinical trial data collection NIH and FDA phase I studies.

Other studies included neonatal feeding studies. Purchased computer

equipment and software for the Pediatric General Clinical Research

Center.

. Met with primary investigators/biostatisticians to set-up various studies

including physical therapy, drug, heart-bypass, cancer studies. Help

design case report forms (CRF) and develop the data management behind the

CRFs.

. Ensured that HIPAA regulations were followed.

. Used SQL statements to automate the download of lab and radiological data

into a study's database. This included the use of database triggers and

stored procedures.

. Wrote SAS and SPSS programs to manipulate and analyzed data from

different studies. Used ODS to make reports from SAS datasets. Used ODBC

to access SQL Server tables with SAS and SPSS.

. Supervised a staff of two programmers, one analyst and three student

interns. Wrote job descriptions, performance evaluations, developed

personnel and equipment budgets.

National Jewish Medical and Research Center, Denver, CO

Data Coordinator, October 2002 to December 2005

Statistical Programmer, January 2002 to October 2002

. Developed SQL-Sever databases and applications for various patient, drug

and device studies. These databases included triggers to develop

automatic audit tables and send automatic emails.

* Maintained the data quality and management of various pulmonary studies.

This included phase three clinical trials, NIH compliance studies and EPA

air quality studies. Designed CRFs, wrote proposals and contracts. Set up

users with permissions on the servers. Managed four people: three

programmers, one CRF designer and one data verification specialist.

* Wrote code in SAS, SQL scripts to manage data. SAS experience with

macros, base SAS and SAS Stat. The purpose of the code was to manage the

data, range-check the data and develop user reports to help with data

quality.

* Wrote SAS programs to access data from labs, both blood chemistry and

spirometry. Used SAS with ODBC drivers to connect with KOKO and PIKO

data.

University of Denver, Denver, Colorado

Instructor, September 2005 to December 2005

. Part-time instructor of Statistical Computing for SAS Software.

Primen, Boulder, Colorado

Contract Employee, October 2001 to December 2001

* Performed economic analysis, market research, database development and

survey research for the utility industry. Also developed commercial and

industrial load shapes. Used logistic regression model to determine

consumers of green power for direct marketing purposes.

EDS, Louisville, Colorado

Information Analyst, June 1999 to July 2001

* Designed and maintained large consumer SAS analytic relational data

warehouse on a Sun Solaris 2.5 Unix system. Developed all of the code and

the relational tables. Used Unix shell scripting to set off programs

(krontab function), checked for variable types. This database has twelve

different tables, which range in size from 7 million records to over 635

million records. The building of this data warehouse included loading

from flat files into the SAS tables on a weekly and monthly basis. The

purpose of this data warehouse is to determine consumer behavioral on

various levels -- payment history, purchase history, credit history and

call center activity.

* Performed statistical modeling on the databases for direct mail purpose.

Developed random samples for data to model from. The type of modeling

included neural networks, cluster analysis, logistic regression and least-

squares regression.

Hunter Douglas Window Fashions, Broomfield, Colorado

Senior Market Research Analyst, 1996 to 1999

* Designed, developed and analyzed survey of customers and dealers to

determine if the dealers qualified lead program was cost effective.

Tighten the requirements of qualified leads.

* Analyzed, refined and managed a 75,000 outbound survey. Survey purposes

determined market share and profile of window covering customers. Managed

the survey vendor.

* Developed the Customer Information System of three different products

lines, linked the customer information with demographic and address

databases to develop target market direct mail program.

* Built and maintained the Dealer Response Database. This database is used

to market directly to dealers of Hunter Douglas products. The database

also tracks the success of different promotions for dealers and the how

dealers make the promotions successful.

* Provide competitive intelligence on the four different major competitors.

Database development to store all information from public records, stock

prices and press releases.

Public Service Company of Colorado, Denver, Colorado

Program Evaluation Analyst, 1993 to 1996

* Designed survey for security lighting analysis, a 600-respondent

telephone survey of the Denver metro area and mountain regions of the

state. Analyzed survey for changes in customer behavior, attitudes and

future needs. Matched the survey results with current residential market

segments via cluster analysis. Survey results used to develop targeted

marketing plans. Developed RFP and managed vendor.

* Analyzed the Energy Savings Partners low-income weatherization program.

Developed research plan, designed surveys, focus group discussion guides;

analyzed results wrote final report.

* Managed three consulting firms with a budget of $450,000. Consulting

firms perform analysis on various Demand-Side management programs that

Public Service sponsored for its customers.

* Managed collection of numerous telephone surveys by different vendors,

including preparing the request for proposal, selection of vendor, and

gathering final data from the vendors for use in analysis.

* Team lead in developing new customers via a fuel-switching program in

Fort Collins, Colorado. Areas of the city were examined and scored for

potential of fuel switching possibilities. Success rate of 55% of homes

targeted to switch fuels.

* Analyzed the savings at Denver International Airport from the use of

natural gas chillers versus electric chillers; savings estimated through

regression analysis.

* Determined electric energy savings, developed phone survey, analyzed

survey of 160 homes that switched from electric heating to natural gas

heating.

* Developed methodology, gathered data and wrote report on the non-energy

benefits of low-income weatherization.

Outlook Eyewear Company (subsidiary of Bausch & Lomb), Broomfield, Colorado

Market Planning Analyst, 1992 to 1993

* Developed automated sales tracking system from different retailers' point

of sale systems. The sales tracking system fed into the inventory

forecast. Sales tracking system developed profit statements.

* Tracked marketing's department budget of $3.2 million, managed the

advertising vendors, gathered competitors' information and set up the

first customer information system from warranty cards.

Automobile Club of Southern California (AAA), Los Angeles, California

Senior Research Analyst 1991 to 1992; Research Analyst 1988 to 1989

* Conceived and automated a report ranking sales representatives by quality

of business sold. This automation saved over $200,000 in manpower savings

per year and enabled senior management to develop strategies to motive

personnel to sell a better book of business.

* Researched the characteristics between renewing and non-renewing members.

Analysis tested statistically the differences between the two

populations. Results built a forecast model of renewals.

* Developed standards of service performance to judge the success of

"Saturday Morning Service Hours." Saved $20,000 by arranging an on-line

reporting system.

* Performed forecasts of dental and prescription drug claims, updated and

refined the facilities master plan. Developed economic forecasts and

performed various secondary market research projects.

First Interstate Bank of California, Los Angeles, California

Financial Analyst, 1989 to 1991

* Used cluster analysis to define the 330 bank branches into six different

market types. Identified branches as over or under performers based upon

the branch's cluster. Generated equations for each cluster to forecast

expense and revenues for each branch.

* Performed financial analysis on credit card portfolios leading bank to

buy or sell portfolios.

EDUCATION

Ph.D. coursework Macroeconomics and Econometrics, 1986-1987

Colorado State University, Fort Collins, Colorado

Master of Science, Agricultural and Natural Resource Economics, 1986

Colorado State University, Fort Collins, Colorado

Bachelor of Arts, Economics, 1984, University of Colorado, Colorado

Springs, Colorado

PUBLICATIONS/CONFERENCE PROCEEDINGS

Dudden RF, Corcoran K, Kaplan J, Magouirk J, Rand DC, Smith BT. "The

Medical Library Association Benchmarking Network: Results" J Med Libr

Assoc. 2006 Apr;94(2):118-29.

Dudden RF, Corcoran K, Kaplan J, Magouirk J, Rand DC, Smith BT. "The

Medical Library Association Benchmarking Network: Development and

implementation", J Med Libr Assoc. 2006 Apr;94(2):107-17.

Magouirk, Jeffrey K. "Taking Almost Raw Law Data and Turning it into Data

Fit to be Analyzed"

Conference Proceedings, Northeast SAS Users Conferences 18th Annual

Conference

Portland, Maine, September 2005.

Magouirk, Jeffrey K. "Using Proc SQL and ODBC to Manage Data outside of

SAS"

Conference Proceedings, Western Users of SAS Software, 12th Annual

Conference

Pasadena, California, October 2004.

Magouirk, Jeffrey K. "Partners in Privacy" Intelligent Enterprise,

September 18, 2001.

Magouirk, Jeffrey K. "Measuring the Non-Energy Benefits from a Low-Income

Weatherization Program" 1995 National Evaluators Energy Conference

Proceedings, Chicago, Illinois, August 1995.

Chi, Meng and Magouirk, Jeffrey K. "Measuring the Rebound Effect as a

Result of a Residential Fuel-Switching Program" 1994 American Council on

Energy Efficient Economy Conference Proceedings, Monterey, California,

August 1994.

Professional Associations

Member, Society for Clinical Data Management, 2009 to present

Member, 2003- 2005, 2009 to present

Chair, Denver SAS User's Group, 2005-2006

Member, Biomedical Research Informatics Association, 2003 to 2008

Contact this candidate