Joined this small business to build C# Winforms applications for a diverse portfolio of clients from small furniture stores to a global retail logistics company. Team has expanded from two when I joined to 6 consultants all working from Home.Responsible for all warehouse XML Schema definitions and supporting SSIS based EDI communications for our biggest client.Technical lead for all Database tasks including SSIS and Broker Services.60% C#, 40% T-SQL

Returned to Barcap (see below) to manage the CVaR application and small development / support team. Managed the day to day running of the system and transitioned the technical team and business contacts from the Credit Risk group to Prime Brokerage group within the company.50% VB6, 50% T-SQL

Development of a “Business Rules Engine” to recreate financial investment positions over a fixed period for a data remediation project. Involved in all project phases, from schema design to liaising with testers to generating statement reports.100% T-SQL

Responsible for analysis and development of database side of a new application to pass trade and settlement data to downstream system for generating P&L and risk. Development carried out under continual contact with the Freight business teams. Also provided business with bespoke reports from an OTS Freight Logistics system using T-SQL and delivered in Excel through an automated process.60% T-SQL, 20% PL-SQL, 20% C#

Support and Development on expanding Credit Value at Risk system for Barcap’s Hedge fund business. The “CVaR” application, which started as a spreadsheet and became a collection of VB applications with a SQL Server database, pulls in position data from numerous feeds, to generate VaR amounts across a wide range of portfolios.45% VB6 (& ASP), 30% T-SQL, 25% C#

Followed a UK Power Trader from El Paso (see below) to Sempra to provide similar support tools to those described below. Afterwards the contract was extended to enable the production of a Trade Management database to compliment an established legacy system. Major functions included Position Management and Monitoring, Profit & Loss Reporting, and Price Curve storage and analysis. Became the sole Front Office Developer across UK Power, Continental and Gas desks.50% VB6 + DCOM, 20% C# & VB.NET, 30% T-SQL

Part of a small front office development team providing applications and support to energy traders. Main projects:Market Watch – captures and displays live trades and prices from brokers to all TIBCO subscribed traders using GlobalVision API. Data then used for automated trade booking.Market Reporter – provides extensive market analysis in chart form using ComponentOne charting controls. Live Candlestick, Spark spread, weighted volatility etc.Linepack Monitor –up to the minute Gas pipeline capacity information.50% VB6 + GlobalVision API, 50% T-SQL

Technical associate of the Data Team supporting busy credit risk trading desk.• Use of Bloomberg & Reuters DLLs & Controls to capture real-time market information.• Liaise with DBAs over design, indexing issues, access rights etc.50% T-SQL, 40% Excel VBA, 5% Access VBA, 5% VB6

Brought bespoke application written in Basic2C and Btrieve up to date using SQL Server and an Access Data Project.Installation, set-up and subsequent administration of SQL Server 7 Database server.Creation of Data Transformation Packages and procedures for daily export of live data to new database for testing purposes, and separate data warehousing project.60% Access VBA, 40% T-SQL (DTS + VBScript

Part of two-man team providing expertise in the development of database applications and IT tools to support business processes employed across the Defense Division. Projects undertaken from concept, through requirements analysis, design, implementation and testing.Administration of SQL Server, Web Server (IIS), NT File Server and NT Domain Server.Front-ends written as either MS Access/VBA applications or through our Intranet using Active Server Pages (ASP) and JavaScript, depending on business needs / resources.60% Access VBA, 35% T-SQL, 5% VB ASP