Oracle Sales
Resume:
Rahul C. Pardeshi___________________________________________________
**************@*****.***
Career Summary
IT Professional with over 12 years extensive experience in Oracle Applications. A resolute problem solver with strong
interpersonal, analytical and communications skills. Technical savvy combined with strong work ethics will add value and
impact bottom-line results. Demonstrated ability to work effectively at all organizational levels with both internal &
external customers.
Technical Skills
Engagement Application Development Application Implementation
Data Conversion Business & Technical Process Re-
Expertise
engineering
Technical Architecture
Database Installation and Tuning
Database Administration
Applications Oracle Advanced Pricing Oracle Inventory
Oracle Warehouse Management (WMS) Oracle Incentive Compensation (OIC)
Oracle Fixed Assets Oracle Purchasing
Oracle Trade Management Oracle Shipping
Oracle Order Management Oracle Bills of material
Oracle Accounts Receivable Oracle Work in Process
Oracle Accounts Payable Oracle MRP
Oracle General Ledger Depot Repair
IProcurement Oracle Service Contracts 11i
IPayment Oracle Core Contracts 11i
IExpense Advance Benefits
ISupplier Oracle Time & Labor
Oracle Telesales Oracle Learning Management
Oracle Applications Implementation (AIM)
Methods
Databases, Tools, Software & Languages
Technology
Oracle DBMS 10g, 9i, 8i, 7, 6 Java
Oracle Applications Versions - R12, Statspack
11.5.9, 11.5.8, 11.5.6, 11.5.3, 11.0.3, DBMS Profiler
10.7SC, 10.6, 10.5, 10.4 Tkprof, Explain plan
Report Versions – 9i, 6i, 3.0, 2.5, 2.0 Taviz
Form Versions – 9i, 6i, 4.5, 4.0, 3.0, 2.3 Toad
AOL Designer 6i
SQL*Plus, SQL*Loader, PL/SQL Kintana
XML / BI Publisher C.A.T Advantage
Fortran, K Shell and Pro*C Ghost Viewer
Designer 1.3.2 PVCS
Quest Software Oracle Workflow 2.6
SQL Developer
Hardware Operating Systems
IBM PC Compatibles MS DOS
ICIM DRS3000 Windows NT, Windows 95/3.11
Apple Macintosh UNIX, SCO UNIX, Novell NetWare
1
LAN, VAX / VMS, Sun Solaris,
Micron Millenia Pro
HP-UX
Compaq Proliant, AS400, IBM
HP K Class 9000 Servers (HPK200,
Mainframe
HPK460)
1. Familiar with DBA tasks, Managed
Database
Oracle database for Clear DDTS
Administration
application, Application Tuning
using TKPROF STATS Pack,
DBMS PROFILER,
SNAPSHOT, Explain Plan, Oracle
Export/Import/SQL*Loader,
External Tables, Applying
Patches, FND_LOAD,
CONCSUB Utillity Writing Shell
Scripts. Creating Printer Drivers,
Printer Styles, Printer Types,
creating tables Sequences
Industry Architecture & Engineering Finance
Procurement, Order Management High Tech Electronics
Plant Maintenance Manufacturing
Semiconductor Warehouse/Distribution
Automotive
Professional Experience
Progressive Insurance 2009-Present
Role: - Oracle Application Tech Lead
Worked on Oracle Iprocurement, OAF (Oracle Applications Framework Customizations) for Requisitions Notifications,
done Oracle Isupplier Setups
ORACLE CORPORATION 2006 – Jan2009
Traveled and worked as a consultant for various clients, both national & international, customizing their ERP systems.
Some of these project spans were as small as 2 weeks and some lasted for 4-6 months.
Role: - Oracle Application Consultant.
Client companies included -
Tony & Guy - Dallas, TX - Worked in Oracle iPayment for German EFT Direct Debit Program, Bank
Renconciliation using oracle Cash Management, AP Check fraud prevention in Oracle Apps - Payee Match with
Positive Pay, Lockbox Reconciliation Extension
Citco Financials Group - Edison, NJ - Worked on SQL*Loader Scripts.
Herbal Life - Torrence, CA - Worked on Order Management Reports with an input to Optio.
Sun Microsystems - San Jose, CA- Worked in Informatica for Datawarehousing Project.
Cisco Systems - San Jose, CA - Worked on XMLP reports to generate the web letter through Workflow
Subscription.
Smucker’s - Orrville, OH - Customized Standard Budget Workflow in Oracle Project Costing adding
hierarchy part to it.
CVRD - Brazil - Functional resource working on the Order management Module checking all the setups
originally done by Deloitte, Brazil
BMC Software - Houston, TX - Developed Reports in XML Publisher for R12. Developed both Check
printing report on Pre-printed Stationary and Contract Details report in XML Publisher. Customized the
Oracle Service Contracts Workflow to send notification to the salespeople who are outside of Oracle domain.
2
Pella Windows - Pella, Iowa - Worked on Work in Process Module,Functional expertise in OTM 5.5/5.0
(Oracle Transportation Management) Performed business requirements gathering, functional design documents
and configuration. “Effective transportation management was able to control, and manage, both fleets as well as
for-hire carriers,”
Mercury Marine - Wisconsin - Booked a Sales Order Line using Release Management. This module
populates the Order Management Interface Tables. Booked a Sales Order Line By EDI 830 Inbound planning
Schedule. This Module populates the Order Management, Interface tables. Worked on Outbound 862 Shipping
Schedule (DSNO)
Diebold - Canton, OH - Worked on a Custom Auto Invoice program in PL/SQL. Setup an Oracle Configurator
development or test environment,Import PTO and ATO BOM Model structures and Item Master data into
Oracle Configurator Developer,Use Oracle Configurator Developer to enhance the configuration model,Perform
engineering calculations,Integrate with an alternative User Interface,Write custom rules that cannot be created
using OCD
Invacare – Elyria, OH - Worked in OIC(Oracle Incentive Compensation) to calculate and pay commissions
for salespersons based on incoming transactions. OIC Processes have a simple user interface with a couple of
standard input parameter integration with Oracle Payroll. OIC is a global variable compensation application
that automates the design, administration, and analysis of incentive-based compensation programs to
successfully drive corporate goals. OIC enables "pay for performance" while maintaining necessary financial
controls. OIC allows organizations to connect sales incentives to business objectives to motivate workers (sales
reps), 3rd party representatives, customers / suppliers, resellers and partners. OIC automates the complex task of
modeling and calculating incentive payments.
Created an order using configurator and book the order through OM. Knowledge of Advanced Pricing Module
and Integration to Configurator Pricing. Thorough understanding of Configurator-APIs for integration &
extensions.
Good integration knowledge between Oracle Configurator and Oracle Advanced Pricing/Contracts/Quoting.
Worked in Oracle Interconnect and XML gateway to generate outbound 810 for Invacare Customers.
Did Trading Partner setups, Created Custom maps for Customers in Oracle XML Designer.
RAPIDIGM SYSTEMS 2003 – 2005
Worked as a consultant for various clients.
Role: - Oracle Application Consultant
JTEKT
Created a Sales Order using Incoming supplier EDI.
Shipping using WMS Mobile Devices.
Shipping through Oracle Forms.
Functional as well as Technical Consultant for Quote to Cash module for ATO and PTO Items using Standard
Order, Simple Quote and Profit Analyzer.
Receipt of Payment and posting to GL
Creating a Work Order using MIN MAX, Receive a product using ASN, Receive AP Invoice through EDI INI,
Return to vendor with Automatic Debit Memo Creation.
Performance management in People Tools
Migrate roles from one database to another database
Web Application Servers with PeopleTools 8.1x and PeopleTools 8.4
Good knowledge of Inventory Organization Transactions, consigned Inventory, FIFO Costing
Discoverer 4i, Discoverer 4.1.37.00.0 - Created Workbooks, Worksheets, Cross Tab, Page detail Cross tab, Page
Detail Table Reports. Knowledge of data points and axis items in cross tab reports
Trained users use discoverer as an ad hoc query tool to develop reports and retrieve data from respective
business folders.
Worked on Discoverer Admin side - Created EUL (End User Layer), summary tables, (i.e. materialized views),
3
and database user in discoverer admin. Scheduled workbooks, shared workbooks to other users, exported
workbooks to excel and HTML format. Created calculations, functions, percentages in discoverer.
Created analytical functions, alternative sorts, item classes, hierarchies (Date and item hierarchy) on Discoverer
admin side
Worked on both standard EUL as well as Apps mode EUL. Generated the business areas using NOETIX EUL,
worked on NOETIX Views, Noetix EUL Generator and Oracle Business views (Oracle BIS).
Customized the COGS Workflow. Added new functions to select account information from customer site level.
Worked on Order Capture APIs in oracle Quoting, creating quotes from templates.
Worked on purchasing setups like creating an employee, buyer, jobs, positions, and position hierarchy. Approval
groups and Oracle Purchasing Lookups.
Familiar with the document types in purchasing setup.
Worked in Oracle Workflow Module (Engineering Change Order), Creating Jobs, Position Approval Groups,
and Security Attributes determining Line Duration reviewing Pricing Attributes.
Worked on BIS (Business Intelligence System) in Apps mode Discoverer Purchasing Intelligence, Operations
intelligence, financials intelligence, HRMS intelligence.
Wrote a custom label-printing program, which is a source for Easy Label.
Handleman Company, Troy-MI 2003 - 2003
Applied service charges to product (order) lines. Process was workflow based; Items Instructions for services are
based at the customer item level.
Technical design documentation for the custom pick release, Order load, Item Extract.
Pick Release Process modifications and customized Pick Slip reports.
Form development - Custom Pick release Rule and Custom Release Sales Order form.
Design and development of reports - Fill rate, Order Grouping and Ticket exceptions.
WMS – Setup of Pick and Put away rule and strategy design, Express Receipt, WMS interface
Item extract using Taviz (ETL), Integration testing and Migration of Custom objects.
Configuration of OM and shipping modules for functional team.
Performance Tuning of the Order Load and Pick Release Process
Report development - Character reports, Daily Orders Report, Inv Shortages Report, and Shipment Exception
Report
Worked on HRMS (Application programming Interface) to create employees, dependent, address, updating
assignments, managing employee data
Development of interface between Payables and Vertex for use tax calculation.
Development of conversions and interfaces for Oracle Receivables, Fixed Assets, General Ledger using
SQL*Loader and Taviz
Performed extensive SQL, PL/SQL tuning using various Oracle Tools such as TK-PROF, Explain Plan, Level 8
trace, creating snapshot of the database.
Air Liquide, Houston, TX 2003 - 2003
Custom Forms Development, and upgrade from 10.7 to 11.5.7
Migrated all customized forms from Oracle Applications 10.7 to 11i using Designer 6i and Flint 60 method for
custom forms.
Keithley Instruments, Cleveland, OH 2002 - 2003
Customized the shipping reports i.e. Bill of Lading, Commercial Invoice, Pick Slip Report.
Worked on Oracle Trading Community Architecture (TCA), mapped all the Data Warehousing Order Entry
queries to the corresponding queries using Oracle Hot Zone Tables (HZ tables in 11.5.8)
Developed Open Interfaces in Oracle Purchasing module called Purchasing Document Open Interface (PDOI)
Created a contract in Oracle Core Contract (OKC) from a template, Copy contract from an existing contract,
4
Contracts Party details and Party Merge, Extended Warranties etc
Developed Accounts Receivables Customer Interface
Worked on Multi language Reports (invoice Report, Sales order report in European Languages) using Oracle
translation Language Tables
Customized Sales Order Forms
Migrating all customized forms from Oracle Applications 10.7 to 11i.
Knowledge of oracle database. Characterset nls_sort, nls_language
Manual entry of the party number in Telesales, address validation, reciprocal relationship, duplicates party check.
Knowledge of TCA API’s and Profiles.
Arvin Meritor Troy, MI 2000 - 2002
Worked on various Oracle Reports - Bitmap Report, Character Report, Matrix report, Nested Matrix Report,
Conditional Duplex Report, Check printing through Report, Purchase Order Report, Invoice Print Report and
Requisition Activity Summary Report
Worked on manually renewing a contract and also auto renewal of a contract.
Worked on AP, AR, HR to People Soft interfaces
Customized the process developed for Engineering Change Order (ECO) Approval Workflow
Customised Order Management Workflows
Worked on shipping API’s
Dana Corporation / Eaton Corporation, Kalamazoo, MI 1998 - 2000
Developed Pack Release Order Customization, an MRP-like program that drives the entire material handling and
packing process for after market operations
Performed setups of Order Cycle, Order Types, and Standard Value rule sets, quick codes and hold.
Performed Inventory transactions such as Sub-inventory transfer, miscellaneous receipts, checking availability of
components, verifying and creating Bill of Materials.
Created BOM Explosion Reports.
Responsible for the successful implementation of OE module for Eaton/Dana Corporation.
Member of data conversions/Interfaces team for Quest 21/Endevour 2000 and responsible for Order Entry
Module.
Developed a PL/SQL program to import the price lists from COPICS system into Oracle.
Involved in loading catalogs, catalog values and adding descriptions.
Performed analysis to load the customer items at the customer level and at the customer address category level
Loaded customer items into Oracle automotive tables using PL/SQL.
Programmed material handling and packing process for after market operations.
ICIM (International Computers India Ltd,) 1997- 1998
Worked as a consultant in CISCO Systems, San Jose.
Role: - CA Programmer/Analyst (done in India offshore project)
Implemented MultiOrg option, Y2K compliance and performance tuning.
Converted and tested SQL reports and Reports 2.0 analysing those for redesigning queries.
SUNRISE SYSTEMS 1995 – 1997
Worked as a consultant for various clients –
Role: - India Programmer/Analyst
Kalyani Consultancy Pvt Ltd,
Developed Stock Market Securities System (SMS), which offered a total solution to management of securities for
an investor in primary and secondary markets.
Developed various forms such as Company Master, Script Master, Industry Master, Bank Master and Stock
5
Exchange Master.
Developed Material Inventory and Poultry (MIP). Developed, tested, and documented Purchase Order module,
material inward, material issue for production of feed, flock, shed bird count, mortality, and eggs production.
Developed various forms using Forms 4.5 and reports using Reports 2.5. SQL*Forms 3.0 to develop screens for
maintenance of historical impact data, primary estimate preparation and printing, final estimate preparation,
estimate inquiry and bill printing.
Forties Finance, India Programmer/Analyst
Developed Fixed Deposit Accounting System (FIDAC), a generic package that offered a total solution for term
deposit processing, consisting of several modules such as Fixed Deposit applications, Processing module,
Brokerage Calculations and Brokerage Check Generation Module.
Developed various master entries, transactional and inquiry forms using Forms 3.0, reports using SQL*Plus and
Pro*C.
EDUCATION MBA in Computer Systems Management, University of Pune, India
Bachelor of Engineering- Civil, College of Engineering, Pune, India
TRAINING Financials 11i XML Publisher Fundamentals.
Oracle Business Intelligence On-Site training
Oracle Order Management (Oracle Apps 11i)
Oracle Inventory (Oracle Apps 11i)
Oracle Workflow 2.6
Oracle 11i Time and Labor Management
Online Training for R12 foundation/basics course
Oracle Product Information Management (PIM)
Oracle BPEL
6
Contact this candidate