Oracle Support

Location:

Brampton, ON, Canada

Posted:

January 08, 2021

Contact this candidate

Resume:

Name: Adekunle Tunde Bode,

(E-mail: **********@*****.***) Phone: 416-***-**** (Cell)

Experience Summary

A Certified Oracle Professional with over 29 years’ experience in all phases of application development cycle. Development experience covers the following industries: Government, Pharmaceuticals, Materials Management, Financial Applications, Banking, Telecommunication, Credit Risk management, Retails (RETEK), Production/Manufacturing, Foreign Banking, Payroll, HRM and Oracle ERP (Supply Chain Management, Financials & Manufacturing), Technical Team Leadership, IT development Project planning, estimation, presentation skills, Project Management (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), Negotiation skills, UML, UTP, Unix Shell Programming, Mercury Test Director.

Experience also includes Over 18 years of hands-on experience in Oracle AIMS methodology, TCA, Oracle Fusion Cloud Rel. 11.1.9, Rel. 13,19D Oracle Applications Rel. 12.2.6, 12.2.5, 12.2.4, 12.1.3, 12.1.2, 11i, 10.7/11i - 11.5.1, 11.5.3, 11.5.4, 11.5.7, 11.5.9, 11.5.10 (AR, AP, GL, FA, FAH, PO, I-Proc, I-Expense, CE, PA,OM/OE, Oracle Trade Management, INV, BOM, WIP, OTM, OPM, HRM, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), OTL, Oracle Advanced Benefits, ASCP, Oracle FAH) Customization, Interfacing, Migration & Development tools like SQL*Forms, Pro*C, Oracle Forms, Oracle Reports, PL/SQL, SQL*Plus, Oracle JDeveloper, SQL*Loader, Oracle XML/Bi Publisher, Oracle Approval Management Engine (AME) & Oracle Discoverer, Oracle Warehouse Builder, Oracle SOA and Oracle ADF.

• 10/11g Developer Suite for Forms and Reports,

• Oracle Application Development Framework (ADF)

• Oracle REST/SOAP service, Oracle Integration Cloud Services (OICS)

• Oracle Cloud Conversions using FBDI/FBDL, ADFDi

• JDeveloper,

• Custom.pll

• Forms Personalization,

• Oracle XML / Bi PUblisher

• PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules

• Experience architecting application solutions in Oracle eBusiness Suite environment

• Experience writing Advance SQL queries.

• Experience with Oracle 10g or 11i databases

• Experience with Oracle database conceptual, physical and logical data models

• Experience with Oracle R12E-Business Suite modules

• Experience defining logical and physical data models

• Experience Approval Management Engine (AME) & Oracle Discoverer, Oracle Warehouse Builder.

10g Developer Suite for Forms and Reports

• Experience with Noetix, Formscape, MKS Source Control Management, VSS Source Safe, PVCS and QVCS, TOAD.

• A great team worker, but also functions well as an independent worker. A quick learner who loves challenges and is at his best when under pressure.

• Version control: PVCS, QVCS, Miscosoft VSS, MKS

Query Optimization in Oracle: TOAD, Explain plan, Tkprof, Analyze command

Professional Experience

CSS International/ACCO Engineering, Pasadena California, USA - Oracle Cloud Architect / Integration Technical Lead (May 2017 to Jan 2020)

(Dec 2019 to date)

Technical leadership, managing and guiding technical resources working on multiple projects

Lead Oracle HCM Cloud technical design, development, integrations and implementation.

Expertise in design and mapping of EBS/Cloud ERP modules

Managing and Tracking of Project Deliverables

Leadership, mentoring and managing offshore resources and development work schedule.

Project status update presentation to Executive Management/Sponsors

Team Player with Collaborative Approach

Technical business process design, documentation and implementations.

Change Management

Worked on multi-year business transformation projects

Experience using various data interchange formats like JSON and XML

Experience with web services such as REST and SOAP

Experience consuming REST APIs (bonus points for building effective REST APIs)

Supporting Oracle Data Integration Cloud Services, Oracle Data Integration Platform Cloud, Oracle Integration Cloud

Oracle Cloud HCM Fast Formulas

Oracle Cloud reporting - Oracle OTBI Dashboard

Oracle HCM, Payroll Integrations for US, Canada and UK

Oracle HCM Extracts design and

Oracle OTBI/BIP Reports development

Data conversion/Integration for Oracle HCM Fusion applications, Oracle REST/SOAP service, ORDS, Oracle Integration Cloud Services (OICS).

Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.

Experience in managing HR data requests and Assemble, analyse and format data into useable reports.

Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.

Responsible for estimation, design, development, testing, support and deployment of application using Oracle SOA Suite 12c, Oracle OSB, Oracle JDeveloper 12.2.1

Experience in Oracle OSB using Oracle Fusion Middleware Stack 11g (Eclipse IDE)

Experience in Oracle Integrated Cloud Service (ICS).

Part of designs, proof of concepts and development for Client project using Oracle ICS.

Design and Implementation of Enterprise Shared Services platforms such as SOA.

Involved in Project Design, Development, Enhancement and support-based applications.

Worked extensively on Oracle SOA Suite, OSB 12c/11g products like BPEL, Mediator, Business Rules, Web Services, proxy, business services, service account, routing, JCA, XQuery, OWSM etc.

Strong Experience in Web Services, SOAP, WSDL, XSD, XML, XSLT, and XQUERY.

Oracle Cloud Conversions using FBDI/FBDL, ADFDi

Integration Experience with RESTFUL and JSON services and ORDS.

Experience in integrating with third party benefit carriers, JDE, EBS and Web services.

Experience in developing and deploying BPEL Processes using technology adapters (JDE, REST, Oracle Applications, DB Adapter, File Adapter, B2B and FTP Adapter), Fault handling (catchall) and Transformations.

Knowledge on scheduling the SOA Services through Quartz and managing it through EM.

Experienced in BPEL orchestration and using Mediator, Adapters, Workflow and human task

Responsible for Investigating errors and performing Root cause analysis

Experienced in Oracle integrations using Oracle repository and Business event, Oracle Integration Cloud Services (OICS

Metrolinx, an agency of the Government of Ontario, Canada – Senior Oracle Cloud / EBS Lead Developer (May 2017 to Jan 2020)

Data conversion/Integration for Oracle EBS (Financials, Projects, Oracle EAM, Unifier) & Fusion HCM Fusion applications

Providing techno - functional support for Oracle Application R12.2.4 Oracle ERP (Financials & Human Resources, HCM, Procurement, Order Management & Shipping, OTL, Core HR, Payroll, Absence Management, Oracle Advanced Benefit, HR Self service, Reporting, interfaces, extensions and customizations).

Oracle CEMLI development for AR, FA, AP, GL, Cash Management, HRM, Oracle Advanced Benefit, Oracle Projects, PO, I-Expense, I-Proc, & Financial Modules.

Personalization of Oracle OAF forms & Oracle forms 10G re-designed and development to OAF forms.

Several Oracle OAF forms customizations and Extensions was done to the Controller, View Objects.

Built BPEL processes that subscribe to various EBSevents around requisitions processing functionality and participate in database and JMS transactions. Used the various activities available in BPEL to perform transformations and write business logic.

Error handling was also done for handling the faults in BPEL Processes. Business faults were handled using the catch, catchall, throw, compensation and compensation handler activities. The system faults were handled by defining fault - policies in the fault management framework.

The database MDS repository was used to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files. Abstract WSDL's were also stored here and any call to a composite through a BPEL is made through abstract WSDL in-order to avoid dependencies problems during server startups.

Implemented some Human Resources Approval Tasks like a "New Hire Workflow" process using BPEL in SOA Suite to activate a series of workflow activities and approvals when an employee or a contactor comes on-board. This system during the flow interacts with multiple back-end applications and services.

Oracle P-Card interface/implementation with BMO Bank.

Technical extension and reports on Oracle Projects Management (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management, Billing, Revenue and Invoicing).

Support and follow-ups of service requests with Oracle Support.

Customization of account Generator in PO & Supplier Invoices for Project Related Transactions

Customization of account Generator in Requisition for Project Related Transactions

Customization of account Generator for iExpense for Project Related Transactions

Developed Oracle BI reports on Oracle Fusion HCM Cloud and projects costing, billing, Invoicing and Costing

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting & TCA, Oracle AME Oracle Workflow customization PL/SQL packages/procedures based programming for data integration, enhancement and interface development around Oracle EBS modules.

Study, design, analysis, Implementation, technical support & testing of Oracle HCM Fusion applications (Oracle Fusion Rel 13.*)

Technical documentation using Oracle AIMS methodology

Data conversion/Integration for Oracle HCM Fusion applications

Oracle SOA, BPEL, OSB, REST/SOAP service

Technical support for Oracle Fusion R13 (HCM)

Experience in Creating HCM Extracts and Delivery Options for Extracts.

Developed OTBI reports for HR users to view and validate employee data using existing subject areas.

Experience in Creating Reports and Analytic using Fusion HCM BI.

Experience in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI.

Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.

Experience in managing HR data requests and Assemble, analyse and format data into useable reports.

Implementation and support of Oracle EBS HRMS and Oracle Cloud HCM Talent management.

Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.

CCHS-Cross Country Home Services, Fort Lauderdale, Florida – Senior Oracle EBS Technical Consultant (Feb 2017 to May 2017)

Retrofit and custom development of Oracle Procurement/Inventory forms (Oracle EBS R12.2.4)

Providing techno-functional support for Oracle Application R12.2.4 Oracle ERP (Financials & Order Management & Shipping).

Technical documentation using Oracle AIMS methodology

Design, analysis and development of Oracle Forms, PL/SQL, and packages/procedures based programming for data integration

Support and follow-ups of service requests with Oracle Support.

Testing and documentation of the tests results

Saks- 5th Avenue / PWC, Jackson, Mississippi, USA – Oracle Fusion Lead (Integration/Data Conversion) Technical Consultant (March 2016 to March 2017)

Study, design, analysis, Implementation, technical support & testing of Oracle Fusion Financials, HCM Fusion applications (Oracle Fusion Rel 11.1.9)

Project Management, Supplier management, Fusion Expenses, Web Centre Forms Recognition, Fusion Automated Invoice procession, &

Oracle Fusion data conversion technical lead and architect for Fusion Rel 11.1.9 (Financials & Human Capital Management (HCM).

Functional and technical documentation using Oracle AIMS methodology

Oracle CEMLI development for HCM, Oracle Fusion Financials, Project Management, Supplier management, Fusion Expenses, Web Centre Forms Recognition and Fusion Automated Invoice procession.

Data conversion/Integration Lead for Oracle Fusion Financials, Project Management, Supplier management, Fusion Expenses, Web Centre Forms Recognition, Fusion Automated Invoice procession, & HCM Fusion applications

Technical support for Oracle Fusion R11.1.9

Oracle SOA, BPEL, OSB, REST/SOAP service

Technical support for Oracle Fusion R11 (HCM)Experience in Creating HCM Extracts and Delivery Options for Extracts.

Oracle SOA Suite 9G, Oracle OSB, Oracle JDeveloper 9

Experience in Oracle OSB using Oracle Fusion Middleware Stack 10G (Eclipse IDE)

Experience in Oracle Integrated Cloud Service (ICS).

Part of designs, proof of concepts and development for Client project using Oracle ICS.

Design and Implementation of Enterprise Shared Services platforms such as SOA.

Involved in Project Design, Development, Enhancement and support-based applications.

Worked extensively on Oracle SOA Suite, OSB 9g products like BPEL, Mediator, Business Rules, Web Services, proxy, business services, service account, routing, JCA, XQuery, OWSM etc.

Strong Experience in Web Services, SOAP, WSDL, XSD, XML, XSLT, and XQUERY.

Integration Experience with RESTFUL and JSON services.

Data conversion/Integration for Oracle HCM Fusion applications, Oracle REST/SOAP service, ORDS, Oracle Integration Cloud Services (OICS).

Developed OTBI reports for HR users to view and validate employee data using existing subject areas.

Experience in Creating Reports and Analytic using Fusion HCM BI.

Experience in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI.

Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.

Experience in managing HR data requests and Assemble, analyse and format data into useable reports.

Implementation and support of Oracle EBS HRMS and Oracle Cloud HCM Talent management.

Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.

The following modules were in scope

HCM Oracle Modules

• Core HR

• Payroll

• OTL

• Absence Management

• Self-Serve (employee and manager)

• Reporting

• Advanced Benefits (for USA & Canada)

Oracle Finance Modules

• Fusion Financials (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Financial Reporting)

• Project Management (Oracle Fusion Project Management, Fusion Project Financials, Oracle Fusion Task Management, Oracle Fusion Project Resource Management, Oracle Fusion Time and Labor for Projects)

• Compliance and Financial Controls (not available from Oracle until R13 initial design will be based on Vendor’s interim solution)

Financial Reporting Compliance

Fusion Advanced Financial Controls

Web Centre Forms recognition

Fusion Automated Invoice Processing

Fusion Expenses

Supplier Management (Fusion Purchasing, Fusion Supplier Qualification Management, Fusion Supplier Portal)

Canadian Nuclear Laboratories (CNL), Deep River, Ontario – Oracle HCM Test Lead Consultant (May 2016 to Aug 2016)

Preparation of Oracle HCM test scripts.

Updated existing end to end functional testing plan.

Executed and implemented testing procedures and analyzed results.

Ensured deliverables conformed to customer requirements.

Tracking test defects and follows up on correction and re-test.

Support and follow-ups of service requests with Oracle Support.

Testing and documentation of the tests results.

Envison HealthCare, Denver, Colorado – Lead Oracle EBS Technical Consultant for (Oct 2015 to March 2016)

Data conversion/Integration for Oracle EBS (Financials, Projects, Oracle HCM, SCM applications )

Providing techno - functional support for Oracle Application R12.2.5 Oracle ERP (Financials & Human Resources, OTL, Core HR, Payroll, Absence Management, Oracle Advanced Benefit, HR Self service, Reporting, interfaces, extensions and customizations).

Oracle CEMLI development for AR, FA, AP, GL, Cash Management, HRM, Oracle Advanced Benefit, Oracle Projects, PO, Inventory, OM, Shipping, ASCP, I-Expense, I-Proc, & Financial Modules.

Support and follow-ups of service requests with Oracle Support.

Customization of account Generator in PO & Supplier Invoices for Project Related Transactions

Customization of account Generator in Requisition for Project Related Transactions

Customization of account Generator for iExpense for Project Related Transactions

Developed several reports on Oracle HCM and projects costing, billing, revenunue management, Invoicing and Costing

Support and follow-ups of service requests with Oracle Support.

Providing techno - functional support for Oracle Application 12 Oracle ERP (Financials & Human Resources, HRM, Core HR, Order Management & Shipping Module and Inventory).

Support and follow-ups of service requests with Oracle Support.

Functional and technical documentation using Oracle AIMS methodology

Agropur Co-operative, Montreal Quebec – Senior Oracle EBS Techno functional consultant for Oracle EBS R.12.1.3 for both USA & Canada (Sept 2014 to Oct 2015)

Data Conversion, integration, Customizations and extensions for AR, Fixed Asset - FA, AP, GL, Cash, Discrete & Process manufacturing, Procurement, Projects billing & Costing, BOM, WIP, Quality, WMS, etc.

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting, HTML Forms Personalization and TCA, Oracle AME Oracle Workflow customization PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules.

Providing techno functional support for Oracle Application 12 Oracle ERP (Financials & Human Resources, HRM, Core HR, Payroll, and HR Self service, Oracle Advance Benefits, Order Management & Shipping Module, OPM, ASCP and Inventory).

Oracle HTML forms Personalization

Oracle ADF forms modifications of Oracle HR Self-service forms.

Design, analysis and development of PL/SQL packages/procedures based programming for custom Oracle EBS applications, data conversions, and interface development around Oracle EBS modules

Experience architecting application solutions in Oracle eBusiness Suite environment

Functional and technical documentation using Oracle AIMS methodology

Support and follow-ups of service requests with Oracle Support.

Testing and documentation of the tests results

Knape & Vogt, Grand Rapids, MI, USA (Contract work through Oxford Corp, USA) – Senior Oracle EBS Lead Developer (Nov 2013 to Sept 2014)

System study, analysis and techno functional support & Customizations for Oracle HCM, HRM, Oracle Advanced Benefits, Core HR, OTL, Payroll, HR Self Services, Compensation workbench, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), Payroll, Payments, I-Procurement, AR, FA, AP, GL, Cash Management, PO, Oracle ASCP, Inventory, OM, Shipping, WMS, Advanced Pricing, I-Expense, I-Proc, Oracle FAH & Financial Modules.

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting & HTML Forms Personalization and TCA, Oracle AME Oracle Workflow customization PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules

Functional and technical documentation using Oracle AIMS methodology

Oracle Forms, Reports, PL/SQL, XML/BI Publisher Reporting and TCA, Oracle AME Oracle Workflow customization for Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management),.

Technical Application architect and Lead solution adviser

Oracle Reports, Oracle XML/BI Publisher

Support and follow-ups of service requests with Oracle Support.

Functional and technical documentation using Oracle AIMS methodology

Testing and documentation of the tests results

Ontario Government, Enterprise Financial Services and System (IFIS) - Oracle EBS R12 upgrade, Toronto, Canada– Lead Oracle EBS Developer/Systems Integrator (April 2013 to Oct 2013)

Technical development Lead Oracle EBS R12 upgrade from 12.1.3 to 12.2.1, 12.2.3

Technical Lead for data integration & Customizations for, Payments, I-Procurement, AR,CE, GL, FA, AP, Cash Management, HRM, Core HR, Payroll, HR Self Service, Benefits, Absence Management, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management),, PO, I-Expense, I-Proc, & Financial Modules

Data conversion/Integration for Oracle EBS (Financials, Projects, Procurement, Oracle HCM )

Several Reports using BI-Publisher.

Functional and technical documentation using Oracle AIMS methodology

Preparation of test scripts for several modules and tasks

Testing and documentation of the tests results

Providing technical support for Oracle Application 12 Oracle ERP (Financials, & Human Resources, Core HR)

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting & OAF Personalization and TCA, Oracle AME, PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules.

Developed several new codes and modified existing batch modules using PL/SQL and Oracle Forms.

Developed several new PL/SQL packages for Database packages, Database procedures and triggers.

Developed several Unix Korn shell scripts to aid the performance of some customized routines on Oracle application.

Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.

Worley Parsons, Calgary, Canada (Contract work through Oxford Corp, USA) – Lead Developer/Systems Integrator for USA, Canada, UK, Australia and Singapore. (Dec 2012 to Aug 2013)

Integrated Oracle HRM, OTL, Payroll, Absence Management, Oracle Advanced Benefits and Oracle Advanced Benefit to ADP Global view payroll/benefit system integration for USA, Canada, UK, Australia and Singapore.

System study, analysis and techno functional support & Customizations for Oracle HCM, HRM, Oracle Advanced Benefits, Core HR, OTL, Payroll, HR Self Services, Compensation workbench, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), Payroll, Payments, I-Procurement, AR, FA, AP, GL, Cash Management, PO, Oracle ASCP, Inventory, OM, Shipping, Advanced Pricing, I-Expense, I-Proc, Oracle FAH & Financial Modules, Discrete & Process manufacturing, Procurement, BOM, WIP, Quality, WMS etc.

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting & OAF Personalization and TCA, Oracle AME Oracle Workflow customization PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules

Design, analysis and development of Oracle Forms, Reports, PL/SQL, Oracle workflow, XML/BI Publisher Reporting & HTML Personalization and TCA, Oracle AME Oracle Workflow customization PL/SQL packages/procedures based programming for custom applications, data conversions, and interface development around Oracle EBS modules

Oracle Fast formula, Oracle Forms, Oracle AME Oracle Workflow customization for Projects.

Business Intelligence: Design, Reporting, BI Analysis, Oracle Discoverer

Testing and documentation of the tests results

Several data extracts program from Oracle EBS to ADP Globalview system

Developed several Unix Korn shell scripts to aid the performance of some customized routines on Oracle application.

TransCanada Pipeline, Calgary, Canada (Contract work through Eagle Recruitment) – Oracle Project EBS Technical Lead (July 2012 to Dec 2012 < Oracle EBS Rel. 12.1.3>

Technical Leadership, Development, support, integration & Customizations for Oracle Financials (GL, AR, AP, Cash Management, FA), FAH, Internet Expense, Iproc, HRM, Oracle Advanced Benefits, Core HR, OTL, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), Payroll, PO Modules and Oracle Financial Accounting Hub (FAH), Discrete & Process manufacturing, Procurement, BOM, WIP, Quality, WMS, etc.

Oracle Reports, Oracle XML/BI Publisher, Forms Oracle Fast formula, Oracle Identity Manager, Oracle Access Manager, Oracle Internet Directory, Websphere application server

Oracle Forms & HTML Personalization, TCA, Oracle AME Oracle Workflow customization for Projects.

Setup Oracle Discoverer views for client, developed discoverer reports and EULs

Several Reports using BI-Publisher.

Technical extension and reports on Oracle Projects Management, Costing & Billing, Revenue and Invoicing.

Developed projects related account generator using AutoAccounting.

Functional and technical documentation using Oracle AIMS methodology

Preparation of test scripts for several modules and tasks

Testing and documentation of the tests results

Technical Application architect and Lead solution adviser

Helping with identifying functional flow in relation to business process, and their documentation of gap analysis.

Data Integration & Management: Mirroring, Log Shipping, Replication, Materialized Views, Power Pivot, Data Normalization, Table Partitioning

Business Intelligence: Design, Reporting, BI Analysis, Oracle Discoverer

Oracle Project related account generators.

UNIX Shell Programming to support data encryption (SFTP/PGP encryptions)

Oracle AIMS methodology

Developed several Oracle Forms, Reports, PL/SQL and SQL scripts for the above customizations.

Developed several new PL/SQL packages for Database packages, Database procedures and triggers.

Developed several Unix Korn shell scripts to aid the performance of some customized routines on Oracle application.

Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.

Worley Parsons, Calgary, Canada (Contract work through Oxford Corp, USA) – Senior Oracle EBS Lead Developer/Systems Integrator (March 2012 to July 2012)

Technical support, integration & Customizations for, Payments, I-Procurement, GL, AR, FA, AP, Cash Management, HRM, Oracle Advanced Benefits, Core HR, OTL, Oracle Projects (Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management & Oracle Project Management), Payroll, PO, Inventory, OM, Shipping, Oracle WMS, Advanced Pricing, I-Expense, I-Proc, & Financial Modules, Discrete & Process manufacturing, Procurement, BOM, WIP, Quality, etc.

Oracle Reports, Oracle XML/BI Publisher, Forms Oracle Fast formula, Oracle Forms & HTML Personalization, TCA, Oracle AME Oracle Workflow customization for Projects.

Payable Invoice Approval, PO Approval, OTL Workflow for employees, PA Timecard approval workflows using AME

Technical extension and reports on Oracle Projects Management, Costing & Billing, Revenue and Invoicing.

Developed projects related account generator using AutoAccounting.

Technical support, integration & Customizations for HRM, Oracle Advanced Benefits, Core HR, OTL, Oracle Projects, Payroll & Financial Modules

Several Reports using BI-Publisher.

Functional and technical documentation using Oracle AIMS methodology

Preparation of test scripts for several modules and tasks

Testing and documentation of the tests results

Helping with identifying functional flow in relation to business process, and their documentation of gap analysis.

Oracle Project related account generators.

UNIX Shell Programming to support data encryption (SFTP/PGP encryptions)

Oracle AIMS methodology

Interface and integration with ADP Globalview payroll/benefit system.

Several data extracts program from Oracle EBS to ADP Globalview system

Developed several Oracle Forms, Reports, PL/SQL and SQL scripts for the above customizations.

Business Intelligence: Design, Reporting, BI Analysis, Oracle Discoverer

Developed several new PL/SQL packages for Database packages, Database procedures and triggers.

Developed several Unix Korn shell scripts to aid the performance of some customized routines on Oracle application.

Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.

Pomeroy, Hebron, KY, + Mitsui Foods, NY, USA (Contract work through DAZ SI, USA) – Senior Oracle EBS Lead Developer/Systems Integrator (April 2011

Contact this candidate