SUMMARY:

• 15+ years experience as a Senior Programmer/Analyst in desktop and distributed systems applications
• Proven experience writing stored procedures and triggers in SQL
• Adept at translating user specifications into database solutions
• Created and wrote user, administrative and technical manuals
• Developed reporting applications in Access and Excel
• Developed applications for Treasury / Market Risk Managers
• Expertise in software life - cycle methodology

TECHNICAL SKILLS:

Languages: Visual Basic, Visual Basic for Applications, VB.net

Windows Applications: Access, Excel, Word, Crystal Reports

Databases: SQL Server, Oracle, SybaseInternet: XML, HTML, Active Server Pages, ADO, VBScript, ASP.net, SOAP

PROFESSIONAL EXPERIENCE:

Confidential, Fair Lawn New Jersey

Excel Developer

Responsibilities:

• Used Excel to calculate numerical representations (digital signatures) of the relationships between individuals and ideas
• Created VBA code to relate individual signatures to those of other individuals and groups
• Created reports to analyze the characteristics of the occurrence of the digital signatures

Confidential, New York, New York

Access Developer

Responsibilities:

• Responsible for all project life cycle phases, from specifications and coding through testing, debugging, and documentation
• Designed tables, reports, forms and queries

Confidential, Fair Lawn New Jersey

Access Developer

Responsibilities:

• Designed tables queries and reports to join customers, products, and deliverable dates and forms to produce reports with varying criteria of customers, dates and /or product type
• Database aided in determination of what to produce and in what quantities

Confidential, New York, NY

Report Developer/Quantitative Analyst

Responsibilities:

• Developed specialized reports for Trading desk and Senior Risk Management on counterparty exposures
• Data for reports were extracted using Sybase stored procedures and adhoc queries
• Reports were rendered in excel using VBA Functions and Macros
• Complied with Federal and Basel III regulatory requirements for Risk reporting
• Gathered and documented business requirements from-end users to develop reports

Confidential, Long Island City, NY

VBA Programmer/Analyst

Responsibilities:

• Creation, Development And Implementation of End of the Day report for Traders
• Creation, Development and Implementation of Access2007database to store data from three data sources
• Creation, Development and Implementation of VBA code for the treasury department to reconcile different sources
• Creation, Development and Implementation of VBA code to create worksheet reports for each of top 15 countries
• Analyzed business requirements, wrote business requirement documents
• Created functional requirements and specification documentations and constructed flow charts of the processes
• Created project plans, and automated the processes to manage project plans and project activities
• Analyzed financial data
• Identified opportunities to optimize business processes, and automate the processes
• Performed testing
• Perform daily business and application support

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Full Life cycle development from Requirements gathering, application design, implementation, testing/quality assurance, and end-user
• Development of VBA code
• Creation of DSN’s

Confidential, Los Angeles, CA

Programmer/Analyst

Responsibilities:

• Full Life cycle development from Requirements gathering, application design, implementation, testing/quality assurance, and end-user . .
• Developed and maintenance of system with VBA macros to provide reports
• Development of Industry Employment Projection application in Office 2007

Confidential, New York, NY

Access Developer

Responsibilities:

• Responsible for all project life cycle phases, from specifications and coding through testing, debugging, and documentation
• Designed tables to join managers, products, deliverable dates and forms to produce reports with varying criteria of managers, dates and /or product type
• Created VBA code to update data from Excel worksheets and to produce reports with varying criteria of managers, dates and /or product type
• Wrote user and administrative manual

Confidential, New York, NY

Software Engineer

Responsibilities:

• Developed standardized and ad-hoc reports, VBA code & Sybase stored procedures
• Maintained, enhanced and troubleshot forms & VBA code
• Created system to update data through a batch process
• Cleaned up data and developed validation procedures
• Developed in Access, VBA and VB an automated system to generate e-mails to external contacts, and in Excel a commercial product to estimate ratings based on risk criteria
• Developed applications for fixed income

Confidential, New York, NY

Access Developer

Responsibilities:

• Designed reports, queries, forms, tables, VBA modules and links to other Access databases
• Imported data to create tables
• Data analysis and cleanup
• Testing and documenting of application

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Designed SQL Server Database and tables, reports, queries, forms and VBA modules
• Creation of Stored procedures, Triggers and DTS Packages
• Imported data to create tables
• Data analysis and cleanup
• Testing and documenting of application
• Development of applications for fixed income

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Created and maintained MS Access database for reports with a search form for Credit Derivative trades
• Designed and Implemented Production Tracking Reports for Credit Derivative trades utilizing VB.Net, MS Access, VBA
• Developed special reports for Credit Events utilizing MSAccess, VBA, and Excel

Confidential, New York, NY

Team Lead Developer

Responsibilities:

• Developed application in MS Access to create automated assessment tool for the intake of clients and
• MS Excel VBA code, formulas, table lookups, calculations to test table design and data
• Full life cycle development including proposals, diagrams, flowcharts, coding and testing
• Wrote stored procedures and triggers in SQL server
• Application to report airline, hotel and car rental revenue utilizing SQL Server, Access and Excel
• Enhancements for national helpdesk call tracking and mgmt application
• Visual Basic (version 6) application to increase sales of computer services
• Credit derivatives projects using VB, Access. Excel and Oracle
• Food production system with Visual Basic and SQL Server
• Designed Excel code and macros to update commodity future prices and price changes