Oracle PLSQL Resume

Objective Statement

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

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:

Client: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

Client: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:

Client: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.