Title:No Title

abpxg2@r.postjobfree.com

Document

Source below

NAME: SWARUP ROY

ADDRESS:

CITY: Fords

STATE/PROVINCE: NJ

ZIP/POSTAL CODE: 00000

COUNTRY: USA

EMAIL: abpxg2@r.postjobfree.com

PHONE: 732-***-****

CANDIDATE ID: N/A

CITIZENSHIP: US

Citizen

EDUCATION: Not Entered

EXPERIENCE: Not Entered

WILL RELOCATE: Not Entered

RELOCATION INFO: Not Entered

JOB WANTED: Not Entered

HOMEPAGE:

HOTSKILLS:

ESUME

Swarup K. Roy

No Address

City, ST 00000

^732-***-****

Email: abpxg2@r.postjobfree.com

Employment Objectives

To work as Team Leader, Oracle DBA, Sr Analyst/Designer

Currently working for MCI Systemhouse as SR Technical Architect.

EDUCATION

Bachelor's of Engineering (B.E

.) in Computer Science & Technology,

Calcutta University,

Calcutta, India

EXPERIENCE SUMMARY [ Worked For TCS, IBM, AT&T, D&T, MCI ]

6+ years experience on ORACLE in following areas mainly

DESIGNER*2000,DEVELOPER*2000,PRO*C 2.X,PL/SQL 2.X,ORACLE 7.X,

SR. DBA for ORACLE 7.x & DESIGNER 20000 in AIX,SOLARIS,UNIX,WINDOWS

Skills Achieved

Oracle Database administration

Physical Database Creation, Capacity Planing

Monitoring & Tuning Database

Backup, Recovery & Auditing

Query Optimization, Maintaining User Objects

Export, Import & Data Loading

Installing Oracle Database and Tools

Analysis Of Project

SRS ( Software Requirement Specifications ) creations

FS ( Functional Specification ) Creations

Software Estimation [ FPA S/W ] & Quality policy

Design Of Project [ BY CASE TOOLS ]

Data Modeling by ERD, Process Modeling by DFD

Function hierarchy & function/entity matrix development

Re-engineering, Database design, Applications Design

Software standards creation for RDBMS,GUI,3GL

Development & Testing Of Project

RDBMS,Client Server architecture,Distributed database

Software Project Management By MS PROJECT

HARDWARE/OS:

IBM RS 6000, AIX 3.2, IBM PC-486, DELL 450/L, SUN MICRO SYSTEM,

IBM OS2 WARP, SCO UNIX 3.2, MS-WINDOWS NT/95, SUN WORK STATION,

SOLARIS 2.5, VAX, VMS, HP UNIX, HP 9000.

SOFTWARE:

ORACLE 8.0/7.3/7.2, DESIGNER 2000, DEVELOPER 2000, PRO*C 2.0,

PL/SQL 8.0/2.3, DISCOVER 2000, ORACLE*FORMS 4.5,ORACLE*REPORT 2.5,

ORACLE*GRAPHICS 2.5,LBMS 6.0,SQL*MENU 5.0, SQL*PLUS 3.2, SQL*DBA,

SQL*LOADER, C/C++,Oracle Power*Objects, Oracle System sizer

Oracle Enterprise Manager.

PROJECT PROFILE:

Nov. 97

to Apr.98

MTA Project, New York, USA

Sr. DBA For Oracle and Designer

2000

I am curently doing ORACLE Applications DBA activities which includes

installations of Oracle server & tools,physical database design &

creation,

planning for backup & recovering, optimizing sql,tuning data base,

solving

oracle errors, creating & maintaining schema objects,writing Plsql

packages,

procedures, functions, database triggers,batch programs in Pro*c. I am

also

doing adminstration of Designer*2000 repository etc.

I have installed and configured Designer*2000 repository. I provides

support

for reverse enginnering, design of Oracle Financial Applications.

I Created STANDARDS for GUI,RDBMS for Designer 2000.

I used Oracle Enterprise Manager for Oracle Database Administration.

I used Oracle System Sizer for configuring and capacity planning for

Oracle database.

Environment:

COMPAQ 486 PC, SUN WORK STATION,SOLARIS 2.5, WINDOWS NT/95, ORACLE

8/7.3,

DEVELOPER *2000, ORACLE*FORMS 4.5,ORACLE*REPOR 2.5, PL/SQL2.3,

PRO*C 2.0, DESIGNER*2000.

Apr. 97

to Nov.97

AG COMMUNICATIONS,PHOENIX,USA

Sr. Oracle DBA and Database Analyst

I have done Sr ORACLE DBA activities which includes physical database

creation,upgradation,security managemnet,auditing proper

works,optimizing

sql,tuning data base, solving oracle internal errors,

doing backup & recovery, import,export,creating/maintaining schema

objects,

start up/shut down,data loading by sql*loader,writing Plsql

packages,procedures, functions, database triggers,batch programs in

Pro*c.,

Environment:

IBM RS6000 SERVER, COMPAQ 486 PC, SUN WORK STATION, MOTIF, HP 9000,

SOLARIS 2.5,AIX 3.2, WINDOWS NT/95, HP UNIX, ORACLE 7.3,

DEVELOPER *2000, ORACLE*FORMS 4.5,ORACLE*REPORT/GRAPHICS 2.5,

PL/SQL 2.3, PRO*C 2.0, DESIGNER*2000.

Oct. 96

to Mar.97

DEPARTMENT OF SOCIAL SERVICES, Boston, USA

Family Net Project

DBA for Oracle 7.2 and Designer 2000

Involved in FAMILY NET project developed by DESIGNER 2000 with RAD

approach.

I configured and installed Oracle 7 server, Developer 2000 client

software.

I installed Designer 2000, creating repository,managing repository,

process

modelling,data modelling,application standards creation. I installed

Oracle

and created physical database,security

implementation optimizing sql,tuning database,doing backup & recovery,

creating schema objects,import,export,start up,shut down, writing

Pl*sql packages.

Environment:

IBM RS6000 SERVER, COMPAQ 486 PC, AIX 3.2, WINDOWS NT/95, ORACLE 7.2,

ORACLE*FORMS 4.5, ORACLE*REPORT 2.5, PL/SQL 2.2, DESIGNER*2000,

DEVELOPER *2000,SQL*NET 2.0.

Jan. 96

to Sep. 97

IBM, THAILAND, BANGKOK

Tax Computerization Project

Application DBA for Oracle 7.1

Involved in largest project of ASIA 'TAX COMPUTERISATION'of IBM for

Thailand government. There are many modules CIT,PIT,VAT,SBT etc.

I have worked in CIT ( corporate income tax ) group as application dba

in a ORACLE DISTRIBUTED DATABASE environment. Mainly writting Batch

programs in PRO*C,PL*SQL Packages,Optimizing SQL, Tuning Application,

Database/objects creation/modification,data loading by sql*loader

etc. I have done installation, customization & implementation Oracle

Database, Tools and Applications.

Environment:

IBM RS 6000, IBM 486 PC, AIX 3.2, IBM OS2 WARP, DEVELOPER 2000,

LBMS 6.0, PL/SQL 2.1, PRO*C 2.0,ORACLE 7.1 DISTRIBUTED DATABASE,

Jan. 95

to Dec. 95

TATA CONSULTANCY SERVICES, INDIA

Patient Care Management Systems

( PCMS )

Sr DBA for Oracle 7.1 & Designer*2000 repository

I have worked as a Oracle DBA for this big project with 25 modules &

giga byte database. PCMS is a package for client sever solution to

for hospital automation and clinical solutions. I have done

instalation,

upgradation and configure Oracle database, tools and applications.

Tuning the database, troubleshooting and support of large Oracle

database

and applications.

I have also done backup planning & recovery procedures. I have done

capacity planning,Database Creation, security,optimizing sql,creating

scIma objects,doing import,export,start up,shut down etc.

I also installed,configured, troubleshooting designer*2000 repository.

Environment:

DELL 450/L PENTIUM SERVER, IBM 486 DX2 PC, SCO UNIX 3.2 (SYSTEM V),

MS WINDOWS 3.1/95, Developer*2000,SQL*PLUS 3.1, PRO*C 1.5,PL/SQL 2.1,

ORACLE 7.1, DESIGNER*2000, SQL*NET 2.0.

Dec. 93

to Dec. 94

TATA STEEL, INDIA

Part List System

Oracle Analyst in Manufacturing Environment

This project is from largest steel production company of INDIA.

I created FS which consists of DFD,ERD, Context diagram,Functions

hierarchy,

Function/Entity Matrix,Hardware,Database,Os,Operations, Security etc I

have

done capacity planning and finding client

server requirements for this project. Later I have created physical

database,

installed tools/application,setup database system for users,

supporting

implementation. I have created critical server side batch

programs & loading program for old data using SQL*LOADER.I have done

DBA activities for optimizing sql,tuning environment,backup/recovery,

import,export,start up,shut down.

Environment:

SUN MICRO SYSTEM, SLC SPARC STATION, SOLARIES 2.3, SQL*PLUS 3.0,

SQL*FORMS

3.0,

SQL*REPORT WRITER 1.1, PRO*C 2.0, OL/SQL 2.0, ORACLE 7.0,

CASE*DICTIONARY 5.0,CASE GENERATOR 2.1, SQL*DBA, SQL*LOADER, PCNFS

5.0.

May 93

to Nov. 93

PEERLESS HOTEL, CALCUTTA, INDIA

Financial Accounting Systems

Analyst/Programmer in Oracle

For the Financial Accounting System these 5 forms were developed by

me:

Account Register, Daily Transactions, Journals, Party/Employee Master

The reports developed by me:

Bad Debts, List of Loans, Monthly Transactions,List of Bad Accounts.

The Journal population batch program was developed in Pro*C.

The chief responsibilities were designing and developing.

Environment:

VAX, VMS, SQL*FORMS 3.0, SQL*PLUS 3.0, SQL*REPORTWRITER 1.1, PRO*C

1.5,

PL/SQL 1.0, ORACLE 6.0

Nov. 92

to Apr. 93

PEERLESS HOTEL, CALCUTTA, INDIA

Inventory Control Systems

Analyst/Programmer

in Oracle

The following 7 forms were developed for this project:

General Purchavee Order,Goods Received Note,Indent

(indent between substore and main store),Transfer

(transfer of items between stores),Transactions

(daily consumption, Store (store master)and

Item (item master).

Two batch control programs were developed: Month End and Year End.

The 5 reports developed:Stock Availability, Items Below Safety Stock,

List of GRNs, Required Items, and List of Lost Goods.

The chief responsibilities were designing and developing.

Environment:

VAX, VMS, SQL*FORMS 3.0, SQL*PLUS 3.0, SQL*REPORT WRITER 1.1,

PRO*C 1.5,PL/SQL 1.0, ORACLE 6.0

Feb 92

to Oct. 92

PEERLESS HOTEL, CALCUTTA, INDIA

Hotel Management Systems

Analyst/Programmer

in Oracle

For this project, I developed the following forms:

Housekeeping (Insert/update/delete room status)

Front Menu (reservations/cancellations, cIck-in)

Banquet Hall (reservations/cancellations)

I developed following reports:

List of Arrivals/Departures,Bill Printing,Room Service

Available Facilities

His role in the project was developing and testing.

Environment:

DELL 386, SCO UNIX, SQL*FORMS 3.0, SQL*PLUS 3.0, SQL*REPORTWRITER 1.1,

PRO*C 1.5, PL/SQL 1.0, ORACLE 6.0

Contact this candidate