Title:Sr. Network Management Specialist

abpq6p@r.postjobfree.com

Document

Source below

NAME: shrenik, shrenik

ADDRESS: ***, ****** ******

ADDRESS2:

CITY: SanFranicsco

STATE: CA

ZIP: 94105

CANDIDATE ID: 714103

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 2

WILL RELOCATE

: Yes - All United States

JOB WANTED: Any

RATE NEEDED: $90,000 to $100,000

TELEPHONE:

EMAIL: abpq6p@r.postjobfree.com

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS: 2167, 3270, 80.86, a+ certification, abap, active server, activex,

animation, applet, as 400, as/400, as400, assembly language, athlon, autocad, automatic

test equipment, aviation, baan, banyan, beos

REVISION: 08-AUG-01

YOE: 2

RESUME:

shrenik parekh

101, Market Street, MS 340

SanFrancisco, CA-94105, USA.

Phone : WORK 415-***-****

Email : abpq6p@r.postjobfree.com

Visa status: h1b valid up to Aug.2003

Professional Summary:

Over 14 years of experience, out of which the last 5+ years as Oracle DBA/MS SQL Server 7

DBA

/Database Architect / System Analyst / Designer 2000 on SUN Solaris, UNIX and Windows NT

(Prod.

& Development) with OS Admin.

Over 5 years of experience as a Business Analyst / Project Analyst.

Experience of Performance Tuning such as tuning of application, shared pool, buffer

cache, I/O

distribution, rollback segments, redo mechanisms, stored procedures triggers and

functions.

Proficient in Designer 2000 - Identifying entity, attribute and establishing -

cardinality,

referential integrity of an enterprise.

Proficient in ORACLE DBA - Installation, Administration, Backup & Recovery Strategy

Implementation

according to the volatility of the data, Performance Monitoring/Tuning and Database

Security.

Proficient in Quality Testing of an Application - Guide the team in preparing test

specification,

and responsible for final testing of an application.

Proficient in MS SQL Server 7 DBA - Installation, Administration, Backup & Recovery

Strategy,

Script to retrieve object information, Run the DBCC, DTS packages, Import and export,

Maintenance plan, Link the server, Stored procedure, Database Trigger, Performance

Monitoring/

Tuning and Database Security.

Experience in planning & implementation of Backup & Recovery strategy, used physical &

logical

backup using Exp./Imp.

Experienced in Tuning SQL statements using Explain Plan, SQL Trace & TKPROF, Hints

Experienced in managing SQL* NET connectivity.

Certifications:

Brainbench Oracle 7,8 Database Administration and RDBMS concept

(http://www.brainbench.com/transcript.jsppid=422433)

Technical Skills:

Operating Systems: UNIX, Windows NT, SUN OS 5.7, Linux- Red hat 5.2 (Apollo), MS

DOS, MS Windows

RDBMS : Oracle 8, Oracle 7.3, 7.1, MS SQL Server 7, MY SQLv3, MS Access

Applications : Oracle Application Server, Oracle Financials 10.7,Oracle Application

Server 9i,

Lawson, Tock 3.3 Builder 7.0.

Tools for Oracle : Import/Export, Procedure builder, SQL Loader, Easy Conf., SQL*Net,

SQL*Loader, SQL*Plus, Server Manager, SQL*DBA

Tools for MS SQL : Enterprise Manager, OLAP Manager, MMC, Import/Export.

Server 7.0

Languages : PL/SQL, Developer 2000, PHP3, HTML

Business : Oracle Designer 2000

Analysis Tools

Hardware : HP Net server LH 6000, Sun Solaris, Alpha Server 2100.

Professional Experience

Federal Reserve Bank Of San Francisco, April. 2001 to Continued

San Francisco, CA

Database Analyst

As a Database analyst responsibilities included in the context of the ORACLE, SQL-

6.5,7.00,2000,

Netscape Application Server, Web Trend Professional Suite 5.5, Application - Lawson,

Tock.

Provide support to Application User / Developer for the Application LAWSON (PAPSI) &

TOCK, Manage

Security, Design and Implementation Of the Backup Policy.

Remote Server Management - Tracing & monitoring the Activity Of remote server locate at

LA,Chicago.

Provide support to IIS Consolidation Project.

Deploy application on web server Internet Information Server.

Installation, Maintenance and Tuning Of The - SQL Server 6.5, 7.00, 2000, Netscape

Application

Server 2.1, Web Trends Professional Suite 5.5.

Monitoring and maintenance of the production server PAPSI (LAWSON).

Migration from SQL Server 6.5 to 2000.

Environment: Oracle 8.1.5, SunOS 5.7, MS SQL Server 2000,7.0,6.5, Win NT 4.00, IIS 4.0,

Netscape Application Server 2.1, Web Trend Professional Suite 5.5,

Tock 3.3 builder 7, Lawson.

Answers.com Inc

., Pasadena, CA Feb.2001 to Mar. 2001Oracle Database Consultant

The project include trouble shoot the shell script used to load the data from production

database

to decision support, tuning database, memory - open_cursors, tuning - query used in

report, logical

backup and recovery with different option, migration from MS SQL Server 7 to Oracle

8.1.5.6

As a Database consultant responsibilities included in the context of the

ORACLE:

Tuning of the - database, memory, queries used to run the report, trouble shoot the shell

script

used for loading the data form production database to decision support system.

Migration from MS SQL Server

7.00

to Oracle 8.1.5.6

Environment: Oracle 8.1.5, SunOS 5.7,PL/SQL 2.0,Gemstone, MS SQL Server 7.0.

Jupiter InfoSoft

Jul. 2000 to Jan. 2001

Oracle / MS SQL 7 DBA

The project includes maintenance of the existing inventory management system keeping the

track

of the material management, vendors, and suppliers and generates report also.

As a Database specialist responsibilities included in the context of the

ORACLE:

Daily backup, weekly backup, tuning of an application. In writing PL/SQL stored

procedures,

functions, triggers to meet new features to be incorporated in the system to implements

business

rules.

Script to retrieve the information from the database, statistics. Tuning SQL statements

using

Explain Plan, SQL Trace & TKPROF, Hints

Environment: Oracle 8.1 for work group server, Forms 5.0, Reports 3.0, SQL * plus 3.1,

PL/SQL 2.0, Windows NT.

MS SQL Server 7.00 DBA:

The project involved community vertical portal [www.evishwagujarati.net] & e-comm. Portal

[www.gujarateshop.com] development and maintenance. Theses portals contain Online

shopping,

News, literature of reputed authors, travel section, mail facility, Chat rooms, directory

etc.

As a DBA responsibilities included in the context of the MS SQL Server 7.0

Design the databases - identifying an entity and attribute and establish referential

integrity.

Scheduling the Backup.

Administration - creating users, design the role, security keeping.

Design the Backup and & Recovery Strategy and Implementing it according to the volatility

of the data.

Writing the script to retrieve objects information as well as run the DBCC regularly.

Scheduling the DTS packages to upload and download the data from the hosting server.

Import and export the data from the hosting server.

Design and scheduling the database maintenance plan.

Link the server automate the various task new record insertion.

Stored procedure, database trigger, Performance Monitoring/Tuning and Database Security

for Databases.

Environment: MS SQL Server 7.00, ASP 3.0, Java 1.2, WIN -NT.

Jindal Online

May 2000 to July 2000MySQL DBA

The client was one of the major Internet Service Providers. The project involved in

development

of the vertical portal [www.jindalonline.com] for international business community like

importer

and exporter.

As a Database Administrator responsibilities included:

Installation of the Linux System, Configure the Apache with PHP3 and MySQL.

Configure the LDAP with Apache.

Design the directory, crone job, databases - identifying an entity and attribute and

establish

referential integrity.

Design the Administration - creating users, design the role, security keeping.

Script to retrieve the information from the database, statistics.

Environment: MySQL version 3.23.11 - Alpha, Red Hat Linux release 5.2 (Apollo),

LDAPv3, PHPv3, Java 1.2, C++, Apache 1.3.9

Nirma

March 2000 to April 2000

Oracle DBA

Nirma is one of the largest manufacturers of Detergents & cosmetics products. The project

was the synchronization of the database of the PAS having distributed DB.

As a Database Administrator responsibilities included:

Managing the database at remote site.

Creating the database, designing the tablespace, creating users, train the user to use

export

import utility. Establishing the consistent database.

Environment: WIN 95/NT, Oracle8.0 for work group server, Forms4.5, Reports 2.5,

SQL* plus 3.1, PL/SQL 2.0.

Applitech solutions

Jan. 1999 to Mar. 2000Database Administrator

Applitech Solutions [ISO 9002] is one of the leading & fastest growing software

consulting firm.

Being Database Administrator I was deputed to various clients sites for various DBA

activities.

The details of clients & my responsibilities are as following.

Vijay Tanks and Vessels

Jan. 2000 to Mar. 2000Database Administrator / Technical Leader

The project was to implement the purchase and inventory system.

Responsibilities included:

Inter action with Upper Level Management and freezing the modification, and give the

final shape

to the inventory and purchase system, Modify the database trigger.

Lead the team to customize the application according to clients frizzed requirement in

business

process of quotation and purchase order. Maintenance o the database.

Environment: Oracle 8.1 for work group server, Forms 5.0, Reports 3.0, SQL * plus 3.1,

PL/SQL

2.0, Windows NT.

AMUL

[www.amul.com] Nov. 1999 to Dec. 1999Database Administrator / Technical Leader

The project was to Y2K compliant and responsibilities included:

Lead the team to make system Y2K compliant. Update the database. Testing of the shell

scripts,

SQL files of the finance and sales module modified by the team.

Environment: SUN OS 5.7, Pro*C/C++, Oracle7.1, Forms4.5, Reports 3.0, SQL*LOADER,

SQL*Forms

3.0, SQL * plus 3.1, PL/SQL 2.0, Windows NT.

Panex Oversees

Mar. 1999 to Oct.1999Database Administrator / Technical Leader

The client was Export Oriented Unit of the Garment. The project was to develop the

integrated

application, which track the purchase, inventory, finance, manufacturing, and

merchandise,

shipping module and design the security module.

Responsibilities included:

Prepare coding standard, designs specs, process specs, identifying an entity and

attribute of

the enterprise and prepare ER diagram using designer 2000 & test specs.

Lead team & Guide the team regarding the business process of the enterprise.

Testing finance modules transaction - Invoices, voucher, credit note, debit note, bank

negotiation, bank realization, and letter of credit.

Testing all other modules which has passes the coding phase.

Design & implementation the security module.

Salient features of this security are client has to use compulsory the application that

is

developed by developer for DML operation. And DML operations are not possible through

back-end except DBA.

Environment: WIN 95/NT, Oracle8.0 for work group server, Forms4.5, Reports 2.5,

SQL * plus 3.1, PL/SQL 2.0.

Agra System, Canada Nov. 1998 to Jan. 1999Database Administrator / Technical Leader

It was the offshore project. We have to complete the coding phase of the following module

-

Type Approval, Dealership, Radio Operator, Radio Amature. We are getting the database

design,

process specs, coding standard from the client and we have to develop the application.

And responsibilities included:

Create the database and database objects according to the data dictionary sent by client

to us.

Check the database design with database integrity - whether it is according to the design

specs,

process specs, and requirement id also. Guide team in the business process. Testing of

modules.

Environment: WIN 95/NT, Oracle7.3 for work group server, Forms4.5, Reports 2.5,

SQL * plus 3.1, PL/SQL 2.0

Client Server

SoftwareJan. 1996 to Oct. 1998

Oracle Database Consultant

Core Health Care: - The client was the, manufacturer of the bulk pharmaceutical drug.

Lubi Electricals: - The client was the, manufacturer of the bulk electrical components.

The project was to provide ERP solution. Develop the complete integrated system including

all the modules - purchase, inventory, manufacturing, sales, finance, quality, human

resources, security.

As a DBA responsibilities included:

System Analysis, Business processes reengineering.

Mapping of the business entity, Develop the data flow diagram, and define the entities,

attributes and establishing - cardinality, referential integrity of the enterprise.

Develop the ER diagram-using designer 2000, Guide the team in the area of business

process so that coding logic proves easy for them.

Guide the team in preparing coding standard, design specs, and process specs, test specs.

Testing of the systems different modules.

Demonstration of the application at clients site and get the approval of the system from

client, and sign off.

Train the clients employee regarding how to use the system.

Tuning and monitoring of the - application, database, SGA, alert file.

Database warehousing - Store the historical database at secure place.

Environment: WIN 95/NT, Designer 2000, Oracle7.1, Forms4.5, Reports 2.5, SQL * plus

3.1, PL/SQL 2.0.

Independent Consultant

Jan. 1995 to Dec. 1995

Desktop Solution

in MS ACCESS

The clients were professional people - Doctors, Lawyer and Engineers. The projects were

to

provide desktop financial accounting system and implement it.

Environment: WIN 95, MS ACCESS.

N.B. Valand & Co

. Jan. 1986 to Dec. 1994Business Analyst & Project Analyst

The clientele base were various organizations from different kind of industry sectors

consumer products, process industry, industrial products, Banks, Financial Institutions

etc.

The type of the work to analyze the business, finance position, marketing strategy,

provide

assistance in establishment of the enterprise, provide marketing assistance.

Was responsible for:

Preparing business report of the enterprise / organization i.e. their business process,

what

were the unnecessary expenses incurred, what are the non value-added activity by visiting

clients site and office and remarks suggestion.

Scrutinizing the financial document and report to the manage about its various aspect

i.e. GP

Ratio, NP Ratio, Expenses, Assets, Capital as compared to previous years record and

prepare a

detail report with the factors affecting the result.

Providing assistance to manager in preparing business plan prepared for getting finance

from

the financial institution AND in international marketing to study the market potential in

export

business - Agriculture product, spices, casting, hardware. And negotiated with the export

promotion council at India and abroad to assist developing countries.

Education

Associate Degree

in Engineering

Bachelors of Commerce

Contact this candidate