Summary

• Six plus years of IT experience as an PL/SQL Developer, Oracle Developer, Development & Support of Oracle Database 9i,10g and 11g in Production, staging and Development environments.
• Involved in all phases of SDLC (Software Development Life Cycle).
• Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.
• Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
• Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators.
• Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS.
• Expertise in handling errors using Exceptions with RAISE application clause.
• Knowledge of Materialized Views.
• Generating SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Expert in creating Public Synonyms, DB Links.
• Managing security by creating and granting Roles and Privileges to users.
• Experience in developing external Tables, Views, Joins, Cluster indexes and Cursors.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables and Dynamic SQL.
• Experience in creation of table Partitioning by range, list, hash, composite methods and Indexes for managing large tables.
• Proficient in Query/application tuning using optimizer Hints, Explain plan, SQL Trace, TKPROF.
• Developed new Reports which are used to extract data from different systems and criteria.
• Automated the process through the UNIX Shell Scripting and auto sys job scheduling.

Education:
Bachelors in Electronics & Communication Engineering, Confidential,-INDIA.

Technical Skills:

Operating Systems:

UNIX, LINUX, Sun Solaris 5.8/5.9/5.10,
Windows NT/95/98/2000/XP

Databases:

Oracle 11g/Oracle 10g,Oracle 9i, Ms Access

Utilities :

SQL*Loader, Explain Plan, FTP,SFTP,SCP

Tools:

TOAD, SQL Developer , Erwin ,SQL Navigator,
SQL*Loader, SQL*Plus, MS-FrontPage, MS Office Suite, iSql Plus,
(REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g).

ETL Tools

Informatica power center 8.6.x,Data stage

Languages/
Editor

SQL, PL/SQL, UNIX Shell Programming, VI Editor

Professional Experience:
Confidential,Mason, OH Jan2011-Till Date
Role: PL/SQL Developer
The RealPage Payments platform is embedded in the Onsite property management system and provides end-to-end automation of the payments process to help property management added efficiencies while increasing resident satisfaction. Worked on end user applications which Improve cash flow through increased collections rates and ability to research payments online in real time 24/7 resident payment amenity through the resident portal.
Responsibilities:

• Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored Procedures.
• 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.
• Involved in performance tuning using with TKPROF.
• Tune SQL statements using hints for maximum efficiency and performance, create 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 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.
• Developed Shell scripts for job automation and daily backup.
• Documentation of the business process through Designer.
• Created, debugged, and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.

Environment: Oracle 11g, Oracle 9i, SQL Developer, SQL Loader, TOAD, UNIX, Sun Solaris.

Confidential,Atlanta Oct 2009-Dec2010
Role: PL/SQL Developer
Xerox handles various sectors starting from manufacturing to retail. Worked on end user applications dealing with auto finance industry, more and more lenders are seeking creative ways to manage and optimize their consumer loan operations. Also worked on the health care applications involving Health plans are under heavy pressure to reduce costs, Streamline processes, Improve consumer communication, Create new products that meet imposed medical loss ratios.
Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build Packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.
• Used SQL*Loader and UTI File Loader to upload bulk data by writing scripts for the Control file.
• Working on the ETL side of the process to load data into database from different servers.
• Created partitions for parallel processing of data.
• Developed UNIX Shell scripting for job automation and daily backup.
• Involved in performance tuning using with TKPROF.
• Documentation of the business process through Designer.
• Writing backend stored procedures.
• Writing event driven Triggers, Functions and Packages as needed.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention.
• Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS. Oracle query tuning and optimization.
• Extensive Use of Bulk Binds, Bulk Collect.
• Extensive Use of Pragma Autonomous Transactions.

Environment:Oracle10g,PL/SQL Developer, SQL*Plus, TOAD,Oracle10g, Informatica, SQL Developer, UNIX.

Confidential,Pasadena, CA Mar 2008-Sep2009
Role: Oracle PL/SQL Developer
Kaiser permanent is a health insurance company providing healthcare at its best. Designed application for the end users to access plans and to guide to receive the plan which suite the best to their requirements. Working with tickets to handle costumer issues and provide better performance at every instance.
Responsibilities:

• Extensively used high level backend PL/SQL programming involving different databases.
• Involved in the development of new Procedures, Functions, Packages, Triggers and also updating the old ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.
• Developed new Forms which are used to extract data from different systems and criteria. The results are written to a flat file.
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for the Procedures which is used to update the purchase order information from one database to another database.
• Utilized tools like TOAD during development of the application.
• Used Database Trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Use of EXPLAIN PLAN, ANALYZE, HINTS, TKPROF to tune queries for better performance.
• Extensively used the advanced features of PL/SQL like Collections, Nested Table.
• Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.
• Used shell scripting in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Extensively used the DBMS_SESSION, DBMS_STAT and DBMS_PUTLINE oracle supplied packages.
• Created Documentation of development code and the test cases involved.
• Worked extensively on Exception Handling, to trouble-shoot PL/SQL code.

Environment: Oracle 10g, SQL Developer, SQL Loader, UNIX, TOAD,Oracle10g Forms and Reports, UNIX/Sun Solaris.

Confidential,India Sep 2006- Jan2008
Role:PL/SQL Developer
Responsibilities:

• Involved in creation of Tables, Join Condition, Nested Queries, Views, Sequences and Synonyms for the business application development.
• Developed Database Triggers, Packages, Functions and Stored Procedures usingPL/SQLand maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Created dynamic SQL to support dynamic nature of front end applications.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used the UNIX for Automatic Scheduling of jobs. Involved in Unit Testing of newly created PL/SQL blocks of code.
• For increasing the performance of all the collection-based DML used FORALL and also scanned the collections using FIRST, LAST and NEXT in loops.
• To conserve the resources used the anonymous blocks within the IF statements.
• Used the Pragma Exception_Init to name the system exceptions that are raised by the program.
• Wrote complex queries to generate reports as per client request as a part of production support.

Environment:Oracle8i, Windows XP,PL/SQL, SQL*PLUS, SQL Developer, UNIX.
Confidential,India. July2005-Aug2006
Role: PL/SQL Developer
Responsibilities:

• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Monitoring existing SQL code and performance Tuning if necessary.
• Extensively involved in new systems development with Oracle 6i.
• Interact with business analysts to develop modeling techniques.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Used Import/Export Utilities of Oracle.
• Wrote UNIX Shell Scripts to automate the daily process as per the business requirement.
• Writing Tuned SQL queries for data retrieval involving Complex Join Conditions.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Read data from flat files and load into Database using SQL*Loader.
• Created the External Tables in order to load data from flat files and PL/SQL scripts for monitoring.

Environment: Sun Solaris UNIX, Oracle 6i, SQL Loader, Oracle Forms 6i, SQL*Plus and SQL Developer.