Summary:
Results oriented professional with extensive business experience have worked in
the following capacities:
•	Developer Programmer Analyst
•	Technology Application/Implementation and Integration
•	Data Analyst
•	Project Planning and Management
•	Business Analyst
•	Workflow/Productivity Analyst
•	Requirements Analyst
•	Systems Integration
•	Quality Assurance and Testing
Specialized skills:
SQL Server 2005, MS Excel VBA , MS Access VBA, database design, Office
automation with backend database integration to database systems including SQL
Server, Sybase and Oracle. 
Technologies:
Microsoft Technologies, Windows XP, Windows Server 2003, Sharepoint 3.0,
Sharepoint 2007 (MOSS), VB.NET, VB 6, ADO, MS Office 2000, XP, 2003, 2007, MS
Access VBA, MS Excel VBA, T-SQL, MS Office Automation, SQL Server 2000, SQL
Server 2005, Visual SourceSafe 6

Experience:

Hewlett Packard/Credit Suisse - December 2007 – March 2008
SQL Server 2005 Database Design and Implementation, Data Analyst
•	Design and development of an automated global Service Level Agreement (SLA)
Reporting System using SQL Server 2005 and T-SQL.  Project involved the design
and development of all tables, complex stored procedures and functions used in
the system.  System required in depth knowledge of date/time math for proper
calculating of all times relating to the HP Help Desk SLA’s.  Reviewed server
configuration and worked with HP DBA and CS technical staff  to effectively
communicate requirements for the new system.  Worked with HP Business Operations
Manager to insure reporting accuracy and system integrity.  Provided data
analysis for data retrieved from new Remedy system for incorporation into the new
SLA Reporting System.  Provided system documentation.


United Nations Peacekeeping Financing Division - March 2007 – July 2007
Data Analyst, MS Office Developer Programmer/Analyst, Design Consultant
•	Management, development of enhancements and maintenance of the Peacekeeping
Troops database and Accounts Payable database using Microsoft Access and
Microsoft Excel, which includes programming in VBA, interface development and
enhancements, Access reports development and enhancements
•	Provide design consultation for the development of a new .Net based Troops and
Accounts Payable system that is being developed using SQL Server 2005, C#, ASP
.Net and Crystal Reports 11, for enhanced data gathering functionality that
includes online data gathering and processing.


Epicor Software - June 2006 March 2007
VB.Net, VB6, Developer Programmer/Analyst
•	Write and maintain functional and technical specifications. Convert designs
and specifications into computer code. 
•	Code screen layouts, graphical user interfaces, printed outputs, and
interfaces. Compile VB code into executables and dll’s and correct errors
detected in compile process. Create test transactions, run tests to find errors,
analyze and debug code to find causes of errors and revise programs with
corrections. Confirm program meets specifications. 
•	Provide technical assistance by responding to inquiries regarding errors,
problems, or questions with program. 
•	Analyze and estimate feasibility, time, and computer capabilities. 
•	Requirements and Business Analysis to analyze and understand functions to be
automated, client needs, objectives, desired features, and input and output
requirements. 

Convergenex - June 2005 February 2006 
Developer Analyst Technology Consultant 
•	Provided database and spreadsheet modeling, for the development and
implementation of a customized management reporting system using MS Access 2000
and MS Excel 2000.  Solution utilized customized Access GUI’s and extensive VBA
coding and DAO for system automation. 
•	Created Management Reports using Access reports, some of which were exported
to Excel and modeled Excel spreadsheets, which included misc. pivot tables and
charting, for presentation purposes for local and regional reporting
requirements.

Credit Suisse First Boston - May 2000 June 2005 
Developer Programmer/Analyst
Application development, enhancement, and maintenance of executive and global
compensation systems using Visual Basic 6.0 and MS SQL Sever 2000.  Designed,
coded, developed, enhanced, user interfaces in VB 6, coded stored procedures in
SQL Server 2000.
•	Enhancement and maintenance of McLagan compensation survey data using MS
Access 97 and VBA for the Global Compensation team. 
•	Custom Access 2000 and Excel workbook application development for efficient
data retrieval and presentation for executive and global reporting needs using MS
Access 97, MS Excel 2000, T-SQL, VBA and DAO.  Solutions provided instantaneous,
time efficient and accurate data-on-the-desktop for the reporting needs for
various HR groups, eliminating the need for report requests that customarily
required a 3 to 4 day waiting period for delivery from HRIS.
•	Modeled, developed and implemented a custom MS Access 97 database for the
Global Recruiting Team. Solution provided customized interface for editing and
updating of data, various report generation using both customized Access reports
and customized Excel workbooks that incorporated VBA for data retrieval from
Access DB. 
•	Ad-hoc reporting using Peoplesoft Query, DB Artisan
•	Custom report creation using Peoplesoft Query


 
J. P. Morgan Chase - September 1997 May 2000 
Developer Programmer/Analyst
•	Productivity Improvement Initiative - Integrated application development using
MS Access, MS Excel and VBA, using data extracted from Sybase and Oracle backend
OLTP and OLAP systems for automated analysis of various equity product offerings
resulting in the reduction of a 80 man-hour bi-weekly process to a 1 hour
exercise.  Remodeled various tactical and strategic desktop Excel workbook
applications to utilize automation for front office financial analysis needs. 
The remodeled structure incorporated ODBC, DAO (passing SQL strings from Excel to
Sybase backend db’s), VBA to access and import data from networked source files,
and linked tables. 
•	Redesigned, developed, coded and automated a scenario generation tool for
asset returns and multi-period portfolio optimization for allocation of
structured products for the Asset Mgmt. Group.  Redesigned tool incorporated VBA
programming in MS Excel, MS Access, ODBC, DAO, SQL and a Sybase backend.
•	Modeled, developed, coded, tested and implemented automated custom Excel
spreadsheet based applications for Global Assets Consolidation and Analysis for
12 world-wide offices for the NY Financial Group for front office performance
analysis within various product groups (Equity, Fixed Income, High Net Worth,
etc.) as well as the Risk Mgmt., Asset Mgmt., Revenue Value and Cash Flow groups.
 Newly re-modeled Access databases and Excel workbook applications provided more
time-efficient and precise systems all based on MS data access technologies and
VBA programming as needed.

Morgan Stanley/Dean Witter Reynolds - August 1996 August 1997 
Developer Analyst/Technology Consultant 
•	Designed, developed, coded and implemented automated, custom spreadsheet
solutions, using VBA in MS Excel for the Financial Reporting Group 
•	Developed online documentation and help file system 
•	Converted Lotus 1-2-3 files and macros to MS Excel and VBA 
•	Provided MS Excel technical support and training for the Financial Reporting
Group 

New York Times - February 1994 August 1996 
Corporate Collections Manager 
•	Managed billing and accounts receivable and collections for retail chain
accounts 
•	Coordinated and negotiated the collection of over $2 million in receivables
over 180 days 
•	Reorganized Retail Chain Account department resulting in increased efficiency

•	Developed custom MS Excel based accounting and reporting system 
•	Managed computerization of Retail Chain Account department and training 
•	Managed eight permanent employees and temporaries when needed