Oracle Project
Resume:
Title:No Title
*********@*****.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: PA
ZIP:
CANDIDATE ID: 2916044
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 215-***-****
EMAIL: *********@*****.***
HOMEPAGE:
HOTTEST SKILLS: oracle, sql, database, financial, oracle financial, receivable,
programmer, health, engineer, product, software engineer, unix, vms, sale, accounts
payable, forecast, ledger, payroll, computer science, data modeling
REVISION: 08-SEP-02
RESUME:
NAME:
ADDRESS:
CITY: Andalusia
STATE/PROVINCE: Pennsylvania
ZIP/POSTAL CODE: 19020
COUNTRY: US
EMAIL: Home: *********@*****.***
PHONE: Home: 215-***-****
CANDIDATE ID:
CITIZENSHIP: United States
Citizen or National
EDUCATION: Master Degree
EXPERIENCE: Residence:
WILL RELOCATE: No
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED: 100,000/yr 85/hr
HOMEPAGE:
COMMENTS:
HOTSKILLS:
I am applying for Oracle Financials Project Lead/Manager Consultant
position, I have
about 6 years of experience.
I am US
Permanent ResidentDhan PATEL
3060 Bristol Road, #159
Bensalem, Pennsylvania 19020
Tel : no
(H)
(O)
email : *********@*****.***
SUMMARY
Expertise with SEVEN years of professional experience in Designing,
Development,Implementation and Project Management of Oracle Applications
With administration of the Oracle 7/8 database
SKILLS
ORACLE APPLICATION :-
ORACLE FINANCIAL - General Ledger, Accounts Receivable, Accounts Payable,
Order Entry
Managing Auto Invoice, Customer interface, Auto Lockbox, Tax Locator,
Chart of Accounts,
Key and Descriptive Flexfields, Set of books, Set up Transactions,
Interface Tables for all the
Modules, customization of the screens .
ORACLE HRMS (Human Resource)
ORACLE ENVIRONMENTAL, HEALTH & SAFETY
Industrial Hygiene, Medical, Epidemiology, Evaluation, safety
Project Management:
Microsoft Project :
Creating project schedules, critical path, network diagrams, Gnat
Charts.
Interaction with the Users, managing the Team of PL/SQL programmers.
Risk analysis.
Database Administration:
Tuning & Performance, Backup & Recovery, Exports and Imports
Data Loading using Exports, Imports and SQL Loader(indirect
Direct), Database Creation, Data Replication, Database Repository
Des 2000 migration from One machine to another machine. Repository
creation and administration, maintenance of the database.
Enterprise Manager :- Used for analysis, monitoring, timing statistics of
the Database.
Application development on Oracle server ver 6.0/7.1/7.2/7.3/8.0using
SQL* Plus, SQL* Forms 2.3 / 3.0 Oracle Forms 4.0 /4.5/5.0, Developer
2000 v 1.1/1.2/2.0, Oracle Reports 2.5/3.0, Oracle Graphics 2.5/3.0,
PL/SQL (Stored Procedures/Packages/ Functions, Database triggers), SQL *
Reportwriter,
SQL * Menu, SQL* Loader, Pro* C, ANSI SQL
OODBMS
Development on ODE ver 4.0 (OODBMS) using O++ (C ++ & Persistent
Objects).
CASE Tools
ORACLE CASE 5.0/5.1, CASE * DESIGNER, CASE * GENERATOR, CASE *
DICTIONARY, Designer 2000 v1.1/1.2/2.0 (Process Modeler, ER Modeler,
data diagrammer, Reverse Engineering.
OS
UNIX, MS- DOS, Netware 3.11, MS-Windows 3.0/95, Sun Solaris 2.4,Windows
NT(3.51/4.0), Alpha WINDOW NT, VAX/VMS
SSAD
Feasibility studies, requirement analysis, data modeling, ER modeling,
functional requirements, software metrics and test plans.
Languages
C, C ++, O ++, Pascal, Parallel C, Fortran.
GUI Tools
OSF Motif, sound in Visual Basic 3.0, PowerBuilder (3.0), WindowsSDK
Platforms
AT-286/386/486, Pentium 2 based workstations, Sun Sparc Stations,
Unisys, Macintosh. HP machines VAX machines
EXPERIENCE
Feb 99
-present :- MAXIM GROUP INC :- (Philadelphia, PA)
On site
at
Genex Services Inc (Wayne,
PA)
Project Lead Consultant
:- Oracle Financials (10.7 Smart
Client)(GL,AR,AP,OE)
Currently Working as a Project Lead for a Data Conversion Project from
the Legacy System
(VAX/VMX) into General Ledger, Accounts payable and Accounts Receivable
. Managed
The Whole Project with a Team of 3 programmers right from the
Specification, Interaction
With the users, creating Project schedules, Designing the PL/SQL
scripts and monitoring
The Whole Conversion in to Oracle Financials . and Creating Financials
Reports.
The Data from the VAX DB which had five different system running on it
was converted
Into Oracle Financials (Accounts Receivable ) system on Oracle 8
database.
Dec 95
- Jan 99INTERNATIONAL TECH INC :- (Dallas, TX)
1) On site (Radian International
Software - Houston Texas )
Project Lead Consultant:- Oracle Financials (10.7 Smart
Client)(GL,AR,AP)
Worked as a Project Lead for Data Conversion project
from Legacy System(Vax/vms)
Into Account receivable .Managed the Whole Project with
a Team of 2 PL/SQL
Programmers. Also added a Manual Entry Form in the Order
Entry Module for
Customization, Oracle Financials Reports where created
based on the Specification provided
Worked also a Project Lead with (ORACLE HEALTH & SAFETY
) Oracle Health and safety was written for users who are actually
inputting health and safety related information and printing reports based on
that data. This includes industrial Hygienists, HR personnel, training,
coordinators, epidemiologists, doctors, nurses, and other health care.
Tools used . Designer 2000/Developer 2000, Reports 2.5, PL/SQL, Oracle
utilities, Oracle Oracle Health & Safety.
2) On Site ( HOUSTON Light And Power - Houston Texas
)
Project Lead Consultant
:- Oracle Financials (GL,AR) Oracle HR
Worked as a Project Lead for Legacy system Conversion for the Account
Receivables system
Creating Financials Reports using Oracle Reports and PL/SQL .
Also Working with the Oracle HR Module doing Functional set upfor that
module and creating Oracle HR reports based on the Specifications and
customization of the screens .
Performance and tuning on the Financials database was done as whenrequired
.
3)
On site
(Aspen Tech Inc Houston - Texas)
Oracle DBA : - Worked as a oracle DBA and following Dutieswere
performed
Tables, Indexes,Triggers, Packages, Snapshots and other objects were
generated using the Designer 2000 tool. Major worked involved was Database
administration of this application .Created databases for Test, Production and
Development .Exported and Imported the data coming from HL & P, toolsused were
Oracle Utilities:- IMP/Exp and Loader (indirect and direct).Data replication
(Creation of Snapshots at a remote location in Bay City which connectsto the
master database at Houston and Refreshing the data at a specified Interval ).
creating scripts for administration purposes. Performance and tuning
of the database and the application using tools like explain plan, SQL TRACE
and TKPROK and Enterprise manager for Monitoring of the database for
Performance, Backup and recovery, general administration on the database,
trouble shooting,Migration of the Repository (DES 2000)from Alpha NT SERVER to
a Unix Machine. Creation of a new Repository and Migration of the application to
it, Repository Administration and Maintenance of the whole database.
4) On site ( The World Bank :- Washington DC)
Oracle Financials
Senior Analyst Consultant
Worked as a Senior Analyst in setting up there Oracle Financials system
Data Conversion of from the Vax to Accounts Receivable and Accounts
Payable
Generating Oracle Reports based on the Specifications.
Also Worked on there Oracle HR system Designing customized forms in
Developer 2000
(forms 4.50) and adding the form to the Oracle HR module, generating
Oracle
HR Reports and performance Tuning of the Database .
5)
On site
(Precision Response Corporations (PRC)
Miami Florida
)
Team Lead /Senior Analyst Consultant
Design and Developed a Order Management System (OMS) for DIRECTV -
SATELLITE TV a major client of PRC . Worked as a Senior System
Analyst/ Programmer in Design and Development phase of the OMS
.Desiged the OMS using Designer 2000 V 1.1/1/2 right from process
modeling to ER modeling and using the same tool to convert the whole
design to Forms 4.5 and then using the Developer 2000 (Forms 4.5,
Reports 2.5, Graphics 2.5, PL/SQL) to design the Front End of the
systems and generating the Reports
6) Jul. '95 - Nov. '95 Database repository (system catalog)
Programmer /Analyst Designed and developed a database
repository in ODE (OODBMS) using O++ (persistent objects & C
7)
Jun. '94
- Jun. '95Parallel Software Engineering Graphical
Editor with an interface to RDBMS
Designed and developed a Graphical Editor (GUI Tool) for parallel
processes used in Parallel Software Engineering & interfacing with
ORACLE 7.0 RDBMS. The GUI was developed in OSF MOTIF and C under X
- windows Operating Systems and objects were stored/retrieved in
ORACLE 7.0 RDBMS using Pro * C and PL/SQL, SQL* PLUS and SQL* FORMS
3.0 were used for displaying the information of the objects and
their relationship between other objects and their relationship
between other objects. Forms were later upgraded to ORACLE Forms4.0.
The RDBMS part of the project of the project was designed in ORACLE
CASE 5.1.
Jan. '92
- Feb. '94. Tubby ComputersProgrammer/Analyst
1) Exporters Preshipment Documentation System
Designed and developed this system for inserting, retrieving, and
generating the preshipment documents used for exports of goods. The
system was designed using Entity Relationship Modeling and the
database was normalized to reduce redundancy. Design incorporated
full use and interaction at all stages, forms and reports produced by
this system were critical to the overall understanding & use of this
system. Designed and analyzed the system using Oracle CASE 5.1 (CASE
* DESIGNER, CASE * DICTIONARY, CASE * GENERATOR). Designed all user
interface and forms using SQL Forms 3.0 with PL/SQL triggers. All
routines written in SQL* PLUS. Designed reports using SQL* Report
writer.
2) Order Entry and Accounts Receivable System
This system was designed & developed for a manufacturing company for
order entry, invoicing and accounts receivable. Generated management
reports to show accounts balance along with sales and payments
activities and report. The system was designed using ORACLE CASE 5.1
(CASE * DESIGNER, CASE * DICTIONARY, CASE * GENERATOR). All interfaces
and forms developed using SQL * Forms 3.0 and PL/SQL triggers.
Routines were developed in SQL * Plus. Designed reports using SQL *
Reportwriter.
3) Inventory Management System for Hospital
This system was developed to maintain the stocks of a variety of
hospital goods. It was designed in Oracle CASE 5.0 ( CASE*DESIGNER,
CASE*DICTIONARY, and CASE* GENERATOR). The data in this system was
integral and sophisticated forms and queries could be incorporated
into this system. Developed first in ORACLE ver 6.0 using SQL*Forms
2.3 with SQL*PLUS with SQL text triggers and SQL*Report writer. Later
modified and upgraded in ORACLE ver 7.0, SQL*Forms 3.0 with PL/SQL
triggers.
4) Multivariate Regression Utility & Production Forecasting System
This system was comprehensively designed in ORACLE CASE 5.1 usingCASE
*DESIGNER, CASE * DICTIONARY, CASE * GENERATOR. This system was
developed to forecast production of several agricultural crops based
on available data using the regression formulae over multiple
variables. The database containing past productions details of crops
was maintained on an ORACLE 6.0 RDBMS database and the entire
programming for the regression formulae was done in Pro * C.
5) Human Resources Management System
This system was developed to keep track of personnel and payroll
activities, generate a variety of personnel and payroll form and
documents, and prepare a number of management reports. It was
analyzed and designed in ORACLE CASE 5.0 using CASE DESIGNER, CASE
*DICTIONARY, and CASE * GENERATOR.
EDUCATION
MS
Computer Science,
BS
Engineering [Electronics]
Work Status :-
US Permanent Resident
Contact this candidate