SUMMARY
Over 6+ years of experience in Application development and Production support using Oracle SQL, PL/SQL, FORMS and REPORTS.

• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i, FORMS 10g/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Supported Advance PL/SQL using Cursor, REF Cursor.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Carried out testing in test database for upgrading/migrating from Oracle 9i to Oracle 10g.
• Experience in developing logical and physical database design, data modeling using Erwin & Informatica (Power Center 6.1).
• Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Experience with DBA activities like creating tablespace, granting and revoking privileges on database objects.
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, Hints in Oracle 9i.
• Experience in Installing Software’s and Configuring Databases.
• Experience in UNIX Shell Scripting for batch processing.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually.

SKILLS:

RDBMS Oracle 11g/10g/9i
Oracle Tools SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer2000 (REPORTS 10g/6i, FORMS 10g/6i), SQL*Plus, Discoverer
ETL Tools Informatica Power Center 8.6.X/6.1, Data stage
Data Modeling Tools Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003
Data Analysis Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.
Programming Lang Unix Shell Scripting, Perl Scripting, XML, C, C++,Java, HTML,XML
Environment Sun Solaris 2.6/2.7/2.8/8.0, Red Hat Linux ,Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

EXPERIENCE

Confidential, FL. MAY ‘11- OCT’12
Sr. Oracle PL/SQL Developer

Confidential, is the largest publicly held personal lines property and casualty insurer in America. All State is traded company which is listed on the New York Stock Exchange Under the trading symbol ALL. It was number 93 on the Fortune 500 list of largest companies in America. The company is reinventing protection and retirement to help households insure a better plan for future. Allstate products include auto, home, life and retirement insurances for consumer’s access.

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database.
• Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated jobs using UNIX Shell scripts to run all the sql files in a directory by invoking SQL *Plus.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Maintaining different versions for DDL extract of schemas and applications files (version control) using Tortoise SVN.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Testing and debugging of the applications.
• Implementation and end user training.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients
• Environment: Oracle 11g, SQL Developer, SQL Navigator, Tortoise SVN, HP Project and Portfolio Management, Windows XP, UNIX, Secure Shell Client.

Confidential, Austin, TXJune’10-July’11
Sr. Oracle PL/SQL Developer

Confidential,is a privately held software development company that provides digital technology solutions to professional photography and imaging businesses. It has a rounded product offering calledDigital Everydaythat includes Darkroom software, PhotoReflect.com internet storefronts, Lubricity lab connectivity and Enrichment business services.

• Generated SQL and PL/SQL scripts to install Create and Drop database objects, including Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Constructed and implemented multiple-table links requiring complex JOIN statements, including Outer-joins and Self-joins.
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created complex Stored Procedures and Views to be used for the Reports.
• Created parameterized reports and customized existing reports for presentations using

Environment: Oracle 11g, SQL developer, UNIX Server 4.3, Rational Clear Quest and TOAD.

Confidential,MA April ’09 May ’10
Sr. Oracle PL/SQL Developer

Confidential, was initiated to restructure the business process for tracking the sales volume. The Siebel Analytics application was developed for the top Executives to view, analyze the gain/loss revenue. Involved extraction of customized data from Siebel system into the warehouse to help in report development and decision making to analyze and improve the performance

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 6i.
• Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Designed, Developed and Tested application in UAT environment and Deployed in Production.
• Provided Productions supports and ongoing user supports for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle Application Server 9i and UNIX Shell Scripting.

Confidential,Texas. Sept ’08 March ’09
Oracle Pl/SQL Developer

Confidential, is an option for people who want short term loan approved in seconds online without the hassle of driving to a bank or long wait on loan approval process. The project involved tuning of the system to achieve optimization of system resources in financial investments, banking, fixed income as well in implementing retail exchange trade reconciliation and settlement processes in cash management system.

• Developed PL/SQL Packages, Procedures and Functions in Oracle 9i.
• Developed PL/SQL package procedures using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Incorporated bulk incremental inserts in PL/SQL procedures.
• Created Database Trigger to audit search events.
• Embedded SQL queries in PL/SQL procedures and ran them dynamically.
• Operated BLOBS, CLOBS and BFILES using PL/SQL (DBMS_LOB) packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Designed Data Model Diagram using Designer 10g.
• Designed and Developed logical and physical database using Designer 10g.
• Created Views, Table, Sequences, Indexes and Synonyms Database Objects.
• Created partitioned Tables and Indexes.
• Developed UNIX shell scripts to process file feeds.
• Tuned PL/SQL packages to improve performance of the application.
• Created User Interfaces for search functionality using Oracle FORMS 6i.
• Created Menus, Object Libraries, and Properties Classes and integrated in application using Oracle FORMS 6i
• Created and developed REPORTS for financial reporting using Oracle REPORTS 6i.
• Tuned SQL queries using tuning techniques like TKProf.
• Created Designed Documents and technical documents.

Environment: Oracle 9i, Oracle FORMS 6i, REPORTS 6i, SQL DEVELOPER, UNIX SHELLScripting.

Confidential, INDIA. July’07 Aug ’08
Oracle PL/SQL Developer

Responsibilities:

• Coding Procedures, Functions, and Triggers and generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Refreshing the test database with the production database.
• Created the database from full export for the Table space point in time recovery.
• Responsible for the creation and testing of hot and cold backup scripts using PL/SQL.
• Created and maintained the UNIX shell scripts to automate common tasks.
• Involved in analysis, design and development of the system.
• Created database Objects Tables, Indexes, Views, Synonyms
• Created stored Procedures, Functions, Triggers.
• Created of Roles, Users, Table spaces, database Triggers, Procedures etc.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Implemented integrity Constraints on database tables.
• Created FORMS and REPORTS using Visual Basic.
• Testing and debugging
• Involved in preparing documentation and providing user training.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*LOADER, Erwin.

Confidential, India June’05 May ‘07 Oracle PL/SQL Developer

Responsibilities:

• Analyzed database design requests and Created databases according to client needs
• Developed PL/SQL modules such as Packages, Triggers, Procedures and Functions.
• Heavily involved in Performance Tuning at the application level.
• Developed Reports using Oracle Reports
• Developed UNIX Shell scripts that will interact with the PL/SQL Objects.
• Documented and performed unit testing for all components prior to migrating them to production.
• Maintained existing applications.

Environment: Windows XP, Oracle 9i, UNIX shell scripting, SQL *Plus, SQL Developer.