$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Oracle Developer with over 20+ years experience
Shaun Kinnair
,
Connahs Quay, United Kingdom
Experience
Other titles
Skills
I'm offering
Self-starting highly proficient Oracle Analyst/Developer with 22 year’s experience of ORACLE databases from versions 6 through to 12c working in all areas of the software development life cycle, under pressured project deadlines for large blue chip and small clients within different areas of the business.
As a team member I communicate an energetic and enthusiastic approach to many situations, which promotes a friendly outgoing environment for others. I have shown myself to be reliable, versatile, effective and confident. I believe my honest hard working philosophy combined with a motivation and adaptability to learn new skills helps me to achieve my personal and professional goals.
As a team member I communicate an energetic and enthusiastic approach to many situations, which promotes a friendly outgoing environment for others. I have shown myself to be reliable, versatile, effective and confident. I believe my honest hard working philosophy combined with a motivation and adaptability to learn new skills helps me to achieve my personal and professional goals.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2015 - 2020
freelance
Oracle Analyst/Developer
PRS for Music.
• Analysing, designing and developing New Oracle Forms/Reports application that would be used by business users to answer customer queries relating to royalties, statements and billing.
• Develop PL/SQL packages to process incoming data files into a meaningful form to enable business users to query the data on the front end application..
• Create/Modify database objects to enable better performance of existing/new data processing.
• Test work completed using unit test plans, documenting tests before moving code forward to the system test environment.
• To follow company coding standards, create re-usable PL/SQL code that can be used again in other programs.
• Create Functional/Technical documentation outlining requirements, version control all programs and documentation.
• Develop PL/SQL packages to process incoming data files into a meaningful form to enable business users to query the data on the front end application..
• Create/Modify database objects to enable better performance of existing/new data processing.
• Test work completed using unit test plans, documenting tests before moving code forward to the system test environment.
• To follow company coding standards, create re-usable PL/SQL code that can be used again in other programs.
• Create Functional/Technical documentation outlining requirements, version control all programs and documentation.
Oracle database, Oracle sql, Oracle PL/SQL, Oracle Database development, Oracle Report builder, Oracle, TOAD, Visual studio code, Sql xml, SharePoint, Visio, Windows, Word, Excel, MS office, Microsoft office, Microsoft Word, Microsoft outlook, Microsoft excel, Microsoft Teams, VDI
2013 - 2014
freelance
Oracle Analyst/Developer
The Coventry Bank.
• Analysing, designing and developing a new Oracle PL/SQL Banking Liquidity program that would produce statistical reports against retail deposit accounts.
• Being responsible in helping the business users come up with a solution to develop a program that would show the retail deposit outflows and liquidity position of the bank (daily and month end) which would fulfil and comply with the new banking regulations outlined by the European Banking Authority (EBA).
• Create historical reports that would show customer behaviour in times of stress (2008 banking crash) and forecast customer behaviour on certain retail banking products in the future.
• Create packages, procedures, functions, indexes, tables to assist in processing customer accounts data and produce a number of reports highlighting probable high risk and low risk customer accounts (current, savings and ISA accounts).
• Performance tune PL/SQL and SQL using DBMS Profiler/Explain Plan.
• Test work completed using unit test plans before moving code forward to the system test environment.
• To follow company coding standards, create re-usable PL/SQL code that can be used again in other programs.
• Create Functional/Technical documentation outlining requirements, version control all programs and documentation.
• Being responsible in helping the business users come up with a solution to develop a program that would show the retail deposit outflows and liquidity position of the bank (daily and month end) which would fulfil and comply with the new banking regulations outlined by the European Banking Authority (EBA).
• Create historical reports that would show customer behaviour in times of stress (2008 banking crash) and forecast customer behaviour on certain retail banking products in the future.
• Create packages, procedures, functions, indexes, tables to assist in processing customer accounts data and produce a number of reports highlighting probable high risk and low risk customer accounts (current, savings and ISA accounts).
• Performance tune PL/SQL and SQL using DBMS Profiler/Explain Plan.
• Test work completed using unit test plans before moving code forward to the system test environment.
• To follow company coding standards, create re-usable PL/SQL code that can be used again in other programs.
• Create Functional/Technical documentation outlining requirements, version control all programs and documentation.
Oracle, Oracle database, Oracle sql, Oracle PL/SQL, Oracle Database development, Word, Excel, Microsoft Word, Microsoft office, TOAD
2013 - 2013
freelance
Oracle Developer
Engage Mutual.
• To help in the completion of a project and develop front end Oracle Forms/Reports user interfaces and back end PL/SQL application programs from technical specifications.
• Create packages, procedures, functions, triggers to assist in processing/validating financial data and to audit any data changes into history tables.
• Investigate and then solve problems with existing PL/SQL programs and Oracle Forms.
• Performance tune existing PL/SQL and SQL.
• Test work completed using unit test plans before moving code forward to the system test environment.
• To follow company coding standards and to create re-usable PL/SQL code when possible
• Create packages, procedures, functions, triggers to assist in processing/validating financial data and to audit any data changes into history tables.
• Investigate and then solve problems with existing PL/SQL programs and Oracle Forms.
• Performance tune existing PL/SQL and SQL.
• Test work completed using unit test plans before moving code forward to the system test environment.
• To follow company coding standards and to create re-usable PL/SQL code when possible
Oracle database, Oracle sql, Oracle PL/SQL, Oracle, Oracle forms, Oracle reports, Windows, TOAD
2011 - 2013
freelance
Oracle developer
Admin Re UK.
• Build PL/SQL programs from Analyst user requirements that would migrate new acquired financial policy data into the existing Oracle database. Using PL/SQL bulk processing techniques (i.e. Bulk Collect).
• Create packages, procedures, functions, triggers, tables and views to assist in migrating financial data and audit changes to that data.
• Create database holding tables to assist in the migration of financial data from flat files.
• Creating PL/SQL programs that would assist help-desk users to fix corrupt migrated data that had not been fully migrated in the past.
• To clear the back log of help desk incidents with life insurance/pension data that had been a problem in past migrations.
• Supporting/Investigate bugs/problems with existing PL/SQL programs.
• First line testing PL/SQL, SQL programs that have been put forward to go live.
• Performance tune existing PL/SQL and SQL.
• To follow coding standards and to create re-usable PL/SQL code when possible.
• Create user documentation (dummies guide) on newly created PL/SQL, SQL programs for help-desk users.
• Create packages, procedures, functions, triggers, tables and views to assist in migrating financial data and audit changes to that data.
• Create database holding tables to assist in the migration of financial data from flat files.
• Creating PL/SQL programs that would assist help-desk users to fix corrupt migrated data that had not been fully migrated in the past.
• To clear the back log of help desk incidents with life insurance/pension data that had been a problem in past migrations.
• Supporting/Investigate bugs/problems with existing PL/SQL programs.
• First line testing PL/SQL, SQL programs that have been put forward to go live.
• Performance tune existing PL/SQL and SQL.
• To follow coding standards and to create re-usable PL/SQL code when possible.
• Create user documentation (dummies guide) on newly created PL/SQL, SQL programs for help-desk users.
Oracle, Oracle database, Oracle PL/SQL, Oracle sql, TOAD, Excel, Microsoft Word, Microsoft excel, Microsoft office, MS office, Outlook, Microsoft outlook
2004 - 2011
freelance
Oracle Developer
Scottish Government.
• Analysing and gathering user requirements by liaising with customers, technical staff and managers. Creating both functional/technical specifications from information gathered.
• Designing/developing front end Oracle forms/reports user interfaces and back end PL/SQL application programs from functional/technical specifications given by business analysis or created by myself.
• Building new PL/SQL & SQL*Loader data batch processing scripts to load, process and validate data, creating management/user reports from the results of the process.
• Upgrade/Migrate Oracle forms and Oracle reports to later versions in both client/server and internet applications (upgrading Oracle forms 6i to 9i/10g, Oracle reports 6i to 9i/10g).
• Creating database tables, views, indexes, packages, procedures, functions, constraints, sequences.
• Creating Generic Oracle Templates 10g Forms/PLL/Object libraries to improve developer performance in building new Oracle applications. Introducing business coding and design standards for future developers within Scottish government to adhere to.
• Investigate/solve performance issues by tuning PL/SQL batch programs, SQL, Oracle forms/reports and application code.
• Supporting/Investigate bugs/problem solve existing business applications through help desk calls, new work requests and change requests that are created by users, analysis, managers and DBA’s.
• Test applications and programs created, creating test plans/documentation, release notes and peer reviewing other developers code for quality assurance.
• After testing moving code forward to system testers, user acceptance testers and finally releasing code to the production environment using version control software.
• All documentation created in the development process would be saved to an EDM system for future reference.
• Designing/developing front end Oracle forms/reports user interfaces and back end PL/SQL application programs from functional/technical specifications given by business analysis or created by myself.
• Building new PL/SQL & SQL*Loader data batch processing scripts to load, process and validate data, creating management/user reports from the results of the process.
• Upgrade/Migrate Oracle forms and Oracle reports to later versions in both client/server and internet applications (upgrading Oracle forms 6i to 9i/10g, Oracle reports 6i to 9i/10g).
• Creating database tables, views, indexes, packages, procedures, functions, constraints, sequences.
• Creating Generic Oracle Templates 10g Forms/PLL/Object libraries to improve developer performance in building new Oracle applications. Introducing business coding and design standards for future developers within Scottish government to adhere to.
• Investigate/solve performance issues by tuning PL/SQL batch programs, SQL, Oracle forms/reports and application code.
• Supporting/Investigate bugs/problem solve existing business applications through help desk calls, new work requests and change requests that are created by users, analysis, managers and DBA’s.
• Test applications and programs created, creating test plans/documentation, release notes and peer reviewing other developers code for quality assurance.
• After testing moving code forward to system testers, user acceptance testers and finally releasing code to the production environment using version control software.
• All documentation created in the development process would be saved to an EDM system for future reference.
Sql, Microsoft office, Microsoft outlook, Microsoft excel, Microsoft Word, Excel, MS office, Word, TOAD, Oracle, Oracle Database development, MICROSOFT SQL SERVER DATABASE DEVELOPMENT, Oracle Report builder, Oracle forms, Pl/sql, Oracle PL/SQL, Oracle sql, Oracle database
My education
1998
-
2005
Chester University
Post-Grad Certificate, Professional and Personal Development
Post-Grad Certificate, Professional and Personal Development
1994
-
1995
Huddersfield University
BSc (Hons), Computer Science
BSc (Hons), Computer Science
1992
-
1994
Wrexham University
HND, Business Computing
HND, Business Computing
Shaun's reviews
Shaun has not received any reviews on Worksome.
Contact Shaun Kinnair
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Shaun directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark