Project Manager Sql

Riteshkumar shah

**** ********* ***, *** **, Bridgeport, CT-06605

**********@*****.*** . 631-***-****

Objective Statement

Seeking for a challenging and interesting role of SQL and Pl/SQL programmer

in a company where my experience and knowledge can be utilize and enhance.

summary

. Nearly 2 years of experience in the Oracle PL/SQL Developer/Tester in

Analysis, Design, Data Modeling (Logical and Physical), and

Implementation of Business Applications using the Oracle Relational

Database Management System(RDBMS)

. Strong RDBMS concepts including expertise in pl/SQL queries like DML,

DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers,

and Cursors etc.

. Experienced in SQL Optimization, performance monitoring and tuning.

. Experienced in programming as an Oracle PL/SQL Developer in Analysis,

Design, Data Modeling(logical and physical), and Implementation of

Business Applications using the Oracle Relation Database Management

System(RDBMS)

. Expertise in data modeling, Normalization, database design, data

loading, data retrieval, modification, and archival techniques

. Experience in Microsoft Sql Server 2005, Microsoft Excel, Microsoft

Access. MySql.

. Experience in Shell Scripting.

. Experience in Oracle Forms And Reports Developer

. Strong, clear communication and interpersonal skills

Education

Masters of Science, Electrical Engineering May 2010

University of Bridgeport, Bridgeport, CT

Bachelor of Engineering, Electronics and Communication July 2007

North Maharashtra University, Maharashtra, India.

Related Coursework

Introduction to database system (part1 and part2), Introduction to SQL and

PL/SQL, Advance Pl/SQL, Data Communication and Networking(Part 1&2),

Microprocessor & Interfaces, Advance Microprocessor, E-commerce Data

Encryption & Security, Wireless Communication, Wireless Sensor Network,

Analog VLSI, Digital Signal Processing, Fiber Optic Communication, Computer

Network (Part1&2), VLSI Testing, VLSI Digital System Design, Low power

VLSI, RF CMOS VLSI, Analog VLSI.

professional certification

Exam 1Z0-051 Oracle Database 11g :: SQL Fundamental 1

Exam 1z0-144 Oracle Database 11g ::: Program with PL/SQL(pursuing)

Key Skills

Operating Windows XP/NT/2000,98/95, DOS, Unix, Linux

System:

DBMS SQL, PL/SQL, Triggers, Stored Procedures and

functions, Standard Packages, SQL*Plus, SQL*Loader,

Import/Export, Performance tuning.

Development Tools Oracle Forms, Oracle Reports,Crystal Reports

Tools Used Oracle 8i/9i/10g, SQL Developer, Toad, Designer 6i,

SQL Navigator,ERWIN, Excel, Access, Sql Server

2005

Scripting Unix Scripting ( sh, csh, ksh and bash)

professional experience

MobileComm Professional Inc, Houston, Texas

Aug 2010 to Jan 2011

Position : Oracle PL/SQL developer

Responsibilities:

. Responsible for the designing the advance SQL queries, procedure,

cursor, triggers, scripts.

. Collaborated with the application developers in data modeling and E-R

design of the systems.

. Also created, modified, maintained and optimized SQL database.

. Maintained the documents and create reports for the business analysts

and end-users.

. Responsible for the management of the database performance, backup,

replication, capacity and security.

. Developed SQL*loader scripts to load data in the custom tables

. Created Materialized views & normal views where business requirements

needed

. Communicated issues and progress to project manager

. Involved in solving day-to-day problems, giving support to the users

. Developed scripts for checking oracle errors in alert log and trace

files

. Also created forms and reports for web and paper based using oracle

forms and reports developer

Environment::

Oracle 10g, SQL, PL/SQL, Oracle forms and Reports, TOAD, SQL*Loader,

Unix Shell Scripting, MS Windows XP, Microsoft Access, Microsoft Excel

International System Technology, Bridgeport, CT

Jan 2010 to Jun 2010

Position : SQL developer Intern

Responsibilities:

. Responsible for the designing the advance SQL queries, procedure, cursor,

triggers, scripts.

. Collaborated with the application developers in data modeling and E-R

design of the systems.

. Also created, modified, maintained and optimized SQL database.

. Maintained the documents and create reports for the business analysts and

end-users.

. Responsible for the management of the database performance, backup,

replication, capacity and security.

Environment::

Oracle 10g, SQL, PL/SQL, Jasper Reports, TOAD, SQL*Loader, Unix Shell

Scripting, MS Windows XP, Microsoft Access, Microsoft Excel

India Nic InfoTech LTD, Gujarat,

India June

2007 to Dec 2007

Position : Oracle Developer

Responsibilities:

. Involved in the complete life cycle of the product from requirements

gathering to end of system testing.

. Worked on developing a financial application system to handle all the

bank transactions using SQL, PL/SQL, Developer 2000 (Forms4.5 and

Reports2.5) on Windows environment.

. Worked as a librarian to maintain the system application design using

Designer2000 tools.

. Used SQL*Loader to load the database from flat files.

. Created new Tables, Indexes, and Sequences where needed.

. Created database triggers for data security & Consistency.

Environment::

Oracle 8i, SQL, SQL*Plus, PL/SQL, SQL*Loader, Microsoft Access, Microsoft

Excel, Developer2000 (Forms 4.5 and Reports2.5) and Unix Shell

scripting.

Contact this candidate