IT/STRATEGIC SKILLS

• Certified Public Accountant (CPA) and Functional Analyst having ten years experience on Business Application Analysis, Customization and Implementation.
• Extensive exposure to Software development life cycle processes, including requirements, process re-engineering, systems specifications, program specifications, testing and systems and end-user documentation.
• Experience on business analysis, solutions design & implementation process and Production support.
• Good working knowledge of Applications Implementation Methodology (AIM).
• Experience in the preparation of Test Scripts, Training documents and End user and Super user training.
• Performing CRP and UAT.
• Familiarity with Database concepts and SQL.
• Knowledge and exposure in Oracle Accelerator.
• Overview of Oracle Financials R12.
• Strong communication, presentation and interpersonal skills.

SIGNIFICANT ACCOMPLISHMENTS

• Deployed Oracle 11i ERP Business Flows for clients like Fuji Xerox, Petra Foods and SIIX Corp.
• Extensive experience with Financial and Distribution modules of Oracle 11i. Full life cycle Oracle Implementation experience and production support in GL, AP, AR, FA, Cash Management.
• Managed, consulted and trained clients and co-workers on Oracle Applications projects. Hired, trained and mentored associates.
• Managed all implementations with high degree of client satisfaction. Projects were completed on schedule and met all utilization and profitability targets
• More then seven years plus experience working with onsite/offshore model

TECHONOLOGIES/TOOLS/METHODOLOGIES

Methodologies used include Oracle AIM, Rapid Return on Investment (R2i)
Oracle Applications: Oracle Applications 11i/11.x/10.7, GL, AR, AP, FA, Cash, Project Billing, PO, OM, INV, Federal Financials and Systems Administration

Software: Oracle 9i/8i/8.x, Reports 6i/3.0/2.5, PL/SQL, SQL*LOADER, SQL*PLUS

Programming Languages: SQL, and PL/SQL

RDBMS: Oracle 10g/9i/8i/8.x

Operating Systems: Sun Solaris, Win XP, NT, Windows 95/98

Work Experience:

Dec. 01/08 –Till Date

Functional Consultant of Oracle Application 11i – Confidential

Oracle Financials Functional Consultant

• Responsibilities:
• Provide functional support in production environment particularly in the GL(General Ledger), AP(Accounts Payables), FA(Fixed Assets) and Purchasing modules
• Performed configuration of the GL, AP, FA, Purchasing and Cash Management modules for one set of books for UAT and Production environment.
• Prepared the BR100 for each of the modules configured (GL, AP FA, CM and Purchasing)
• Defined the different user responsibilities for the implementation of the new set of books and assigned the profile system options for each of the responsibilities created.
• Provide users with their needed responsibilities in each module.
• Handle SRs in Oracle Metalink by corresponding with the Oracle Support group.

Environment: Oracle Applications 11i, SQL*PLUS
Modules: GL, FA, AP, Purchasing, Cash Management and System Administrator

Feb. 21/08 – Nov. ‘08

Functional Consultant of Oracle Application 11i, Confidential

Oracle Financials Functional Consultant

• Responsibilities:
• Provide functional support by performing comprehensive testing in the various projects involved under the FSA FMS Enhancements team like: DB Upgrade, Metrics Performance Monitoring Tool, Oracle Applications Tablespace Model (OATM) Implementation and FMS FY2004-FY2006 Archive Project. Comprehensive testing were done in the different Task Areas wherein customizations were applied in the GL(General Ledger), AP(Accounts Payables), AR(Accounts Receivables) and Federal Administrator modules using the IT, UAT, Paygov and Devcom environments.
• Prepared the revised Test scripts template used in the OATM Implementation testing and FMS FY2004-FY2006 Archive Project.
• Provided assistance in the updating of the PEP and Metrics Production Handbook manuals.
• Performed the checking in of the OATM Implementation project in the ClearQuest tool and checking in of the FMS FY2004-FY2006 in ClearCase tool.

Environment: Oracle Applications 11i, SQL*PLUS

• Modules: GL, AR, AP, Federal Administrator

Jun 2007 – Feb. 19/08

Implementation and support of Oracle Application Confidential.

Oracle Consultant

Confidential is a global software solutions company providing enterprise-wide solutions for the Marine, Education and Utility sectors. Since its inception in 1990, the company has demonstrated a first-rate growth to emerge as the global leader in its markets.

• Responsibilities:
• Performed various functional Setup steps and configuration for GL (General Ledger), AP (Accounts Payables), AR (Accounts Receivables). Assets and Project Billing.
• Provide functional support to end users of Project Billing, General Ledger, Accounts Payable and Accounts Receivable.
• Supported in configuring Multi-Org environment for Business Group, Legal Entities, Operating Units and Set of Books
• Develop and execute specific functional test processes for various Oracle modules
• Done business process design, Oracle configuration and debugging of Oracle Financial applications and production support.
• Responsible for issue resolution, escalations, Tar Support, supporting Development, String tests and CRP Test Cycles.
• Provided functional support in production environment for GL, AP, AR and Project Billing modules.
• Developed Oracle FSG reports for financial statements analysis and reconciliation.

Environment: Oracle Applications 11i, PL/SQL, SQL*PLUS

• Modules: GL, AR, AP, FA, Project Billing

Apr 2007 –May 2007

Implementation and support of Oracle Application Confidential.

Oracle Consultant

Confidential. provides IT hosting, outsourcing and professional services leveraging a proven set of technologies and extensive subject matter expertise. Role is to configure Oracle Financial modules such as GL, AR, AP and implement the functional requirements for Hudson Valley Hospital on Oracle Applications 11i using Oracle Accelerator.

Responsibilities:

• Captured business requirements
• Involved in GAP analysis – identified gaps between oracle functionality and business requirements.
• Performed various functional Setup steps and configuration for GL (General Ledger), AP (Accounts Payables) and AR (Accounts Receivables)
• Supported in configuring Multi-Org environment for Business Group, Legal Entities, Operating Units and Set of Books
• Develop and execute specific functional test processes for various Oracle modules
• Developed Oracle FSG reports for budgeting, analysis and reconciliation.

Environment: Oracle Applications 11i, PL/SQL, SQL*PLUS
Modules: GL, AR, AP

Feb 2006 – Mar 2007

Implementation and support of Oracle Application Confidential

Oracle Consultant

Confidential is a worldwide Document Company, which builds, distributes, and supports machines such as laser printers, copiers, and production printer systems. Role is to configure Oracle Financial modules such as GL, AR, AP and implement the functional requirements for Fuji Xerox on Oracle Applications 11i .

Responsibilities:

• Captured business requirements
• Involved in GAP analysis – identified gaps between oracle functionality and business requirements.
• Performed various functional Setup steps and configuration for GL (General Ledger), AP (Accounts Payables), AR (Accounts Receivables), Cash Management and Fixed Assets.
• Supported in configuring Multi-Org environment for Business Group, Legal Entities, Operating Units and Set of Books
• Provided functional support in Production environment for GL, AR and AP modules.
• Attribute Mapping and Functional Specifications for Data Conversion Programs related to AR, AP and GL modules.
• Involved in creating functional specs and designing new reports, testing, modifying existing reports both in legacy systems and Oracle Applications
• Developed Oracle FSG reports for budgeting, analysis and reconciliation.
• Developed and implemented cross validation rules and provided Production support.
• Extensively worked with ADI in defining complex column sets, reports and uploading of journals accounts.
• Used accounts hierarchy manager in defining new chart of accounts.
• Supported business for month end and quarter end closing.
• Supported AP with changes in bank accounts, payment methods.
• Supported AR with Revenue Recognition processing and other AR functionalities including customers set up and entry, transactions entry, reporting, multi-org and GL - multi org, set of books, multi currency, global consolidation.
• Worked on integration of AP with GL.
• Extensively worked on journal import programs and validation and corrections.
• Develop and execute comprehensive test plans for Oracle financial applications.

Environment: Oracle Applications 11i, PL/SQL, SQL*PLUS
Modules: GL, AR, AP 

Aug 2005 – Jan 2006 Implementation and Support of Oracle Application Confidential.

Oracle Consultant

Confidential. principal activities are the manufacturing and marketing of industrial cocoa ingredients, chocolate confectionaries and investment holding. Role is to do setup of the Oracle Financial modules such as GL, AR, AP, FA and Cash and to do implementation and conduct training to end users.

Responsibilities:

• Configuration owner for Oracle Financial modules such as GL, AP, AR, FA, Cash
• Responsible for capturing configuration requirements for GL, AR, AP, FA and Cash modules.
• Responsible for issue resolution, escalations, Tar Support, supporting Development, String tests and CRP Test Cycles.
• Developed functional specs and designed customized reports as required by users particularly in the AR and AP modules.
• Created financial statement reports using FSG in GL
• Supported AP with changes in bank accounts, payment methods.
• Supported AR with Revenue Recognition processing.
• Provided Production support in Oracle Financial modules like GL, AP, AR, PO iProcurement and Cash Management.
• Develop and execute comprehensive test plans for Oracle financial applications

Environment: Oracle Applications 11i, PL/SQL, SQL 
Modules: GL, AR, AP, FA, Cash, PO, OM

Jul 2004 –Jul 2005

Implementation & Support of Oracle Application Confidential

Oracle Consultant

Confidential. is one of the world leading producers of oleochemicals wide range of products all derived from natural resources which are used in variety of applications. Involved as a functional lead for the GL, AR, AP, FA and Cash implementation. Responsibilities included: Proof of concept, Gap analysis, solution design, testing and implementation.

Responsibilities:

• Involved in implementation of Oracle Financials 11i
• Responsible for Business requirements, Gap Analysis, Solution Design and UAT
• Financial modules setups and configuration
• Part of Steering Committee, managing priorities, tracking deliverables and milestone assessments etc.
• Responsible for issue resolution, escalations, Tar Support, supporting Development, String tests and CRP Test Cycles and Production instance.
• Supported AR with Revenue Recognition processing and other AR functionalities including customers set up and entry, transactions entry, reporting, multi-org and GL - multi org, set of books, multi currency, global consolidation.
• Worked on integration of AP with GL.
• Develop and execute comprehensive test plans for Oracle financial applications

Environment: Oracle Applications 11i, PL/SQL, 
Modules: GL, AR, AP, FA, Cash

Mar 2003 – Jun 2004 Implementation and support of Oracle Confidential

Oracle Financials Consultant

Confidential is one of the biggest telecoms company in the Philippines. It uses Oracle Applications in its business process and they have upgraded their Oracle application from 10.7 to 11i. Role was to implement the functional and technical requirements in Bayan Telecoms on Oracle 11i including AP, FA, PO and INV.

Responsibilities:

• Project Implementation: Implemented milestones like CRP’s, UAT and deliverables like Business Requirements, Functional Specification and Design docs. Issue Tracking and TAR escalation with oracle support and development.
• High Level Design: Collecting requirements as Business Requirements Document, suggesting the Functional Design and Process Flow as Functional Specifications Document.
• Active Participation in different phases of CRP1, CRP2, UAT, Production Cutover, Cutover Support.
• Develop and execute comprehensive test plans for Oracle financial applications.
• Functional Specifications for Payables, Purchasing and Inventory customized reports
• Involved in Setups for GL, AP, AR modules.
• Provided functional support in Production Environment in AP, GL and FA modules.
• Setup Flexfields, Profile Options, QuickCodes and other setups
• Attribute Mapping and Functional Specifications for Data Conversion Programs related to Inventory module.

Environment: Oracle Applications 115.9, GL, AP, AR, FA, PA, INV, PO, PL/SQL, SQL*PLUS, SQL*LOADER, Reports 2.5/6i

Nov 2001 – Feb 2003

Implementation and support of Oracle Confidential.

Oracle Financials Consultant

Confidential. manufactures and markets wearable particularly leather footwear, clothes and leather bags. Role is to configure Oracle Financial modules such as GL, AR, AP, FA and implement the functional requirements for Conqueror International on Oracle Applications 11i.

Responsibilities:

• Project Implementation: Implemented milestones like CRP’s, UAT and deliverables like Business Requirements, Functional Specification and Design docs. Issue Tracking and TAR escalation with oracle support and development.
• High Level Design: Collecting requirements as Business Requirements Document, suggesting the Functional Design and Process Flow as Functional Specifications Document.
• Active Participation in different phases of CRP1, CRP2, UAT, Production Cutover, Cutover Support.
• Functional Setups for GL, AP, AR, FA Modules.
• Develop and execute comprehensive test plans for Oracle financial applications.
• Provided functional support in Production Environment for Project Accounting, AP, GL and FA modules.
• Involved in Issue Resolutions and Cutover/Production Support.

Environment: Windows, Oracle Applications 11i, GL, AP, AR, FA, FSG, PL/SQL, SQL*PLUS, Reports 2.5/6i

May 2001 – Oct 2001

Implementation and support of Oracle Confidential

Oracle Consultant

Confidential is a Certified Oracle Partner that offers various Oracle services to its various clients. Role is to do analysis of the clients reported issues and take appropriate action on the issues. It involved resolving functional issues, issue tracking and TAR escalation to Oracle support group and coordination with Oracle support group for TARs escalated thru Oracle Metalink.

Responsibilities:

• Analysis and simulation of the problem from both technical and functional perspective and providing necessary solutions to the customer.
• Interacting with the client to identify the problem
• Resolving implementation & post implementation problems in the Production Environment faced by the clients and consulting companies world wide.
• Analyzing the client logged issues & doing the code changes, enhancements, etc. if required
• Coordinating with other divisions of Oracle such as Consulting for timely and efficient resolution of the issue.
• Provided training to functional experts on Payables and General Ledger Modules as part of in-house skill development process at Oracle.

Worked on Following Modules:

• General Ledger
• Accounts Payable
• Accounts Receivable
• Interfacing with Inventory and Receivables

Conducted Training Sessions on the above functionality and also attended to clients logged issues.

Environment: Oracle Applications - GL, AP, AR, PL/SQL, Oracle Database, Sun Solaris, Windows

Education:

• International Diploma in Computer Studies
• B.S. Commerce, Major in Accounting