Sql Server Oracle

Location:

San Ramon, CA

Posted:

December 01, 2012

Contact this candidate

Resume:

Title:Administrative Assistant

***********@*******.***

Document

Source below

NAME: Asim Shahab

ADDRESS: **** ****** *****

CITY: San Ramon

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 94583

COUNTRY: USA

EMAIL: ***********@*******.***

PHONE:

CANDIDATE ID: 110655

CITIZENSHIP: US

Citizen

EDUCATION: Master Degree

EXPERIENCE: 0

WILL RELOCATE: Yes

RELOCATION INFO: All Locations

JOB WANTED: Any

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

HOMEPAGE:

HOTSKILLS:

ESUME

Asim Shahab

9631 Pleasant lake Blvd, Apt Z-8

Parma, OH 44130

(440)V884-5378

***********@*******.***

OBJECTIVE: Seeking a position in the computer industry.

EDUCATION: Cleveland State University,

Cleveland, Ohio

April 1997

- May 2000

Master of Computer & Information Science

College of Wooster

August 1986

- May 1990

Bachelor of Chemistry

CERTIFICATIONS:

Oracle Certified Professional (OCP).

Microsoft Certified Professional Windows 2000 Workstation (MCP).

TECHNICAL EXPERIENCE:

Databases: Oracle7/8/8i, Microsoft SQL Server 6.5/7.0, Microsoft SQL

Server 2000, Access, Paradox

GUI: Visual Basic, PowerBuilder, C, C++, JAVA

Language: Active Server Pages (ASP), JavaScript, HTML,

SQL, SQR,

PeopleTools

OS: Unix, Linux, Windows 95/98/NT/2000

Application Packages: iPlanet Suite, Netscape Commerce (Web) Server, Apache

Web Server, Microsoft Internet Information Server.

RANGE OF EXPERIENCE:

Three years experience in Information Technology Infrastructure (ITI).

Operations experience with systems, and networks in client-server and web

environment. Technical experience using Unix, Linux, Windows NT, and Windows

2000 servers. Experience in Unix, Windows NT, and Windows 2000

Administration. Designed databases using S-designer, PowerDesigner and Erwin.

Wrote stored procedures and triggers to increase the efficiency and integrity

of the database. Backed up using hot backup, cold backup, and exporting data.

Responsible for database Administration of Oracle Databases, SQL Server 7.0

databases and SQL Server 2000 databases on a variety of Platforms

EXPERIENCE:

PeopleSoft, Inc

2001

-PresentGSC Install/Upgrade Analyst, concentration on Citrix, Microsoft SQL and Oracle

install and upgrades. Answered questions on the installation of Peoplesoft in

two, three and n-tier architecture. Trained on Peopletools and Peoplecode.

Used Vantive CRM and answered questions on problems encountered during

upgrade. Went through upgrade on Tools only, Financial and HRMS.

PricewaterhouseCoopers

Consultant

2000

-2001

Responsible for Database Administration of Oracle as well as SQL Server

Databases and Development of web based applications involving Windows DNA

Architecture. Created Component, which talked to Microsoft SQL server. Wrote

reports in ASP. Involves use of Components, JavaScript, VBScript, Visual

Basic, XML, and SQL. Design of database using Erwin, PowerDesigner.

Implemented Advanced Oracle Replication, scheduling of jobs from Oracle SNP

servers, wrote stored procedures and triggers in PLSQL, and called external

JAVA programs from Oracle stored Procedures and triggers.

Cleveland Clinic Foundation, Cleveland, Ohio

Internet Specialist and Oracle DBA

1998

- 2000

Developed a pre-transplant database for a consortium of five hospitals.

The application is completely Internet based. The application was developed to

keep a repository of the patients medical record so that a physician from a

remote location can easily review it with the aid of a web browser. The tools

used to develop the application are Oracle, Visual Basic, JAVA, VB Web Classes,

DLLs, VBScript, JavaScript, and HTML. Sophisticated queries were built using

Oracles PL/SQL or SQL so that a user can obtain routine data easily.

Developed an Internet based application for patient tracking. The application

was developed as a VB Web Class using HTML templates. The back end was the

Oracle database.

ASAP Technical Services

Assistant Organic Supervisor

1995

-1998

Responsible for the Analysis of Organic compounds using purge and trap

technique and using a Gas Chromatograph. Used Paradox Database to find out the

samples to be analyzed that day. Certified by OHEPA for the analysis Organic

compounds in drinking water

ASAP Technical Services

Inorganic Supervisor

1993

-1995

Responsible for supervising the Inorganic Department of the Laboratory.

Supervised 3-5 people. Responsible for scheduling using Paradox databases.

Performed analysis and made sure that the work was being performed on time.

Certified by OHEPA for the analysis of inorganic compounds in drinking water.

Burlington Environmental Inc

On-site Supervisor

1992

-1993

Supervised the Onsite analysis of samples. Analyzed the samples for organic

with a Gas Chromatograph (GC) using purge and trap techniques. Responsible for

obtaining the samples using a Geo Probe. Produced reports on site using a HP

Chem Station.

MASI Environmental Labs

Chemist/Analyst

1990

-1992

Analyzed Drinking Water for Bacteria, Metal and various inorganic compounds.

Certified by Ohio EPA.

REFERENCES: Available upon Request

PROJECTS:

h Created databases on NT, Unix and Linux platforms. Proposed the architecture

for the site. Designed the data model using Erwin. Implemented Advanced Oracle

Replication in Asynchronous mode. Scheduled jobs from Oracle using the SNP

server and executed external JAVA programs from triggers and stored procedures.

h Created new panels using PeopleSofts Application Designer also created the

related fields, records and menus, and wrote SQR reports.

h Currently certified by Oracle as an Oracle Certified Professional in Oracle

8.0. Have designed and deployed over half a dozen applications. Have gone

through all stages of application development from the initial determination of

user requirement to the actual deployment of the applications in production.

Performed Oracle database administrator functions including data normalization,

and analysis of referential integrity, design using S-designer and

PowerDesigner, database creation in a test environment. Built applications in

the development and test environment and then moved the application to

production. Created stored procedures and triggers. Performed ongoing

maintenance, security, tuning, backup and analysis duties. Regularly

maintained and tuned the database for most effective results. Wrote queries in

SQL, and stored procedures in PL/SQL. Triggers where written in PL/SQL to

maintain data integrity. The database platform has been Windows NT, Windows

2000 and Sun Unix (Solaris 7 and Solaris 8), and Linux.

h Installed and worked with Microsoft SQL Server 7.0. Upgraded the database

from version 6.5 to 7.0. Have a good understanding of database design and an

in-depth understanding of the database model. Written sophisticated queries,

triggers and stored procedures in the database to increase database performance

and to ensure data integrity.

h For a department of the county performed analysis of their current system and

built an application designed in ASP. The business logic was placed in Oracle

stored procedures were called from the ASP procedures. Information between the

county and the hospitals was exchanged using XML format. Stored procedures

were written to generate the appropriate XML and to parse the returned XML and

place the information into the database. Edit checking was done in JavaScript

and the application was deployed using IIS. File transfer protocol was also

enabled so data could be transferred directly from the hospitals to the county

database.

h For a department of the county wrote an application designed in ASP using

components written in Visual Basic with Microsoft SQL Server 6.5 as the back

end (upgraded to SQL Server 7.0). The appliction was then deployed using the

MTS architecture. Queries and business logic was placed in the Visual Basic

Components and the application deployed using Microsoft IIS server.

h For a major healthcare provider, defined user requirements, designed and

developed a web-based pre-transplant database for a consortium of five

hospitals. User requirements were determined through careful interviews and

the application designed on those basis. The application was developed to keep

a repository of patients medical records so that a physician can easily review

these records from a remote location with the aid of a web browser. The

application was built using Visual Basic, JAVA, VB Web Classes, DLLs,

VBScript, JavaScript, and HTML, using rapid application development principles.

Sophisticated queries were built using Oracles PL/SQL or SQL so a user can

obtain routine data easily.

h Designed, developed and deployed an application designed as a VB Web Class

using components written in C++, which were then deployed using the MTS

architecture. The application provided for the tracking of hospital patients

which were being serviced by the hospital. The application also created a

comma delimited file which was then downloaded to hand held Palm Pilots.

h Designed and Developed reports using Crystal Report which were then called

from a VB Application. The backend was an Accesss database.

h Designed, developed and deployed a client/server application for a major

healthcare provider. User requirements were accurately determined and the

application designed on those bases. The application was designed using

powerbuilder as the front-end tool and Oracle as the database repository. The

application captured user input for biopies performed. Sophisticated

calculations and triggers were created in the application to verify the

integrity of the input data and to display the data. The database was designed

using powerdesigner and the database was fully normalized. Queries and stored

procedures were written in SQL and PL/SQL to provide and capture information

from the user in the most effective and efficient manner.

h Designed, developed and deployed a client/server application for a major

healthcare provider. User requirements were accurately determined and the

application designed on those bases. The application was designed using

powerbuilder as the front-end tool and Oracle as the database repository. The

application captured user input for Right Heart Catherizations performed.

Sophisticated calculations and triggers were created in the application to

verify the integrity of the input data and to display the data. The database

was designed using powerdesigner and the database was fully normalized.

Queries and stored procedures were written in SQL and PL/SQL to provide and

capture information from the user in the most effective and efficient manner.

h Designed, developed and deployed a client/server application for a major

healthcare provider. User requirements were accurately determined and the

application designed on those bases. The application was designed using

powerbuilder as the front-end tool and Oracle as the database repository. The

application captured user input for Left Heart Catherizations performed.