SUMMARY

• 9 years of IT experitence in analysis, design, development, implementation and testing as Oracle SQL/PLSQL Developer.
• Hands - on experience in all phases of system development & software development with well-defined Quality Standards; Requirement Analysis, Design, Development, Testing & Implementation.
• Provided support for RDBMS in Development, Test and Production environments using Oracle Tools.
• Involved in database design and data modelling using ERwin Data Modeller tool.
• Experience in Oracle Development tools TOAD, Oracle SQL Developer.
• Experience in SQL, PL/SQL, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes.
• Knowledge of Autonomous Transactions Materialized Views, Bulk Collects and Collections.
• Experience in writing PL/SQL routines in data warehousing applications.
• Analyzing & gathering table statistics for Query Optimization.
• Experience with Oracle Developer Suite 6i /9i /10g.
• Experience in Performance Tuning using SQLTRACE, EXPLAIN PLAN&TKPROF with the help of Hints, Partitioning, Bulking techniques and Indexes.
• Experience in UNIX Shell Scripting.
• Oracle Import/Export Utilities & SQL*Loader.
• Experience in Migrating Data to Oracle database.
• Good understanding of Oracle Architecture.
• Experience in preparing technical documentation & user manuals.
• Ability to cope up with team with good analytical, communication, organizational and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: WINDOWS NT/2000/XP/Vista/windows7, Solaris 10/9/8, AIX 5.x, Red Hat LINUX AS3.0 & 4.0

DATABASEs: ORACLE 8i/9i/10g/11g, MS Access, MS Excel (VBA), SQL Server 2005/2008, DB2

GUI's: Oracle Developer suite 9i/10g/11g/12c

TOOLS: ERWIN 7.x, TOAD 10.6, SQL Developer 2.1, SQL*PLUS, SQL*LOADER, PVCS, Informatica 7.1/8.6.

SCRIPTING: UNIX Shell Scripting

Languages: C, C++, Java, VB, C#

Communication Tools: MS-Outlook, IBM Lotus Notes

Web Technologies: JSP, Servlets, Applets, XML, HTML,CSS, PHP

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Oracle Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked with SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Created PL/SQL packages, procedures, functions applying the business logic to calculate Communication Volumes (by touchpoint & communication channel), Response Rates (Customer Pay & Warranty Pay breakouts), Dealer ROI Metrics, Key Program Headquarters Statistics, Revenue Generated Statistics (cumulative and per CP RO), Services Purchased (e.g. Brakes, Batteries, Tires, etc.), etc.
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformation andload packagesfordata ware housing.Extracted data from theXMLfile and loaded it into thedatabase.
• Extensively involved in tuning the queries for faster and better performance of the SQL queries Optimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.
• Involved in Performance tuningofSQL queriesas data warehouse consists of many of rows of data.
• Created data for Crystal Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Documented design specifications and architecture using Microsoft Visio.
• Used Oracle APEX to create screen design and reports design templates.

Environment: Oracle 12c, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 9.0.3, Toad, AIX 7.1.

Confidential, Madison, WI

Oracle Developer

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Created the PL/SQL packages, procedures, functions applying the business logic facilitate the functionality for various modules.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the different tables.
• Design and developed the scripts to create tables, views, indexes and sequences.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Migrated data from the previous database in SQL Server database to Oracle 11g.
• Involved in performance tuning and troubleshooting issues.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Fine Tuned procedures in various schemas across databases using Oracle Hints, Explain plans and Trace sessions.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 11g, Microsoft SQL Server 2005, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6, AIX 7.1.

Confidential, Philadelphia, PA

Oracle developer

Responsibilities:

• Involved in gathering and creating requirement document
• Providing assistance in logical/physical data modeling and data integrating using Erwin. Assisted in designing the system flow.
• Created tables, indexes and views.
• Creating stored programs in the form of PL/SQL Packages, Procedures and Functions.
• Modified Stored Procedures and Stored Packaged Procedures using TOAD.
• Creating SQL*Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Managing tables, indexes, constraints, views sequences, synonyms and stored program units
• Extensively used complex SQL queries ( Sub-queries and correlated sub queries)
• Involved in writing crisp and precise technical documentation.
• Involved in analysis, design, and development and testing of different modules.
• Created Indexes to improve the overall system performance.
• Involved in tuning the SQL queries for performance improvement.
• Developed UNIX shell scripts for automating the loading procedures.
• Developed Database Triggers, Stored Procedures, Functions and Packages.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• Created Files and entry screens. Also provided exception and error handling in the application.
• Generated reports using Crystal Reports.

Environment: UNIX, Oracle 9i/10g, SQL*PLUS, PL/SQL, SQL*Loader, Toad 9.5, SQL Developer 2.1, Oracle Reports 10g.

Confidential, Cleveland, OH

Oracle Developer

Responsibilities:

• Understanding the business requirements, writing functional specs, test specs and plans.
• Translation of business requirements to an Enterprise Data model.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Developed stored procedures, packages and functions for workflow validation and verification.
• Document the whole process flow: PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Prepared procedures to update the internal structures to reflect the newly loaded data.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.
• Created error log table to capture the error messages, session load time.
• Extensively involved in tuning the queries for faster and better performance of the SQL queriesOptimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Worked with Reporting group to facilitate reports.
• Responsible for production support and bug fixing.

Environment: Oracle 9i/10g, SQL*PLUS, PL/SQL, SQL*Loader, UNIX, Windows XP, SQL Developer 1.2, Toad 8.6.1.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Created the PL/SQL packages, procedures, functions applying the business logic facilitate the functionality for various modules.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the different tables.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformation andload packagesfordata ware housing.Extracted data from theXMLfile and loaded it into thedatabase.
• Design and developed the scripts to create tables, views, indexes and sequences.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Migrated data from the previous database in SQL Server database to Oracle 11g.
• Fine Tuned procedures in various schemas across databases using Oracle Hints, Explain plans and Trace sessions.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 11g, Microsoft SQL Server 2005, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6, AIX 7.1.

Confidential

Oracle Developer

Responsibilities:

• Involved in requirements gathering, designing, developing, testing and deploying backend procedures, function & packages in PL/SQL particularly for maintaining payments.
• Worked on optimizing existing procedures and functions.
• Used Oracle materialized views / snapshots, clusters and partitions for faster query performance.
• Improved query performance through usage of bit map and function based indexes, explain plan, analyze, hints and joins.
• Extensively used PL/SQL collections and records.
• Developed database tables /views using primary keys and foreign keys.
• Created synonyms to maintain the security to give access to specific users.
• Created curser designs and passed cursor variables as program parameters; created subtypes based on existing types of the application.
• Used nested tables, string indexed and nested collections, and wrote PL/SQL programs using collections and coded them; compared associative arrays to collections.
• Used sequences to automate number generation for employees.
• Used different exception handlers and created some user defined exception handlers.

Environment: Oracle 9i, SQL*Loader, SQL*Plus, Toad 8.6.1, PL/SQL, Oracle Forms/Reports 9i.