Oracle Project
Resume:
Title:No Title
*********@*******.***
Document
Source below
NAME: SWARUP ROY
ADDRESS:
CITY: Fords
STATE/PROVINCE: NJ
ZIP/POSTAL CODE: 00000
COUNTRY: USA
EMAIL: *********@*******.***
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
Email: *********@*******.***
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