Oracle PL/SQL developer Resume

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,
Bachelor of Engineering, Electronics and Communication

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

Confidential,Oracle Database 11g ::SQL Fundamental 1
Confidential,Oracle Database 11g::: Program with PL/SQL(pursuing)

Key Skills

Operating System:

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

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:

Confidential,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

Confidential,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 SQLdatabase.
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

Confidential,Gujarat , IndiaJune 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 usingSQL,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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship