SUMMARY:

• 8.6 years of experience in Oracle e - Business Suite Modules with in-depth experience in implementation, upgrade and support of software applications.
• Hands on experience with R12 and R11i Implementation, Upgrade and Support of Oracle Applications financial and supply chain modules.
• Expertise in Quoting, Order Management, Advance Pricing, TCA, Accounts Receivables, Accounts Payable, General Ledger, E-Business Tax, I-Procurement, AGIS, Fixed Assets, Inventory and Purchasing Modules.
• Extensive experience in Requirement gathering, Solution design, Setup configuration, Testing, Data Migration, Documentation, Period End closing, consolidation and Post Implementation Production support.
• Experience in system admin activities like creation and maintenance of users, creating responsibilities, etc.
• Worked on Customization and Development Reports under Oracle Apps.
• Good knowledge and understanding of general accounting principles “GAAP”.
• Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• A strong team player, and adaptable to a variety of roles. Also possess the ability to analyze situations and offer innovative cost effective solutions.

TECHNICAL SKILLS:

Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup

ERP: Oracle Financials and Supply chain (R12 and R11i)

Modules: General Ledger (GL), Accounts Payables (AP), Advance Pricing, TCA, Quoting, Order Management, E-Business Tax, I-Procurement, AGIS, Fixed Assets, Accounts Receivables (AR), Order Management, Purchasing, Inventory, i-Procurement and Purchasing.

Working and Process Flow Knowledge: Cash Management, Order Management, Inventory, Internet expenses, i-Procurement and Project Costing

Languages and tools: Reasonable understanding of SQL, MS-Office tools

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Order to Cash Functional Consultant

Responsibilities:

• As a Functional Consultant implemented financial modules: Quoting, Order Management, Inventory, Accounts Receivables, TCA Release 12 of Oracle e-Business Suite.

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for OM, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Worked on the setups of the TCA - Defined Parties, Accounts, Party Sites, Account Sites, Contacts, Contact Points, Relationships (Reciprocal and Non-Reciprocal)
• Worked on cleansing of the TCA customer data and enriching of the data using Trillium and USPS Integration.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
• Implementation of Credit Management and Collection for Design, Development, Enhancements & Custom Solution, transitioning from Oracle Advanced collections and Credit Management to FIS GET PAID. This includes Data Conversion Strategy, Solution validations and modifications accordingly
• Involved in the Testing of the OM, Advance Pricing, Shipping, AR, Credit and Collections, AP, PO and INV modules including developing Test Cases, Conducting UATs and CRPs as well as logging defects in the Mercury Quality Center tool.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Oracle e-Business Suite Release 12.1.3 and OM, Advance Pricing, Shipping, Credit and Collections, Get Paid, AR, AP, PO and INV modules

Confidential, Miami, FL

Oracle Order to Cash Functional Consultant

Responsibilities:

• Requirements gathering from end users, Requirement analysis.

• Worked on the entire Financials business process.
• Performed all the setups required for OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV
• Developed several enhancements to the Business Processes on the Financials side.
• Sub Ledger Accounting: Define the events, sources, and account derivation rules in Sub Ledger Accounting.
• Worked on the Auto Invoice setups for Accounts Receivables
• Worked in the Auto Lock Box setups in AR for Wachovia Bank and Bank of America
• Developed the Revenue Recognition process in AR for Deferred Revenue and Regular Revenue for Product and service.
• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop Shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation

Confidential, Edison, New Jersey

Order to Cash Functional Analyst

Responsibilities:

• As a Functional Consultant implemented the following modules: OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules.

• Worked on the Functional mapping of data Conversions & Enhancements for OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules
• Worked on the setups for AME including the AME Rules, Actions, Attributes, Conditions, etc.
• Worked on the setups of the TCA Module - defining parties, accounts, party sites and account sites, contacts, contract points, relationships, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Provided with useful training to the users in OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV Modules.

Confidential, Los Angeles, California

Oracle Order to Cash Functional Analyst

Responsibilities:

• Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.

• Worked on the setups of OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules
• Adapt in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Worked with end users to document the business processes & functional requirements also providing them with training materials
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
• Coordinated with client through Conference calls and WEBEX sessions to get the requirements and coordinating with the technical team for fixing the issues for proper deliverables to the client.
• Provided KT sessions to the testing and the technical teams.

Confidential

Oracle Apps Consultant

Environment: Oracle Applications - 11.5.10

Responsibilities:

• Defined Accounting Flex Field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.

• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.

Confidential

Oracle Apps Consultant

Responsibilities:

• Implemented the Inventory, Purchasing and Order Management modules.

• Defined three inventory organizations as per the company’s requirement.
• Completed required setups for the Inventory, Purchasing and Order Management modules.
• Defined transaction types for order processing such as standard order, RMA - Credit Only and RMA - Credit after receipt.
• Assigned document sequences for each of the transaction types.
• Defined Item categories, Inter-Org transfer, Freight Carriers. Sub-inventories and organization parameters.
• Defined approval limits for purchasing approvals as required by the company.
• Did the required setups for i-supplier.
• Did setups for modifiers and qualifiers and provided the pricing solutions as per the client requirements.
• Helped in setting up the UPS integration.
• Maintained customer and supplier master.
• Loaded the bin locations and created combinations for setting each item as default for individual bin locations.
• Provided a workaround for UPC codes and Tariff codes required by the client.
• Defined Shipping Parameters and document sets for Pick Release and Ship Confirm.
• Defined jobs, employees and buyers.
• Created shipping document sets, price lists and modifiers.
• Helped in data mapping and data conversions.
• Created functional design specifications for both the inventory item search and item available date to be displayed on the sales order form.
• Conducted CRP and end user training.