SUMMARY

• Around 8 years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment. Highly focused to strive for Excellence in the field of software development - with dedication, proactive approach, positive attitude and passion and to utilize my knowledge. and skills in the best possible way for the fulfillment of organizational goals
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL, Toad, SQL*Plus, PL/SQL Developer, UNIX and working knowledge of UNIX editors.
• Proactively interacted with Business Analytical, technical analysts, Developers, Testers and External clients.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Strong interpersonal skills with good Team management and Team development experience.
• Experience in writing complex SQL Queries, created materialized views.
• Ability to work as an individual and as well as a team member.
• Sharp to learn new concepts, adapts to new environments.
• Dedication in planning and executing a given job to perfection.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Created Instead of triggers for updating join views with DML operations.
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Interacted with the business users, collected the requirements analyzed the requirements, designed and recommend solutions.
• Possess excellent oral / written communication and interpersonal skills.
• Good knowledge on Oracle Forms and Reports.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS Access, MS SQL Server, SQL, Data Stage

Programming Languages: SQL, PL/SQL,UNIX Shell Scripting, HTML, CSS, C, C++, C#, VB.NET

Oracle Tools: Oracle Forms 10g, 9i, Oracle Reports 10g, 9i.

Tools: and Utilities: SQL*Plus, Toad, SQL*Loader.

Operating Systems: UNIX, Windows XP/Windows 7/8, Windows vista, Linux.

Office Tools: MS Word, Excel, PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, WA

Oracle Pl/SQL developer

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Oracle 10g, SQL* Plus, SQL* Loader, Toad, MS SQL Server, Windows XP, UNIX, Shell Scripts.

Confidential, Frisco, Texas

Oracle Pl/SQL Developer

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref &Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.

Environment: Oracle 10g/11g, SQL*Loader, SQL* Plus, MS Access, MS Excel, TOAD, XP, Linux.

Confidential

Oracle Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testing and Implementation.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Developed and modified custom triggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Developed database objects including tables, Indexes, sequences, packages and procedures.
• WroteSQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Created DB links for connecting to remote databases accessing.
• Developed Triggers in the database to ensure restriction to data for change.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Made timely changes and fixes to all database modules on problems reported by database administrator.

Environment: Oracle Database 11g, PL/SQL Developer, SQL*Plus, TOAD, Power Builder, Windows, UNIX.

Confidential, Santa Clara, CA

PL/SQL Developer

Responsibilities:

• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Designed and Developed pricelist import program for loading continuous price updates.
• Documented the development process using standard AIM methodology
• Worked with SQL*LOADER for data loading.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning.
• Created DDL scripts, and database objects like Tables, Views Indexes, Synonyms and Sequences.
• Created Oracle Alerts to inform internal users of certain events and to notify customers of their account status.

Environment: PL/SQL, SQL*Plus, Oracle 9i, SQL*Loader, TOAD, Windows

Confidential

PL/SQL Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 10G, Pl/SQL, UNIX shell scripting.

Confidential

PL/SQL Developer

Responsibilities:

• Developing the Oracle reports based on the project requirements.
• Conducting the unit testing and performance testing on the reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and Indexes.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle reports.
• Wrote SQL scripts to perform Back End testing of the Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended Design meetings, code review and test review meetings.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Extensive experience in loading high volume data and Performance tuning.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes.
• Expertise in handling errors using Exceptions.
• Attended Design meetings, code review and test review meetings.
• Attended meetings and review to discuss current issues and processes to tackle issues.
• Worked as a Developer, did requirement analysis, design, developed (Oracle - PL/SQL), tested and implemented and provided infant care on production.
• Gathered the requirement from the client and translated the business design into technical design.
• Involved in creating Procedures, Functions, Packages, and Triggers. Creating reports using Reports.
• Extensively involved in writing SQL queries (sub queries and join conditions) for generating complex reports.
• Involved in the development of UNIX shell scripts.
• Performed tuning of the SQL queries using Explain Plan.

Environment: Oracle 9i, SQL & PL/SQL Development, Oracle Forms and Reports, HTML & CSS, Windows 98/2000/XP.