Post Job Free

Resume

Sign in

Developer Oracle

Location:
Charlottesville, VA
Posted:
February 24, 2014

Contact this candidate

Resume:

Michael R. Mayhew

** ******* ******

Palmyra, Virginia 22963

Phone: 434-***-**** (cell) acctgh@r.postjobfree.com

Objective: Sr. Oracle Developer/DBA Security Clearance: TS/SCI with CI Poly (Expires 7/15)

Summary:

Sr. Oracle Developer/DBA with active "TS/SCI with CI Poly" security clearance - 20 years full life

cycle experience including analysis, design, and development in Oracle environments. Areas of

emphasis include Oracle Forms, Oracle Reports, PL/SQL, SQL*Plus, and database design.

Proficient with Windows, Unix and Korn shell programming. Coding is user friendly and adheres

to standards.

Languages: PL/SQL, Oracle*Reports, Crystal Reports, Korn & c shells, ClearCase, CVS

Software: Oracle*Forms 10g, 9i, 6i, 4.5, 3.0; SQL*Plus, PL/SQL, Toad, SQL Developer

Databases: Oracle (versions 11g, 10g, 9i, 8i, 7, 6, & 5)

Systems: Unix, Windows 7, Vista, & XP

Training: HTML, XML, APEX, Java, Visual Basic, c, MS Office Suite

Experience:

GEMINI INDUSTRIES, INC - Reston, VA 06/2013 - 11/2013

Oracle Database Developer

• Loaded and normalized data from Excel files into an Oracle 11g database.

• Created tables, built constraints, and developed database triggers to track finances.

BLUE CANOPY GROUP, LLC - Fort Bragg, Fayetteville, NC 2011 - 2013

Sr. Software Developer

• Created specialized reports using PL/SQL and Toad within Oracle 11g.

• Enhanced functions, procedures, database triggers, and performance tuning.

NATIONAL GROUND INTELLIGENCE CENTER, Charlottesville, VA 2010 - 2011

Information Technology Specialist

• Interviewed data stewards for multiple organizations. Created Department of Defense

Architecture Framework diagrams using Visio to visually display data flows.

• Researched and documented current processes for data catalog and multimedia

applications. Recommended methods to improve efficiency, user friendliness, and

storage mediums.

SAIC - National Ground Intelligence Center, Charlottesville, VA 2006 - 2010

Senior Oracle Developer

• Enhanced and maintained Oracle Forms software for a human resources/security

database at the National Ground Intelligence Center which provides input for over 20

other applications.

• Created new software triggers for capturing events related to personnel job description

changes. Enhanced a reporting interface by updating functions and procedures within a

database package. Implemented software and database architecture changes.

• Completed numerous projects and trouble tickets in a timely manner with high quality.

• Created a process to ingest data from a spreadsheet. Performed thorough analysis on

human resource data before inserting or updating records in an Oracle database.

Compiled reports on data failures as well as warning messages as part of this upload

process.

• Received a “Certificate of Appreciation” from the customer for my high quality

development work on a 2010 Reorganization project.

Michael R. Mayhew Page 2 of 3

EIDEN SYSTEMS CORP - National Ground Intelligence Cntr, Charlottesville, VA 2003 - 2006

Sr. Oracle Developer

• Created, enhanced, and maintained Oracle forms for the Harmony intelligence

application. Identified numerous cases of attempting to add duplicate data. Coded

numerous software enhancements which eliminated many manual review steps.

• Created and maintained packages, procedures, functions, and triggers.

Performed DBA functions in the areas of creating tables, views, indexes, constraints,

roles, and grants.

• Completed all change requests within estimated time with a high quality level

including attention to detail.

AON CONSULTING / ASA, Greensboro & Winston-Salem, NC 2000 - 2002

Staff Developer

• Designed, wrote, and enhanced numerous shell scripts and stored Oracle

triggers and procedures using PL/SQL. Improved the integrity of the retirement benefit’s

data.

• Supported a nightly application feed process critical for daily client activities using

Unix and Oracle 8i. Resolved all issues within eight hours; 90% within two hours. Ported

the nightly feed system from an NCR/Oracle 7 environment to Sun/Oracle 8i. Corrected

database issues and debugged all script problems.

AT&T WIRELESS SERVICES / VANGUARD CELLULAR, Greensboro, NC 1991 - 2000

Staff & Senior Software Developer

• Provided technical design leadership on multiple projects with emphasis on

Oracle Forms Development, PL/SQL and Oracle database design. Created functional

design, detailed design, and test case documents from business requirements.

Supervised developers and contractors in the areas of forms design and SQL analysis.

These activities provided a higher quality of data, and made maintenance tasks easier.

• Reduced maintenance costs by 50% and improved quality of initial releases by

40% by sharing my expertise in the areas of simplified design and good coding

techniques.

• Mentored contract and less experienced developers in the areas of design and

on-line coding techniques. Conducted on-line code reviews and enforced coding

standards. Provided consistency in layout and navigation within screens across the

entire system.

• Coordinated the use of database triggers and stored procedures as part of a

commission’s project. Performed all the design work, plus coded a number of modules

while performing as the project’s lead developer.

• Performed as a lead developer in providing an interface between the Flexcell®

on-line system and specific coding for a 3rd party communications organization.

Responsibilities included analysis, design, coding, and database design. Coordinated

efforts with quality assurance and documentation to insure data integrity and accuracy.

• Received following awards: “Gold Circle of Excellence” & “Cellular One Merit”.

Education: B.S., Industrial Engineering, Virginia Tech, Blacksburg, VA

Professional Development:

XML - Learning Tree Intl., On-line, 2010

Java/XML - Learning Tree, Intl., Reston, VA, 2005

Oracle 8i - Learning Tree, Intl., Crystal City, VA, 2001

Korn Shell Programming - Learning Tree, Intl., Rockville, MD, 2000

Oracle Open World & Oracle Developer Conference - Both in San Francisco, CA, 1998 & 1996

Oracle Case Tools - Oracle Training Center, Raleigh, NC, 1996

Michael R. Mayhew Page 3 of 3



Contact this candidate