Developer Quality Control

Title:Senior Engineer

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

Document

Source below

NAME: Rajagopal Vijayaraghavan

ADDRESS: *** ****** *** * ***.312

CITY: Sunnyvale

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 94087

COUNTRY: USA

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

PHONE: 408-***-****

CANDIDATE ID: 142436

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: Oracle Database(5), SQL(5), PL/SQL(5), Oracle Forms(5), Oracle Reports(5),

UNIX(5), Oracle Designer(3)

ESUME

Summary: Five years of experience in analysis, design, development and implementation of

software applications using Oracle 8i/8.x/7.x, Developer 6i/2000 (Forms 6i/5.0/4.5,

Reports 6i/3.0/2.5), Designer 6i/2000, PL/SQL, SQL on Unix and Windows platforms.

Extensive experience in developing client and server side programs using PL/SQL.

Skills:

RDBMS: Oracle 8i/8.x/7.x

Languages: PL/SQL, SQL, Shell scripts

GUI/Tools: SQL * Plus, Developer 6i/2000 (Forms 6i/5.0/4.5, Reports 6i/3.0/2.5),

Designer 6i/2000, SQL * Loader

OS: HP- Unix 11.0/9.0, Sun Solaris 5.x, Windows NT4.x/2000

Experience:

Cisco Systems Inc

., San Jose, CA

CCRM - Commitment Compliance and Revenue Manager

June 01

- Sept 01

CCRM is an application which offers deal management functionality and a central point of

aggregation for data related to a complex sale. The requirement for this project was to

provide an additional functionality of linkiing legal contracts with the deals from a

remote database. Developed all the required database objects and server side PL/SQL

programs required for this functionality. The database objects include materialized views

for tables from a remote database, simple views, tables, sequences etc. The server side

programs include instead-of triggers on views to handle DMLs in the base tables, packages

for viewing and allocation of contract queues to Sales Controllers imported from the legal

database, handling the linking and unlinking of contracts with the deals, applying holds

on contracts being modified by the users, and handling errors generated in a transaction

to an error table for debugging. Wrote control files for SQL Loader for data imported from

remote databases into the CCRM database. Also developed XML reports for deals and revenue

information.

Environment: Oracle 8i, PL/SQL, HTML, Javascript, Java, SQl Loader, Windows NT,

Sun Solaris 5.6

Reasoning Inc

., Mountain View, CA

Conversion of Insurance System

May 00

April 01

The project was to convert the entire Insurance System of Zurich Financials, HongKong

from Ingress to Oracle. The project involved data migration, library modules, conversion

of nearly 700 Ingress frames to Oracle forms and 400 Ingress reports to Oracle reports.

Involved from start of the project till completion as a group leader with responsibilities

to develop, debug and test library modules, form modules and reports. Application was

developed for setting system operations, general maintenance, creation, endorsement,

cancellation of policies, enquiry screens, handling claims settlement, creation of account

documents and quotations. Used a custom tool for conversion and deposited in Designer 6.0.

Created and modified program units in libraries and forms, created templates for common

item properties and visual attributes, and used Oracle Terminal to create function keys.

The multiple forms application was tested extensively from a menu screen and SQL scripts

created to test accuracy of changes to the database. The application was also tested

simultaneously with Ingress application run from unix, to conform 100% with Ingress

navigation behavior. Developed reports involving creation of temporary tables dynamically

for use in the report query. The application used a lot of Dynamic SQL in library packages

and reports.

Environment: Oracle 8i, PL/SQL, Designer 6i, Developer 6i (Forms 6i, Reports 6i), SQL

Loader, Windows NT, Sun Solaris 2.7

Advanced Glassfibre

Yarns, SC

Inventory Module

November 99

- April 00

The project was to develop custom applications to the existing Inventory software module

for a glassfiber yarn manufacturer. Invloved in development of client side application for

tracking inventory items from production to finished product to help planning of

production and procurement of raw materials. Wrote server side programs and database

triggers to update order tables for quantity and reordering levels for critical items,

update inventory of by-products,, and wastages. Also developed amulti-user application for use by customer service

representatives to commit orders not committed by other users. Created reports for

printing committed orders for the day for planning shipment. Was involved in testing the

customized features after implementation in the production database.

Environment: Oracle 8.0, Developer 2000 (Forms 5.0, Reports 3.0), PL/SQL, HP-Unix 11.0,

Windows NT

NEN Life Science Products Inc

., MA

Licensing Module

February 99

- October 99

Involved in analysis, design and development of the application for license and shipping

document validations for a manufacturer of radioisotopes. Developed forms to provide order

screening, updating item quotes for customers, improve compliance for licensing and export

restrictions. Developed Packing List, Carrier Document, Quality Control Reports and

Commercial Invoices using Forms 4.5 and Reports 2.5. Was involved in testing the

customized features.

Environment: Oracle 7.3, PL/SQL, Developer 2000 (Forms 4.5, Reports 2.5), HP-Unix 9.0,

Windows NT

Schweitzer-Mauduit Inc., GA

Quality Control Software

November 97

- January 99

Involved in analysis, design and development of the Quality Control software for a

specialty paper manufacturer. Developed forms and reports for collecting QC data for its

customers. Developed Certificate of Analysis for test results and specification to match

customer calibrations, packing list for pallets and rolls, inventory reports, printing of

Bobbin labels and EDI documents. Wrote stored procedures, triggers and packages using

PL/SQL. Was involved in testing the customized features.

Environment: Oracle 7.3, PL/SQL, Pro-C, Developer 2000 (Forms 4.5, Reports 2.5), HP-Unix

9.0, Windows NT

McKee Foods Inc

., TN

Transfer Planning Application

May 97

- October 97

The project was to develop a multi-user system for planning transfer of items between

warehouses and factories located in different states. The application will integrate with

the existing manufacturing system, demand planning system and a legacy order entry system.

Invloved in creation of database objects for the custom application, development of forms

and reports for item inventory maintenance, order maintenance, order forecast, order

history, trailer maintenance, and Transfer Planning. Also wrote server side packages and

database triggers.

Environment: Oracle 7.3, PL/SQL, Developer 2000 (Forms 4.5, Reports 2.5), Windows NT

Guru Software

Services, GA

Job Order Tracking

April 96

April 97

Involved in analysis, design and development of the application for tracking job orders

and tracking trailers for a transport company. Developed forms and reports for creating,

allocating, tracking of job order status, trailer availability, allocation, status and

shipping documents.

Environment: Oracle 7.3, PL/SQL, Developer 2000(Forms 4.5, Reports 2.5), Windows NT

Employers:

May 2000

till dateAce Technologies, Inc. Milpitas, CA

Programmer/Analyst

May 1997

to April 2000Advanced Technologies & Services, LLC. Atlanta, GA

Oracle Technical Consultant

April 1996

to April 1997 - Guru Software Services, Roswell, GA

Software Developer

Education:

BA

in Commerce

Associate Degree

in Information Systems

Reference: Available on request

Contact this candidate