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

Jason Hull

Verified Expert  in Engineering

Bio

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.

Portfolio

Comcast
Automic (UC4), SSAS, SQL Server, SSIS, SQL Server, Windows Development
Comcast
Linux, Windows Development, Job Schedulers, ActiveBatch, Data Virtualization...
Comcast
Graphic Design, Cisco, SSIS, Informatica, Data Management...

Experience

Availability

Part-time

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
Comcast
  • 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, SSIS, SQL Server, Windows Development

Senior Data Architect

2015 - 2017
Comcast
  • 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 Development, Job Schedulers, ActiveBatch, Data Virtualization, Cisco, Teradata, Oracle Development, Data Modeling, Oracle Development, Erwin

ETL Developer

2008 - 2015
Comcast
  • 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: Graphic Design, Cisco, SSIS, Informatica, Data Management, Business Intelligence Development

Divisional Business Reporting Manager

2007 - 2008
Comcast
  • 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: Excel Development, Microsoft Access Development, SQL Server, Oracle Development

Division Reporting Analyst I, II, & III

2001 - 2007
Comcast
  • 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: Excel Development, Microsoft Access Development, SQL Server, Oracle Development

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.
DELIVERABLES
• 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

Tools

Informatica ETL, Microsoft Development, Automic (UC4), Oracle Development, Visual Studio Development, Microsoft Access Development, Excel Development, SSAS, Business Intelligence Development, Informatica, Erwin, ActiveBatch, Tableau Desktop Pro, Tableau Development

Languages

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

Platforms

Oracle Development, Visual Studio Development, Linux, Windows Development, Oracle Development

Storage

SQL Server, SQL Server, Database, SQL Server, PL/SQL, Teradata, SQL, Oracle Development, SQL, PostgreSQL, MySQL, SQL Server, SSIS, SQL Server, Netezza

Paradigms

Waterfall Project Management, Agile Development, Oracle Development

Frameworks

.NET

Other

SQL Tuning, Data Virtualization, Informatica, Task Automation, Data Engineering, Data Build Tool (dbt), Data Management, Cisco, Graphic Design, Data Modeling, Job Schedulers, Tableau Server, Data Warehouse, Database

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.

1

Share your needs

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

Choose your talent

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

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