Scott Hillier Email & Phone Number

Cwmbran, Gb

Cwmbran, Gb

Home Based

United Kingdom

Security Cleared Oracle Developer at Frontera (now Accelalpha)

Cheltenham

Senior Oracle Developer in Cheltenham.EBS 12.1.2, Supply Chain, WMS.Custom Forms, BI Publisher.Apex 5, ODI, OBIAPL/SQL

Bristol / Cheltenham

Oracle Development on Agile Project.PL/SQLJiraJenkinsGerritRuby-spec pl/sql

Gloucester, United Kingdom

Lead Development Consultant on a high profile project for a large defense client in Cheltenham. Full project life cycle from requirement gathering through design and build, both functional and technical, of Oracle EBS Supply Chain12.1.2 and subsequent 12.1.3. Full customer database migration using EBS APIs from Dataflex database to EBS. Associated reporting using BI Publisher.Skills Used:SQLPL/SQLOracle 11gOracle EBusiness Suite - Supply Chain 12.1.2, 12.1.3Web Forms 10gBi PublisherSQL Developer

Isle Of Man, United Kingdom

Maintenance and development of Insurance & Finance Forms system with Apex and Web Reports reporting. PL/SQL back end coding. Working remotely from Bristol with quarterly appointments at Isle Of Man head office.Skills Used : SQLPL/SQLOracle 11gApplication Server 10gWeb Forms 10gWeb Reports 10gPLSQL DeveloperApex 3.2Toad

Newport, United Kingdom

Design and build of CRM Oracle Apex system.Maintenance and development of DII Oracle Forms and Reports systemwith backend PL/SQL coding. Migration and upgrade project movingStarteam 2005 on Oracle 8 to Starteam 2008 on SQLServer 2005.Restoration of Oracle E-Business 11.5.9 system to a fully working state.Skills Used:SQLPL/SQLOracle 11gApplication Server 10gWeb Forms 10gWeb Reports 10gPLSQL DeveloperApex 3.2SQL Server 2005Starteam R2Oracle EBusiness Suite 11.5.9

Basingstoke

Part of the Oracle development team, working on the TIA (The InsuranceApplication) System. Day to day PL/SQL, Forms and Reports developmenton the TIA System.Skills Used:TIASQLPL/SQLOracle 11gApplication Server 10gWeb Forms 11gWeb Reports 11gPLSQL DeveloperTOAD

Newport, United Kingdom

Solely responsible for design, build and maintenance of several Web based Oracle systems. Complete design and build of Recruitment, Actions DB, GATE, Non Conformance Reporting and Offsite Equipment DB databases with associated front end web forms and reporting systems. Maintenance and enhancement of DII, F&P, Cormorant OR and Assets database and associated front end web forms & reporting systems. Day to day maintenance, performance tuning, upgrades and bug fixes. User creation etc. Offsite customer liaising and requirement capturing for module enhancement.Discoverer End User Layer and Report building.Skills Used:SQLPL/SQLOracle 11gApplication Server 9i, 10g,Web Forms 10gWeb Reports 10g PLSQL DeveloperDesigner 10gDiscoverer 10gTOAD

Farnborough, United Kingdom

1 of the 2 senior Database developers on the defence SCOPE Project.Responsible for code design, build and test of database modules for interaction with App Server team code. Code reviews. Mentoring of graduate developers.Skills Used:PL/SQLOracle 10gClearcasePL/SQL Developer

Newport, United Kingdom

Solely responsible for design, build and maintenance of several Web based Oracle systems. Complete design and build of Recruitment, Actions DB, GATE, Non Conformance Reporting and Offsite Equipment DB databases with associated front end web forms and reporting systems. Maintenance and enhancement of DII, F&P, Cormorant OR and Assets database and associated front end web forms & reporting systems. Day to day maintenance, performance tuning, upgrades and bug fixes. User creation etc. Offsite customer liaising and requirement capturing for module enhancement.Discoverer End User Layer and Report building.Skills Used:SQLPL/SQLOracle 11gApplication Server 9i, 10g,Web Forms 10gWeb Reports 10g PLSQL DeveloperDesigner 10gDiscoverer 10gTOAD

Cardiff, United Kingdom

Solely responsible for development of Midstream Insurance Policy Payment Protection system. Including Forms, Reports and database design, development, testing and performance tuning.Full life cycle solo project, liaising with onsite managers and future end users to design, build, test and implement a system for a team of 30+ phone operators to use in the selling of payment protection insurance.Skills Used:PL/SQLOracle 9iApplication Server 9iASForms 9iReports 9iTOAD

Cheltenham, United Kingdom

Working on migrating bespoke HOF upgrades from 11.5.1 to 11.5.5 on the FA, PO, GL and AP Oracle Financials systems. Including Forms, Reports and database development and testing. Discoverer Administration and user development. Full life cycle of Recognition loyalty card system. From design through to implementation of object oriented encapsulated product.Migration of data. Data passing using XML.Working on EDI system. Creating and modifying existing Oracle reports, forms and PL/SQL code. Discoverer End User Layer and Reports maintenance.Skills Used:SQLPL/SQLOracle EBusiness Suite Financials 11i, v.11.5.1, 11.5.6 (FA, PO, AP, GL)Discoverer 4iForms 6i, 9iReports 6iOracle 9iASXML

United Kingdom

Oracle E-Business Suite (Assets, HR), Forms, Reports, EDI developer.

Bristol, United Kingdom

Forms, Reports and database development and support as part of a 10 man team developing both the Submarine and Surface Ship support products. Solely responsible for development, testing and implementation of new SPAR data analysis product. Including design and creation of test system to include detail of unit and integration test plans, runs and results. Performance tuning and maintenance.Skills Used:SQLPL/SQLOracle 8iForms 6iReports 6iDesigner 2.1

Bristol, United Kingdom

Responsible for managing Building Control development team, ranging in size from 2 to 8 people. Creation of BC system from design stage through to current stage of build, including testing, development and implementation. Design and development of Forms, Libraries, Object Libraries, Menus, Packages, Tables, Triggers, Constraints. OLE automation.Interaction between Forms and Microsoft Word, VB, G.I.S.Solely responsible for development, testing and implementation of new Planning Appeals product. Development of Module test and review system.Used for reviewing functionality of modules and cross linking with testing. Testing to include module testing, system testing, integration testing. Result storage and retest detail. Performance tuning based on performance test results. Interviewing potential new employees, yearly reviews, team motivation, project planning across all BC projects. Attending user group meetings. Bug fix and Requirement capture discussions with local government managers.Skills Used:SQLPL/SQLOracle 7.3Forms 5Reports 3Designer 2.1

Bristol, United Kingdom

Part of the 8-strong Insurance Policy Management Engine development team. Creation of database packages, forms and reports building, testing and design with associated business document writing.Skills Used:SQLPL/SQLOracle 7.1Forms 4.5Reports 2.5Designer 1.3

Warrington, United Kingdom

Forms development of pavement management system and road lighting system. Testing and investigating bugs in code written by contractors.Solely responsible for the companies reports requirements, including designing and developing reports and tuition of development team on Reports 2.5Skills Used:SQLPL/SQLOracle 7.1Forms 4.5Reports 2.5Designer 1.3

Bachelor’S Degree, Computer Science, First Class With Honors

BSc Computing

Higher National Diploma (Hnd), Computer Science, Successfully Completed

H.N.D. Computer Studies

Btec National Diploma, Computer Science, Successfully Completed

National Diploma in Computer Studies