CV of Jon Elsom Jon Elsom is a consultant with over 15 years experience in the IT industry, having extensive knowledge in all aspects of systems development. He has worked with numerous database products, most notably Oracle for which he has over 10 years experience and has spent the past three years working predominantly with Java, for which he has gained Sun Programmer Certification. He has, at one time or another, assumed most roles within a project team, with the majority of his time being spent acting as team leader, technical consultant or trainer. Personal Summary Address: Lydstep, Cornwall Gardens, Brighton, East Sussex BN1 6RH Nationality: British Status: Married Date of Birth: 28.03.64 Telephone: 01273 501 130 Mobile: 0780 320 4014 Email: jon.elsom@aWonderfulChoice.com Availability: From Dec 2003 Career Summary Company: Freelance Consultant Role: Analyst/Designer/Team Leader/Builder/Trainer Period: Sep 92 - Present Company: Cap Gemini (formerly Hoskyns Group) Role: Systems Integration Division - Junior Programmer to Technical Consultant Period: Sep 87 - Sep 92 Technical Summary Operating Systems: Unix inc shell scripting (10 years) Windows (10 years) VMS (5 years) Database Products, Tools and Utilities: Oracle RDBMS V5-9I (10 years) SQL*Plus, pl/SQL (10 years) Oracle Designer (7 years) Oracle Developer Forms & Reports (3-6i) (10 years) Cache (DSM, DTM, MSM) (6 years) XML, XSL, XSLT (3 years) Other Products: Apache/Tomcat (3 years) CVS (10 years) TogetherJ (3 years) ANT (1 year) JUnit (3 years) Java and Web: Java/J2EE (3 years) JavaBeans/EJBs (3 years) JSPs/Servlets (3 years) AWT/Swing (3 years) HTML/DHTML (4 years) JavaScript (4 years) Methodologies: PRISM (5 years) PRINCE (7 years) SSADM (2 years) DSDM (2 years) eXtremeProgramming (3 years) UML (3 years) Sumary of Achievements * Has extensive knowledge of both OO (Java) and RDB (Oracle) languages, toolsets, standards and processes, thereby become a vital resource in any mixed project. * Expert in both UML and RDB Case environments and products. * Worked as an Oracle team leader for Government Agency for seven years following full project lifecycle delivering national applications on average once every eight months. * Chosen by Oracle to give numerous internal and public courses in analysis and design techniques, based on practical experience gained in enterprise-wide application developments. Experience Summary Company: Freelance Consultancy Summary: Oracle Reports consultant working for local authority (Aug 03 - Present) Description: The consultant has been asked to produce numerous reports from an existing complex Oracle application dealing with social services provision within the local authority.In addition he has been asked to document system structures and enable SQL and pl/SQL knowledge transfer. Key Achievements: * Constructed complex matrix reports and graphics objects using Reports 6i * Automated documentation of system using pl/SQL analysis scripts to generate ERD's in Visio Company: Freelance Consultancy Summary: J2EE expert for financial software supplier integrating product to client banking application (July 03 - Aug 03) Description: Working in the City and operating within very aggressive timescales the consultant was asked to develop Java classes to communicate, through XML, with the client's remote authentication Vasco-based server. This enabled the product to support the client's internal security procedures. The work was successful and the product was integrated accordingly. Key Achievements: * Increased knowledge of XML and file parsing linking via EJB's to Sybase and Oracle * Experienced gained in using JBoss and Forte Company: Freelance Consultancy Summary: Team member in Java/JSP/Apache/Cache development for internet startup (Nov 00 - June 03) Description: Working in a small team to provide complete business functionality for this startup, the consultant has helped to design and build numerous Java classes, servlets and JSP's. Specific Java experience was gained in developing open tools for JBuilder, parsing XML files for data import, constructing configurable web trawling utilities and building daemon processes for automatic data state transitioning. During this time the consultant has also been required to investigate the possible use of Struts within the project and conducted some investigation work into the potential use of EJB's. Some anaylsis work has also been conducted for a sister project using Oracle 9i. 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 * Experience gained in flexible OO design, using basic design patterns and laterly Struts * Good knowledge of UML attained using dedicated modelling tools * Some exposure to Oracle 9i Company: Freelance Consultancy Summary: Senior Team Leader/Analyst/Designer/Trainer implementing various Oracle systems for Government Agency (Nov 93 - Nov 00) Description: Over the course of 7 years the consultant provided a number of services to this Agency. Following successful integration work the consultant 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, the consultant 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. 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) Company: Freelance Consultancy Summary: Part-time Lecturer in Analysis and Design Techniques for Oracle UK (Nov 96 - Nov 99) Description: The consultant was engaged by Oracle Education to give both public and internal courses on a periodic basis. He lectured in Business Modelling Techniques (functional decomposition, dependency diagrams, ERM, data flows, RDA) and Relational Systems Design (database design, remodelling, selective denormalisation, indexing strategies, 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. 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 Company: Freelance Consultancy Summary: Analyst/Designer building a Management Information System for Andersens Consulting FM site (Sep 92 - Nov 93) Description: The consultant worked as an analyst/designer/programmer for this leading Regional Electricity Council alongside both Andersens Core Practise consultants and end users. This development has made heavy use of CASE*Generator to create forms, reports, menu structures and DDL scripts with the consultant occupying a key role, becoming the resident expert in the use of the Generator. Key Achievements: * Increased analysis skills and gained in depth knowledge of CASE*Dictionary/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 Company: Cap Gemini (formerly Hoskyns Group plc) Summary: Team Leader developing Middle Office Client Reporting system for a leading Portfolio Management Group (Mar 91 - Aug 92) Description: The consultant 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. 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 * Managing live implementation and co-ordinating live support Company: Cap Gemini (formerly Hoskyns Group plc) Summary: Designer/Programmer on billing system for Government Energy Authority (Sep 90 - Mar 91) Description: Cross training from MUMPS to Oracle the consultant became a designer/programmer for this Authority using Oracle V5 and SQL*Forms V2.3. Key Achievements: * Developed knowledge of SQL*Forms and SQL*Plus and increased skills in Unix and VMS Company: Cap Gemini (formerly Hoskyns Group plc) Summary: Programmer-Senior Programmer/Team Leader building MUMPS applications and 4GL environment (Sep 87 - Aug 90) Description: The consultant 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. Key Achievements: * Design and build of a major new release of MDM, team leading up to four people * Responsibility for sales support and training (development of 2 new public courses) * Conducted numerous sales support meetings and demonstrations * Consultancy at user sites on usage, performance and developments in MDM * Conducted graduate training over a two month period Qualifications 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) Course: Train the Trainer Provider: Learning Tree Course: Java Programming Workshop Provider: Sun Systems Course: Bespoke CDE2000 Training Provider: Oracle Course: CASE*Dictionary Introduction Provider: Oracle Course: CBT Forms V4.5 Provider: Oracle Course: CBT pl/SQL V2.0 Provider: Oracle Course: Introduction to Oracle Provider: Instruction Set Course: Practical Team Leading Provider: Hoskyns Education Course: Time Management Provider: Hoskyns Education Course: PDP-11 System Management Provider: Hoskyns DEC Education Course: VAX-DSM System Management Provider: Hoskyns DEC Education Course: Data Structured Programming and Design Provider: Hoskyns DEC Education Course: Professional Programming Provider: Hoskyns Education Course: MUMPS/MDM Graduate Training Provider: Hoskyns DEC Education References Available on request Other Details Other Information: Full current clean driving licence An up-to-date copy of this CV may be found on the consultant's web site, www.awonderfulchoice.com. Interests: Keen cricketer, snooker player, enjoys juggling, unicycling and speaking French and German badly. Variable golf handicap.