Paul Snook Email and Phone Number

• Engaged to support and enhance the existing databases (Access, SQL Server 2008, SQL Server 2012).• Built a new project-specific Clinic database (Access) that could operate on free-standing laptops and synchronise with a network back-end when connected to the network.• Developed automated import, recoding and data exporting processes in the existing Phenobase Database (SQL Server 2012).

Contracted to work on a project for Public Health England (West Midlands), assisting the in-house development team to fix and enhance their Colposcopy Database. The database is used by a number of hospitals in the Midlands. The database was initially in the structure of a front-end which also held most of the tables and a back-end that held the primary data tables. The database was intended to be installed on a network drive and potentially accessed by multiple users at once.The enhancements included:- developing a utility that could be used to automate the upgrade of existing databases to a fully front-end / back-end structure.- assisting the in-house development team in upgrading the back-end from Access to SQL Server- assisting the in-house development team in upgrading the database to cater for multiple hospitals in a single Trust.

In this role I was a solo developer based within the HR Learning and Development MI Team, working on an Access database that had previously been built to; manage and collate course feedback from delegates, store and calculate some MI statistics and provide some basic reporting functions. The database suffered from a number of serious issues, such as reports running very slowly, crucial functions not working at all and a complete lack of dynamics that made it impossible for a standard user to make any amendments.Initially I was asked to fix a number of urgent problems, examples of which include:• On the first day I amended a query that was taking over 90 minutes to run so that it completed in less than two minutes. The previous developer had failed to understand how queries were processed when a “SELECT * FROM [table] WHERE….” statement was included in the criteria.• Amended the feedback import process so that it didn’t break when attempting to import feedback forms that had had their structure altered by the delegate.• Amended the feedback reporting statistics so that they were calculated correctly.I then developed an automated MI Report that would output the calculated statistics to Excel. The report itself needed to be stable, include the underlying data and be dynamic, which was achieved using key Excel functions and capabilities such as, VLOOKUP, Tables, Pivot-Tables, Named Ranges and Advanced Conditional Formatting.I was then extended for a couple of months in order to redevelop a couple of existing functions which had become obsolete because criteria in queries had been hard-coded. The new functions allowed users to select / amend criteria, such as which courses to include in a Career Pathway, using a professional user-interface. Other benefits included greater stability through proper error-handling and quicker, accurate reports through more efficient use of queries (in one case replacing a report that used 65 queries with one that needed just 6).

This role was based in the Product Control IT Team who were responsible for developing the Tactical and Strategic solutions for the Product Control Teams and made use of a range of technologies, including; Microsoft Access, Excel, SQL Server and C#. Prior to my joining the PCIT Team, they had found that too much of the developers’ time was being spent dealing with support issues. I was therefore hired to act as the contact point for users and to investigate and resolve the issues with as little interruption to the developers as possible. I was required to quickly familiarise myself with all the applications developed by the team and in most cases, develop, test and release any fixes.This role required extensive knowledge of Access, Excel, VBA, SQL Server (primarily Stored Procedures and data manipulation, but some exposure to SSRS) and eventually an understanding of C#. It also gave me exposure to a formal version-control process (initially using VSS, then SVN), enhanced my ability to pick up and decipher code from a wide-range of developers, and allowed me to expand my knowledge of SQL Server development. After about three years I switched to a pure RAD Developer role, developing tactical solutions for the Product Control users. Most involved an Access application processing data imported from a variety of SQL Server databases and exporting dynamic reports to Excel. All these applications were multi-user, multi-location, often cross-team and required extensive use of VBA and T-SQL, including:• ADO and DAO • Classes• Ribbon Customisation• DSNless connection to SQL Server and OracleIn addition, the applications required:• Developing a professional user-interface• Building efficient queries• Securing the database (.mde / .accde)• Basic but effective version-control• Split front and back-end with the back-end installed on a common server and the front-end installed on the user’s pc with an installation script.

As part of the Lean Project, I developed a number of new Access and Excel applications to automate otherwise manual processes. Worked with a number of Product Control teams simultaneously and was responsible for the whole development life-cycle of each application, from gathering requirements, overseeing UAT and gaining user sign-off.

Was based within the Structured Notes Product Control Team, primarily supporting and improving their existing Access and Excel applications.Developed a small single-user application that extracted data from Active Directory and presented the information in a hierarchical Treeview Control.Created a small application to easily manage the links to external servers (ORACLE and SQL Server) for all the applications used by the Structured Notes team.

Supported and enhanced existing Access and Excel applications.Developed four new reconciliation tools using Access, one of which used code I had written for an existing application that imported data provided in XML format. Two applications needed to interact with internal Sharepoint sites. All were required to import data from either SQL Server or ORACLE databases.Created an Excel application for collecting Positions data from multiple users. The data was subjected to significant validation testing and the results collected and reported in the workbook. The data collected, including the validation data was subsequently imported into a new Access application.

Stabilised or rebuilt a number of small, user-built Access databases.Supported and enhanced the Regulatory Reporting applications, built in VB with a SQL Server back-end.Built a number of new reconciliation applications using Access as required. Most were required to extract data from SQL Server and present the results of the reconciliation in a user-friendly and presentable Excel spreadsheet.Between November 2005 and June 2006 I was also seconded to the Product Control RAD Team to assist with the support and development of a number of applications.

UBS - Redeveloped Account Opening form in Excel for the Client Vetting Unit.HVB - Developed a function in an existing database to extract and query data from Bloomberg.CPS Inspectorate - Developed a multi-user timesheet application. General users were allowed to run pre-determined reports analysing their workload while senior management could run ad-hoc reports on any data they required.

Working directly with the Middle Office Settlements team, my role was to support and maintain their existing Microsoft Office applications and develop a handful of new tools.I developed two new reconciliation tools using Access and Excel. The tools were multi-user applications that reconciled internal CDS Trades and NOSTRO Breaks.Developed a Ticket Manager application using Access for use within both the Credit and Rates Middle Office Teams.Enhanced two existing New York application (Access) for use by the London Middle Office Teams.

Joined the Central Business Services Accounts Team to develop a number of small Access and Excel applications to automate their reconciliation and substantiation tasks.

Managed a team that supported internal and external users of the Mellon Financial Accounting products.

Supervised a team of Data Integrity Administrators in the Custody Risk Management Department. Key responsibilities were the day-to-day management of the workloads and liaising with various stakeholders from the UK and US,

Started off as Product Support Analyst when the company was known as BZW Asset Management, where I was responsible for assisting back-office users of the in-house Investment Accounting Systems and processing Corporate Actions on the stocks held in the Investment Funds. As the team grew, the two functions were split and I was promoted to Supervisor of the Systems Administration Team.

My first position out of education was as a Data Analyst for Datastream International (now Thomson Reuters).I was required to maintain the accuracy of stock data for UK Equities and Unit Trusts and whilst in this role, gained a basic understanding of dealing, an in-depth knowledge of UK Equities and reasonable knowledge of Corporate Actions.During my time at Datastream I ran a project team to improve the Unit Trust database including setting up new procedures.