Sales Oracle
Resume:
Title:Senior Business Consultant
*********@*******.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: MA
ZIP:
CANDIDATE ID: 2928912
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 978-***-****
EMAIL: *********@*******.***
HOMEPAGE:
HOTTEST SKILLS: oracle, sql, sale, unix, inventory, database, solaris, gross, programmer,
suit, financial, receivable, e-commerce, informix, promotion, lease, information
technology, java, oracle financial, programming
REVISION: 08-SEP-02
RESUME:
NAME: GANESH SAWANT
ADDRESS: 31 WESTERN AVE. APT# 3
CITY: GLOUCESTER
STATE/PROVINCE: MA
ZIP/POSTAL CODE: 01930
COUNTRY: USA
EMAIL: *********@*******.***
PHONE: 978-***-****
CANDIDATE ID: 219019
CITIZENSHIP: Permit
EDUCATION: Bachelor Degree
EXPERIENCE: 8
WILL RELOCATE: Yes
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED:
HOMEPAGE:
COMMENTS: Dear Sir/Madam,
How are u I came across your job requirement. Currently I
have finished my project on Oracle 11i Application implementation at Cyrk,
Massachusettes. I am confident in my work given a chance. I have excellent
references from Cyrk. I am willing to relocate.Appreciate your consideration.
Ganesh Sawant
HOTSKILLS: Oracle 11i Applications
ESUME
SUMMARY:
Over Eight years working experience in the field of Relational Database
Management Systems. Designed, developed & customized Open Interfaces, Forms and
reports in Oracle Financial Applications (11i/11/10.7 GUI) environment. Strong
analytical and technical skills with good programming experience in SQL,
PL/SQL, Developer 6i/Developer 2000 GUI suite (Forms 6i/4.5, Reports 6i/2.5).
Good understanding of Data Analysis, Modeling techniques and Client Server
computing models. Self-motivated individual having exceptional works ethics,
superior planning and good organizational skills. Effective team player and has
good written and verbal communication skills. Expertise in customizing OM, INV,
AR, PO, E-Commerce gateway, Oracle Self Service modules. Good understanding of
Application Object Library.
Customized forms & reports in Oracle Financials. Developed reports in GL using
Financial Statement Generator
Developed several conversions such as Item, Item Categories, BOM, On-hand,
Quotations, Routing etc.
Extensively coded custom library.
Customized workflow functions.
Developed Packages, Procedures, Functions & Database triggers
Worked extensively on SQL*Loader and UTL_FILE.
Knowledge of EDI operations using STMAP for windows & Harbinger Trusted Link.
TECHNICAL SKILLS:
Applications: Oracle applications (OM, INV, AR, PO, E-commerce Gateway & Self
Service) V11i/11/10.7
Databases: Oracle 8.x/7.x, Informix-Online (7.2).
Tools: Developer 6i/2000(Forms 6i/4.5, Reports 6i/2.5), Designer 2000,
Discoverer 2000, FSG,
WorkFlow Designer 2.6, STMAP for windows (4.11), Harbinger Trusted Link (4.34),
TOAD, SQL*Loader, Visual Basic 4.0/5.0 /6.0, Crystal Reports 4.x, Vignette
Story Server 4.2
Languages: SQL, PL/SQL, Pro*C, C, Unix Shell Scripts, ISQL, TCL
Operating Systems: Windows 9x/NT 3.5/4.0/2000, HP-UNIX 9.x/10.x; SUN SOLARIS
2.5, Unisys U6000
WORK EXPERIENCE:
CYRK Inc
. Wakefield, Massachusetts Oct.2000- till Date
Oracle Applications Implementation
CYRK, a promotional marketing company with headquarters in Wakefield,
Massachusetts with offices throughout the country. Company implemented Oracle
Applications for their enterprise business needs. Worked as an application
technical developer with Oracle Consulting team involved in implementation.
Responsibilities:
Design and coding go-live conversion programs, which will convert data from
Platinum legacy system to Oracle applications 11i. Involved in getting business
requirements from the users, writing detail design documents such as MD20 and
MD70 as per Oracle consulting standards for conversions.
Performed following Conversion programs using Oracle 8i/PLSQL - Open item
interface, Item categories, Bill of Materials, Routing, On-hand quantities,
Price list, Quotations, Physical Inventory, Item Demand History, Imprint
Attachments, Approved supplier list & Sourcing rules.
Drop Ship process is automated to create & approve Requisition & Purchase
Orders. Developed procedures involved in Drop Ship process such as Copy Sales
Order DFF in requisition interface table, Requisition Import, PO creation, PO
approval. Seeded Purchase Release package is used. All procedures as an
individual concurrent programs are added to a Request set & scheduled to run
every 5-min.
New workflow process is created for Drop-Ship Orders in Order Management using
Workflow Builder 2.6. Oracle seeded Line flow Generic workflow is used. Added
a custom function to make Drop Ship Sales Order lines to wait before auto
invoicing until all the receipts received for a PO. Only after receiving
transaction in receiving is complete, status RECEIVED is returned by workflow
process and the line is interfaced to AR.
Modified Custom.pll library for various business requirements in Order
Management using Oracle Forms 6i. Use Zoom event in custom.pll, to call other
forms by creating a list of values at run time from Sales Orders screen. Coded
zoom function to show Gross Profit and Gross Margin from Sales Orders form when
user selects Gross Profit from the zoom. Called a stored procedure from
Custom.pll to populate supplier DFF on the sales order line, which will be used
for PO generation in Drop-Ship Process.
Daily Open orders extract procedure is coded using UTL_FILE that will write
all the order details, reservations, ATP quantity, shipping instructions, etc.
into text file. This request is scheduled to run every morning.
Seeded Pick slip report is customized to fit portrait layout. Added
Bill-to/Ship-to address, country of origin, Barcode for item, labeling, locator
Name as per business need.
Developed & customized several reports from Order Management, Inventory,
Receivables, WIP modules. Reports such as Customer Order History, Order
Summary, Program Sales, Order Admin count, Sales Rep Order count, Invoice
Sales, Backlog Detail/Summary, Discontinued Items, Monthly invoice, Program
Sales, Reservable Inventory, WIP Details, MasterCard Ship-to, Min-Max Planning,
Inventory Valuation, Commission Accrual, Gross Margin by Orders, Gross Margin
by Invoices, etc.
GL reports such as P/L by department, P/L by Sales office, Gross margin by
program, Sales Incentive by Sales Rep using Financial Statement Generator
(FSG).
Supported Invoice (810Outbound) transactions using E-commerce Gateway, STMAP.
Solving various on the job technical problems, escalating Oracle TARS,
performance tuning.
Environment: Oracle Applications 11.5.4 modules Order Management, Inventory,
Receivables, Purchasing, Oracle 8.1.6.1, PL/SQL, Developer 6i/2000(Forms
6i/4.5, Reports 6i/2.5), Work Flow Builder 2.6, EDI STMAP for windows,
Harbinger Trusted Link, Windows 98, HP9000/HP Unix.
Motorola Information Technology Group, Phoenix, AZ Jan.2000-Sep.2000
Oracle Applications Implementation
Motorola Information Technology Group
(MCG) is using Order Entry & Oracle
Receivables modules in their Phase-I implementation. These modules continue to
exchange data with MCG's old EMS system. Extensively involved in PL/SQL
programming & tuning.
Responsibilities:
Order Entry functionality was customized using Custom Scheduling form.
Developed triggers & procedures to check reservation, backorder reservation,
etc. Modified existing Messages logic to suit business need.
Since MCG split the order in different lines, standard Oracle cancellation
Form can't be used for cancellation directly. Customize standard Oracle
Cancellation form in the Order Entry module to remove check box & add a SPLIT
indicator field so user can cancel particular line detail. Modified logic to
cancel line details before it finally passed to standard user exit through
OE_RPC buffer.
Lines which are closed can be Picked to Release depends on Shipment priority
code, carrier & request date. Standard Oracle form is customized to remove the
capability to pick lines concurrently.
Extra feature to see all the details for the pick Release in the order are
given, report is modified to remove all the inventory related details & add
specific details from custom tables to suit business need.
Modified Backorder Detail, Cancelled Orders, Order Cycle Listing, Salesperson
Order Summary reports for Order Entry modules
Environment: Oracle Applications 10.7-Smart Client, Oracle 7.3, PL/SQL, Forms
4.5, Reports 2.5, Modules - Order Entry, Inventory, Accounts Receivable,
Windows NT/AIX Unix.
Enews.com, Washington, DC Jun.1999Dec.1999
Vignette Story Server.
Enews.com is the leading Web-based provider of magazines, offering attractively
priced subscriptions to more than 1,000 magazine titles from more than 400
publishers. Enews.com is the Electronic Newsstand owned by Barnes and Noble and
having a strategic partnership with FreeShop. It also has promotional
alliances with Cool Savings, MyPoints and Netcentives and several others
affiliate sites.
Responsibilities:
Developed the Express checkout with User Login shopping cart. This shopping cart
allows user to buy the magazines faster. The Affiliate sites like Fhmus.com,
Teenmag.com, Snowboarder.com, etc use this cart.
Developed the other site templates for Enews.com and the affiliate sites with a
generic model to accommodate different styles of Left Navigation Bar, Right
Navigation Bar, Header and Footer.
Developed Express Checkout Admin templates which is used to assigned content or
legal language text for Headers, Footers and the Left and Right Navigation Bars
of different sites. A site can have multiple Headers/Footers/Left/Right
Navigation bars.
Conventional shopping cart used by Enews is modified to suit their new needs. It
allows customer to buy fast and easy way. Account creation information is added
on to billing page instead of conventional Login page to avoid discarding of
shopping cart by user because of time-consuming steps. Currently Enews is using
it live.
Also modified to add a special offer on Basket page depending on the promotions
using a generic way.
Wrote and modified back end stored procedures being called in the Templates.
Environment: Story Server 4.2, TCL, IIS 4, Oracle 8.1.5, JavaScript, and Windows
98
Shubert Ticketing Services
. Oct.1998- May 1999
Shubert Ticketing System using Passport Enterprise.
Project was developed to implement a more robust ticketing system using cutting
edge technology. Involved in the design of the development screens by analyzing
the legacy system. User interaction & prototyping is done. Then involved in the
development & Implementation cycle of the project. Passport enterprise tool
based on JAVA is used to develop the system using Informix as a backend
database.
Environment: RS 2000, SUN Solaris, Win95, Informix Online engine. Esql*C,
Stored Procedures, Functions & Triggers and Passport Enterprise tool.
Colgate-Palmolive Company, NY, New York. Mar.1998Aug.1998Data Migration
Project involved Migrating data from AIX Unix to SUN Solaris huge amount of data
comes into Oracle Databases from SAP, Nielsen Workstation, Infact Workstation
and DB2. My role was to analyze table usage per application. Generate the SQL
Scripts with proper table & index parameters to create on SUN. Tune SQL scripts
using Explain Plan & does necessary modifications. Write stored procedures,
functions, database triggers & Pro*C programs to load data from flat files into
tables. Write/Modify End of Day processing scripts.
Environment: RS 2000, SUN Solaris, Win95, Oracle 7.3 Developer 2000 (Forms 4.5
& Reports 2.5), Pro*C, Sql*Loader, PL/SQL, Stored Procedures, Functions &
Triggers.
Colgate-Palmolive Company, New York. Sep.1997Feb.1998
Accounts Monitor & Reporting System.
The system provides an automated process for accurate & timely Account Monitor
Reports & creates Account Monitor data repository which will provide
Daily/Monthly summary data for trending & analysis of the Growth Accounts by
regions.
Environment: SUN Solaris, IBM-PC - Windows 95, Oracle 7.3 Developer 2000 (Forms
4.5 and Reports 2.5), Pro*C, Sql*Loader, PL/SQL 2.3.3, Stored Procedures,
Functions & Triggers.
British Gas Plc
. Staines, England Dec.1996Jun.1997
Premier Central Heating System
PCHS an On-line, multi-user system which consists of two modules, namely Premier
and Audit system. Responsibilities include developing and modifying Premier and
Audit module.
Environment: SUN Solaris, IBM-PC - Windows 95, Oracle 7.3 Forms 3.0 and Reports
1.2, Pro*C, Sql*Loader, PL/SQL 2.1, Stored Procedures, Functions & Triggers.
Managerial Information Systems,
Tata Unisys Ltd
., India
From April 1996
To November 1996. Worked as a Programmer/Analyst.
Environment: Oracle 7.0, Developer 2000 - Forms 4.5/Reports 2.5, Windows 95.
Indents & Stock-Sale System,
Atlaz Technology Private Ltd
., India
From Jan. 1995
To March 1996 worked as a senior programmer.
Environment: Oracle 7.0, Forms 3.0, Pro*C, DEC Alpha, UNIX
Inventory & Sales Order Processing System,
Atlaz Technology Pvt. Ltd., India
From September 1994
To Dec. 1994 worked as a programmer.
Environment: Oracle 7.0, Forms 3.0, Reports 1.2, Pro*C, DEC Alpha, UNIX
Sales Order Processing System,
DCM Data Systems Pvt. Ltd
., India
From September 1993
To August 1994. Worked as a programmer.
Environment: Oracle 7.0, Forms 3.0, Reports 1.2, Pro*C, DEC Alpha, UNIX
EDUCATION: BS
in Computer Science, Pune Institute of Computer Technology,
University of Pune,
India 1993
REFERENCE: References will be provided upon request.
Contact this candidate