SUMMARY

• Over 8 years of experience as an Oracle Financials Functional Analyst working on multiple wide ranges of projects in both Oracle R12 and 11i versions at various client environments irrespective of their nature of industry like Manufacturing, Technical, Processing & Service industries.
• In depth knowledge working on integrations and architecture of Multi - Org(MOAC),SLA(Sub-ledger Accounting)
• Experience with multiple projects in Oracle Implementation, Upgradation and Post Production Support projects in multiple versions in both Oracle R12 and 11i.
• Extensively worked on General Ledger (GL) including AGIS, Accounts Payable (AP) including Payments, Accounts Receivables (AR),E- Business Tax (E-B.Tax), Cash Management (CE), Fixed Assets (FA), iExpense(iExp), System Administrator (Sys Admn), Purchasing (PO), Sub ledger Accounting (SLA) including Procure to Pay (P2P Cycle), Order to Cash (O2C Cycle), Acquire to Retire (A2R Cycle) & Record to Report (R2R Cycle)
• Professional expertise in Oracle AIM methodology including preparing documentation of RD20, BR30, BR100, BR150, BP30, CV040, TE40, MD50 and BP80 including preparing documentation for Change Management process with Impact analysis from the function perspective.
• Conducted multiple CRPs and coordinated UATs with tracking issues/open items and resolved the same working with technical team and/or oracle support. Create and update detailed test scripts to all functional activities including verify the reports; analyze and test the accuracy of SIT integrations &RICE / CEMLI components.
• Provided Application in all phases of full life cycle Oracle Financials implementation i.e. Requirements Definition, GAP Analysis, Fit-gap analysis, Application Configuration, System Integration Testing, User Training, debugging and Performed business process mapping for all Prototype functionalities including proposed custom processes.
• Coordinate onsite and offshore team for the timely deliverables including proactive reporting of weekly status updates to the project management.
• Conduct multiple meetings with business, and prepare& execute detailed test plan& scripts for the proposed business scenarios in all financial modules.
• Involved in Data Migration and Data Conversion process with sanity check of migrated/converted data from Legacy to Oracle including the data inbound from third party software’s.
• Coordinate with Oracle Technical Support on high prioritized open issues raising SR’s/TAR’s and conduct OWC sessions to avoid ambiguity on identified issue with speedy resolution for the same.
• Play key role in team achievements with complete solution on the Business Re-engineering, Quality Assurance, along with key business users& coordination for quick decision making on open items as part of timely deliverable of full System Development Life cycle with transformation of key business processes.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through financial closing; revenue and expense cash/accrual concepts; adjustments and financial statements.

TECHNICAL SKILLS

Tools: & Software’s: Web ADI, ADI, OBIEE, Toad, Discoverer, Hyperion, Data Loader, SQL*Loader, Bugzilla, Share Folder and MS Office.

Modules: GL, SLA, AGIS, AR, AP, CE, PO, FA, E-B.Tax, iExpense, Sys Admin, Cycles including P2P, R2R, O2C, A2R AND knowledge on other functional integration areas like PO, OM, Inventory modules.

Oracle: R12.0.3, R12.0.4, R12.0.5, R12.0.6, R12.1.1, R12.1.2, R12.1.3 &11i (11.5.9, 11.5.10, 11.5.10.2)

PROFESSIONAL EXPERIENCE

Confidential, Davidson, NC

Oracle Financials Functional Consultant

Responsibilities:

• Perform requirement gathering and played a major role in preparation of share folder/document like AS-IS and TO-BE process during the initial build stage of the project
• Actively participate in the functional design meetings with key process team members and update the latest designs in MD50
• Took responsible ownership of the RICE components assigned, and coordinate unit testing and proof of concept (POC) type of code review with technical team and Quality team
• Provide Assistance in defining and reviewing the functional requirements for the RICE objects, for instance, existing interface specifications
• Confirm the completeness and consistency of the design deliverables and also resolve if any inconsistencies arose
• Provide functional guidance to the reports, interface, conversion, extension technical designer for the reports, interface, conversion &extension work units
• Participate in various business requirement meetings, identify Gaps and provide Fit-Gap Analysis
• Prepare various documents including Customer requirement document, gap analysis document, setup document & identify the RICE components
• Directed and also corrected the incorrect currency, which was raising a major problem in AR Invoice, Debit Memo & Credit Memo
• Performed GL Set-Up which included defining the Chart of Accounts, Calendar, Currencies, Set of Books, Accounting Flex fields, and Flex field Security Rules, also the Journal Entry Sources and Categories, and Cross-Validation Rules
• Corrected customer Profile class setup & statement to avoid multilingual statement printing
• Developed FSG (financial statement generator) Reports in GL like (Income statement, Department Expenses, Inter Company Summary)
• Create responsibilities as per business requirements &proposed internal controls by employee classes
• Performed setups for General Ledger, Accounts Receivable, Accounts payables and also Fixed Assets
• Defined rules in Oracle Approvals Management (AME) to send FYI notifications
• Designed Auto Invoice Import process and documented the import process in AR
• Help technical team members to understand seeded oracle receivables flow and help them understand various custom objects requirement
• Participate in Integration test and UAT preparations including coordinate business users for smooth UAT accomplishment
• Prepared various data loader programs to load the configuration data which is high in volume and perform data cleansing before the final upload
• Help business users to prepare test scripts to test various end to end business scenario, which also included updating the TE40 document
• Testing of various custom reports, to ensure it meets the standard expectation of the business clients

Confidential, Danbury, CT

Oracle Financials Functional Consultant

Responsibilities:

• Conducted team meetings with client, technical team and business IT team in order to gather the business requirements and update in RD20
• Gathered requirements from the business according to the current business flow and process as a part of preparing AS IS and TO BE documentations in the initial build
• Performed mapping and GAP analysis for each module, in order to understand the gaps which will be identified as RICE components
• Set up of COA, Calendar, Currency and creating Ledger at Accounting Manager based on the company’s requirement, and customize as per the client’s necessity
• Creating responsibilities through System administrator, handling assignment of various user level access
• Set up of particular details like recurring journals and mass allocation based on the details provided by the business team
• Performed Set up of transfer and consolidation of various data from the third party system to the standard functionality
• Conducted extensive Set up activities for Suppliers site, location, Bank accounts, Bank reconciliation, defined payment terms, payment process profile and Transferred various data to GL in order to create reports
• Performed certain set up steps like transaction type, memo line, receipt class and receipt method in Account Receivables module.
• Conducted Run Transfer to General Ledger program from Account Receivables modules based on the request of clients
• Involved in setting up of PO documents types, and in parallel worked on updating different PO types
• Assisted in setting up of suppliers and creating site for payments & billings, to balance with other steps of set up activities
• Updated and corrected various test scripts which were documented in TE40, which involved tests like sanity test & smoke test
• Co-coordinated with technical team for Conversion of historical data from the third party legacy system to the standard oracle functionality
• Conduct PowerPoint presentations, and used Instance for the training session the business users to familiarize oracle system to the business users
• Assisted in developing GL, AP, AR and CE Training Guides during the lucid super user trainingand also assisted in configuring CRP & test instance
• Worked with Oracle Support in the process of resolution of various application issues, bugs and TAR management, and provided quick solutions for all the functional issues
• Played a major role in providing post-production support and helped in period close process.

Confidential, Houston, TX

Oracle Financials Consultant

Responsibilities:

• Performed activities like evaluating the design and development needs of the client, depending on their business lines
• Writing functional specifications and technical specifications in documents like MD50 and MD 70 with assistance of technical team
• Participated majorly in testing activities like debugging and testing, also provided functional & technical support and resolve issues raised by the business users
• Executed best practices of business procedures and processes in application analysis and design, and updated in the documents
• Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, Payables and Purchasing, AP invoice fixes, Invoice Import modules
• Involved in post CRP sessions, which involved various changes that are further applied through Change Management Process
• Conducted Oracle web conference (OWC) with Oracle support team, in order to resolve many functional and technical issues along with the coordination of technical team
• Extensively worked on documentation forBR100, RD20 for GL,AP, & CE through AIM Methodology, during the initial build of the project
• Developed Test scripts and Business scenario for CRP and UAT and further updated the same in TE40
• Managed Oracle Service Requests and testing of maintenance patches in order to resolve functional issues quickly and efficiently

Confidential, Sunnyvale, CA

Oracle Financials Functional Analyst

Responsibilities:

• Extensively worked on setting up Project Plan and Mile Stones in the up gradation process, also assisted in creating BR 100 documentation for AR and CE modules
• Provided end user training on the new features and functionalities, and scripted a user manual for the business users
• Responsible for creating Unidentified and Unapplied receipts, in the receivables module which was later reported in GL
• Created transfer of various data from AR and CE into the GL program as part of data migration
• Performed activities like preparation of Solution Document, Design and Migration documents like MD50, TE40 and CV40
• Assisted in configuring data migration and ensured to perform data cleansing before uploading the data into the instance
• Recreated custom programs, modifications and running RICE components based on the specifications of the business
• Conducted testing and CRP sessions, which involved conducting business meetings, capturing and updating business scenarios

Confidential, Miami, FL

Oracle Financials Functional Consultant

Responsibilities:

• Reviewed the Business Requirements Documents with the Business and Development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identified standard functionality, analyze gaps document and design solution for GL, AP depending on business requirement.
• Created Chart of Accounts, calendar and currency according to the business requirement.
• Defined Primary Ledger, secondary ledger and defined accounting setup options.
• Involved in the setup up of Security rules, data access sets, Cross validation rules, recurring journals, revaluation template and translation
• Involved in the design and setup of legal entities and the related inventory organizations using the legal entity Configuration.
• Configured Payables System options, Financial options and Payables options in the payables module to enable customization based on the business requirement
• Defined Payment Terms and Distribution Sets, Involved in the setup of auto invoice workflow
• Conducted CRP’s, prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, and user feedback integration.
• Worked with technical team for data conversion and custom object validation.

Confidential, Euless, TX

Oracle Financials Functional Consultant

Responsibilities:

• Performed System setup audit to ensure the system setups were as per business needs in R12.1.1 to meet the requirements in GL, AP, FA, PO modules.
• Reviewed the R12.1.1 setups with the CFO, Manager and users of respective modules/systems and updated the setup as per business requirements.
• Conducted new functionalities like Sub Ledger Accounting (SAL) and functionality changes in various modules which were are reviewed with CFO, super users and users of various business areas.
• System integration and regression tests were carried out to meet various functional scenarios.
• Tested system to meet the Procure to Pay cycle with matching and payment batch process in payables module
• Performed tests to meet invoice to cash process, applying manual and Auto Lockbox receipts, and revenue reorganization in Receivables. Developed test cases on various functional scenarios and provided the same to the users. Lucid Super User training was provided on the new system, for the business users with the provision of user manual

Confidential, North Brook, IL

Oracle Financials Functional Analyst

Responsibilities:

• Performed System setup audit in order to ensure the system setups in R12.0.6 met the requirements in GL, AP, FA modules.
• New functionalities like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed with CFO, super users and users of various business areas.
• Responsible for preparing upgrade plan for GL, AP,FA & CE
• Prepared impact analysis document for the upgrade of financial modules like AP, GL, AR, FA, CE
• Responsible for setting up Data Access sets, Report Manager, Payment Process, and also handled the system administrator
• Extensively worked on complete functional testing and resolving issues, raised by the users and maintained the same protocol up to date
• Reviewed the R12.0.6 setups with Project Manager and project management team, and updated the setup as per business requirements.
• Conducted CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration. Coordinated with Oracle support and raised multiple SR for critical issues.
• Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, CE, PO and E-Business Tax modules.
• Performed Issue resolution, also updated functional impact analysis with proposed changes, if any in to Bugzilla issue tracker based on the issues recorded from the business users
• Created and followed up SR’s with Oracle Technical Support, coordinated and followed up on multiple issues based on priority including identifying bugs and follow-up with Oracle Development.

Confidential, Cambridge, MA

Oracle Financials Functional Consultant

Responsibilities:

• Involved in the up gradation of Fixed Assets module globally throughout the entire business in a phased manner along with the coordination of business team
• Assisted the technical team on developing & conducting data migration from older version to newer version of oracle system
• Performed review of changes/upgrades to any of the interface design and code, also being responsible for creation of Test cases and Test plans for business unit testing
• Conducted other activities like Run open period, apply the receipt to the transaction and create accounting for accounts receivables module
• Worked on changing payables, system and financial options for accounts payables modules with integration with cash management
• Assisted in creating clearing account in GL and also create account for cash management module
• Involved in updating the interface design documents with the latest changes/updates on timely basis, with coordination of other team members
• Prepared the business requirement documents and also related functional specification documents to satisfy the clients basic business needs in Oracle Financial modules
• Involved in reproducing the bug & patch fixing scenario in Vision instance to check its working meets the standard expected by the business
• Involved in support and maintenance of various modules in Oracle Applications R12 Oracle Account Payables, General Ledger
• Assisted in preparation of BR100, MD50 and RD20 documentations for FA, AR & CE modules
• Involved in debugging and troubleshooting of various forms and reports issues as part of support and provided the solutions for the same
• Interacted directly with the end-users and clients, interact with the users of legacy systems as well to get invoice and payment issues resolved

Confidential, Tustin, CA

Oracle Financial Analyst

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.510.2 to R12.0.6
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identified standard system functionality, analyzed GAP document and designed solutions for GL & AP depending on Business requirement.
• Created process documents BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, conversions (RICE) and test scripts in AIM methodology as part of project up gradation task.
• Coordinated with project Manager, Business team for discussing deadlines for the implementation process
• Involved in activities like Setup Chart of Accounts structure, Currencies, Calendar, Sub ledger accounting method (SLA).
• Defined value Sets, Flex fields and Segment Qualifiers, cross validation rules, security rules in general ledger module
• Involved in the design and setup of legal entities and the related inventory organizations using the legal entity configuration
• Performed Functional design and Building Custom BAI2 Lockbox file from (Credit Multiple Message Line) CREMUL file as part of Automated Bank Reconciliation through CE module for AR transactions.
• Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, defined Bank information, receivables quick code, auto invoice grouping rules, transaction types.
• Involved in the setup of auto invoice workflow. Setting up of banks, bank branches and bank accounts and setup AP payable system option, financial options, and payable options.
• Defined accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning.
• Performed setting up of PO matching options, invoice tolerance, term holds, expense report templates
• Involved in end user training and user acceptance testing, preparation on test scripts (TE 040) and integration testing.

Confidential, Exeter PA

Oracle Financials Functional Analyst

Responsibilities:

• Reviewed the Business Requirements documents with the Business and Development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identifying standard functionality, analyze gaps document and design solution for AP, AR and FA depending on Business requirement
• Setups Payables (Financial option, Payable system option, payable option) as per business specification.
• Configure the setups in Payables for business flows like Asset invoices processing and expense invoice processing with matching options, Employee expense report and recurring invoice processing.
• Played a vital role in Assets key flex field structure designing to meet the requirement for effective management for organization assets at corporate Books and tax books. Assets are categorized using different depreciation methods and asset types.
• Defined transaction types & sources, quick codes, Grouping and Line ordering rules for Auto invoice, Auto accounting rules, Receipt classes and Source, Customer profiles, Payment terms, Internal Banks, Transmission Formats, System options and Tax Codes, Receivable activates and Profile Options to meet the business requirement
• Created several types of Variance analysis reports like rolling months, PTD, QTD and YTD variances. Also created division wide periodic P & L variance reports.

Confidential, Jacksonville, FL

Oracle Financials Functional Consultant

Responsibilities:

• Identified Business need as part of Requirement gathering and complete Requirements Analysis
• Defined GL Responsibilities, Value Sets, Key Flex field Segments, Period Types, Accounting Calendar, Currencies and created Set of Books
• Defined Recurring and Allocations Formulas based on the accounts defined in the general ledger
• Performed setup for the Global Consolidation System, involved in creation of customized reports as per the client’s requirement in Oracle GL using FSG reports
• Performed complete setups related to manual and automatic receipts, in receivables module
• Defined Profile Options to specify certain implementation parameters, Processing and System Options
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
• Involved in defining Organization, auto cash rule set, auto invoice tuning based on certain customization as per business requirements
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges and distribution sets
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Performed Trouble-shooting in GL & AR, simultaneously also conducted CRP1, CRP2 with the coordination of business team
• Extensively involved in UAT user acceptance test, performed UAT preparation tasks and updated all documents
• Track issue in the production and provide fixes along with proper document for future review

Confidential 

Oracle Interim Support Analyst

Responsibilities:

• Gathered and prepared requirements from Business Users, and updated the same in RD20 document, also assisted in updating BR100
• Prepared AS IS, TO BE documentation on business requirements and conducted mapping process during the initial build
• Assisted Co-workers on running GAP analysis and was also involved in updating RICE components into the CRP1 instance
• Performed various tests like smoke test, sanity test while preparing CRP and also updated the TE40 based on the test cases
• Assisted in configuration of CRP1, test instances using Test script and ensured to solve all issues during that period
• Worked on creation of COA, Calendar, Currency for the Set of books in General Ledger module
• Coordinated with Payables team in creating suppliers and setting up Invoices and Payments, which was an integrated work
• Conducted numerous PowerPoint presentation on Oracle functionality to the users, along with sessions using Instance to familiarize oracle system to the end users