Oracle Sales

Shefali Sharma

Cell: 408-***-****, E-mail: ***************@*****.***, Add: 2296 Skyline drive, Milpitas, CA

SUMMARY

* ***** ** ******-********** Expertise to provide expert consultancy on implementation and functionality of PO, INV, OM, WMS, Advanced Pricing, AR, General Ledger, Assets, CRM (Service Contracts) Modules in Oracle E-Business R12 and 11i.

Proficient in Programming Using SQL, PL/SQL, Reports 6i, XML publisher, Forms 6i, Forms 10G.

Oracle Certified Associate

Onsite experience (Agilent technologies, Malaysia)

Strong experience of working in a onsite-offshore model

PROFESSIONAL EXPERIENCE

IBM India Pvt. Ltd, Bangalore Sep 10 – Feb 12

Senior Developer

Client: Kinetic concepts Inc.

Ebiz version: Oracle R12

KCI is a leading global medical technology company.

• Developed an extension Inventory Cost Element Breakout and Automate FA Mass Additions to post the assets as per the inventory cost breakup

• Developed an extension C2C 143 Handling Multiple Pricing Models which handled multiple pricing scenarios by calculating values for custom pricing attributes

• Developed a Form that enabled the users to find the cash receipts based on customers and called PayPal APIs to process refunds.

• Worked on extension C2C.E.390 Quote Agreement Integration to create service contracts based on core contracts.

• Worked on R12 upgrade.

• Lead a team of 5 and did a POC for L3 support activities.

• Was responsible for creating MD70s, Unit test scripts.

Technology: SQL, PLSQL, Forms 10G, Reports

Tesco Hsc, Bangalore Nov 09 –Aug 10

Senior Developer

Ebiz version: Oracle R12

Tesco Public Limited is a UK-based international grocery and general merchandising retail chain.

One of the new lines of business they are initiating is Marketplace where sellers can sell their products to customers using Tesco website. Worked with Infosys Technologies for this implementation as a part of Tesco IT.

• Handled Oracle financials side from Tesco HSC.

• Developed Order import inbound interface to receive the data from OMS sterling via Tibco using advanced queues.

• Developed an extension Tesco Create Refund for Open Credit Memos that applied all the open invoices to the credit memos and applied refund for the due amount using standard Oracle APIs if a negative amount was due for a seller.

• Developed a host program Tesco Create Transactions for Pricing Events to pick up pricing event data, put it into a staging table and then call a custom component to create transactions in AR.

• Developed an outbound interface Tesco Mkp Journal Feed to Tesco Plc. to take the data from GL based on the input period, default set of books id and push into the interface tables.

Technology: SQL, PLSQL, Advanced Queues, XML publisher

Oracle India Private Limited, Bangalore Jan 06 – Nov 09

Associate Consultant

Client: Agilent Technologies

Ebiz version: Oracle R11.5.10

Agilent Technologies is the world's premier measurement company. Agilent provides core electronic and bio-analytical measurement tools to advance the electronics, communications and petrochemical industry.

• Worked on 30 days advanced Distributor Pricing Project –It involved deriving the 30 days’ advanced price by calling pricing APIs with required parameters and developing a extract program to extract the prices and send it to a third party application for processing.

• Worked on Pricing Research to improve pricing performance in production environment.

I was involved in taking requirements directly from client, suggesting a solution and doing POCs on following:

1. Static Pricing: Static pricing was to defer the online calculation for price happening on sales orders/quotes and instead use the pricing repository (which consists of already calculated prices).

2. Study of Archiving and multi currency feature and implementing the same on development instance.

• Developed XXAT: Pricing Data Report to pull archived pricing data from standard archiving tables.

• Developed XXAT: Archive Pricing Entity to Temporary Tables, a wrapper on standard archiving functionality so that multiple prices list can be archived at one shot. .

• Worked on Planning Auto schedule Automation, Agilent had created a customization to suppress zero forecasts and that required to put requisition import on hold and then run planning auto schedule and then remove the hold for each org. This object was aimed at automating this process..

• Worked on support project in PO, OM, INV and WMS modules. Handled issues related to the purchase requisitions and orders, sales orders, issues in the transactions, on hand quantity and serial numbers.

• Developed Job monitoring tool, it was designed to monitor critical programs, I was responsible for developing pl/sql procedures and functions, which identify the programs not running or completing in error and sends out a notification.

Technology: SQL, PLSQL, Reports 6i

SKILLS

ERP: Oracle Apps 12i/11i (PO, INV, OM, WMS, Advanced

Pricing, AR, GL Assets, CRM (Service Contracts)

RDBMS: Oracle 8i/9i.

Tools SQL* Plus, Toad, Putty, SQL Developer, Forms 6i, Forms 10G, Reports 6i, XML Publisher

Languages: SQL, PL/SQL

Operating Systems: UNIX, Windows 9 xs / 2000 Server

EDUCATION

Bachelor of Engineering in Computer Science, Institute of Engineering & Technology, INDIA

.

Contact this candidate