Mark Hawes

Developer for Product Control IT, Associate Vice President (AVP). Management of End User Computing applications in MS Excel and MS Access including user support, migrating applications to Oracle.

Development for IB Treasury, including a global system for collating and reporting liquidity (MSSQL, VBA, Excel). Broker fee calculations and invoice capture for front and middle office. Global Liquidity Sheet enhancements for Front Office and Group Treasury (VBA, Excel, Java). Currency Certificate reconciliation and reporting for Front Office and Structured Products Control (Python, XML, XSLT, xHTML, MDX, SQL, IIS).

FX Trading and Global Distribution and Physical Reports for Front Office and Distribution Control (Python, XML, XSLT, xHTML, MDX, SQL (Oracle), IIS, MS Access). Processes for reconciliation of legal agreements to actual trading. Processes for analysis and modification of global residual funding allocations.

Market Data and Trading Systems Analyisis: Reports to manage and reduce global costs of MDS Systems (eg Reuters, Bloomberg) across the bank. Treasury Analysis Projects: working prototype for analysis of the Global Balance Sheet of UBS for Group Treasury. Off Market : Tools and reports for inspecting trading patterns to assist in identification of unusual trading activity. Skew: Integration of skew calculations for FX trading into revenue reports. P&L Reporting: An ASP/VBScript-based set of web reports t

FCD Securites Lending: Development of a Balance Sheet Reporting application for Financial Control of Securities Lending and Prime Brokerage, Data extraction from several major banking databases. Analysis and Implementation of business logic for the balance sheet. Design and implementation of a user interface for controlled, scheduled and logged data processing. User training and support.

Support and continued development of a daily reporting system. Prime Brokerage: User interface for import of files provided by multiple clients in different formats. SWIFT messaging to automate settlement transfer. Automation of PDF creation, FTP and email. An MS Access scheduler to automate daily tasks, archive files and distribute report

NT Migration: Preparation of existing MS Access applications for migration to a standardised global Windows NT environment. Management tool producing reports in MS Access from SQL Server database. Stored procedures to read from and write to SQL Server. Preparation of applications for Systems Management Server packaging for unattended remote installation across Switzerland.

Development of a costing allocation system for National Grid usage. Implementation of a set of charging rules given in a briefing paper from management. Raw data extracted from Oracle database, calculated data passed to Excel for formatting into report.

Patient Administration: A module to extend the capabilities of the Patient Administration System to implement patient/provider split-charging. Analysis of data available from the health service specific databases and of a complex system of charging rules. Breakdown of the complex process into simpler steps and implementation into SQL to be handed on to a technical user at completion. Design and layout of a set of reports to be delivered to external purchasers each month. Validation routines to assist in the

Remote Site Management: Use, development and set-up of various systems concerned with energy management on remote systems. A sales database to manage contact with potential customers. An asset register for management of Kinetica-owned equipment on customers sites. Real time display of temperature and other plant-related data via modem links. Interfaces to various proprietary energy management systems. Graphing, analysis, reconciliation and billing for energy usage.

Pricing and tendering for large-scale industrial boiler plant, including database design for producing documentation. Project management for the replacement of 24 oil/gas burners for power stations in Spain and Sweden. Database development for project accounting and management.Project management of boiler 'outage', including use of project management/Gantt software.