SUMMARY:

Senior programmer - analyst and team leader with 25 years of experience at top-tier firms in the financial industry. Outstanding communication, teamwork, problem solving, and technical skills. Extensive experience with process improvement, all phases of the systems development, and production support. Especially talented in helping others and developing colleagues.

CORE TECHNICAL SKILLS:

• Object-Oriented Design and Programming in Java
• Relational Database Design and Stored Procedure Optimization for Sybase
• JDBC, Spring, Junit, Unix, C#, Perl, Autosys, MQ, TIBCO, SOAP/XML, HTML, Excel, PDF, EDI
• Eclipse, Ant, Ivy, VisualStudio, DBArtisan, RazorSQL, TOAD, Git, Bitbucket, Perforce, CVS
• Oracle and DB2 exposure

PROFESSIONAL EXPERIENCE:

Confidential

Executive Director

Responsibilities:

• Transferred to Confidential from Confidential when Confidential bought Confidential ’s physical oil business.
• Compiled and installed Confidential oil systems in Confidential environment.
• Changed systems to work in Confidential environment, including connections to Confidential ’s directory, email, and fax systems.
• Changed systems to use TIBCO instead of proprietary Confidential data bus.
• Completed deployment of indirect tax system developed at Confidential . Reduced tax department headcount by three persons.
• Completed deployment of VAT System developed at Confidential .
• Enhanced several systems to support merger of two Confidential legal entities.

Technologies: Java, C#, Sybase, Perl, Autosys, SOAP/XML, MQ Series, TIBCO, Excel, PDF, EDI

Confidential

Responsibilities:

• Enhanced Java program and Oracle SQL to speed up load of transaction data for Confidential oil trades into Confidential .
• The data loaded in 3 minutes instead of an hour.

Technologies: Java, Oracle

ISO Connector

Confidential

Responsibilities:

• Modified message format to support Confidential balance-of-period auctions.
• Implemented 2-factor authentication with SPP by including security token in HTTP headers.

Technologies: Java, Hibernate, Oracle, HTTPS

Confidential

Responsibilities:

• Enhanced Java program and Oracle SQL to speed up load of weather forecasts and other fundamental data into Oracle database.
• Most data sets loaded in a few minutes instead of a few hours.

Technologies: Java, Oracle

Confidential

Responsibilities:

• Promoted to Vice-President in 2007
• Covered crude oil, refined products, electricity, natural gas, coal, emissions, industrial metals, and precious metals for global sales and trading business.
• Provided expert SQL programming and optimization advice to colleagues.
• Designed and built the system from scratch. Managed a team three local developers.
• Covered federal and state tax returns for U.S. and Canada.
• Integrated with ETRM for trade facts.
• Built determination engine to calculate taxes in real-time for every trade update.
• Built reporting engine to generate tax returns and supporting documents in Excel, PDF, and EDI formats.

Technologies: Java, C#, Sybase, Perl, Autosys, Excel, PDF, EDI

Confidential

Responsibilities:

• Collaborated extensively with London VAT team to establish functional requirements.
• Managed a team of two offshore developers.
• Integrated the VAT functionality into the existing scheduling and invoicing systems.
• Built determination engine to calculate taxes in real-time for every trade update.
• Built reporting engine to generate tax returns and supporting documents.

Technologies: Java, C#, Sybase, Autosys

Confidential

Responsibilities:

• Took full ownership of the system. Managed a team to two developers.
• Renovated system to reduce complexity and improve performance, thus paving the way for global expansion.
• Partnered with Operations department to standardized pre-settlements process globally.
• Expanded system from one desk in New York to the entire global department by building numerous new features and integrating with five additional risk systems.
• Integrated with firm systems for payments, accounting, cash management, tax reporting, exception reporting.
• Automated precious metals settlements by generating instructions to metal depositories and generating interest rate reset notices for forward rate agreements.

Technologies: Java, C#, Sybase, Perl, Autosys, SOAP/XML, MQ Series, PDF

Confidential

Responsibilities:

• Partnered with Scheduling and Operations departments to document their business process and gather requirements for the new system.
• Advised users on optimal structure for extensive reference data library to facilitate ongoing operations as well as business expansion.
• Co-led global team building new scheduling system for physical deliveries. Managed one developer.

Technologies: Java, Hibernate, Sybase, SOAP/XML

Confidential

Responsibilities:

• Took full ownership of all Confidential systems. Managed two developers.
• Expanded trade capture feed for ICE to also capture trades from NYMEX, CME, CBOT, LME, TOCOM, and several proprietary sources.
• Expanded feeds to cover new products by integrating with risk systems for precious metals and European power.
• Redesigned feeds with increased component sharing among feeds to improve time-to- Confidential for new feeds and new products.
• Expanded electronic confirmation system to cover broader range of commodities products.

Technologies: Java, Sybase, SOAP/XML

Confidential

Responsibilities:

• Improved performance of nightly batch processes by optimizing Sybase stored procedures.

Technologies: Sybase, Perl

Confidential

Responsibilities:

• Enhanced Confidential portfolio data infrastructure for use in several internal investment management systems.
• Coordinated development to meet the requirements and deadlines of four distinct systems.
• Enabled large cost savings through retirement of legacy portfolio database.
• Enhanced Confidential portfolio data infrastructure to support non-dollar accounts.

Technologies: Unix, Sybase, Java, EJB, JDBC

Confidential

Responsibilities:

• Built portfolio data infrastructure for use by portfolio analysis, trading, and alerts sections of client web site.
• Coordinated design of denormalized portfolio reporting database with database development team in custody systems department.
• Designed, built, and optimized over 100 stored procedures to retrieve data from the portfolio reporting database. Coordinated with database development team and database administrators to solve the most difficult performance problems.
• Built Java API using JDBC on top on stored procedures.
• Built OFX capabilities for downloading client data to Quicken. Managed one programmer, and coordinated with external OFX tools vendor.
• Designed and implemented system to update cost basis on transferred securities. Managed one programmer and coordinated with development team in custody systems department.

Technologies: Unix, Sybase, Java, EJB, JDBC, HTML