Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Patrick Summerfield

Patrick Summerfield

Boise,ID

Summary

Versatile professional experienced in data analytics, custom reporting, workforce management, and P&L management. As a Senior Analyst for T-Mobile, I excelled in resource planning, optimizing operations and collaborating cross-functionality. My Experience in P&L management adds depth to my analytical skills and strategizing to improve business goals. As a Custom Reports Programmer at Paylocity, I specialized in SQL and tailoring reporting solutions. I am eager to contribute my expertize to roles that demand data-driven insights and strategic thinking.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Custom Reports - Programmer 2

Paylocity
Boise, ID
01.2026 - Current
  • Collaborate with cross functional teams to ensure seamless integration of custom reports into Paylocity's reporting suite
  • Co-headed initiative to optimize report automation. measurable reduction in turnaround time to report completion from Start to Finish as well as First time accurate results.
  • Developed and delivered custom reports for clients allowing them to access and query data that meets their needs
  • Utilize SQL programmings skills to query and manipulate data
  • Managed multiple client requests, prioritizing tasks and meeting deadlines while maintaining high quality standards and communication with clients
  • Client interactions to understand wants and needs from reporting requests
  • Implemented best coding practices to improve code quality and maintainability.
  • Partnered with Lead and Junior developers, fostering skills development and knowledge sharing.
  • Identified opportunities for process improvement, leading to a more efficient development cycle.
  • Enhanced software functionality by identifying and resolving complex coding issues.

Custom Reports - Programmer 1

Paylocity
Boise, ID
11.2023 - 01.2026

Senior Analyst, Business Analysis

T-MOBILE
Meridian, ID
10.2013 - 11.2023
  • Collaborated closely with Senior Managers, Directors, and VP for specific data points/data requests within the company and customer markets
  • Partnered with Operations Managers in strategizing to maximize staffing and reduce Cost by 20%
  • POC for intra facing reporting decommission and transition to new program
  • SQL data mining and query creation
  • Validation on data tables for accuracy
  • SQL table maintenance and creation
  • Provided insights around Profit and Loss analytics to identify new strategies and areas of opportunity.
  • Enhanced current reporting with new functionality and automation
  • New report creation to drive initiatives and results including intraday reporting for real time engagement
  • Created, deployed and maintained reporting using data to help drive P&L
  • Managed a consistent inbox with frontline requests and updates.

Education

High School Diploma -

Timberline High School
Boise, ID
05-2017

Skills

  • Expert Excel and VBA Proficiency
  • SQL / MySQL
  • SSRS
  • PowerBI
  • Detail Oriented
  • Innovative
  • Collaborator
  • Data Collection
  • Business Analysis
  • Project Management
  • Workforce Management
  • Flexible and Adaptable

Certification

  • Excel VBA & Macros - Udemy
  • SQL Bootcamp - Udemy

Timeline

Custom Reports - Programmer 2

Paylocity
01.2026 - Current

Custom Reports - Programmer 1

Paylocity
11.2023 - 01.2026

Senior Analyst, Business Analysis

T-MOBILE
10.2013 - 11.2023

High School Diploma -

Timberline High School