$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Bernard Otesanya
,
Watford, United Kingdom
Experience
Other titles
Skills
I'm offering
Markets
United Kingdom
Language
English
Fluently
Ready for
My experience
2018 - ?
freelance
Oracle Developer
HMRC/RCDTS(Contractor).
Worked as part of the RCDTS (Revenue and Customs Digital Technology Services) on the Reval 2021 Project, to deliver software enhancements to support the re-evaluation of Business rates for Commercial properties
in the UK. Development Methodology was done with an Agile approach incorporating elements of Kanban.and daily Scrum meetings.
Enhancements were made to front end application using Oracle Forms 11g /Oracle reports 11g. Backend enhancements were made to Stored Database packages and API 's using pl/sql
Development environment Amazon Work Space (AWS) , Unix , windows 10 , Serena Dimensions
P
in the UK. Development Methodology was done with an Agile approach incorporating elements of Kanban.and daily Scrum meetings.
Enhancements were made to front end application using Oracle Forms 11g /Oracle reports 11g. Backend enhancements were made to Stored Database packages and API 's using pl/sql
Development environment Amazon Work Space (AWS) , Unix , windows 10 , Serena Dimensions
P
Kanban, Backend, Amazon, Software, Development, Support, Developer, Technology, Unix, Pl/sql, Sql, Windows, Agile, Database, Oracle, API, AWS, Scrum, Backend
2017 - 2018
job
Oracle Developer
Scottish And Southern Energy(SSE).
Developed the backend business processes and validation routines for the following projects
• Auto-Renewals - pl/sql data feed that identifies that electric/gas business customers coming up for renewal
And then issues an automatic quote that is costed according to business criteria
• Energy Commodity Trading and Monitoring Data - I developed an interim solution as part of a wider project
Validating data input ,concerning , tendering ,creation of contracts brokered by Data Providers
• Report Manager -Developed a generic Reporting application ,allowing users to define adhoc parameters,parameter types,report columns .Features included , security,Custom Report creation ,Report filtering and deletion.
The projects involved creating the supporting data structures , pl/sql database packages and incorporating the use of database object and Collections Types
• Auto-Renewals - pl/sql data feed that identifies that electric/gas business customers coming up for renewal
And then issues an automatic quote that is costed according to business criteria
• Energy Commodity Trading and Monitoring Data - I developed an interim solution as part of a wider project
Validating data input ,concerning , tendering ,creation of contracts brokered by Data Providers
• Report Manager -Developed a generic Reporting application ,allowing users to define adhoc parameters,parameter types,report columns .Features included , security,Custom Report creation ,Report filtering and deletion.
The projects involved creating the supporting data structures , pl/sql database packages and incorporating the use of database object and Collections Types
Monitoring, UP, Processes, Manager, Energy, Contracts, Backend, Energy, Interim, Sql, Contracts, Security, Developer, Pl/sql, Database, Oracle, Backend
2016 - 2017
job
Oracle Datawarehouse Developer
unknown.
Migrated data from disparate sources , INGRES database and user supplied spreadsheets in the FASTTRACK project, for Celesio/AAH into an Oracle datawarehouse. Created new dimension , fact ,lookup and staging tables. In addition developed PL/SQL ETL procedures embedded in Korn shell scripts to populate and push the Purchasing and Supplier data from the staging tables into partitioned fact/dimension tables.
Prepared and executed test scenarios using HP Application Lifecycle Management Software.
Assisted in Winguard Project for AAH Pharmaceuticals ,smoke tested ETL Functionality and wrote validation procedures
Prepared and executed test scenarios using HP Application Lifecycle Management Software.
Assisted in Winguard Project for AAH Pharmaceuticals ,smoke tested ETL Functionality and wrote validation procedures
Sql, Oracle, Database, ETL, Test, Management, Pl/sql, Embedded, Developer, Software
2016 - 2016
freelance
Oracle Fusion Middleware 12c Consultant
Red stack Tech.
Contractor)
Proof of concept project
Objective to prove that PRS Musics applications could be upgraded from an Oracle Forms 10g /Oracle Application Serverjj/Windows 8.1 environment to Oracle Forms 12c/Weblogic 12 /Windows 12 environment.
* Build 12c Forms and Reports
* Configuration of Weblogic12c, Forms Services and Reports Services on Windows 2012 Server virtual Machine
* Forms and reports infrastructure based on a Microsoft windows 2012 r2 environment
* 11gR2 database setup for Forms and reports repository and Testing
* determining certification requirements across a Windows Server environment v2012 R2
* migrating and testing forms and reports in a complex environment
Proof of concept project
Objective to prove that PRS Musics applications could be upgraded from an Oracle Forms 10g /Oracle Application Serverjj/Windows 8.1 environment to Oracle Forms 12c/Weblogic 12 /Windows 12 environment.
* Build 12c Forms and Reports
* Configuration of Weblogic12c, Forms Services and Reports Services on Windows 2012 Server virtual Machine
* Forms and reports infrastructure based on a Microsoft windows 2012 r2 environment
* 11gR2 database setup for Forms and reports repository and Testing
* determining certification requirements across a Windows Server environment v2012 R2
* migrating and testing forms and reports in a complex environment
Oracle, Database, Windows, Windows server, Infrastructure, Testing, Server, Weblogic, Middleware
2016 - 2016
freelance
Oracle Forms Developer
Saga plc.
(Contractor)
Developed screen enhancements in the Motor Insurance and Home Insurance functionality of TIA using Oracle Forms 11g and pl/sql.
Amended Pl/sql extracts sending XML datafiles to Thunderhead. which were then loaded up onto saga plc website
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
COMPANY: RM results(BATH)
Developed screen enhancements in the Motor Insurance and Home Insurance functionality of TIA using Oracle Forms 11g and pl/sql.
Amended Pl/sql extracts sending XML datafiles to Thunderhead. which were then loaded up onto saga plc website
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
COMPANY: RM results(BATH)
Sql, Oracle, XML, Pl/sql, Website, Unix, Developer, PLC, Development, Insurance, Weblogic, Middleware, UP
2015 - 2015
freelance
Oracle Forms Developer
unknown.
(Contractor)
Assisted in the Design ,code ,testing and Deployment of changes to Leap, a bespoke Qualification and Subject data import and transformation application, written in Oracle forms 11g and Reports 11g. The system also gets information from the Nation Pupil Database and the DFE. The changes included additional database Packages and schema objects to consolidate data validation and consistency checks of imported data
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
COMPANY: Sodexo Benefits and Rewards(Camberley)
Assisted in the Design ,code ,testing and Deployment of changes to Leap, a bespoke Qualification and Subject data import and transformation application, written in Oracle forms 11g and Reports 11g. The system also gets information from the Nation Pupil Database and the DFE. The changes included additional database Packages and schema objects to consolidate data validation and consistency checks of imported data
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
COMPANY: Sodexo Benefits and Rewards(Camberley)
Design, Sql, Oracle, Database, Pl/sql, Unix, Deployment, Developer, Transformation, Development, Testing, Weblogic, Middleware
2015 - 2015
freelance
Database Migration Analyst
unknown.
Contractor)
Documented and specified outbound and Inbound interfaces (files and tables)from PHOENIX a voucher and invoicing system developed in Oracle Powerbuilder to an external system using Microsoft NAVISION 2015. Liaised with third party to confirm data mapping requirements.
Assisted in enhancement of Sodexo Gift Card developing modules on Card Ordering , Invoicing ,Voucher Creation, Card Order Fulfilment, Payments using Pl/sql. Peer Tested Consumer and Corporate order journeys.Developed ad hoc MIS reports in Oracle pl/sq based on Sodexo Moneyboost (employee money management system)
Documented and specified outbound and Inbound interfaces (files and tables)from PHOENIX a voucher and invoicing system developed in Oracle Powerbuilder to an external system using Microsoft NAVISION 2015. Liaised with third party to confirm data mapping requirements.
Assisted in enhancement of Sodexo Gift Card developing modules on Card Ordering , Invoicing ,Voucher Creation, Card Order Fulfilment, Payments using Pl/sql. Peer Tested Consumer and Corporate order journeys.Developed ad hoc MIS reports in Oracle pl/sq based on Sodexo Moneyboost (employee money management system)
Sql, Oracle, Database, Management, Pl/sql, Navision, Analyst
2014 - 2014
freelance
Oracle Forms Consultant
Capgemini /Heathrow Airport Ltd.
(Contractor)
Amended the GRD(Group Retail Database) System using Oracle Forms 11g and Pl/sql. The enhancements included new screens to capture data and invoke reports for Sales &Income Budgets on a weekly/Monthly basis. In addition I developed new functionality in various existing modules ,with the aim of improving the accuracy of the Provisioning//Payments and Actuals process, for the 90 Concessionaires and over 300 Outlets covering Heathrow. Provided finer granularity in sales reporting by improving the method in which budget data was imported and exported into GRD.
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
Amended the GRD(Group Retail Database) System using Oracle Forms 11g and Pl/sql. The enhancements included new screens to capture data and invoke reports for Sales &Income Budgets on a weekly/Monthly basis. In addition I developed new functionality in various existing modules ,with the aim of improving the accuracy of the Provisioning//Payments and Actuals process, for the 90 Concessionaires and over 300 Outlets covering Heathrow. Provided finer granularity in sales reporting by improving the method in which budget data was imported and exported into GRD.
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g, Oracle Reports 11g,pl/sql, Unix Solaris, r2,Weblogic,OEM,Korn Shell scripts.
Sql, Oracle, Database, Retail, Budget, Sales, Pl/sql, Unix, Development, Weblogic, Middleware
2013 - 2014
freelance
Database Migration Consultant
unknown.
(Contractor)
Member of the migration team for Fujitsu Post Office Account, migrating data across partitioned tables from Oracle 10g to 11g and installing Oracle Goldengate as an ETL solution.
Analysis ,Design and production of Functional and Technical specifications detailing enhancements APOP/TESQA applications
Major enhancement of Oracle Forms 10g screen applications APOP/TESQA Workstations and coordination with users and stakehholders for UAT
Amended Pro*c progams to use updated libraries and recompiled
Development Environment: Oracle 11g,Oracle Goldengate, PL/SQL, Oracle Forms 10g,Reports 10g,,Korn Shell Scripts.
Member of the migration team for Fujitsu Post Office Account, migrating data across partitioned tables from Oracle 10g to 11g and installing Oracle Goldengate as an ETL solution.
Analysis ,Design and production of Functional and Technical specifications detailing enhancements APOP/TESQA applications
Major enhancement of Oracle Forms 10g screen applications APOP/TESQA Workstations and coordination with users and stakehholders for UAT
Amended Pro*c progams to use updated libraries and recompiled
Development Environment: Oracle 11g,Oracle Goldengate, PL/SQL, Oracle Forms 10g,Reports 10g,,Korn Shell Scripts.
Design, Sql, Oracle, Database, C, ETL, Pl/sql, Development, Office, Production
2012 - 2013
freelance
Oracle Forms Developer
unknown.
(Contractor)
Migrated Retail Finance application INPRO from Oracle Application Server 10g release to Oracle Fusion middleware11g, upgrading screens from Oracle Forms 10g to Oracle forms 11g. Configured forms and report services on dev, test and production environments using Weblogic scripting on Linux Servers. Configured Webutil to replace obsolete Fileuploader.
Worked on several projects PaybyFinance, Savvi, Motor Finance Plans and Monthly Releases, enhancing the Amadeus/INPRO screens using Oracle Forms 11g, database pl/sql packages interfacing with Supplier systems and creating oracle dbms scheduler jobs for overnight processing.
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g,pl/sql, Linux ,Oracle 11g RAC r2,Weblogic,OEM,Korn Shell scripts.
Migrated Retail Finance application INPRO from Oracle Application Server 10g release to Oracle Fusion middleware11g, upgrading screens from Oracle Forms 10g to Oracle forms 11g. Configured forms and report services on dev, test and production environments using Weblogic scripting on Linux Servers. Configured Webutil to replace obsolete Fileuploader.
Worked on several projects PaybyFinance, Savvi, Motor Finance Plans and Monthly Releases, enhancing the Amadeus/INPRO screens using Oracle Forms 11g, database pl/sql packages interfacing with Supplier systems and creating oracle dbms scheduler jobs for overnight processing.
Development Environment: Oracle Fusion Middleware 11g,Oracle Forms 11g,pl/sql, Linux ,Oracle 11g RAC r2,Weblogic,OEM,Korn Shell scripts.
Sql, Linux, Oracle, Database, Retail, Test, Pl/sql, Scripting, Finance, Developer, Development, Server, Weblogic, Middleware, Production, Processing
2012 - 2012
freelance
Oracle Developer
Metropolitan Housing Partnership.
Contractor)
Worked on various projects including ,Granta data migration Housing Project ;Rent Increase letters 2012;Housing Benefit Entitlement Awards. Performed general production support duties for in house system MWORLD.
Amended Oracle Forms 10g screens for MWORLD as part of a major enhancement project
Amended Oracle Discoverer reports within MWORLD enhancement project using Oracle E-Business Suite
Development Environment: WINDOWS NT, Microsoft Excel, UNIX, Oracle v11gRelease2 , Oracle Forms 11g, Oracle Reports 11g ,Oracle Discoverer, pl/sql ,sql, Oracle E-business Suite,Korn Shell scripts.
Worked on various projects including ,Granta data migration Housing Project ;Rent Increase letters 2012;Housing Benefit Entitlement Awards. Performed general production support duties for in house system MWORLD.
Amended Oracle Forms 10g screens for MWORLD as part of a major enhancement project
Amended Oracle Discoverer reports within MWORLD enhancement project using Oracle E-Business Suite
Development Environment: WINDOWS NT, Microsoft Excel, UNIX, Oracle v11gRelease2 , Oracle Forms 11g, Oracle Reports 11g ,Oracle Discoverer, pl/sql ,sql, Oracle E-business Suite,Korn Shell scripts.
Sql, Excel, Oracle, Windows, Pl/sql, Unix, Developer, Support, Development, Oracle E-Business Suite, Production
2011 - 2012
freelance
Oracle Developer
unknown.
Contractor)
Developed major enhancements to the KBC Home loans application using Oracle Forms 10g/Reports 10g in the 2nd phase of CCMA project (Code of Conduct for Mortgage Arrears) .Functional areas enhanced included, Debt Management, Income and Expenditure, Mortgage Reassignment, Property Assets and Non -Property Assets.
Responsible for the design and delivery of functional
Technical specifications from the Requirements Specification document for phase 2
Development Environment: WINDOWS NT, Microsoft Excel, UNIX, Oracle 11g release 2 , ORACLE forms 10g,
Oracle Reports 10g , pl/sql
Developed major enhancements to the KBC Home loans application using Oracle Forms 10g/Reports 10g in the 2nd phase of CCMA project (Code of Conduct for Mortgage Arrears) .Functional areas enhanced included, Debt Management, Income and Expenditure, Mortgage Reassignment, Property Assets and Non -Property Assets.
Responsible for the design and delivery of functional
Technical specifications from the Requirements Specification document for phase 2
Development Environment: WINDOWS NT, Microsoft Excel, UNIX, Oracle 11g release 2 , ORACLE forms 10g,
Oracle Reports 10g , pl/sql
Design, Sql, Excel, Oracle, Management, Windows, Pl/sql, Unix, Developer, Development
2010 - 2011
freelance
Oracle Developer
Northrumbrian Water.
(Contractor)
Assisted in the migration of NWLS' legacy character based Asset Management application ENGARDE. (Oracle forms 4.5, reports 2.5) to ENGARDE2 (Oracle forms 10gr2, Oracle reports 10gr2).
Analysed, sourced and amended over 40 reports to be converted
Designed and developed generic parameter driven reporting mechanism to be fully functional in ENGARDE2.
Assisted in the migration of NWLS' legacy character based Asset Management application ENGARDE. (Oracle forms 4.5, reports 2.5) to ENGARDE2 (Oracle forms 10gr2, Oracle reports 10gr2).
Analysed, sourced and amended over 40 reports to be converted
Designed and developed generic parameter driven reporting mechanism to be fully functional in ENGARDE2.
Oracle, Management, Developer, Asset Management
2008 - 2010
freelance
Oracle Developer
FirstAssist(Purley).
(Contractor)
Developed and delivered suite of new screens and reports to the Defence Solicitor Call Centre system using Oracle Forms9i/10g
Converted the Legal Services Commissions DSCC (Defence Solicitor Call Centre) system from Oracle Forms 9i to Oracle Forms 10g release2 to run against an Oracle 11g Database.
Upgraded and reconfigured application servers from Oracle Application Server 9.02 in a windows platform to Oracle Application Server 10g release 2 on a Linux platform. Over 100 modules were converted.
Development Environment:
Linux x86-84, Oracle Application Server 10g Release 2, Oracle v11.1.0.7,Headstart
VNC viewer,Oracle Forms 10g (10.1.23), Oracle Reports (10.1.23), winscp, sql developer, OEM
Developed and delivered suite of new screens and reports to the Defence Solicitor Call Centre system using Oracle Forms9i/10g
Converted the Legal Services Commissions DSCC (Defence Solicitor Call Centre) system from Oracle Forms 9i to Oracle Forms 10g release2 to run against an Oracle 11g Database.
Upgraded and reconfigured application servers from Oracle Application Server 9.02 in a windows platform to Oracle Application Server 10g release 2 on a Linux platform. Over 100 modules were converted.
Development Environment:
Linux x86-84, Oracle Application Server 10g Release 2, Oracle v11.1.0.7,Headstart
VNC viewer,Oracle Forms 10g (10.1.23), Oracle Reports (10.1.23), winscp, sql developer, OEM
Sql, Linux, Oracle, Database, Windows, Developer, Development, Server
2007 - 2008
freelance
Oracle Datawarehouse Developer
Enfield Informatics Systems/NHS.
and Barnet
Developed ETL processes to extract data from NHS patient administration system RIO to Oracle Datawarehouse using PL/SQL and SQL*LOADER and Unix Bash shell scripting
Developed Statutory RAP Assessment Reports (Social Care) using Oracle Discoverer and deployed via Oracle Portal.
Development Environment Windows NT, Microsoft Excel, Oracle 10g, Oracle Discoverer, Oracle Portal, Oracle BI Publisher, TOAD. Pl/Sql, BASH, RIO,DDL,DML.
Developed ETL processes to extract data from NHS patient administration system RIO to Oracle Datawarehouse using PL/SQL and SQL*LOADER and Unix Bash shell scripting
Developed Statutory RAP Assessment Reports (Social Care) using Oracle Discoverer and deployed via Oracle Portal.
Development Environment Windows NT, Microsoft Excel, Oracle 10g, Oracle Discoverer, Oracle Portal, Oracle BI Publisher, TOAD. Pl/Sql, BASH, RIO,DDL,DML.
Scripting, Social, Processes, Portal, Assessment, BEE, Development, Developer, Unix, Sql, Bash, Pl/sql, Windows, ETL, Oracle, Administration, Excel
2007 - 2007
freelance
Oracle Developer
NHBC.
(Contractor)
Developed enhancements to NHBC Fusion System Using Oracle forms/Reports 10g Release 2, Oracle 10g Database and pl/sql.
Supported various systems within Field Based Services Division covering Oracle mobile services, PDA and Fusion Warranty.
Resolved software bugs raised through helpdesk system
Development Environment: Windows NT, UNIX, Oracle Forms 10G, Oracle Reports 1OG, Toad, PL/SQL
Developed enhancements to NHBC Fusion System Using Oracle forms/Reports 10g Release 2, Oracle 10g Database and pl/sql.
Supported various systems within Field Based Services Division covering Oracle mobile services, PDA and Fusion Warranty.
Resolved software bugs raised through helpdesk system
Development Environment: Windows NT, UNIX, Oracle Forms 10G, Oracle Reports 1OG, Toad, PL/SQL
Sql, Oracle, Database, Windows, Pl/sql, Unix, Developer, Development, Software
2006 - 2007
freelance
Oracle Forms Developer
Sweet &Maxwell (Thomson Group).
(Contractor)
Migrated legacy Expert Witness System from Oracle Forms 4.5/Reports 2.5 to Oracle Forms 10g release2/Oracle Reports 10g Release 2
Analysis, Design and development of New screens for the migrated Expert Witness which included customer upgrade facility, transaction auditing, and developing PL/SQL interfaces for the screens to feed data to Sweet and Maxwell's Legal Hub , a web front end developed in XML.
Organised Design walkthroughs with end users, technical team and middle management.
Co-ordinated unit testing, regression testing and system testing with clients.
Migrated legacy Expert Witness System from Oracle Forms 4.5/Reports 2.5 to Oracle Forms 10g release2/Oracle Reports 10g Release 2
Analysis, Design and development of New screens for the migrated Expert Witness which included customer upgrade facility, transaction auditing, and developing PL/SQL interfaces for the screens to feed data to Sweet and Maxwell's Legal Hub , a web front end developed in XML.
Organised Design walkthroughs with end users, technical team and middle management.
Co-ordinated unit testing, regression testing and system testing with clients.
Design, Sql, Oracle, XML, Management, Pl/sql, Regression testing, Developer, Development, Testing, Web
2005 - 2006
freelance
Oracle Developer
EDS /Ministry Of Defence.
(Contractor)
Developed new screens for an Oracle based automated Army Supply Chain System (GLOBAL) using OracleForms 10g
Mainly involved in the analysis, design, specification and development of enhancements to screens and reports using Oracle Forms 10g/Reports10g
Development environment: Windows NT, UNIX, Oracle 10g , Oracle Forms 10g, Oracle Reports 10g, Toad, Oracle Pl/sql
Developed new screens for an Oracle based automated Army Supply Chain System (GLOBAL) using OracleForms 10g
Mainly involved in the analysis, design, specification and development of enhancements to screens and reports using Oracle Forms 10g/Reports10g
Development environment: Windows NT, UNIX, Oracle 10g , Oracle Forms 10g, Oracle Reports 10g, Toad, Oracle Pl/sql
Design, Sql, Oracle, Windows, Pl/sql, Unix, Developer, Development
2004 - 2005
freelance
Oracle Developer
Transport for London.
(Contractor)
Developed new screens for Oracle based applications BODS and OLIVER using Oracle Forms 10g /Reports 10g and PL/SQL. These applications are used to manage bus routes and schedule journeys
Migrated data into Oracle 10g from four legacy systems and developed software to cleanse data
Involved in all aspects of the project life cycle
Development environment: Windows NT, UNIX, Oracle10g, Oracle Forms 10g, Oracle Reports 10g, Toad, Oracle PL/SQL
COMPANY: Haringey Council - Social Services (London)
Developed new screens for Oracle based applications BODS and OLIVER using Oracle Forms 10g /Reports 10g and PL/SQL. These applications are used to manage bus routes and schedule journeys
Migrated data into Oracle 10g from four legacy systems and developed software to cleanse data
Involved in all aspects of the project life cycle
Development environment: Windows NT, UNIX, Oracle10g, Oracle Forms 10g, Oracle Reports 10g, Toad, Oracle PL/SQL
COMPANY: Haringey Council - Social Services (London)
Sql, Oracle, Windows, Pl/sql, Unix, Developer, Development, Software, Social
2003 - 2004
freelance
Oracle Developer
Social Services CLIENT.
(Contractor)
Developed 26 new run time reports on the Social Services CLIENT index reporting database using Oracle Reports. 9i
Amended existing reports and Front end screens using OracleForms 9i/Reports 9i and PL/SQL to take account of identified faults and changed requirements specification.
Developed 26 new run time reports on the Social Services CLIENT index reporting database using Oracle Reports. 9i
Amended existing reports and Front end screens using OracleForms 9i/Reports 9i and PL/SQL to take account of identified faults and changed requirements specification.
Sql, Oracle, Database, Pl/sql, Developer, Social
2003 - 2003
freelance
Oracle Developer
unknown.
(Contractor)
Developed and implemented major system critical enhancements to Insurance Claims Settlement system Portia
These enhancements centred on specification, design and development of screens/reports using Oracle Forms 9i on an Oracle 9i Database, new database packages and triggers
Fixed general software bugs raised through Helpdesk support for Property Insurance Modules.
Development environment: Windows NT, UNIX, ORACLE V9I, Oracle Forms 9i, Oracle Reports 9i, Toad, Pl/sql
limited experience of Oracle Products.
Developed and implemented major system critical enhancements to Insurance Claims Settlement system Portia
These enhancements centred on specification, design and development of screens/reports using Oracle Forms 9i on an Oracle 9i Database, new database packages and triggers
Fixed general software bugs raised through Helpdesk support for Property Insurance Modules.
Development environment: Windows NT, UNIX, ORACLE V9I, Oracle Forms 9i, Oracle Reports 9i, Toad, Pl/sql
limited experience of Oracle Products.
Design, Sql, Oracle, Database, Windows, Pl/sql, Unix, Developer, Support, Development, Software, Insurance
2002 - 2003
freelance
Oracle Developer
unknown.
Contractor)
Delivered on time a backlog of major enhancements to screens (Oracle forms 4.5/5) and reports (Oracle Reports 2.5) focussing on Re-insurance Run off environments
Upgraded over 600 modules from Oracle Forms 4.5/5 to Oracle Forms 6i and Oracle Reports 2.5/3 to Oracle Reports 6i.
Supported six in house Reinsurance/Insurance claims settlement systems developed in Oracle, resolving issues raised by users via helpdesk
COMPANY: Forensic Science Service (Birmingham)
Delivered on time a backlog of major enhancements to screens (Oracle forms 4.5/5) and reports (Oracle Reports 2.5) focussing on Re-insurance Run off environments
Upgraded over 600 modules from Oracle Forms 4.5/5 to Oracle Forms 6i and Oracle Reports 2.5/3 to Oracle Reports 6i.
Supported six in house Reinsurance/Insurance claims settlement systems developed in Oracle, resolving issues raised by users via helpdesk
COMPANY: Forensic Science Service (Birmingham)
Oracle, Service, Developer, Insurance, Science
2001 - 2002
freelance
Analyst/Programmer (Contractor)
unknown.
Converted Microsoft Access based Exhibit Management System (EMS) into Oracle Database 8i and redeveloped screens and reports using Oracle Forms 6/6i ,Oracle Reports 6/6i, and PL/SQL as part of the FSS Quick Wins Programme.
Developed software to migrate data from Access database (EMS) to Oracle Database (EMS)
Developed major enhancements to Work Management System (WMS) using Forms 4.5/Reports 2.5 on Oracle 8i on UNIX through Citrix Metaframe.
Developed software to migrate data from Access database (EMS) to Oracle Database (EMS)
Developed major enhancements to Work Management System (WMS) using Forms 4.5/Reports 2.5 on Oracle 8i on UNIX through Citrix Metaframe.
Sql, Oracle, Database, Oracle database, Management, Pl/sql, Unix, Analyst, Citrix, Software, Wms, EMS
2000 - 2001
freelance
Analyst/Programmer (Contractor)
unknown.
Developed data migration software for SEPERATION project between Cable & Wireless customers from NTL customers and pricing tariffs. Using PRO*C.
Supported legacy system POS (provisioning of Service) enhancing screens written in Oracle Forms 6i.
Supported legacy system POS (provisioning of Service) enhancing screens written in Oracle Forms 6i.
Oracle, C, Service, Analyst, Pos, Wireless, Software
1999 - 2000
freelance
Analyst/Programmer (Contractor)
International Export Operations/Ford Dagenham/Logica.
Developed software modules for OUTTURNS SYSTEM using Oracle FORMS v6i, Reports v6i and PL/SQL. Involved throughout full system life cycle, from writing specifications to testing and implementation of software.
Supported MIGS system by fixing generic bugs raised by end users via helpdesk
Supported MIGS system by fixing generic bugs raised by end users via helpdesk
Sql, Writing, Oracle, Pl/sql, Analyst, Implementation, Testing, Software
1997 - 1999
freelance
Analyst/Programmer (Contractor)
unknown.
Developed key areas of ESF (European Social Fund) Database System using Oracle Forms v3/v4.5 and Report writer, Oracle PL/SQL on Oracle v7 using a SCO-UNIX platform in a Windows 95 environment
Other duties included impact analysis, requirements specification, and development of new software, software amendment, testing, and documentation.
Other duties included impact analysis, requirements specification, and development of new software, software amendment, testing, and documentation.
Sql, Oracle, Database, Windows, Pl/sql, Unix, Analyst, Development, Testing, Software, Social
1997 - 1997
freelance
Analyst/Programmer (Contractor)
Cable & Wireless.
Working as part of the Corporate Provisioning system team, developed screens/reports using Forms v3/4.5 and sqlreportwriter v1.1, pl/sql , stored procedures, triggers and functions on VAX/VMS and UNIX platforms using Oracle v7 Database.
Sql, Oracle, Database, Pl/sql, Unix, Analyst, Stored procedures
1996 - 1997
freelance
Analyst/Programmer (Contractor)
Caradon Everest plc.
Developed Cash Control functionality to enable the monitoring of payments made against customer purchase agreements using SQL FORMS v3, on an Oracle v7 Platform
Developed Cash screens to track reconciliation of payments of different methods (i.e. Credit Card, Debit Card, Cash etc.) using SQL FORMS v3, on an Oracle v7 Platform
Developed application to calculate BACS processing dates for payments on an annual basis
Developed Cash screens to track reconciliation of payments of different methods (i.e. Credit Card, Debit Card, Cash etc.) using SQL FORMS v3, on an Oracle v7 Platform
Developed application to calculate BACS processing dates for payments on an annual basis
Sql, Oracle, Analyst, Monitoring, Processing
1996 - 1996
freelance
Analyst/Programmer (Contractor)
unknown.
Maintained and enhanced the ITS TRACKING Database System, which tracks the movement of components units introduced for repairs at the central repair centre for Europe.
Developed front end screens and reports using FORMS V3/4.5,PL\SQL ,sql*report writer on Oracle v7 database.
Developed front end screens and reports using FORMS V3/4.5,PL\SQL ,sql*report writer on Oracle v7 database.
Sql, Oracle, Database, Analyst
1991 - 1996
job
Systems Engineer (Permanent)
Perot systems Europe LTD.
Developer working on the Greenfield project GREENWAY for EUROPCAR.
Main duties centred on the support, development and enhancement of the Fleet Management , vehicle leasing functionality, software implementation, documentation and configuration
Development environment: SQL Forms v3, PRO*C, UNIX,
Main duties centred on the support, development and enhancement of the Fleet Management , vehicle leasing functionality, software implementation, documentation and configuration
Development environment: SQL Forms v3, PRO*C, UNIX,
Sql, C, Management, Unix, Developer, Support, Implementation, Development, Software
My education
University of Westminster
BSc, Computing
BSc, Computing
Bernard's reviews
Bernard has not received any reviews on Worksome.
Contact Bernard Otesanya
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Bernard directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark