Patrick Trant Email & Phone Number

Wichita, Ks, Us

* Transform and structure large datasets via SQL into reusable formats through dbt models utilizing Kimball/star schema, creating fact and dimension models, and data vault methodologies [ELT, dbt, Kimball, data vault]* Develop, maintain, and debug over 1,150 dbt data models and 250k lines of SQL [dbt, SQL]* Build and define new reporting infrastructure, permissions, and tables in data warehouse with Terraform for Infrastructure as Code [Snowflake, Terraform, IaC]* Review and optimize query performance - last 2 day company hackathon prompted the review and optimization of our most costly queries and resulted in a $50k annual savings* Work closely with product, engineering, and analytics teams to scale reporting architecture and the ELT pipeline based on source of truth tables* Create and update data visualization views and explores for internal and external reporting [Looker]* Support reporting infrastructure tools and systems (e.g. Terraform, IaC, Fivetran, Airflow, Snowflake, dbt, Looker, GitHub, AWS)* Monitoring alerts and anomaly detection efforts to measure performance, accuracy, and usage of data and reports [Splunk, Datadog]* Create and implement creative solutions to maximize system efficiencies (e.g. using scripting languages to automate manual processes) - lead initiative to research and setup dbt defer via automated script for 30+ analysts' local development environment, resulting in savings against Snowflake compute costs and hundreds of hours of developer time which no longer had to be spent waiting for models to build [shell scripts, Python]* Mentored and helped other analysts and engineers to learn new tools, best practices, and to grow their careers - frequent peer sessions to teach and assist in troubleshooting - hosted open office hours to allow others to join and ask questions

Wichita, Ks

* Develop and implement workflows* Design processes for automated data extraction and import from multiple datasets and technology platforms [C#, PowerShell, Python]* Query and create reports for key performance indicators [SQL, NoSQL]* Monitor processes and infrastructure, respond and resolve alerts [Azure]* Review and optimize existing processes* Create data models, views, reports, and dashboards [Metabase]* HCL Notes/Domino (formerly known as Lotus Notes and IBM Notes) Developer and Administrator* Design and code manual, scheduled, and automated database agents [LotusScript, Formula Language]* Implement views, forms, and other application logic

Wichita, Ks

* Automate daily build processes [Batch, PowerShell, Python]* Analyze and resolve errors* Software quality assurance testing and bug reporting

Bachelor Of Science (B.S.), Computer Science

Computer Science