SUMMARY

• Oracle Apps Associate with more than 6 years of experience in with Oracle E - Business Suite in a variety of business environments.
• I have performed requirements gathering, configuration, interface design, conversions, application testing and production support.
• My experience includes support for GL, AR, AP, FA and CE track along with good exposure of Procure-to-pay, Order-to-Cash business flows.
• My strong quantitative and qualitative analytical skills provide capability in all areas of Project Management, Implementation, Development Support, Training and Go Live support.
• Oracle Apps Finance-Functional Consultant primarily working on Oracle 11i & R12 Financials modules like AP, AR, FA, CE, GL, PO and System Administration.
• Extensively Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Very Good Functional knowledge in Oracle Applications Financials such as (GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), Sub Ledger Accounting (SLA), RevRec.
• Strong implementation knowledge of Oracle Business Flows (Procure to Pay and Order to Cash), Solution design and Business Process Mapping.
• Strong understanding of Agile, Waterfall and Systems Development Life Cycle (SDLC) process.
• Experience in analyzing data and translating business requirements into technical specifications.
• Knowledge of Low-level ad-hoc query tools such Oracle SQL* Loader, SQL Plus and a working knowledge SQL queries.
• Extensive experience Accounting Operations, Accounts Payable, Payroll, and End to End business processes.
• Extensively worked in implementing RICE (Oracle Reports 10g/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, XML Publisher and Discoverer Reports.
• Expert Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Extensively worked in implementing RICE (Oracle Reports 10g/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, XML Publisher and Discoverer Reports.
• Knowledge of Low-level ad-hoc query tools such Oracle SQL* Loader, SQL Plus and a working knowledge SQL queries.
• Strong familiarity with AIM methodology in creating MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
• Proven ability to quickly learn and apply new technologies with strong technical background
• Self-Starter, ability to manage multiple tasks at once and a work ethic based on a strong desire to exceed expectations and to clearly communicate complex concepts and implement ideas in a fast paced environment.

TECHNICAL SKILLS

ERP: Oracle EBS R12, 11i

Modules: GL, AP, AR, FA, RevRec, OM, PO, CE, OM, I-Proc, I-Expense, O2C, P2P, Purchasing

Technologies: Oracle Forms, Oracle Reports, XML Publisher, Workflow, Discoverer Plus, OBIEE, FSG Reports, Salesforce, Web Development Technologies, Oracle Data Integrator and Structured Systems Analysis.

Tools: Oracle 11/10g, Toad, SQL* Plus, SQL*Loader, Data Loader, Load Runner, ADI, SQL

Languages: SQL, PL/SQL, UNIX Shell, Java, VB, HTML, XML, Web forms, Reports, Web Servers

Office Suite: MS Word, MS Excel, MS Outlook, MS Access, MS Visio, MS SharePoint, Microsoft Team Foundational Server (TFS)

PROFESSIONAL EXPERIENCE

Oracle EBS Techno Functional Consultant

Confidential, Billerica, Massachusetts

Environment: - Oracle ERP Applications 12.1.3, Oracle Hyperion Cloud

Responsibilities:

• Lead implementation of Oracle enhancements: gathered business requirements, created functional design documents, lead testing, created documentation and worked with business to direct successful deployment into production environment for Oracle enhancements covering various financial modules (GL, AP, AR, PO, FA)
• Improving business processes and support critical business strategies by leading the development, implementation, and maintenance of business applications systems.
• Created Discover Reports and Customizing FSG Financial Reports and other non-seeded reports, and ad-hoc reports and analytics.
• Preparing 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 Salesforce.
• Managing multiple projects and coordinate with developers to ensure that specifications are met and functionality is rigorously tested prior to implementation.
• Working with business customers, developers and Oracle Support to research, document and resolve Oracle system issues.
• Performing module specific configuration duties for implemented applications to include establishing role-based responsibilities for user access, administration, maintenance and support.
• Working closely with key stakeholders for new Implementation of Oracle Hyperion Cloud which involves responsibility for budgeting, financial modeling, ad-hoc reporting and improvement of reporting tools and processes.
• Working closely with internal business units to understand business drivers and objectives which can be enabled through effective application deployment.
• Prepared all documentation and led Conference Room Pilot (CRP) and User Acceptance Testing (UAT).
• Met with project steering committee weekly to coordinate business procedure changes & change approval process.
• Performed business/technical analysis and problem solving to identify and resolve technical and functional issues. Documented all solutions for Operations to implement.
• Provide effective communication regarding issues, objectives, initiatives and performance measurements against set plans.
• Ability to work in agile development environment, collaborating with the teams to drive earlier defect detection.
• 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.
• Support Production issues on a day-to-day basis including month end closure p1 issues.
• Worked on a GAP Analysis and prepared functional documents for the GAPs identified
• As part of Production Support team was involved in supporting the users for issues with performance, data and training. Also Involved in support the month end and quarter end process including helping reconcile and fixing of interface issues.

Oracle Finance Functional Consultant

Confidential, San Francisco Bay Area, CA

Environment: - Oracle EBS 12.1.3, Oracle Database 11g

Responsibilities:

• Involved in activities of production support of Oracle applications environment in AP, PO, AR, Cash management, Fixed Assets, Order Management and GL.
• Involved in month end processes for journals, SLA, Recurring and Reports with subsequent accounting. Proficient on various modules (AP-Accounts Payables, AR-Accounts Receivables, PO-Purchase order, GL-General Ledger, Sub Ledger Accounting, CE-Cash Management, Fixed Assets, Order Management and Iprocurement).
• Lead UAT for Fixed Assets and debug report performance and data related issues and provide progress updates to project team for daily stand-up meetings.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Payables, Purchasing, Inventory and Fixed Assets Module.
• Formulated solution design and implemented strategy based on client requirements. Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts
• Managing multiple projects and ensure that specifications are met and functionality is rigorously tested prior to implementation.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Queried SQL/PLSQL codes for testing and verification of data into the database and for other related investigations.
• Prepared MD050, TE40, CRP execution, User training and coordinating with technical teams on Oracle Apps.
• Responsible for developing Oracle Discoverer reports based on the modules like Purchasing, General Ledger and Receivables.
• Partnered with Procure to Pay (P2P) team to perform integration testing and system validation for new enhancements and deployments within iProc, PO, Payables Module.

Oracle O2C Functional Consultant

Confidential

Environment: - Oracle EBS R12, Oracle Database 10g

Responsibilities:

• Participated in Oracle apps R12 implementations in multi org/multi-currency scenarios, Order management and worked as areas involving Pricing, iprocurement, and Inventory.
• Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CE, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.
• Worked on the entire Order to Cash business process.
• Performed all of the setups for OM, INV, Advanced Pricing, i-Procurement, PO, AP and GL.
• Developed several enhancements to the Business Processes on the Order to Cash side.
• Implementation and support of OM, INV, Advanced Pricing, Purchasing and Account Payable Module.
• Worked on the setups of Positional Hierarchy Approval Hierarchy in Oracle Purchasing.
• Worked on defining the Purchasing and Receiving Option in Oracle Purchasing.
• Defined Buyers and setup their roles in Oracle Purchasing.
• Setup Advance Pricing to define Price Breaks, Modifiers, Qualifiers, Setup Price lists for different currencies, worked on defining attributes to be used in Pricing, defined automatic discounts, surcharges in Advance Pricing module.
• Worked on the integration of Purchasing with i-Procurement module.
• 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.
• Worked on a GAP Analysis and prepared functional documents for the GAPs identified
• Implemented TCA in Oracle AR Module.