SUMMARY

• Eight 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
• Expert in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD,SQL*LOADER
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write & Transportable table spaces
• Strong experience in Data warehouse concepts, ETL, Informatica
• Good knowledge on logical and physical Data Modeling using normalizing Techniques
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based)
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• 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
• Loaded Data into Oracle Tables using SQL Loader
• Used Insert All, Insert First for multi table inserts.
• Partitioned large Tables using range partition technique
• 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
• Expertise in Dynamic SQL, Collections and Exception handling
• Experience in SQL performance tuning using Cost-Based Optimization (CBO)
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, Pipelined tabled functions for faster execution
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan, HINTS
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with the Reporting tools such as Cognos
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab
• 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, Sybase, DB2

Programming Languages: SQL, PL/SQL, TSQL, C, Java, VB.NET, and ASP.NET

Tools: and Utilities SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad, ColdFusion, Crystal Report, Informatica, SVN subversion, ODI

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

PROFESSIONAL EXPERIENCE

Confidential, Saint Petersburg, FL

Sr PL/SQL developer

Responsibilities:

• Took a responsibility of Software Development of Serve Web Apps and Mobile Apps.
• Create new high volume database designs for new modules.
• Creating and maintaining tables, views, procedures, functions, and packages and performing DML operations using insert, update and delete statements
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Created automated scripts to perform actions like Creating new table; adding new column; adding an index etc.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Identified and fixed application performance issues by providing proven scientific solutions.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Created complex SQL queries using Editioned views, sub queries, correlated sub queries.
• Extensively used cursors, ref cursors and exceptions in developing packages, procedures and functions.
• Debugging the code and created error log package to record all the bad records along with error codes and error message.
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Created new automated test programs which are used to perform health-check of an application code.
• Took a responsibility of identifying defects and providing high quality solutions.
• Took a special care in implementation of application security programs.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, MS-TFS, Project Web App

Confidential, Houston, TX

Sr.PL/SQL developer

Responsibilities:

• Creating and maintaining tables, views, procedures, functions, and packages and performing DML operations using insert, update and delete statements
• Extensively Used Autonomous transaction and triggers to audit the DML operations on tables.
• Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements.
• Handled bulk operation using different types of Collections (Associated arrays, Nested tables, Varrays).
• Created scripts to create database objects like Tables, Indexes, Sequences etc.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Avoided mutating table errors using the new functionality in Oracle 11g i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Coordinated with front end team working on Java and web services and provided them the required procedures and packages and necessary insight into the data.
• Created complex SQL queries using inline views, sub queries, correlated sub queries.
• Extensively used cursors, ref cursors and exceptions in developing packages, procedures and functions.
• Debugging the code and created error log package to record all the bad records along with error codes and error message.
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Involved in writing Test cases and performing data validation and process testing for application moving into production.

Environment: Oracle 11g, SQL, PL/SQL, SQL Developer 3.0.03, Beeline, SVN

Confidential, Reston, VA

Sr.PL/SQL developer

Responsibilities:

• Developed complex PL/SQL programs and modified the existing PL/SQL units.
• Created dynamic sql queries using Execute Immediate statements.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools/utilities like Explain plan, DBMS Profiler, Auto*Trace, SQL Trace, TKPROF etc.
• Extensively used hints to direct the optimizer to choose an optimum query execution plan.
• Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Used various control structures like Case, Decode, IF-Then-Else, For Loop, While Loops while developing procedures.
• Extensively used SQL Joins (Inner Join, Outer Join, and Anti Join).
• Created PL/SQL scripts to create and drop objects including Tables, Views, Primary Keys, Indexes, and Constraints.
• Developed complex SQL queries to retrieve the data.
• Extensively worked using autonomous transaction and triggers to keep the track of DML operations.
• Processed data using both Implicit cursor and Explicit cursor.
• Used Records and Collections extensively in Packages in order to improve the package performance.
• Used advanced features like Forall, Bulk Collect.
• Extensively Worked with Table Partitioning and used various partitioning strategies like Range Partitioning, Hash Partitioning, List Partitioning, Range-Hash Partitioning, Range-List Partitioning etc .
• Created Scripts for maintaining the partitions.
• Used SQL loader for importing the flat files which consists of several records of clients’ information into the different tables in the database.
• Performed DBA activities such as creation of roles, granting privileges to the role, creating database link to connect to users under different instance.
• Used dynamic SQL to implement DDL statements in PL/SQL programs.
• Performed Unit Testing on the developed code to ensure it is bug free.

Environment: Oracle 10g/11g, SQL * Plus, PL/SQL Developer, SQL*Loader, Shell Scripts, UNIX, Windows XP, etc.

Confidential, Cranston, RI

PL/SQL developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables
• Involved in the continuous enhancements and fixing of production problems
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Involved in data loading using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between sql and pl/sql engines
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools like Toad,PL/SQL Developer and sql* plus
• Partitioned the fact tables and materialized views to enhance the performance
• Extensively used bulk collection in PL/SQL objects for improving the performing
• Created records, tables, collections (nested tables and varrays) for improving Query performance by reducing context switching
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Extensively used the advanced features of PL/SQL, like Records, Tables, Object types and Dynamic SQL
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, NY

PL/SQL developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application
• Designed Technical design document MD.070 for the business requirements
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages
• Developed ER Diagrams, Data flow diagrams based on the requirement
• Developed SQL scripts to create database objects like tables, views and sequences
• Used SQL*Loader to load bulk data from various flat files and legacy systems
• Developed SQL and PL/ SQL scripts for transfer of data between databases
• Developed complex SQL queries for reports
• Developed complex triggers in reports before/after for validation of user input
• Performed unit testing and supported integration testing and end user testing
• Extensively worked on production issues with effective defect management
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILERetc
• Extensively worked with table partitioning and table space creation etc
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, PERL Shell script, TOAD, Informatica 8.6.0

Confidential, Summit, NJ

Pl/SQL Developer

Responsibilities:

• Creating and maintaining tables, views, procedures, functions, and packages and performing DML operations using insert, update and delete statements
• Worked with Designers and developers to translate data requirements into the physical schema definitions for oracle
• Developed many complex PL/SQL programs and modified the existing PL/SQL program units
• Performed constant monitoring and performance tuning of Oracle database, checking the most expensive queries
• Worked with external tables, loaded data from flat files into Oracle tables using SQL*Loader
• Used composite datatypes (Varrays, PL/SQL tables and Nested tables) to improve functionality with in PL/SQL
• Developed scripts using UNIX commands to perform complex file processing
• Worked with the web developing team in coding HTML pages using HTML tags and used CSS (cascading style sheets) to improve look-feel of the pages
• Extensively worked using autonomous transaction and triggers to keep the track of DML operations (insertion, updating and deletion)
• Used exceptions to process errors
• Extensively used the oracle exception handling techniques for implementing all types of exceptions
• Tuned the SQL queries and complex Procedures to improve performance
• Used bulk collect and for all to reduce context switching between SQL and PL/SQL engine and vice versa
• Processed data Using both implicit cursors and explicit cursors and their attributes
• Worked extensively on complex views and instead of triggers
• Used Dynamic SQL to implement DDL statements in PL/SQL programs
• Performed unit test on the developed code to ensure that its bug free

Environment: Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Plus 3.1, SQL*Loader, HP-UX, UNIX

Confidential, NJ

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
• Worked in Data modeling, Data mapping and Data flow
• Involved in Requirement gathering and writing Functional and Technical documents
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Experience in writing procedures, functions and packages for new requirements
• Usedadvanced PL/SQLconcepts likeBulk collect, PL/SQL tablesand Dynamic SQL for DML operations for better performance
• Developed PL/SQL and web PL/SQL stored procedures
• Implemented Advanced PL/SQL Concepts for better performance of PL/SQL Applications
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc
• Extensively used EXPLAIN PLAN utility to leverage SQL queries
• Performance tuning of Oracle Databases and User applications
• Used Relational Clear Case for source and version control
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager
• Involved in Unit Testing for the application
• Involved in solving day-to-day problems, giving support to the users
• Provided 24/7 on call production support

Environment: Oracle 10g, TOAD, PL/SQL, Explain Plan, TKProf, Informatica 8.6.0, UNIX, HTML

Confidential

PL/SQL Developer

Responsibilities:

• Physical designing and development of Database
• Worked on PL/SQL in creating complex stored procedures and functions
• Created various database objects like tables, indexes and views
• Used Collections like variable arrays, nested tables extensively
• Writing triggers, stored procedures and functions required to send the Credit Approval Details
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Used composite data types like %ROWTYPE and %TYPE
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Taking table level backups using Shell scripts
• Wrote complex SQL queries and generated reports using Reports 6i
• Resolved several hardcore business rules and issues at the client site

Environment: Windows XP, IBM AIX, Oracle 8i, SQL, PL/SQL, SQL*Plus, TOAD, SQL*Loader, Oracle Forms & Reports 6i.