Peter Lawes Email & Phone Number

London, United Kingdom

FXCM is a leading provider of Forex, CFD trading and spreadbet services.o At FXCM I was team lead and Oracle/reporting resource for the UK On-Exchange Development team (3-4 members) reporting to the UK CTO.o In a major project replacing the UK On-Exchange platform with services provided by third party companies, I was responsible for the reporting solution to provide integrated oversight/management reports for compliance, risk and client liaison. This required the loading and transformation of data feeds from each external party to provide daily and trend reports as spreadsheets, plus a feed for the risk dashboard.o Working with the Compliance department I was responsible for the analysis and implementation of operational reports and daily extracts to allow the company to conform to the FCA EMIR regulations.o Working with the Risk manager I implemented a dashboard in Qlikview for senior management to monitor critical KPIs. I then provided technical and back-end support as the dashboard was extended and re-extended by the Risk department themselves.o Initially I performed a review of the On-Exchange reporting infrastructure with a view to extend existing facilities with OBIEE/Publisher. This resulted in a proof of concept implementation in the US which was well received.o My other duties included being sole UK DBA, linux administrator and providing application support to the equities business.o Oracle 9i-12c RAC; Informatica; ODI; OBIEE; PL/SQL; TOAD; Linux Admin; Bash; Python; Perl; Java; Qlikview; Jira Agile; TDD; CVS; Git.

London, United Kingdom

ODL was a London-based Foreign Exchange and Equities Brokero I was hired to lead the development of a new trading data warehouse (Oracle 9i/10G with Business Objects DI/XI) working with a mix of internal staff and a team of external consultants (combined team of 5). o I worked at board level to identify KPIs and reporting requirements, and developed a revised dimensional model which was mapped to the back office trading system. This was then used to load a subject-orientated warehouse and provide a Business Objects WEBI solution for the board and forex trading management.o After successful rollout the warehouse had multiple extensions and two major releases addressing Risk and then Client Management.o In addition to the system reporting I was also part of the DBA team (3 members) and provided development support and technical advice to the in-house development teams (25 staff) .o One major piece of work was as the database designer for a new Spreadbet platform being developed by the company. This was a large project (12 man team) for which I provided the physical database design, implementation, administration, application development (PL/SQL), performance tuning and skills transfer to the project as a whole.o Oracle 9i/10G RAC, Dataguard, OEM, Business Objects XI/DI, ER-Studio, PL/SQL, Linux, Bash, Perl, SQL*Plus, TOAD.

London, United Kingdom

o o I joined an existing team in Global Markets Corporate Credit Risk. o My role was primarily to design and implement a new MIS, but also involved 24 hour support of existing reporting systems.o Working with a team of business analysts I produced a technical architecture design, data designs, standards and specifications.o I was responsible for producing and overseeing the designs for the end-to-end data warehousing process, plus initial designs for two data marts that covered board reporting and credit operations.o I developed a number of pilot prototypes, some at full volume, to prove the approaches being adopted. The aim was to create consistent and proven templates for off-shore development.o Oracle 10.2, Linux, OWB, OBIEE, ETL, ER/Studio, PL/SQL, Bash, Perl, Business Objects (5.2), ER-Studio, Oracle Designer, Visio, SQL*Plus, TOAD.

Reading, United Kingdom

My role involved :o System performance analysis to generate recommendations on instance and application level tuning. Managing the implementation of the required system changes in liaison with in-house administrators and developers. Monitoring post-implementation to measure the achieved improvements.o Physical database design based on analysis of partial requirements documents (Kimball design, Oracle Designer, Visio).o Implementation of all required reporting components process and reformat the required sales data, so as to deliver customised Excel reports to sales managers (using PL/SQL, Perl, Lotus Notes).o Oracle 10G, Sagent ETL engine, Oracle Designer, PL/SQL, Perl, MS SQL Server 2005, MS Analysis Services 2005, Lotus Notes, MS Office

London, United Kingdom

Originally a six month project, my involvement with Inpharmatica was extended for a series of distinct development projects (varying from 3-12 months) and short periods of production support.I joined to design and implement a data model to maximise query flexibility and end-user performance of the flagship Biogensa product (1.8 Tb). The UI was a custom-build JSP application, I provided analysis and design deliverables (RUP, UML, and Oracle Designer) and implemented all Oracle related components by leading a team of three developers.There followed a project to create a new ETL process to load the data used to create Biogensa every quarter and to provide a query resource for internal scientific staff. My design hinged on the partitioned storage of protein annotation as XML with all business mappings being applied using XSLT. Again I managed the implementation and delivered a reliable and cost-effective process.Finally I produced a full volume Oracle 10g pilot to establish the future direction of the repository.My role involved: -• Generating physical database designs based on analysis of requirements (Kimball design).• Specify, design and lead the implementation of the loading processes, including relevant application PL/SQL interfaces. Tune to maximise performance.• Oversee and support the initial releases of the warehouses before hand over to support staff. Provide second tier support.• Environment: Oracle 10.1 (partitioning, transportable tablespaces, compression, bitmap indexes), Solaris 9, Redhat Linux, Erwin , Oracle Designer, Oracle Warehouse Builder, PL/SQL, Java, Oracle XML SDK, XSLT, Perl v5.8 (DBI, POE), JBoss Application Server, Apache Tomcat, Perl, Mysql, Bash, SQL*Plus

Reading, United Kingdom

The New Economic Data Warehouse was an initiative to capture market data generated by the new electricity market and provide intranet analysis using Cognos and Oracle. My role was to interface between market analysts and a team of offshore developers. In the early stages of the project I was jointly responsible for the data design, managing user expectations and overseeing the production of a raft of design documentation. Later I was responsible for quality assurance of the implemented solution, retrofitting the logical model and working with users to satisfy enhancements requests. Finally I was responsible for volume tuning the production system and facilitating the user functional system tests.My role involved: -• Establishing and documenting the application architecture and system design.• Producing a database and ETL process design to support the data captured from 65 system interfaces, while maximising the use of Oracle features to achieve acceptable performance.• Working with users to refine requirements into solutions deliverable through Cognos and Oracle.• Environment: Solaris, Windows NT, IIS, Oracle v8.16, Oracle Designer, Cognos (Powerplay and Query), Fame, MS Project.

United Kingdom

United Kingdom

Amsterdam Area, Netherlands

London, United Kingdom

Birmingham, United Kingdom

London, United Kingdom

United Kingdom

Education record

Education record