SUMMARY

• 12 years of overall experience with above 8.6 years of experience in Oracle Financials & Oracle Applications, upgrade of apps, testing, setting up Oracle EBS modules 11i and R12 of ERP, and Designing solutions, Developing Function Specifications for Interfaces, Conversions and Customizations.
• Profound experience in Implementation/Reimplementation and Upgrade of Oracle EBS from 11i to R12.
• Expertise in configuration of Oracle Applications, Analyzing business requirements and Designing functional solutions using AIM and other methodologies.
• Expertise on the Order to Cash&Procure to PayBusiness transactions.
• Specialty skills of Oracle Applications Customizations, Implementation and post production support, in AR, AP, GL,FA,SLA,CE,OM, PO,INV, AOL and System Administration.
• Have fair idea of the various modules like iExpenses, EB - Tax,AME.
• Expertise in QA methodologies and creation of Test cases.
• Experience in using Star Team Tool and Tidal Scheduler, QC Client.
• Expertise in Production support, Trouble shooting of Customizations and Implementation of Oracle Apps suites of modules.
• Expertise in Period Close Activities for Financial Modules.
• Good Functional Understanding of Business processes having the academic knowledge of Finance and ERP pursued through my education.

TECHNICAL SKILLS

APPS MODULES: Accounts Receivables (AR), Oracle Payables (AP), General Ledger (GL), Fixed Assets (FA), SLA, Purchasing, Order Management, Application Object Library(AOL), Inventory,Cash Management, E-Business Tax,iExpenses.AME.

RDBMS: Oracle 10g/9i/8i/7.0, PL/SQL

TOOLS: Oracle Reports, Forms, SQL*Loader, SQL*Plus, PL/SQL, Testing Tools, Oracle TKProf and Trace, Developer2000, Discoverer, XML Publisher, Web ADI, FSG.

O/S & HARDWARE: IBM PC-AT compatibles, Compaq Pentium/486, HP UX 9000 Machines, Sun Solaris, HP-UNIX, Linux, Windows NT/2000.

PROFESSIONAL EXPERIENCE

Confidential

Functional Analyst

Responsibilities:

• Production Support for Order to Cash business process involving Oracle AR, Pricing, Intercompany and Cash Applications.
• Leverage Subject Matter Expertise in analyzing and troubleshooting complex system r user issues to drive to resolution and determine root cause.
• Coordinate issue resolution efforts across peer support groups, technical support teams and vendors as required.
• Effectively coordinate and communicate issue resolution with end users.
• Correlate related production issues and assess trends to identify broader improvement opportunities.
• Financial Consultant for R12 Upgrade project for Oracle AR.

Confidential

Functional Analyst/BI Reporting

Responsibilities:

• Client was decommissioning old mainframe system and used to generate financial and operational reporting by feeding data into MS-Access database.
• Involved in identifying & Performing GAP analysis on reports those does not exist in EBS. .
• Gather reporting requirements by business users and articulate value add for business by implementing BI reporting for their business requirements.
• Role of Functional analyst for a Transformation project in BI space at Confidential Corporation that involve Integrating boundary systems with BI and bringing users from other business functions (other than Finance Teams) onto OBIEE for operational and analytical reporting needs.
• Prepare logical data modeling and solution design for BI dimensions and facts for Oracle EBS R12 tables, creating functional specification for reports and solution Testing and supporting UAT.
• Sunset custom built Cost Management system and enabling business users to leverage OBIEE capabilities for operational and Analytical reporting.
• Prepare solution design for and improving Costing visibility and simplify reconciliation process.
• Automation of Dealer managements operational and Analytical report distribution, elimination of access databases, manual processes and making OBIEE as source data warehouse

Confidential

Responsibilities:

• Involved in 6 weeks blue printing session with business at Onsite demonstrating business value add implementing Oracle EBS R12.
• Conducted CRP sessions for business users and do initial FIT/GAP analysis.
• Involved in workshop sessions with business users doing Proof of Concept for solutions on R12.

Confidential

Responsibilities:

• Perform System Testing for P2P Custom components going through BSD (Business Solutions Documents) and FSD (Functional specification Document).
• Configured EB-Tax Rules and simulate taxation for Payables.
• Provided support for SIT and UAT for R2R and P2P tracks.
• Efficient internal ordering process for over 8,000 stores
• Optimized spend categorization and cost center accounting at source
• Improved supplier collaboration by bring over 1500+ vendors on iSupplier portal
• Improve Inventory visibility
• Travelled Onsite for Post Production support after Go-Live and assisted business users

Confidential

Responsibilities:

• High Level and Detail Solution Design activities
• System Integration Testing and Assisting the users in User Acceptance Testing
• Issue Resolution for Customization of Oracle Finance modules used by the Client
• Prepared Train the Trainer documents on R12 delta features.
• Release12 solution deployment
• Providing Support during Cutover and Go-Live
• Post Go-Live Support Activities
• Functional Testing of Remediated Custom components during Unit Testing and SIT.
• Follow up with Oracle for resolution on SR’s to get the solutions for the various bugs and get Patches applied and do complete testing.
• Coordinating with onsite team and assisting technical team (Offshore).
• Prepared training manuals for Oracle Report Manager

Confidential

Financial Functional Consultant

Responsibilities:

• R12 Reimplementation for a reputed Software Technology Industry in USA having its presence across the globe in 29 Countries.
• Gather Business Requirements & configure financial applications in POC instance.
• Involved in doing R12 Functional impact assessment for Custom objects(FRICEW) Migration from 11i to R12.
• Prepared CV040 Documents for Conversions in Financial modules like AR, AP and FA.
• Prepared Test Scripts for Financial Modules AR, AP, GL, FA, MDM&iExpenses.
• Performing FUT & String Testing for Migrations and Conversions in Financial applications.

Confidential

Responsibilities:

• R12 Implementation for a reputed Life Sciences Industry in USA for Procure to Pay Business Flow.
• Involved in Configuring Payablesmodule and providing post production support.
• Prepare Documentation based on AIM methodology and prepared Test Scripts.
• Involved in the integration cycles and testing for Payables& E-Buss Tax module as Offshore resource for the Procure to Pay team
• Follow up with Oracle SR to resolve the defects and get Patches applied by DBA’s and do testing.
• Setup Client meetings to help in reconciliation activities for the Financial Modules during UAT and for the first period close in Production Instance.
• Actively participate in the troubleshooting phase once the product has gone "live”.
• Responsible for developing and adhering to engagement team project standards to ensure the delivery of quality client deliverables.

Confidential

Business Analyst/Financial Functional Consultant

Responsibilities:

• Modules supported were Payables, Receivables, General Ledger, Cash Management and Fixed Assets, Purchasing and Order Management.
• Maintained a good record of SLA’s onTrack IT helpdesk system followed by the business with good response time and efficient resolution to the end users.
• Supported for High critical production issues from financial modules while performing period close activities, reconciliation issues as well as reporting needs.
• Worked with Oracle support to raise SR’s to get the solutions for the various bugs and get Patches applied to the applications and do complete testing.
• Also worked on Web ADI issues, identified bugs and got patches applied from Oracle On Demand.
• Assisted Technical team in various Enhancements in Financial Modules and Interfaces.
• Played a significant role in configuring Wal-Mart Payment Processing for their custom Business requirements and Setting up electronic payments through NACHA for ACH.
• Performed Data purge activities on Financial and Supply chain modules as per business approval to remove obsolete data.
• Efficient and effective resolution for the reconciliation issues faced during period close activities taking them on high priority activity for my work tasks.
• Also supported third party application GL Wand used by the business for financial reporting needs.
• Responsibilities Ensure production of timely support in addressing incidences, issues and troubles pertaining to Oracle Applications
• Work with Oracle on demand team for data fixes, bug fixes, patches etc.
• Understand financial impact and suggest fixes. Support month end activities.
• Understand the business process and suggest process improvements.
• Involved in gathering business requirement for all process improvements.
• Prepare Functional design documents (MD50).
• Guide and lead on support activities from a Functional perspective.
• Development and roll-out of project
• Implemented roll out of fixed assets modules for US and Fiji Operating Units.

Confidential

BSA/Functional Analyst

Responsibilities:

• Gathering requirements, Functional & Technical specifications Design Document, Business Requirement Documents, Gap Analysis to ensure all the key Process areas are covered.
• Wasinvolved closely in the upgrade assessment of R12 and rollout implementation of various modules.
• Worked with Oracle support to raise SR’s to get the solutions for the various bugs.
• Worked closely with the DBA's to get the patches applied and tested the various patches, patch sets for the various modules GL, AP, AR, OM
• Created all the required documents based on the AIM of Oracle.
• Implemented various work units, analyzed the requirements from the end users and prepared the documents, co-ordinate with the concerned teams and trained the end users.
• Performed functionality test of 11i modules, end-to-end testing data through the interfaces
• Used Team Track for Bug Escalation and follow-ups; and used TOAD to perform backend testing
• Prepared various test cases to make sure the work units are functioning as designed
• Involved in trouble shooting of various work units and production support activities.
• Developed and trouble shoot various FSG's for the users and developed few adhoc reports for the auditors during the auditing
• Performed Period Close support activities.
• Supported various users in different states and countries.

Confidential

Sr. Analyst/Consultant

Responsibilities:

• Developing and testing interfaces for GL, AP and AR modules.
• Handling tickets on Trackweb tool and doing Post production support.
• Created all the required documents based on the AIM of Oracle.
• Involved in the Multi-Org Implementation of Oracle Applications including Manufacturing and Financial modules.
• Trouble shooting of Order and customer import into Oracle Applications from a web storefront database.
• Worked on R12 upgrade and Configurations on test environment.

Confidential

Sr. Analyst

Responsibilities:

• Worked on Financial & Distribution modules like AR, AP, GL, OM, POand CE.
• Created all the required documents based on the AIM of Oracle.
• Prepared several SOP’s (Standard Operating Procedures)
• Prepared Unit Test Scripts and Integration Test scripts based on AIM.
• Involved in the Multi-Org Implementation of Oracle Applications including Manufacturing and Financial modules.
• Trouble shooting of Order and customer import into Oracle Applications from a web storefront database
• Was given comprehensive training for Oracle Financial Modules and given hands-on sessions.