Peter Kennedy

Experience

• 

  MAQ Software

  Mar 2016 - Apr 2018

  Software Engineer

  Consulted with clients to convert their idea into a robust business intelligence solution.Led several development teams in an iterative and agile environment.Optimized legacy SQL scripts to run 60% faster.Wrote a script to repair a geography hierarchy that contained over 50% invalid records.

• 

  Microsoft

  Apr 2018 - Jun 2019

  Software Engineer (contract)

  With vague requirements from the client, I delivered a full reporting solution in less than a month that exceeded expectations. This solution was all-encompassing and removed the need for the existing multiple single-purpose reports.Designed several visuals that helped the business identify the biggest pain points, which when resolved, led to 50% faster runtimes.

• 

  HCL Technologies

  Apr 2020 - Aug 2020

  Software Engineer

  Designed efficient DAX measures to apply row-level security across the entire report without taxing performance.Optimized legacy SQL stored procedures to reduce total ETL runtime from 24+ hours to less than 5.

• 

  Microsoft

  Feb 2021 - Sept 2021

  Software Engineer (contract)

  Developed a dynamic report containing 100+ million rows that refreshed visuals in less than 10 seconds.Took the initiative to develop features that were not requested, but were very popular once shown to the clients.Designed tiny callouts in the report visuals to show the business when their data was “invalid”. This enabled users to easily identify problems in business workflows to fix. This also allowed users to see all data in one place instead of needing multiple reports for valid vs invalid. Show less

• 

  Trident Seafoods

  Jan 2022 - now

  Business Intelligence Analyst