Employment
2015-present
Snr. Software Engineer
SWK Technologies Inc

I develop Custom Software and integrations for the Acumatica ERP System

2010 - 2015
Director of Engineering
The Macabe Associates

I work with consultants to flesh out business needs into feasible technical projects. I execute from conception through development, delivery, and support.

2006 - 2010
Software Engineer
The Macabe Associates

Rapidly prototype and build software to specification and provide technical support. Projects deal with ERP workflow, ETL, upgrade, and custom reports

2003 - 2006
IT Associate
Ipas

Developed internal .NET/SQL projects, implemented Sharepoint conversion, and provided general IT support

Contact
Here's how to get a hold of me.

Email
patrick711 at gmail.com

Find out more
www.patrickschen.com

LinkedIn
www.linkedin.com/in/pschen

GitHub
github.com/patrick711

Stack Overflow
stackoverflow.com/users/1048614/patrick-chen

Education

University of Washington Seattle
Certificate in Data Science 2016

University of North Carolina Chapel Hill
MS Information Science, 2004

University of Washington
BS Economics, 2002

Certifications
Acumatica Developer & Technical Administrator

Skills

Coding Skills
C#,TSQL,PHP,VB,Subversion,Java,Javascript,HTML,CSS,R

Technologies
Visual Studio, Acumatica, REST/SOAP Webservices, MSSQL Server, PowerBI, JSON

General Expertise
Solution design, Enterprise software development, Database design, UX design, prototyping, production build, documentation, and customer support

Projects
I solve customer problems, here are examples.

MAPADOC for Acumatica
I developed an Acumatica EDI solution that pulls in EDI data over REST service,creates Sales Orders, and uploads invoice data to EDI Service C#/.Net ERP

ERP SOAP integration
I worked on a team building a PHP application that syncs inventory between a consumer facing application and the Acumatica ERP system. PHP

Connectwise integration
I developed a custom integration between the Acumatica ERP and the Connectwise MSP C#/.Net ERP

Pro Bono DBA for Landesa
Created a PHP transcription software package for in-field survey entry and output to .csv for analysis in SSPS. Currently on GitHub

The Polish Imports
An import solution for a Fortune 500 customer to bring complex manufacturing data from frontline operations into their ERP

ACH/EFT integration
A suite of custom software solutions for creating several types of Banking transaction files in the Acumatica C#/.Net ERP

ERP ETL
Designed several import modules that utilize TSQL SPs and SSIS to import, validate, and transform data to fit into the SAGE 500 ERP.

Large System Upgrade
Undertook the upgrade of a large legacy system to a modern ERP. Over the course of several years I took a SQL 6.0 database system loaded with undocumented SQL and VB6 custom code and upgraded it to modern systems.

SQL Performance Analysis
Redesigned a TSQL Stored Procedure for ETL import in order to increase performance and efficiency.

SSIS/TSQL integration
Regularly integrate ERP into customer ecosystems via SSIS & TSQL SP.

SAGE 500 Paperless Office
Designed and developed a system that automatically PDFs, stores, and provides several retrieval options for documents printed in SAGE 500 ERP.

Fampix
Created a Windows 8 desktop app that pulls pictures of family members posted to Facebook using oAuth