Supply Chain Sales

Location:

Dover, DE, 19901

Posted:

December 02, 2010

Contact this candidate

Resume:

Dipali Malhotra

***************@*******.***

425-***-****

Summary

* 6+ years of experience in the financial and software industry in the

Analysis, Design, Development, Testing and Implementation of Oracle

Technologies.

* 5+ years of strong experience working as Oracle Applications Supply Chain

consultant in OM, INV, Order-to-Cash, Procure-to-Pay, AP,AR, GL modules

using Oracle Applications 11.5.10 and R12.

* Extensive experience in life cycle implementation including Requirement

Gathering, Solution design, GAP analysis, production scheduling, Custom

development, System configuration, Test Plan Cycle, CRP, UAT and Project

Coordination activities.

* 3 full lifecycle Oracle applications implementation (11.5.10.2 (2) and

R12 (1)).

* Experience working with the Global rollout for OM, Purchasing, AP and AR.

* Expertise in Custom Order to Cash Process Implementation using Order and

Shipping API.

* Good Conceptual and working knowledge on Oracle Discoverer 9i/10g and XML

Publisher.

* Knowledge of EBTax integration with Order Management.

* Design validation & Setups of OM, INV, AR, PO, AP, and Shipping modules.

* Exposure to Oracle Supplier portal and Sourcing.

* Experience in working with Supply chain, Manufacturing modules (BOM and

WIP).

* Formulated solution design and implementation strategy based on client's

requirement.

* Experience in Oracle Applications Setup, Customization, System

Administration, Data Conversion an interface programming and generating

reports and concurrent programs.

* Experience in CRM Modules of Service Contracts and Install Base.

* Experience in working with sales contracts and procurement contracts.

* Good understanding of Customer Data Hub and TCA (Trading Community

Architecture) setup.

* Experience in development of Packages, Procedures, Functions using PL/SQL

and a good knowledge of using TOAD.

* Ability to learn and adapt to new technologies, good team player in

dynamic work group environments and also self motivated to work

independently with excellent communication skills.

Technical Expertise

ERP : Oracle Applications 11i (AP, AR, OM, INV,

AOL)

Oracle Tools : Toad, PL/SQL

Other Tools : Workflow Builder 2.6, Discoverer 4i/10g, XML Publisher,

Oracle form and Reports.

Languages : SQL, PL/SQL

Database : Oracle 10g, R12

Operating Systems : Windows XP/2000/NT/98

PROJECT PROFILE

AEES Inc, San Antonio TX

Jul '10 - Oct'10

Role: Oracle Applications Consultant.

. Provided analysis and reconfiguration of the Supply chain and

Manufacturing modules (OM, PO and INV).

. Prepared the functional Specification documents, business requirement

documents, data mapping, test scripts for UAT and CRP.

. Worked on resolving issues related to OM, Shipping, PTP, AP and AR

and setups for new customers.

. Prepared design documents, MD50, BR100 and functional testing

documentations.

. Involved in Testing and Reconfiguration of Supply chain modules (OM,

PO, INV) and Financials (AP,AR, GL).

. Worked with Modifiers, Qualifiers and custom pricing attributes setup

across multiple business units and pricing reports.

. Upgrade item master for blanket purchase agreement and quotations,

applying sourcing rules and release generation method to import them.

. Deployment of TestLink and Bugzilla (defect tracking tool), prepared

functional specifications and created test cases for testing.

. Tracked and resolved issues for Sales orders (internal and external)

and redefining the shipping parameters as per the client

requirements.

. Created test scripts for partial period revenue recognition and

improved OM/IB/SC modules integration.

. Form Personalization for populating the customer information and

finding orders using their phone number.

. Provided Sales Reps self-service access to relevant information

stored throughout the enterprise, including pricing campaigns and

inventory levels.

. Reduced the operational costs by streamlining quote creation with

templates and maximizing margins to ensure its compliance with

integrated pricing.

. Worked on creating various service contracts, procurement contracts,

billing contracts and resolving issues relating to a contract

lifecycle.

Environment: Oracle EBS R12, OM, SC,INV, PO, AP.

Con-way Inc, Portland, OR

Nov'09 - May'10

Role: Oracle Application Supply chain Consultant.

OM, SC, INV,PO-

. Prepared the functional Specification documents, business requirement

documents, data mapping, test scripts and UAT.

. Worked extensively with RFI, RFQ and Auctions negotiation types while

implementing sourcing and service procurement (R12 Sourcing setps).

. Interacting with the end users to resolve issues related to OM and

Shipping execution.

. Functional design for the Custom Pick Confirm and Ship Confirm

process for DLX.

. Forms Personalization for avoiding the users to Book the Orders for

the Discontinued Items.

. Created of the process to clean up the Shipment lines from the RA

interface tables for speeding up the Auto Invoice process.

. Import of Orders from the ATG site for the other carriers using Order

Import Interface Program.

. Created Held Order Report, Stuck Order Report and Fulfilled Orders

by the other carriers using XML Publisher.

. Provided production support to all the users for the orders which are

stuck in Ship Confirm or because of shortage of the Shippable

Quantity or because of Item Setup in Item Master.

. Defining invoicing information, payment terms, accounting rules,

transaction period, accounting parameters and invoice sources.

. Designed and developed a custom program to load the service contracts

from PeopleSoft to Oracle using the standard API's. Created the

contract header, contract service lines, contract covered lines,

billing stream and the Price Adjustments to apply the discount or

surcharge.

. Designed and created custom reports (tabular, master details, form,

matrix) using Oracle Reports and registered reports and stored

procedures in Concurrent manager in 10g and 11i.

. Defining ATP rules (Supply chain-inventory-setup-rule-ATP), assigning

rules to items in OM and checking.ATP to proper value, scheduling ATP

data collection value.

Accounts Receivable (AR)

. Prepared requirement analysis functional documents for custom

application development, conversion, interface and reports.

. Designed and validation of steps, formulated solution design and

implemented strategy based on client requirements.

. Creations of new customers through UI or using the API for large set

of customers.

. Regular Creation / updating of payment rules for different set of

customers.

. Designed and developed Conversion Interface Programs to pass Credit

Memos for the Existing Invoices in the Cougar Set of Books. Usage of

API to pass Credit Memo and apply against Invoices.

. Retrieved accurate service price and application of discounts.

. Managing of renewals and informing customers and agents of the

expiring contract.

. Managing the negotiation workflow stages and setting up of the

renewal process (manual, online, evergreen).

Environment: Oracle R12, OM, INV, AR, Oracle Reports 6i, XML Publisher,

Oracle 10g, PL/SQL, TOAD, SQL Loader

Prudential Insurance Company, NJ

Mar'08 - Oct'09

R le: Oracle Supply chain and Manufacturing Consultant

OM,INV,PO, SC:

. Preparing of all of the Functional Specification Documents (FSD),

Business Requirement Documents (BRD), Data Mapping Documents (DMD)

and Functional Testing Documents.

. Developed XML Report for the successful / unsuccessful Quotes and

analysis of the unsuccessful ones. Provided the report to the

Business users weekly, which helped them in analysis of the

improvements needed.

. Development of many Discoverer Reports 10g for Campaigns, Events and

Product Launch for Marketing Modules.

. Designed and developed a concurrent program for Order Import

interface, to load all the legacy orders in booked status in Oracle.

Developed a program to validate the data from legacy system and

insert them into the interface tables.

. Understand Division-specific business processes from the end users

and implement the same.

. Developed interface program to upload the Order data to the

Interface tables and load in the Order Management. Loaded Orders

booked from the Retail Stores.

. Developed report for the sales credits for the Sales rep as per the

company policies.

. Involved in the Full Cycle Usage of TCA Architecture for Customers

and Customer Contracts etc.

Accounts Receivable (AR):

. Worked on functional design of Auto Lockbox program to handle the

payment details sent by the bank. Responsible for Identifying and

setting up the Transmission Format and Transmission Fields in oracle

based on the details in the bank file. Involved in setting up the

Lockbox Account. Created the SQL Loader file with the entire column

based on Transmission Fields.

. Developed functional design of Bank Reconciliation Report as per

Audit Team Request.

. Developed reports for the list of customer based on the volume of

business given by them in Receivables.

. Customized AR reports to show the only the Difference between amounts

when a Revision of the Report is generated.

. Developed reports for the reconciliation of the Total Order amounts

with Total Invoices generated in AR.

. Resolution of credit card issues.

. Reconciliation of the payments from the payments source like Sabrix

etc.

. Designed and developed custom program to reorganize the revenue for

the converted invoices based on the business rule.

. Worked on the Invoice Outbound interface program that will interface

all the records from the RA_INTERFACE_LINES_ALL table to the third

party system for Invoice creation and financial consolidation.

Environment: Oracle 11.5.10, OM, AR, XML Publisher,Oracle Reports 6i,

Oracle 10g, PL/SQL, TOAD, SQL Loader.

Euramax International Inc, Atlanta GA

Mar'07 - Jan'08

Role: Oracle Application Consultant

Responsibilities:

INV, OM &PO:

. Item Setup for the new ones and customization of the existing ones in

the Master Item Forms.

. Extensions in the Order Management Process for capturing the Sales

Order for Miami based client.

. Involved in importing orders from legacy system to Oracle Application

base table using the standard item import program. Wrote package to

validate data before loading in interface tables.

. Creation of the new price list for special Corporate Customers.

. Wrote Queries to validate the Item Setup which failed to reserve the

Inventory in the Pick Release or issues in the Ship Confirm process.

. Developed new reports for the Shipped orders revenue, Inventory

revenue based on the Cost Price List, amount due towards vendors etc.

. Supported the users for issue surrounding the Pick Release, Ship

Release, Ship Confirm and Auto Invoice Process.

. Update item master for blanket purchase agreements and quotations,

apply sourcing rules and release generation method to the imported

item.

Requisition & Purchase Order (Procure to Pay):

. Gathered Internal Requisitions from the various users and Process the

approval process of the Requisitions.

. Designed and developed Concurrent program for creation of purchasing

requisitions by using the Oracle standard Program Requisition Import.

. Designed and developed a concurrent program for creation of Purchase

Order for the dropshp sales order by using the oracle standard

Purchase Release program.

. Raised Request for Quotation (RFQ) from the vendor and then do

Quotations Analysis and then raise the PO with the vendor.

. Designed and developed a concurrent program for the Receiving the

material from the Trading partner by using the Receiving transaction

processor program.

. Receiving of the goods in the warehouse, matching received goods with

the PO and approval of the Invoices.

Accounts Receivable (AR)

. Helped users for issues in Workflow Background Process to load into

the AR interface table from Order Management.

. Involved in resolution of issues arising from the Auto Invoice

Program.

. Developed AR reports for the reconciliation of the revenues with the

Order Management.

. Create and implement comprehensive billing, credit and collection

policies and related procedures for departmental, interdepartmental

and inter-company use.

. Program Unit to re-generate the Invoices for the ones where Credit

Memo were passed with new set of Accounting Rules. Usage of API to

generate Invoices.

Environment: Oracle EBS 11.5.10, Order to Cash (AR, OM, INV, Requisition,

PO), Oracle Reports 6i/10g, Oracle 10g, Discoverer Reports, PL/SQL, TOAD,

SQL Loader.

UBS, NYC NY

Aug '06 - Nov '06

Role: Oracle Application Functional Consultant

Responsibilities

Financial and Accounting :

. Worked with team members to fulfill the client requirement and

conducting interim project review and final project tweaks before its

launch.

. Adept at reducing development costs and providing traceability of

projects and conducting risk analysis to derive and execute action

plan on time.

. Created vision, scope and used case documents, case diagrams and

assisted senior analyst in conducting risk analysis, status reports

and establishing critical success factor.

. Developed reconciliation report to notify users automatically about

the missing Invoices after the Bill Cycle run.

. Developed many Ad-hoc reports for the Credit and Finance Department.

. Created IRR, NPV, ROI models for evaluating the financial implication

of new product and investment and putting the proposal to the higher

management.

. Tracked and reviewed gross and net sales and gross margin in producing

forecast and trend analysis on an ongoing basis.

Functional Responsibilit s

. Ensured all artifacts compiled with corporate SDLC policies and

guidelines.

. Helped manage risk analysis and mitigation plans, status reports, and

client presentations; prepared business process models, defined

milestone deliverables, and established critical success factors.

. Prioritized business and systems problems; analyzed legislation and

conducted impact analysis.

. Involved in the requirement gathering with the business and other end

users for the newly proposed system and customizations in the existing

system and then developed MD - 70 documents on basis of the changes

proposed.

. Created of Business Areas, Custom Views, Reports based on the Order

Management and Interactive reports as per the user requirements in

Oracle Reports and Discoverer 10g.

. Developed and ran the complete Order To Cash cycle and generated

invoices.

. Trouble-shooting of various reports in OM modules.

Environment: Oracle Database 8i, Oracle EBS 11.5.9 (AR, AP,OM), PL/SQL,

Windows XP.

Spice Communications, Mohali, India

Mar '04 - Jun '06

Role: Financial Consultant

Financial and Accounting

. Prepared financial statements, studying market trends, financial

issues and bringing it up front to the top management.

. Worked with team members to fulfill the client requirement and

conducting interim project review and final project tweaks before its

launch.

. Adept at reducing development costs and providing traceability of

projects and conducting risk analysis to derive and execute action

plan on time.

. Created vision, scope and used case documents, case diagrams and

assisted senior analyst in conducting risk analysis, status reports

and establishing critical success factor.

. Developed reconciliation report to notify users automatically about

the missing Invoices after the Bill Cycle run.

. Developed many Ad-hoc reports for the Credit and Finance Department.

. Used SQL *Loader to upload the Master-Items into the Custom table.

. Produced annual budgets and forecast model on departmental, business

segments working with functional departmental head and officers.

. Created IRR, NPV, ROI models for evaluating the financial implication

of new product and investment and putting the proposal to the higher

management.

. Tracked and reviewed gross and net sales and gross margin in producing

forecast and trend analysis on an ongoing basis.

. Ensured all artifacts compiled with corporate SDLC policies and

guidelines.

. Prioritized outstanding defects and system problems, ensuring accuracy

and deadlines were met.

. Prepared business process models; used Visio to create use case

diagrams.

. Involved in detailing project mission, data process flow diagrams, and

timelines.

. Worked with SQL queries for data extraction & data manipulations.