SUMMARY

• Over 6+ years of experience in the field of Software Design, Development and Implementation with Proficiency in using Oracle SQL, PL/SQL ,Reports, Forms and Informatica.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i, SQL SERVER CE, FORMS 10g/6i, REPORTS 10g/6i, Oracle Import/Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collect, Autonomous Transactions, Dynamic SQL, and Collections.
• Experienced in writing complex PLSQL Procedures or Functions using advanced PLSQL concepts
• Strongly experienced in developing Complex database Triggers, Views and Exception Handlers.
• Experienced in implementing various performance techniques such as Oracle Hints, SQL Rewrite, Indexes, etc.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER.
• Experienced in Data Analysis, Data Modeling and Data Profiling.
• Expertise in developing both Logical Modeling and Physical Data Modeling using Erwin.
• Strong experience in creating Materialized views to improve performance of SQL queries.
• Strong understanding of Oracle Data Dictionary and Normalization techniques.
• Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
• Good understanding of Oracle Compression techniques.
• Expert in implementing Explicit and Implicit Cursors.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database using DB Links.
• Experience with DBA activities like creating Tablespace, granting and revoking privileges on database objects.
• Experience working with DBA to set up Oracle Streams.
• Practical Knowledge of Data warehouse Concept, Data modeling principles – Star Schema, Snowflake, surrogate keys, Normalization/Denormalization Techniques
• Experienced in using various database tools such as SQL Developer, SQL Navigator, PLSQL Developer and TOAD
• Good experience in using batch scheduling tools such as Autosys.
• Experience in maintaining source codes using CVS, PVCS, VSS and Subversion.
• Experience in programming languages like C, C++, JAVA, HTML & XML Technologies.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF.
• Experience in Installing Software’s and Configuring Databases.
• Experience in UNIX Shell Scripting for batch processing.
• Experienced in Encrypting and Decrypting files using Unix Shell scripting.
• Expert in Trouble-shooting, Problem solving, Analytical & Design Skills.
• Excellent Team player with Leadership qualities and coordinating abilities.

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access 

Data Modeling: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

ETL Tools: Informatica Power Center 9.1.0/8.6.0 

Languages:SQL, PL/SQL, SQL*Plus, Unix Shell Scripting, XML, C, C++, Java, HTML, XML

Tools: SQL plus,SQL Developer, SQL Navigator, TOAD, Autosys, Developer2000 (REPORTS 10g/6i, FORMS 10g/6i)

Operating Systems: UNIX, Windows (XP, NT/95/98/2000), WinNT4.0, MSDOS6.22

EXPERIENCE

Confidential, FL. MAY ‘10- Till Date
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 using DB Links.
• 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 Views, Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created PLSQL infrastructure for Debugging and Error Handling using stored procedures and Functions in packages.
• Created Unix shell scripts for Encrypting and Decrypting data files.
• Worked with DBA to implement compression on Database tables.
• Worked with DBA to set up Oracle Streams that streams data from OLTP to DWH database.
• Monitoring Autosys jobs in QA, DEV and production.
• Created both Logical and Physical Data models by constantly staying in touch with Business Analysts and understand the requirements.
• Implemented Interval range and Hash partitions to help improve the performance of SQL queries.
• 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.
• Involved extensively in Tuning SQL queries and PLSQL scripts by using SQL rewrite, partitions and Indexes.
• Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Used SQL*LOADER and External tables to upload data into the tables.
• Worked on Power Exchange to create Mappings, workflows that loads the data from Flat files coming from source system to Oracle database.
• Monitored Informatica workflows using Informatica workflow monitor.
• Involved in Testing and debugging of the applications.
• Involved in 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, MA April ’09 –May ’10 
Sr. Oracle PL/SQL Developer

Drug Sales Tracking System (DSTS) 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, Fortworth, 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. 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 June’06 – 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 Front end using SERVLETS, JSCRIPT and HTML
• Developed the backend using Servlets, Java Beans and JDBC.
• JMS messaging method is used for communication between software applications
• Extensively utilized XML and SOAP for the data transfer between web clients and server
• 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, Java, JDK,JSP,JMS,JDBC, HTML,XML.