Senior Business Analyst Resume Profile, NJ - Hire IT People

Professional Experience

Confidential

Technical Analyst

Improved pre-pricing trading from 2 to 90 with development of database to regionalize market values using New York's daily Foreign Exchange spot rates, linking population by trade IDs and identifying reasons for market value breaks.
Eliminated user errors and saved time through developing spreadsheet to automate daily reconciliation of global internal equity options, generating exposure summary reports for discrepancies over 500K.
Reconciled currency swaps by originating new database to increase efficiency and speed by creating automatic process for reporting that identifies missing offsets and enabling automatic reconciliation.

Confidential

Senior Business Analyst

The database manages 33 District Courts in the Boston area, including large volume centers such as Dorchester, and West Roxbury courts. On average, it tracks over 7MM in balances and over 4,000 accounts. The database streamlined the turnaround time for the processors and enabled a more efficient tracking of the process.

Confidential

Senior Business Analyst and Access/Excel Expert to manage international product deployment

Developed an MS Access front-end utilizing VBA to create DAO links to SQL Server back-end that enables case managers to create, update and track claims for Total and Permanent disability.
Linked the database directly to the company's IBM 3270 mainframe system to allow immediate data refresh.
Database allows users to prepare approvals, denials and request for information correspondence letters using Word mail merge. Prepared end-user and technical documentation and trained users.

Confidential

Access Developer for Portfolio Management

Developed an MS Access database to manage the drug approval process. The database tracks projects, resources and financial data to create a unique portfolio for each drug approval.
Linked MS Access to MS Excel templates using VBA in order to create analysis reports for users and linked to Word mail merge documents to generate progress reports for managers.
Developed an MS Access database to support the company's direct mail forecasting efforts by tracking catalogue sales and using resulting sales data to develop forecast models.
Imported weekly catalog data from the company's mainframe into Access where it is consolidated with forecast data provided by the Marketing and Inventory Control departments and created seasonal forecasting curves for demand, returns, orders and backorders and produces seasonal forecast reports. Prepared comprehensive user and technical documentation.