I design, develop and continuously improve EDI systems, ERP integrations and interface programs for our Production Automation Technologies/Artificial Lift divisions. I lead an advanced team of developers, consultants and project-specific vendor resources to support and enhance our Oracle EBS interfaces, extensions and integrated applications. I draw from over 22 years of programming experience covering a wide range of skillsets, technology stacks and platforms.

Apergy merged with ChampionX in 2020. See work experience rolled up under ChampionX above.

Dover Artificial Lift spun off as Apergy in 2018. Apergy merged with ChampionX in 2020. See work experience rolled up under ChampionX above.

Full-time IT consultant at Reata from March 1st to August 21st 2011; accepted Senior Manager, IT Project Management FTE position August 22nd 2011.--- Oracle 10g/11g DBA and PL/SQL Programming--- SQL Server 2008 DBA and T-SQL Programming--- Project Manager Projects & Activities:Finance Department’s Monthly Closeout System—oversight of requirements gathering, system design, phases of in-house solution development & implementationResearch Departments’ Chemical-Compound Database Registration and Management Systems (Isentris/Assay Explorer/Plate Manager)—contract negotiation, hardware/software procurement, system implementation & end-user trainingDrug Safety/Pharmacovigilance System—requirements gathering, vendor selection, contract negotiation, implementation/validation of hosted ARISg solutionMolecular Biology Sequence Analysis/Simulation System—Vector NTI—vendor selection, contract negotiation, system implementationChemical-Compound Analysis/Visualization Solution—TIBCO Spotfire—procurement/implementationMonthly project status reporting on all projectsUtilized PMI standards/PMBOK framework/best practices --- Program Manager Projects & ActivitiesReata’s enterprise-class electronic document management systems (eDMS—NextDocs)Requirements gathering, RFI development, vendor landscape analysis, system evaluation/selection, contract negotiation, hardware/software procurement, system implementation and validationOversight of the three Projects/Project Managers responsible for each of the 3 module’s implementationso Regulatory Operations Module o SOP and Training Moduleo Contracts Module• Weekly project status reporting• Responsible for ongoing vendor management as well as the monitoring of many vendor managed projectsSee Resume for Experience/Expertise In:--- Policy and Procedure Development--- Direct supervisor of IT Department’s Developers

--- Database Application Development--- Data Warehouse Design and Management--- Systems Integration--- Web Application DevelopmentOngoing programming as described below under first bullet of the "Senior Clinical Programmer Analyst" position I had with Encysive/Pfizer (Apr-05/Dec-08) -- see the (Database Design, Programming and Administration) section.Web automation programming for automatic login, navigation and downloading of data from secure CRO vendors’ web portals, creating fully automated external-to-internal system integration solutions.Daily ASP .NET web application development/deployment (including Business Objects components/Crystal Reports 11) utilizing Visual Studio 2008, creating IIS virtual directories and configuring web-application server on Windows 2003—Oracle 10g or SQL Server 2005 backend (based on nature of projects).Extensive SharePoint site (MOSS 07) and SharePoint-enabled application development, using full range of SharePoint features, SharePoint Designer 2007, Visual Studio 2005 and Visual Studio 2008. Database design oversight, specification review, and application testing for EDC/RDC web-based clinical trial systems (outsourced) using PhaseForward product suites (Inform, Instruct On Line, User Management portal). Drug Safety data warehousing and reporting—consolidating data from all 16 completed trials at that point in time. Developed Oracle DB system for loading entire Clinical Study Reports into Oracle--allowing for query and reporting off of actual CSR data. Created Oracle DB systems for global audit trail and error handling for all in-house developed Oracle applications.See Resume for Experience/Expertise In:--- IMPACT CTMS System Integration--- Lab Data Analysis and Reporting Tools--- Custom Apps for Management of PI/Clinical Site Details--- Development of Prototype Clinical Trial Drug Supply Management System

-- Database Design, Programming and Administration --PL/SQL and T-SQL programming (DTS packages, PL/SQL packages, procedures, functions, tables, triggers, indexes, views, sequences, public synonyms, executable script files, batch files, format files, control files, par files, SQL*Plus/SQL*Loader files, ETL batch load procedures, cursors and dynamic SQL structures) to develop system integration solutions, data migration projects, data entry and validation systems, document tracking systems, business intelligence and data warehouse reporting systems.Cross-platform system integration with clinical databases, drug safety databases, bio-statistical datasets and other regulatory systems.Database planning, analysis and design—requirements gathered in collaboration with Data Management, Drug Safety, Clinical Ops and Biostatistics.Complete front-end/back-end database application development to create and maintain data storage and display objects—with additional PL/SQL programming to improve GUI features while minimizing potential for data entry errors (7 study databases in production to date). All programming conducted in compliance with SDLC SOP. Ongoing database access and security administration.Developed and implemented PL/SQL programming, customized coding dictionaries, algorithms and display objects for automatic and interactive coding of adverse experience and concomitant medication records.Created and implemented PL/SQL packaged edit check system (supplemental to and integrated with third-party systems) for validation of data, generation of discrepancy records and formatting of error message output for data clarification forms—designed to support cross-study reusability of global components.Completed steps for database locking in accordance with Standard Operating Procedures.See Resume for Experience/Expertise In:--- Data Warehouse Programming/Report Development --- SOP, Policy and Procedure Development--- Computer System Validation

Supervisor of all IT team members including: Network Administrator (supervised network/HW/SW staff); Data Coordinator (supervised clinical data entry staff); Programmer III; Programming Interns; IT consultants.Agency director responsible for oversight and troubleshooting of all company information systems (over 320 users, 15 networked sites, 23 buildings networked to agency IT resources). Extensive recruiting, screening, interviewing and hiring of candidates (or consultants) for IT department positions.40+ hours per week of direct programing, database administration and system integration.Daily T-SQL programming, ongoing revision of legacy SQL code. Designed, created and managed complete systems including: a data warehouse system; custom clinical and business applications; Crystal Reports (7, 8.5 and 9); automated systems for nightly updating of custom SQL databases and generating/distributing reports in user-preferred formats (usually Excel or plain text); automated processes for assembling, validating, formatting, and FTP batch submission of contractually required data files to State agencies. System integration development for cross-platform data transfer between 3 servers running separate database management systems on different server operating systems.Developed data migration plans and the programming for implementation of data migration processes.Customized and enhanced third-party client-server applications for improved performance, clinical data validation and reporting of clinical services—with extensive programming to track billing, payments, authorizations, insurance coverage, treatment planning and patient response to clinical services. Web site and intranet technology development.Developed backup routines, disaster recovery plans, and data security strategies.Lead team evaluation of third-party applications.Extensive Project Management—over 20 projects completed—applied standards and practices of PMBOK 2nd Edition (2000)