Oracle/SQL Development & Performance Specialist
Resume:
Craig Hoover Baden, PA ***** 724-***-**** ************@***.***
Summary
Results-driven Application Development Specialist with over 15 years of experience in Oracle database development, performance tuning, and system optimization.
Proven track record of designing and implementing solutions that reduce costs, improve efficiency, and enhance system performance.
Skilled in PL/SQL and Oracle SQL Development with over 15 years of experience developing complex queries.
Proficient in SQL tuning, consistently optimizing database performance.
Developed advanced Unix shell scripts and Linux shell scripts, automating tasks to decrease manual workload by 30%.
Experienced in Mainframe support for legacy systems, as well as maintaining financial applications using Cobol, JCL, and CICS for transaction processing.
Skills
Oracle, DB2, Teradata, PL/SQL
SQL tuning, query/program/application optimization
Unix/Linux shell scripting
Mainframe, COBOL, JCL, CICS, GDG, VSAM
Oracle Forms, Oracle Designer
SQL Navigator, Toad, SQL Plus, Teradata Assistant, Teradata Administrator
Batch job scheduling, CA7, ESP, Autosys, Control-M
System design and implementation
MQ Series, Syncsort
Version control, Harvest, Endevor, GIT
Agile, Scrum, Waterfall
Work Experience
Highmark – Application Technical Consultant (Employee)
06/2012 – 12/2024
Redesigned and implemented application changes, saving the company millions of dollars.
Rewrote several key processes, saving the company hundreds of thousands of dollars.
Optimized batch processes, reducing processing time by 15 hours per week.
Developed and enhanced PL/SQL packages for Oracle-based applications with Java front-end.
Implemented configuration tables and Oracle VPD to enable parallel business stream processing.
Optimized slow-running queries as an Oracle SQL Developer.
Trained new employees on development and deployment best practices (including version control workflows, automated deployment pipelines, and code review standards). This comprehensive training led to a 25% reduction in deployment errors and significantly faster onboarding times, improving team productivity and ensuring consistent software quality.
Giant Eagle, Inc. – Oracle Developer (Consultant)
11/2010 – 06/2012
Implemented an enhanced fuel perk system that automated processes, resulting in annual savings of $600,000.
Led shelf tag automation project, improving efficiency across retail operations.
Developed Oracle Forms screens and updated data models, cutting nightly batch processing time by 6 hours.
Highmark – Oracle/Mainframe Developer (Consultant)
10/2006 – 11/2010
Modernized legacy systems to support flexible benefit allocation.
Converted Cobol code to Oracle PL/SQL packages.
Optimized SQL queries, cutting response time from 5 minutes to 5 seconds on critical screens.
Giant Eagle, Inc. – Oracle/Mainframe Developer (Employee)
07/2001 – 10/2006
Migrated Retail Pricing system from mainframe to Oracle/Unix environment.
By redesigning the Cash and Sales system, I reduced processing time by 10 hours each week.
Developed processes for rapid competitive response.
Improved the tag processing system, resulting in savings of hundreds of thousands of dollars.
Supported the CA7 batch scheduler to ensure the proper execution of jobs.
Set up Autosys batch schedule for Retail Pricing.
Black Box – Mainframe Developer (Consultant)
06/2000 – 07/2001
Oversaw and enhanced a Data Control System (DCS) platform leveraging COBOL, DB2, and CICS technologies.
Created reports that generated significant company savings.
Developed and implemented a Returns Processing app that saves hundreds of monthly hours.
USX Corporation – Mainframe Developer (Consultant)
03/1998 – 06/2000
Developed and implemented an order fulfillment system using COBOL, DB2, CICS, and JCL.
Visited Indiana (state) to help install and support the new system.
Education
Associate’s degree in Specialized Business – Computer Information Management, Computer Tech (Feb 1998)
Certificates
COBOL
CICS
DB2
Contact this candidate