PROFESSIONAL SUMMARY

• Over 10 years of experience in IT industry as Oracle Apps Functional Consultant with exposure to Oracle Financial Functional Modules (AR, AP, GL, FA, Cash Management, SLA, E - Business Tax) Have closely worked with Financial Functional Users and Implementation teams in successfully translating business requirements into functional specifications and deliverables. Results driven software professional with an excellent record of delivering complex technology and creative solution by using a practical, pattern-based approach to achieve stated objectives within limits of time, budget and client’s satisfaction.
• Expertise in the business process review, re-engineering, change management and full life cycle implementation and upgrade of Oracle EBS: GL, Lease and Finance Management (OLFM), AP, AR, Assets, Collections, SLA and Cash Management and Payments
• Excellent exposure of having worked on wing-to-wing implementations delivered on onsite solution delivery model and offshore based delivery model.
• Actively involved in various stages of implementation like capturing business requirements, Gap Analysis, Module Setup, Business Analysis, Upgrade, Application Design, Conversion and Interface Design, Handling TARs and Documentation using AIM3.0.
• Experience with Taxware (Vertex, Sabrix), OnGuard and Markview 170 Systems.
• Worked in Full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment
• 3+ years of accounting and auditing experience.
• Good command on SQL, PL/SQL and Toad for database access.
• Worked on Oracle Applications versions R 12/11.5.10/11.5.9/11.5.5/11.0.3.
• Experience in Oracle Applications upgrade from 11.5.7 to 11.5.10
• Experience in Solaris to Linux Migration Project planning and execution
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team-oriented environment. 
• Worked for end-user’s support, troubleshooting and giving effective & efficient resolutions for the technical and functional issues
• Worked as a liaison between finance and technical team
• Acted as a Team Lead in multiple projects
• Strong on Functional documentation for Configurations (Setups), User Training Documents and Customization Documents.
• Expertise on all design documents (CV 60/CV065/MD050/MD070/MD0120/TE020/MD 130/MD 200/CV80).

TECHNICAL SKILLS

Domain: Financial, Supply Chain, Discrete Manufacturing

Oracle Apps Modules: Account Receivables, AGIS, e-Business Tax, Lease and Finance Management (OLFM), Vertex, Account Payables, General Ledger, Inventory, Purchase Order, Order Management, AOL, Oracle Alerts, System Administrator, Application Developer, Fixed Assets, Pricing.

Databases: Oracle data base 8/9i/10g/11g/12g

Operating Systems: Sun Solaris, Windows, Unix, Linux

Business Skills: Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD Sessions, Gap Analysis, and Impact Analysis., Epicor experience.

Methodologies: OUM, AIM, Waterfall, Agile

Modeling & Designing Tools: Rational Rose and MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Oracle Financials Functional Consultant

Responsibilities:

• Implementation and support of Oracle e-Business Suite Release 12 (Lease and Finance Management (OLFM), AR, AP, GL, FA, Sub Ledger Accounting, e-Business Tax)
• Testing the existing modules setup for inconsistencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Analysis, design and implementation of seamless integration between 3rd Party systems and Receivables.
• Assisting in developing and testing custom programs.
• Worked on the end to end Lease Life Cycle Management in OLFM - like Booking, Funding, Invoicing, Receipt Application, Accruals and Non Accruals, Loss Provision, Rebooking, Renewals, Release and Lease Termination.
• Worked on Lease Contract Authoring, Lease Booking and Lease Funding in Oracle OLFM
• Worked on Rebook, Transfer and Assumption, Renewal of Lease, Release of Lease, Upgrade of Lease in Oracle OLFM
• Worked on the setups of OLFM like - Lease and Finance management accounting options, account method builder, lease and finance management event model, accounting sources, default account codes for OLFM, SLA Rules for OLFM, etc.
• Worked on the Revenue Recognition process in AR Module - setting up Accounting and Invoicing rules, defining the daily revenue rules, setting up Customer Acceptance process, deferred revenue, deferred COGS process, etc.
• Worked on the configuration of the Advance Collections module - defining the scoring engine parameters, scoring rules, customer classification, delinquencies quick codes, etc.
• Worked on the setups of the Accounts Payables module including the setup of the Payment Manager
• Developed several enhancements to the Business Processes on the Financials side.
• Worked on the Support of Vertex with Oracle AR and AP modules.
• Developing Business Intelligence Reports and FSG Reports using Oracle Report Manager and Insight Reporting Software
• Provide Training and UAT and Additional Business Requirements sessions
• Implementing and testing of VERTEX - Q series.
• Support production environment and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems

Environment: Oracle Fusion Financials Release 9 (GL, AR, AP, Advance Collections, I-Expense, PO, FA, CE, AGIS, AME, e-Business Tax, OM, Contracts), Oracle 10G, VERTEX - Q series, Oracle Discoverer 10, Data loader, TOAD, INSIGHT Reporting

Confidential, Columbus, OH

Oracle Financial Functional Consultant

Responsibilities

• As a Functional Consultant implemented the business flows including AR, e-Business Tax, AP, GL and Cash Management modules.
• Performed Requirement and Gap analysis.
• Worked on the setups of e-Business Tax and Vertex module - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Worked on the credit card integration to accept PayPal Payments and Visa Credit Card payments.
• Worked on the integration of Oracle e-Business Tax with Vertex module.
• Configurations and Setups for AP, AR, GL and Cash Management modules
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle E-Business Suite 11.5.5/12.1.3 , Oracle DB 10.2.0.3.0 , Load Runner, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, MS-Office

Confidential, Emeryville, CA

Oracle Finance Functional Consultant

Responsibilities -

• Have Created GL Allocation Entries and performed varieties of GL Allocation entries as following.
• Net Allocations
• Step Down Allocations
• Rate Based Allocations
• Usage Based Allocations.
• Application Consultant in Oracle Financial R12 modules, involved in the implementation and customization of Oracle Applications for client.
• Extensively involved in set-up and customization of Oracle General Ledger, AGIS, Account Payable, e-Business Tax, Cash Management, Fixed Assets, Purchasing, and Order to Cash Management.
• Configured all the General Ledger, Payables, Fixed Assets and I-Expense set-ups in the test instance.
• Created extensive joins for data blending from several different data sources
• Worked on the setups of the Oracle e-Business Tax module – setting up rates, regimes, rate to regime flows, tax rules, tax exemptions, tax exceptions, etc.
• Participated in discussions with the client and cross-functional groups regarding the business process and requirements, performing Fit-Gap analysis, proposed solution and design for customization and the migration strategy, Preparation of Setup Documents, Design Document & Test cases using AIM methodology.
• Involved in setting up Chart of Accounts, Reporting Currency, Legal Entity, Ledgers, and Sub-ledgers.
• Worked on creating the Items for the Inventory set up for R12.
• Setup of Payable and Financial Options for Oracle Payable, System Options for Receivables, Setups for Transactions for Payables and Receivables, Bank Account setups
• Involved in the set up of purchasing option, receiving option, Position hierarchies, Approval hierarchies, control groups, Approved Suppliers List, Sourcing Rules.
• Developed specs for custom AR aging reports, workflow notifications to respective users as per the aging due dates from respective vendors.
• Have write, validate and execute the test scripts.
• Worked on configuring the production Environment.
• Studied current business processes, future business flow and identification of gap / workaround in order to provide an integrated order to cash business flow to meet the business needs of the group.
• Prepared Mapping document BR030 and setup document BR100 for AP and PO modules
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management.
• Creating and Updating Functional Design Specification documents (MD60/ MD65) based on BR100 on payroll.
• Participated in the design of Chart of Accounts and did the Set up of Recurring Journals, Stat Journals &Mass Allocation Journals. Trained end users in Financial AR, AP, GL, FA and CE and HRMS (Employee and Payroll) also created detailed user manual.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Designed & developed training material and undertook training for all levels of users on new functionalities configured.

Confidential, Emeryville, CA

Oracle Financials Functional

Responsibilities -

• As a Functional Consultant implemented the following modules: AP, AR, AGIS, GL, FA, Cash Management modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, FA, AGIS, Cash Management and GL modules.
• I-Procurement – Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle GL, Cash Management, AP, AR, AGIS, OM and PO from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure by creating new Business Group, Legal Entity, Ledgers (primary and secondary) and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AP, AGIS, FA, Cash Management, INV and PO Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Mountain View, CA

Finance Functional Consultant

Responsibilities

• Worked on the entire Finance Functional Flows AR, AP, GL
• As a Finance Functional Consultant implemented the following modules: AR, AP, GL
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, GL modules
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in AR, AP, GL Modules.