Scroll To View More
Adam Knust, Data Architecture Developer in Velpen, IN, United States
Adam Knust

Data Architecture Developer in Velpen, IN, United States

Member since March 5, 2018
Adam is an experienced and successful data architect and engineer, having led the BI practice for a $4 billion company and three successful data warehouse and business intelligence implementations. Along with RDBMS platforms, Adam has Spark, Hive, and Sqoop experience on Hadoop with Java, Python, and Scala. As a former business manager, he communicates very well with all levels and picks up on the business domain extremely fast.
Adam is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 7 years
  • Data Architecture, 5 years
  • ETL Implementation & Design, 5 years
  • Query Optimization, 4 years
  • SQL Server Integration Services (SSIS), 4 years
  • SQL Server Analysis Services (SSAS), 3 years
  • Hadoop, 1 year
Velpen, IN, United States

Availability

Part-time

Preferred Environment

MS SQL, SSMS, IntelliJ, PyCharm, VS, Git

The most amazing...

...thing I've single-handedly built is two data warehouses and BI solutions from requirements gathering to production delivery.

Employment

  • Manager of Data Engineering

    2015 - 2018
    Next Gear Capital
    • Architected a state-of-the-art data warehouse and ETL process on the 2016 Microsoft SQL Server stack for a $4 billion financial services company.
    • Sunsetted an archaic BI platform in favor of modern, feature-rich technologies and more lean, enterprise-grade processes.
    • Migrated all code into Git and automated deploys through Bamboo scripts.
    • Served as engineering lead on our Release Train team, which encompassed five teams of developers.
    • Hired, trained, and mentored three teams of developers.
    Technologies: SQL Server 2016, SSIS, SSAS, SSRS, Scala, Java, Python, Hadoop
  • Developer

    2014 - 2015
    Next Gear Capital
    • Supported modifications to the sales data warehouse via T-SQL stored procedures to account for new and updated KPIs and org structure.
    • Updated existing risk and KPI applications in C# and ASP.NET.
    • Developed extracts and transformations from Microsoft Dynamics GP accounting platform.
    • Developed third-party integrations to support periodic information transfer.
    • Mentored junior developers.
    Technologies: SQL Server 2008, SSIS, SSAS, C#, ASP.NET
  • Manager of Data Analytics

    2013 - 2014
    IU Health
    • Oversaw data collection of ICD, CPT, and other clinic data points.
    • Developed an ETL process to extract data from our EMR and schedule solutions to analyze outcomes and costs of onsite clinic solutions.
    • Developed costing models to prove cost overall savings of onsite clinics against traditional primary and immediate care strategies.
    • Developed a reporting solution for the interface with the data warehouse to generate reports for clients.
    • Helped effect change with our occupational health partners by sharing best practices and operational trends.
    Technologies: Postgres, OpenTalend, Python
  • Strategic Data Manager

    2012 - 2013
    Purdue University - College of Agriculture
    • Translated the strategic plan into objective metrics.
    • Developed ETL processes to extract data from the siloed data sources to bring together in a comprehensive data warehouse.
    • Provided KPI reporting to the deans and department heads, which was used to make data-based decisions.
    • Served as an information resource for state and federal audits.
    • Served as the primary functional analyst for Purdue's enterprise data warehouse initiative.
    Technologies: SQL Server 2008 R2

Experience

  • NextGear Capital Enterprise Data Warehouse (Development)

    Modern Data Warehouse platform and process to support a $4 billion financial services company. The initial sub-project was a broadly scoped revenue data mart, which provides detailed insight into revenue across all aspects of the business. It also supports product decisions including risk-based pricing. Technologies used were SQL Server 2016, SSIS, SSAS, and Tableau.

  • NextGear Capital Report Modernization (Development)

    Sunset the IBI WebFOCUS platform, which only supported tabular reporting, and instituted Tableau, SSAS, SSIS, and SSRS 2016 to support the differentiated information needs of our executives, operations teams, sister companies, and third parties. We also revamped the requirements gathering process to better scope the business problem so that devs could implement the correct solution (i.e., dashboards, mobile reports, standard PDF reports, etc...).

  • IU Health - Client Reporting Standardization (Development)

    Client reporting had historically been very manual, tedious, and error-prone. To solve these problems, I built a complete data warehouse and reporting solution to automate information collection and reporting so that effort could be spent on commenting and elaborating on the report for our clients.

  • Purdue - Strategic Plan and Departmental KPI Reporting (Development)

    The College of Agriculture had a number of initiatives outlined in its strategic plan; however, they had no means to measure success. To solve this, we had to work together to identify objective measures that mapped to each initiative, then collect that information from the disparate systems that housed this data across the university. Then I developed processes to extract and bring this data together so that automated reports could be built and provided for data-driven decisions.

Skills

  • Languages

    SQL, Java, Scala, Python
  • Storage

    Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Database Replication, Database Administration (DBA)
  • Frameworks

    Scaled Agile Framework (SAFe), Hadoop
  • Tools

    Git, Maven
  • Paradigms

    ETL, ETL Implementation & Design
  • Other

    Data Architecture, Query Optimization
  • Platforms

    Linux, Windows, MacOS

Education

  • Bachelor's degree in Economics
    2000 - 2004
    Purdue University - West Lafayette, IN
Certifications
  • Microsoft Certified Professional
    JULY 2017 - PRESENT
    Microsoft
I really like this profile
Share it with others