SUMMARY:

• 16+ years of experience out of which 12+ years in IT Functional expert on Oracle EBS Applications, working in various roles like IT Business Analyst, Functional lead and Team lead and 4 years of domain experience in Finance and account in manufacturing operations.
• Extensive experience in multiple areas of Oracle Applications implementation, upgrade, support Projects, which includes, facilitating sessions defining user Requirements, performing Gap Analysis, building Functional Design for RICE objects (Reports, Interface, Conversion, Extension), Application configuration, Testing in CRP, SIT & UAT, Documentation, preparing and delivering training for users and providing Production Support
• Extensively worked on core Oracle Applications, that is, GL, AP, AR, CM, EB Tax, iexpenses FA, SLA, Cost Management, Inv including P2P (Procure to Pay), O2C (Order to Cash) cycles and Project Accounting Modules.
• Coordinate with Oracle Support on resolving high priority issues through SRs/TARs
• Coordinate with offshore teams for timely deliverables as per Project timelines
• Exposure to using PL/SQL queries.
• Has sound decision making and good problem solving skills coupled with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Tools: & Software

Toad, SQL Developer, ADI, Web ADI, Data Load, MS Visio, MS Project, SharePoint

Others: Windows Vista/XP/NT/2000/95, MS - DOS, SQL, Html, XML

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Finance Functional Lead

Oracle EBS R12.1.3

Modules - Manufacturing (INV,WIP,BOM), Distribution (PO,OM,istore) Ebiz Tax, Payables, Receivables, General Ledger

Responsibilities:

• As a Functional Lead responsibilities include the following:
• Work with Business teams to collect requirements
• Setting up Payables module, Customize the check print and Positive Pay file to Bank, Electronic Funds transfer and customized payment advise to suppliers.
• On the Receivables Module - Setting up various transaction types, Source, Receipt Batches, Bank, Auto Lockbox set ups, worked with Bank on testing of file import for Various operating units, Advanced collections etc.
• Designing solution for Instalments Billing on the AR and revenue recognition.
• Design and configure the complete 'Regime to Rate' functional solutions for EB Tax for multiple countries like Canada and USA for both AR and AP applications, including the following:
• Create multiple Regime including provisions for cross regime compounding
• Create multiple Taxes, Tax Jurisdictions, Tax Rate codes
• Create multiple Tax Rules for handling specific requirements including using Tax Determining Factor Sets and Tax Condition Sets
• Create Tax Authorities, First Party and Third party Tax profiles
• Work on Procure to Pay and Order to Cash flows.
• Participating in test cycles for CRP and UAT
• Work on documentation for Requirements gathering, Functional Solution Design, Testing, Setups, like MD50, TE40 and BR100.

Confidential - Tulsa, OK

Functional Lead Consultant - Implementation and Support

Oracle EBS R12.1.3

Modules Involved- Manufacturing (INV,WIP,BOM), Distribution (PO,OM,) Ebiz Tax, Payables, Receivables, General Ledger (US,CAN & AUS)

Responsibilities:

• As a Lead Functional Consultant, my responsibilities include the following:
• Reviewing the Business Requirements and Use cases and perform solution mapping
• Providing Functional Design Solution for financial modules, Oracle EBS for Conversions, Interfaces, Customizations of Reports
• Reviewing the Technical Design Solution
• Preparing test cases, Testing and Code review for multiple Test cycles like SIT, CRP and UAT, including triaging Defects
• Setup configurations under multiple Oracle instances to facilitate Development and Testing
• Complete documentation for Solution Design, Setups and Testing, like MD50, BR100 and TE30
• Performing Configurations on multiple Oracle EBS instances

Confidential

Functional Lead Consultant

Oracle EBS R12.1.1 - AP, AR, FA and GL

Responsibilities:

• Study of AS IS business on the 11.5.2. And various Interfaces and Custom reports with the present system.
• Interaction with the Business in finalizing the To be business in Oracle.
• Gap Analysis and Resolution.
• Identifying the required areas of customization.
• Provided user training.
• Post Production Support.

Confidential

Functional Consultant - Lead

Oracle EBS 11.5.10.2 - AR, AP and GL

Responsibilities:

• As a part of Lead Functional Consultant role, Study of AS IS business on the Mainframe System. And various Interfaces and Custom reports in the present system.
• Interaction with the Business users in finalizing the To be business in Oracle.
• Mapping and testing of the interface between third party system with Oracle.
• Preparation of AS-IS, TO-BE, MD 50, BR 100 Documents and providing functional support to the technical consultants to prepare MD 70.
• Conducted CRP to the business.

Confidential

Functional Consultant

Oracle EBS R12.1.1 - AP, AR, GL, CM

Responsibilities:

• Responsible for the following:
• Perform Requirements gathering, solution mapping, Custom solutions for gaps
• Prepare Functional Design solutions, have walkthrough sessions with Technical team, Code review, Testing and Documentation for all Custom solutions
• Work on configuring EB Taxes for multiple Legal Entities and Operating Units for AR module
• Perform the Foundation applications setups like Legal Entity, Ledger, OU, Inventory Org
• Work on Service Requests created with Oracle Support
• Major Project deliverables included the following:
• Documentation for Functional Design, Testing, Setups
• Setups completed in the related Oracle instance and the instance is ready
• Data Conversions complete and all fallouts resolved
• Interface programs running successfully and all fallouts reviewed and resolved
• Resolve Service Requests created with Oracle Support

Confidential, Columbus, OH

Oracle EBS 11.5.10.2 - Internet Expense

Responsibilities:

• Major Project responsibilities included the following:
• Implementation of Internet Expense module with Credit card functionalities.
• Successfully drove project activities with Business/ IT Consulting teams.
• Lead functional team in Business/to-be model and Gap Analysis.
• Conducted CRP,SIT and UAT
• Provided User Trainings to entire organization
• Preparing test cases and Testing
• Following were the major Project deliverables:
• Functional Design Solution documents and Test scripts

Confidential

Oracle EBS 11.5.10 - Rollout & Support AP, AR,GL, PA, Iexpenses

Responsibilities:

• As a Functional Consultant, was responsible for the following:
• Worked extensively on Rollout and Support for 11 OUs in US, EMEA and APAC having AP,AR,FA,Iexp,GL,CM and PA modules.
• Coordination of project delivery with onsite/offshore technical delivery teams.
• Monitoring and resolving critical operational issues in day to day business.
• Patch analysis and smooth migration of patch to production instance.
• Ensure smooth period, quarterly and year end closures which are critical for the Business.
• Design solution for Conversions for entities like Customers, Suppliers, AR and AP Invoices
• Work on design and development testing of Interface for AP and AR invoices
• Work with Oracle Support team on resolving the Service Requests created
• Developed XML publisher reports
• Documentation based on AIM standards for Functional Design, Setups and Testing
• Setup configurations in multiple Oracle instances
• Project issues resolution

Confidential

Oracle EBS 11.5.10.2 - AR, AP, FA, Iexp and GL

Responsibilities:

• As a Functional Consultant, was responsible for the following:
• Reviewing the Use cases and recommending solutions, be it, out of box or workarounds or Customizations
• Work on Conversions for Customer master data and AR transactions, Supplier Master data and AP transactions
• Setup configurations and Testing of custom solutions
• Major Project Deliverables included the following:
• Prepare documents for Conversions, Interfaces, other Functional solutions, Testing and Configurations

Confidential

Oracle EBS 11.5.9 - AP,AR,FA,GL

Responsibilities:

• As a Functional Consultant, performed the following responsibilities:
• Review of Use cases and proposing Custom solutions for Gaps
• Provide High level Functional Design for Custom solutions
• Create instance, identify setups that are ready and configure them
• Facilitate Setup migrations from instance to and from multiple Development instances
• Review of Technical Design documents and testing of Custom objects developed
• Project deliverables included the following:
• Document preparation for Functional Design, Conversions, Test, Setups
• Configure and migrate Setups across multiple instances

Confidential

Oracle EBS 11.5.10 - AP, AR, GL and Cash Management

Responsibilities:

• As a Functional Consultant, performed the following duties:
• Worked at Client location on requirements gathering and review AS IS conditions
• Identified functionalities that could be delivered with minimal customizations and workarounds
• In case of Customizations, provide Functional Solutions
• Work on Conversions and Interfaces for master data and important transactions
• Setup configurations in different Oracle instances
• Work in different Project test cycles, like Conference Room Pilot (CRP), Integration and Pre go live
• Training Super users and end users
• Facilitate UAT and resolve any issues identified therein
• Work on Cutover activities and GO Live for the Finance modules
• Work on Service requests with Oracle Support
• Prepare documentation for Solution Design, Testing and Setups configuration
• Setup migration into different Oracle instances
• Prepare customized reports for master data
• Complete Training for user community
• Close Sub ledger Periods and reconcile with GL

Confidential

Responsibilities:

• Review of the Development and Testing of deliverables by the team members.
• Additionally also responsible for project deliverables in the Functional Consultant role, like
• Data Conversions, Interfaces and Custom objects
• Functional Solution Design, Development, Testing and Setup configurations
• Prepare Solution Design, Test and Configuration documents
• Documentation of Solution design, Testing and Setups

Confidential

Senior Executive Finance

Responsibilities:

• Preparation MIS reports like Profit and Loss, cash flow, Materials Requirement Planning, project profitability, debtors schedule and creditors’ schedule.
• Finalization of Accounts.
• Maintaining Cost Control over expenses at both product and project level through Collective interaction.
• Liaison with Bank Officials, Creditors, Debtors and other Government Officials like Income - Tax, Sales Tax.
• Inventory Control through Stock Register and Periodic Stock taking.