Curriculum Vitae

Justin Connaughton

 

 

Email justinweb1@showpiece.co.uk

 

Marital Status:      Married                                                                                                      DOB 01-04-1968

Driving License:   Full Clean 23 years                                                                                   Age: 40

 

Summary

An analyst with over 12 years experience of financial systems development and analysis using various toolsets and data systems such as the Sybase and Oracle RDBMS.

 

Experience

Jan 2008 – Present            Project Brokers Ltd. Bellis Jones Hill, 25 Watling St., London, EC4M 9BR

Job Title                 Consultant Contractor

Responsibilities:   Working for a consultancy supplying MI and reporting information to Investment banks using the Qlikview product from www.qliktech.com . Providing solutions and reporting requirements rapidly and accurately based on user requests, from multiple data sources allowing business users to view and report business critical data on a wide data set to include a full range of trading derivatives and equities and sub prime reporting through to research and performance analysis on a global management level. Setting up intranet services to allow distribution of the reports to a wide and secure user base where required.

Tools:                     Qlikview, Excel, HTML, OpenSpan Certified Developer

Business:               Investment Banking Consultancy    

 

September 2007 – Dec 2007   BP Oil Trading International Ltd 20 Canada Square, London, E14 5NJ

 

Job Title                 Consultant Contractor

 

Responsibilities:   Mid Office Support. To work as part of a team supporting and developing a multi-client Mid Office deal processing systems of a major international oil company. Providing support to users of the in house trading systems during release and early life support for Openlink Endur. Also supporting Moft, and Clearvision on BP’s London trading floor. Ensuring trades are processed inside expected processing times, and liasing with traders, and business users in the UK, US and Singapore.  Covering overnight support tasks and ensuring P&L batch processing completes correctly, to ensure business has up to date data.

Tools:                     Openlink, Sybase 12.5.1, Oracle, Unix, Business Objects

Techniques:          Stored procedures, C, Structured programming, shell scripting

Business:               Oil Trading

 

Mar 2006 –Aug 2007         BP Oil Trading International Ltd 1 Broadgate, London, ECM 2AP

Job Title                 Consultant Contractor

 

Responsibilities:   Mid Office Business Analyst/Data Analyst To work as part of a team to provide a conformed reporting solution to enable Management Information systems an easier method of reconciling deals across various in house systems. Activities include Business Analysis, design of scripts, extract and import routines, release methodology and compilation of new standards and merging of current standards. Coding stored procedure extracts and import routines.

                                During this period I have also been continuing work on the Openlink project as described below on a part time basis, ensuring reference data is accurate and up to date for the implementation of the Openlink Endur system.

 

Tools:                     Sybase 12.5.1, MS SQL Server 2005, DTS, Business Objects, Clearcase, Qlikview

Techniques:          SQL Scripting, stored procedures,  Data Warehousing.

Business:               Oil Trading

 

Feb 2005 – Mar 2006         BP Oil Trading International Ltd 1 Broadgate, London, ECM 2AP

Job Title                 Consultant Contractor

 

Responsibilities:   Mid Office Business Analyst To work as part of a team to provide a replacement deal processing system using the OpenLink Endur deal entry system. Design and writing of scripts for migration of transaction data and set up of reference data. Setting up users and security to comply with Sarbanes Oxley requirements. Set up of a workable plan for parallel processing, including reconciliation of P&L and migrated deals. Design and implementation of reporting requirements necessary for the business users. To provide advice and information to other analysts on the existing mid office systems.

 

Tools:                     PowerBuilder V9, Sybase 12.5.1, Oracle, PL/SQL, Openlink, Unix, Business Objects

Techniques:          SQL Scripting, stored procedures,  Structured programming,.

Business:               Oil Trading

 

October 2001 – Jan 2005  BP Oil Trading International Ltd 1 Broadgate, London, ECM 2AP

Job Title                 Consultant Contractor

 

Responsibilities:   Mid Office Support. To work as part of a team supporting and developing a multi-client Mid Office deal processing systems of a major international oil company. Providing support to users of the in house trading systems Mobo and Moft, Tempest Trader and Clearvision on BP’s London trading floor. Ensuring trades are processed inside expected processing times, and liasing with traders, and business users in the UK, US and Singapore.  Covering overnight support tasks and ensuring P&L batch processing completes correctly, to ensure business has up to date data. Providing 2nd&3rd line advice to the support team.

Tools:                     PowerBuilder V6, V7 & V9, Sybase 11.9.2/12, Unix, C, Business Objects

Techniques:          Stored procedures, C, Structured programming, shell scripting

Business:               Oil Trading

 

January 2001 to September 2001    Merrill Lynch, Milton House, Milton Gate, London

Job Title                 Consultant Contractor

Responsibilities:   Group Clearing Account Management Support. To work as part of a large team, supporting and developing a multi-client Back Office Settlement systems of a major international development bank. Providing support to users of a Gloss system, acting as a clearing broker for external clients. The system is designed to process around 250,000 trades a day, supporting multiple clients. Also developing new applications and reports for use with new clients, delivering software to tight time scales on time.

 

Tools:                     PowerBuilder V5 & V7, Sybase 11.9, Wilco Gloss HV, Unix, Perl, C

Techniques:          Stored procedures, C, Structured programming

Business:               International Trading Bank

 

January 2000 to December 2000     Merrill Lynch, Milton House, Milton Gate, London

Job Title                 Deputy Production Support Manager

Responsibilities:   Gloss Production Support. To work as part of a large team supporting and developing Back Office Settlement systems of a major international development bank. Providing support to users of 12 systems around the world, the largest processing around 40,000 trades a day on a 24/7 basis, Releasing new code into the production systems, liaising with the business and deputising the 10 developer strong support team.

Tools:                     Power Builder V5, Sybase 11.0.3 & 11.9, Wilcox Gloss HV, Unix, Perl, C

Techniques:          Stored procedures, C, Structured programming

Business:               International Trading Bank

 

May 1999 to December 1999 Trace PLC, St John St., London

Job Title                 Consultant Contractor

Responsibilities:   IT Development. To work as senior developer, in a team developing property management software for external clients. As well as developing new functionality, I provided day-to-day support for external clients, visiting sites, bug fixing and migration of previous Unix System to the GUI version.

 

Tools:                     Powerbuilder V6.5, Microsoft SQL Server 6.5, Sybase SQL Anywhere V5.5, Unix

Techniques:          Structured Programming, Stored procedures.

Business:               Software house developing Property Management Software

 

June 1997 to May 1999     Dai-Ichi Kangyo International Bank, King William St., London

Job Title                 Consultant Contractor

Responsibilities:  IT Development. To work as senior developer in a team in the back office development of a trading bank, maintaining code and class libraries, developing new products, writing stored procedures. Providing user support. Developing Intranet products using PowerBuilder.

Tools:                                     PowerBuilder V5 & V6, Sybase 10 & 11. Wilco GlossPack Back Office.

Techniques:          Structured Programming and stored procedures

Business:              International Trading Bank.

 

Oct 1995 to June 1997      Intuitive Systems Limited, Primett Road, Stevenage.

 

Job Title:                Analyst Programmer Grade 1

Responsibilities:                   Financial Services Division. To work as part of a large team, which includes consultants from Sybase, Powersoft and Synamic, to develop and deploy a point of sale system for a large insurance company with over 2000 field service representatives. The work involves analysing and implementing Object Orientated methodology, extending the PowerSoft Foundation class library. Leading a team, in providing technical backup to the system integration and deployment teams, both on site and in the office.

Sales System Division. To develop and deploy the Intuitive Sales and Marketing and Telemarketing Workbench products. My work ranged from designing new classes to extend the application infrastructure through to customizing the system to realize client requirements.

 

Tools:                    PowerBuilder V5, Sybase SQL Anywhere, Data Replication, Oracle, Select, IS/2

Techniques:          Data Modeling, Object Oriented Design and Implementation

Business:              Sales and Telemarketing, Insurance laptop Point of Sale Systems

 

Education

Sept 1979- July 1982            Austin Friars School, St. Anne’s Hill, Carlisle.

Sept 1982 - Feb 1985            Victoria High School, Ulverston, Cumbria.

Feb 1985 - July 1985             Barrow Technical College, Howard Street, Barrow, Cumbria.

Sept 1985 - July 1987           Wigan College, Parsons Walk, Wigan.

 

Qualifications

O Levels:               English Language, English Literature, Math’s, Physics, Chemistry, Geography, History, French

C&G:                      Communication Studies

OND:                      Photography

 

Hobbies and Interests

My hobbies and interests include: Photography, Running, Cycling, Off-road driving and track days, with frequent visits to the old Nurburgring, in Germany, my Bearded Collie & Australian Kelpie dogs.