SUMMARY: 14 years experience working as Application Developer, Technical Architect, and Project Lead/Manager in a wide variety of business applications. Specifically Financial Applications revolving around Leasing, Alternative Trading Systems, ATMs, Banking, and the Credit Card Industries. Interests include relational database design using Oracle, SQL Server and Sybase coupled with backend large scale application development for business applications.

TECHNICAL SKILLS: Database and Application Design. Technically competent in PLSQL, TSQL, Java. Past contracts also included Jython, PowerBuilder, Visual Basic, C, Automation using WinRunner, Load and Performance Testing.

EXPERIENCE

Hewlett-Packard (IT 4 IT), Murray Hill, NJ 1/2008 – 10/2008

Consultant

• Senior PL/SQL Developer supporting PPM, Project and Portfolio Management Center, and CBA, Cost Benefit Analysis Tool, used for planning of all Hewlett-Packard Projects.
• CBA is written in Java using Struts and Ibatis Frameworks running on an Oracle 10G Database.
• Approvals and notifications were handled through the PL/SQL packages utilizing UTL_SMTP, DBMS_LOB.
• Created data uploads and extracts used for ETL, using SQL*LOADER, triggers and custom PL/SQL packages.
• Replaced existing DBMS_JOBS with custom KSH scripts in order to meet data center compliance.
• Designed and implemented DDL, DML using dynamic scripts to facilitate incremental and full build scripts.

Hewlett-Packard (Financial Services), Murray Hill, NJ 4/2004 – 12/2007

Consultant

• Lead/Senior Developer for the core leasing application, Phoenix.

• Application covers lease entry, business entity management for Customer, Supplier and Supplier Invoices.

• Completed role as Subject Matter Expert for Java to .Net conversion of front end and middle tier while collapsing EMEA and AP Regions into one global application for an estimated 3 year cost savings of $6.8 Million.

• Responsible for all the back-end development using PLSQL and embedded Oracle Java Objects to perform invoice consolidations, payment stream generation, lease rate classifications, internal rate of return calculations, data imports and extractions, using DBMS_XMLDOM, DBMS_LOB, UTL_FILE.

• Developed a SWING applet and worked with Java Script to communicate with server side components for front-end client side data entry and validation. Maintained Servlets, JSP’s and a POJO database access layer using JDBC interacting with the oracle database for region base business rules validation.

LIQUIDNET, NY, NY 3/2001 – 4/2004

Director of Automation

• Liquidnet is a global equity trading system allowing users the ability to trade large-block orders anonymously. The system comprises: a Java Swing Application (TRADER); orders enter via an Order Management System (OMS) Integrator; a UNIX backend supported by an Oracle DB.
• Managed team responsible for creating automated testing tools for front end applications.
• QA Team Leader for joint initiative with development on implementation of testing tool enabling GUI-based testing of TRADER using Jython, Python and Java.
• Designed and implemented web-based QA Automation front-end using Java Servlets, Dynamic HTML, Java Script and XML connecting to a MSSQL DB using JDBC.
• Maintained and enhanced in-house QA Automation tool using Win Runner scripts to automate testing TRADER and proprietary OMS.
• Designed and built in-house Load Test environment.
• Setup and maintained QA OMS Servers, MSSQL 6.5, 7.0, 2000 and Sybase 11.9.2, MacGregor, Eze Castle, Advent Moxy, LineData and Decalog.

CREATIVE VISIONS, NY, NY 1/1997 – 1/2002

Consultant
• Designed, implemented and maintained custom Inventory System using PowerBuilder 6.5 and MSSQL 6.5.
• Migrating MSSQL 6.5 to 2000.

NYCE, Woodcliff Lake, NJ 1/1998 – 9/2000

Consultant

• Senior developer on project team responsible for designing and implementing rewrite of Financial Tracking and Reporting System (FTRS), allowing the billing of NYCE services and transactions according to hundreds of algorithms, parameters and profiles.
• Implemented and designed using PB 6.5 front-end application with MSSQL 7.0; other components includes Data Junction, Crystal Reports and Connect Direct.
• Application utilizes daily, monthly and on-demand tasks, extended stored procedures, as well as stored procedures, user defined types, foreign keys enforcing referential integrity, etc.

COMPAQ, Edison, NJ 3/1999 - 8/1999

Consultant

• DBA on project, responsible for optimization of invoicing system.
• Implementation uses a PB 6.0 front-end application in conjunction with MSSQL 6.5.

BANKERS TRUST COMPANY, Jersey City, NJ 10/1997 - 2/1998

Consultant
• Designed, implemented Cobra Fee Revenue Forecast application using VB 5.0 and MSQL 6.5 DB.
• Application is used on a monthly basis utilizing data feeds from numerous business lines and the Bankers Trust mainframe accounting system, as well as a direct data pull via an optimized stored procedure executed on the Bankers Trust billing system, residing on MSSQL DB.
• Coordinated efforts of support staff during the implementation of the application.
• Created adhoc queries and reports using MS Access 7.0 databases.
• Created design specification for implementation of web based interface allowing users the ability to perform updates to Globe Net database residing on a MSSQL.

SCHMIDT, PISCITELL & SCHWARTZ, CPAs, NY, NY 1/1997 – 9/1999

Consultant

• Responsible for maintenance of workstations connected on a Novell Network.
• Maintain and update access permissions on Novell Server 3.12.
• Perform backups, software upgrades, and issue resolution in DOS and Windows 9x.

MASTERCARD INTERNATIONAL, Purchase, NY 6/1994 - 6/1996

Systems Manager

• Designed and implemented a sophisticated, multi-function statistical reporting and analysis system (QMRS) used to generate 55% of MasterCard's total annual revenue.
• QMRS, implemented with PB 4.0 and extended stored procedures on a MSSQL DB, typically supports 20 simultaneous users during peak quarterly reporting periods.
• Responsibilities include design of user interface; act as lead programmer; manage two programmers; serve as liaison to QA group and users; coordinate fixes; perform version control.
• Maintain MSSQL DB; create and update stored procedures and indexes; schedule and perform backups; maintain referential integrity; administer multiple NT Servers.
• Organize and direct stress testing of UNIX-based reporting engines to establish business case for upgrading production NT Server hardware.
• Manage day-to-day operations of Technical Services group in Global Information Services department; Recruit and train Technical Services Team of five.

KONRAD ZUSE INSITUTE, Berlin, Germany 5/1993 – 8/1993

Internship

• Integrated CPLEX, a matrix manipulation Mathematics package, with C and C++ code, by developing an implementation of Block Design in the UNIX environment.

EDUCATION

Stevens Institute of Technology, Hoboken, NJ

Howe School of Technology Management

MS in Information Systems, December 2003

NYU, Courant Institute of Mathematical Sciences, New York, NY

MS in Computer Science, Network Applications, May 1994

BA in Mathematics, May 1992

AA in Liberal Arts, May 1990

LANGUAGE SKILLS

English, German and French.