Oracle Sales
Resume:
Title:Laboratory Assistant
*********@*******.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: NJ
ZIP:
CANDIDATE ID: 2922825
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 732-***-****
EMAIL: *********@*******.***
HOMEPAGE:
HOTTEST SKILLS: oracle, financial, budget, accounting, ledger, receivable, sql, oracle
financial, product, sale, inventory, price, purchasing, statement, database, transaction,
html, credit, payment, stock
REVISION: 08-SEP-02
RESUME:
NAME: Deepesh VB
ADDRESS: 7 MALVERN WAY
EDISON, NJ 08817
CITY:
STATE:
ZIP:
COUNTRY:
CANDIDATE ID: NA
EXPERIENCE: Not Entered
DESIRED POSITION: Not Entered - See Resume
WILL RELOCATE: Not Entered
US CITIZENSHIP: YES
JOB WANTED:
EDUCATION: Not Entered
RATE NEEDED: Not Entered
TELEPHONE: 732-***-****
EMAIL: *********@*******.***
HOMEPAGE:
COMMENTS:
HOTTEST SKILLS:
Deepesh VB
7 MALVERN WAY
EDISON, NJ 08817
*********@*******.***
SUMMARY:Over four years of experience in development, implementation and
support of Business Applications.Expertise in the analysis of both
business
and system requirements.Extensive programming experience in writing
database
procedures, database triggers, database packages and creating tables,
views
using Oracle 7.x, SqlForms4.5, Developer 2000, Report Writer 2.5, on
IBM PC
Compatibles. Working on a challenging assignment with Walt Disney
Publications.
The Publication Business is unique in many ways compared to other
businesses as
it has process flows unique to this organization(Also differs from
others within
the industry).
Experience in setting up/implementation of Oracle Financials (Oracle
General Ledger, Oracle
Order Entry, Oracle Receivables, Oracle Payables Oracle Purchasing,
Oracle
Project Accounting) and Involved in taking the Sales Order into Oracle
Manufacturing.
HARDWARE:Intel Pentium Based UNIX and DOS Machines. HP-9000 E35
PA7100 LC RISC, HCL-HP486, IBM486.
SOFTWARE:Oracle Financials 10.6/ 10.7SC161(Oracle General Ledger,
Oracle
Order Entry, Oracle Receivables, Oracle Payables,Oracle
Project
Accounting and familiar withOracle Inventory, Oracle
Purchasing, Mfg. Modules .
Oracle7.3, SqlForm2.3,Oracle Forms 4.5, HTML,Oracle
Reports
2.0/2.5,OracleGraphics 2.5,PL/SQL, ProC and SQLLoader.
Winframe
3.0,GLDI(GL Desktop Integrator) 9.0.
SCO OpenServer, MS-DOS, Windows 3.11, Windows NT 4.0,
Windows95
and Novell Netware.
PROJECTSEXPERIENCE:
International Paper Company,South CarolinaSep'98 - Present
Role:Project Lead.
Setting up Oracle Order Entry Module and integrating it to work with
with OracleReceivables, Oracle Inventory, BOM,
WIP.Developed interfaces to input customer data
from SAP Receivables(Corporate Business System)into the Oracle
Receivables.Developed custom interface (Price list interface) to bring in legacy
price lists into the Oracle Order Entry Price Lists Tables.Also working on AR,
WIPand Inventory modules.
The Walt Disney Company
May'98 - Aug'98
Involved in setting up/implementation of the following modules: Oracle
General
Ledger, Oracle Project Accounting, Accounts Payables, Oracle Purchasing
and
providing support on other Manufacturing modules like WIP, BOM, MRP/MPS,
Oracle Inventory.
Duties included conducting extensive user training sessions, determining
business unit requirements of Chart of Accounts and various child/parent
accounts after determining how it would roll up into the Parent
Company's
accounts. Finding out the various reporting needs of the Business Units.
Analyzing Business Process flows ofthe various Business Units and help
them to
decide about the modules they would and would not be using. Setting up
of the PA
module inconsultation with the Business Units and Module Lead. Setting
up
Projects and WBS(tasks) based on Business Unit requirements. Using
transaction
import to import data fromlegacy systems. Importing legacy system data
into
Oracle General Ledger, Oracle Payables, AR depending on the business
flows unique to this
industry.Extensively using GLDI to import/upload budgets from Excel
Spreadsheets
to Oracle General Ledger and downloading budgets from GL to spreadsheets
for
analysis purposes or to make changes and upload it again. Applied budget
rules,
created customised reports, generated financial reports from database
using
GLDI. Trained users on GLDI. Worked closely withBusiness Unit Heads(
Manufacturing/Production) analysing their Business flows and
communicating how
the flow of data would be in Oracle compared to their present Legacy
systems.
Environment:Oracle 7.3, Oracle Applications Release 10.7SC161, GLDI
(General Ledger Desktop Integrator) 9.0, Oracle
Discoverer2000
Browser3.0, PL/SQL, SQLLOADER.
Genesis Software SystemsApril '97 - April
'98
Genesis Software is a Software Development Company located in India,
focusing
primarily on the implementation and customization of Oracle applications
for its
Client. Below is a listing of projects:
Implementation Of Oracle Financials
This project involves setting up, implementation and customization
of
Oracle Financial/Mfg Modules like Oracle General Ledger, Oracle
Receivables,
Oracle Order Entry, Oracle Payables Oracle Purchasing,Oracle Project
Accounting..
Oracle General Ledger
Flexfield definition with dependent and independent value sets
Setting up
ofbooks, Budget and Budget organization, Implemented Mass allocation,
Master
Detail Budgets, Translation & Revaluation Budget Upload.
Budget created in Microsoft Excel with the account head and the
budget
amount. This is converted to an ASCII file and transferred to Oracle
Application
server where a PROC program was written to upload the budget to oracle
financials planning budget.
i)Descriptive flexfield.
Descriptive flexfield in journal entry screen to capture
cheque
number, cheque date and name of the payee.
ii)Concurrent programs
Exporting Period end balances from Oracle
financials.
A PROC program to export period end debits and credits for a
range of accounts.
This program is registered in Application object library as a
spawned process and made it part of the oracle general ledger.
A front end is developed informs 2.3 to capture range of
accounts and pass these parameters to the concurrent program.
iii)Consolidation
Consolidation from different subsidiary set of books into
parent
set of books and Consolidation of subsidiary set of books
different servers to set of books.
iv)Internet
An HTML script at the web browser to input trial balance
parameters such
asperiod, range of accounts and set of books. At the oracle financial
server
enda PROC program receives these parameters in an environment
variable and
process the trial balance and formats the report back to web browser
Involved in
setting up of Set Of Books.
Oracle Receivables
Setting up Customer profiles, payment terms, payment method,
Receipt class,
Bank Invoice type, source, credit memo, Commitments Receipt source,
Automatic
Receipts, Installation of TAX vendor hook, Implemented Lockbox interface
through
SQLLOADER Customer Interface. Importing Invoices from legacy systems
using Auto
Invoice.Tested features Auto Lock Box, Automatic receipts, Credit
Memos,
Deposits and Guarantee.Developed a report showing Customer name and
Receivable
Balances.Created an Alert which fires automatically when Receivable of
customer exceeds a certain limit.
Oracle Order Entry
Setting up of Order cycle, Order types, Price List Bill of material
with
Configure to order model and option classes.Forecasting and Master
production
schedule Routing with departments and resources Generating Job orders
and shop
floor transactions. Developed a Pro 'C' program to load price lists into
OE
tables . Automatic creation of Accounting flex field combinations for
COGS A/C
using Flex Builder.Created RMA Cycle and tested RMA Interface.Tested
the
Link between OE and Manufacturing Cycle.Developed a report in
Developer 2000
showing total quantity of an item sold in different states of India
Developed
an Report on Internet showing Item wise Rejections using Oracle 7.3 and
Internet
.
Internet
An HTML script at the web browser which allows Customers to place
the Order
on the Net. At the Oracle financial server end a PROC program receives
these
parameters in an environment variable and it will insert the data into
the Order
Import Interface tables and from Oracle Order Entry we have to run Order
Import
Concurrent Program.
Oracle Payables
Setting up of Payables cycle with Vendors, Employees, Importing
purchase
order from legacy systems, Autoselect, Importing Invoice from legacy
systems
with respect to Employee expenses (Xpense/Xpress). Payment
Reconciliation with
Oracle Payable using Auto Clear.Check Formatting report customization
Implemented Bank Reconciliation.
Project Accounting
Setting up of the various setup options. Set up Work breakdown
Structure(WBS),
Projects, Transaction Import to import data from legacy systems.
Prepared
documentation containing details for all the above and the required
validations.
Environment:SCO OpenServer, Oracle Financials 10.7and Oracle
7.x,
Developer/2000, Oracle ReportWriter 2.0, ProC, and SQLLoader.
MPR Refractories, Andhra Pradesh, India
Jan'95
- March '97.
MPR Refractories is a manufacturing company involved in the Indian steel
industry.The three years with this organization entailed several
in-house
projects, involving the full life cycle, from the analysis of business
and
system requirements, to the implementation of the application.A brief
description of these projects follows:
An On-line integrated application with modules, including Sales,
Purchasing,
Inventory, Quality Control, Production Planning, Finance and MIS.
Duties
involved Project Study, Coding, Designing and implementing screens,
Reports
Generation.
A. Purchase System. Project involved recording of all purchases made for
the
organization and linked to other modules.Project involvement included
coding,
development of screens, Report generation. The outputs generated in this
module
are Requisition Slips, Orders etc..
B. Quality Control SystemThis was developed to record all Quality
inspection
details from quality check of goods, rejections, replacements, various
tests
like calibration of machinery, test reports on quality, quality plan and
integrated with other modules.
C. Inventory System. This was developed to record all stock details
including
receipts and issues of stock fromstores and warehouse. The stocks were
maintained according to Minimum Order Level and reorder level and
integrated
with other modules. Projectinvolvement included coding, designing and
implementing screens, report generation.
D. Production Planning SystemThis system records and generates
Production Plan
based on orders onhand, demand orders etc. The outputs generated in
this
modules are Production Plan Charts, Production achieved reports etc.
Duties included designing and implementing screens, coding
and report generation.
E. Sales Order Processing System. This was developed for
recording/generating
sales order processing and sales monitoring from enquiry, tenders,
delivery
schedules, pending orders, sales targets and integrated with other
modules.
Duties involved designing and implementing screens, coding, report
generation.
The outputs generated in this module are all kinds of sales reports.
F. Financial Accounting System. This was developed for financial
accounting of
the organization.This moduleis integrated with all other modules for
day to
day on-line transaction updating. All types ofvouchers can be entered
for
on-line accounting, this includes sub-contractwork and preparation of
financial statements. The outputs generated in this moduleare all
types of.
vouchers, daybooks, ledgers, financial statements etc
G. Human Resources System. This system was developed for employee's
welfare and
administration maintenance. It records personal and payroll processing
information for allemployees and is integrated with the Financial
Accounting
System. The outputs generated are administrative reports, income
statements,
monthly and yearly statements pertaining to Provident Fund, Taxes, Final
Settlement statement etc..
H. Management Information System. This module is integrated with other
modules.
Used for planning, control etc.
ENVIRONMENT:HP-UX, Novell Netware 3.11,
Oracle7.x,Forms4.5,Reports2.5,
Graphics 2.5, HP-9000 E-35 PA 7100 LC RISC,HCL-HP486.
EDUCATION:Bachelor of Commerce
from Wesley Degree College,
Secunderabad,
India, Osmania University .
Post Graduate
in Management from Indian Institute Of
Advanced Management, Visakhapatnam, India.
Post Graduate Diploma
in Computer Applications(PGDCA)
Kenetronix Institute of Informatics,
Hyderabad, India.
Contact this candidate