Summary
Overview
Work History
Education
Skills
Personal Information
Experience Years
Timeline
Generic

Paul Pickett

Plymouth,MN

Summary

Software Engineer with expertise in REST API development and SQL database management. Proven ability to optimize business processes and enhance system performance. Strong problem-solving skills and experience in collaborating within agile teams to deliver scalable solutions.

Overview

18
18
years of professional experience

Work History

Consultant Software Engineer

CGI Inc.
08.2022 - 05.2025
  • As part of the development effort to modernize ageing software. Developed backend scheduling utilities for plant bottling systems in the Parsec TrakSys system. Developed T-SQL stored procedures for KPI reports. Technologies used include C#, .NET, .NET Core, Azure, Postgres, SQL Server, Sybase, Oracle, and TrakSys.

Software Developer

Cargill
02.2022 - 07.2022
  • Worked on design and maintenance of labor analysis application. This project allowed plant to run simulations of plant operations given current production requirement and staffing levels to optimize plant performance. Technologies used include Python, Flask, FastApi, Django, PostgreSQL.

Software Developer

Compeer
08.2021 - 01.2022
  • Participated as part of the software engineering group to develop REST API to orchestrate loan automation across CRM. Helped with DevOps to build software releases. Managed SpecFlow automated testing. Technologies used include C#, .NET 5, MS SQL, JSON, Azure DevOps, API-M, Azure Service Bus.

Test Automation and Workflow Consultant

Best Buy
08.2021 - 09.2021
  • Assessed Best Buy engineering teams’ test automation and workflow. Assessed each teams’ strengths and areas for improvement related to test automation and tools. Conducted meetings with each engineering team to find out current testing processes and workflows. Reviewed current tools Best Buy teams were utilizing and outlined different functions and focus improvements for each team.

Software Developer

Cargill
05.2021 - 07.2021
  • Developed REST API to expose animal nutrition lab test data. Worked with the Core Sample team to gather requirements and coordinate development. Created a batch loader process to load data from Hadoop warehouse to PostgreSQL database. Collaborated with other developers to design the REST API and PostgreSQL database. Worked with Cargill employees to design the workflow process and TRC compliance reviews. Technologies used include C#, .NET 5, Hadoop, PostgreSQL, JSON, AWS, Docker, Impala ODBC.

Lead Systems Architect

Whitebox Advisors
10.2012 - 10.2020
  • Create centralized development framework that reduced development time by at least 50% by allowing developers to purely focus on the business rule side of development. Created over 40 applications/services that were 100% utilized by the front and back offices.
  • Empower employees to manage over 100 different tasks that involved report generation, data processing, monitor servers and troubleshooting workflows by using a single tool (VisualCron).
  • Develop financial information model database that houses all source data for operations which allowed each department to pull clean data to optimize the processes and workflows.
  • Created a solution to decrease our expenditures to Bloomberg by creating a centralized Bloomberg API service to capture all outgoing requests to Bloomberg to validate the fields and tickers were valid. This solution reduced our Bloomberg data costs by 35%.
  • Manage 10 developers and contractors to reengineer all workflows for key systems which include accounting, order management, treasury and compliance systems.
  • Mentor and train developers in using proper coding standards and methodologies such as single pattern, inversion of control (IOC) and single responsibility principle.
  • Develop strategic relationships with vendors to thoroughly understand the intricacies of key systems to save Whitebox time in development and costs.
  • Used C#, .NET, .NET Core, SQL Server, JSON, WCF, XML, MongoDB, XAML, WPF, RSL, T-SQL.

Sr. Software Developer

TEK Systems, Cargill
05.2010 - 09.2012
  • Maintain legacy classic ASP web application and developed and led ASP.Net training program for full time employees.
  • Architected and deployed a combined .Net/classic ASP framework to run the required web platform, thus preventing a complex rewrite of legacy systems.
  • Consolidated .Net web applications into a single solution creating a common framework for the combined applications.
  • Created complex tax schedules and reporting tools.
  • Created a windows service to receive and process flat files from all business units’ financial systems which integrated with Cartesis Financial Information Management. The implemented solution reduced processing time from 3 days to less than 2 hours.
  • Developed conveyor app to scan tracking numbers and provide real-time weight analysis to verify package content.
  • Developed a wide variety of capabilities for two eCommerce sites and for company intranet sites.
  • Used C#, .NET, .NET Core, SQL Server, T-SQL, ASP.NET, HTML, JavaScript, CSS, Ajax, WCF, Web Api.

Software Engineer L3

Virtual Radiologic
11.2007 - 05.2010
  • Maintain legacy classic ASP web application and developed and led ASP.Net training program for full time employees.
  • Developed a web application to monitor hospital VPN connections which retrieved router information about the VPN tunnels using SSH, which provided advance alert and troubleshooting information for critical hospital and business function.
  • Developed a new Radiology Technician web application, which consolidated two separate critical business unit applications into one integrated framework, which streamlined reporting and enabled a significantly more efficient radiology workflow.
  • Developed a new database and code base to process all login procedures, consolidating all the security databases into one universal security model thereby enabling a single sign-on system.
  • CO-architected an Enterprise Software radiological information system, which was delivered ahead of schedule and improved system performance and efficiency of radiologist which enabled the company to create to new business line offerings.
  • Updated Windows Service program Report Monitor to support multiple Radiology Practices, mapping and processing incoming faxes and auto-forwarding to the individual Radiology Practice’s.
  • Used C#, XML, WCF, SQL, JavaScript, JQuery, Java.

Education

University of MN -

University of MN

Skills

  • C# programming
  • NET framework
  • REST API development
  • SQL database management
  • Test automation
  • Software design principles
  • Agile methodology
  • DevOps practices
  • Business process optimization
  • Problem solving
  • Continuous deployment
  • Continuous integration
  • Scalable system design
  • API design and development
  • Automated testing frameworks
  • Software architecture design
  • Microservices architecture
  • Quality assurance testing
  • Adaptability and flexibility
  • Performance improvement
  • Application development
  • RESTful apis
  • Script writing
  • Gather requirements
  • Microservices
  • Back end development

Personal Information

Title: Consultant Software Engineer

Experience Years

19

Timeline

Consultant Software Engineer

CGI Inc.
08.2022 - 05.2025

Software Developer

Cargill
02.2022 - 07.2022

Software Developer

Compeer
08.2021 - 01.2022

Test Automation and Workflow Consultant

Best Buy
08.2021 - 09.2021

Software Developer

Cargill
05.2021 - 07.2021

Lead Systems Architect

Whitebox Advisors
10.2012 - 10.2020

Sr. Software Developer

TEK Systems, Cargill
05.2010 - 09.2012

Software Engineer L3

Virtual Radiologic
11.2007 - 05.2010

University of MN -

University of MN

Similar Profiles

CREATE PROFILE
Paul Pickett