Patrick Trant

Patrick Trant

Assistant Product Manager, Development

Followers of Patrick Trant178 followers
location of Patrick TrantWichita, Kansas, United States

Connect with Patrick Trant to Send Message

Connect

Connect with Patrick Trant to Send Message

Connect
  • Timeline

  • About me

    Technology enthusiast who enjoys learning new skills, researching emerging software and hardware, delving into critical problems, then designing and implementing solutions.

  • Education

    • Southwestern College

      -
      Bachelor of Science (B.S.) Computer Programming Technology
    • Butler Community College

      -
      Computer Science
  • 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

  • Licenses & Certifications

  • Volunteer Experience

    • Den Leader, Quivira Council, Pack 3584

      Issued by Boy Scouts of America on Jan 2022
      Boy Scouts of AmericaAssociated with Patrick Trant
    • Executive Board

      Issued by Wichita Youth Hockey Association on May 2024
      Wichita Youth Hockey AssociationAssociated with Patrick Trant