Jon Heller Email & Phone Number

Clive, Ia, Us

Hyderabad, Telangana, In

* Create programs in Oracle SQL and PL/SQL that migrate and synchronize commercial electricity plans.* Build PL/SQL objects (packages, procedures, functions, triggers, types, etc.), schemas (tables, partitions, views, constraints, indexes, sequences, etc.), and database scripts (DDL and DML).* Improve query performance by using indexes, optimizer statistics, ASH, SQL Monitoring Reports, hints, etc.

Wilmington, Oh, Us

* Added features and fixed bugs for asset management and truck dispatch systems.* Wrote and tested SQL and PL/SQL code, optimized SQL statements, and helped developers with Oracle issues.

Remote, Us

* Maintained excellent uptime on a critical benefits processing database despite heavy loads and old hardware.* Led a multi-year query performance initiative where I worked with many developers to continuously improve our SQL and PL/SQL run times.* Automated user management across multiple databases, helped Java developers fix deployment scripts, performed database maintenance, implemented data quality initiatives, and migrated data to Amazon RDS.

Columbus, Ohio, Us

* Helped multiple contractors successfully deploy and run custom Oracle programs in a hostile environment, as part of a large federal government contract.* Created a relational remote execution program that multiple teams used to perform database administration and data analysis tasks in seconds across hundreds of databases. (See project Method5 below for more details.)* Solved many challenging database performance issues in a high-stress production environment. Tuned many SQL statements and PL/SQL programs for both busy OLTP systems and large data warehouses.* Performed many database administration tasks – troubleshot Oracle errors, deployed code, OEM monitoring and alerting, upgraded, patched, automated management tasks with APEX, automated STIG security rules and validation, automated dozens of preventive maintenance checks, etc.

Falls Church, Virginia, Us

(Same contract and responsibilities as position at Ventech Solutions.)

Falls Church, Virginia, Us

* Created the processing engine for the Calculating Quality Reporting Service (CQRS), a program used by the UK National Health Service to improve health care quality by rewarding providers for meeting quality measures.* Used PL/SQL to create a traditional programming language environment on top of an object-relational rules engine.* Created an automated build and unit testing process that significantly improved development scalability, quality, and testing time.* Tuned database queries and processes using indexes, parallelism, optimizer statistics, profiling, hints, execution plans, etc.

* Developed a demand sensing application that forecasted billions of dollars of consumer product goods sales.* Refactored SQL build scripts, which significantly shrunk build times and removed over 10,000 lines of code.* Reduced run time by optimizing parallelism and batching processes.

West Des Moines, Iowa, Us

* Processed billions of Medicare claim records for the Physician Quality Reporting System (PQRS), a program that improved health care quality by rewarding providers for meeting quality measures.* Programmed measures and a rules engine built with object-relational PL/SQL.* Re-wrote the rules engine with standard relational technology, which both improved performance and decreased complexity by an order of magnitude.

Wilmington, Nc, Us

* Created thousands of reports and notifications for clinical trials.* Reduced report creation time by 75% by creating a templating system and continuous improvements.* Used Crystal Reports, XML stylesheets, and Oracle SQL to provide data to customers and analysts.* Frequently helped C# developers improve their SQL code and performance.

Research Triangle Park, Nc, Us

* Configured and administered an enterprise issue tracking system that improved the compliance and quality of biological products.* Used TrackWise, Crystal Reports, Oracle Reports, and ad hoc Oracle SQL queries to build and support issue tracking and laboratory information systems.

Austin , Texas, Us

Programmed digital oscilloscopes using C++ and LabVIEW.

Master’S Degree, Computer Science

Bachelor’S Degree, Computer Science

Education record

Education record