Professional Summary:

• 6 years of IT experience in Analysis, Design, Development and implementation of Business Applications using the Oracle Relational Database Management System.
• Strong skills in Oracle including SQL, PL/SQL Packages, Functions, Stored Procedures and Database Triggers and Reports.
• Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
• Good Debugging skills and good at using Exceptions and Error Handling.
• Worked with Database tools Toad, SQL Navigator, SQL Developer and SQL Loader for Data Design, Data Tracking and PL/SQL Coding.
• Experience in Performance Tuning and optimization using SQL Trace, Explain Plan, TKPROF
• Experience in Data Migration and Data Conversion.
• Knowledge of all phases of ETL Extraction, Transformation, and Loading and having working knowledge with Data stage.
• Complete knowledge of data ware house concepts like dimension and fact tables, snowflake and star schemas and SCD slowly changing dimensions .
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Sound working knowledge in Shell Scripting.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Experience in health care and financial domains.
• Excellent team player and can work on both development and maintenance phases of the project.
• Efficient team player with excellent communication skills and good interaction with users.

Technical skills:

Professional Experience:

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Created new tables, views, queries for new enhancement in the application using TOAD.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL Loader.
• Used Bulk Collect feature to improve performance and computed statistics to improve response time for queries.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Designed and developed the scripts to create table, views, indexes and sequence.
• Provided solutions for partition adjustment tasks, Includes creating new partitions and moving data between different set of partitions.
• Created technical documentation for all the scripts written for future reference.
• Involved in Performance tuning, Included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats and also involved in designing and developing forms and reports.
• Written Arrays to reduce the programming time and improve performance.
• Created tables with partition by range, partition by date and partition by value for reporting and analysis purpose in data warehouse environment.
• Created shell scripts to maintain the log files of the target tables, to know whether the data inserting into the target tables is according to the JURIS standards and weather the data is meeting client's requirements.

Environment: Oracle10g/11g, TOAD, SQL Loader, SQL Developer, PL/SQL, SQL Plus, Shell Scripts, UNIX, Windows 7.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Design and development of database schemas, object relation mapping, oracle forms and reports, database performance tuning.
• Designed and implemented the data access layer using Oracle Stored procedures, functions and packages.
• Customized Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the report. Writing after parameters triggers for the Validation of the data.
• Involved in creating customized reports to get the customer details, account details, payment history of the customer.
• Developed Test Plans, assisted in Documenting the modifications and new reports, procedures and packages developed.
• Extensively utilized the Application Object Library to register Shell Scripts, PL/SQL procedures and Reports as Concurrent Programs.
• Worked closely with QA and UAT teams in testing the developed program units and reports and successfully moving them to Production.

Environment: SQL, PL/SQL, Oracle 10g, Forms Reports6i, Oracle applications 11i MS-Office, Linux, IE 5.5, Win NT/XP/2000.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL Loader.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Worked on Data warehouse data base like data mart and schemas of the environment.
• Used the Explain Plan for tuning the queries and also used the TKPROF for tuning the procedures by setting up the trace and generating the trace files.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Developed Scripts for Oracle tables, views and sequences.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Applied optimizer hints to tune the queries for faster performances.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• 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: Oracle10g, TOAD, SQL Loader, SQL Developer, PL/SQL, SQL Plus, Shell Scripts,

UNIX, Windows 7.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Applying business logic and creating data forecast models for business users.
• Customer Value score development for Green Mountain NRG subsidiary .
• Responsible for production support.
• Developed various procedures, functions and packages to implement the new business using Oracle PL SQL.
• Responsible for code development using PL/SQL.
• Responsible for Data migration using SQL loader and PL/SQL code.
• Responsible in code review and design doc preparation.
• Preparation of Test Plans.
• Developed mapping's , workflows and scheduling Job in INFORMATICA.

Environment: Oracle 11.1.0.7.0, PL/SQL Developer 7.1.4.1390, UNIX.

Confidential

Role: PL/SQL DEVELOPER

Responsibilities

• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for managing production, development test databases and applications.
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Creation of Users and Granting them privileges and roles.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

Environment: Oracle 8i,9i, SQL Server 2000, UNIX, Windows, SQL PLUS, Quest software tools.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Used Dynamic SQL for DDL commands in PL/SQL.
• Wrote Cursors for acquiring information to be used in calculations written in stored procedures.
• Creating and managing schema objects like tables, indexes, views, synonyms and clusters.
• Debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Actively involved in detail design, development and testing phases of SDLC and STLC.
• Used various kinds of control structures including case, decode, if-then-else, for loops, while loops while developing procedures.
• Writing Unit Test Cases and Test Scripts for Manual Testing.
• Interacted with user to identify the user requirement from various groups/level of user and defined Entity relations ship diagram.

Environment: Oracle 8i, PL/SQL, UNIX, Toad 8.0, Windows NT 4.0, Oracle D2K Form 5.0