PROFESSIONAL SUMMARY

• 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Applications such as OLTP, OLAP using the Oracle Relational Database Management System RDBMS .
• Strong understanding of logical and physical database designs and also dimensional modeling schemas like Star and Snowflake schema for OLAP systems.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Strong understanding of relational database software development and integration techniques, tools, and methodologies.
• Hands on experience on various technologies like Oracle 8i/9i, 10g/11g, PL/SQL, C/C and HTML.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Triggers and Stored Procedures.
• Excellent understanding of PL/SQL modules such as collections, cursors Implicit, Explicit, Ref , packages, Materialized views.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL developer, SQL Navigator.
• Strong knowledge of Software Development Cycle SDLC and implemented various models like Agile and V model
• Working experience in Dynamic SQL and Exception handling.
• Used Range Partitioning to partition large tables for improve performance and easy access the data.
• Experienced in optimization of SQL Statements using the Oracle 11g, SQL Trace and Explain Plan.
• Experience in BULK COLLECT to fetch large volumes of data from table.
• Extensive used Oracle packages such as UTL FILE, DBMS UTILITY, DBMS SCHEDULER, DBMS SQL and DBMS PARALLEL EXECUTE etc.
• Experience of working in UNIX and windows environment.
• Work with defect tracking tools such as Quality center, Clear Quest.
• Involved in Performance Tuning using Cost-Based Optimization CBO .
• Quick Learner, self-motivated, ability to work independently, Problem Solving skills, Multi-Tasking abilities with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILL-SET

Professional experience

Confidential

Oracle PL/SQL developer

Roles and Responsibilities:

• Responsible for writing a design documents for time and attendance management system.
• Played a key role in problem solving, project status updates and team meeting.
• Involved in developing ER diagrams, physical and logical Data Models using Microsoft Visio.
• Enforced database integrity using primary keys and foreign keys.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Involved in performance tuning of the Tables by creating Partitioned Index.
• Developed Triggers and Procedures for Oracle Forms and Reports.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block.
• Implement complex SQLs using joins, sub queries and correlated sub queries.
• Implement complex queries by separating it into Stored Procedure, and functions.
• Involved in programming database triggers for automatically updating tables and views.
• Involved in tuning the existing packages for better performance and providing on-going support existing applications and troubleshooting serious errors when occurred.
• Involved in the writing an alert on using trigger to implement Threshold alerts on late attendance logs.
• Played a key role in setting up infrastructure and test data analysis.
• Support for the development, test and the production databases.
• Coordinated with DBA in improvement of Performance of Database.
• Fine Tuned the SQLs using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
• Extensively used Temporary tables in the implementation for improving the performance of the report generation.

Environment:Oracle 10g, OLAP/OLTP, Toad, Windows XP, SQL Loader, SQL Developer, Agile.

Confidential

Oracle Developer

Roles and Responsibilities:

• Worked closely with the external teams and systems to produce high-quality deliverables.
• Responsible for working on oraclequery on Data warehouse application for Data Analysis purpose.
• Review of code changes, test procedure, test plans and other deliverables.
• Enforced database integrity using primary keys and foreign keys.
• Used TYPE and ROWTYPE for anchoring the variables to the database data types.
• Work with the advanced features of PL/SQL like collections, nested table, ref cursors, materialized views and dynamic SQL.
• Engaged in writing PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Work with BULK COLLECT to fetch large volumes of data from table.
• Used SQL Loader to perform bulk data loads into database tables from external data files.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file, remove the junk characters from the file before loading them into the base tables.
• Implemented indexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Improved the performance of the application by rewriting the SQL queries.
• 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 and packages using Oracle tools like Toad, PL/SQL Developer and SQL Plus.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment:Oracle 11g SQL, PL/SQL, UNIX, SQL Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential

Oracle Developer

Roles and Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Involved in all phases of SDLC as active participant.
• Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Used various Indexing and partition techniques to improve the query performance
• Developed PL/SQL triggers and mastertables for automatic creation of primary keys.
• Improved the performance of the application by rewriting the SQL queries.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Used Dynamic SQL to implement DDL statements in PL/SQL programs
• Created scripts to create new tables, views and queries for new enhancement in the application using TOAD.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Environment:ORACLE 11g, SQL Plus, PL/SQL, SQL Loader, TOAD, UNIX.

Confidential

Oracle Developer

Roles and Responsibilities:

• Involved in creation of Conceptual Modeling covering all the business requirements in to logical modeling and physical modeling and coordinated in working with the Common Data Model for various Teams which uses the same Source.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Data loaded from legacy systems using PL/SQL and SQL Loader.
• Involved in fine tuning SQL query, SQL Optimizing using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Implement indexes on 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.
• Work directly with managers and testing team in an Agile.
• Created Records, Tables, Objects, Collections Nested Tables and Arrays , and Error Handling
• Documented business rules for writing triggers and constraints, functional and technical design, test cases and user guides
• Wrote complex SQL queries and generated reports using Reports 6i
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Experienced in optimization of SQL Statements using the Oracle 11g
• Used database objects to create Reports according to requirements using Crystal Reports, Familiar with the features enhancements in Oracle 11g.

Environment:Oracle 9i/10g, SQL, PL/SQL, Forms 9i, Reports 9i, SQL Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential

Oracle Developer

Roles and Responsibilities:

• Involved in logical modeling and physical modeling of application.
• Extensively involved in writing procedures, functions, triggers and packages using PLSQL
• Worked on Logical, Physical and conceptual design of Database Data Modeling, and Data Architecture with the use of Erwin and MS VISIO as a modeling tool
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Developed complex queries to retrieve 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.
• Created indexes for faster access of data.
• Created and Modified existing functions and procedures based on business requirements.
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Created Records, Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Session management to provide security to web access.
• Involved in Unit Testing for the application.

Environment:ORACLE 8I, PL/SQL, SQL PLUS, SQL Developer, Scripts, UNIX, Windows XP.

Confidential

Oracle Developer

Roles and Responsibilities:

• Involved in software requirement specification and technical design.
• Performed Normalization and Logical Database Design.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created of database links and accessing the data through SQL statements.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Responsible to tune ETLmappings to optimize load and query Performance.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views,Inline Views normal views where business requirements needed.
• Created database, table spaces, user schemas, and assisted in database administration.
• Developed Stored Procedures,Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Performed SQL and PL/SQL Tuning and application tuning using various tools like EXPLAIN PLAN, SQL TRACE, AUTOTRACE.
• Worked on Database tuning and performance monitoring.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Partitioned large Tables using range partition technique.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries andreports.
• Processed data Using both implicit cursors and explicit cursors and their attributes.
• Implemented indexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.

Environment:ORACLE 9I, SOLARIS, REPORTS 6I, FORMS 6I, TOAD, SQL LOADER, PL/SQL, SQL PLUS.