Oracle Developer

Title:SDE-III

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

Document

Source below

NAME: J Tooley

ADDRESS:

CITY:

STATE/PROVINCE: NY

ZIP/POSTAL CODE: 11101

COUNTRY: USA

EMAIL: ********@*******.***

PHONE: 718-***-****

CANDIDATE ID: 195424

CITIZENSHIP: Permit

EDUCATION: Post Graduate Work

EXPERIENCE: 5

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: Oracle, Oracle Developer, Oracle Designer

ESUME

Jay Kothari

OBJECTIVE

Suitable software development position within a challenging growing environment

in which functional experience and skills in data modeling, knowledge

management platform, system analysis and design with system implementation

abilities will be used to their full potential. Willing to learn and work in

all aspects.

SUMMARY

Oracle developer with over four years of experience in the analysis, design,

and development of data warehouse and oracle related applications.

Expertise in design, development and testing of products for data warehouse

industry.

Expertise in Data Modeling, Database designing, application development,

performance tuning using Oracle Designer 2000/6/6i, PL/SQL and Oracle Developer

2000/6i.

Extensive experience in writing stored procedures and functions using PL/SQL,

generating Forms and Reports using Designer 2000/6i and Developer 2000/6i.

Proficient in Database Management Procedures (Logical and Physical Design of

database), Performance Tuning of Oracle Servers.

Data Modeling and Data Migration.

Installation of Oracle Database Software, and Networking Software.

Network management using Names Server, SQL*Net for large organizations.

Development of Pro*C programs, Unix Scripts for some complex reports and some

backend scripting.

Exposure in Replication, Name Server Configuration, Distributed Database and

Standby Database

24 x 7 support for any critical Production Database issue.

Brainbench Oracle PL/SQL Certified with the score of 2.93.

With my technical functional background, I am good at transferring user

requirements into technical solutions. Im eager to learn and willing to get

involved with all aspects of my position and work with fullest dedication to

accomplish goals and objectives.

CERTIFICATION:

Brainbench certified for Oracle PL/SQL with the score of 2.93.

Skills:

RDBMS Oracle 8i/8.0/7.x, MS Access 2000/97, FoxPro.

GUI Developer 6i/2000 (Forms and Reports), VB 6.0/5.0/4.0.

Languages SQL, PL/SQL, C, C++, Knowledge of Java, Pascal, Cobol.

Methodology Designer 2000, Designer 6i.

Reporting Tools Crystal Reports 6.0/5.0, Oracle Reports 2, 2.5, 6i.

DSS tools Oracle Express 6.3.1, Discoverer 3.1.

Tools Microsoft Office 2000/97, Microsoft Outlook 2000/97 and Lotus Smart Suit.

OS Windows 2000(Server & Professional)/NT-4.0(Server and Workstation),

Windows-ME/Windows 98 and 95,Unix.

Hardware Pentium based servers and workstations, IBM Nfinity Server.

Experience

Time Warner Cable

Oct-2001

to Jan-2002

Customer Management System.

Environment: Windows-NT 4.0 (Server), Oracle 8i, SQL* Loader, PL/SQL, Oracle

Designer 6i.

This system is developed to help Road Runner Security Management department. We

developed database to maintain Customer Information and details of their

connection times and their work. So that whenever customer calls to Public

Affairs department about their complaints or for any problem just typing by

their account number they can get all information about that customer. Number

of violations done by them, Number of times their service has been stopped,

etc.

Responsibilities:

Installed and configured Oracle Designer 6i. Used Repository Administrative to

generate Oracle Repository and created users to access the repository. Used

Oracle Designer tools to Process flow diagram, data models and to make Entity

Relationship diagram (ER Diagram). Used Process Modeling tool to generate

Graphical representation of Organization and their processes. Used Entity

Relationship Diagram tool to create tables and to construct entity relationship

models using entity and attributes. Responsible for developing Oracle

applications (Forms/Reports) via PL/SQL and Design Editor tool of Oracle

Designer. Developed rule sets to deliver with products. These rule sets were

used to extract information from the Oracle Designer repository and produce

task and phase end deliverable documents. Used Matrix Diagrammer to

cross-reference repository objects. With the help of Oracle Designer tool build

a Database schema with table and referential integrity constraint. Developed

Function, Forms and Reports using Oracle Designer tools. Used Oracle Designer

software tool for analyzing business requirements and for designing and

generating client/server systems that meet projects requirements. Regression

tests all applications against the developed database. Development and test

copies of the customer database. Monitor the system for a few weeks for

problems. Developed Stored Procedures, Triggers, Cursors, and Functions using

PL/SQL. Transfer of Data from text file to Database. Give Training to employees

for the new System. Wrote PL/SQL to generate stored procedures, functions and

some backend processes.

Application Developer

Brown Brothers Harriman & Co

., New York (Jan 2001 to Oct -2001)

Environment: Unix, Oracle 8i, SQL* Loader, PL/SQL, Oracle Designer 6, Windows

NT,

Project Description: The application components include product and vendor

management, price and promotion management, purchase management and inventory

transaction management. To support the different client applications the code

was developed generically and customized as per client requirements.

Responsibilities:

Designed conceptual model using Designer. Used Designer to model business

processes; re-examine the methods used to achieve the goals of the

organization; create diagrammatic representations of business processes.

Designed Process flow, Entity Relationship and created a database, Functional

Hierarchies using Oracle Designer 6 tools like Process Modeler, Entity

Relationship Diagram, Dataflow Diagram, Functional Hierarchy Diagrammer. Used

Database Design Transformer to transform entity models into database design.

Used Application Design Transformer to transform business functions into

application design. Developed PL/SQL Library modules for Oracle Forms and

Oracle Reports application using Oracle Designer 6. Used Matrix Diagram to

browse, update and cross-reference repository-held objects. Used Repository

object navigator to browse and update repository objects, creation and

management of application system. Developed rule sets to deliver with products.

These rule sets were used to extract information from the Oracle Designer

repository and produce task and phase end deliverable documents. Used Design

Editor to develop Forms and Reports. Developed, tested PL/SQL stored procedures

for Data ETLA (extracting, transforming, loading and auditing). Designed,

developed and implemented PL/SQL program units for Incremental and updateable

loading procedures. Analyzed the query performance and designed the loading

process schedules. Uploaded data using SQL * Loader from Legacy systems.

Involved in the system setup for the new clients and releasing the cycle code

to all the existing clients. Used CVS for source code check in and checkout

procedures. Installed database schemas for OLTP, STAGE and OLAP environments

Performed unit and system testing procedures and provided real time support for

testing teams.

Application Developer

(Jul 2000 to Dec-2000)

Call Sciences, NJ.

Migration Project.

Environment: Oracle 7, Forms 2.5/3.0/4.5, Report 2, Oracle 8i, Designer 6,

Windows- 2000 (Server), IBM-Netfinity server, Unix

Responsibilities:

Used Repository Administrator Utility to created Repositories and Users to

access respective repositories.

Used Process Modeler, an Oracle designer tool to generate graphical

representation of process of each organization.

Designed strategy to develop project using Oracle Designer.

Server side generation using Oracle Designer.

Used Process Modeler to capture business process metrics such as time, cost

and yields to allow accurate modeling of current and target business processes.

Generated Entity Relationship between tables using Designer.

Migration consist of following steps...

o Thoroughly document the migration plan, including detailed Forms and Reports

migration steps Copy one production database to a test environment and migrate,

following the documented steps.

o Regression test all applications against the migrated database

o Migrate the production database

o Development and test copies of the production database.

o Monitor the system for a few weeks for problems caused by the migration

Designed current and future target business through Oracle Designer.

Used Design Editor to develop Forms, Report, Development and Security

management

Implementing, Testing & Debugging of Forms & Reports.

Responsible for Day-to-Day reports and backups.

Developed Packages, Stored Procedures, Triggers, Cursors, and Functions using

PL/SQL.

Created Packages, Libraries, Forms Level Trigger, Block Lever Trigger, and

Item Level Triggers to meet the requirements.

Developed Some Reports using PL/SQL and Pro*C.

Installation of Forms Runtime & Reports Runtime at clients end.

Developed Menus and Library files as per requirements.

Configure Net8 / SQL*Net on Server and Client machines.

Granting Roles and Privileges to Users.

Application Developer

VDO INDIA Ltd

. (Apr-1998 to Jun-2000)

As an In-house programmer I was responsible for many day-to-day works like

reporting, Development of In-house applications, Backup and Recovery of Oracle

Server. But major projects are as given bellow

Migration Project from Oracle 7 & Forms 2.x/3.x from Unix Platform to Oracle 8i

& Forms- 6i to Windows-2000 server

Project Description: Migrating whole system from Oracle 7.0 and forms 3 to

Oracle 8i & forms 6i. Project involved from the Oracle Installation to the

Forms Designing Created new forms and reports as per clients requirements and

was maintaining old forms and reports. Day-to-day work on Unix Shell Scripts,

Oracle 7.0, Forms 3.0, Report 2.5. After that they migrated their whole system

from Unix based Oracle 7.0 and forms 3.0 to Windows-2000 server based Oracle 8i

and Forms 6i, Report 6i.

Environment: Oracle 7, Forms 3, Reports 2.5, Oracle 8i, Designer 6, Oracle

Developer 2000 (Forms & Reports), Pro*C, Windows- 2000 (Server), IBM-Netfinity

server, Unix

Responsibilities:

Study, Design, Development and implementation of S/W for new applications

Planed, Designed, Implemented the Databases.

Database Designing and Database Modeling through Oracle Designer.

Created Repository to store metadata, Objects, Process flow diagrams.

Created some Forms and Reports through Designer.

Responsible for creating new forms & reports using Forms 6i and Reports 6i,

maintaining existing forms & reports as per client's requirements.

Prototyping & Designing of Forms and Reports.

Implementing, Testing & Debugging of Forms & Reports.

Responsible for Day-to-Day reports and backups.

Involved in a migration of Finance Module, HR Module from forms 4.5 to forms

6i and Reports to Reports 6i.

Provided user access including creating/dropping/modifying users, creating

user objects, roles, authorizing grants.

Installed, Configured, Maintenance of Oracle 8i onWindows-2000 Server.

Export and import of database. Backup/Recovery of Database.

Involved in SQL Tuning and backups.

Configured Oracle tools like SQL* Net to access the database from network

Involved in designing, development and logical data modeling.

Development and implementation of built in packages, stored procedures,

functions and database triggers. Involved in the design, development and

logical data modeling.

Design front-end with Oracle Forms.

Prepared various reports with Oracle reports.

Design Libraries for common procedures/functions.

Created and managed databases, database instances, disk space, table space.

Created the user accounts and assigning roles and privileges.

Developed SQL Scripts & UNIX Scripts for the required environment.

Application Developer

Work Order Issue Form

Project Description: This Form was developed to Issue component to the employees

or to the production department as per the work order for that particular

month. Employee cannot issue more then the required quantity for that product.

Number of required quantity gets decided from the production schedule.

Environment: Oracle 8i, Oracle Developer 2000 (Forms 6i& Reports 6i), Windows-

2000 (Server), IBM-Netfinity server

Responsibilities: Involved in the design, development, Testing and logical data

modeling. Laid out the GUI standards. Design front-end with Oracle Forms.

Prepared.

Application Developer.

Project Details: Maintaining reports, Supporting Users with new reports or

modifying existing reports as per their requirements using Oracle PL/SQL & SQL

Scripts.

Environment: Oracle 8.x/7x, Windows 98 / 2000, Unix

Responsibilities: Involved in maintaining reports, Supporting Users with new

reports or modifying existing reports as per their requirements using Oracle

PL/SQL & SQL Scripts

.

EDUCATION

B.Sc

. Computer Science

Post Graduate Diploma

in Advanced Computer Application.

Brainbench Certified Oracle PL/SQL Developer.

Contact this candidate