Summary of Qualifications

Many years of business systems experience in the management design analysis programming testing documentation support and user education of various web / desktop applications full project life cycle

Applications

• e-Commerce web retailing Risk Management OPICS FX/Money Market/Margin/CLS/FI/Repo MIS Reporting
• Foreign Exchange Trading Back Office Human Resources / Personnel
• Securities Trading Payroll Trading Compliance Accounts Payable / Receivable Portfolio Management General Ledger DDA Inventory Control Money Market Funds Transfer / SWIFT / MONTRAN
• Commercial Loans Perfect Match / Accord
• EDI Interfacing Messenger Tracking System
• Pharmaceutical Production Pfizer Inc. Report Execution/Scheduling
• Pharmaceutical Sales Tracking Schering-Plough Inc.

Hardware / Operating Systems

• PC / Compatibles Windows 7 / 2003 / 2000 / XP / NT / 9x / 3x
• Sun servers Solaris
• VAX / Alpha VMS Open VMS standalone / clustered

Database Systems

• SQL Server 2012/2008/2005/2000/7.0 /6.5 Access 2003 / 2002 / 2000 / 97 / 95
• SYBASE MySQL
• ORACLE RDB VAX

Languages / Software

• Visual Studio.NET 2012 / 2010 / 2008 / 2005 / 2003 .NET Framework 4.0 / 3.5 / 2.0 / 1.1
• C VB.NET / VB6
• Team Foundation Server TFS Visual SourceSafe VSS Infragistics Controls ComponentOne Controls Telerik Controls jQuery Crystal Reports 8 9 10 11 / Enterprise SSRS / SSIS
• ActiveReports
• Web Services / HTML / CSS / ASP.NET / JavaScript
• Windows Services Transact-SQL / PL-SQL / MySQL
• Citrix UNIX / Korn Shell / Shell Script
• OPICS Architecture Toolkit Putty Web Farm load balancing

Detailed Business Experience

Confidential

Design coding and support of several web/desktop e-commerce related applications for a leading pet- care supplies and pharmaceuticals firm. The company maintained a public-facing e-commerce website as well as an internal intranet website both with the capability to enter customer orders for pet-care supplies and pharmaceuticals. The ordering on the internal website was performed by agents manning an 800- exchange telephone call center. Programmed enhancements to the internal website which were deployed to a staging server for QA testing and then finally deployed the accepted changes to a load-balanced Production web farm. Also programmed enhancements for many of the in-house desktop applications that control and monitor pharmaceutical workflows remote vendor suppliers inventory and warehousing. Designed and implemented a security/role schema to control which internal personnel by user or group could access each of the functions in all internal applications. Designed and implemented a new inventory control application while re-designing the company s warehouse to provide more efficient use of the available space in order to fulfill a greater number of customer orders in a shorter period of time.

C Visual Studio.NET 2012/2010/2008 Team Foundation Server ASP.NET light WCF AJAX controls Telerik Controls Crystal Reports SSRS SSIS .NET Framework 3.5/4.0 SQL Server 2012/2008 Putty

Confidential

Design coding and support of a web-based compliance questionnaire system for a leading brokerage firm. The personnel working on the individual trading desks were given special login accounts on the corporate intranet in order to automate the filling-out of questionnaires that are required by regulatory agencies. Provided compliance management with a rich set of functions to setup new web users maintain question libraries assemble questionnaires schedule the completion of the questionnaires and various methods of monitoring and inquiring on questionnaires and their statuses. Designed and implemented a nightly scheduler to notify the compliance system users via e-mail of all outstanding questionnaires. Additionally responsible for enhancements to an options trading system and re-designed the application modules to integrate an more object-oriented architecture and make the components re-useable to other applications. The enhancements allowed the core modules containing the business rules and utility methods to be readily accessible so that the common functionalities could be easily accessed without the need to re-code the standard methods used by all applications.

C VB.Net Visual Studio.NET 2008/2005/2003 ASP.NET Component One controls AJAX controls

Crystal Reports Active Reports Infragistics controls Web Services SQL Server 2008/2005/2000

Confidential

Conversion of a nationwide sales-shortage reporting system for a major baked goods manufacturing conglomerate from using an un-normalized MySQL database to a normalized SQL Server database. Redesigned and implemented new procedures for loading 500 000 UPC-scanned items from various supermarket/sales chains on a weekly basis as well as implementing a new company sales hierarchy within the reporting database. Implemented controls to alert management and support via e-mail of any violations of referential integrity within the SQL Server database during the weekly loading of files sent via EDI. Interfaced with the EDI group to resolve feed issues. Converted the Crystal reports to use ODBC connections new report groupings and SQL Server database interfaces instead of MySQL interfaces. Responsible for the design implementation and testing of a web-based inquiry interface to allow management to determine the report utilizations by sales-shortage analysis with the capability for detailed drill-downs. Many different bakery companies were supported in this effort including Entenmann s Stroehmann s Thomas s Arnold Boboli etc. with multi-billion dollar sales nationwide. Upgraded all ASP.NET-based reporting interfaces to use .NET Framework 2.0/Visual Studio 2005 from Framework 1.1/Visual Studio 2003.

Confidential

Analyzed and migrated an existing GIC investment management system portfolio management from Visual Basic 6 to Visual Basic.Net/C .Net as well as an associated reporting system using the same data. All portfolios were represented in a standard hierarchical structure within a Sybase database. Re- designed the user interface to improve productivity and ease-of-use using Infragistics controls. The systems encompassed more than 50 clients and supported 25 users at various locations. Reporting was provided through the use of Crystal Reports 10. Implemented specialized deployment software for automated updating of the local copies of the application. After migration provided documentation support and additional business-related enhancements to the system. Additionally responsible for coding an application to provide real-time ledger and trade entry capabilities for Cash Desk management and control. Linked the application to the existing Charles River front-office trading system.

VB.Net C Visual Studio.NET 2005/2003 VB6 Sybase ORACLE Web Services MS Enterprise Library

Crystal Reports 10 Infragistics controls

Confidential

Designed and implemented the building blocks of an object-oriented middle-office risk management system providing unattended nightly capturing and normalizing of all trading information from the various front-office and back-office trading systems as well as offering automated nightly reporting. Also designed and implemented the user interface that provided for reconciliation adjustments drill-down inquiry and generation of the required daily management accounting reports of all FX and loan processing activity. Implemented a fool-proof solution for the scheduling of all data flowing in and out of the system by creating a 24-hour task scheduler with a robust and flexible programming interface driven from tables in the main database.

VB.Net C Visual Studio 2005/2003 ASP.NET SQL Server 2005/2000 Component One controls

Infragistics controls ACCESS 2003 EXCEL 2003

Confidential

Design maintenance support and enhancement of an existing OPICS application encompassing the F/X Fixed Income and Repo product lines. Responsible for design and implementation of generalized workflow monitoring tools and data integrity checking. Designed and implemented a trade clearing reconciliation application using daily feeds from the Euroclear clearing service. Integrated the clearing programs into OPICS using the OPICS Architecture Toolkit enabling the Back-office users to automatically reconcile all trades sent to Euroclear daily. The software decoded the daily feeds received from Euroclear as well as tracking all trades sent to Euroclear and maintained a running history of the settlement of all cleared/failed trades with full reporting capabilities. Performed analysis and coding of trading activity reports and SWIFT transaction reports for another in-house trading system for handling OTC options. Responsible for design and implementation of a parameterized inquiry/reporting package that allowed all of the bank s users to have a single consistent web interface to its ORACLE database and Crystal Reports. It provided both batch and online interfaces which replaced their costly Crystal Enterprise reporting platform with full security tailored to the needs of the individual departments and users. Responsible for analysis and implementation of components of an in-house back-office trading system which was intended as a replacement for OPICS. Implemented various trading instrument reconciliations for end-of-day closing.

VB.Net VB6 OPICS Crystal Reports Perfect Match SWIFT ASP.NET ORACLE PL-SQL ACCESS 2003/2002/2000/97 EXCEL 2003/2002/2000/97

Confidential

Analysis of an existing front-office and back-office OPICS F/X trading application to gather current transactional statistics and future needs to propose new hardware and software purchases to accommodate the users plans for expansion. Provided detailed documentation on all phases of current system activity as well as program modifications that would be required to allow two new trading locations in other time zones. Prepared comparisons of various relational database packages to meet future requirements. Proposals were submitted for several different upgrade configurations due to client cost constraints. All hardware and software must be made available for 24-hour trading due to the time zone differences and nightly batches and upload/downloads were staggered for optimum system performance with full failover capabilities.

VB.NET VB6 OPICS Perfect Match SWIFT SYBASE ORACLE

Detailed job history and references furnished upon request.