Oracle Financial Functional Consultant

PROFESSIONAL SUMMARY

Over ** years of Functional & Business experience in Oracle ERP in a variety of large Projects with Full Life Cycle Implementations, Upgradation and Post Production Support of Oracle Applications.

Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.

Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax),Purchasing (PO) and Sys Admin.

Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification &Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.

Involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System) and designed and developed Financial Statements (FSG’s) as per Business Requirement.

Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).

Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, and GL Balances.

Experience in maintaining documentation and using the Application Implementations Methodology (AIM),which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20, BR30, BR 100, MD 50, CV 40 &TE 40)

Create SR’s with Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.

Conducted CRP’s and provided wide range of functional training to multiple business user groups and coordinated UAT sessions.

Excellent communication skills and leadership qualities with analytical problem-solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

Academic:

Master of Business Administration (MBA), Business Management.

Bachelor of Science, Finance.

Technical Skills:

Oracle ERP: Oracle Financials R12&11i – GL, AP, AR, CE, FA, E-B Tax, PO, I Expense, Sys Admin, SLA, P2P, O2C and A2R.

Other Tools: Web ADI, Data Loader, Discoverer, SQL*Loader, SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE

Mount Sinai Hospital System, NY Jan 2017– Present

Oracle ERP Financials Consultant

Post Production Support of R12 GL, AP, PO, FA, P2P

Responsibilities:

Handling Month-end close activities and reconciliation for GL, AP, PO and FA modules.

Resolving Finance issues that occurred during production and provide Month end support to the above financial modules along with delivering the reports of the close.

Run Depreciation for the Company Corp books and created the system entries to be approved by Superusers, reviewed and then posted.

Run the CIP and Standard FA Reports for the different Books. Interacted with the end users and demonstrated the functionality in detail.

Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.

Responded to Users` requests to run programs, reports and requests for their daily duties.

Prepared training materials with screen shots, exercises and presentations for critical end users.

Supported Oracle Financial modules which involved daily issues and new customizations and enhancements based on the changing requirements.

Working actively with DBAs to apply Change Control (CRs) in PRD and to migrate solutions.

Worked with Oracle Support to resolve the critical Production issues.

Used TOAD to open multiple instances and query tables using SQL and to either run reports, figure out issues or get some data for analysis.

EDI monitoring for Supply Chain inbound & outbound data which involves resubmission of failed orders, reporting incorrect POs to users, approving POs and identifying any issues with scanned orders.

Inner Wireless Richardson, TX (Jan 2014 – Jan 2017)

Oracle Financial Functional Analyst

Oracle EBS Post Production Support & Functional Enhancement (R 12.1.3)

GL, AP, PO, AR, FA, CE and E-B Tax

Inner Wirelessfocuses on building wireless in every industry from healthcare to Fortune 500. Theydeliver the guaranteed wireless coverage and engineered capacity for maintaining connectivity and optimizingservice levels. Worked in the Post production phase and was involved in Functional Enhancement.

Responsibilities:

Supported Post-Implementation phase for all Oracle Financials Modules.

Production support, interfaces maintenance, change management, month end closing

Prepared and modified MD50’s for different reports like Product profitability report, PO received but notinvoiced report, etc.

Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployedto production.

Researched and resolved PO number in customer credit card statement for refund transactions.

Resolved the issues related to credit card refund, return, bills only, freight charge return, not invoiceable items,credit card authorization, consolidated invoicing, in order management and receivables.

Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, and customer statement report.

Worked on development of new FSG reports and customized various standard FSG reports.

Worked with technical team regarding RICE components.

Created work around for unsolved issues.

Supported Post-Implementation phase for all Oracle Financials Modules.

Worked with Oracle Support to resolve the critical issues through SR/TAR.

Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue logregister.

Involved in supporting Super Users and End users in period end closing.

Comcast. (Philadelphia, PA)

Oracle Financial Functional Analyst April 2011 – Dec 2013

R12 (12.0.6) AR,CM, FA/PA –Implementation & (12.1.3) Upgrade

Comcast Cable, Nation’s largest and fastest Internet, Cable and Voice service provider to the end consumers. It has more than 25000 centers across the country and having more than 50 custom, Client\Server and web applications running on different platform. Establish external Data Source Provider platform, gather supporting information from various third-party vendors to provide innovative solutions and alternatives to company’s customers.

Responsibilities:

Involved in Comcast’s Oracle EBS Implementations and its Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, I Expense, Project Costing, Billing and Cash Management.

Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates.

Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings.

Used other major Oracle’s such as IPM and Other outside applications such as KOFAX, AppLoad, Formscap for Images Management and uploading bunch of data using Excel Sheets into the Oracle Database.

Defined, Created and Tested Flex field structure, Cross Validation rules, Accounting Calendars, Functional currencies, foreign currencies and budget for QA testing.

Defined, Created and Tested Primary Ledger, sub ledgers and Operating Units Ledgers.

Created Journal and its Batches (with STAT), Recurring Journals, Mass allocations, Consolidations, Conversions, Journal line Reconciliation, Generated reversal and scheduled automatic reversal journals for QA Testing.

FSG Reports, Financial Reports, Account summary reports, Income and Expense Reports and other Oracle standard reports.

American Commercial Lines (ACL), Jeffersonville, IN

Oracle Financials Functional Analyst May 2010 – Apr 2011

R12 (12.1.1) AP, AR, & CE- Upgrade.

American Commercial Lines Inc. (ACL) is a leader in the transportation and manufacturing industry. I worked with ACL as an Oracle Financial Functional Analyst from phase CRP1 through to UAT and I was responsible with AP, AR and CE.

Responsibilities:

Assisted in implementation of Oracle Financials (AP, AR and CE) across the organization.

Managed a team of consultants for the up gradation and configuration of AP, AR and CE modules.

Created general settings and completed specific configuration related to Company Code, Banktransaction codes, Bank accounts and bank reconciliations.

Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.

Conducted CRP1, CRP2 and tested the customized components.

Configured the Sub Ledger Accounting (SLA) setups.

Created the BR100, TE40 and BP80.

Created the MD50 documents for each RICE components.

Facilitating end-user training and developing the various users training manuals and conducted the UAT.

Involved in the design and setup of legal entities and the related inventory organizations using the legalentity Configuration.

Set-up financials options, payables and payables System options in AP.

Drafted extensive set of requirements, questionnaire and gap analysis.

Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accountingrequirements.

Used accounting methods builder in sub ledger accounting for analysis, auditing and reporting of journalentries.

Defined security and cross validation rules.

Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules.

Setting up of fiscal calendar in FA that map to the new GL calendar.

Configure new prorate conventions based on the fiscal calendars.

Create new corp. books and tax books that are associated with new calendars and prorate conventions.

Assign asset categories to corresponding new corp. and tax books.

Reviewed business processes initiated setups, developed and executed test scripts.

Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.

Setting up of banks, bank branches and bank accounts.

Configured the financials and payables options.

Involved in end user training and user acceptance testing.

Leap Frog, Emeryville, CA

Oracle Financials Functional Consultant Sept 2009- May 2010

Implementation (R12.0.6) - (GL, AP, PO, I Expense and P2P)

Leapfrog is a leading designer, developer and marketer of innovative, technology-based educational products andrelated proprietary content. Worked as an Oracle Financials Functional Consultant before CRP1 through usertraining and was responsible for GL, AP, PO,I Expense and P2P.

Responsibilities:

Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Payables, Purchasing, I Expense and P2P.

Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script).

General Ledger, Account Payables, andPurchasing Modules setups.

Business communications for the system updates and meeting the deadlines for the implementation.

Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.

Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, CrossValidation Rules, Security Rules, Calendar, Currencies, Assigning Ledger to a

Setting upResponsibility, Standard Journals, Statistical Journals, Recurring Journals, Suspense Accounts and Mass Allocations.

Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.

Set-up Oracle Payables including System Options.

Setups and defined Invoice attributes- Payment Terms, Approve, Hold and Release and DistributionSet, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplierand Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, TaxCode, Rates,Groups and Withholding Tax, Open/Close of payable Accounting periods, andPayableTransfer to GL.

Used Accounting Rules to determine the number of periods and percentage of total revenue to berecognized (Revenue Recognition) in each accounting period.

Perform the related setup tasks in the applications that work together with Internet Expenses to create anintegrated environment for expenses reporting.

Setup payment terms, invoice distribution, matching of invoices against PO.

Telex Communication, Burnsville, MN

Oracle Financials Functional Consultant Dec 2008 – Aug2009

Upgradation (from 11.5.10.2 to R12.0.5) - (GL, AP and AR)

Telex is a leading manufacturer of dependable, top-of-the-line communication equipment. Worked as an OracleFinancials Functional Consultant from just before CRP2 through to Go-live and was responsible for GL, AP andAR.

Responsibilities

Responsible for the documentation (BR.100 -Application Setup and TE.040 -System Test Script) andsetups of the General Ledger, Account Payables and Account Receivables.

Involved in the design and configuration of chart of accounts, accounting periods and accounting calendarfor each legal entity.

Designed the primary ledger, secondary ledger, functional currencies and reporting currencies using theaccounting setup manager.

Involved in the design and setup of legal entities and the related inventory organizations using the legalentity Configuration.

Set-up of financials options, payables and payables System options in AP.

Drafted extensive set of requirements, questionnaire and gap analysis.

Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accountingrequirements.

Used accounting methods builder in sub ledger accounting for analysis, auditing and reporting of journalentries.

Defined security and cross validation rules.

Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules.

Setting up of fiscal calendar in FA that map to the new GL calendar.

Configure new prorate conventions based on the fiscal calendars.

Create new corp. books and tax books that are associated with new calendars and prorate conventions.

Assign asset categories to corresponding new corp. and tax books.

Reviewed business processes initiated setups, developed and executed test scripts.

Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.

Setting up of banks, bank branches and bank accounts.

Configured the financials and payables options.

Involved in the setup of auto invoice workflow.

Involved in end user training and user acceptance testing

Live Nation, San Antonio, TX

Oracle Financials Functional Consultant Sept 2007 – Nov 2008

Post Production Support (11.5.10.2) – (AP, AR and PO)

Live Nation Entertainment is the world’s leading live entertainment and eCommerce company, comprised of fourmarket leaders. Worked as an Oracle Financials Functional Consultant for Post Production support and wasresponsible for AP, AR and PO.

Responsibilities:

Involved in Month-end support for close and reconciliation for AP, AR and PO modules.

Resolved issues that occurred in the production.

Interacted with the end users and demonstrated the functionality in detail.

Involved in unit testing and integration testing on various modules.

Prepared and did extensive testing of TE 040 test scripts, validations using Win Runner 7.5.

Assisted in user acceptance testing and conference room pilot go live.

Prepared training materials with screen shots, exercises and presentations for critical end users.

Assisted the technical teams on the customization and extension issues of RICE objects.

Actively involved in the post production support and troubleshooting on various issues.

Provided with Post production support for various issues after go- live.

Resolved the application issues interacting with oracle support through SR/TAR.

Resolved the issues related to credit card payment processing, payment authorization, payment capture.

Resolved the issues where invoice transactions were related to consolidated invoicing and selected to receipt batch ids and stuck in the workbench and not being able to be applied to the receipts.

Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench.

Resolved the issues related to automatic clearance of receipts, aging 7 bucket report, credit snapshotreport, customer statement report.

Resolved the issues related to RTP for drop ship, PO receiving, AP invoicing, receiving hold, debit memo.

Novatel Wireless, San Diego, CA

Oracle Financials Functional Consultant Jan 2007 – Aug2007

Implementation (11.5.10.2) – (GL and AP)

Novatel Wireless, Inc. is a leader in the design and development of intelligent wireless solutions based on 2G, 3Gand 4G technologies providing wireless connectivity. Worked as an Oracle Financials Functional Consultant rightfrom the beginning through to Go-Live and was responsible for GL and AP.

Responsibilities:

Member of the core team responsible for implementing GL and AP.

Interacted with the client team to understand the existing business practices and prepared the businessrequirement definition document.

Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100Application.

Setup and TE.040 -System Test Script) and setups of the General Ledger and Account Payables Modules.

Created BR100 documentation for GL and AP.

Participated in designing the chart of accounts to meet the client’s business requirements.

Configured the Ledger Setup, Legal Entity, Operating units and Multi Org (MOAC).

Created Customized responsibilities, customized menus, customized request groups.

Configured Payable Setup Options.

Used Accounting Setup Manager for Inter-company Transactions.

Worked with Technical team regarding conversion of data.

Conducted CRP1 and CRP 2.

Created the MD 50 for each RICE components.

Provided various custom solutions for client’s specific needs.

Created user-manuals and trained the end users.

Trained the users for UAT and conducted UAT.

Created Test Scripts (TE-40’s) for UAT sessions.

Kinetic Concepts, Inc San Antonio, TX Oracle Financials Functional Consultant March 2006 – Dec2006

Testing and Post Production Support (11.5.10.2) - (GL and AP)

KCI elevates patient outcomes, lowering costs and delivering the advanced treatments necessary to heal woundsand improve lives all around the world. Project includes the Testing and Post Production support of GL and AP.

Responsibilities:

Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.

Writing TE.040 Test Scripts for Functional Testing of GL, AP and developing Guided Navigations.

Developing Training Material for AP module.

Conducted end user training sessions and User manuals.

Post implementation support and maintenance – performed successful three-month end and period closeactivities in the newly implemented modules.

Design and Configure Financial Statements Using FSG.

Maintain issue tracker using Bugzilla and issue resolution.

Conduct business meeting whenever required based on issues and new functional requirements.

Resolved issues that occurred in the production.

Interacted with the end users and demonstrated the functionality in detail.

Involved in unit testing and integration testing on various modules.

Assisted in user acceptance testing and conference room pilot go live.

Prepared training materials with screen shots, exercises and presentations for critical end users.

Assisted the technical teams on the customization and extension issues of RICE objects.

Contact this candidate