David Steinmetz Email & Phone Number

Pittsburgh, Pennsylvania, United States

Pittsburgh, Pennsylvania, United States

Senior IT Developer working with financial data using Perl and SQL Server. Performing on boarding, reporting, financial calculations for loan payoffs and mailings. Creating and modifying PDFs. Windows platform. Utilize Sign Now for signature routing of documents.

Developing solutions for Lockbox Processing on the Vicor RIDS system. Developing new ways to import and export data, interface to other applications, audit and monitor the system. Operating system is Unix FreeBSD. Code development involves c++, Perl, api’s, sqlLite, and Unix scripting.

Pittsburgh

Supervise testing and implementation of Release Upgrades of A/R Advantage System.Develop training materials and train new employees.Document Standards and Guidelines for code development for team.Perform System testing and validation for new system features for Lockbox System (A/R Advantage).Coordinate off-shore developers and DBA for new APA.

Designed and developed tables and relationships for DB2 Database.Maintained and enhanced CICS/DB2 front end to PEP+ system.Perform analysis and design, modified tables, retrofitted data, modified code base, and monitored the system for Year 2000 Compliance.

Technical Consultant for Mellon Bank. Worked on report development from DB2 systems.

Technical Consultant for Allegheny Power. Convert invoice system from in-house written Main Frame package to purchased package on unix platform. Wrote numerous jobs and scripts to convert data and create on-going interfaces.

Technical Consultant at Westinghouse ESBU. Large scale project converting to SAP systems. Developed interface and conversion programs and database tables.

Technical Consultant for PNC Bank developing sales tracking system for retail branch operations. System was developed on OS/390 using Cobol, DB2, CICS.

Technical Consultant for Highmark Blue Cross/Blue Shield. Implemented new system to store archive records on optical drives rather than microfiche. Developed system to cache records to DASD from the optical drives for review. Corrected dead lock time-out issues on unrelated system.

Technical Consultant for Stuart Medical Inc. Performed system enhancements and trouble shooting for inventory and order management system. Developed conversion programs for systems to convert for merger with Owens & Minor Inc.

Consultant Westinghouse ESBU Division. Converted Executive Information System from Pilot to DB2 database based system, including new functionality of on-line programs to allow user updating of base tables. Revamped invoicing system to allow international orders to be processed through the ESBU invoicing system.

Developed DB2 module to dynamically update DB2 tables in Goodyear's International Order Tracking System. Developed conversion programs to convert EDI formatted data to sequential data sets to be picked up via RJE by countries without and EDI translator. Developed automated file transfer procedures between Personal Computers and IBM Main Frame utilizing EDI.