Resume of Oracle Applications Technical Consultant

Title
Oracle Applications Technical Consultant

Primary Skills
Implementations conversions interfaces team lead design development PL/SQL SQL Reports Forms UNIX Shell Scripts TOAD

Location
Canada-ON-Toronto - GTA

Posted
Feb-24-07

SUMMARY

Applications technical consultant with over 30 years of varying experience in the IT field. Since 1993, I have specialized in implementing, extending and customizing Oracle Financials, Order Management and other applications on UNIX, Windows and Linux based systems.

During my engagements, in both lead and key member rolls, I have participated in the full lifecycle of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, and Support. I interact directly with the client, using my understanding of systems and business processes, to interpret and analyze business requirements, to identify risks and design appropriate solutions that integrate information technology and business process changes to support strategic business requirements.

I also have provided guidance for business decisions from a technical perspective on issues such as: performance, scalability, reliability, and security

From July 1997 to November 2006, I was part of the Consulting group of Oracle Canada, participating in multiple implementations. From 1993 to 1997, I was technical team lead in the successful implementations of Oracle Financials, in the Canadian and Latin American subsidiaries, of a multi-national corporation. Prior experience includes Professional Services, and MIS.


SKILLS HIGHLIGHTS

· Able to clearly articulate and effectively communicate ideas, problems, and solutions with individuals at all levels
· Excellent customer relationship, facilitation, organization, and problem solving skills
· Work well in both leader and key member roles
· Excellent understanding of system, accounting and business processes
· Very good functional understanding of many Applications
· Use my understanding of the data and information needs, of clients, to develop solutions that integrate information technology and business process changes to support strategic business requirements

· Specializations include conversions, interfaces, extensions, customisations
· Technical skills include PL/SQL, SQL, UNIX scripts, Reports, Forms, etc.
· Major Applications include Oracle Financials, Supply Chain, etc.
· Business Flows include Order to Cash, Procure to Pay


PROJECT HIGHLIGHTS

· Provincial Government Multi-ministry Accounts Receivable implementation
· Multi-national capital markets organization , Toronto -- Oracle Financials implementation
· Major U.S. bank, New York -- Oracle A/R Outsourcing
· Large back office service provider, Toronto -- Oracle G/L, FA, PO and Inventory implementation
· Multi-national capital markets organization, New York -- Oracle A/P and F/A implementations
· Canadian provincial government ministry - full Oracle Financials suite implementation
· Major brewery -- Oracle Order Management implementation
· Canadian Health Industry -- Order Management implementation
· Multi-national computer manufacturer - team lead in 7 implementations of Oracle G/L and A/P in Latin America
· Multi-national computer manufacturer - team lead in full suite implementation of Oracle financials in Canadian subsidiary

PROFESSIONAL EXPERIENCE

Oracle Corporation - July 1997 -- November 2006
Senior Principal Consultant, Oracle Consulting


Major Project Details

Details of all projects available upon request.


Multi-national capital markets organization - Toronto

Applications technical lead for implementation of G/L. A/P, PO, CM and F/A

· multi-org
· multiple reporting currencies
· average daily balances

· technical architecture
· conversion standards
· customization design standards
· gap analysis
· integration fit analysis
· customisation program design
· conversion program design
· create conversion programs
· create customisations


Provincial Government

Multi Government Ministry Accounts Receivable Implementation

· Designed and wrote multiple complex conversions and interfaces
· Customers and Invoices for numerous government ministries.


Multi-national capital markets corporation - New York City

· Implementation of Accounts Payable and Fixed Assets.
· Assisted client in design of process to interface invoices, from legacy systems, to Oracle A/P.
· Designed and wrote complex interfaces to feed data from Oracle A/P, F/A and G/L to mainframe systems.
· explode A/P and F/A Journal Entries to detail level to feed external G/L
· extract invoices, payments, etc. to feed to external systems
· Designed and wrote multiple reports for A/P and F/A.
· Assisted client in use of AutoSys automated scheduling tool (Platinum Systems)
· developed method to allow AutoSys to interface with Oracle Financials Concurrent Processes
· developed user guide for client personnel
· trained customer staff


Major Bank - New York City

· Technical lead for multi-org A/R outsourcing 'proof of concept'
· Developed Build Standards.
· Designed and wrote various interfaces
· Prepared test strategy and test scripts.
· Assisted with problem resolutions.
· Provided support for Systems Administration
· Assisted client technical resources


Major Canadian Insurance Company

· Technical lead for implementation of G/L and A/P
· Conversions, Interfaces, Reports, etc.


Major Canadian Brewery

· Order Management Implementation
o Interfaces, reports, etc.


G. Winegarden Consulting - October 1993 - June 1997

Independent Consultant

Technical lead for the implementations of Oracle Financials in the Canadian and Latin American subsidiaries of Unisys Corporation

November 1993 - December 1994

Led the application technical group during the successful implementation of General Ledger, Accounts Payable, Purchasing, Accounts Receivable, and Fixed Assets level 9.4.2, in the Canadian subsidiary. Major responsibilities also included assisting the business users in mapping their business requirements to the new applications and setting up the modules. Guided the technical team in the development of interfaces, conversions, reports, Alerts, triggers, FlexFields etc. for the various modules. Designed and wrote numerous interfaces, reports, triggers, etc. for A/P, G/L, PO, A/R and R/A.

January 1995 - December 1996

Performed the application technical implementations of General Ledger and Accounts Payable for seven Latin American subsidiaries. Again concentrated on assisting the business users in mapping their requirements and developing interfaces, conversions and reporting extensions. In total, participated in seven General Ledger and five Accounts Payable implementations during this period.

January 1997 - March 1997

Designed and wrote various interfaces and reports for Corporate Head Office Oracle Purchasing system.

April 1997 - June 1997

Participated in initial stages of project to convert Oracle Financials level 9.4.2 to level 10.7.


Unisys Corporation - June 1971 - September, 1993

Held varied positions with Unisys Corporation, Canada (formerly Sperry Inc.)

Professional Services Consultant

Assist clients in software implementations on Unisys hardware, specialising in operating systems installations and upgrades.
Assist clients with software issues including trouble reports, performance analysis, and selection of software and hardware.

Manager, Branch 1100/2200 Series Professional Services

Coordinated group of technical consultants specialising in operating systems and data base support, for clients.

Supervisor, Technical Support, MIS

Supervised group of seven technical and applications programmers responsible for writing applications programs and technical support of in-house computer systems for Canadian Head Office.




SKILLS SUMMARY

Oracle Financials Applications· General Ledger · Accounts Payable · Accounts Receivable · Fixed Assets· Purchasing· AOL · SysAdmin Other Oracle Applications· Order Management · Inventory · Human Resources · Cash Management · Contracts· Incentive Compensation· Warehouse Management
Databases· Oracle 7, 8, 8i, 9i, 10i Tools· TOAD· Developer 2000· SQL Developer· Java Developer
Operating Systems· HP-UX· Sun Solaris· IBM AIX· Unisys · Windows NT· Windows 2000· Linux Programming Languages · PL/SQL· SQL*Plus· SQL· UNIX / AIX / LINUX Shell Scripts · SQL*Loader · Oracle Reports · Oracle Forms· Workflow· COBOL· C
Engagement Experience· Requirements Gathering · Applications Development· Fit/Gap Analysis· Design· Data Conversion· Interfaces· Extensions· Customisations· Testing· Standards Development · AIM Methodology Oracle Specific Training· PL/SQL · PL/SQL Functions and Procedures· SQL and SQL*Plus· Advanced SQL· Oracle Reports· Oracle Forms· Extending Applications with Forms· Systems Administration 11i · Oracle General Ledger 11i· Oracle Accounts Payable 11i· Oracle Accounts Receivable Release 11· Oracle Cash Management Release 11· XML· Oracle Web Server - Develop Applications using PL/SQL· Oracle Internet Procurement Workshop· Oracle Web Server Administration· Oracle Discover 3 · Oracle Financials Technical Foundations· Define FlexFields· Oracle Workflow· Data Warehouse Workshop· Oracle 8 DBA· Java


REFERENCES

Upon Request

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-ON-Toronto - GTA »
View all resumes in Canada-ON »

View other Oracle Applications Technical Consultant resumes, Programmer / Developer resumes