Chris Warnock Email & Phone Number

Milwaukee, Wisconsin

Assumed sole responsibility for the 24x7 operation of an existing 250GB financial data warehouse for this $5 billion/yr business. Processed 80 nightly data feeds extracted from transactional systems and from Oracle EBS Accounting (Customers, Contracts, Service Tickets, Costs, Budgets, Inventory, Payables, Receivables, Employees, Timesheets). Provided.

Greater Milwaukee Area

Oracle 9i PL/SQL – Served as data architect and programmer for a sales tracking and payroll bonus system. Translated evolving business requirements into Oracle tables and PL/SQL packages to extract, analyze, and validate health insurance policy data to generate commission amounts for internal sales force.Microsoft SQL Server 2000 – Administered 175.

Pewaukee, Wisconsin

Authored and revised numerous SQL Server packages to import medical claim records from external feeds. Wrote SQL scripts and stored procedures to perform complex data scrubbing on an 800 GB health claims database. Authored reporting packages in TSQL and VB6. Prepared documentation.

Greater Milwaukee Area

Client: University of WisconsinApplied OLAP technology in analysis of environmental and bio-diversity data collected under EPA contracts. Populated data warehouse (fact tables and star/snowflake schema) using Microsoft SQL Server 2000 Data Transform Services (DTS). Created MOLAP cubes using Microsoft Analysis Services Dimension Editor. Configured Excel.

Greater Milwaukee Area

Client: Johnson Controls IncRe-wrote Perl code for the Web-based time and expense reports used by 5000 USA employees. The new programming replaced prior sequential in-line coding with an Object-Oriented model based on features of Perl 5 (classes, properties, methods, encapsulation, inheritance). Revised (Oracle 7.3 on HP Unix ) data structures on back-end.

Greater Milwaukee Area

Client: Milwaukee Metropolitan Sewerage DistrictControls engineer with nationwide environmental consulting firm. Project Manager of design effort to retrofit two GE Frame 5 Turbine Generators, gas compressors, boilers, conveyance equipment, and HVAC systems. Led engineering team that prepared 300 engineering drawings and 600 pages of contract.

Greater Milwaukee Area

Assisted in start-up of specialty chemical plant, including reactors, material handling equipment, steam boilers, and propane cycle chillers. Programmed Allen Bradley PLC. Calibrated field instruments for flow, level, pressure, pH, and composition analysis. Maintenance and troubleshooting. Supervised operating shift.

Served as senior engineer on multi-million dollar computerization projects involving 1000+ valves and 5000+ instrument inputs. Specified DCS and PLC equipment, and landing of field signals. Redlined piping and instrument drawings. Supervised software engineering of real-time process control strategies and operator displays. Supervised control transfer from.

Participated in plant troubleshooting on a daily basis. Engaged in start-up, debottlenecking, shut-down, and retrofit of chemical plant units. Calculated energy and material balances, line sizing, pump NPSH, reboiler efficiency, optimum unit run lengths. Developed control strategy for xylene distillation train utilizing analyzer feedback, feedforward from.

Fortran programmer. Coded and evaluated the performance of several non-linear optimization routines as driver programs for the Beckstead-Derr-Price computer model of ammonium perchlorate monopropellant burn rates in solid fuel rocket motors.

Medical evacuation helicopter pilot, aircraft commander, tactical instructor pilot.

Biology, Wastewater Engineering

Bachelor Of Science Degree, Chemical Engineering

Magna Cum Laude