Oracle Developer

KEVIN O’NEIL DAVIS

Apt *, *** Chemin Vanier, QC J9J 2A3• C: 647-***-**** • *****.**.*****@*****.***

• www.linkedin.com/in/kevin-davis-133b641/

PROFESSIONAL PROFILE

IT professional with extensive experience in Oracle technology and strengths in PL/SQL and SQL development, GUI development utilizing Oracle Application Express, Oracle Forms and Reports. Experienced in design, development and implementation of solutions to solve complex challenges. Worked in a range of industries including education, HR, education, energy, shipping and manufacturing. Possess excellent writing, research and problem- solving skills in both functional and technical areas, demonstrated through the delivery of various projects as part of development teams, on solo and remote projects. PROGRAMMING EXPERIENCE / EMPLOYMENT HISTORY

ESDC Mar. 2020 – Present

PLSQL Developer

• Development of packages and queries in support of project testing Technology – Oracle, PLSQL, Toad, SQL Developer

University of Toronto School of Continuing Studies Sep. 2019 – Dec. 2019 Full Stack Development Bootcamp Student

• Enrolled in three month-long bootcamp for Full Stack Development, maintained grade average of A Technology – mySQL, MongoDB, HTML, CSS, React, Bootstrap, JQuery Body of Work - https://github.com/kevin-on-davis

Humber College Aug. 2018 – June 2019

Data Migration Consultant

• Converted multiple single day transactions to single duration based records using T-SQL procedure.

• Identified data issues requiring review and correction by the HR Department.

• Implemented corrective protocol to correct issues with contact addresses using imported Canada Post postal codes data.

• Analyzed data load errors and carried out resolution tasks

• Performed System Integration testing of HCM modules

• Determined and facilitated manual post-conversion activities

• Created and maintained techno-functional documentation for all conversion scripts

• Created scripts and ad-hoc queries for verification exercises Technical Environment – SQL Server, SQL, T-SQL, Informatica, Oracle HCM Cloud LINQUED INC. Jan. 2017 – July 2018

Consultant – APEX Development

• Managed project to replace outdated shipping application

• Created software solution to replace 20-year old custom legacy shipping application originally developed using Microsoft Access for a mid-sized Canadian shipping company.

Designed Apex interface to merge functionality handled by multiple screens in legacy application into single streamlined page reducing data entry time by approximately 40% and user input error by approximately 60%

Designed User Interface components in consultation with client SME for conversion of manual logistic Kevin O'Neil Davis Page 2 of 5

process using Excel and handwritten sheets to electronic workflow improving efficiency and reducing turnaround time from 2-3 days to approximately 2 hours

Created database framework for new application including database triggers and packages to organize, process and normalize data required for customer transaction data and logistic workflow.

Designed and implemented new functionality to create complete end-to-end logistic process flow for capture, tracking and routing of transactions from initial phone call to generation of shipping manifest.

Identified gaps in requirements provided and collaboratively determined appropriate solutions.

Conducted research and evaluation of software best suited to meet customer needs.

Provided training to employees

Installed, upgraded and configured Oracle Apex software on Windows server.

Extracted data from legacy system, normalized and loaded data to new database. Technical Environment – Oracle Database Express 11g, Oracle Application Express (APEX) 5.1, PL/SQL, AS_PDF3 (PL/SQL report scripting package), Windows Server TECHKNOWSOFT INC. Jan 2018- Mar. 2018

Consultant(contract) – APEX Developer

• Modified/extended Apex functionality for Government of Yukon in-house software in order to provide budgetary information to Public Works Department.

• Created reports using Jasper Reports

Technical Environment – Oracle Database, Oracle Application Express (APEX) 4.2, PL/SQL, Jasper Reports, JIRA

PEEL DISTRICT SCHOOL BOARD Oct. 2017

Applications Developer (I month contract)

• Developed forms and reports using Oracle Forms and Oracle Reports for Student Management application Technical Environment – Oracle Database, Oracle Forms, Oracle Reports, PL/SQL FUJITSU CONSULTING Nov 2011 – Jun 2017

Senior Technical Consultant (Full time)

• Provided daily and on-call support for 24x7 user applications for electricity trading system

• Developed and maintained Oracle Forms and PL/SQL code.

• Developed and maintained migration and ETL scripts using SQL*Plus, PL/SQL, TOAD, SQL*Loader

• Developed and supported SAP BODS ETLs for movement of data between systems managed by Revenue, Metering and Settlement Systems Support department

flat files to Oracle tables

SQL Server to Oracle

between different of Oracle database versions

• Managed BODS ETL jobs via management console:

scheduling and rerunning failed jobs

root cause analysis of failures

performance tuning of jobs

• Investigated and evaluated Oracle Application Express (APEX) for introduction of new technology to company portfolio.

• Performed performance tuning of SQL and PL/SQL code at application and database levels

• Interfaced with business units to for troubleshooting, identification and resolution of issues with application and database environment

Technical Environment – Oracle Exadata, Oracle 8i – Oracle 12c, Oracle Forms, Toad, PL/SQL, SQL Plus, PVCS, Business Objects Data Services (BODS), SQL Server, T-SQL, Unix, Oracle Apex 5.1 FUJITSU Sep 2010 – Nov 2011

Kevin O'Neil Davis Page 3 of 5

Consulting QA Tester / PL/SQL Developer (Contract)

• Reviewed code and performed unit and integration testing of PL/SQL packages, procedures and functions

• Executed test cases and creation of test scripts

• Created SQL and PL/SQL migration and application scripts Technical Environment- Oracle 8i, Oracle 10g, Oracle 11g, Oracle Forms, Toad, PL/SQL, SQL Plus, PVCS, Unix IMEX SYSTEMS Sep 2009 – Aug 2010

Oracle Developer (Contract)

• Reviewed initial conversion of Oracle forms by offshore development team for automotive manufacturer based in USA.

• Updated converted forms to resolve user and technical issues arising from de-supported features. Technical Environment – Oracle 10G Developer Suite, PL/SQL, SQL Navigator, Oracle Application Server, Oracle Designer, BugZilla Issue Tracking

MINISTRY OF GOVERNMENT & CONSUMER SERVICES 2007 – 2009 Oracle Reports Developer (Contract)

• Developed PL/SQL code, Oracle Reports and database objects for Cabinet Submission application. Technical Environment – Developer 9i/10g: Reports, PL/SQL, Toad, UNIX, Rational Software Suite, Java, Websphere, XML, Oracle Application Server, CSS, JSP, XML MERCER HUMAN RESOURCE CONSULTING 2006 – 2007

Oracle Developer (Contract)

• Modified Oracle Forms and Reports as per user requirements

• SQL query optimization

• Data correction and ETL scripting using PL/SQL

• Analyzed and created specifications for Forms and Reports solutions to reported client issues. Technical Environment – Developer 9i/10g: Forms/Reports, PL/SQL, and SQL, PL/SQL Developer, UNIX, PVCS RAYTHEON CANADA 2006 – 2006

Oracle Developer (Contract)

• Developed Oracle 10g Reports and PL/SQL objects.

• Team Lead/Senior Developer to three other consultants Technical Environment – Developer 9i/10g: Reports, PL/SQL, PL/SQL Developer, Visual SourceSafe ADMINISTRATIVE ASSISTANTS LIMITED 2004 – 2006

Oracle Developer (Full time)

• Created and maintained PL/SQL code and database objects for educational software package marketed to school boards across North USA and Canada

• Assisted Product Support and Quality Assurance departments with replication and analysis of issues reported by clients, verification of corrected issues and definition of test data. Technical Environment – Oracle 9i/10G, Developer 9i/10G: Forms/Reports, PL/SQL, and SQL, SQL Navigator, UNIX, HP Linux, Solaris, Windows

TROPICAL MEDICINE RESEARCH INSTITUTE 2002 – 2003

Programmer Analyst

• Projects:

Patient Management System – Forms 4.5, Oracle 7.x database

Stroke Data Collection System – Forms 6i, Oracle 8i Technical Environment – Forms/Reports 4.5 and 6i, Oracle 7.x – 8i, PL/SQL, TOAD, SQL, Windows NT, Visio CABLE & WIRELESS PLC 2002 – 2002

Senior Systems Analyst (Contract)

Kevin O'Neil Davis Page 4 of 5

Analyzed and solved functional / technical issues surrounding Peoplesoft-Oracle module interfaces. Senior Systems Analyst 1995 – 2002

• Projects:

HRMS, Job Order System, Fleet Management System (FMS), Motor Vehicle Tracking Module, Pension Tracking Module, Payroll Module

Electronic Forms Processing (EFP)– Forms 6i, Oracle 8i

Performance Management, Time & Labour, VAX Access Request

PeopleSoft HR, Payroll, Benefits implementation, Data Mapping, ETL for Data Migration

EFP Customization for interface with PeopleSoft (Forms 6i)

EFP-Payroll data transfer process (SQR)

Technical Environment – Oracle 9i/10G, Developer 9i/10G: Forms/Reports, PL/SQL, and SQL, TOAD, UNIX, Solaris, Windows, PeopleSoft, Crystal Reports

COMPUTER INFINITY LIMITED 1994 – 1995

Independent Programmer

Developed additional functionality and reports for custom investment software package written in Foxpro. Developed protocol for user-generation of additional input screens based on FoxPro table structures. ADVANCED DIGITAL SERVICES 1993 – 1995

Programmer Analyst

Developed character-based Oracle 7.x application modules for general insurance industry. Created reports and ETL processes using SQR.

TECHNOLOGY SKILLS

ETL

SAP Business Objects Data Services 3.1, 4.2

Databases:

Oracle

• versions 7.x – 11g, XE

• PL/SQL

MySQL

MongoDB

Oracle Development

• Toad

• SQL Loader

• SQL*Forms, Oracle Forms (v4.5 – 11g)

• SQL*Reports, Oracle Reports (v4.5 – 11g)

• Oracle Designer 2000

• Oracle Application Express (APEX)

Business Intelligence / Reports Experience

• Oracle Reports

• SQR

• Crystal Reports

• Jasper Reports

• AS_PDF3

Full Stack Development

HTML, CSS, JavaScript, JQuery, APIs, React,

MongoDB, MySQL, JSON

SQL Server

• Version 2008/2012

• TSQL

Source Code Management

• PVCS

• SourceSafe

• ClearCase (Rational)

Security Clearance

• Reliability Clearance - August 2017

Kevin O'Neil Davis Page 5 of 5

EDUCATION / TRAINING

University of Toronto School of Continuing Studies (Full Stack Developer Certificate) 2019 Montreal Oracle Developer Day Conference 2017

Live for The Code Conference 2017

Oracle Application Express 5.1 2017

Oracle 12c: Introduction to SQL 2016

SAP Business Objects Data Services – Data Quality Management 2015 SAP BODS 4.0 2013

Oracle Database 11g: Getting Started With PL/SQL 2014 Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures 2014 Oracle Database 11g: Using SQL to Query Your Database 2014 Oracle Database 11g: Conversion Functions, Group Functions, and Joins 2014 ITIL Foundations Certification 2013

Javascript (2011) - computer-based training

Crystal Reports v10 2008

Introduction to Report Design

Academic

B.Sc. Computer Science – University of the West Indies 1993 Rated as equivalent to Canadian standards by the University of Toronto. Volunteer

Assistant Coach – United Sports Club 2014 - 2017

Coached championship teams - 2016 and 2017.

Contact this candidate