Jason Hull, Developer in Nashua, NH, United States
Jason is available for hire
Hire Jason

Jason Hull

Verified Expert  in Engineering

Software Developer

Nashua, NH, United States
Toptal Member Since
June 18, 2020

Jason has over 18 years in the telecommunication industry where he's worked with strong databases, ETL processes, data virtualization, task automation skills, and risk-based data management systems (Oracle, MS SQL Server, Teradata, and PostgreSQL). He's administered and developed an ETL in Informatica and the Cisco Information Server (virtual databases) for over seven years. He loves challenges, especially when it has been said it can't be done.


Automic (UC4), SSAS, SQL Server Reporting Services (SSRS)...
Linux, Windows, Job Schedulers, ActiveBatch, Data Virtualization, Cisco...
Composite, Cisco, SQL Server Integration Services (SSIS)...




Preferred Environment

Toad, Visual Studio, Oracle, Microsoft SQL Server, Windows

The most amazing...

...program I've built was an application that determines the optimal dialysis machine settings to improve patient comfort and reduce their time in the hospital.

Work Experience

BI Developer

2017 - PRESENT
  • Fleshed out a reporting database to support the national truck roll-, phone call-, and subscriber-based metrics.
  • Implemented new SSAS cubes for regular and ad hoc reporting.
  • Designed extracts from multiple source platforms, Oracle, SQL Server, and Teradata and consolidated that data into an MS SQL warehouse.
  • Automated data pulls using SSIS and external calls to FTP when needed.
  • Developed new automated tasks in the Automic environment.
  • Transitioned existing jobs scheduled via SQL Server Agent to Automic for better job chaining.
Technologies: Automic (UC4), SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Windows

Senior Data Architect

2015 - 2017
  • Built out a virtual data warehouse called Single Source using DV technology for a more than 400 user base; sourced from Oracle, MS SQL, Teradata, Netezza, PostgreSQL, and DB2.
  • Implemented a physical Oracle data warehouse with three major subject area data marts' also built my own data model.
  • Led the ETL development team in standards and best practices as well as reviewed code and shared my migration expertise.
  • Performed database backup tasks as a secondary Oracle database administrator.
  • Administered and worked as the primary developer of the ActiveBatch scheduling environment.
  • Designed and implemented divisional finance data warehouse in Teradata. The design was based on existing reporting needs and utilized available enterprise BI resources.
Technologies: Linux, Windows, Job Schedulers, ActiveBatch, Data Virtualization, Cisco, Teradata, Oracle, Data Modeling, Toad, Erwin

ETL Developer

2008 - 2015
  • Pulled data from disparate sources into modeled Oracle star schemas by using the department ETL toolset: Cognos Data Manager, Informatica PowerCenter, SSIS, and the Cisco Composite Information Server.
  • Guided team members and contractors to use best practices and to adhere to the department architecture.
  • Aided in the administration of multiple Oracle instances.
  • Managed key applications in the ETL architecture, Cognos Data Manager, Informatica, Cisco Data Virtualization, and ActiveBatch.
Technologies: Composite, Cisco, SQL Server Integration Services (SSIS), Informatica PowerCenter, Data Management, IBM Cognos

Divisional Business Reporting Manager

2007 - 2008
  • Partnered with the senior management in the implementation, design, and enhancement of new and existing reporting.
  • Managed a staff of five analysts.
  • Developed the department website for housing and distributing reports. SQL Server back-end with a .NET front-end.
  • Collaborated with IT to flesh out data structures needed to support reporting.
Technologies: Microsoft Excel, Microsoft Access, Microsoft SQL Server, Oracle

Division Reporting Analyst I, II, & III

2001 - 2007
  • Tasked with understanding the structure behind the new CSG billing system and partnered with co-workers to redesign reports.
  • Acted as the owner and builder of key reports including tech productivity, quota management, and pending work orders.
  • Adopted a roster database from an outgoing employee and tasked with enhancing the existing database while developing a .NET web/Oracle database-based version.
Technologies: Microsoft Excel, Microsoft Access, Microsoft SQL Server, Oracle

Migrate Data Warehouse to Snowflake With dbt

The project was started after the company spun off from its parent company as a standalone entity. Initially, a SQL server farm stood up to duplicate warehousing, analysis, and reporting services.

After the spin-off, a project began modernizing the data warehousing to use the cloud. Snowflake, Fivetran, and dbt were the selected tools.

My role was to understand, catalog, and reverse engineer the existing SSRS reporting based on T-SQL queries to the SQL instance and MDX queries to the SSAS server. Once understood, I then had to build the model in dbt Cloud and test it to ensure the accuracy of the new structure.

In dbt, I used dbt Cloud with a combination of snapshotting for type 1/2 dimensions, traditional fact structures, and a big-wide-table methodology to ease the report building in Tableau, all using the Fishtown syntax. Additional dbt functionality includes utilities from dbt-labs for common macros, custom macros that fit the project's purpose, and multiple pipeline jobs to break out the data warehouse build.

Customer Value Reporting

This part of the data mart was made up of multiple dimensions and a single fact table that read from multiple billing system sources to identify what the value (incoming revenue) of a customer is and trends that data over time.

First Call Resolution

This query was pulled from an existing set of call records and made into a support center. Using database analytic functions to see if the same account number called in on the same day, it labeled calls and resolved them if they were the last call made or only a call from an account number that remained unresolved. A report on top of this was then used to display the number of unresolved calls and a first call resolution rate.

MDX Dashboard

This example MDX query is handwritten to pull in all the key metrics from an SSAS cube to be displayed on a dashboard. The date parameter is dynamic based on user selection, and some members are derived based on other members.

Oracle PL/SQL Delete

Developed an Oracle PL/SQL procedure that accepts input parameters to dynamically delete records from the table passed in. I also tuned and maintained it over time.

Oracle Materialized View

Developed a query embedded in the view that was timing out after hours when submitted to a database via an application. I moved it into a daily materialized view refresh, saving time and improving stability.

Looping PL/SQL

Developed a looping PL/SQL procedure used to read update statements stored in a table with a configurable commit level.

ETL Platforms | Informatica PowerCenter

I served as the lead developer during a migration project away from SSIS and IBM Cognos Data Manager as ETL platforms. My work included installing and administering Informatica PowerCenter.
• Install and configure the PowerCenter engine on a Linux host.
• Install the client on all developers' desktops.
• Define and build standards.
• Identify reusable items to convert into maplets or workouts.
• Design, code, and deploy all core mapping and workflow components.
• Review of junior members' code.
• Ensure standards were met for the use of lookups, expressions, and target loads.
• Lead the discussion on when to use ETL vs. ELT approach.
• Integrate the enterprise scheduler.
2000 - 2002

Bachelor's Degree in Information Systems

University of Massachusetts Lowell - Lowell, MA, USA


Informatica ETL, Microsoft Visual Studio, Automic (UC4), Toad, Visual Studio, Microsoft Access, Microsoft Excel, SSAS, IBM Cognos, Informatica PowerCenter, Erwin, ActiveBatch, Tableau Desktop Pro, Tableau


SQL, VB, C#, Visual Basic .NET (VB.NET), VBScript, JavaScript, Snowflake, MDX


Oracle, Visual Studio 2016, Linux, Windows, Oracle Data Integrator (ODI)


SQL Server 2008, SQL Server 2014, Teradata Databases, SQL Server 2016, PL/SQL, Teradata, PL/SQL Developer, Oracle PL/SQL, ANSI SQL, PostgreSQL, MySQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Netezza


Waterfall Development, Agile Software Development, Oracle ODI




PL/SQL Tuning, Data Virtualization, Informatica, Task Automation, Data Engineering, Data Build Tool (dbt), Data Management, Cisco, Composite, Data Modeling, Job Schedulers, Tableau Server, Data Warehousing, Data Queries

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring