SUMMARY:

• Confidential has 14 years of Consulting, Development and Management experience in Oracle E - business Suite ERP.
• This includes experience in Implementation, R12 Upgrade, Support and Core Product Development for the complete End-to-End projects in 11i & R12 E-Business Suite.
• Confidential has worked upon various Oracle application modules including Order Management, Advanced Pricing, Oracle Channel Revenue Management / Trade Management, Account Receivables, Payables, Purchasing & I expense, Inventory, Oracle Subledger Accounting, Oracle General Ledger & Oracle HRMS
• Confidential has been working in Oracle Channel Revenue Management from past 6.5 years.
• He has been Implementing various sub-modules of OChRM like Trade Planning includes Budgets & Offers, Direct Sale Accruals & POS(IDSM) calculation, Backdated /Retro Offer & Accrual Adjustments, Return Sales, Promotional Accounting, TM SLA customization, Promotional / Non- Promo Claim settlement, Deduction Management, & Release/true up calculation with adequate Tracking, Reporting and Reconciliation.
• It should support the calculation of Accruals by OLD Confidential 605 and upcoming Confidential 606 standards.
• There is also a need to calculate the True up/ Release calculation which follows the revenue principle and Tie back each accrual adjustment to original shipment accrual period.
• In addition to this, Confidential / Preview process was implemented to review actual vs forecast impact which is reviewed with Higher management to get the approval for the expected hit on the Qtr end. and to know if any discrepancy happening in the Automated accrual and release process.
• Confidential has well versed knowledge of Oracle AOL library, Oracle technologies like SQL, PL/SQL, Forms/ Reports, Oracle BI Publisher, and Forms personalization, Custom WEBADI, Oracle Discoverer, Oracle SOA, Oracle ADF, OAF & Oracle Workflow.

EXPERIENCE:

Confidential

Functional / TM Architect

Responsibilities:

• Distributor Spin Process Improvement and support
• Broker Commissions & Payment Process Improvement and support
• Offer, Claim, Deduction and SLA related support
• Channel Revenue Month End process
• Reporting and Integration with Demantra Support

Confidential

Functional / TM Architect

Responsibilities:

• R12 Upgrade Implementation
• QIAC (Qcom Incentive Automation and Compliance Project)
• Convert Approx. $2B Spreadsheet Accruals to TM without P&L hit
• Business line Alignment
• Chipset Rebate Process
• QTIL Direct Rebates Process
• FLEXSKU Integration
• NXP Integration (Upcoming)

Confidential

Functional / Architect

Responsibilities:

• Designed & Implemented Tribus Point Deal Management solution for C& Confidential to replace the IBM DemandTec Solution
• Integrated with Trade Management to automate.
• Implemented the Offer WebADI Solution for Manual Deal upload

Confidential

Functional / Architect

Responsibilities:

• Design the Freight and Revenue Claim Management solution for Confidential industry to support the Distribution of claim across different railroad companies based upon the Point / Miles formula given and support to associate claim.
• Implemented Custom Settlement for Monthly Billing Process

Confidential

Functional / Architect

Responsibilities:

• Designed Implemented Tribus Point Claim WebADI custom solution to create & update Promo & Non- promo claims through excel upload
• Implemented Tribus Point Offer WebADI solution to upload manual offers through excel upload
• Design and implemented Control Accounting Periods Extension for TM to make sure everything is accounted in TM before GL closes.
• There is a way to sweep the stuck Accrual / Claim accounting events to next open period.
• Implemented Split claim functionality in case of Partial pay in the Claims WebADI
• Implemented Tribus Point Broker commissions for Confidential to perform the calculation on Actual Selling Price after Discount and Returns for broker commission rather than the invoice amount.

Confidential

Functional / Architect

Responsibilities:

• Designed Implemented Tribus Point Claim WebADI custom solution to create & update Promo & Non- promo claims through excel upload
• Implemented Tribus Point Offer WebADI solution to upload manual offers through excel upload

Confidential

Functional / Architect

Responsibilities:

• Designed & Implemented Tribus Point Broker commissions for Confidential to perform the calculation on Actual Selling Price after Discount and Returns for broker commission rather than the invoice amount.
• Designed & Implemented Autopay functionality to create the claims from the picture of existing accruals.
• User has the flexibility to choose the existing accruals and pay to the customer.
• There is functionality to reverse the accruals if booked wrongly.
• Implemented Tribus Point Claim WebADI custom solution to create & update Promo & Non- promo claims through excel upload
• Implemented Tribus Point Offer WebADI solution to upload manual offers through excel upload

Confidential

Techno Functional

Responsibilities:

• Design and Developed Conversion, Interfaces, Reports and Customized workflow
• Implemented Monthly billing process and Customer Balance forward functionality
• Automated AR Lockbox process, Automation of AP Invoice process, Approval workflow and various Custom Payment format processes.
• Implemented Supplier Remittance Advice
• Developed Complex Pricing and modifier interfaces from Mainframe to Oracle EBS
• Designed and Developed HRMS Conversions and Positive pay outbound file
• Developed various custom KPI reports
• Customized Oracle PO workflow, AP Invoice approval workflows