Jon Heller

Jon Heller Email and Phone Number

PL and SQL Consultant @ Technoidentity
Clive, IA, US
Jon Heller's Location
Clive, Iowa, United States, United States
Jon Heller's Contact Details

Jon Heller personal email

n/a
About Jon Heller

I am an Oracle SQL and PL/SQL expert who enjoys developing, automating, and performance tuning.I've worked with Oracle databases as a developer, analyst, and administrator for over 20 years. I wrote "Pro Oracle SQL Development" (https://www.apress.com/us/book/9781484245163), built the relational remote execution tool Method5 (https://github.com/method5/method5), and have helped a lot of programmers with Oracle questions on Stack Overflow (https://stackoverflow.com/users/409172/).

Jon Heller's Current Company Details
Technoidentity

Technoidentity

View
PL and SQL Consultant
Clive, IA, US
Website:
technoidentity.com
Employees:
205
Jon Heller Work Experience Details
  • Technoidentity
    Pl And Sql Consultant
    Technoidentity
    Clive, Ia, Us
    View
  • Technoidentity
    Pl/Sql Consultant
    Technoidentity Mar 2023 - Present
    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.
    View
  • R+L Carriers
    Oracle Developer
    R+L Carriers Jul 2021 - Mar 2023
    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.
    View
  • Businessolver
    Oracle Database Administrator
    Businessolver Jul 2019 - Jul 2021
    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.
    View
  • Ventech Solutions
    Database Administrator
    Ventech Solutions 2015 - 2019
    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.
    View
  • General Dynamics Information Technology
    Principal Database Analyst
    General Dynamics Information Technology 2013 - 2015
    Falls Church, Virginia, Us
    (Same contract and responsibilities as position at Ventech Solutions.)
    View
  • General Dynamics Information Technology
    Principal Engineer, Software
    General Dynamics Information Technology 2012 - 2013
    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.
    View
  • Terra Technology
    Software Development Engineer
    Terra Technology 2011 - 2012
    * 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.
  • Telligen
    Senior Programmer Analyst
    Telligen 2009 - 2011
    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.
    View
  • Ppd
    Senior Systems Developer
    Ppd 2006 - 2009
    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.
    View
  • Talecris Biotherapeutics, Inc.
    Information Systems Analyst
    Talecris Biotherapeutics, Inc. 2002 - 2006
    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.
    View
  • National Instruments
    Engineering Intern
    National Instruments 2000 - 2000
    Austin , Texas, Us
    Programmed digital oscilloscopes using C++ and LabVIEW.
    View

Jon Heller Skills

Sql Databases Oracle Pl/sql Etl Software Development

Jon Heller Education Details

  • North Carolina State University
    North Carolina State University
    Computer Science
  • North Carolina State University
    North Carolina State University
    Computer Science
  • Havelock High School
    Havelock High School
  • Voorhees High School
    Voorhees High School

Frequently Asked Questions about Jon Heller

What company does Jon Heller work for?

Jon Heller works for Technoidentity

What is Jon Heller's role at the current company?

Jon Heller's current role is PL and SQL Consultant.

What is Jon Heller's email address?

Jon Heller's email address is jo****@****dit.com

What schools did Jon Heller attend?

Jon Heller attended North Carolina State University, North Carolina State University, Havelock High School, Voorhees High School.

What skills is Jon Heller known for?

Jon Heller has skills like Sql, Databases, Oracle, Pl/sql, Etl, Software Development.

Who are Jon Heller's colleagues?

Jon Heller's colleagues are Jayakrishna Pulipati, Rahul Rao Basava, Satish Dasika, Aakansha Pachauri, Mohd Sohaib Hussain, Ashwin Kumar Modala, Prasad Muvvala.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.