SUMMARY:

• Over 13+ years of experience as an Oracle Applications Technical Consultant and Oracle HCM Consultant.
• Hands on experiences in Oracle Development - Oracle Reports, Oracle Forms, SQL, Oracle Discoverer, BI ( XML) Publisher and PL/SQL hands on experiences.
• Production support, e-business suite patch analysis for Oracle e-business suite. Examples include analyzing impacts against extensions (custom modules built by extension) or existing seeded modules, interfaces by determining required regression tests, functional tests for user acceptance testing on a required subledger accounting patch at Pepsico.
• Technical design and relation database design (data modelling) expertise. Examples of which include the design of a common library functions using PL/SQL to add attachment to Purchase Orders automatically for a life sciences organization; Designed and built a custom mapping form for the translation of legacy COA to a new multi-segment COA to be used for interfaces and data conversion (account to account mapping).
• Experienced in an Oracle e-Business Suite Managed Cloud Services environment; working with Oracle Support to deliver patches and other system changes.
• Deep development experience Reports, Interfaces, Conversions, Extensions (RICE) and Workflow (RICE-W). I have built interfaces for Receivables, Order Management, Electronic Funds Transfer Payments
• Data Conversion Expertise on Procure to Pay, Order to Cash processes and Oracle HCM Cloud implementations. Built data conversion program using PL/SQL, staging tables, and Oracle concurrent manager.
• Extensive interface development with E-business suite for Receivables, Payables (invoices), order management, General Ledger and Manufacturing modules
• Built and designed several custom Workflows as well as extensions to existing workflows e.g. Account Generator, PO approval workflow and Journal Batch Approval.
• Experienced in development environments on Oracle Databases 9i, 10g, 11g, and 12c
• Configuration management and defect control software such as HP Quality Center, JIRA, HP Service Manager, PVCS and SVN
• Developed BI (XML) Publisher, using e-text, rtf and Excel templates. Examples of artifacts include check print program, purchase order and several HCM cloud reports.
• Created several work products (artifacts) e.g. AIM documents (MD070 - Technical design, MD050 - Functional design, Installation instructions and TE020 test scripts, inclusive of Development & Configuration management standards.
• Built and designed interfaces using HCM Extracts, BI Publisher for Oracle HCM Cloud, for Benefits, HR and Payroll.
• Tools - Toad, SQL/Developer, SQL/Plus, and SQL/Loader
• Built and designed UNIX, and or Linux shell scripts for code migration. Additionally, for file handling or file movement for mission critical interfaces such as GL balances, Receivables cash receipts, EFT, and receivable invoice premium interfaces. Scripts includes call to SQL*Loader, and fndload (program definition loads)
• Experienced in development delivery in business-driven Technology Organizations
• Requirement Gathering & Analysis experiences for large technology companies e.g. Fujitsu and IBM Consulting services
• Agile Scrum development experience for a project at a large automotive industry client. Delivered XML extract using PL/SQL to describe respective BOM’s (Bills of Materials)
• Created development standards for several e-Business projects at IBM, MDS and the government of Ontario
• Experienced operating in an ITIL, Incident Management, and Problem Management environment. E.g. presenting changes to the CAB, and providing required artifacts to support the change
• Full Life Cycle Implementations (SDLC), and Oracle’s AIM
• ERP, Oracle E-Business Suite (EBS R12, 11i) Order Management, Inventory, General Ledger, Receivables, Project Accounting, Cost Accounting, OTL, Payables, iExpenses, iProcurement, and Purchasing)
• Experienced in Oracle E-business Suite manufacturing and financials implementations in the telecommunications industry
• Excellent verbal & written Communications

TECHNICAL SKILLS:

Programming Language: Java - George Brown College 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.

Technical and Functional Skills: OraclePL/SQL, SQL*Plus, SQL*Loader, SQL Developer, Oracle WorkflowERP (Oracle Apps 11i &R12) - TechnologySQL*Loader, Putty, Oracle Forms, Oracle Reports, Workflow, BI Publisher (XML Publisher) and Oracle Discoverer, Concurrent Manager - Security, Flexfield definition, Value Sets, Program definition, Request Groups and other system administration functions.ERP(Oracle Apps 11i &R12) ModulesOM, PO, iProcurement, AP,GL, Fixed Asset FA, AR,PA, INV, OE, iExpenses, Web ADI, Oracle Time and Labor, HCM Cloud- HR

Oracle HCM Cloud: HCM Extracts, and BI Publisher

Operating systems: Windows XP/NT/2K, UNIX and Linux

Others Tools: JIRA, Utilities FNDLOAD, UTL FILE, TOAD, custom pll

Methodologies: Oracle AIM Methodology, Agile Scrum

EXPERIENCE:

Confidential

ORACLE TECHNICAL SPECIALIST - DEVELOPMENT CONSULTANT

Responsibilities:

• Designed and built data conversion validation programs that were independent of fixed data positions. Data was compared against received versus extracted data; discrepancies reported if data was dropped or changed.
• Developed data conversion reconciliation reporting with SQL scripts, BI (XML) Publisher reports, HCM Extracts on data conversion metrics.
• Developed HCM extracts of Worker (Address, Employment Relations
• Established processes and procedures in the design of multiple data extract programs in support of interfaces to external vendors such as the OSI interface.
• Creation of conversion templates for HDL and spreadsheet loader functionality in HCM.
• Developed Fast Formulas for HCM Benefits and Absence modules.

Environment: Oracle Fusion HCM cloud, PL/SQL, SQL, Oracle 12c, HCM extracts and BI (XML) Publisher

Confidential

ORACLE SENIOR TECHNICAL CONSULTANT

Responsibilities:

• Providing leadership role in onboarding new team members utilizing expertise in Oracle database concepts and products.
• Ensured adequate allocation of disk space on client databases to proactively manage growth, created monthly reports for the AMS dashboard from JIRA, and leveraged best practices in weekly report extracts from JIRA for open and resolved tickets.
• 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 project
• Worked actively to onboarding of new team members, to the various Oracle environments
• Proposal for the integration of web-based Oil and Gas industry application with a custom application to Oracle using SOAP in the public sector.

Environment: Oracle E-Business Suite 11i, Oracle iProcurement, Oracle iExpenses, Oracle Time and Labor, SVN version control, Oracle Forms, Reports, SQL, SQL Developer, MS Excel, XML, PL/SQL, JIRA, Linux, and Oracle 9i, 10g,11g and 12c

Confidential

ORACLE CONSULTANT

Responsibilities:

• Built XML outputs to reflect BOM changes using SQL and PL/SQL on 11g
• Built components/stories of a web based application using Scrum.

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

Confidential

ORACLE PROGRAMMER ANALYST

Responsibilities:

• Built solid relationships to collaborate with Oracle support to resolve any applications issues.
• Supported the approval process for procurement approvals with Oracle e-Business Suite R12
• Production support of Oracle E-Business Suite R12 (Payables, iProcurement, Purchasing, GL, Fixed Assets and Web ADI journal uploads for GL consolidations and other finance processes)
• Process documentation of any changes to the system e.g. adding a new company to the existing chart of accounts and the associated interfaces through Web ADI e.g. the acquisition of a new company.
• Support the approval process for procurement approvals, maintaining approval hierarchies and limits.

Environment: SQL, PL/SQL, Oracle 11g, Workflow, SQL Developer, Toad, HP Service Manager, Oracle Managed Cloud Services environment with Linux, Oracle E-Business Suite R12 (Payables, Cash Management, iProcurement, Purchasing, GL, Fixed Assets and Web ADI

Confidential

ORACLE SYSTEMS ANALYS

Responsibilities:

• Worked on upgrade of Oracle E-Business Suite 11i to Oracle E-Business Suite R12.1.2 on the development team
• Effectively supported Oracle Financials and manufacturing through GL, AP, FA, Cash Management, iProcurement Cost Accounting.
• Completed an American Express interface fix which included the redesign, process documentation and coordination of user acceptance testing, to implementation. (Built, designed and implemented)
• Worked collaboratively to document Accounts Receivable (AR) reconciliation process and verified available reporting that supported oracle standard processes.
• Provided daily production support inclusive of month-end and year-end closing on Oracle e-Business Suite R12 (Process Manufacturing and Financial modules)
• Full support of interfaces, Oracle Financials (GL, AP, FA, AR, CE, iProcurement, Cost Accounting) and Manufacturing (Process Manufacturing). E.g. Banking interfaces for electronic funds transfers on AP
• 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 namely presentation of changes to the CAB, installation instructions, technical design and back out plans.

Environment: Oracle E-Business Suite R12 (GL, AP, FA, AR, CE, iProcurement, Cost Accounting, Inventory, Purchasing ), SQL, PL/SQL, Oracle 11g, Oracle Reports Oracle Forms, Workflow, Toad, HP Quality Center, HP Service Manager, Linux, and AIX.

Confidential

ORACLE DEVELOPER

Responsibilities:

• Production support of E-business suite issues 11i.
• Developed & designed Oracle BI Discoverer reporting for receivables aging receivables using dynamic queries. (PL/SQL and Oracle Discoverer)
• Developed and implemented, journal entry batch custom audit trigger to work with Oracle journal batch approval workflow using workflow and PL/SQL.
• Resolve and log test problem reports with Oracle on E-Business suite issues.
• OBIEE - (BI Publisher, Discoverer) and set up of Excel reporting from the Application Object Library

Environment: Oracle E-business suite release 11i (iExpenses, HR, GL, AP, GL, FA, Cash Management- CE, AR) SQL, PL/SQL, Oracle 11g, UNIX, Oracle Discoverer, Oracle Reports, Toad, Test Tracker, and BI Publisher.

Confidential

ORACLE CONSULTANT PL/SQL DEVELOPER

Responsibilities:

• 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 and back out scripts to bring database to original state during a failed deployment.
• Supported various application modules during QA testing, by analyzing and fixing any software bugs.

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

Confidential

ORACLE SENIOR DEVELOPER, TECHNICAL TEAM LEAD

Responsibilities:

• Provided technical leadership to offshore resources; mitigated performance risks for Human Resource interfaces, Payables, Project Accounting, Install Base, Order Management and Inventory.
• Directed the Oracle Install base data conversion exercise which led to a unified system that included an acquired company’s install base items.
• Utilized effective communication skills with key stakeholders to plan, schedule and managed projects, conducting full life cycle project management to ensure deliveries were on time and within budget.
• Environment: 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, Cash Management, Projects, Install Base, and General Ledger)
• Managed, planned, scheduled, monitored and coordinated an archive project for American Express. 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 and resolved issues as they arose.
• Delivered proposal for an implementation of Compensation and Benefits Workbench. Sections worked on included 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 of R12 and 11i customers
• Developed check print program for Release 12 using BI Publisher on a new implementation of Oracle E-Business Suite R12
• Developed PL/SQL program fixes for custom extensions to Oracle E-Business Suite on R12 and 11i

Environment: 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, Cash Management, Fixed Assets, General Ledger)

Confidential

ORACLE SENIOR BUSINESS SYSTEMS ANALYST

Responsibilities:

• Developed data conversion on the chart of accounts, an account reorganization project that was completed successfully.
• Created feasibility study; analyzed, designed, and developed successful code fix an employee assignment interface programs that were previously deemed irreparable.
• Managed and coordinated the Oracle release 11 archive project.
• Led daily direction of the Timecard Workflow data cleanup project (1 FTE and 1 PTE) (Implemented data cleanup scripts and workflow administration of failed or stuck item processes).
• Delivered production support on the Oracle Release 11i; resolved production support issues, inclusive of code fixes when required.

Environment: 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, UNIX