Summary
Overview
Work History
Education
Skills
LinkedIn
Project
Timeline
Generic

Caleb Gundberg

Winona,MN

Summary

Accomplished Technical Program Analyst with a robust background in managing and optimizing technical programs and IT projects. Highly adept at analyzing complex data, integrating advanced systems, and developing innovative software solutions / reports to drive organizational efficiency and effectiveness. Bridging and coordinating cross-functional teams, streamlining processes, resolving technical issues with exceptional problem-solving skills and strategic thinking. A strong commitment to continuous improvement with resilient character and great communication skills with the ability to translate business problems into actionable technical requirements.

Overview

3
3
years of professional experience

Work History

Technical Program Analyst

Fastenal
05.2023 - Current
  • Facilitated communication between stakeholders, technical teams, and management to align project goals and deliverables.
  • Developed project plans, timelines, and milestones, tracking progress and addressing issues as they arose.
  • Developed and maintained dashboards to monitor key performance indicators (KPIs).
  • Successfully led the implementation of a Legacy Reporting Decommissioning Effort that resulted in 1100 individual reports or about 60% of Enterprise Reporting being disabled / replaced.
  • Supported the implementation and integration of new technologies and systems, providing technical guidance and troubleshooting.
  • Conducted root cause analysis for technical/program issues, developing and executing corrective action plans.
  • Worked well under pressure to coordinate and address production level financial statement reporting inaccuracy with hotfix implementations.
  • Gained additional responsibilities as my performance improved to be able to oversee three portfolios within the Enterprise BI Team.
  • Created effective documentation, deployed code using multiple pipelines, and created system change notes.

PT Programmer

Fastenal
06.2022 - 05.2023
  • Designed and implemented dataflows, datasets, implemented security and developed critical enterprise reports on Power BI.
  • Wrote several hundred PL/SQL queries to satisfy unique business requests.
  • Followed the SDLC to implement effective software
  • Designed intuitive graphical user interfaces to improve user experience.
  • Performed data cleaning, transformation, and loading (ETL) processes to integrate data from multiple sources.
  • Optimized SQL queries for performance, ensuring efficient data retrieval and processing.
  • Helped implement stored procedures to populate row level security (RLS) for individual reporting and shared sets.

Geospatial Analyst

Saint Mary's University of MN Geospatial Services
05.2021 - 09.2023
  • Created effective maps, charts and other images based on project-specific requirements.
  • Determined location and dimensions of objects.
  • Followed the lead and learned from a lead analyst
  • Performed analysis to classify wetlands and track objects in a database

Education

Bachelor of Arts - Software Development | Business & Data Analytics

Saint Mary's University of Minnesota
Winona, MN
04.2023

Skills

  • Power BI (Dashboard Development, Data Modeling, DAX)
  • SQL (Query Development, Performance Optimization, Stored Procedures)
  • Strategic Planning
  • Requirements Gathering
  • ETL Processes and Data Integration
  • Problem-Solving and Critical Thinking
  • Azure Technology Stack (Storage Accounts & Synapse)
  • Communication and Presentation
  • Databricks and PySpark (Python) Skills
  • Project Management
  • Highly Proficient in Excel
  • Functional Specification, Solution Design and Issue Management (JIRA, ServiceNow & Confluence)

LinkedIn

https://www.linkedin.com/in/caleb-gundberg-683926196/

Project

Consumer Preference Among Above or Below Average Priced Trucks to Reveal Insights into the Truck Market in America


Cleaning, transforming, and mining insight out of over one million rows of data. This included 30+ continuous variables, all having to do with details surrounding each individual sale of a truck, which were used to predict 1 or 0 for higher or lower than a certain price of the truck. I used an OLAP to run my stepwise regression model. The model then used TFPN (True, False, Positive, Negative) analysis with a threshold to show the accuracy in predicting the price of a vehicle higher or lower than a threshold.

Timeline

Technical Program Analyst

Fastenal
05.2023 - Current

PT Programmer

Fastenal
06.2022 - 05.2023

Geospatial Analyst

Saint Mary's University of MN Geospatial Services
05.2021 - 09.2023

Bachelor of Arts - Software Development | Business & Data Analytics

Saint Mary's University of Minnesota

Similar Profiles

CREATE PROFILE
Caleb Gundberg