Résumé (Full)

12/02 – PRESENT DAVID’S BRIDAL

PRINCIPAL DEVELOPER AND SR MANAGER, ENTERPRISE SYSTEMS DEVELOPMENT (11/17 - PRESENT)

• Lead team of full stack developers, eCommerce developers and staff augmentation development teams
• Responsible for architectural review, design reviews and code reviews
• Responsible for goals, reviews, coaching
• Application Development advocate on Architecture Review Board

PRINCIPAL DEVELOPER AND SR MANAGER, DEVELOPMENT AND ARCHITECTURE (12/15 - 11/17)

• Lead team of full stack developers
• Responsible for goals, reviews, coaching, design reviews and code reviews
• Responsible for architectural review of new projects
• Enhancements and defect resolution to customizations of purchased mobile POS solution. Java, Eclipse, Maven, XCode/iOS, WPF, Postgres, Cassandra
• Developed a proxy Web Service to intercept calls from mobile POS to Order Management System. Used for timing, diagnosis and logging
• BizTalk and SSIS development to support new Store Inventory Management solution
• Technical oversight of Angular app hosted in AWS using AWS lambda functions punching back to on premise web services

PRINCIPAL DEVELOPER AND MANAGER, DEVELOPMENT AND INTEGRATION (07/14 – 12/15)

• Lead team of three full time developers
• Responsible for goals, reviews, coaching, design and code reviews
• Responsible for architectural review of new projects
• Design and development of an ASP.NET MVC, NHibernate web application targeting the iPad for in-store customer and order data management.
• BizTalk and SSIS development to support new Store Fulfillment of eCommerce special orders initiative
• BizTalk and SSIS development to support new eCommerce special order solution

SENIOR SYSTEMS ANALYST (12/02 – 07/14)

• Design and development of BizTalk interface applications integrating legacy systems with newly deployed ERP system – MS Dynamics NAV.
• Upgraded over 90 BizTalk 2006 applications to BizTalk 2013.
• Design and development of a BizTalk 2006 solution for integrating merchandising, order fulfillment, warehouse, and supply chain systems.
• Multiple interfaces developed utilizing SQL, MQ, flat-file, and XML messaging.
• Design and development of a C# Windows Service doing socket-level communication with an RS/6000 to control the exchange of data files over FTP.
• Design and development of a marketing campaign and list management website. Application utilized ASP.NET, C# and SQL Server
• Design and development for nationally deployed POS (point-of-sale) system, 1000+ registers, through multiple releases. Application utilizes VB6, MSMQ, Queued Components, SQL Server
• Design and development of a real-time sales reporting website. Application utilized ASP.NET, C# and SQL Server
• Design and development of a help desk application monitoring website. Application utilized ASP.NET, C#, Web Services, XML and SQL Server
• Design and development of a database process blocking website for DBA group. Application utilized ASP.NET, C# and SQL Server
• Design and development of a Windows Service application for processing debit reversal transactions. Application utilized C# and SQL Server

05/02 – 12/02 PSCI

SENIOR WEB DEVELOPER, ASTRA ZENECA

• Developed intranet website for Operations group consolidating over 30 existing websites into a single website. Utilized ASP, XML, XSLT, DHTML, JavaScript, VB and Oracle.
• Enhanced Therapeutic Areas website to provide automated emailing and metadata tagging of user-identified news items. Utilized ASP, XML, JavaScript, Oracle and CDONTS.

10/96 - 04/02 FIRST CONSULTING GROUP, INC.

SENIOR CONSULTANT

• Provided presentations and training on Microsoft .Net technologies to internal development staff. Topics included C#, VB.Net, ASP.Net, ADO.Net and Web Services.
• ORAPHARMA, DBA for a Call Tracking System deployed on Palm VIIx handheld devices. Responsible for synchronization of data between Palm devices and SQL Server. Responsible for design and development of database, tables, indexes, procedures, etc. Responsible for configuring merge replication of database from hosting site through a firewall and over the internet to the client site.
• NEW YORK PRESBYTERIAN HOSPITAL, Technical Lead and Senior Developer for a team that created a web application for the data capture and data extraction and reporting of cardiac procedures.  Developed in ASP, JScript, VBScript, XML, Crystal Reports and SQL Server.Technical Lead and Senior Developer for a team that created a web application for the data capture and reporting for an Emergency Department. Specifically, the system captured patient demographic and clinical information as well as integrating Cerner lab data provided in HL7 format. Developed in ASP, JScript, VBScript, COM+, MSMQ, VB, Crystal Reports and SQL Server.
• MEDCOST, Technical Lead for the reengineering of a PPO management system from a Visual FoxPro system to a three-tier VB-MTS-SQL Server system.  Major portion of system was a HIPAA compliant claims database handling HCFA 1500 and UB 92 claims. Wrote System Architecture document, User Interface Design document and Business Layer Design document. Conducted design reviews and code reviews.Developed middle-tier components and stored procedures. Accelerated development by developing code generation utilities that created middle-tier classes, stored procedures, and application code for calling the stored procedures.
• PILOT AIR FREIGHT, Technical Lead and Senior Analyst for team of 20 on a $3M reengineering of a VAX financial system to an n-tier VB-MTS-SQL Server on Windows NT 4.0 system. Requirements, business rules, etc. were extracted from the existing source code.Gathered requirements and wrote Functional Requirements Specification and Detailed Design documents. Conducted design reviews and code reviews.Designed and developed client UI and batch applications as well as middle-tier business components.
• HOECHST MARION ROUSSEL, Designed and developed customizations for the Global Submission Development and Approval (GSDA) system. GSDA is a Documentum-based application that enables users to copy, edit, review, and approve submission-related documents in a globally accessible and secure storage area. The system also supports electronic assembly and publishing using ESPS CoreDossier. Implemented a Drug Dictionary maintenance utility; batch print facility; custom find and query utility; document status change function; and edit user profile function. Developed the installation script and supported User Acceptance Testing at the client site. Development was performed using Documentum, Visual Basic, Installshield Express, and ActiveX components in a Windows NT environment.
• SMITH KLINE BEECHAM, Lead Developer on the re-engineering of a LIMS system that supports studies for the Drug Metabolism and Pharmacokinetics department. System was developed as a VB to Oracle client server system using RDO for data access.Responsible for the development of business components such as Study Management, Assay Management, Sample Management, and Dataset Selection. Designed and implemented significant portions of the application's architecture using class modules to provide user interface services, windows services, application services, and logging services.

LEAD CONSULTANT

• HELLER FINANCIAL, Developed a Visual Basic utility program to support a network migration effort. The application opened and examined Windows Shortcut files for pathnames that qualified for migration and replaced the outdated path designations with the new path server/share names. The application utilized the Desaware OCX control suite.
• DOCUMENT CONVERSION ASSOCIATES, Document Conversion Associates is a value-added reseller (VAR) integrating an Optical Character Recognition (OCR) system with an existing Key From Image claims processing system for Aetna US Healthcare. The system accepts scanned images of HCFA 1500 forms (Medicare Claim Forms) and extracts and processes the data.  DCA adds custom programs to off-the-shelf software that manages the workflow through the system and report on status and statistics. The system was deployed in several regional centers nation-wide.  Wrote multiple Visual Basic programs to control the workflow process and gather statistics. Tested applications. Wrote installation scripts with InstallShield. Access to databases used DAO and RDO. The OCR application ran in a client-server environment with a Windows 95 platform, and the database ran on a NT platform.
• AETNA US HEALTHCARE HDIC, Development Database Administrator (DBA), developer, and tester for an enhancement to an existing US Healthcare system. The system enabled healthcare providers to submit claims, referrals, and encounters information to US Healthcare, and to receive member and eligibility information electronically. The enhancement enabled concurrent use of two database formats and increased the number of provider offices able to use the electronic system. Revised application and ancillary systems to enable the common code base to use Watcom SQL or Microsoft SQL Server transparently. Provided numerous innovative solutions in a variety of dual-database problem areas, including data type discrepancies, open database connectivity (ODBC) statement and connection handle allocation, database-specific function calls, non-ANSI standard SQL, and interaction between Crystal Reports and the databases.
• FIRST CONSULTING GROUP, Rewrote several network utility programs. The utilities were designed to capture and report on statistics of server disk utilization in a scheduled batch mode. Used API calls to connect to the various servers to gather the disk statistics. MAPI controls were used to automatically send results to MIS management. Development was performed using Visual Basic 4.0 on Windows NT servers.
• COVALENT RESEARCH ALLIANCE, Designed and developed several data entry applications for the capture and tracking of pharmaceutical study results. Designed user interface, database tables and queries, and coded validation rules. Development was performed using Microsoft Access in a Windows for Workgroups environment.

06/95 - 10/96 AETNA US HEALTHCARE, BLUE BELL, PA

SENIOR APPLICATIONS DEVELOPER

• QA CREDENTIALING, Designed and developed a client-server management decision support system (DSS). The system supports provider quality assessment, re-credentialing, and re-certification for the managed care network. Performed business analysis, prototyping, coding, testing, documentation, and production support.  Designed user interface and coded business rules in Visual Basic. Designed and created tables, views, indexes, stored procedures, and triggers. Created stored procedures used for complex queries and shared queries. Development was performed using Micro Focus COBOL, shell scripts, Visual Basic 3.0, and Sybase System 11 on an AIX platform. Sybase was used for the batch reporting subsystem.

06/89 - 06/95 THE PRUDENTIAL, FORT WASHINGTON, PA

PROGRAMMER ANALYST

• MCTS, Developed enhancements to an existing client-server transaction processing system, which was designed to capture and report marketing campaign costs and reconcile them with the general ledger. Performed maintenance and error corrections to Oracle7 stored procedures and graphical user interface (GUI) revisions using PowerBuilder 3.0. Analyzed, developed, tested, and documented code.
• LTC PRICING, Designed and developed a client-server DSS. The system supported the actuarial department in trending, pricing, and reporting activities for long term care products. Used PowerBuilder 3.0 to create the user interface and encapsulate business rules. Designed and created tables, views, indexes, and stored procedures. Responsible for business analysis, prototyping, coding, testing, documentation, and production support. Development was performed as a front-end system using an Oracle7 database running on Windows NT.
• VANTAGE, Integrated a vendor mainframe transaction processing system into Prudential legacy systems. The system was intended to support contract administration activities for annuity contracts. Performed analysis, coding, testing, and documentation.

ASSISTANT PROGRAMMER ANALYST

• PBRPS, Developed a client-server transaction processing system with an OS/2 client and an MVS 3090 DB2 server. The system supported billing and remittance processing activities for group and individual contracts. Performed business analysis, RAD/JAD, prototyping, coding, testing, documentation, production support, and performance tuning.

DEVELOPMENT TOOLS, LANGUAGES AND PLATFORMS C#, ASP.Net, MVC, Node, Angular, BizTalk 2006/2013, Visual Basic, VBScript, Visual Studio 2002-2017, XML, XSL, HTML, JavaScript, COM+, MSMQ, SSRS, SSIS, NHibernate, Git, Java, Eclipse, Jira, Confluence, BitBucket

DATABASES MS SQL Server, Postgres, Oracle, MS Access

OPERATING SYSTEMS MacOS, Ubuntu Linux, Windows (all versions), MS-DOS, OS/2

M.B.A, Computer Information Systems, Temple University, 1994 B.S., Computer Information Systems Management, Delaware Valley College, 1988 B.S., Business Administration-Accounting, Delaware Valley College, 1988