Shane O'Neill

Development of Back Office applications used to administer client share movements in the context of the purchase of stock market shares. Application software used includes Oracle 12c, Oracle Apex 5.1, Oracle SQL, PL SQL, and Unix Shell Scripts. Investigate application development issues and develop code fixes. Manage and configure software releases using Perforce P4V.

Duties include: the development/configuration of Actimize AML solutions and ETL processes for Compliance / Financial Crime IT projects that utilize Actimize products in the Wealth Business, and co-ordination with different support teams for QA and production releases

Senior Oracle Analyst/Developer working on the development of Dental Insurance systems, (using Oracle SQL; PL/SQL stored procedures; PL/SQL triggers; Unix shell scripts; Redwood’s Explorer/Cronacle job scheduling application) .Investigate application development issues and develop code fixes. Liaise with the business to be able to get exact requirements for development and code changes needed. Manage and configure software releases using PVCS and PVCS Tracker.

Senior Oracle Analyst/Developer on the development of an AML (Anti-Money Laundering) project, using Oracle SQL Developer and Unix shell scripts. Working on the design, development and strategy of the project. My involvement consisted of the creation of an Oracle PL/SQL Package to generate a data feed from the Retail System to allow the flow of new transactional and personal data to a third party system.

Develop PL/SQL financial service and Treasury systems code, in order to deliver high quality, fit for purpose, Oracle database solutions to business requirements, in a cost effective and efficient manner. Tools used include Oracle 11G; Oracle Reports 6; Oracle Forms 6.Contribute to/participate in/perform the following over the lifecycle of an I.T. finance project:

Develop PL/SQL code and Oracle Forms, investigate faults in the IT system and code fixes for them and liaise with the business to be able to get exact requirements for development and code changes needed. To work independently on changes and faults and also as part of a team as a whole.

Design, build and maintain ETL applications using Informatica v7 with Oracle 11G SQL, PL SQL and Unix Shell scripting. Using the whole Informatica Powersuite application tools, to development new applications, or to investigate application failures within the Control-M batch schedule, and the various environments, Test and Live.

Design, Testing and Support of Life&Pensions AMARTA FS software - a series of business services for Acquisition, Policy Administration, Claims, Premium Collection/Allocation, and Internal Accounting. Additional Duties included: development of Test Plans/Test Data/Data loading scripts; Walkthrough/demonstration of released modules to Client; Helpdesk application support.

Support an Oracle Database (ver 8i) used to administer client share movements in the context of the purchase or sale of stock market shares. Duties include the creation of SQL scripts/Unix Shell scripts into the Autosys batch schedule for new process functionality, Investigation and resolution of DBA database maintenance issues, including space management and performance issues. Performance Tuning of SQL scripts. Maintenance/creation of database triggers

Supporting Oracle Databases (ver 7.2) used to administer domestic electricity meter readings and calculate consumption values. Duties included the investigation of data flow failures and correction/update of records using SQL scripts. Create solutions for the resolution of data flow failures, using SQL scripts/ Oracle Forms.

Development of a Y2K compliant Oracle Database to replace an older system as well as some general support. The database was comprised of student financial information. Main duties consisted of the conversion of RPT Reports to SQL Reports using Oracle Reports 3, as well as creating Oracle Forms.

Supporting an Oracle Database v7.2 used to administer Group Pensions products. Support of a variety of pension systems, with Access/Visual Basic/Clipper/DataEase i.e. amendments to pension renewal calculations. Development of Microsoft Access databases for Company Departments.

Development of various stock control batch COBOL programs using embedded SQL.