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 Oracle DBA support to a team of 10 Java developers building web and BI applications used by 15,000 employees. Created all Oracle objects and ETL code for ongoing projects. Migrated warehouse from Oracle 9i to Oracle 10g RAC. Maintained Dev, Test, and Prod environments. Performance tuned many ETL jobs. Administered all database schemas, user privileges, security, auditing. tablespaces, partitioning, matviews, sequences, referential integrity, replication, job scheduling. Migrated warehouse from Oracle 10g RAC to Oracle 11.2g RAC. Re-wrote the job sequence engine (Unix C shell). Authored code to replace ASCII text feeds with direct Oracle to Oracle loading. Wrote archive and purge programming. Migrated ETL code from SQL text to compiled PL/SQL packages. Pushed innovation. Authored a new job control engine ( PL/SQL) to execute warehouse ETL job chains automatically sequenced to account for inter-job data refresh dependencies. All job configuration and job execution meta-data was kept Oracle tables, thus allowing construction of a web based interactive control panel to schedule job chains, recover from errors, halt and re-run job steps, guide execution sequence, and view run state, error messages, row counts, start and run times, with comparison against historical meta-data. Introduced new technologies such as DBMS_Scheduler, hash partitions, sub-partitions, redo log mining, change data capture, Oracle Streams, Oracle Goldengate, near-real-time incremental ETL processing of changed records only.

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 production databases running in a multi-server clustered environment. Duties included security admin, backup, recovery, SQL Agent job scheduling, 24x7 support. Handled promotion of table and code changes from Deverlopment, QA, and Training servers. Authored numerous DTS packages. Wrote WinNT command scripting and SQL batch jobs. Developed and tuned TSQL stored procedures used by numerous OLTP applications written in Microsoft .NET.Oracle 9i and Oracle 10g – Administered 35 Oracle instances hosting 120 database schemas running under AIX, WinNT, and Linux. Maintained Oracle security roles, profiles, and user accounts. Allocated tablespaces and system files. Authored scripting for ETL, db administration, and SOX auditing using PL/SQL, SQL Plus, Exp, Imp, SQLLDR. Wrote complex data scrubs. Was sole developer maintaining 130 code modules in a PL/SQL based financial system with $80 million held in health savings accounts for automatic payment of medical claims.

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 front end for drill-down. Applied data mining technology (K-clustering and Decision Tree). Client: Froedert & Medical College of WisconsinApplied OLAP technology in identification of renal failures based on radiological data, from X-ray, CT, and MRI scans. Client: Triad EngineeringUsing Microsoft SQL Server 2000 DTS, developed data extraction routines for real-time SCADA measurements of hydraulic parameters in a complex municipal sewer network. Scripted data validation and cleansing. Invoked computational modeling routines. Populated data warehouse.Client: Eclipse Controls IncServed as acting Director of Technology for this electrical and controls system contractor. Established engineering standards and methods. Commissioned plant-wide control systems based on Windows 2000 Servers and Cisco routers. Active Directory, RAID, clustering, TCP/IP, network design, network security, DNS, DHCP, routing. UNIX and Linux experience.Authored control logic operating turbine electrical generators, gas compressors, fired boilers, pumping systems, chemical injection, and mechanical conveyance equipment. Programmed Allen Bradley Control Logic 5000 and SLC 500 PLC. Configured Intellution iFix consoles.

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 to handle new requirements of Canadian employees. Assisted in data migration, cleansing, and archiving. Revised screen layouts, security model, and client side Java Script. Brought Canada on-line without interruption to USA 24x7 availability. Client: Milwaukee CountyDeveloped an Oracle based system to track Milwaukee County residents applying for paid medical assistance, with eligibility based on income, residency, etc. Status of patients assigned to neighborhood clinics was tracked for billing authorization. Front end built using Oracle Developer 2000 Forms 4.5. Project required data cleansing and migration of 300,000 Oracle 7.3 records to newly designed tables. Wrote Insert/Update/Delete triggers in PL/SQL. Managed projects and accounting.

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 specifications for electrical, mechanical, and I&C retrofit. Personally prepared all specs and drawings for turbine controls. Subsequently served as lead engineer on software team that programmed a Bailey Distributed Control System installed under the project. Completed controls retrofit of four 5000 horsepower axial compressors, providing control logic, graphic displays, field inspection, startup services, training, and documentation. Engineered datalinks between Square D PLC and Bailey DCS systems. Client: Kohler CompanyInstrumentation and controls engineer on the design of a 160,000 gal/day industrial wastewater treatment facility, developed P&IDs, specified instruments, selected DCS equipment, and drafted control wiring diagrams. Subsequently wrote control software for the plant, assisted the contractor through loop checkout, and commissioned all controls during start-up.Client: Packaging Corporation of AmericaParticipated in design of 15 million gal/day industrial wastewater treatment facility for the Tomahawk, Wisconsin papermill. Developed P&IDs, selected instruments, did design layout of Bailey DCS system.Client:S.C.Johnson WaxProgrammed operator displays for Modicon PLC running wastewater treatment plant.

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 old analog panels to newly installed DCS consoles without interrupting gas plant production. Developed RS232 driver software enabling up-load of real-time plant data. Set functional specifications for an Oracle based Management Information System. Wrote SQL scripts to create and populate Oracle tables. Built Oracle forms and screen navigation. Designed and installed process control strategy for diglycolamine gas sweetening units to minimize DGA and energy consumption. Math modeled contactor temperature profile to infer extent of exothermic reaction. Designed and installed computer controls on a de-ethanizer unit, including minimization of refrigeration compressor recycle. Reduced propane product and energy losses for confirmed savings of $657,000/yr. Designed state-of-the-art digital anti-surge algorithms for seven large NGL centrifugal compressors to reduce maintenance costs and steam consumption, and enhance operational stability. Developed a Chemshare steady state simulation to determine the feasibility of re-commissioning a mothballed distillation train for isopentane purification service. Examined alternate plant layouts, high and low throughputs, existing tray internals versus column packing. Served as engineering consultant to gas plant operations. Diagnosed and provided remedy for equipment and process problems: pump cavitation, compressor surge and stonewall, condenser limits, valve actuator failure, instrument failure, reboiler fouling and blow-thru, product loss and contamination. Wrote manuals. Presented technology seminars. Trained Saudi Arab operators.

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 rate and composition, BTU control of dual fired reboilers, delta pressure control on firing with multiple constraint selection, yielding $950,000/yr in production credits. Stabilized de-toluenizer unit via redesign of heat integration network. Set up dual analyzer, dual temperature controls, reducing off test product by 70 percent. Developed cutpoint controls on de-benzenizer column, reducing off test benzene to near zero. Installed split-range controllers with constraint overrides to minimize steam consumption on seven butyl rubber reactors for an estimated $75,000/yr in savings. Programmed gas chromatograph analyzer validity checking routine used plant-wide in all analyzer feedback controls. Implemented feed-forward, feedback control of caustic, bicarbonate, and borax additives to hold pH in aqueous systems. Designed furnace optimization strategy with fully metered cross limiting control of air/fuel ratio reset by oxygen and carbon monoxide analyzers. Responsible for training console operators in the use of computer controls. Also responsible for on-the-job training of other control engineers. Used hyperplane search techniques, linear programming, predictive modeling, and statistical process control. Personally tuned several hundred PID control loops for level, flow, pressure, temperature, and chemical composition.

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