Scroll To View More
Jason Hull, SQL Developer in Nashua, NH, United States
Jason Hull

SQL Developer in Nashua, NH, United States

Member since December 7, 2017
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.
Jason is now available for hire

Portfolio

  • Comcast
    Windows, MS SQL Server, SSIS, SSRS, SSAS, Automic
  • Comcast
    Erwin, Toad Data Modeler, Oracle, Teradata, Cisco Data Virtualization...
  • Comcast
    Cognos Data Manager, Informatica PowerCenter, SSIS...

Experience

  • SQL, 12 years
  • Toad, 12 years
  • Oracle, 12 years
  • Agile Software Development, 8 years
  • Informatica ETL, 7 years
  • Teradata Databases, 5 years
  • Automic (UC4), 3 years
  • SQL Server 2016, 2 years
Nashua, NH, United States

Availability

Part-time

Preferred Environment

Windows, MS SQL, Oracle, Visual Studio, Toad IDE

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.

Employment

  • 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: Windows, MS SQL Server, SSIS, SSRS, SSAS, Automic
  • 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: Erwin, Toad Data Modeler, Oracle, Teradata, Cisco Data Virtualization, ActiveBatch Job Scheduling, Windows, Linux
  • 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: Cognos Data Manager, Informatica PowerCenter, SSIS, Cisco Composite Information Server
  • 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: Oracle, SQL Server, Access, Excel
  • 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: Oracle, SQL Server, Access, Excel

Experience

  • Customer Value Reporting (Development)

    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.

Skills

  • Languages

    SQL, VB, C#, Visual Basic .NET (VB.NET), VBScript, JavaScript
  • Tools

    Informatica ETL, Microsoft Visual Studio, Automic (UC4), Toad, Tableau Desktop Pro, Tableau
  • Platforms

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

    SQL Server 2008, SQL Server 2014, Teradata Databases, SQL Server 2016, PL/SQL, Teradata, PL/SQL Developer, Oracle PL/SQL, ANSI SQL, PostgreSQL, MySQL, Netezza
  • Other

    PL/SQL Tuning, Data Virtualization, Informatica, Task Automation, Tableau Server
  • Paradigms

    Waterfall Development, Agile Software Development, Oracle ODI
  • Frameworks

    .NET

Education

  • Bachelor's degree in Information Systems
    2000 - 2002
    University of Massachusetts Lowell - Lowell, MA, USA
I really like this profile
Share it with others