Vijayan Amaladhas - Consulting - http://maxpages.com/itconsultants/VijayA

Availability: February 2000

SUMMARY:
Vijayan is an Oracle Certified Database Administrator. He Has nearly 5 Years of Experience in Oracle Database Ver 8.0/7.3/7.2/6.0 Administration. He also has a total of 6 Years of experience in the Software Industry. Vijayan has expertise in Database Administration, Database Tuning, SQL Tuning, Database design, Data Modeling, Data and Process Flow Diagram, Entity Relationship Diagram (logical model) and Physical Model. He has Good experience in Software Life Cycle. (System Study: information gathering), Design, Program Specification, Coding, writing test scripts for Unit testing, Integration testing, System Testing and maintaining and supporting the Database). Has very good experience in OLTP, DSS and Hybrid Oracle systems, as well as production support for 24/7 Databases.

Expertise in the Areas of -

Install, Maintain Oracle Server and other Oracle Products

Create, maintain and upgrade Databases

Database Backup and Recovery

Database Security

Database Tuning

Database Architecture and Design

Data Modeling

PL/SQL Coding and Tuning

SKILLS:
OS: UNIX system V R4.0 Ver2.0 (AT&T), SEQUENT DYNIX/ptx 4.1, SUN Solaris 2.6/2.5
SUN OS 5.4 Rel, HP - UX 9.04, SVR 4/MP, AT & T UNIX V Release 3.2, Windows 98/95/3.1, DOS 6.2/5.0
Hardware: Unisys PENTIUM P5/EISA, Sequent, Sun Sparc, HP - 9000 Series, HCL - HP Busybee 486/Pentium Systems, Wipro Synergy Pentium/486 LM 486/386
RDBMS: ORACLE 8.0/7.3/7.2 / 7.1/ 6.0 Open VMS V6.2. (On Alpha/VAX Machine)
GUI TOOLS: Oracle Forms 4.5 /3.0/ 2.3, Oracle Reports 2.5 , RPT, RPF, Developer 2000
DBA Tools: BMC Patrol, Oracle Enterprise Manager, SQL*DBA, SVRMGR
Other Tools: PL/SQL 2.2/2.1/ 1.1, SQL*Plus 3.1, Oracle Reports 2.5, RPT, Pro*COBOL , SQL*Loader, SQL*Menu 5.0/4.0,Export, Import, RFLOW, ERwin/ERX2.01 Lotus Notes E-mail, Remedy
Networks: SQL*NET 2.2/2.0

EXPERIENCE:
March 1998 - Till Date
Consultant – Object Resources, Overland Park, KS
ORACLE DBA Consultant, Eli Lilly and Company, Indianapolis, Indiana
Project #14
Project Name: COMMERCIALIZE DATA FOUNDATION (CDF)
Description: CDF is a Staging Area Database. Involved in Subscribing and Publication to multiple databases. Subscription and Publication concept is implemented through Oracle snapshots. 24/7 Database. Data refreshes and Batch processes occur on cycles of 3 hour window. Production Database size, including all Subscriptions and Publications, is around 50Gig.

DBA ACTIVITES:

Multi-tasking working environment supporting and maintaining multiple databases.

24/7 Database Support.

Space Evaluation and Space management, of new schemas (Subscription and Publications)

Table and Tablespace Re-Organization.

Creating Application Schemas in the Database.

Installing Oracle Server and Products.

Upgrading Oracle and Applying Patches.

Database Maintenance.

Day-to-day database Support.

Database and SQL Tuning.

Oracle/ Database Security.

Snapshot and Snapshot Log Creation.

Database Links

Code Reviews.

Developed and implemented a step-by-step procedure on moving Database Objects and Application from Development to Testing and from Testing to Production Database.

User Account Validation. (Process to ensure that the privileges granted to users confirms with Eli Lilly Standards.)

Instance Validation. (Process to ensure that the Creation of the Instance, Users, Tablespaces and Objects confirms with Company Standards.)
Environment: Sun Sparc/Sun OS 5.6 (2.6), 5.5.2(Solaris 2.5.2), 5.5.1(Solaris 2.5.1), Oracle 7.3.4 /7.3.3/7.3.2, Export, Import, SQL*Plus 3.3 and SQL*Loader.

Project #13
Project Name: Year 2000 Testing
Description: Testing of Databases and Applications to assure that the System/s will run normally as expected in the 21st Century. Creating the database for Y2K testing OR Recovering the database as part of Y2K testing from the backup of the production database. Migrating objects to the new database for testing. Security, back up and maintaining the database. Y2K Instances were Created, Tested and Maintained during the Testing Period for the following Databases.

CTMan (Clinical Trial Management)

CTM DataMart

CTMC (Clinical Trial Material Compliance)

Documentation Database

Regulatory Application

MPD (Medical Planning Database)
Environment: Sun Sparc/Sun OS 5.6 (2.6), 5.5.2(Solaris 2.5.2), 5.5.1(Solaris 2.5.1), Oracle 7.3.4 /7.3.3/7.3.2, Export, Import, SQL*Plus 3.3 and SQL*Loader.

Project #12
Project Name: ORACLE Common Scripts Upgrading
Description: A set of scripts which include shell Scripts, SQL's and information storing files (data) are developed and maintained for Checking the databases, alerting the DBA's of any occurrence of Errors in Database/Instance or System wide errors. This Includes Installation, Upgrading of Common Scripts from C shell to K shell or from lower version of K shell to Higher Version (V 2.0), Updating the common scripts with necessary changes, and Testing the scripts. Upgraded 3 Unix Servers.
Environment: Sun Sparc/Sun OS 5.5.2(Solaris 2.5.2), 5.5.1(Solaris 2.5.1)

Project #11
Project Name: Regulatory Activity and Project Tracking System (RAPT)
Description: Supporting Production, Testing and Development Databases. The Size of the database
varies from 3 to 12 GB. This project involved data and structure Migration using BMC Patrol, Change
control, using BMC; adding, modifying and dropping Objects in the database, and Migrating the changes to
different instances through BMCPatrol.
Environment: Sun Sparc/Sun OS 5.5.2(Solaris 2.5.2), 5.5.1(Solaris 2.5.1), Oracle 7.3.3.5, BMC Patrol, Export, Import, SQL*Plus 3.3 and SQL*Loader.

Project #10
Project Name: CT-MAN (Clinical Trial Management)
Description: Managing Production, Testing and Development Databases in Oracle 7.3. Supporting multiple OLTP and DSS applications. The Size of the database varies from 2 to 10 GB.

Databases and Applications in this project includes,
- CT Fin (Clinical Trial Finance)

Involved in the Design of CYCLE CHANGE OVER (CCO) module.

Coding for the entire CCO Module.

Unit, Integration test Scripts and SYSTEM testing the code.

Moving Code/Objects stored in the database from Development to Test and

Test to Production Database.
- CTMan DataMart. (Clinical Trial Management, a Decision Support System)

DataMart Combining data from CTMan, CDF (Commercialize Data

Foundation and CT Finance)
- CTMan, Clinical Trial Management (Impact Application)

Upgrading of the Impact Software (Fraser Williams, England) in

Development, Test and Production Databases.

Upgraded from 3.2.3 to 3.2.4

Upgraded from 3.2.4 to 3.3.2

Created and Modified Snapshots, Views for Tables in CDF.( Data from

CTMAN to Commercialize Data Foundation)

Created and Modified Snapshots, Views for Tables in CTMan. (Data from

CTMan to CTFin)

Created and Modified Snapshots, Views for Tables in CTMan. (Data from

CTMan to DataMart)

Maintain Jobs running in CTMan, CTFin and CTM DataMart.
Environment: Sun Sparc/Sun OS 5.5.2(Solaris 2.5.2), 5.5.1(Solaris 2.5.1), Oracle
7.3.3/7.3.2.3.0/7.2.3.0.0, Export, Import, Oracle 7.1.3.20 Export, Import, SQL*Plus 3.1/3.2/3.3

DBA ACTIVITIES

Multi-tasking working environment supporting and maintaining multiple databases.

Space Evaluation and Space management, of new schemas / Existing schemas during re-organization,

Creating new databases for Development, Testing and Production.

Creating Application Schemas in the Database.

Installing Oracle Server and Products.

Upgrading Oracle and Applying Patches.

Database Maintenance.

Day-to-day database Support.

Table and Schema Re-organization.

Database Links.

Upgrading third party Applications Changes in the DATABASE (Server) Side.

Oracle Security.

Migrating Databases to Different Servers.

User Account Validation. (Process to ensure that the privileges granted to users confirms with Eli Lilly Standards.)

Instance Validation.(Process to ensure that the Creation of the Instance, Users, Tablespaces and Security confirms with Eli Lilly Standards.)

Server Validation. .(Process to ensure that the All the Databases/Instance, Users, Tablespaces, Physical Structure and Security of a SERVER confirms with Eli Lilly Standards.)
Apart from the above projects also supporting the following projects.

CTMC (Clinical Trial Material Compliance, Web based Application)

Documentation Database. (Database that used to Store Documentation of Different Applications and On-going Researches, Studies and
Projects)

November 1997 - December1998
DBA Consultant, OFFICEMAX, Cleveland, Ohio.
Project #09
Project Name: MerchEIS
Description: This is a production database in Oracle 7.1.4 The size of the Database is around 250GB.
Environment: The system is in Oracle 7.1.4 server with Export, Import, SQL*Loader, SQL*Plus 3.2, running on Unisys, Windows 95.

DBA ACTIVITIES

Space management, Data Loading, Database tuning, SQL Tuning, Oracle Server Tuning

Database backup & Recovery procedures.

Database Maintenance

Day-to-Day Support

Table Re-organization

Database Monitoring

Feb 1997 - October 1997
DBA Consultant, First Data Solutions, Omaha, Nebraska
Project #08
Project Name: Western Union
Description: This is a production database in Oracle 7.3.2. The size of the Database is around
120GB. I was working in a DBA team of 8 members. Oracle Enterprise manager is used for monitoring.
Environment: The system is in Oracle 7.3.2 server with Export, Import, SQL*Loader, SQL*Plus 3.2, Business objects running on Sun OS 5.4 on Sun Sparc, Windows 95.

Project #07
Project Name: Collection Solutions
Description: This is a testing database converted from Mainframe to Oracle 7.3.2 Parallel Server with PQO option. The size of the Database is around 550 GB.
Environment: The system is in Oracle 7.3.2 server with Export, Import, SQL*Loader, SQL*Plus 3.2, Pro*Cobol running on DYNIX/ptx V4.1, Windows 95.

Project #06
Project Name: Customer Contact
Description: The system, Customer Contact is being developed as product to effectively manage the
usage of Collection Solutions by the various clients of FDC. The system provides an intelligent querying
option which takes away the decision control from the end-users who are mainly the collectors and
managers. It has a bookmark module, which stores all the customer information when queried first and
this bookmark is used for subsequent queries, thus, avoiding hitting 'hot tables'. It also provides as
information bank on database access and the total elapsed time the user hitting the database and using
this tool for effective billing purposes.
Environment: The system was developed in Oracle 7.2 server with Export, Import, SQL*Loader, SQL*Plus 3.2, PL/SQL 2.2, running on DYNIX/ptx V4.1. Oracle Enterprise manager is used for monitoring.

Project #5
Project Name: SalesBook
Description: The system, SalesBook 4.2 for Oracle, is a multi-user on-line Transaction Processing
system. The database has a maximum of 100 concurrent users and around 25 remote users, who
connect to the Oracle database to synchronize their Laptop database running Watcom/Sybase SQL
anywhere, with the Centralized Database. Synchronization process includes moving data to and from
Oracle Database, specific to the User and his privileges.
Responsibilities: In this project my task includes the conversion of existing Database in SYBASE SQL
Anywhere 5 to Oracle which includes System Tables, Database Tables, Views, Procedures, Triggers,
Integrity Constraints object relations, Sequences, Indexes, Private and Public synonyms. The Size of the
database was around 3GB.

DBA ACTIVITIES:

System Study, Database Design

Space Analysis & Evaluation

Database Creation

Space management, Data Loading

Tuning File I/O

Planing the Database backup & Recovery procedures.

Database Maintenance

Database day-to-day Support

Database Monitoring

SQL Tuning
Database migration from Sun Sparc to Sequent Machine. Identifying raw partitions, map tablespaces to rows and map tables to tablespaces. Database file link creation, Database creation, Data Loading, Scheduling the monitoring scripts, Exports and Imports, Index creation, Analyzing the schema etc.
Environment: The system was developed in Oracle 7.2 server with Export, Import, SQL*Loader, SQL*Plus 3.2, PL/SQL 2.2, running on DYNIX/ptx V4.1. Oracle Enterprise manager is used for monitoring.

Jan 1996 - Dec 1996
Associate Consultant / Module Leader, HCL - HEWLETT PACKARD
Project # 4
Project Name: Non Banking Financial System
Description: This system includes four major modules: VIZ Financial Accounting, Deposit Management
system, Hire Purchase Leasing, Bills Discounting. Deposit Management System takes care of fresh
deposits (Fixed, Cumulative, RD, Business, Inter-corporate), Closures and Pre-closures, Gifts and
Incentives paid to depositors and Brokers, Interest Warrant Generations and postings, Loan Issue and
Repayments, Tax calculations and Postings, Closures and pre-closure Postings, Accrued Interest
Postings, Tax, Loan Statements, Loan Ledgers, and Deposit Ledgers.

DBA ACTIVITIES:

Site Evaluation

Oracle Installation

Application Software.

Space Evaluation,

Database creation.

Application and Database Tuning

Data loading.

Database Recovery Procedures.
Also involved in Application coding in Developer 2000 and PL/SQL Procedures and Packages.
The size of the Database is around 10 GB. Was working in a DBA team of 3 members.
Environment: The system was developed on HP 9000 Series - Server on HP - UX 9.04 using Oracle Forms 4.5, Oracle Reports 2.5, Export, Import, RFLOW, ERwin/ERX2.01, SQL*Loader on Oracle 7.1

Feb 94 - Dec 95
Technical Consultant, WIPRO INFOTECH LIMITED
Project #3
Client Name: Department of Telecommunication, Govt. of India.
Project Name: TELEPHONE REVENUE BILLING AND ACCOUNTING SYSTEM
Description: Computerization of Telephone Revenue Accounts Section of DOT, Calculates Meter Call,
Trunk Call, Phonogram and ITX Call charges, Generates Bills for all subscribers, Updates subscriber
information, Accepts Payments, Generates Subledger. Reports like Engineering Report, Subscriber Record
Card, Disconnection, Outstanding Analysis, Subledger Review Statement, Service Tax and Surcharge
broad Sheets.

DBA ACTIVITIES

Responsibility in this project Included Preparation of site for Oracle Installation

Space Management and Analysis

Database Architecture

Design Application

Application coding

Database creation

Database tuning

SQL tuning, allocating resource quota

Backup and recovery planning and coding scripts.
*The size of the database varies for different locations from 7 to 15 GB.
Environment: SVR4/MP, Unix V Release 3.2, Pentium using Oracle Forms 2.3, Sql*Forms 3.0, SQL*Loader, RPT, Sql*Menu 3.0/4.0 on Oracle 6.0.

June 1993 - Jan 1994
Project #2,
Programmer, STANVA CONSULTANTS
Client Name: Stanva Builders
Project Name: COST ESTIMATION
Description: The scope of this project is to calculate the complete Project cost, Generate reports like
Stock Report, Details of Material Shipment, Billing Reports, Analysis Reports. The system was developed
on UNIX System V Release 3.2 using Sql*Forms 2.3, SQL*Loader, Sql*Menu3.0 on Oracle 6.0.

Project #1,
Client Name: Thirumalai Financiers Pvt. Ltd., Banking System
Description: The scope of this project is to handle and Open fresh accounts, Accepts recurring Deposits, Cumulative Deposits and Fixed Deposits.
Environment: UNIX System V using Sql*Forms 3.0, SQL*Plus 3.1 under Oracle 6.0.

EDUCATION:
Bachelor of Engineering in Computer Science and Engineering, MK University, India.

IT Resources
9401 W. Indian Creek Pkwy., Suite 1100
Overland Park	Kansas	66210
USA
(913) 438-7140 ext. 112
Fax (913) 438-7130
patty.w@orimail.com

Sign Guestbook

View Guestbook

Visitors: 01031

Page Updated Wed Jan 26, 2000 12:42pm EST