SUMMARY

• Over 11+ Years of Experience in Oracle Application as a Financial Functional consultant with Certified in Oracle Receivables (R12)
• Worked with various Industries and was involved in different stages of a project like implementation, Development, Roll - out, upgrade and Support Projects.
• Proficient experience in P2P (Procure to Pay) and O2C (Order to Cash) with Modules such as General Ledger (GL), Fixed Assets (FA), Accounts Receivable (AR), Account Payables (AP), Project billing (PJB) and Project costing (PJC), E-Business Tax (ZX), SLA.
• Possesses fair competency in modules Order Management (OM), Cash Management, Manufacturing (MFG), Costing (CST) and Inventory (INV) and Service contracts (OKS).
• Experience in reviewing Conversion programs logic.
• Handling and playing pivotal roles on Oracle implementation through various phases from requirement gathering to Go-live support including delivery and testing.
• Good understanding in PL/SQL for querying the back-end data by using tools like TOAD, SQL Developer.
• Experienced in customization by extension and modification of the standard application suite using Application Object Library.
• Strong exposure in preparation of high level functional design documents for customer application development, conversions, interfaces and reports.
• Proficient working with Oracle support, Creating and following up on SR’s. Working closely with Oracle on multiple issues based on priority including identifying bugs and following up with Oracle development and support team.
• Trained client super users and users on the application and also conducted unit testing and integration testing.
• Excellent analytical problem solving and communication skills with ability to be an effective team player and work under severe time constraints.
• 7+ months worked in UK as primary point of contact for all production support issues across financial modules in Steria UK.

TECHNICAL SKILLS

• Oracle EBS 11i and R12
• Modules - Accounts Payables
• Accounts Receivables
• General Ledger
• Cash Management
• Fixed Assets
• Oracle Project Billing (PJB)
• Oracle Project Costing (PJC)
• SLA
• EBTax
• Service Contracts
• Order Management
• Costing.
• PL/SQL Programming.
• Application development using Oracle Forms and Reports.
• Oracle Apps Sys Admin and AOL
• Operating Systems: Windows
• Tools: Toad
• PL/SQL Developer
• Data Loader
• Ticketing Tracking Tool: Remedy
• Service now
• Kintana
• Bridge Clarify
• Support Central.

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Oracle Finance Functional Lead Consultant

Environment: Software Oracle Applications R12

Responsibilities:

• Validating custom components to Technical Review Board and obtaining approval for the same.
• Involved in weekly review meetings with various teams with accountability on the Financial, Costing and Project Modules.
• Monitoring the business users screen to understand the issues and fixing it by guiding them to complete the process in a right way.
• Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications.
• Resolving the issues on Pending Transactions from various applications.
• Resolving the month end issues and prepared a setup document for Month-end closing.
• Prepared the user training material/documents and test scripts for end users to execute their day-to-day transactions in Oracle.
• Resolved the issues on Taxes, Freight charges for the customers in Order Management Application.
• Troubleshooting the production issues on various applications (Average Costing and Standard Costing (CST), Accounts Receivable, Record to report (R2R), Project Costing and Project Billing etc. ), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Yearend processes.
• Working with different teams to resolve the issues for the assigned sites. Research the issues on Metalink and Open the TAR with Oracle for critical issues and following up with Oracle support regarding bugs and patches.
• Resolving the Issues or Errors as per the Severity level and as per the Service Level Agreement with the Client.
• Responsible for obtaining signoff on business processes and custom components from users after regress testing.
• Regular meetings with business management and IT management team to report and highlight on progress, key milestones, upcoming task and risks.
• End-User training; Trouble Shooting through Meta link.
• Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Yearend processes.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Production Support Analyzing and resolving implementation issues.

Confidential

Oracle Apps Financial Functional Lead

Environment: Software Oracle Applications R12

Responsibilities:

• The solution design, development of custom components, requirement testing, application setups, data migration, validating data, preparation for go-live milestone.
• Understanding the requirements and business processes from the requirement gathering team and business users
• Testing of standard and custom processes to ensure requirement fit and user signoff.
• Testing of standard functionality with other teams like Sabrix (tax implication), GECARS (Account receivables).
• Designing and finalizing setup documents like BR100,CF250,TE050 for setups, responsibility customization, custom component changes, test scripts etc.,
• Assisted clients in mapping and streamlining/reengineering business practices to implement various Oracle modules, which includes integrating the Oracle Applications with existing client systems, using standardized implementation methodology including reports specification development and deployment
• Responsible for developing and adhering to engagement team project standards to ensure the delivery of quality client deliverables.
• Gathered the information and built custom inbound and outbound interfaces.
• Prepared and shared various documents with client like MD050, Training documents, Test Scripts.... Adherence to guidelines from the system and accounting control check points to ensure non-violation of any SOX compliance.
• Validating custom components to Technical Review Board and obtaining approval for the same.
• Involved in weekly review meetings with various teams with accountability on the Financial Modules
• Prepared the user training material/documents and test scripts for end users to execute their day-to-day transactions in Oracle.
• Resolving the Issues or Errors as per the Severity level and as per the Service Level Agreement with the Client.
• Responsible for obtaining signoff on business processes and custom components from users after regress testing.
• Regular meetings with business management and IT management team to report and highlight on progress, key milestones, upcoming task and risks.
• Communicating with the End Users via phone calls, emails or through net meeting and explaining the procedures to resolve the issues or errors.
• Documentation of User Guides to the End users. Discussing the open tickets and closed tickets weekly with the onsite Project Manager, PL, Client Co-coordinator and Team members over the Telecom. Solving the problems as and when required. End-User training;
• Trouble Shooting through Meta link.

Confidential

Responsibilities:

• Off-shore of the Project BT Fixed Assets.
• Responsible for Fixed Assets Reporting. Which includes day-to-day activities till period end reconciliation
• Resolution of incidents received for various modules (FA, AP, GL within timeframe)
• Reproducing the Bug based issues to get the Permanent Fix from Oracle
• Creation of required setup changes for various environments of EQ1 & EQ2
• Root cause analysis for problems.
• Responsibility of Fixed Assets Period closing.
• Raising SR with Oracle and working it out for core oracle issues.
• Raising RFC’s for custom object changes or enhancements and their testing.
• Functional specification and estimation on new requirements/changes.

Confidential

Environment: Software Oracle Applications 11iLanguages

Responsibilities:

• Resolve all the application issues related to (AP,GL,FA and Project Costing and Project Billing) within SLAs; Raising SR with Oracle for Data Fix and Bug Based issues.
• Delivery of required changes for Mid-Month Software Drop
• ADHOC reports for unique data and required reconciliation, which is not available in normal scenario.

Confidential

Environment: (with skill versions)Software Oracle Applications 11i

Responsibilities:

• Responsible to complete the all the reconciliation issues of Year End and successfully done at on-site during my project assignment.
• Prioritized requests for software changes and enhancements.
• Developed many interfaces with non-Oracle Systems
• Design, Coding and Unit Testing
• Presented the change to Change Management Board for SOX controlled applications
• Single point of contact for the customer.
• Resolve all the application issues related to Financial Modules
• Raising SR with Oracle for Data Fix and Bug Based issues.
• Working on Period Closing Activities of Receivables and Payables.
• Worked with Technical Consultants to find out the problems which causing year end reconciliations.