SUMMARY

• Around Seven years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
• Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Tables, Views, Sequences, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Varray) in complex backend packages.
• Experience in performance tuning and Query optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Experienced in UNIX shell Scripting.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS access

Programming Languages: C, C++, HTML, SQL, PL/SQL

Tools: and Utilities SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad

Operating Systems: UNIX, Windows (98/2000/XP/VISTA), DOS

PROFESSIONAL EXPERIENCE

Confidential, FL

PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Loaded data into oracle database from flat files using SQL*Loader.
• Prepared program specification and development of PL/SQL packages, procedures and functions as required by the business users.
• Created Materialized View for extracting the data from the remote databases.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Used Bulk Collection types such as bulk collect and for all to reduce context switching between SQL and PL/SQL engine and vice versa.
• Used theMergestatement to select rows from one or more sources for update and insertion into one or more tables.
• Effectively made use of Analytical functions while developing the code.
• Created various Function Based Indexes to significantly improve performance.
• Implemented the test plans for the integration testing.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Optimized critical queries to eliminate Full Table Scans reduce Disk I/O and Sorts.
• Performed unit test on the developed code to ensure that its bug free.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Played key role in prod support for on call issues for the developed participant reports.

Environment: Oracle 11g, PL/SQL, TOAD, SQL loader, Oxygen XML Editor.

Confidential, Rye, New York

PL/SQL Developer

Responsibilities:

• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes.
• Preparation of wrapper scripts for all the database processes and data quality checks using Unix Shell scripting.
• Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
• Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and manage the same in issue log.

Environment: Oracle 11g, PL/SQL, TOAD 9.1/10.5, VI editor, MKS, FileZilla FTP tool, SQL loader, SQL Server 2008

Confidential, Madison, WI

Oracle PL/SQL Developer

Responsibilities:

• Discussed and analyzed business functionality with the client and the developers.
• Involved in writing Functional and Technical documents.
• Generated SQL scripts for creating Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Created PL/SQL program units to implement DML, DDL statements using Dynamic SQL.
• Wrote Database triggers for audit and to implement complex business logic.
• Created Bitmap Indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Wrote control files and loaded the data into the Oracle database with SQL*Loader.
• Used PL/SQL Developer Tool to do the backend development.
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting the data from remote database.
• Used PL/SQL Collections (Nested Tables and Varray) in complex backend packages.
• Coded Unix shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.

Environment: Oracle 10g, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD

Confidential, Fort Worth, TX

Oracle Developer

Responsibilities:

• Interacted with the end users for gathering of requirements and analyzed them.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Created the Object Relational Database Tables with all the necessary Constraints.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Used All Control Structures like IF, CASE, For, While Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created and managed primary data base objects such as Tables, Views, Sequences, and Synonyms.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Designed Database Triggers for audit and validation purpose.
• Implemented multiple-table links requiring Complex Join statements, including outer-joins and self-joins.
• Processed data using both implicit cursors and explicit cursors and their attributes.
• Loaded data from flat files to temporary tables in Oracle database using SQL*Loader, Collections for better performance.
• Worked in Maintenance of the system and debugging of the code whenever necessary.
• Used Exception Handling for validation of input and displaying the error messages in the application.
• Used Explain plan, TKPROF to gather the statistics along with analyze command for performance tuning.
• Tested, Installed, Documented and provided On Call Support for the Applications.

Environment: PL/SQL, SQL, SQL*Plus, SQL DEVELOPER, SQL*Loader, Oracle 10g, Windows XP/2000.

Confidential

PL/SQL Developer

Responsibilities:

• Interacted with the end users for gathering of requirements and analyzed them.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed Model Diagrams and Input/Output structures for the data entry screens.
• Used efficient Joins, Indexes and Correlated queries for Query optimization.
• Developed Control files, SQL*Loader scripts, migration and backup of Oracle data.
• Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions.
• Implemented Record Insert, Record update and also used Insert All to load the data into multiple tables.
• Used Dynamic SQL to implement DDL statements in PL/SQL programs.
• Used Collections like varrays, nested tables extensively.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Created the Shell scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Involved in programming, debugging, unit and system integration testing of modules.
• Used SQL trace facility and TKPROF along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.

Environment: Oracle9i, WindowsXP/2000, PL/SQL, SQL*PLUS, UNIX, SQL*Loader, UML.