Profile

Phil Grinham is a Senior Oracle Developer with over 17 years' experience in the I.T industry who has worked on both small and large scale projects and has full project lifecycle experience. With expertise in SQL and PL/SQL, Oracle databases and APEX combined with Microsoft and Java technology experience; creating quality software solutions and seeing them used and appreciated is the most satisfying aspect of the work.

Brief Summary
  • Over 17 years in the industry, 9+ years in the Financial sector, 3 in Public sector and 4 in the Energy sector
  • Quality focused, driven approach to complement technical expertise in Oracle, PL/SQL, SQL and APEX
  • Experience with Microsoft development using Visual Basic/VBA and experience of SSIS, .Net (C#/VB/ASP/ADO) and C++
  • Web development experience with IIS, Tomcat and Apache using HTML, Javascript, JQuery, AJAX, CSS and XML.
  • Worked autonomously and as part of both small and large teams
  • Full lifecycle experience in small, medium and large projects
  • 2nd and 3rd line support experience

Skills

Oracle PLSQL
Oracle PL/SQL

Developed on Oracle 7i through to 12c

Oracle APEX
Oracle Application Express

Early adopter version 1.5 through to 5

Oracle Designer
Oracle Designer

Version 6i

Oracle Web Toolkit
Oracle Web Toolkit

Extensive work with the mod_plsql engine on 9i and 10g databases

Toad
Toad and PL/SQL Developer

In addition to the tried and trusted SQL*Plus !!

Web Development
Web Development

ASP, HTML, Javascript, ADO, AJAX, XML/XSD, CSS, JQuery

Microsoft .Net
Microsoft .Net

Mainly C# with ADO.Net but also exposure to VB.Net and ASP.Net

Crystal Reports
Crystal Reports

Versions 9 and XI

Microsoft Visual Basic
Microsoft Visual Basic

Versions 4 to 6 and VBA for Excel and Word 97 to 2010

SQL Server
Microsoft SQL Server

Database version 2008 - developed SQL Server Integration Services (SSIS)

Methodologies
Methodologies

Traditional Waterfall, Agile, UML and Prince

Source Control
Source Control

Visual Source Safe (VSS), PVCS, Serena Changeman


Experience

Global Energy Provider

Working with a small team of developers specialising in delivering APEX applications to support and enable business processes.

  • APEX 5 with Javascript, JQuery, AJAX, CSS, etc.
  • Extensive PL/SQL and database design to support the front end APEX application
  • Java and SAP integration
  • Private Financial Institution - City of London

    As lead developer for the full lifecycle of the Bank's flagship e-commerce project, I designed and developed the middleware Oracle database to interface with the Bank's legacy systems and a 3rd party front-end application. This large-scale, highly pressurised project ran for over 2 years and gave me exposure to a number of the advanced features and best practices of Oracle when building an OLTP/Operational Datastore such as:

  • Advanced PL/SQL (Use of BULK operations, analytic functions, Oracle Advanced Queues, XMLDB)
  • APEX with Javascript and AJAX
  • Materialized views
  • Oracle Messaging Gateway
  • Oracle Designer
  • Performance Tuning
  • 3rd Party Integration with IBM Websphere and Crystal Reports

  • Outside of this project I heavily utilised APEX and the Oracle Web Toolkit (mod_plsql) to create new and enhance existing internal applications that are key to the Bank's daily operations. The application suite was augmented with Microsoft technologies such as .Net (C#/VB/ADO), SQL Server, SSIS and VBA that I helped to develop.

    UK Border Agency (Security Cleared ) - London Suburbs

    Working amongst a large team of highly skilled developers, I enjoyed putting my Oracle skills into practice whilst constantly improving my Microsoft development knowledge. I was fortunate enough to work on both 2-tier and 3-tier architecture. This ranged from Visual Basic 6 applications that ran directly on top of Oracle databases to using ASP presentation layers, COM+ middle tiers and, again, Oracle database backends.

    Major UK Bank - City of London

    My introduction to the world of I.T came as a graduate trainee for this household named bank. Initially I found my way into development work through working with complex Excel macros and Visual Basic for Applications. This lead me to forge a role as an Oracle DBA/Developer role joining a team which shared the following responsibilities:

  • Oracle DBA tasks on 2 large databases, one an OLTP database with a Forms front end, and one a datawarehouse optimised for Business Objects reports
  • Provided bug fixes and enhancements to the batch processing which was developed in PL/SQL and ProC* and controlled via Cron jobs executing Shell scripts
  • Provide on-call support 24/7 x 365 for the databases and the overnight batch processing