Paul Ching Email & Phone Number

Dexter, Mi

ProQuest 1099 sub-contractor for Kineetoz, LLC. (12/2013-03/2014)Provided Data ETL migration/integration from external MySQL database using TOAD for MySQL and Oracle SQL Developer in combination to output .csv feeds into a Salesforce CRM repository. It involved handling special Chinese character sets and oversized BLOBs: 1099 Computer Consultant for Systems Integrating (09/2006-10/2007)Consulted in Investigative Phase for private investor client identifying elimination/integration points for disparate MS applications into Cloud system for REO Real Estate Investor company. 1099 Computer Consultant for Systems Integrating (01/2005-03/2006)Contracted to create standalone intranet application of a Shipment Tracking System for a private logistics franchise company utilizing Web based client/server architecture, and integrated with legacy backend through daily batch feeds.

Dexter, Mi

Hiflex MIS application programmerMajor integrator for migration from Hagen OA MIS to Hiflex MIS of relevant data for transition. Performed custom PSQL query programming and maintained existing queries to ETL data for output reporting/feeds to peripheral services (GP, Hiflex HPI, XMLschemas, OnixEdit,etc.). Began analysis/design, ETL prototyping to integrate both MIS systems into a common Data Warehouse for enterprise-wide access.Hagen OA MIS application programmerPerformed Custom 4GL programming design/development and maintenance support of the resident MIS system using Roundtable IDE. Maintained Webspeed HTML pages serving output from the Openedge data repository. Evaluated/Created/maintained Crystal Reports, XML EDI, JDF feeds delivered by the repository.

Ann Arbor, Mi

Team Lead/Software Engineer II-III (03/01-09/04)Decreased development costs and expanded internal client base from 30% to 100% as Team Lead for project team in re-architecture of Data Warehouse(DW) in a major enterprise-wide Business System Replacement (BSR) Program. Software Engineer I/IS Tech Lead (12/97-03/01)Insured the Copyright Office designation of “document of record” of all archived PDF dissertations for ProQuest as Team Lead of design and development group to automate the integration of the Library of Congress/Copyright Office Recordation Document System(LC-CORDS) with the Dissertation Acquisition Tracking system(DATS). This project also eliminated the need to staff an additional scanning shift to handle production capacity and saved the company from having to invest $2,000,000 dollars for another camera.Created search and extract processes against both storage mediums and online DATS database to retrieve text copyright application data and PDF equivalent documents for feed through the CORDS application.Developed process to FTP outputs to LC-CORDS servers from the CORDS and DATS applications utilizing CRON scheduling.Designed internal email verification processes to parse CO email for document status responses (using VB).100% financial data integrity was achieved as member of Data Warehouse design and development group maintaining the company Data Warehouse on an Oracle DBMS. Programming included UNIX Korn shell scripting and Oracle programming in SQL and PL/SQL. Senior System Analyst (09/81-11/96)A turn-around time savings of 4 months was achieved by automating several manual processes with the design and implementation of Dissertation Acquisition Tracking System(DATS).