Noah Gary

Application Developer

Louisville, Kentucky, USA

Skills

Work Experience

I led the engineering team's efforts in managing data pipelines, utilizing tools like Cookie Cutter, Pulumi, Airflow, and DBT for data integration, transformation, and migration in GCP.
Developed custom data reporting and analysis solutions, including shell scripts to iteratively fetch historical Kochava data and Jupyter Notebooks for ad-hoc pipeline issues.
Managed cloud resources with Pulumi Infrastructure as Code (IaC), automating deployments via GitHub Actions.
Advanced data management using SQL for DBT transformations from structured and unstructured data into a graph-based model for enhanced business insights.
Designed Airflow DAGs for running data transfers and triggering DBT transformations on a schedule, optimizing batch processes.

Pioneered a DBT project, transforming it into our standard for dimensional warehousing, streamlining ETL/ELT processes with data lineage graphs and DRY SQL models, and enhancing team adoption and system clarity.
Managed DBT job execution via Airflow DAGs and devised a DBT-based algorithm for hourly driver safety score calculations.
Automated driver safety score dissemination through pub/sub after DBT refreshes, leveraging Python futures for message batching.
Established GCP data pipelines for advertising data retrieval, significantly optimizing cloud functions and API data processing.
Refined our car insurance quote API for efficiency, slashing redis cache rebuild times to under 13 seconds, and set up triggers for automatic data ingestion into BigQuery upon new file uploads.
Integrated Datadog for robust application log monitoring, ensuring long-term operability.

Developed AWS CloudFormation templates for Auth0 secured APIGateway routes, enabling Lambda functions to interact with AWS services like Redshift, RDS, and DynamoDB, with Cloudwatch for logging.
Implemented automated deployments via GitHub Actions to AWS Cloudfront, optimizing NextJS React website distribution across the US for enhanced scalability and response times.
Integrated Looker and Microsoft PowerBI dashboards into client portals, utilizing Looker API and Microsoft Authentication Library (MSAL) for secure access.
Streamlined prototype deployments to Vercel for NextJS/JAMStack applications and integrated Auth0 authentication.
Leveraged AWS Cloudformation for efficient data pipeline creation to DynamoDB and Redshift, and deployed New Relic One to monitor client cloud services, focusing on cost control comprehensively.
Gained practical experience with Snowflake DBMS.

Designed and implemented an ETL architecture using AWS Lambda Functions and CloudFormation, enhancing data processing and management capabilities.
Developed and managed Apache Airflow DAGs for orchestrating regular ETL tasks, streamlining workflow efficiency.
Employed Apache Spark in Scala to import and query log data from Amazon S3 and optimize data analysis processes.
Utilized command-line tools for parsing and validating CSV data, ensuring data integrity by logging errors for quality assurance.
Leveraged PySpark and Amazon EMR for efficient data importation, enhancing data accessibility and analysis.
Established and enforced data contracts by creating schemas for imported data, ensuring consistency and reliability in data utilization.

Utilized the Laravel Framework to route requests, Access Data, and display webpages in the Model View Controller architectural pattern.
Developed Vue JS components and made use of its directives to create dynamic and data driven web pages
Used Amazon Web Services with s3 storage containers to upload and retrieve files using the Laravel Storage Facade
Utilized Git version control to fix bugs and develop features for the site in conjunction with JIRA and BitBucket to track and resolve issues
Developed Unit Tests for the platform
Used elastic search to modify how our site shows relevant products

Maintained constant communication with clients throughout the development process
Utilized a lattePanda Single Board Computer as an HTTP server
Created documentation for software I developed
Built HTTP Requests in PHP to send data in JSON back to a server to be stored in a database
Developed a system to track the location of hazardous waste in geographic areas

Implemented MQTT into an Android Application and set up an MQTT server
Worked with graphic designers to develop an android Application
Worked with an Arduino One and a Raspberry Pi to create a RFID access control method to the building
Set up a Raspberry Pi as a wireless router and server
Make POST requests in C++ from an Arduino One to a web server on a Raspberry Pi
Implemented a login system using a database and hashing algorithms in the PHP programming language

Worked with languages such as: PHP, Javascript, Python, HTML/CSS, Julia, C, and Bash
Familiarized myself with JSON as well as XML
Familiarized myself with the crontab, installing, updating and upgrading new software from the Linux command line.
Utilized git version control
Managed an Apache2 web server as well as exploring other possible web servers such as: NGINX, and the python SimpleHTTPServer
Actively involved with improving on the design of the page
Utilized in house responsive design code
Worked with a team to create a widescreen interactive map that shows heat maps of kentucky using different data points such as rainfall, Solar Radiation, and wind speed
Optimized the site for mobile
Legacy site
New Site

B.S. in Computer Science - Systems and Scientific Applications

High School Diploma

A real time weather network monitoring system that tracks weather conditons on and around Western Kentucky University's campus