Jon DiPietro

Technical

Programming Languages

Proficient in VB6, VB.NET, C#, ASP.NET, T-SQL, XML, HTML, CSS, Pascal, Fortran, Ladder Logic.

Familiar with C++, Javascript and Lisp.

Software

Development Tools and Environments: Microsoft Visual Studio (through 2008), Microsoft Visual Source Safe, Crystal Reports, Developer Express suite, Robohelp, CA Erwin, SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, Aspose, Countersoft Gemini, Dynamic PDF, Graphics Server, Image Glue, Infragistics Ultra Suite, XML Spy.

Databases: Microsoft SQL Server and Access.

Other: Microsoft Office, Microsoft Visio, Microsoft Project, Microsoft Expression Web, Adobe (Macromedia) Dreamweaver and Fireworks, Quickbooks

Process Control

Hardware: Programmable Logic Controllers (Allen Bradley, Siemens, GE Fanuc, Opto-22), vision systems, motion control, data acquisition, loop controllers, pneumatics, hydraulics, and instrumentation.

Software: GE/Intellution (iFix, Fix, DMACS), Rockwell Software (ControlView, RSView, RSLinx, RSLogix), Wonderware.

Business

Passionate, successful entrepreneur with domestic and international experience in operations, P&L management, strategic planning, and product development, sales, and marketing.

Demonstrated ability to break down complex challenges and deliver innovative solutions; usually with little or no resources.

Keen sense of market trends with a track record of exploiting them.
Uniquely qualified to leverage technology in order to improve the performance of all business areas: management, accounting, research and development, human resources, operations, sales, and marketing.

Accomplished speaker, with a talent for communicating abstract and/or complex ideas in clear, understandable terms through both written documents and presentations.

Broad professional skill base includes business development, financial management, product development, sales and marketing, project management, system integration, computer programming, design and administration of databases, networks, and web sites, and process control system engineering.

Bridge-Soft client;VB, VB.NET and SQL Server consulting contract in from June, 1999 – September, 2005

The original development of QMS occurred through a contract with specialty chemical manufacturer Shipley Company of Marlborough, MA (later acquired by Rohm and Haas).  It was an enterprise quality management system that maintained QC specifications for over ten thousand part numbers and managed the data entry of test results and created certificates of analyses for product shipments.  Technical details of the project included:

• Developed using Visual Basic 5.0 and 6.0 with a SQL Server back end.
• A central unattended application automatically rendered and delivered certificates of analysis for every product shipment.
  • The company could not ship product without this system functioning correctly.
  • In the original implementation, warehouse pick lists were pulled from querying the MRP system (PRISM). 
  • This was later replaced with an interface to SAP using the Developer’s Toolkit.  It retrieved the pick list from SAP in XML format, parsed the contents, and then rendered the certificate.
  • The certificate was automatically routed to the appropriate location based upon dynamic customer profiles.  They were printed to one of thirteen warehouses in North America and Europe, exported to PDF and emailed directly to the client, and/or exported to customer-specific XML formats and then uploaded via FTP.
  • Certificate results were wrapped into XML format and uploaded to SAP quality module via SAP Developer’s Toolkit via SOAP protocol.
  • I also wrote a web service to respond to data warehouse requests for data.  This service would retrieve results from the database in XML format and perform a bulk upload to the SQL Server data warehouse using XSLFO.
• An external web portal was written for Shipley customers to log in and download certificates online.  Security authentication was retrieved from a Lotus Domino server via SOAP protocol.

VB consulting contract from May, 2000 – March, 2001

Developed a “tool-box” of nine COM objects (ActiveX controls and ActiveX DLLs) that were used to create VB 6.0 applications for R&D chemists to view 3D representations of molecules and proteins. The COM objects utilized ADO connections to an Oracle back-end database. The controls allow a user to browse two and three-dimensional representations of the molecules.

QMS is a comprehensive data management system that allows water and wastewater utilities to schedule, collect, manage, integrate, and report on their operational and compliance data. Its ease of use, powerful features, and enterprise architecture deliver benefits to any organization – small or large.

QMS was initially developed in VB6 with a SQL Server back end.  The application is currently being converted to .NET using the interop toolkit.