SUMMARY

• Over 8 years of Professional experience as an Oracle Financials Functional Analyst working with multiple diverse projects, clients and industries expertise in Oracle R12 and 11i versions.
• Functional expertise in Oracle Applications with Implementation, Upgradation, Testing and Post Production Support of General Ledger (GL), Advanced Global Intercompany System (AGIS) Accounts Payables (AP), Purchasing (PO) Accounts Receivables (AR), Cash Management (CE), Fixed Assets(FA), E Business Tax ( E - B.TAX), iExpenses (iExp) and System Administration (Sys Admin).
• Worked on Order to Cash (O2C), Procure to Pay (P2P), Record to Report(R2R), Aquire to Retire(A2R) Business Cycles and Subledger Accounting (SLA).
• Performed as a Project Manager for several projects including Merger and Acquisition, Spin off, Upgradation and Full Life Cycle implementation Projects.
• Logged and monitored incidents through ServiceNow Incident management and HP Quality Center tools. Drive incidents to closure and build reports and dashboards to identify KPIs and understand pain points to streamline processes.
• Interacted closely with senior management and aid decision making by providing metrics on various KPIs that provide meaningful insights.
• Gather RFCs from all tracks, analyze, prioritize and submit for migration for different environments and follow up to closure.
• List all RFCs and get approval from Change control Board for significant changes explaining cross-functional impact to key stake holders and deploying communication plan.
• Experience in using Application Implementation Methodology (AIM), business requirement gathering, understanding As-Is Process, Solution designing (To-Be Process), performing Gap analysis, building RICE (Report, Interface, Conversion, Extension),configuration, CRP testing, end-user Training, UAT, Issue documentation and Post-Production support. (BR100, BP80, BR150, BR30, TE40, MD50 and CV40.)
• Proficiency in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing, custom solutions, programming, scheduling, documentation and production support, besides Integration and forecasting the financial information in Legacy Applications and Oracle Applications.
• Experienced in multiple full life cycle implementations from requirements gathering through to post production support.
• Extensively involved in setups & testing of Oracle Payable and Oracle Receivable Modules.
• Coordinated with Oracle Technical Support team through raising TAR/SRs for the speedy resolution of existing high prioritized issues / bugs with conducting Oracle Web Conference (OWC).
• Involved in logging of Requests for Change (RFC) through Oracle’s MOS systems.
• Follow up with off-shore technical & testing team for timely deliverable within project time lines.
• Well proven track record in achieving the timely deliverables with excellent coordination of Business team, onsite functional and offshore technical team at different phases of each project.
• Worked on and supported implementation and support of SaaS applications such as Concur(Expense management), Revpro(Revenue Accounting) and Sabrix(Global Taxation).
• Provided functional impact analysis for multiple post freeze requirements from business and carrying through appropriate Change Management Process with documenting and following up with approvals.
• Good verbal and written communication skills, with demonstrated ability to interface with all levels and across organizational lines, including leading/facilitating meetings and preparing/making presentations to both technical and non-technical personnel.

TECHNICAL SKILLS

Oracle E-Business Suite: R12 and 11i (GL, AGIS, AP, AR, CE, E.B-Tax, FA, PO, iExpenses)

Others: Sabrix, Concur, Revpro, HP QC, ServiceNow, MS Office, Excel, Project, MS Visio

Tools: Toad, SQL Loader, Discoverer, Hyperion, OBIEE, ADI, WebADI, Bugzilla issue tracker

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, California

Oracle Financials Functional Analyst/Project Management Office

Responsibilities:

• Led the transition activities for Core Finance track as Confidential spun off from its parent company Symantec.
• Worked closely with cross-functional teams to Understand, streamline and document end-to-end activities and process flows of the company’s financial systems.
• Performed in-depth Gap Analysis to identify scope for enhancements, documenting, implementing and testing applications.
• Support business on financial modules of Oracle ERP, identify and implement new features as part of continuous improvement of the applications.
• Extensive work on implementing and supporting third party financial applications like RevPro for revenue recognition, Sabrix for global taxation.
• Develop and report Key Performance indicators to higher management to help streamline the business process and integrate IT systems accordingly.
• Support month end close activities for the Order to cash, record to report and revenue accounting and forecasting teams.
• Meet regularly with business to understand issues, identify scope for enhancements and come up with project plans with timelines to ensure timely delivery of the solutions.
• Work closely with senior management by developing insightful metrics communicated periodically through presentations and dashboards to provide a transparent view into the applications and the pain points.
• Interact closely with the Offshore team to ensure timely deliverables on resolution of incidents.
• Log, update and monitor incidents through ServiceNow incident management tool and drive issues to resolution by working closely with the business and development team.
• Lead process adherence and quality controls by ensuring horizontal adherence to change management processes with stake holder identification and approvals.
• Log RFCs and table all RFCs to be considered for the change control board by providing cross functional impact and communicating the same to key stake holders.
• Log SRs with Oracle, update and follow to ensure issue resolution.

Confidential, Cupertino, California

Oracle Financials Functional Analyst/Project Management Office

Responsibilities:

• Contracting to assist through the full life cycle of Oracle R12 Implementation Project.
• Performed activities from CRP through two cycles of SIT, UAT, Mock Close and GO-Live.
• Key member of Project Management Office for Finance related tracks on the R12 Implementation.
• Create reports to present project progress, by collaborating across various teams, to higher management on a regular basis.
• Led the implementation of Oracle Financial Analytics (OFA) using OBIEE for financial reporting performing the role of a Project Manager.
• Worked extensively in the M&A team to integrate a newly acquired company to Confidential ’s ERP platform.
• Identified and implemented several small projects for efficient financial applications and integration.
• Contributed by initiating projects like gSites, Intracompany Delegation of Authority hierarchy, consolidation of global reports and tools used.
• Work closely with the Global Financial reporting team to create improved and efficient analytical reporting systems.
• Worked extensively with external implementation partners, acting as a liaison between Confidential, its cross functional - Multi-national teams and the external partners.
• Worked closely with the IT and business teams in requirement gathering, documentation, configuration, validation and end user training.
• Engaged closely with the senior management through-out the implementation cycle.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

• Supporting existing Oracle 11i Financial Applications
• Activities include analyzing and troubleshooting issues on a daily basis as reported by the users. Includes interaction with various business users to achieve an optimal solution for the efficient running of the system.
• Supporting month end activities for all Oracle financial applications.
• Part of the ongoing Reimplementation of Oracle EBS project, to implement Oracle R12.
• Helping install, upgrade and test Spreadsheet Server - an excel add in, to work seamlessly with the new Oracle R12 tables going forward.
• Validated appropriate drill down of the data being extracted to the Spreadsheet server to the jounal level, against Oracle entries. Set up various responsibilities to restrict data visibility to various regions.
• Worked on the remediation of various third party financial applications like Amega, Avalara, Concur, ADP, E&Y and their integration to Oracle R12, followed by appropriate testing.
• Involved in the establishment of secure SFTP connections for the data transfer of these applications between Confidential and the vendors.
• Involved in identifying the appropriate transaction types for apps like Amega and Avalara after consulting business users.
• Worked extensively on the remediation of Concur on both ends - data coming in from HR to Concur and extract from Concur to Oracle and validated the resulting Journal entries and Invoices.
• Validated all entries being generated in Oracle for all third party financial applications and tested all the apps thoroughly during CRP and UAT.
• Helped determine the schedule of automatic extracts going out from Oracle and coming into Oracle for all the finance applications
• Part of the annual E&Y auditing which included understanding the business process and preparing detailed documents on several controls like INV - KC 12 and OTC KC - 8.
• Incudes a lot of interaction with several business users and vendors from the third party software providers. Worked with offshore technical team to get the right code to extract the appropriate data.

Confidential, Boston, Massachusetts

Oracle Financials Functional Analyst

Responsibilities:

• Worked on the restructuring of the Chart of Accounts (COA), the key focus of the project.
• Played a role in deciding the new accounts to be used, after discussing with the business users and created mapping documents to record the new mapping changes.
• Worked on the Eprentise tool to map the old CCID to the new CCID.
• Configured AP, FA and Iexpenses with the changes as part of the new Chart of Account structure
• Documented high level BR100s for FA, AP, and IExpenses with detailed description of every configuration to be made.
• Primarily involved in redesigning, mapping, configuring and testing of Cost Centers, Expense reports, Signing limits among others in AP.
• Authored MD50 for documenting the RICE components, and was part of configuration and validation team.
• Worked on testing of AP, FA and IExpenses module to ensure proper functioning with post COA changes.
• Suggested, tested and documented various changes as part of the changing definitions of segments as part of the new COA structure.
• Identified, logged and resolved issues of several priority levels as part of the testing.
• Worked with the GL team on configuring the right CVRs, to ensure proper functioning and efficiently reflect the new COA changes.
• Worked closely with other financial modules(GL, AR, Projects, CE and E-B.Tax) to understand and test for effective functioning for transactions flowing in from other modules.
• Also performed roles of the Enterprise Business Analyst, reviewed validated and approved changes as part of various localizations.
• Worked closely with the technical team to resolve issues detected during testing based on Priority levels.
• Assisted in the setup of profile options for General ledger, Account Payable and Fixed Assets
• Involved in creation and following with Service request (SR) TAR with Oracle for application error and business critical Issues in AP and FA.
• Was part of and coordinated Regression testing and UAT cycles, and actively tracked issues and resolved it through Application Lifecycle Methodology (ALM).
• Prepared test documents and was part of the end user training to explain the changes and impacts.
• Planned and co-ordinated the Cutover phase.
• Provided support post Go-live phase and helped fix issues.
• Create documentation for all proposed functional changes with detailed functional impact analysis as part of Change Management Process for prior approvals from project steering committee.
• Trained end users on the new changes.

Confidential, Omaha, Nebraska

Oracle Financials Functional Consultant

Responsibilities:

• Participated in the gathering business requirements from business users and diverse business groups
• Conducted multiple meetings with key business users for in depth understanding of existing key business process and document and high prioritized requirements from business perspective in order to map the proto type functionality in Oracle and also to see the visibility of other solution to fit the requirement AS IS.
• Worked with the Project Managers to develop detail track work plans
• Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed assets and Inventory, Purchasing
• Designed Functional specifications for diverse business units based on requirements
• Configure Charts of Accounts, Descriptive Flexfields, Segments Qualifiers, Setup account hierarchy
• Worked with diverse segments and segment values, design of cross validation rules and Security rules

Confidential, Fremont, CA

Senior Financial Functional Consultant

Responsibilities:

• Worked in the implementation of core financials and Procure to Pay module
• Involved in gathering business requirements from business users and diverse group
• Identifying the reporting requirements from User. & developed functional specs for the reporting requirements
• Analyzed the needs of functional departments and establishes priorities for feasibility studies and finance systems design and implementation to develop new and/or modify information processing systems
• Worked in the setups to configure P2P applications in line with business requirements.
• Performed gap analysis to understand the requirement to be developed for the customer. Defined Calendar, Currency, Chart of Accounts for General Ledger
• Assisted the client with the functional aspects of upgrade from 11i.5.10.2 to R12.1.1 in AR, AP, FA and GL from end to end process cycle, month en close and reconciliation activities
• Provided Post Implementation production support
• Part of the implementation and Testing Team - Validating reports, testing the standard functionality and custom components for GL, AP and AR

Confidential, Westlake Village, CA

Senior Financial Functional Consultant

Responsibilities:

• Prepared AS-IS and TO-BE documents based on the current system and future client requirements. Performed Gap analysis and recommended possible conversions and customizations to meet the client requirements. Performed the configuration setups in line with the requirements.
• Defined ledger books for different organizations.
• Implemented the Accounts Receivables module, troubleshooting and conducted demos for business users.
• Involved in taxation setups.
• Defined Supplier Setups, Invoice and payments in AP. Created FA parameters.
• Defined the Technical Documentation using Aim Methodologies (MD50 MD70 TR20) for business process analysis, requirement analysis, Gap analysis, system mapping, CRP testing, system configuration, data conversion, master data loading and production go live support.

Confidential, Austin, TX

Senior Financial Functional Consultant

Responsibilities:

• Resolving the issues rose during the implementation life cycle.
• Supporting solving Day-to-Day End - User problems.
• Performing Week/Month end Reconciliation.
• Direct interactions with users and seeking information as required for resolving issues.
• Performing Week/Month end Reconciliation Activities.
• Periodic Communication to Users Regarding the process on the issues being worked on.
• Analysis of the Problem/Issue Reported on Remedy Toll and Suggesting Solutions.
• Reporting to TL/PM on the status of the Remedy Tickets.
• Raising SR for all Critical Issue Solution and conduct multiple OWC sessions with oracle technical support team for speedy resolution of high prioritized open issues.
• Prepare weekly status reports including the proposed solution for the solved tickets on weekly basis.

Confidential, Compton, CA

Oracle Financial Functional Consultant

Responsibilities:

• Gap analysis to understand the requirement to be developed for the customer. Defined Calendar, Currency, Chart of Accounts for General Ledger.
• Defined ledger books for different organizations.
• Implemented the Fixed Assets module, troubleshooting and conducted demos for business users.
• Defined customers and associated different parameters with the account.
• Defined Bank accounts, Payment methods, Dunning letter and Dunning letter sets, Defining Statement cycle.
• Configure the entire Tax system as per business requirements including, Tax Regimes, Tax Codes and Rules
• Posted Receivables transactions to the General Ledger and cross reconcile the transactions from all Sub ledgers to GL.
• Assisted in development of Custom Modules with custom tables, forms and reports.
• Authored Conversion specifications and ensured successful conversion of Purchase Orders, Inventory, Suppliers and AP Invoices from legacy system to Oracle.
• Designed functional specs for Customized AP Check Print format and obtained approval from disbursement bank.
• Product support and testing for the forms and reports created for the business users and customers.

Confidential, La Crosse, WI

Oracle Financial Functional Consultant

Responsibilities:

• Assisted with the Configuration General ledger accounting setups, AGIS and Multi currencies
• Assisted with AP including P2P cycle and integration with FA as well
• Worked on Record 2 Report (R2R) Business process
• Prepared the super and power users for CRP
• Conducted the CRP and prepared the Test Scripts (TE 40). Executed the Test Scripts
• Involved with technical team with conversion of historical data for Accounts Receivables
• Prepared the functional extension design documents (MD 50) for each RICE components in AR
• Tracked the issues and resolution during CRP1 through to UAT
• Conducted CRP1, CRP2 and Coordinate UAT session
• Provided the complete document transition with BR100, TE40, MD50, BR150, BP80 etc.,

Confidential, Las Vegas, NV

Oracle Financial Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes and requirement gathering
• Performed on-site requirement analysis and developed functional specifications for the modules and customized processes
• Prepared the various documents required under the AIM methodology
• Conducted Business Process Review (BPR) and GAP analysis to determine business requirements
• Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
• Defined System Item like Descriptive Flex Field, Organization, Bank etc
• Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set, auto invoice tuning
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined distribution sets
• Defined receipt class, specifying creation method, Payment method, clearing method, defined collectors, defining aging buckets
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.

Confidential, NY

Oracle Financial Functional Consultant

Responsibilities:

• Documented high level Current Business practices (BP 40) as a part of As-Is business process
• Involved in Requirements Analysis, Design, Data Mapping and Client Interaction
• Designed and mapped the Chart of Accounts as per Management’s requirement
• Designed the Customization of the Oracle seeded AP Check Printing Report to generate checks that are to be paid to suppliers. Tested various scenarios on custom check stock of client including and underflow and overflow of invoices tied to payment batches
• Defined Customers and attached customer profile classes, Invoice rules, Sales Persons, Transaction types, Payment Terms in Accounts Receivable
• Posted journals in Receivables during creation of Non-Cash Transactions
• Defined Lockboxes and aging buckets in Account receivables
• Designed Functional Specs for Customizing Incomplete invoice report, Payment terms listing report
• Preparation of Functional Design documents based on the gaps identified for the technical team
• Attending global teleconferences for giving updates to the global implementation managers
• Created test scripts, trained end users and provided post production support.

Confidential

Jr. Oracle Functional Consultant (offshore)

Responsibilities:

• Review internal training material for quick reference to understand the core functionality and to provide quick assistance to functional team.
• Assist internal implementation team as shadow support and create relevant documentation
• Create RD20, Create and update BR100, TE40 and BP80
• Supporting core Oracle team with configuration, documentation and testing
• Creating User manuals and training materials in all financials modules
• Following with Oracle support to solve the problems through raising SR and performing individual research as well.

Confidential

Strategist in Central Purchasing Department

Responsibilities:

• Create Strategies for procurements of machine parts for the automotive division which comes under the direct purchasing sub-division.
• Create strategy for escalating the suppliers in the supplier pyramid with changing the status of the suppliers to preferred, essential and technology specialist suppliers.
• Analyze supplier traffic light and conducted the integrated supplier assessment
• Create formula for supplier filter based on existing results of supplier relationship management