Patrick Trant

Experience

• 

  Simutronics Corp.

  Jan 2005 - now

  Assistant Product Manager, Development

  * Manage a development team of remote, independent contractors* Develop systems for extracting and parsing system logs for reports* Design and implement game systems in proprietary scripting language* Debug and resolve reported bugs* Document code and processes for internal and external end users

• 

  Wolters Kluwer

  Jul 2006 - Aug 2022

  * Develop and implement workflows* Design processes for automated data extraction and import from multiple datasets and technology platforms [PowerShell, Python]* Query and create reports for key performance indicators [SQL, NoSQL]* Monitor processes and infrastructure, respond and resolve alerts* 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 Show less

  • Software Engineer

    Jan 2008 - Aug 2022

  • IT Admin & Support Analyst

    Jul 2006 - Jan 2008
• 

  Guild

  Sept 2022 - now

  Senior Developer, Business Intelligence

  * Transform and structure large datasets via SQL into reusable formats through dbt models utilizing star schema and data vault methodologies [ETL, dbt, Data Vault]* Build and define new reporting infrastructure and tables based on needs of the business [Snowflake]* Work closely with product, engineering, and analytics teams to scale reporting architecture and the ETL 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. Airflow, Snowflake, dbt, Looker, GitHub)* 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) [shell scripts, Python] Show less