John Heffley

Connellsville, PA ***** 724-***-**** adlfrk@r.postjobfree.com

Professional Summary

Experienced Software Engineer: Offering 25+ years of software engineering and development experience spanning numerous contract roles that required a wide range of expertise in design, development, and testing

Results-Focused Professional: Delivered major wins during multiple projects, such as developing a PL/SQL batch process that took a monthly flat file of demographic information on 1M doctors and applied cascading updates to all tables in the Oracle database with prescriber information in accordance with company needs

Well-Rounded Developer: Utilized an advanced knowledge of testing, programming, and analysis to program and parallel test a bi-directional PL/SQL financial interface handling $800M per year in transactions

Skilled Communicator: Able to balance technical expertise in prototyping, numerous platforms, various software systems, and large-scale production systems with strong interpersonal/technical communication skills

Core Competencies

Object-Oriented Applications

Software Development Lifecycle

Shell Scripting & Batch Files

Business Design Documents

Unit Test Plans

Technical Design Documents

System Enhancements

Team Collaboration

Cross-Functional Leadership

Technical Expertise

CA Workbench – Git – CVS – ClearCase – VSS

Oracle – Informix – DB2 – SQL Server – MS Access

Windows – DOS – UNIX – Linux – Sun Solaris – AS/400 – AIX – UC4 (Automic)

Entity Framework – Unity – Machine Specification

Visual Studio 2019 – JIRA – SQL*Loader – SQL*Plus – Import/Export – TOAD – MS Office

SQL Developer – SQL Navigator – SSRS – SSIS – SSMS – SSAS – SQL – PL/SQL – T-SQL

.NET – C# – ASP.NET Web Forms – ASP.NET MVC – ADO.NET – jQuery – Ajax – CSS – Blazor – Razor – JavaScript – Shell Scripting – XML – XSLT – HTML – COBOL

Career Path

Giant Eagle Corporation

Senior Software Engineer, Deal Central Application 2020 – Present

Completed strategic functional enhancements to the application start screen, reward funding screen, and deal header screen ahead of schedule and with a zero defect rate

Reduced load time of 5 key screens from over a minute to under 2 seconds by using LINQ to objects and tuning business layer SQL

Designed and implemented a configurable pagination engine that can be incorporated into any screen with minimal coding

Develop new business layer objects to replace a legacy mainframe application

Sole resource responsible for development of integrations for a new API-based master item data source

Bank of New York Mellon Corporation

Senior Software Engineer, Equinox Reporting Application 2018 – 2019

Support the Equinox Reporting Application, enabling the generating of complex reports in multiple formats

Combine extensive technical and leadership experience to drive the deployment of 20+ complex reports

Develop JIRA workflows for projects, write T-SQL report configuration scripts, and deploy T-SQL scripts

Work extensively with C# .NET assemblies to compile data from API data sources into in-memory data tables

Leverage exceptional interpersonal communication abilities to deliver design presentations during meetings

Ensure that all SLA timelines are met by interfacing with production support personnel to resolve any issues

Steer the migration of critical reports from a legacy system to .NET/SSRS reporting architecture

Thermal Windows & Doors, Inc.

Software Engineer, EMI Application 2017 – 2018

Orchestrated the creation of a data integration project for an ERP system that based on web API technology

Enabled the gathering of data from RESTful web services by expertly developing new .NET utilities

Kept the company’s primary systems updated and running by improving Delphi applications and T-SQL scripts

Helped management make informed decisions by developing and deploying SSRS reports

Aetna, Inc.

Senior Oracle Developer, RXCheck DUR Project 2012 – 2016

Played a pivotal role in the development of a drug utilization review application for Aetna to increase safety

Created optimized Oracle SQL queries and PL.SQL programs to enable the extraction of data

Reduced costs from $1.00 per letter to $0.03 after enabling a deliveryware-based system to fax outreach letters

Implemented business logic for multiple modules for the third-largest health insurance company in the US

Facilitated the efficient updating of application audit tables by developing statement-level and row-level triggers

Employed SQL*Loader for loading data from vendor files into staging tables and logging unvalidated records

Highmark, Inc.

Senior Application Developer, IPAT Project 2011 – 2012

Drafted T-SQL queries, SSRS reports, and ad-hoc queries by using a range of functions and T-SQL features

Loaded insurance applications from an FTP site into target database tables by developing SSIS packages

Successfully automated jobs in a Windows Server/Windows 7 environment by using Windows PowerShell

Used SSAS to create cubes for dimensional data, and proactively drafted technical design documentation

Hewlett Packard, Inc.

Senior Application Developer, MMIS Application 2010

Worked extensively with SSAS for developing cubes with pre-calculated aggregations for payment fact tables

Honed superior technical writing abilities while drafting design documents and participating in peer reviews

Delivered accurate and detailed business design documents in presentations to the change control board

Created an SSRS drill through matrix reports with vibrant graphical indicators and conditional formatting

Used a parameterized presentation style for optimizing and converting PowerBuilder reports to SSRS reports

Became adept at using correlated and non-correlated sub-queries in business logic T-SQL with multiple tables

Gantech, Inc.

Senior Systems Consultant, CHESSIE Project 2008 – 2010

Guided the deployment of complex DB2 data patches to 300+ hot tickets within a one-year timespan

Interfaced with users to provide hands-on assistance regarding the development of ad-hoc queries

Encapsulated business logic by creating WebSphere components; also wrote complex SQL data patches

Unisys Corporation

Senior Programmer Analyst, FSS Contact Management System 2007 – 2008

Collaborated cross functionally with front-end developers to help them with SQL queries to load screens

Ensured that front-end developers were supplied with the SQL queries to perform business logic validations

Performed extensive testing on multiple areas of a large-scale federal software system on a UNISYS database

Interacted with a wide range of specialists to complete assignments and daily tasks in a team environment

Populated the QA environment with test data by writing, extracting, transforming, and loading programs

LCG Technologies, Inc.

Senior Application Developer, Kelly & Associates EDI Application 2007

Completed multiple improvements, such as coding a set of SSRS reports for generating enrollment statistics

Pioneered the implementation of changes to existing EDI files according to the requirements of the client

Consolidated and centralized EDI business logic by creating stored procedures; also created tables and views

Oversaw the 24/7 production support of a mission-critical SQL server EDI application for the company to use

Efficiently implemented open enrollment files by creating configuration file-driven T-SQL stored procedures

Conducted thorough research into file generation issues to identify and proactively resolve systemic issues

Object CTalk, Inc.

Senior Systems Consultant, DMLSS Application 2005 – 2007

Developed an interface for DFAS Final Payments while working in close proximity with functional analysts

Acted as single point of contact for Informix SQL data patches to a joint military just-in-time logistics application

Managed the implementation of Informix schema objects, providing Federal Purchase Card payment visibility

Facilitated the use of the Federal Purchase Card payment visibility on a distributed system for 140 military units

TBB Global Logistics, Inc.

Senior Oracle Developer, Titan Application 2003 – 2005

Participated actively in the successful migration of an n-tier client server application to J2EE architecture

Enabled the automatic generating of unique keys to support primary/foreign constraints by using sequences

Put together Linux shell scripts to automate routine tasks and regular jobs according to the company’s needs

Maximized application performance by expertly rewriting SQL queries and providing effective user training

Information Services Partner, Inc.

Senior Programmer Analyst, ACIS Application 1997 – 2003

Improved system response by 300% after optimizing application SQL by utilizing Oracle trace utilities

Enhanced time savings by designing a utility that moved training database forward specified number of years

Cut an error-prone one-hour manual process to a two-minute batch job by automating interfaces with UNIX

Established a new process that seamlessly upgraded the client application and deployment kit

Professional Development

California University of Pennsylvania BS, Computer Science

Contact this candidate