Curriculum   Vitae 
Jon Elsom

Jon Elsom is a Database architect and developer involved the IT industry since 1987. He has extensive knowledge in all aspects of systems development. He has worked in private and public sectors, in small and large teams, from initial inception of projects right through to completion and the delivery of the business benefits. He has, at one time or another, assumed most roles within a development team from architect, technical lead through to systems developer and trainer.

Contact Details and Availability

Telephone:0785 656 1539Nationality:Britishe-mail:jon.elsom@awonderfulchoice.com	LinkedIn:https://uk.linkedin.com/in/jon-elsom-19a94b29Availability:Please contact meLocation Pref:London, Brighton, remote working

Career Summary

Freelance ConsultantDatabase Architect/Technical Lead/Analyst/Designer/Team Leader/Systems Developer/TrainerSep 92  PresentCap Gemini (formerly Hoskyns Group) :
Systems Integration DivisionJunior Programmer – 
Technical ConsultantSep 87  Sep 92
Technical Summary

Database Products, Tools and UtilitiesAzure CloudLogic AppsPythonSQL Server
Oracle RDBMS V5-11GSSIS Packages
SQL*PlusT-SQL
pl/SQLPostgreSQLNeo4JMariaDBMS SQL Import/ExportSQL*LoaderCDE2000 DesignerMUMPS (Cache, DSM, DTM, MSM)XML, XSL and XSLT Oracle Data ModellerJava and WebJavaJ2EE, EJB's and JavaBeansAWT and SwingJavaScriptHTML and DHTMLJSP/ServletsSOAPRESTWSDLOther ProductsApache/TomcatGITBoomiANTClearcoreMulesoftKatalon StudioPHPPythonMethodologiesSAFe AgileXPUMLPRINCE
Experience Summary

Freelance Consultancy
Enterprise Data Architect for NHS (Oct 2019 - Present)

Jon founded the Sussex Integrated Dataset (SID), a de-identified integrated mesh of healthcare data sources covering the population of Sussex (1.7 million people, 3 billion consultation records).

Key achievements :
* 97% uptake from GP practices, Acute services, Social Care, First Responders, Community Health, Mental Health Services
* Established a framework by which multiple research questions could be answered thereby enabling an evidence-based healthcare policy to be adopted in Sussex
* Automated processes through Logic Apps to develop a cycle of continuous data quality improvement
* Application of machine learning algorithms to create predictive models (e.g. injurious falls, MH patient presentations at A&E)


Freelance Consultancy
Lead Database Developer working for local authority (Aug 03 - Present)

Jon was a lead systems development resource for this. Initially asked to produce a number of performance reports from an existing complex Oracle application this development was deemed such a success that subsequently a whole raft of reporting functionality, covering all aspects of social care, was developed. In addition, Jon developed data feeds from education and health systems leading to enhanced cross departmental reporting. He used his Java skills Java in supporting and extending functionality in building control and adaptation systems using an Agile approach. Jon wrote and delivered training courses to enable teams to migrate from Oracle to SQL Server and compare other SQL products such as PostgreSQL and MySQL.

Key achievements :
* Developed numerous database packages in SQL, pl/SQL and T-SQL for all aspects of corporate reporting, with output to a wide variety of channels
* Developed a framework in PHP and SQL by which all council bespoke web services are delivered, enabling 1 million plus calls in the first year
* Java developer supporting systems using JavaBeans, developed Java Action calls in Mendix
* Constructed complex reports and graphics objects using Oracle Reports, Business Objects, Tableau and Power BI
* Developed multiple RESTful web services using SOAP and JSON
* Developed database procedures, callable from Business Objects, to enable complex reporting
* Responsible for development and support of mass data loading processes using SQL*Loader and import/export 
* Written and presented conversion courses going from Oracle to SQL Server and comparisons with PostgreSQL and MySQL


Freelance Consultancy
Senior Developer in Java/JSP/Apache/Cache development for internet start-up (Nov 00 – July 03)

Working in a small team to provide complete business functionality for this startup, Jon was responsible for the design and build of numerous Java classes, servlets and JSP's. The system architecture used InterSystems Cache to expose persistent objects as Java classes, at that time the first development of its kind in the UK. Other experience was gained in parsing XML files for data import, constructing configurable web trawling utilities and building daemon processes for automatic data state transitioning. Jon developed a number of front end screens using Javascript and HTML. He used eXtreme Programming (XP), a methodology based upon the Agile philosophy, employing such techniques as pair programming, user stories and extensive use of  JUnit. 

Key achievements :
* Extensive experience gained in Java programming, culminating in Sun Programmer Certification
* Experienced in developing numerous JSPs and servlets for use with Tomcat and Apache
* Significant experience gained in developing HTML and JavaScripts, by hand and with Dreamweaver
* Experience gained in flexible OO design, using basic design patterns and frameworks such as Struts
* Good knowledge gained of XP and Agile
* Good knowledge of UML attained using dedicated modelling tools
* Experience of XML file construction and handling within Java


Freelance Consultancy
Senior Team Leader/Analyst/Designer/Trainer implementing various Oracle systems for Government Agency (Nov 93 - Nov 00)

Over the course of 7 years Jon provided a number of services to this Agency. Originally engaged to perform data migration work he soon moved into a key role in a national development to manage flood defence provision. He used Designer/2000 to produce data models and function decompositions and then Developer/2000 to capture the design requirements and build the some of the more complex modules. He also managed the initial stages of the roll out and presented the first set of end user training courses.

Following this Jon was asked to lead a newly formed team specialising in national developments. This team became the pre-eminent force for Oracle systems development within the Agency, producing on average a national application every 8 months, in doing so providing all services from analysis through to implementation. In addition to his project responsibilities, Jon played a key role in the development of Oracle standards within the Agency, assumed general management responsibilities within a 30 strong development centre and provided strategic consultancy in the use of enterprise-wide databases, reporting directly to the head of information systems. Towards the end of this period Jon introduced the first Java-based intranet applications into the Agency.

Key achievements :
* Extensive experience gained in Oracle 7 and 8 (including 8i) and associated products
* Extensive experience gained in CDE2000 Designer and Developer toolsets
* Assumed Team Leader role, reporting direct to Project Boards and National IS Management Teams
* Gained broad knowledge of enterprise database technical directions through strategic consultancy
* Enhanced analysis skills and knowledge of building client server systems
* Experienced gained in shell scripting and application tuning in a client server environment
* Developed web-based skills (HTML, XML, JavaScript and Java)
* Gained exposure to UML and OO design



Freelance Consultancy
Part-time Lecturer in Analysis and Design Techniques for Oracle UK (Nov 96 – Nov 99)

Jon was engaged by Oracle Education to give both public and internal courses on a periodic basis. He lectured in Business Modelling Techniques, covering such topics as functional decomposition, functional dependency diagrams, entity relationship modelling, data flow diagrams and relational data analysis and Relational Systems Design which covered database design, remodelling, selective denormalisation, indexing strategies and application design. He performed this work in conjunction with other projects as it was clear that benefits accrued to his other clients from having a consultant with such close ties to Oracle. Jon has also given independent courses in Data Browser, Data Query, SQL*Plus and pl/SQL, as well as constructing and delivering bespoke courses in analysis and design techniques.

Key achievements :
* Developed excellent presentation and communication skills
* Enhanced negotiation and sales skills in a demanding customer facing role
* Chosen as lead trainer in alliance between Oracle and a leading world-wide IT company
* Gained a clearer understanding of techniques through conducting training courses
* Forged close links with Oracle, gaining exposure to new products


Freelance Consultancy
Analyst/Designer building a Management Information System for Andersens Consulting FM site (Sep 92  Nov 93)

Jon worked as an analyst/designer/programmer for this leading Regional Electricity Council alongside both Andersens Core Practise consultants and end users. The build undertaken involved extensive use of CASE products and the Oracle V6 tool set to provide a management information system to interface with other Oracle based systems and windows packages such as Lotus 123 and Excel.

This development made heavy use of CASE*Generator to create forms, reports, menu structures and DDL scripts. The consultant occupied a key role, becoming the resident expert in the use of the Generator, whilst also progressing 6 functions from requirement stages to implementation, handling version control for integration and acceptance tests, supervising the live implementation and co-ordinating all the supporting documentation.

Key achievements :
* Increased analysis skills and gained in depth knowledge of CASE*Dictionary and CASE*Generator
* Exposure to Oracle V7 and design in V7 with a view to upgrade
* Increased Unix and VMS knowledge throughout design and programming stages


Cap Gemini (formerly Hoskyns Group plc)
Team Leader developing Middle Office Client Reporting system for a leading Portfolio Management Group (Mar 91  Aug 92)

Jon occupied the role of team leader and Oracle designer/analyst/programmer. Extensive experience was gained in Oracle V6, SQL*Forms V3, SQL*Reportwriter, CASE*Dictionary, pl/SQL and Unix. Some experience also gained in ProC.

During this time Jon built a diary and periodic report production system which interfaced with Excel and Word for Windows packages. This was seen as a precursor to client server architecture in that it gave the user all the advantages and security of an Oracle database and the formatting power of pc products. The design and build involved widescale use of SQL*Forms V3 and SQL*Reportwriter, the whole system being documented in CASE*Dictionary. More complex reports were written with pl/SQL pre processes and the controlling mechanisms for the diary were written in ProC.

Key achievements :
* Coding of the more complex forms, reports and  pl/SQL scripts
* Specification and build of all the supporting entities and interfaces
* Performance testing and tuning
* Team leading up to six people at one time
* Conducting link testing with pc products and supervising user acceptance

Designer/Programmer on various MUMPS/Oracle systems (Sep 87  Mar 91)

Jon spent a year with an insurance firm developing a 24 help assistance system. He then became part of an internal Hoskyns team building a multi-platform 4GL environment (MDM). Responsibilities included main development, sales support, training and front line support. Cross trained into Oracle the consultant developed numerous forms and database functionality using Oracle V5 and SQL*Forms V2.3.

Key achievements :
* Developed knowledge of SQL*Forms V2.3 and SQL*Plus and increased skills in Unix and VMS
* Design and build of a major new release of MDM, team leading up to four people

Qualifications

SAFe Agile Practitioner
SUN Programmer Certification for the Java 2 Platform
COSIT Certificate of Computer Competence
BSc (Hons) Chemistry (Southampton University) IIii
5 'A' Levels (1A, 4B's), 8 'O' Levels (6 A's, 2 B's)



Training (Received)

CourseProviderSAFe Agile PractitionerSAFePostgreSQL DeveloperStayAheadIPaaS platform introductionDell BoomiMendix DeveloperMendixTrain the TrainerLearning TreeJava Programming WorkshopSunBespoke CDE2000 TrainingOracleCASE*Dictionary IntroductionOracleCBT Forms V4.5OracleCBT pl/SQL V2.0OracleIntroduction to Oracle	Instruction SetPractical Team LeadingHoskyns EducationTime ManagementHoskyns EducationPDP11 System ManagementHoskyns DEC EducationVAXDSM System ManagementHoskyns DEC EducationData Structured Programming and DesignHoskyns EducationProfessional ProgrammingHoskyns EducationMUMPS/MDM  Graduate TrainingHoskyns DEC Education
References

Available on request


Other Information

Full current clean driving licence. Lived in France for 13 years, where he built a gite complex with his wife.
For more information go to the consultant’s web site www.awonderfulchoice.com.


Interests

Cricket, tennis, park run, certified VI running guide, coach to the Sussex VI Sharks.


CV - Jon Elsom									 	       27/07/2023