Posted by on September 26, 19101 at 20:57:26:

Y. SRI HARI

Phone - Res: +91-0712-232716,
Off: +91-0712-556319
Email:- srihari_n@hotmail.com
c/o prof chimote
Plot no 21,Atrey layout,
City: Nagpur
State: Maharastra
Country: India
pin 440022

Summary
Over 3.8 years of experience in IT with 3 years of
Database administration, designing, coding, testing
and implementation of commercial applications using
Oracle8, Oracle8I,Powerbuilder under windows NT,
Linux, windows 95 & 98. Worked on tools
like Enterprise Manager, RMAN and Legato storage
Manager in 24/7 databases. Comfortable with space
management, object management, user management,
tablespace management, elimination of contention,
performance tuning, SQL Tuning, backup & recovery and
capacity planning. Acquainted with Oracle Server
Architecture,
instance Architecture and management, Creation of
database according to OFA compliant, maintenance of
physical files, storage structures and relationships,
management of rollback segments, managing database
objects, data movement utilities, reorganization of
data, management of privileges and security.

Skills
Hardware P-III, P-II, Pentium MMX, IBM
Compatibles, And 80x86 Machines.
Software Oracle 8i /8.0.5,
Powerbuilder , PL / SQL, Legato
Storage Manager
,Windows NT, Windows 95, Windows 3.11,
SCO-Unix, HP-Unix ,Linux MS-DOS.

Projects Experience

ADCC R&C Ltd. ( Mar 2001 to till date)

Client sitycom

A b2b Pharmaceutical portal wherein the complete chain
from
Manufacturers to
Retailers will be online for buying and selling. Also,
chain from
Manufacturer along with Zonal / Regional / District
Sales Mgr. to
Medical Representatives will be online. This will help
the Manufacturers to decide the manufacturing process
based on the reports that will be generated online.

Value additions to the portal will be the additions of
Doctors,
Transportations and Courier Services. Doctors will
prescribe medicines
to the patient online, and the Retailer affiliated to
the Doctor will
receive the prescription. All the patient has to do
pick up his medicines.

Transportations and Courier services will be used to
transport
medicines from one place to another.
The system so intelligent and user friendly enough
that, the business
Will be online and offline having logical inventory
boundaries. Once the logical online/offline inventory
is reached below a buffer point, the system places an
order to the Wholesaler, which on reaching places an
order to the C&A(Carry and Forward Agent) and it is
carried forward to the Manufacturer. If the stock is
ready, the Transportation or the Courier service is
booked. The lead days are calculated and the complete
chain is responded back and it provides Various
Decision support reports.

Role
· Create the Database according to OFA compliant.
· Laying out appropriate backup strategies and
implementing them.
· User management, Space management, solving the file
contention problem. solving the connectivity problem
from server to server and client to server. Enabling
remote management of various databases.
· Solving the performance related problems through
memory tuning, I/O tuning. SQL tuning, removing file
contention etc.
· Enforcing security through proper authentication,
proper assignment of roles and privileges.

Software: Oracle8i V8.1.5, Oracle Enterprise Manager,
Legato Storage
Manager, Windows NT 4.0, Windows 95/98,

ADCC R&C Ltd

Client :- NECO Group Of Industries Ltd. (Jul 2000 2001
Mar)
Project Description:- This is a turnkey project which
involves the complete computerization
of the NECO Group, which comprises of a number of
companies involved in
manufacturing of steel pipes, steel sheets and all
type of cast
Materials.

This is a completely integrated system catering to the
overall business
activities of NECO. The system consists of the
following main modules.

¨ INVAC
¨ FINAC
¨ SALES
¨ PAYROLL

INVAC: It takes care of inventory management of the
Company.

FINAC: It covers the financial transactions of the
Company.

SALES: This subsystem is related to sales management.

PAYROLL: It manages the salary processing of the
employees of NECO.
. Create the Database according to OFA compliant.
· Data base Design Using Erwin
. Laying out appropriate backup strategies and
implementing them.
· Solving the performance related problems through
memory tuning, I/O tuning. SQL tuning, removing file
contention etc.
. Checking the alert logs of all the databases to find
out any untoward events
· Checking the availability of all the
table-space/data files
· Table growth analysis.
· Checking of online backup
Software: Oracle7.3
Windows NT, Windows
95/98.

ADCC R&C Ltd

Client: L&T Cements Ltd. (Jan 2000 to Jun 2000)

Project Description:
This system caters to the needs of Human Resource
department of L&T
Cement Group, Awarpur M.S. India. It takes care of
maintaining the
personal records of all employees, recruitment
management, manpower planning,
and promotion management and transfer management.

Role
· Create the Database according to OFA compliant.
· Designing Database using Erwin tool.
. Writing SQL Queries, stored procedures and triggers.
· Solving the performance related problems through
memory tuning, I/O tuning. SQL tuning, removing file
contention etc.

Software: Oracle7.3 , Oracle
Enterprise Manager, Legato
Storage Manager, Windows NT, Windows 95/98.

ADCC R&C Ltd

ISPAT Industries Ltd.(Aug 1999 to Nov 1999)

Project Description: Inventory Management & Production
Planning System.

This application is highly OLTP (Online transaction
processing) system. This system takes care of all the
activities in Inventory & Production planning. This
system provides Various decision support , alarm
signaling reports.

Role
· Suggestion of proper Hardware configuration
estimating the kind of load and environment the
application will face.
· Installation of Oracle server software
· Create the Database according to OFA compliant.
· Suggestion of appropriate RAID solution depending on
the environment.
· Design the Database using appropriate Normalization
methods.
· Converting the logical design into physical design.
· Laying out appropriate backup strategies and
implementing them.
· User management, Space management, solving the file
contention problem.
· Solving the connectivity problem from server to
server and client to server.
· Solving the performance related problems through
memory tuning, I/O tuning.
· SQL tuning, removing file contention etc.
· Enforcing security through proper authentication,
proper assignment of roles and privileges.
· Capacity planning.

Software: Oracle8 V8.0.4, Oracle Enterprise Manager,
Windows NT, Windows 95/98,

Client : L&T Cements (Feb 1999 to Jun 1999)
Project Description: Sales Management System.

This application will take care of all the sales
activities From the Order processing to Payment
collection,
Calculating Incentives for the Marketing Personnel
and
Commission calculations for Stockiest, Sub stockiest
.It
provides various decision support reports.

Role
· Installation of Oracle Server Software Red Hat Linux
6.1.
· Suggestion of proper Hardware configuration
estimating the kind of load and environment the
application will face.
· Create the Database according to OFA compliant.
· Laying out appropriate backup strategies and
implementing them.
· User management, Space management, solving the file
contention problem. Solving the connectivity problem
from server to server and client to server. Enabling
remote management of various databases.
· Solving the performance related problems through
memory tuning, I/O tuning. SQL tuning, removing file
contention etc.
· Enforcing security through proper authentication,
proper assignment of roles and privileges.

Software: Oracle8i V8.1.5, Oracle Enterprise Manager,
Legato Storage
Manager, Red Hat Linux 6.1, Windows 95/98,

ISPAT Industries Ltd.( Jan 1998 Aug1998)

Project Description :Maintenance Management System.
It effectively designed to strengthen essential
maintenance
( preventive and predictive Maintenance) and reduce
non-essential Maintenance( Break down maintenance)
Thereby
resulting in low cost, Improved quality, reliability,
reduction in delays, improved availability and
anticipated
shutdowns. This software package intended to keep
track
machinery's upkeep, repair, renewal and replacement of
worn,
damaged or obsolete parts also in efficiently
utilizing Manpower
and Inventory.

Role
· Design the Database using appropriate Normalization
methods.
· Converting the logical design into physical design.
· creating the database according to OFA complaint on
RAW partition.
· Laying out appropriate backup strategies and
implementing them.
· User management, Space management, solving the file
contention problem.
· Solving the connectivity problem from server to
server and client to server.
· Enabling remote management of various databases.
· Writing stored procedures stored functions, triggers
etc.
· Solving the performance related problems through
memory tuning, I/O tuning.
· SQL tuning, removing file contention etc.
· Enforcing security through proper authentication,
proper assignment of roles and privileges.
· Capacity planning.

Software: Oracle8I V8.1.5, Powerbuilder,
Windows NT,
Windows 95/98,