SUMMARY

• A qualified accountant with around 14+ years of experience as a TEMPPrincipal Oracle Cloud ERP and EBS Financials Functional consultant. Key responsibilities include working with business users and stakeholders and gathering business requirements, designing MD50, BR100, developing, mapping, configuring, Fit/Gap Analysis, testing and support of Financials and PPM (Costing/Billing), SCM (Supply Chain Management), including R12 upgradation/ re - implementation experience.
• Lead and execute with a cloud first mindset, halping customers realize benefits of an Oracle cloud ERP
• Provide assessment of current state architecture and recommendation of future state architecture
• Recent hands-on experience in implementations of multiple Oracle Cloud ERP (GL, AP, AR, FA, CE) and P2P including performing assessment of Oracle cloud migration, data conversion strategy, functional analysis, leading data conversion of master and transactional data, leading CRP, UAT/SIT and production cut over planning
• Provide roadmap and migration methodology and identify quick wins
• Provide detailed sizing and associated justification
• Successfully completed a project of re-configurations of COA as part of merger and acquisitions and led the functional setups, CRP, UAT, SIT and integrations with trading partners applications
• Lead and execute with a cloud first mind set halping customers realize benefits of an Oracle cloud-based architecture
• Identify and evangelize key business and technology benefits of adoption
• Identify functionality gaps and develop solutions to them
• Execute planning activities for Oracle projects: definition of scope, effort and timeline in your area of expertise
• Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions
• Provide production support and full solution handover to the client or delivery/application maintenance centers
• Responsible upgradation, identifying CEMLI, creation of a project plan for R12 upgrade, leading testing efforts, user training, preparation of user manuals, BR100, MD050, leading CRP, UAT, Sit and production cutover planning.
• Experience in full end to end implementation and upgrade E-Business Suite/Oracle Applications 11i, R12 financial modules General Ledger (GL), Account Payables (AP), Purchasing (PO), PPM, Project Accounting (Costing/billing), iProcurement (iProc), Fixed Assets (FA), Cash Management (CM), Treasury ¸Account Receivables (AR), Advanced Collections (AC), Credit Management (CM), iExpenses, iPayments, E-Business Tax and Supply Chain Modules Inventory (Inv), Costing, Order Management (OM).
• Good understanding and configuring regions India, Europe and Latin America Localizations for calculating regional taxes and withholding taxes.
• Conduct Conference Room Pilot (CRP) Trainings, end user trainings across Asia Pacific, Europe, South America and North America regions.
• Expertise in various Application Extensions, Conversions, and Process Re-engineering (RICE) and preparing Functional Document Design and Testing Documents developed through Oracle User Productivity Kit Professional (UPK) tool.
• Experience in providing functional impact analysis, patch and Datafix analysis on solutions provided by the Oracle product support.
• Designed and developed Oracle Web ADI, financial modules Interfaces for the legacy system data transfer.
• Experience in configuring Sub Ledger Accounting Method (SLA) for the business requirements.
• Experience in Implementing Oracle Application Implementation Methodology (AIM) and Oracle Unified Methodology (OUM) in implementation, upgrade and support projects and worked on ADP GL and eTime.
• Experience in Oracle Workflow, Approval Management Engine (AME), System Admin, Alerts and Form Personalization.
• Expertise in Patch Analysis, analyzing Release Content Documents (RCD) and Release Update Pack (RUP) for the complicated patches and advice the regression testing plan.
• Experience in developing test scripts using Quick Testing Professional (QTP) for the testing and configuring applications per the application setup documentation.
• Expertise in handling high volume data loading through Data load and using Synchronizer tool for the validation.
• Coordinated with Wells Fargo Adapter payment system integrated with Payables.
• Experience in configuring and supporting Vertex O Series tax integration with Oracle Payables.
• Expertise in documentation using AIM/OUM methodology like RD020, BP020, BP040, CF250, BR100, MD050, CV040, BR030 and TE020, TE040 documents.
• Expertise in implementing Financial System Generator (FSG) and Global Consolidating System (GCS) per business reporting needs and which halps in top level management decisions too.
• Worked on different defect monitor tools like Quality Center, Remedy Incident Tool, JIRA, BMC Service Desk tools for the tracking defects/issues on E-Business Suite.
• Experience in Financials Month End Close process (MEC) by providing pre-closure activities, post-close activities and taking precautionary measurements to make MEC close smoothly.
• Developed extensive queries through SQL for financials modules. Built complex queries required for the business users as well as to work in Product Support environment issues.
• Experience in writing PL/SQL Queries, Packages, Stored Procedures, Functions, Triggers and Developer 6i (Forms and Reports).
• Manage offshore/onsite teams to make sure client requirements/issues understanding correct and to deliver the requirements as expected.
• Excellent communication, presentation, interpersonal, leadership skills and team oriented to deliver the outputs to the organizations and client.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Oracle Functional Consultant

Responsibilities:

• Part of Oracle Cloud discovery to delivery team and responsible for coordination with stakeholders, users and implementation partners and migration and implementation of Oracle cloud Financials, which includes leading data conversions, Requirement gathering with the business owners and prepared the necessary documents, Understanding the existing Legacy system functionality, Configure Fusion Functional Setup Manager, Define Applications Configurations, Configuring Fusion Sub ledger Accounting (SLA), prepare FBDI templates, coordination technical and QA team and setup UAT/SIT and cut over planning
• Identify gaps in current functionality, solution design, configurations and test results
• Solution design for new enhancements and work with technical team in build and testing new functionalities.
• Worked on new functionality and enhancements for Invoice Approval Workflow, Requisition, Change Requisition, Expense Reports, Purchase Order workflows.
• Help business to setup Treasury configurations for new bond issues, short term investments, buy back on Bonds.
• Worked on ADP GL and eTime system for Payroll process and load them into EBS.
• Worked on AventX third party communication system to send emails and fax to vendors.
• Conversion of Chart of Accounts from 9 segments to 6 segments with Eprentise tool.
• Production support for EBS system, PowerPlan with coordination or Technical, DBA, Oracle Support, and other system teams.
• Worked in design and implementation of Oracle Cloud ERP integrations with downstream and upstream applications
• Worked on solution design for integrating with systems Hyperion, OBIEE, PowerPlan, ADP, Oracle CCB, Maximo, SAP etc.
• Work with Middleware Teams SOA, UC4 systems for integration with other systems.
• Architecting EBS system for Automation Team for developing Automated Test Scripts in UFT.
• Support in month end closing process and issues for the financial modules.

Confidential, Orrville, OH

Senior Oracle Functional Consultant

Responsibilities:

• Prepare project plan with timelines for the phases of project, conduct phase gate meetings with business stakeholders.
• Schedule meetings with business users for understanding current design and gathering new business requirements.
• Support in month end closing process and issues for the financial modules. Propose enhancement recommendations on the GL configurations.
• Develop complex month end required reports in GL and Treasury module reports FX Hedging, Debt Maturity Schedule, Debt Weighted Average Report, Investment Mark to Market Report etc.
• Provide new functionality design which drives the reports to various debt categories of debt and invest instruments.
• Configure financial modules with recommended functional solutions in GL, AP, CE and Treasury modules.
• Provide functional solution for amortization of capitalized costs, discount and derivative gain/loss.
• Prepare mapping template for requirement gatherings and map to e-business suite functionality.
• Prepare functional design document MD050 and conduct meeting with business before build starts.
• Debug current report code SQL, PL/SQL, Java and OA Framework to understand existing report logic and suggest new changes for new report.
• Coordinate with technical team to get the report development completed.
• Prepare test scripts TE20 for system testing and give inputs to QA team for preparing UAT test cases.
• Use HP ALM for defect tracking, to track testing status.
• Prepare cut-over document for the activities to be followed while production deployment.
• Make sure offshore team get access and other infrastructure by coordinating with business.

Confidential, Cincinnati, OH

Senior Oracle Functional Consultant

Responsibilities:

• Involved in assessment of R12 chart of accounts upgrade from 9 segments to 11 segments, prepared assessment report, coordinated with business stakeholders, and prepared upgradation plan to proceed, created test plan and test execution for the upgradation, coordination Eprentise third party tool for upgrading chart of accounts.
• Develop new functionality while upgrading GL chart of accounts with new processes required for the business respective to financial modules.
• Update Ledger changes with new process and configurations required for chart of accounts upgrade.
• Develop AR invoices interface and Receipts interface for loading new invoices as part of conversion and close receipts for the past invoices through interface program developed.
• Assist in Period Close Activities, Year Close Activities for the financials modules by halping business to reconcile subledger modules balances with General Ledger.
• ConfiguredRr12 upgradation setups as needed across EBATX, AP, AR, GL, OCM, Advance Collections, Inventory costing, Project Costing/Billing and SLA
• Led CRP, UAT, SIT and production cut over planning.
• Work with business users across General Ledger, Accounts Payable, Accounts Receivables, Cash Management, Credit Management, Advance Collections and build custom reports including preparation MD050, coordination with offshore technical developer and including FSG reports across GL Balances, transactional reports across sub ledgers.
• Write SQL queries and debug PL/SQL, Java and OA Framework as part of period end reconciliation including using GL tables, SLA tables and sub ledger tables.
• Implemented internal sales order(ISO) processing and related intercompany accounting across the different ledgers.
• Added new OU’ as part of R12 upgradation and take care of conversions, functional design and reporting for new OU’s.
• Primary point of contract for P2P and Financials users and supporting across multiple ledgers and OU’s including month end closing activity and reconciliation.

Confidential, Englewood, CO

Senior Oracle Functional Consultant

Responsibilities:

• Provide new version additional features and impact analysis on both functional and CEMLI components to present to the business on modules GL, AP, AR, AC, CM, CE, FA, iProc, PO, AME and localizations.
• Conduct meetings with business key users, stakeholders and steering committee at different levels of project phase like Development Phase, SIT Phase, CRP, UAT Phase
• Conduct Conference Room Pilot CRP training to the key users across the regions Asia Pacific, Europe, South America and North America regions
• Prepare Test Scripts and execute according to the current business scenarios including Latin America Localizations in addition to the Italy Localization.
• Conduct SIT Testing and coordinate with third party owners to make sure inbound and outbound files are placed required path.
• Configure General Ledger, Accounts Payable, Fixed Assets, Accounts Receivables, Cash Management, Credit Management, Advance Collections, Localizations and update BR100.
• Troubleshoot period close activities show stopper issues and work with product support on critical basis. Also halps business users in reconciling subledgers and provide workarounds for showstopper issues.
• Prepare Cut Over documentation for the analysis and reports required to validate the data after upgrade.
• Coordinate with DBA and Technical team and third party systems for the end to end business flow run successfully.
• Log defect and work with product support for the issues encountered at different levels of upgrade phase.
• Work on Quality Center (QC) defects for the raised issues/defects and coordinate with the business super users to resolve defects.
• Prepare Standard Operating Procedure (SOP) documents for the end users and User Manuals which shows differences between R12.0.6 version to R12.1.3

Confidential, Atlanta, GA

Lead Oracle Functional Consultant

Responsibilities:

• Work on environment of Supply Management Modules, Procure to Pay process modules.
• Managed day to day business issues for AP, PO, iProc, Workflow, GL modules. Handle critical and show stopper PROD issues.
• Provided Continual Service Improvements (CSI) for various areas to improve after analyzing the gaps or difficulties of the business process
• Worked with Quality Center (QC) halp desk and Remedy Incident tools to resolve Level 2 and Level 3 issues.
• Worked and supported mock close in stage environments and Month End Process (MEC) for PROD financial and AP module.
• Worked on Vertex O Series team for the tax calculation functionality and Oracle Product support for the tax issues.
• Work with Wells Fargo Adapter team for the electronic payments made and integrated with Wells Fargo Bank in regular payments made through AP.
• Perform upgrade analysis required upgrade from R12.1.2 to R12.1.3 and provided impact analysis. Analyze existing functionality and advice business or CEMLI for any changes required.
• Prepare Test Cases and perform testing for the enhancements and post upgrade functionalities by capturing results with UPK.
• Work in the environment Transcepta, OSN, XML Gateway and AP Interfaces.
• Assist end users directly, super users in resolving the issues through phone, Cisco or Oracle Stbeehive OWC and providing instructions to the users.
• Initiate Bridge/Critical calls and involved every team and managed the call until the show stopper issue got resolved.
• Performed in finding the Root Causes Analysis (RCA) issues and prepared documentation and provided precautionary instructions.
• Schedule resources for the critical issues, MEC plan, and Monthly Releases Deployment into PROD.
• Coordinate Offshore/Onsite team for the different issues, schedules, meetings, client requirements to get good understanding between teams and client requirements/issues.
• Prepare business process document, support document, user manuals, test cases for the enhancements and extensions.
• Prepare Whitepapers for the ongoing chronic issues to halp other teams in the organization.
• Lead and provide the status in client meetings for various issues on weekly basis, organize conferences, meetings for the regular issues.
• Provide KTs to the super users, presentation new changes/process required.
• Prepare different types of status reports for project activities and report to management.
• Coordinate with client, DBA, functional and technical team for the halpdesk issues, performance issues, and CEMLI issues.

Confidential, Baltimore, MD

Lead Oracle Functional Consultant

Responsibilities:

• Support for iExpenses, iProc, PO, AP, GL, and FA modules.
• Helpdesk support through the tool BMC Service Desk tool and assist users in resolving day to day business issues.
• Gather business requirements and design and build the solution with the coordination of CEMLI team.
• Perform Roll outs and Multi-Org setups and for new operating units and deactivate any existing operating units per prepared BR100 document.
• Support super users in setting up COA values in addition or disabling of the new changes in business.
• Developed excel sheet for the AP Open Interface program for large volume of invoices entered on regular basis.
• System Administration Setups for Users, Responsibilities, Menus and Request Groups for the new user groups added in new roll outs.
• Configure new Ledgers, COA, Calendar and OU’s for the new businesses added which cannot be aligned to the existing applications configuration.
• Support employees in iExpenses and provide clarifications, workarounds immediately at their desks, mails, and phone and WebEx web conferences.
• Support iExpenses Credit Card functionality / EDI implemented and coordinated HDFC bank for the frequent issues.
• Work with Oracle Support for the issues and coordinating with DBA to close the issues.
• Perform Patch Analysis for the patches, Generic Data Fixes GDF and deploy the Master Diagnostics Scripts (MGDF) in PROD to find any data corruption on the transactions.
• Write SQL queries to provide data to the client on any emergency one-time need.
• Attend daily conference calls to coordinate with on-site team on support and prepare status reports.

Confidential

Senior Oracle Functional Consultant

Responsibilities:

• Work in the Supply Chain Management Modules, Order to Cycle Modules, Procure to Pay process modules.
• High volume application setups per day to day business need HR Positions, Jobs, and Organization Hierarchy setup through QTP testing tool and Dataload.
• GL, AP, iExpenses, AR, AOL, PO, HR, OM, PA, Form Personalization and related application Setups for new rollouts added.
• Extracting application setups data through SQL queries and validate them through excel sheet.
• Support month end close for the financial modules.
• Prepare weekly and monthly estimation on time schedule and efforts/resources required for the bulk volume setups.
• Configuring customized form which will be applied for automatic Generic Datafix (GDF) for known issues.
• Proactively developed and test custom HR interface program to load daily high volume data required to setup.
• Develop and run QTP Scripts and DataLoad for bulk data.
• Write financial modules, system administrator SQL Queries to extract and validate the setups for bulk data.
• Interacting with client on clarifications of setups.
• Setup changes and validating the same to ensure the deliverables quality.

Confidential

Senior Oracle Functional Consultant

Responsibilities:

• Production Global Support for GL, AP, PO, AR, CM modules, work on Sev-1, Sev-2 Services Requests raised by clients across globe.
• Support FSG issues and configure FSG accordingly business changes.
• Coordinate On-Demand DBA team, Development team and thirty parties required to resolve third party integrated functionality.
• Plan instance Refresh Schedules for the stage, development and test instances.
• Prepare weekly status report on the worked issues.
• Interacting with end users for the clarification on issues through phone, email or web conference.
• Setup changes and validating the same to ensure the deliverables quality.
• Suggesting work around on critical problems.

Confidential, Boca Raton, FL

Oracle Functional Consultant (Offshore - India)

Responsibilities:

• Worked on GL, AP, AR, FA, CE, iProc, iPayments, iReceivables, and iSetup.
• Configure iSetup module and run to load application configurations from one instance to another test instances.
• Update BR100 as per change in Business requirement.
• Review BR030, BP080, and MD050 and prepare Test Scripts for Shakedown and Regression testing.
• Execute Test Scripts as per Shakedown and Regression test documents.
• Setup changes and validating the same to ensure the deliverables quality.
• Prepare application setup queries for all the financial and SCM modules to utilize them in Instances comparison utility tool (E-ICU Tool).
• Validate different instances application configuration to make them in sync with the BR100 by extracting the data from the backend.
• Work on Advanced utilities (Synchronizer) to compare the high volume data extracted after Instance t Instance Setups completed.
• Load the large volume setups by Data Load tool for and validate them to ensure the quality.
• Attend scheduled conferences daily to interact with Onsite team and Client manager about work, issues, clarifications and deliverables.

Confidential

Oracle Functional Consultant

Responsibilities:

• Gathering Business Requirement Documents for the new Modules Implementation and analyzing the gaps and Suggesting optimum solutions.
• Engaging with client on new requirements, prepare As-Is Process, To-Be process and study gap analysis and mapping the requirement in BR030.
• Developed AR Interface custom stage program to load legacy data into AR interface.
• Created various new custom reports for AP, GL, AR, Cash Management and Asset modules.
• Prepare Functional specifications and coordination with technical team for various customizations, interface analysis and designing the interface.
• Prepare User Acceptance Test Scripts as per the Business process scenarios and coordinating the same with Client.
• Applications setups for new rollouts and enhancements.
• Prepare various documentation like BP020, BP040, BR030, RD20, MD050, BR100, CV040, TE20, TE40.
• Perform mock close and support Month End Closing and making sure soft close period.
• Level 3 Support for month-end activities for financial modules, and coordinate with Technical and DBA for interrelated support issues.
• Interacting with end users for understanding issues and impact of severity of the issue, then resolving the issue based on priority setup.