Help Desk/Service Desk Technician
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