PROFESSIONAL SUMMARY:

• Recent hands on experience in multiple R12 upgradations including performing assessment of R12 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), 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.
• 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 helps 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.

TECHNICAL SKILLS:

• Oracle E-Business Suite (Financials, P2P, O2C) 11i and 12

PROFESSIONAL EXPERIENCE:

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.
• Develop complex Treasury 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.
• 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
• 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 upgradation from 11i, prepared assessment report, coordinated with business stakeholders, Apps DBA’ users and prepared upgradation plan to proceed, created test plan and test execution for the upgradation, coordination Oracle support thought the upgradation project
• Configured r12 upgradation setups as needed across EBATX, AP, AR, GL, Inventory costing, Project Costing/Billing and SLA
• Led CRP, UAT, SIT and production cut over planning
• Work with business users across GL, AP, AR, FA, CE and Treasury and build custom reports including preparation MD050, coordination with offshore technical developer and including FSG reports across GL Balances, transactional reports across sub ledgers
• Written SQL 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.
• 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.
• 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) help 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 help 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 helpdesk issues, performance issues, and CEMLI issues.

Confidential, Baltimore, MD

Lead Oracle Functional Consultant

Responsibilities:

• 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 

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.