Philip Hankinson

Philip Hankinson – Curriculum Vitae Based: Öckerö, Northwestern Gothenburg Archipelago, Sweden Tel: +46 - | Email:-PERSONAL STATEMENT I have been working with the Oracle database (both relational and dimensional modelling) for around twenty years. After returning to the UK five years ago, I have also completed a number of contracts using the PostgreSQL database, in particular the PostGIS mapping plugin. These have varied from a few weeks (often in collaboration with Enterprise DB via a US subcontractor) up to almost a year (working remotely for an Australian GIS company). I have worked in many areas in and around the database SDLC, and bring a great deal of value-add (including business process investigation and modelling) to the table. I have installed maintained, completed analysis, design and datamodelling from requirements gathering onwards, developed using a variety of tools, tuned and tested Oracle databases up to multi-Terabyte datasets and their User Interfaces (primarily Forms and APEX) for blue-chip clients in EMEA/APAC. In addition I also have proven MySQL, SQLite and Spatialite development skills. I have also provided input on reporting tools, designed and implemented test reporting models, and systems administration and hardening - especially around mailservers. In terms of deployment platforms: From 1995 onwards I have evaluated, installed, maintained, enhanced and developed on UNIX (AIX, Solaris, Mac OS-X and many other BSD-based distributions), Linux (CentOS, Red Hat, Fedora, Ubuntu [both Client and Server], opensuse, opensolaris and OUL) and every release of the DOS/Windows client since v3 (8-bit through to 64-bit). A more in-depth, and recent, life/career timeline is detailed at the end of this document. A consistently upto-date CV (and more) is available at: https://www.linkedin.com/in/philhankinson SKILLS ➢ ➢ ➢ ➢ ➢ ➢ ➢ Databases (+ Others…): Oracle v7-v11 (Designer/2k and Developer: PL/SQL, Forms and Reports) - 20 years PostgreSQL v8-v9 (Design and development: pl/pgsql & embedded Python) - 5 years Operating systems: Linux, BSD, Windows, Mainframe, VAX Applications (+ Others…): ER/Studio, Designer/2000, Developer/2000, APEX v3-v4 SQL Utilities (+ Others…): SQL Navigator, TOAD, SQL Developer, Aqua Data Studio Version management (+ Others…): Subversion, Mercurial, PVCS, Visual SourceSafe WORK HISTORY AVOX Ltd, Wrexham, North Wales December 2013 - August 2014 Contract Oracle Consultant Refreshing my Oracle experience in a long-term contract for an excellent local firm doing great work as an NFP in financial regulation. Duties include: - Queue management and distribution of work to the GMEI team of analysts - Direct development and manipulation of critical systems utilising PL/SQL in support of a Java/Spring/Hibernate/XML file framework - Direct support to BAU and UAT teams, liaising with senior stakeholders and third parties in the US - Suggested Jasper Reports as a reporting suite, installed a local demo system linked into an exact copy of production, and provided access and sandboxes to potential stakeholders to demonstrate a potentially stable, scalable and cost-effective reporting solution Also: bulk validation and loading of spreadsheet data, maintaining documentation and implementing ad-hoc support queries. Enterprise DB (via a US-based subcontractor), Home August 2013 - October based: Remote Login (US-based clients) 2014 Freelance PostgreSQL/PPAS/xDB Consultant Smaller microcontracts lasting from a few days to a few weeks, these were highly challenging sub-contracts from EnterpriseDB (also known as EDB, the creators of PPAS - Postgres Plus Advanced Server). The contracts included setting up a Live system for a client using xDB (a data pump from Oracle systems to PPAS in this case) using a high-availability Red Hat cluster. Also forensic data recovery for a system called SOAPware, which had deep hooks into earlier versions of PostgreSQL, and required (sometimes) data lost through deletion and corruption to be recovered before data recovery proper could begin. GeoSynergy (Australia), Home based: October 2012 - August 2013 Australian client Contract PostgreSQL/PostGIS Consultant Provided remote advice and development/maintenance work via the internet. Dial-in and remote group discussions via Skype. - Provided yes/no go/no-go decisions on a day-to-day basis for a widely distributed network of Elance developers. - PostgreSQL/PostGIS 9.1 & 2.0 spatial database design and implementation. - Oracle 11gR2 database population and migration. - SQLite/spatialite database construction and migration. - OGR2OGR 'swiss army knife' open source data migration tool use for the above. - Mailserver, Geoserver, reporting server(s) (and other Linux deployments) design, installation and documentation. - Jasper report design and installation/deployment. Eclipse BIRT report design and installation/deployment. Evaluation of numerous other report offerings. Most of the data work completed with the aid of Aqua Data Studio (single licence from GeoSynergy on my advice), everything else with open-source and other freely available tools. rECOrd LRC, Chester Zoo, Chester UK June 2011 - April 2012 Volunteer PostgreSQL/PostGIS System Design and Development Voluntary work for this NFP providing biodiversity logging and dispersion of spatial data. In my first week I installed and populated the PostgreSQL database, added PostGIS, installed the ODBC driver and demoed the link to their existing front end (MapInfo v10.5). I also provided input on linking the SS2k RDBMS to the new PostGIS RDBMS, removing a circuitous manual route between logging and analysis of data. I have since implemented failover, load balancing and persistent connections between PostgreSQL databases on Linux and Windows platforms using pgpool-ii (which I installed and configured). Also introduced Master-Slave MySQL failover between Windows/Linux platforms, and installed and configured a suitably robust squid3 internet proxy on a new Linux machine. Tenzing, New Zealand October 2008 - March 2009 Senior Consultant: EDM Team Client: TelstraClear Datawarehouse Manager Interim project management of the Datawarehouse for this established Telecommunications Company. Hands-on Oracle PL/SQL coding, ETL tuning (at both database and SQL level) and mentoring of junior staff (including permanent full-time, permanent part-time, consultancy staff and contractors). Client: Westpac Datawarehouse Datamodelling Project Modelling a Rapid Application Development DataMart used for Basel II compliance; then recommending technical and business processes to fold changes back into the Datawarehouse for this retail bank. Landsbankinn (The National Bank of November 2007 - August 2008 Iceland), Reykjavik (Iceland) Contract Oracle Consultant (Business Intelligence/Datawarehousing) Analysis, design, development, build and support of Business Intelligence Datawarehouse system. Provide first point of contact for Business Objects Data Integrator developers for all DBA tasks. Full personal responsibility for Logical and Physical model, versioning and maintenance of all development, test and production rollout scripting using ER/Studio functionality. Tuning both database and modules down to DBA level including: - Partition management - Table and partition compression - Using indexing (bitmap, B-tree, and function indexes, IOTs) to enable rapid data extraction - Using Explain Plan and TKPROF to predict optimizer paths - Using ANALYZE, dynamic statistic gathering and statistic locking - Exporting and importing statistics - Data cleansing and backup functions. - Provide technical support and Oracle PL/SQL modules to enable rapid progress of Datawarehouse production. - Use Datawarehouse production techniques to provide fast and accurate data to Business users. JPMorganChase, Bournemouth (UK) December 2006 - September 2007 Contract Oracle Consultant Analysis, design, development, build, support and testing of core business Price Release system for this Investment Bank. Developed code structured towards performance tuning for a large (~1TB) database application. ETL of data from Sungard InvestOne system (inbound and outbound) on mainframe via OLE and Excel reports into several Oracle databases on Solaris. Analysis, design, build and test support of upgrade to Release 06.210. Used SQL*Loader and Solaris UNIX Korn shell scripts for upload of mission critical files via FTP from WMDaten feeds. Including bulk load for historical data. Created and maintained GUI components using Form Builder. Deployed via Citrix thin client. Reuters, Radianz, BT Global Services, February 2001 - September 2006 London (UK) Lead Oracle Designer/Developer Analysis, design, development, build, support and testing of a network configuration support tool for this fixed line financial data feed provider arm of British Telecom Gathered requirements from BSS, suggested solutions to network developers in OSS Completed E2E coding solutions for the last mile (PE/Physical Edge router configuration and cross-cloud traffic shaping, across to CE/Client Edge router configuration and client-sited-server maintenance, including NAT/PAT configuration) Designed & developed robust batch and back-end PL/SQL to the Forms and Report front end Designed and developed data stores and the User Interface experience Fujitsu, Mastercard Europe, National Power, August 1995 - December 2000 Logica, Balsam Healthcare Saudi Arabia, Belgium, UK (Various locations) Contract Oracle Designer/Developer/DBA/Systems Admin Systems administration, DBA, analysis, design, development, build, support and testing of various systems for a variety of clients including: Legal, Utilities and Financial Services. EDUCATION University of Manchester Institute of Science and Technology (UMIST), Manchester (UK) Biochemistry BSc Hons. 2(i) August 1990 - June 1993 Priestley College, Warrington (UK) August 1988 - June 1990 Biology A-level: A, Chemistry A-level: A, General Studies A-level: A, Physics A-level: B HOBBIES, INTERESTS, LIFE & CAREER TIMELINE ➢ I love all aspects of working with software and (preferably vintage, exotic, or just downright unusual) hardware, and databases and their user interfaces in particular. So I have in fact successfully managed to make my hobby into my career. Surely every man’s dream. ➢ I began my consulting career as an Oracle contractor in 1995. After leaving UMIST with an essentially useless Biochemistry BSc degree in the depths of the early-90’s recession, I began an MSc Computer Science 1 year conversion course the following year. As I approached the end of this Master’s Degree, I was offered an unexpected take-it-or-leave-it opportunity of a 366-day tax free contract in Saudi Arabia. This was to be working on a hospital accounting system using Oracle’s brand new Windows 3.1 GUI Forms v4 and Reports v2 builder, plus complete training and housing, company car, and the opportunity to pay off my entire student debt within a year. With a bit of cash left over (and a tan) ready for my return to the UK. ➢ I took the plunge, postponed completion of my dissertation on the then-newly-minted technology, the World Wide Web, to the following year, achieved my PADI Advanced Open Water certification (the original card for which I still own) in the crystal clear and completely unspoiled southeast coastal waters and reefs of the Red Sea, and the rest is history. ➢ Sadly my supervisor left the University, retired, or was simply unavailable in the meantime, and my paper linking HTML to dynamic database output in order to migrate an existing file-based database to Oracle, and create a website on top of it (using the very first OraPerl bindings) for a local museum was never completed. The beta version was completely hand-coded in a basic solaris-based text editor, and if finished would, I believe, have been one of the first projects of this kind in its time. ➢ Very much later, having followed the Oracle design and development path as a contractor for over ten years, while living in New Zealand my wife and I decided to exchange roles - I would look after our infant daughter until school age, my wife would go back into full-time work as a Functional SAP FI/CO consultant (in fact, she joined the same consultancy firm as I had). I thought I got the better part of the deal and enjoyed two New Zealand summers just myself and my daughter. An amazing time, and the like of which too few fathers will ever get to experience. ➢ Following the passing of my Maori Father-in-law, my daughter spending time with her maternal grandparents having been the reason for our initial move to NZ, we decided to return to the UK. I began my new UK career as a volunteer at a local not-for-profit based in Chester Zoo, while continuing to look after my daughter until school age (near to my family, in Chester), and made the move into PostgreSQL on Linux deployment, administration and design/development. ➢ More recently, Ivy Hankinson (my wife and business partner) and I have been involved in a personal web project for the past two years. In May 2015, we made the company we created dormant with Companies House and took the promotional and test servers down, after deciding to sell the website, domain names, trademarked and legal materials as a bundle: Rather than attempt the risky and expensive task of promoting and marketing the website further ourselves. ➢ Sadly, my daughter and I were involved in a very serious motorway/freeway accident close to our home here in the UK in June 2015. Although completely exonerated from blame, we have had a great deal of recuperation to do. As such, I am deemed medically to be unavailable for office work until mid-2016, at the very earliest. I thank you for your consideration in this time during your selection, and contact, for potential roles. ➢ I am now (as of October 2015) accepting offers of remote work, with occasional site visits. REFERENCES ➢ References are available on request following interview and signed contract.