Oracle Developer

Seasoned professional with an extensive career aligning technology with business objectives to deliver short, and long-term goals, improve product capabilities, and mitigate operational risks. Recognized as a key contributor with deep experience in the Oracle space, and delivering results in project management, operational performance, business system analysis and business intelligence. Effective communicator and dedicated to maintaining a reputation built on service, excellence, and uncompromising work ethics.

Highlights of Expertise

Business Intelligence

ETL, OBIEE, OTBL

Requirement Gathering & Analysis

Reports, Interfaces, Conversions, Execution Strategies

Data Conversion Expertise

Full Life Cycle Project Management

SQL, PL/SQL, Oracle Reports, Forms, Workflow, Fast Formulas, BI (XML) Publisher and Discoverer

Patch Analysis

Information Systems Infrastructure

ITIL, Incident Management, Problem Management

Agile SCRUM & SDLC

Oracle E-Business Suite (EBS R12, 11i) Manufacturing, Financials and Oracle HCM cloud applications

Development Standards

Industry experience includes Manufacturing, Insurance, Finance, Hospitality, Utilities, Oil and Gas, Public Sector, Pharmaceutical, Steel, and Consumer Packaged Goods

Career Experience

Apptad Inc (Remote ), Reston, VA 03/2020 to Present

Senior Technical Consultant

Specializing in consulting services for Business Intelligence – OBIEE, OTBI, BI Publisher, Oracle EBS, Oracle HCM Cloud, Payroll Technical and HCM Extracts.

Broadcom, Allentown, PA (Wipro) 10/2019 to 02/2020

Technical Consultant – Business Intelligence

Worked on the business intelligence team to designed data warehousing schemas for several sales and marketing visualizations as well as created visualizations from Oracle R12 EBS Order-To-Cash ERP tables.

Designed schemas in Incorta (an analytics tool) for Sales, Shipping and Order Management visualizations.

Oracle 11g

Oracle EBS Finance and Manufacturing

Incorta visualizations

Oracle Data warehouse

Technology used: OBIEE, Incorta, and SQL Developer

Indiana University Health, Indianapolis, IN (Sondhi Solutions) 05/2019 to 09/2019

Technical Consultant – HCM Cloud integrations

Provided Payroll and Core HR integrations Technical Designs for an Oracle Cloud Implementation, utilizing established integration patterns.

Technical Design of Oracle HCM Cloud- Benefits, Payroll and Compensation Integrations, utilizing, HCM Extracts, BI Publisher

Oracle Integration Cloud (OIC), with Restful API’s

BI Publisher, OTBI, OBIEE

Oracle 12c

Technology used: Oracle Cloud Applications, BI Publisher, SQL, Oracle Integration Cloud, HCM Extracts, Oracle HCM Cloud - Global HCM, Compensation, Benefits and Payroll.

XPO Logistics, Portland, OR (Techmahindra) 10/2018 to 05/2019

Technical Consultant – Integrations, Data Conversion and Enhancements

Worked on the re-implementation of Oracle Receivables and General Ledger as well as Netezza, queries for the data warehouse. Work consisted of common file handling interface design

Technical design and development of interfaces, ETL scripts in PL/SQL and API’s,

Data Conversion

Linux Shell scripting, and the design of the file handling for incoming interfaces

BIP Reports and Oracle Forms development

Technology used: Oracle EBS – Oracle Receivables, General Ledger, Toad, Netezza, PL/SQL, BI Publisher, SOA, SQL, Oracle Forms, Oracle Reports and Linux.

Cloudworks 08/2017 to 07/2018

Technical Specialist Consultant - Provided technical leadership for Oracle Fusion Human Capital Management (HCM) Cloud Software as a Service (SaaS) implementations.

HCM cloud implementation of Benefits, Absence and Core HR at Canadian Natural Resources Limited,

Technical design and development of interfaces using BI PUBLISHER, and Oracle fusion HCM data extracts,

Data Conversion post validation reports using BI Publisher, HCM extracts and PL/SQL,

Integration Lead at Ocean Capital, implementation of Oracle HCM cloud,

Creation of conversion templates for HDL and spreadsheet loader functionality in HCM, and

Developed Fast Formulas for HCM Benefits and Absence modules.

Technology used: Oracle Fusion HCM cloud, Oracle database 12c, PL/SQL, SQL, MS Excel, HCM extracts and BI Publisher

Fujitsu Consulting (Canada) Incorporated 12/2015 – 08/2017

Senior Technical Consultant – Application Management Support namely Oracle development support on 11g, 10g and Oracle 9i, for custom Oracle Forms software within the Utilities sector.

Worked on the Transition management team for the support of custom Oracle distributed applications at a utilities company,

Responsible for documenting the existing applications and processes as a part of the transition,

Onboarding of new team members,

Monthly reports for the AMS dashboard from JIRA,

Weekly reporting extracts from JIRA for open, and resolved tickets,

Managed allocation of addition disk space with hosting vendor as a proactive step to manage database growth, and

Proposal for the integration of web-based Oil and Gas industry application with a custom Oracle form application in the public sector.

Technology used: Oracle iProcurement, Oracle iExpenses, Oracle Time and Labor, SVN version control, Oracle Forms, Reports, SQL, MS Excel, XML, PL/SQL, JIRA, Linux, and Oracle 11g

Millennium Software Inc. (US) 11/2015 – 12/2015

Consultant – Agile Development Scrum project for Ford Motor Company in Dearborn Michigan for the BOM thin change client project on Oracle 11g.

Build the BOM thin change client to generate XML output, and

Implement a web based application using Scrum.

Technology used: SQL, PL/SQL, Oracle 11g, and SQL Developer, Agile methodology/SCRUM

Intact Insurance Company 04/2015 - 08/2015

Programmer Analyst –R12 E-Business Suite functional and technical role, namely project and production support of CEMLI’s, iProcurement, Purchasing, Cash Management, Payables, General Ledger, and Web ADI.

Production support of Oracle Web-based applications and back end applications

Process documentation of any changes to the system e.g. adding a new company to the existing chart of accounts and the associated interface through Web ADI.

Support the approval process for procurement approvals

Work with Oracle support to resolve any application issues.

Technology used: SQL, PL/SQL, MS Excel, Oracle 11g, Workflow, SQL Developer, HP Service Manager, Oracle Managed Cloud Services environment (GL, AP, iProcurement, iExpenses, Purchasing and FA) with Linux

PepsiCo Canada 07/2012 – 03/2015

Systems Analyst - Upgrade of Oracle E-Business Suite from 11i to R12. Supported Oracle Financials and Manufacturing modules inclusive of transition management.

Production support of web-based applications namely internet procurement, internet expenses.

Full support of interfaces, Oracle Financials (GL, AP, FA, AR, CE, iProcurement, Cost Accounting) and Manufacturing (Process Manufacturing).

American express interface fix which included redesign, process documentation and coordination of user acceptance testing through to implementation.

Worked on a team to document the accounts receivable reconciliation process and available reporting to support this process.

Transition management of new enhancements/projects to access the impact on existing applications as well as access readiness to support – completeness of documentation.

Document all enhancements and fixes to existing applications

ITIL, Incident Management & Problem Management experience

Technology used: SQL, EBS R12.1.3, PL/SQL, Oracle 11g, Oracle Reports Oracle Forms, Workflow, Toad, Control-M,HP Quality Center, HP Service Manager, and AIX.

Softchoice Corporation 10/2011 – 07/2012

Oracle Developer - Oracle E-Business Suite Developer for ongoing projects as well as production issues.

Developed Oracle BI Discoverer reporting for receivables aging using dynamic queries.

Developed and implemented, journal entry batch custom audit trigger to work with Oracle workflow.

Resolve and log test problem reports with Oracle on E-Business suite issues.

BI Publisher and set up of Excel reporting from the Application Object Library

Technology used: SQL, PL/SQL, Oracle 11g, Oracle Discoverer, Oracle Reports, Toad, Test Tracker, and BI Publisher.

PWC at Bank of Montreal 09/2010 – 05/2011

Consultant PL/SQL Developer - Worked on the backend (PL/SQL) development in Oracle 11g, for a revolutionary web-based online investment application for the Bank of Montreal.

Developed UNIX (Bourne) shell scripts for a data purging application and other operational utilities.

Additionally, developed PL/SQL packages, procedures and functions.

Created migration scripts for database objects, packages, tables, constraints and indices for the final application release.

Tested migration scripts as well as scripts to bring database to original state during a failed deployment.

Supported various application modules during QA testing, by analysing and fixing any software bugs.

Technology used: SQL, PL/SQL, Oracle 11g, Toad, PVCS and HP UNIX.

Rogers Communications 08/2009 – 10/2009

Business Systems Analyst – Responsible for assessing the impact of the Oracle Applications Release 11.5.10 upgrade on existing reports (BI Publisher, Noetix Views, Oracle Reports) as well as resolving any issues as they arose. Additional responsibilities are ongoing post implementation and cutover support.

Developed PL/SQL procedures to facilitate Noetix Views report testing.

Supported end-user testing of existing Noetix reports against the new 11.5.10 release of e-business suite

Technology used: SQL, PL/SQL, Oracle Reports, Noetix, Oracle 10g, Toad, Linux, and Oracle e-Business suite 11i (Order Management, Inventory, Receivables, Purchasing)

MDS Inc. 07/2008 – 05/2009

Senior Developer- Technical Team Lead: Managed, planned, determined schedule, monitored activities, and led offshore as well as local resources through Team Acceptance, User Acceptance, and Quality Assurance testing, in a validated environment. Whilst at MDS, I delivered Oracle projects consisting of multi-functional teams (5-10 resources). Additional duties performed were recommending solutions or system configuration choices to meet business requirements.

Managed, planned, and scheduled the following projects:

-The Bank Statement automation project with Bank of America. Project reduced manual data entry (1 Full Time Equivalent (FTE) offshore, and 8 Part Time Equivalents (PTE)), which led to faster account reconciliation and mitigated risks of cheque fraud.

-American Express Internet Expenses Project that led to greater efficiencies in employee expense reimbursements. (7 PTE and 1 FTE offshore)

-HSBC EFT (Electronic Funds Transfer) payment automation. Devised and recommended technical approach through meetings with senior managers and key users. Planned, scheduled, and managed the project. (5 PTE on shore and 5 remote PTE).

-Bank of America ACH (Automated Clearing House) payment project for 3 offices in the United States. Planned scheduled and managed the project (1 FTE and 6 PTE) which allowed for faster supplier reimbursements.

Assessed various archive solutions from various vendors namely IBM and Applimation.

Provided technical leadership to offshore resources and mitigated performance risks for HR interfaces, Project Accounting, Install Base, Order Management, and Inventory with IBM offshore team.

Led the Oracle Install base data conversion exercise, which led to a completely unified system that included an acquired company’s install base items.

Technology used: SQL, PL/SQL, Merant, Oracle Reports, Oracle Forms, Oracle 9i, Toad, AIX, Linux, Oracle E-Business suite 11i (Human Resources, Time and Labor, Internet Expenses, Purchasing, Order Management, Inventory, Transportation Management, Payables, Projects, Install Base, and General Ledger)

Trecata Corporation 06/2006 – 06/2008

Support Manager: Provided functional and technical support for Trecata’s outsourcing business.

Managed, planned, scheduled, monitored, and coordinated an archive project for a large financial institution. The project included managing the acquisition of infrastructure as well as relocation in accordance with the project budget. The system footprint included Oracle Human Resources and Oracle Financials. Company successfully removed sold business unit from their Oracle applications system on time and on budget.

Regression tested Release 12 upgrade of Oracle E-Business suite. Resolved issues as they arose.

Delivered proposal for an implementation of Compensation and Benefits Workbench. Sections worked on included training methodology as well as the Project Management Institutes (PMI), PMBOK® methodology.

Completed impact assessment for a chart of accounts reorganization on Accounts Payable, Fixed Assets, Human Resources and General Ledger. The project included the reporting impact on interfaces to other systems.

Production support for large financial institutions.

Developed cheque print program for Release 12 using BI Publisher

Technology used: SQL, PL/SQL, Oracle Reports, Workflow, Oracle 9i, Toad, AIX, Linux, BI (XML) Publisher Oracle E-Business suite 11i and R12 (Human Resources, Internet Expenses, Purchasing, Payables, Fixed Assets, General Ledger)

Atomic Energy of Canada Ltd 05/2005 – 06/ 2006

Senior Business Systems Analyst: Worked on strategic projects as well as Oracle Applications support. The projects included Project Accounting (PA), Payables (AP) General Ledger (GL), Fixed Assets (FA), Shared Human Resources and OTL (Oracle Time and Labor) as well as production support of interfaces, through to code fixes.

Developed data conversion on the chart of accounts reorganization project, which was successfully completed.

Created feasibility study, analysed, designed, and developed successful code fixes to employee assignment interfaces that were previously deemed irreparable.

Managed Oracle release 11 archive project

Managed the Timecard Workflow data cleanup project (1 FTE and 2 PTE)

Production support Oracle Release 11i

Resolved production support issues, inclusive of code fixes when required

Technology used: SQL, PL/SQL, Oracle Reports, Workflow, Oracle 9i, Toad, Unix, Oracle E-Business suite 11i (Oracle Time and Labor, IProcurement, IExpenses, Oracle Purchasing-PO, Oracle Payables-AP, Oracle Fixed Assets-FA, Oracle General Ledger-GL, Oracle Projects-PA), Remedy

IBM Business Consulting Services/ PricewaterhouseCoopers (PWC) 07/1997 – 05/2005

IBM acquired PWC Business Consulting services in 2000.

Senior Consultant

Experiences included preparation of functional and technical design, performing gap analysis and team leadership. Over the years, I have been involved in several large-scaled Oracle E-Business Suite implementations with the delivery of the following work products, MD050 (functional design), MD070 (technical design), development estimates and project proposals.

Requirement gathering roles in the implementation of Order Entry, Warehouse Management and Manufacturing modules.

Created proposals for RFP responses for several large implementations.

Managed or oversaw development of a global implementation of Oracle E-Business Suite. Estimation of work effort, review of development standards, reporting strategy, data conversion strategy, interface strategy, review and deliver technical designs and code reviews.

Led Oracle Applications development extension team, facilitating code reviews and accessing technical feasibility prior to development with a total of 4 FTE. Additionally, responsible for the delivery of development standards.

Reviewed and coordinated training team for a telecommunications company as part of a global implementation of Oracle applications. (3 technical writers) Delivered training materials and job aides (Supply Chain training materials for 3 sites and 2 countries).

Delivered several technical designs and unit test plan documents for manufacturing, human resources and financial modules.

Implemented RICE (Reports, Interfaces, Conversions and Extensions Strategy, inclusive of workflow) Delivered Strategy for Release 11i to provide a development framework.

Performed coaching and development leadership roles on several projects.

Technology used: SQL, PL/SQL, Linux, Unix Oracle Reports, Oracle Forms, Workflow, Oracle 8, 8i, Oracle 9i, Toad, Unix, Oracle E-Business suite 11i (iProcurement, iExpenses, Oracle Purchasing-PO, Oracle Payables -AP, Oracle Fixed Assets-FA, Oracle General Ledger-GL, Oracle Inventory, Oracle Bills Of Materials, Oracle Work In Process, Order management and Oracle Human Resources)

Prior to 1997, I have held several other positions including Application Developer/Client Server Systems, Senior Systems Analyst, and Programmer at the following companies Russel Metals Inc., Telecommunications of Jamaica Limited, and Advanced Digital Services Limited.

Education and Professional Development

M.Sc. (MSc) Computer Information Systems, University of Phoenix

B.Sc. (BSc) General Double Major Computer Science and Mathematics, University of the West Indies Mona Campus

Java - George Brown College

Oracle SOA Suite 11g: Build Composite Applications Ed 2

Microsoft Azure - Skillsoft

Web Development Fundamentals (HTML 4.1) – Skillsoft

XML Language Basics - Skillsoft

Registered for Certificate in Big Data Analytics (Fall 2018) at York University

Corporate Sponsored Professional Development

Agile (SCRUM master) Training (Fujitsu)

Project Management Skills for Success - Learning Tree (AECL)

Mercury Interactive WinRunner Web and TestDirector (PricewaterhouseCoopers)

Release 11i: Oracle Purchasing, Oracle Order Entry, Oracle Receivables, Accounts Payables, Oracle Inventory, and General Ledger Training (PricewaterhouseCoopers).

Oracle Forms, Oracle Reports, Building Extensions to Oracle Applications, Oracle Purchasing, Oracle Order Entry, Oracle Receivables, Oracle Inventory, Develop Extensions to Oracle Application, System Administration and FlexFields at Oracle Corporation (Russel Metals Inc.)

SCO UNIX (Telecommunications of Jamaica Ltd.)

C Programming Language (Telecommunications of Jamaica Ltd.)

Contact this candidate