top of page

Wayne McKinney - Oracle Developer/Analyst

E-mail: waynepmckinney@yahoo.com

Cell Phone: 832-605-7259

Professional info
 

As your Oracle Programmer/Analyst, I will ensure that your Oracle programs, forms, reports, and scripts function at their highest efficiency, solve business problems, and are carefully documented.

Selected accomplishments
 

Software

Oracle Forms 11i, 9i, 6, 5, and 3.0

Oracle Reports 6

Oracle PL/SQL

Oracle SQL

Oracle SQL Developer

Oracle Pro*C

COBOL

Improved responsiveness of reports – Decreased runtimes by a factor of 10 times from 20 minutes to 2 minutes

Managed database/data model changes without the need of a DBA – Acted as DBA in managing a large 175 table database

Performed Database/OS upgrades on my own - Nightly data warehouse build time decreased by 40%

Increased system responsiveness - Tuned and improved responsiveness of many Oracle Forms and thereby improved work floor turn-around time by as much as 20%

Created thorough documentation - Documented what I learned about program, business logic, and the projects I was on so that others could refer to it later

Mentored new co-workers - Coached on application and the development tools we used

Work experience
 

Databases

Oracle 11g, 10g, 9i, 8i

Microsoft SQL Server 2008 R2

Operating systems

Windows 10, 8.1, 8, 7

Windows Server 2008

Oracle Linux 6

Solaris

Insight-Global/Katy Independent School District

Help Desk Contractor                                                                                                                                                       July 2018 - October 2018

Help Desk Support person who helped Katy Independent School District (KISD) get past large volume of calls at beginning of year

  • Managed help desk tickets via Footprints (BMC Software), entering them, assigning them, working on them, closing them

  • Resolved many Windows password, Office application, and Outlook logon problems via Active Directory

  • Worked with full-time Help Desk personnel to resolve and close out both old and new trouble tickets

eBryIT, Inc.

Field Installation Technician                                                                                                                                               June 2017 - June 2018

Technician who prepped and configured desktops, laptops, and Chromebooks for use in schools and colleges

  • Managed help desk tickets via Footprints (BMC Software), entering them, assigning them, working on them, closing them

  • Resolved many Windows password, Office application, and Outlook logon problems via Active Directory

  • Worked with established Help Desk personnel to close out both old and new trouble tickets

Safford, LLC/DTK Inc.

IT Help Desk Service Provider                                                                                                                                  November 2015 - June 2018

IT Help Desk contractor who provided IT Help Desk services for a small, janitorial services company

  • Managed help request tickets and worked to respond to these requests in a timely and courteous manner while at the same time balancing previously assigned work priorities

  • Worked to personally know and understand the needs of each of that company's employees and how they specifically did their work

Pyramid Consulting/MD Anderson Hospital

Oracle Forms and PL/SQL Developer                                                                                                                      July 2015 - September 2015

Oracle Developer for a cancer study protocol data entry and maintenance form

  • Fixed bugs in existing forms and streamlined their internal operations

  • Developed new form to handle unique cancer study data gathering situations

Robert-Half/Wyman-Gordon

Oracle Developer                                                                                                                                                     August 2014 - December 2014

Oracle Developer for a furnace management module in an Oracle E-Business Suite (R11 Manufacturing) application

  • Developed PL/SQL scripts that migrated data from a client-developed furnace management system into tables in a custom Oracle E-Business suite module.

  • Modified and created Oracle Forms and Reports that utilized the migrated data

 

MBO Partners/Schlumberger

Software Engineer                                                                                                                                                September 2012 - January 2014

Oracle Developer/Analyst for a large data warehouse application that Schlumberger used for reporting both quality and performance data

  • Performed database and OS upgrades that resulted in a 40% reduction in nightly build run time

  • Created a system of Linux shell scripts that ran the nightly build in a more efficient manner

  • Wrote a series of PL/SQL scripts to efficiently import data from XML into Oracle tables

  • Created and modified SQL Server Integration Services (SSIS) packages that would perform ETL functions, pulling data from SQL Server and inserting it into Oracle tables

Benchmark Electronics

Senior Oracle Programmer                                                                                                                                        August 2003 - January 2012

Oracle Developer/Analyst for a manufacturing work floor management system

  • Performed modification and development work on a large Oracle Forms 6i based manufacturing work floor management system that was custom built.

  • Tuned and improved the responsiveness of many of the above Oracle Forms by either rewriting code or properly using indexes, thereby improving work floor turn-around time.

  • Created, managed, tuned, and tested the Oracle PL/SQL data migration scripts that would port the schema of the above mentioned application to a new database format.

  • Managed, developed, and unit tested the back-end SQL and Oracle PL/SQL used by a large Java-based data warehouse reporting application.

  • Tuned and rewrote inefficient SQL queries that were submitted to the data warehouse either ad-hoc by the user or from the data warehouse reporting application.

 

Schlumberger/GeoQuest

Senior Software Engineer I                                                                                                                                             January 2001 - June 2003

Programmer responsible for maintaining a physical inventory tracking system

  • Managed the maintenance and development of all data model changes and database-side Oracle PL/SQL triggers for a large Exploration/Production information management system.

  • Analyzed, maintained, and expanded the Oracle 6i Forms used by a large Exploration/Production physical inventory tracking system.

Tempora Resources, Ltd.

Oracle Programmer/Analyst                                                                                                                                    June 1999 - December 2000

Contractor who worked at various sites maintaining and developing Oracle Forms and Reports

 

  • Performed contract work at a client where I engaged in the analysis, maintenance, and development of a large Exploration/Production physical inventory tracking Oracle Forms 6i system.

  • Performed Y2K remediation work on Oracle Forms and Reports.

 

Technical Information Architects

Oracle Programmer/Analyst                                                                                                                                                 July 1998 - May 1999

Responsible for prototyping an E&P information tracking system and performing work at a client site

 

  • Developed a prototype of an Exploration/Production information tracking system written in Oracle Forms 5.0 and Oracle Reports 3.0.

  • Performed contract work at a client company where I analyzed and developed a large Oracle Forms 6i based Exploration/Production physical inventory tracking system.

 

Kestrel Records Management

​Senior Programmer/Analyst                                                                                                                                                 April 1994 - July 1998

Developer who maintained and expanded a large inventory tracking system

  • Maintained and expanded a large records management/inventory tracking system written in Forms 3.0, ReportWriter 1.1, and Pro*C where the database was on a SCO Unix back-end.

  • Developed and maintained billing/invoicing screens, programs, and reports for the above inventory tracking system.

 

Lockheed Engineering & Sciences Company

​Programmer/Analyst                                                                                                                                                       January 1989 - April 1994

Developed, implemented, and maintained a project management system

 

  • Expanded and maintained a project management system written in Cognos Powerhouse and HP FORTRAN.

  • Participated in the conversion and expansion of the above mentioned project management system from Cognos Powerhouse to Oracle Forms 3.0, ReportWriter 1.1, and Pro*C.

2010 - present

2010 - present

Education
 

University of Houston - Central Campus

Bachelor of Science - Computer Science

 

Graduated Cum Laude

 

© 2017 by Wayne McKinney. Proudly created with Wix.com

bottom of page