Paul Perry

Experience

• 

  DpiX

  Jan 2020 - now

  Programmer/Analyst IV

  • Currently working as an independent contractor with the company about 10 – 12 hours per week. Client is converting the CAMSTAR MES system to OpCenter MES. Advising and mentoring client with the design how to map existing processes, flows, operations, products, events, etc. from the existing MES to the new MES. Design a new ETL process to bring data into the existing Data Warehouse so that both systems can function in parallel allowing to eventually phaseout and retire the old CAMSTAR MES system and migrate to the new OpCenter MES system seamlessly.• Lead Developer responsible for the company’s MES, Data Warehouse and SPC systems. The Manufacturing Execution System (MES) is a combination of the proprietary CAMSTAR system and a custom written C#/ASP.Net web based application that sends and receives XML transactions to/from MES. All data in MES, Data Warehouse and SPC are stored in SQL Server databases. Responsible for the custom SSIS ETL process written in C# and Sql Server stored procedures that load the Data Warehouse. XML files from the manufacturing tools are imported into the MES and Data Warehouse through a custom written C# application and the ETL process. The Statistical Process Control (SPC) system pulls data from the Data Warehouse which uses stored procedures to transmit the data into the proprietary InfinityQS SPC system. Custom TIBCO Spotfire reports are used to display summary and calculation data as well as graphs, histograms and images that operators use to easily visualize if manufactured products fall within specification and control limits set in SPC and contain any defects.Currently working as an independent contractor with this company with the same duties 10 to 20 hours a week. Show less

• 

  Gainwell Technologies

  Jun 2021 - now

  Advisor Programmer Analyst

  • Development lead with 2 other developers on a data conversion project combining 3 SQL Server based applications using ProC with Embedded SQL on HPUX and Linux on AWS to a single off the shelf SQL Server based application. Team lead for the data mapping and data conversion portion of the project. Responsible for designing the data migration solution from the 3 databases to a required flat file format provided by the vendor. Tools, programming languages and environments were limited to what was available with Gainwell. Tools used are ProC, SQL Server, Oracle, T-SQL, PL/SQL, AutoSys, IWS, AWS, Linux, HPUX, shell scripting, SSIS and SSRS. Show less