SUMMARY:

• I have 9+ years of Oracle 11i and R12 Finance Functional comprehensive experience in different areas of End - To-End Implementation, Enhancements, CR’s and Upgrades, System Configurations/Setups, Customizations (Reports/Forms), Personalization’s, Development, Production Support, Data Conversion, Data Migration of Oracle Application modules like Oracle General Ledger, Oracle Payables, Oracle Receivable, Cash Management, Fixed Assets, e-Business Tax, Sub-Ledger Accounting (SLA), Multi-Org Concept (MOCA), Application Desktop Integrator (ADI), AIM Methodology, Procure-To-Pay (P2P), Order-To-Cash(O2C), Purchasing, Inventory, Order Management, Human Resource(Core HR)
• Strong familiarity with AIM methodology in creating BRD, RD-20, BR-100, MD-50, MD-70, BP-80, MOM throughout multiple Projects.
• Requirement gathering from the business users and prepared current business base line and business scope documents using life cycle implementation standards with Oracle AIM Methodology.
• Configured Primary and Secondary Ledgers in finance.
• Prepared functional design specifications for solution development by using Oracle standard practices and methodologies.
• Maintained Sub-Ledger Accounting process (SLA)
• Maintained Payments for cash disbursements.
• Maintained 1099 Suppliers where suppliers should use 1099 form for tax filing purposes at end of the calendar year.
• Providing Month-End, Quarter-End and Year-End Period close Process.
• Maintained Multiple OU’s, LE’s and Multi-Currency
• Skilled in eliciting user demands and translating them to data, functional and usability requirements.
• Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS), Data Dictionary, Workflows.
• Strong functional expertise in Procure to pay (P2P) process and exposure to Order to Cash (O2C) in flow Oracle finance.
• Experience of set up, configuration, documentation and coordination of CRP and UAT testing with users of respective modules.
• Mapping interface tables between oracle application and third party legacy system
• Prepare technical templates for data migration from legacy system to oracle application system.
• Providing extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables on-time.
• Experience in working upgrade projects in Oracle 11i to Oracle 12.1.3
• Knowledge/understanding i-Receivables, Receivable Collections
• Understanding TCA (Trading Community Architecture)
• Highly motivated and self-driven for timely target .
• Excellent written and oral communication skills with a results-oriented attitude.
• Strong analytical and problem solving skills in overcome the trouble shoots on day-to-day production support.
• Skilled in various MS Office tools including MS Visio.
• Co-ordinate with offshore team to accomplish the milestones as per project time line.
• Effective time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs coordinating to the varied needs of the people involved.
• Experience in reviewing Test Procedures, defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Multi-task oriented with strong work ethics and ability to work effectively in a team or individually.
• Oracle SR’s for Data Fix, Bugs and Patches to resolve issues on high priority P1 (24/7)
• On call production support for day to day issues at Period and Quarter End Closing process.

TECHNICAL SKILLS:

Environment: 11.5.9, 11.5.10.2, R12.1.3 and R12.2.4

Other modules: System Administration, Application Object Library (AOL), Oracle Diagnostics, User Management, Legal Entity Manager

Data Base: Oracle PL/SQL 9i/10g/11g

Tools: Data Loader, TOAD, ADI

Oracle R12: R12 Oracle General Ledger and Accounts Payables

Oracle Cloud Financials: Trained on Oracle Cloud Financial Functional

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Solution Architect

Environment: Oracle 12.1.3 (General Ledger, Payables, Receivables, Fixed Assets, E-Business Tax, Sub-Ledger Accounting, ADI, Procure-To-Pay, Order-To-Cash, Sys Admin, Vertex)

Responsibilities:

• Gathered and Prepared Business Requirement Documents (BRD) for Journal Approval and Invoice Approval Management Engine (AME)
• Defined required setups and done testing as per standard application for new functionalities in test instance.
• Prepared test cases and scripts against new functionality and enhancements for module wise.
• Supported for Consolidation, Translation and Discover reports.
• Maintained Payments process for cash disbursements.
• Configured organizational approval hierarchy and updated as and when users required.
• Maintained Banks, Bank Statements to upload bank files through SQL Loader in to bank interface tables.
• Supported for Manual Reconciliation and Auto-Reconciliation for Receipts and Payments.
• Prepared User Acceptance Test (UAT) and get approval from users and end users.
• Prepared MD050 Functional Solution Design (FSD) document for new functionalities and enhancements.
• Prepared BR100 Functional Setups document as per Production.
• Providing functional production support to the business users and end-users.
• Supported for Revenue Recognition Process in AR Module.
• Maintained Change Advisory Board (CAB) process for Oracle Data Fix, Patches and Bugs.
• Defined new Application Desktop Integrator (ADI) to upload journals in to General Ledger.
• Day to day issues and on call support for P1 issues at Period and Quarter End Period Close process.
• Assisting to the technical team to develop custom Reports/Forms/Personalization’s as per business requirements.
• Maintained Oracle SR’s for Data Fix, Bugs and Patches to resolve issues on high priority.
• Vertex Taxation integration with Oracle E-Business Tax.
• On-call production support for day-to-day troubleshoot issues and provided solutions.

Confidential - Kansas

Associate Solution Designer

Environment: Oracle 12.2.4 (General Ledger, Payables, Receivables, Cash Management, Fixed Assets, E-Business Tax, ADI, AOL, Procure-To-Pay, Order-To-Cash, Sys Admin and Chervel Tool)

Responsibilities:

• Perform a functional evaluation of your current application environment and analyze existing gaps across your Oracle EBS suite of applications.
• Performed CEMLI’s evaluation.
• Maintained Multiple OU’s, LE’s and Multi-Currency.
• To upgrade the production environment, a step-by-step go-live plan should be executed that includes all technical and functional upgrade steps.
• Prepared planning scope include the upgrade objectives, new features and functionality to be implemented, potential changes, the impact of the upgrade on customizations or interfaces in current environment.
• Perform a practice upgrade of a clone instance of your production instance to gain experience with your unique upgrade and environments.
• Provide project team on functional enhancements, new products, leading practices, and bring experience of upgrade.
• Performing the functional testing including conference room pilots (CRP’s) and testing.
• Defined required setups and conduct the User Acceptance Test (UAT), this test is the final validation of system functionality, business processes and data.
• Prepared Functional Spec Documents (FSD) for customizations.
• Prepared GAP Analysis, Business Requirement Documents (BRD’s) and Functional Spec Documents (FSD’) like MD050, BR100 etc.…
• Performed Sub-Ledger Accounting process in post upgrade evaluation.
• Requirement gathering for data conversions respective module.
• Maintained 1099 Suppliers where suppliers should use 1099 form for tax filing purposes at end of the calendar year.
• Configured Financial Statement Generator (FSG) reports for financial reporting.
• Maintained Payments for cash disbursements.
• Configured organizational approval hierarchy (Employee-Employer relations) and updated as and when users required.
• Maintained Bank Statements to upload bank files through SQL Loader in to bank interface tables.
• Supported for Manual Reconciliation and Auto-Reconciliation for Receipt and Payments.
• Providing functional Production support after upgrade to the users and end-users.
• Provided end-user learning and on new functionality.
• Prepare documentation and update user manuals to reflect changes in both functionality and business process.
• Resolving issues within time and assisting the users and end-users in overcome the trouble shoots on daily basis.
• Day to day issues and on call support for P1 issues at Period and Quarter End Period Close process.
• Prepared user manuals and provided End-User s on going Enhancements.
• Maintained Oracle SR’s for Data Fix, Bugs and Patches to resolve issues on high priority.
• Maintained Chervel Tool for tracking day-to-day issues, patches, bugs, CR’s and Enhancements.

Confidential

Finance Functional Consultant

Environment: Oracle 12.0.4 (General Ledger, Sub-Ledger Accounting, Payables, Receivables, Fixed Assets, Cash Management, Procure-To-Pay, ADI, Sys Admin, AME, Data Loader, TOAD)

Responsibilities:

• Gathered and Prepared Business Requirement Documents (BRD) for all finance modules General Ledger, Payables, Receivables, Fixed Assets, Cash Management, Purchasing, Inventory, Human Resource.
• Prepared current business base line document RD020 and provided validations.
• Involved in system analysis and GAP analysis in existing business process.
• Prepared MD050 functional solution design (FSD) document as per existed business solution.
• Defined new Ledgers (Primary & Secondary), Legal Entities, Operating Units, Inventory Organizations and Sub-Inventories.
• Provided and conducted CRP’s and UAT instance for users/end users testing and also to get approval to migrate the same in to Production.
• Defined required setups and done testing as per standard application functionality for respective modules (GL, AP, AR, CE, FA, PO, INV etc.)
• Prepared data migration templates for all master data like Suppliers, Customers, and Items for new Operating Unit.
• Prepared all custom components and migrated in to the respective new Operating Unit.
• Loading Budgets Journals and Balance Sheet Trial Balance through ADI.
• Maintained 1099 Suppliers where suppliers should use 1099 form for tax filing purposes at end of the calendar year.
• Prepared data migration templates for all Open Transactions like AP Invoices & Payments, AR Invoices & Receipts for new Operating Unit.
• Configured organizational approval hierarchy (Employee-Employer relations) and updated as and when users required.
• Defined Buyers, Document Controls, Document Defaults, Document Types, Approval Groups, Receiving, Financial and Accounting Options etc.
• Maintained Bank Statements to upload bank files through SQL Loader in to bank interface tables.
• Supported for Manual Reconciliation and Auto-Reconciliation for Receipts and Payments.
• Configured Consolidation, Translation and FSG Reports.
• Prepared BR100 Setups document as per Production.
• Prepared user manuals and provided to the users respective End-Users.
• Provided On-Call production support for Period, Quarter end period close process.
• User problem resolution on a timely basis without interrupting regular transactions

Confidential

Finance Functional Lead

Environment: Oracle 12.0.4 (General Ledger, Receivables, Cash Management)

Responsibilities:

• Requirement gathering from the business users and prepared current business base line documents RD020 and business scope documents.
• Involved in system analysis and GAP analysis between Oracle Application and third party legacy system in existing business process.
• Prepared MD050 functional solution design (FSD) document as per existed business solution.
• Prepared Business Requirement Documents (BRD) and Functional Spec Documents (FSD’s)
• Defined required setups and prepared test cases and Test scenarios for User Acceptance Test (UAT)
• Defined new responsibilities for Payables and Cash Management.
• Defined new Operating Unit, Profile Options, Suppliers, and Payment Methods etc.
• Defined Bank, Bank Branches and Bank Accounts.
• Defined System Options, Bank Codes, Mappings and Bank Statements
• Maintained manual reconciliation process for Receipts and Payments.
• Performed module wise setups as per business requirement.
• Extracted AR open Invoices and Receipts from legacy system and populated them into AR Interface tables through SQL Loader.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client requirement.
• Production support after go-live.

Confidential

Finance Functional Module Lead

Environment: Oracle 11.5.10.2 (General Ledger, Payables, Receivables, ADI, TOAD, Data Loader, PL/SQL, Data Base 9i/10g)

Responsibilities:

• Responsible for Business Requirements Documents (BRD’s) creation
• Providing functional support to the users and end-users.
• Preparation of test cases and test scenarios against CR’s.
• Working on understanding and gathering of Functional Spec designs for Customizations, Personalization’s and inbound-outbound interfaces and preparing Functional Design Documents (MD50)
• Defined ADI templates to upload journal lines in to General Ledger.
• Handling Roll-Out projects and Production support after go-live.
• Assisting the users and end-users in overcome the trouble shoots on daily basis.
• Created SR’s and maintained Sev.1 issues 24/7 support.

Confidential - San Jose

Finance Functional Consultant

Environment: Oracle 11.5.9 (General Ledger, Payables, Receivables, Procure-To-Pay, TOAD, Data Loader)

Responsibilities:

• Analysis status of the project, clarify any queries regarding the functionality etc.
• Gathering information about existing patch set level in Oracle finance and then working with Oracle to get latest patch available.
• Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
• Providing functional support to the users and end-users.
• Supported code changes/modifications as users requested for custom reports/personalization.
• Preparing Test Cases and Test Scripts against CR’s.
• Providing required solution for enhancement implementation in production.
• Writing SQL query statements to providing back-end data from data base.
• Assisting the users and end-users in overcome the trouble shoots.

Confidential

Finance Functional Consultant

Environment: Oracle 11.5.9 (General Ledger, Payables, Receivables, Citrix, EssBase, Discoverer Plus)

Responsibilities:

• Provide regular status updates and monitoring progress on issues as per client requirements.
• Providing functional on-line production assistance to on-site people.
• Using other applications like Citrix, EssBase, and Discoverer Plus
• Providing daily and monthly remedy reports and chart reports.
• Providing daily and monthly SLA reports Service Level Agreement

Confidential - New York

Finance Functional Consultant

Environment: Oracle 11.5.9 (General Ledger, Payables, Receivables, Fixed Assets)

Responsibilities:

• Conducted business process review and gap analysis to determine business requirements.
• Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Defined payment terms, invoice approval codes and payables look-ups.
• Defined 1099 suppliers and supplier sites
• Set up transaction types, invoices, write-off, credit memos and debit memos.
• Participated in User Accepting Testing (UAT) test instance.
• Experience and knowledge in set up of FSG, MRC, Revaluation, Translation and Consolidation process.
• Involved setting ups Expense Report Templates and creating expense reports
• Raise SR’s and coordination with Oracle Support team to resolved issues on priority basis.
• On call production support for period end / quarter end reporting.
• User problem resolution on a timely basis without interrupting regular transactions.