SUMMARY

• Over 9 years of extensive experience as Oracle Financials Functional Consultant in full life cycle implementation of Oracle 11i/R12 applications, business process analysis, evaluation and integration of internal systems, postproduction support and training to the users.
• Proficient full - fledged End-to- End Implementation, Upgrade, Enhancement and Support projects in Oracle EBS 11i/ R12.
• End-end working knowledge of the Procure-to- Pay (P2P) and Order to Cash (O2C) Cycles.
• Competent in understanding the functionality of the core Oracle Financial modules (GL, AP, AR, FA, CM, PO) and their interplay in the overall accounting structure of an organization.
• Experience in Data mapping from the external source files with oracle EBS columns across the financial modules during interface development and conversions.
• Experience in conducting CRPs, UAT and training for end users and production support.
• Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Knowledge on Project Billing Implementation Checklists including setting up profile and system options.
• Performing business process mapping, Gap analysis and user training. Expertly utilized UPKs for creating documents and training users.
• Authored various documents using AIM Methodology, which includes Business Functional Requirement analysis, Understanding AS-IS & amp; TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing and developing BR 100, MD 50, CV 40,TE 40 documents.
• Extensive experience creating SRs with Oracle Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up, as well as conducting OWC sessions with Oracle Support Team.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through period closing; revenue and Expense cash/accrual concepts; adjustments and financial statements.
• Knowledge of process/data flow, base tables, interface tables and standard APIs.
• Special expertise in integration of self-service or Internet extensions (Internet Expenses, iSupplier, iReceivables and iProcurement) and the impact that changes in one area have on the rest of the system.
• Extensive knowledge in using Oracle AIM of project implementation methodologies.
• Intermediate knowledge of SQl Server, PL/SQL and well versed with IT Productivity tools including MS Office Suite.
• Excellent communication skills and leadership qualities with analytical problem solving.

TECHNICAL SKILLS

ERP Software: Oracle Applications R12, 11i (11.5.10, 11.5.9, 11.5.8), NCA and R10.7 SC (Purchasing, Accounts Payable, Fixed Assets, General Ledger, Accounts Receivable, Federal Administrator, iProcurement, Self Service Purchasing), Application Desktop Integrator (ADI), Financial Statement Generator (FSG) Version UpgradesOther applications Visio 2000, MS Project 2000, Data loader, Discoverer,, Fixed Asset Desktop Integrator (FADI), Power Point 2000, Toad, Issue tracking tools, such as KINTANA, JIRA and Testing Tools such as Rational RequisitePro, ClearQuest, ClearCase, Test Manager V 2002.05.20 , FPD and Mark View systems.

Methodologies: Oracle’s Application Implementation Methodology (AIM), Oracle’s Fast-Forward (Rapid Oracle Implementation Method), Mapping and Gapping Analysis (MGA), Scope and Objective Analysis (SOA).

Languages: Oracle, SQL, PL/SQL, MS SQL Server, RDBMS, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Arlington VA

Senior Oracle Financials Functional Consultant

Responsibilities:

• Documented AP, PO and GL functional specification for interfaces between the legacy systems and Oracle Financials Modules.
• Documented PO functional specification for conversion of data from the legacy systems to Oracle Financials Purchasing.
• Performed mapping requirements for AP, PO and GL interfaces and conversion
• Tracked and resolved issues relating to AP, PO and GL modules
• Worked Business Requirements Analysis, Mapping and Gapping of Requirements, RICE Development, System Design and Configuration, Testing, Quality Assurance, and Training
• Performed AR and AP netting and reconciliation processes
• Developed SQL scripts to extract AP and AR for audit purposes.
• Responsible for report and other PL/SQL fixes that need attention on a priority basis.
• Responsible for resolving various application issues in financial and supply chain modules.
• Prepared SQL scripts for adhoc reports.
• Developed a SQL script to update email preferences when new users are created.
• To provide users with various data extracts as per requirements for various audits and business discussions.
• Developed a PL/SQL script to email details of Purchase Orders created daily from the PO interface.
• Planned and Conducted set up of 1099 Requirements and reporting entities.
• Promoted and Enhanced Knowledge transfer to Subject Matter Experts, Super and End Users

Confidential, Miami FL

Oracle Financials Functional Consultant

Responsibilities:

• Created a custom-tailored implementation plan and rollout schedule for the Higher Education Community
• Designed the FA Segments such as Location, Category and Asset Key and General L edger segments
• Developed and executed FA and PO test scripts and setup documentation
• Conducted FA mass addition, addition of assets via invoice line distribution and set up detail and quick assets
• Promoted and Enhanced Knowledge transfer of PO, FA, AP, GL and AR modules by training the Super and End Users
• Actively Involved the client’s implementation team in decision making regarding the set up and configuration of the following modules PO, FA, AP, GL and AR
• Mentored and Supervised the client’s implementation team and junior consultants in the consultants team
• Provided Post Implementation support to the client’s team after ‘Go-Live’
• Assessed and Managed Project Risks

Confidential, Houston TX

Oracle Account Receivables Consultant

Responsibilities:

• Set up and created customer relationship (Parent/Child relationship), Aging Buckets, Dunning letters in Account Receivables module
• Imported Invoices using Auto-invoice program and applied receipts using Auto-Lock Box
• Managed Project Issues and Escalation Process

Confidential, Fort Worth TX

Oracle Fixed Assets and General Ledger Consultant

Responsibilities:

• Wrote setup documentation and performed setup steps for GL and FA modules
• Coordinated General Ledger segment changes and designed the Chart of Accounts
• Defined business requirements and carried out requirement analysis
• Developed and Executed GL and FA test scripts and prepared environment for Business System Testing (Conference Room Pilot Testing, Unit, Link)
• Solved complex user questions/problems regarding ERP application functionality
• Developed FA and GL reporting requirements
• Developed and maintained effective relationships with clients and cross-functional teams
• Resolved Project Issues on a timely basis

Confidential - Atlanta GA

Functional Oracle Financials Consultant

Responsibilities:

• Coordinated Public General Ledger segment changes and designed the Chart of Accounts to include funds appropriation, apportionment and allocation
• Defined business requirements and carried out requirement analysis
• Wrote setup documentation and performed setup steps for Federal PO, AP and FA modules
• Solved complex user questions and problems relating to Financial and ERP application functionality
• Developed and maintained effective relationships with clients and cross-functional teams
• Gathered business data, analyzed business processes and reporting.
• Developed and executed PO, AP and FA test scripts and performed Business System Testing (Conference Room Pilot Testing, Unit, Link)

Confidential, Delray Beach FL

Functional Oracle Financials Consultant

Responsibilities:

• Implemented Oracle ERP Financial Packages such as Oracle Purchasing, AP and FA
• Recommended and developed automation solutions which maximized cost and benefit relationship
• Mapped, Gapped legacy data and customer functional requirements with Oracle PO, AP and FA
• Provided function managers with an understanding of the capabilities in Oracle Financial Application applicable to their business functions and processes.
• Implemented and performed Business System Testing (Conference Room Pilot Testing, Unit, Link)
• Modeled complex enterprise with basic concepts (Set of Books, Business Entity, Operating Unit and Inventory Organization) of multiple organization in Oracle Applications
• Customized developments, implementations and identified optimization opportunities to improve usage of applications
• Trained and led super-users and end users through all phases of the Project Life Cycle