Database Analyst RESUME NJ - Hire IT People

SUMMARY:

Over 6 years of experience in Information Technology field with extensive experience in Application development, Marketing, software training and implementation.
Expertise in area of Oracle version 10g,9i, 8i, 8.0.5, 7.x and SQL Server 7.0/2000 on DEVELOPMENT.
Thorough Knowledge of Programming thru Oracle Backend Procedures, Triggers, Constraints and 9ids.
Thorough knowledge in coding complex SQL scripts.
Performing Bulk Inserts in database using SQL Loader.
Experienced in performance tuning of SQL scripts.
Conceptual Knowledge of Datawarehouse.
Developing and deploying Applications built in forms, reports & Graphics in Client Server and three tier architecture.
Possesses excellent communication skills, problem solving skills on any business issue and a good team player.

Technical Skills

RDBMS

Oracle 9i/8i/8.0, SQL Server 2000/7.0, IBM DB2

Front End

9i Developer suite, Developer 6i (Forms, Reports & Graphics), Visual Basic

Oracle products

Oracle 9ias, Oracle WebDB, Oracle Portal & Oracle Migration Workbench, SQL*Loader, Tkprof, IMP/EXP

Languages

SQL, PL/SQL, Java, HTML, Unix Shell Scripting

O / S

Linux, Windows 2000/XP, MS-DOS

Microsoft products

MS Office 2000, Visual Basic.

Other Software

Sql Navigator, Toad, PVCS, Rational Clear Case , Sql Server Enterprise manager.

Certifications

Oracle Certified Associate 9i

Introduction to SQL for oracle 9i Pl/sql Programming in Oracle 9i

Work Experience

Nov 2004 – Till date Confidential,NJ Database Analyst

Environment : Windows 2000
RDBMS : Oracle 9i/8i

Role

Created stored procedure to enable functionality to create database users, assign required privileges and assign object privileges from the Front End.
Migrating Client data from Excel (CSV) files to Production Oracle 9i Databases.
Used TKPROF, Explain plan and Toad to tune SQL and optimize queries
Involved in the development of stored procedures and Triggers by using PL/SQL at the database level to enforce business rules and integrate with Front End.
Created database by using 9i DBCA on Windows 200 Platform, Involved in logical and physical design. Created users, schema, tables, views, indexes & database triggers
Developed shell script to mail the output log file to the users who scheduled the job.
Performed a variety of tasks including SQL and PL/SQL programming, writing shell scripts for performing monthly data extractions.
Developed a generalized, table-driven, SQL script generator for producing data extraction scripts.

Aug 03 – Feb 04 Confidential,Ca Oracle Developer

Environment: Sun Solaris 2.7, Windows NT/2000, PVCS
RDBMS : Oracle 8i/8.0/Personal Oracle 7

Phoenix America
A member of Phoenix America group involved in the project called as MARS (Marketing analysis and reporting sales). Using Oracle 8.1.7/8.0 as backend on Sun Solaris 2.7 server and Personal Oracle 7.0 on the client. The Mars application is setup with the Replication.
Role

Importing large test data in the database using SQL*LOADER utility.
Developed procedures, Triggers and back end programs which are accessed from Front End MARS application.

Using SQL loader to upload the data into temporary tables.

Performing validation on the developed screens.
Development of database objects to support the user requirements i.e. the new forms and reports.

Academic Qualification:

Bachelor of Engineering from Bangalore University

Ref: Furnished upon request.

We provide IT Staff Augmentation Services!

Database Analyst Resume

NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship