Patrick Staight

I love organizing things and solving logic puzzles. 

PROFESSIONAL SUMMARY

• 8.5 years software development experience, mostly backend Web development.
• Experience with Windows based environments using C# and Microsoft .NET Technologies.
• Excellent ability to develop and review design documents as well as efficiently generate training documents for future resources while learning.
• Experience in SCRUM for agile development, reviewing peer’s code for quality and completeness.
• Excellent skill with RDBMS (MySQL, Oracle11g, Microsoft Transaction SQL).
• Extensive abilities in interfacing with clients, suggesting viable software solutions and ensuring quality delivery of products to the clients. 
• Very Good knowledge of JSON, JavaScript, jQuery, AJAX, XML, REST, JSON, Bootstrap and HTML5.
• Team Player with strong leadership, problem solving, planning, team building and project management skills.
• Coded application components using a test-driven development approach.

TECHNICAL SKILLS 

Languages and Tools      :  C#.Net, Microsoft.Net Framework, C/C++, PHP

Web Technologies          :  MVC, ASP, AJAX, JavaScript, HTML, jQuery, XML, JSON, HTML5.

Services                               :  Web API, Restful, OAUTH, Web Services

ORM                                      :  LINQ (LINQ to SQL), Entity Framework 

Scripting                              :  PowerShell and Bash

Database and Tools        :  Oracle 10/11g, T-SQL Server, MySQL, SSRS and SSIS, Crystal Reports.

Server/Others                   :  Microsoft Internet Information Server (IIS), Apache Server, Team Foundation Server (TFS), Git, SVN, Mercurial.

WORK EXPERIENCE

Client: SurePrep LLC – Irvine, CA                                                               5/10/2022 to 3/10/2023

Role: Software Developer

Project: Building the Web API based v2.0 of SurePrep’s flagship tax preparation software.

I was on the API team. We handled all the internal logic and database calls needed for the UI to function. While learning to do corporate taxes is outside my job requirements, I collected extensive documentation on the process and I’m pretty good at making the tax binders I need as testing data for my code.

Roles and Responsibilities:

• Design and implement new API endpoints to support the front end.
• Design and implement SQL stored procedures to connect with my API.
• Maintain code quality using SonarQube and our list of coding best practices.
• Create documentation and requirements from users, and v1.0 code from scratch.

Environment: C#, .net Core, T-SQL, Swagger, Signal-R, SonarQube, Azure DevOps, git, Dapper

Client: FedEx - Remote                                                                                                  5/3/2021 to 7/27/2021

Role: Software Developer

Project: Transition logistics and scheduling from legacy mainframe to cloud services

I rewrote existing scheduling systems and other information systems to use RESTful APIs with an Adobe ColdFusion web front end. I worked remote and became used to reporting my progress and collaborating using Microsoft Teams.

Roles and Responsibilities:

• Migrate scheduling systems.
• Develop Adobe ColdFusion page management scripts.
• Develop RESTful APIs using the Swagger API tool
• Develop systems using RESTful API calls

Environment: Oracle, OnBase, Adobe ColdFusion, Windows Server, C#, .net, Swagger

Client: Prelude Systems Inc.  -  Irvine, CA                                                         8/12/2019 to 11/6/2020

Role: Software Developer

Project: Maintain and Enhance Critical Business Web Apps at Solar Turbines

I was the primary resource for filing support and enhancement requests for Solar Turbine’s 20 business webapps. These apps are mostly under the auspice of Human Resources having uses from processing Turbine reseller contracts to managing hazardous waste.

Roles & Responsibilities:

• Added new fields to web-based contracts.
• Reviewed system logs to solve in-flight bugs such as an approved but stuck contract.
• Added new features to the badge system for sorting and displaying records.
• Added features for exporting contracts in Excel and Word.
• Configured and debugged new IIS settings for web app overhaul.

Environment: Visual Studio .Net 2019, C#, Oracle, ASP, IIS

Project: Improvement to California Air Quality Annual Emissions Report Tool

I developed and deployed a new Toxic Air Contaminant fee calculation and collection system. I documented and modernized some of the existing code base. I built administrative interfaces to manage amendment requests and assignments.

Roles & Responsibilities:

• Improved a C#, .Net MVC fee calculator, handling $100’s of millions in payments.
• Built a workflow tracking system using T-SQL which displayed progress history and file states.
• Optimized the yearly SQL import process which had been taking hours and now takes less than a minute.
• I was the SSRS expert for creating documents and storing them in our data warehouse OnBase.

Environment:  VS.Net 2017 and 2015, MVC 5, C#, .NET Framework 4.6, Microsoft SQL Server, HTML5, CSS, SSRS, Bootstrap.

Client: Pacific Architects and Engineers, Coronado CA                                 11/9/2015 to 4/9/2017

Role: Web Developer/Software Developer

Project: NAVY S.C.O.R.E. (Southern California Offshore Range) Contract

My team wrote scheduling software (D-CAST), which is currently used by 22 ranges mostly from the NAVY but also the Air Force, Marines, and our allies in Japan.

D-CAST handled additional reporting requirements which were otherwise hard to get the sailors to complete. When scheduling range time, D-CAST also provided backend coordination with environmental impact reporting, FAA, Com. 3rd Fleet, the NAVY TRIMS System and other API’s.

The FAA interface is needed because some airspace is joint use between commercial air traffic and military training. I had primary responsibility for this critical body of code upon which human life depends.

The 3rd Fleet Command interface was needed because submarine locations are top secret and any training exercise involving an underwater detonation in the Pacific Ocean must be reviewed at the top level. I was involved in the design of this critical system and some maintenance.

TRIMS reporting is a Navy wide accounting system. The report can be tedious and Navy personnel are usually excited when they discover our software does it for them. Maintaining this value-added feature was one of my responsibilities. 

Roles & Responsibilities:

• Developed an HTML5, time-based animation replays of events from time coded record.
• Developed an HTML5 slideshow replay that syncs sound and image files.
• Designed systems to support scheduling for thousands of high demand daily users.
• Wrote Ajax scheduling forms and data collection tools connected to our Oracle backend.

Environment:  Linux, Oracle, PHP, JavaScript, CSS, HTML5, Bootstrap, jQuery, Mercurial, Bash.

Client: General Atomics EMS, Poway CA                                                               3/9/2015 to 9/24/2015

Role: Software Developer

Project: Control Systems

I overhauled and modernized a think-and-do fuel yard control system which had been written 20 years ago. The software had 20 years of stop gap patches and one-off maintenance. I documented the code, streamlined it, and got it working in a modern environment. I am particularly proud of a program I wrote for converting the in-house scripting language to run in PowerShell along with my custom PowerShell library.

I had additional side projects, for example I wrote an MVC interface for a UAV flight recorder system.

Roles & Responsibilities:

• Wrote fault tree analysis software for UAV flight recorder system.
• Created a .Net MVC web front end for fault tree software.
• Built a windows services hardware interface for a fuel control system and card reader.

Environment:  VS.Net, MVC, C#, .NET Framework, SQL Server, PowerShell

Client: ResortShare, Irvine, CA                                                                                9/15/2014 to 2/27/2015

Role: Software Developer

Project: Everything

Primarily, I designed and deployed the new SQL database to replace a Microsoft Access system which was failing to meet the needs of the growing company. I also helped move everything to Azure.

I was one of two programmers who handled all the software needs of this 55-employee startup company. My manager, the Chief Technical Officer, also did occasional programming.

I had countless jobs. I did system administration work as well as handling occasional technical support calls. If something needed to be done, I would figure out a way to do it. For example, in my spare time, I fixed the phones and printer when there was an issue.

Roles & Responsibilities:

• Wrote a program to quickly clean, organize and de-duplicate the customer lead files we bought so they could be loaded into our Salesforce system.
• Developed a weighted metrics T-SQL/C# solution for assigning inventory to sales.
• Managed Salesforce, our CMS (content management system) and CRM (customer relationship management) integration.
• Wrote an object-oriented simulator to test performance of different inventory to sales needs assignment strategies using previous years of sales data.

Environment:  .Net framework, C#.Net, Windows Forms, Microsoft SQL Server, Azure, MVC, JavaScript, HTML, CSS.

Client: Scantron, San Diego, CA                                                                                  1/1/2010 to 10/25/2013

Role: Software Developer/Data analyst

Project: Data Management Services

I started by collecting and generating data for our new product. Then I went into testing and finally I joined the development team. I wore one-off SQL based report systems for customers and connected them to the web front end.

Roles & Responsibilities:

• Handled data generation needs for Scantron’s major development project.
• Responsible for analyzing hundreds of data forms and answered questions the development team had about potential data.
• Wrote .NET MVC test cases for the product using C# and the Rhino Mocks library.
• In charge of organizing and writing T-SQL scripts and SSIS packages for a team of two data entry technicians.
• Wrote queries for customer reports and built web front ends to be run on demand.
• Assisted with ETL (Extract Transform Load) design and operation
• Wrote a SOAP based reporting system to communicate between servers and the clients.

Environment:  .Net 2.0, C#.Net, SQL Server 2008, JavaScript, CSS, IIS, AJAX

I have a BS in Computer Science from UC Riverside.