PROFESSIONAL SUMMARY:

• Over 10 years of experience in SQL, PL/SQL development along with Oracle Database Administration, Architecture and Designing Databases.
• Extensive experience as Oracle SQL, PL/SQL developer in various domains including Manufacturing, Retail and Utilities.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in   all phases of SDLC including   requirement analysis, database design, application design, development, testing, implementation and   maintenance.
• Excellent skills to write SQL, PL/SQL Stored Procedures, Packages and Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i databases.
• Good experience of Performance Analysis and SQL Query Tuning, while designing scalable application from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, TK - Prof and Explain Plan.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL Developer and SQL LOADER.
• Regular activities like Backup & Recovery , Capacity Planning, Database Performance Tuning, Memory Tuning , Security Administration, Space Management and Index management.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good knowledge in Data warehouse ETL tool like Ab Initio.
• Solving the complicated run time errors while running the process along with DBA team members.
• Created Tables, Views, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in Oracle Cursor Management and Exception Handling.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in migration of source code using version control systems like Subversion (SVN), Revision Control System (RCS) and Microsoft Visual Source Safe.
• Excellent Team Player to work in conjunction with testers (QA and offshore), developers and other team members in validation and testing of complex project scenarios and in maintenance of Quality Standards of products.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILLS:

Project Domain: Utilities, Energy, Government and Education.

RDBMS: Oracle 8i/91/10g/11.x/12c, SQL Server

Languages: Oracle SQL, PL/SQL, JAVA, JDBC, JSPs.

Data modelling Tools: Erwin, TOAD Data modeler, power Designer

Development Tools: Eclipse, TOAD, SQL Developer, SOAP UI.

GUI Packages: Forms & Reports 4.5i/6i/10.1.2.

Operating Systems: Windows, UNIX

Web Tools: Servers, JSP.

Rational Tools: Clear Case, Clear Quest

Version Control: CVS, VSS, SVN

ERP: Oracle Applications 11i./12.2.6

Modules: INV, PO.

Processes: Waterfall model, V- model, Agile (Scrum)

ETL: Ab Initio, Data Stage

Big data: Hadoop

EXPERIENCE:

Confidential, Southfield, MI

Sr. Oracle Developer

Responsibilities:

• Attend business meetings and understand new business requirements.
• Building technical specification requirements that contains all the comprehensive project requirements and scope.
• Analyze the existing Mainframe modules and the data that comes from them.
• Digging into the data mart to understand the discrepancies among several jobs that run on Mainframe modules and identifying observations.
• Generated DDL scripts and created and modified database objects like Tables, Views, Sequences, Functions, Procedures, Indexes, Packages, Records and Collections using TOAD.
• Involved in performance tuning using Oracle Hints and Explain Plan for Views and Queries.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to log the status when error occurs.
• Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
• Tuned sql queries based on recommendations from OEM. Sql tuning performed with the help of AWR reports.
• Monitored the Applications and database using OEM and OAM.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
• Involved in the LOGICAL & PHYSICAL DATA MODELING of the application.
• Involved in performance tuning using HINTS, EXPLAIN PLAN. 
• Involved in writing complex SQL Queries to implement the business requirements.
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.
• Developed technical design documents by reviewing functional requirement documents in an agile environment.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts
• Development, debugging, optimization, configuration and Tuning of PL/SQL code, queries and other database objects.
• Designed and created Database tables, Keys, Indexes, Views, Materialized view as per requirement.
• Develop and design Packages, Cursors, Procedure, function, triggers forms and reports.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 12.10, SQL*Loader, TFS, Windows Server 2008/Windows 7, UNIX, Erwin 9.0

Confidential, Rancho Cucamonga, CA

Sr. Oracle Developer

Responsibilities:

• Involved in gathering Requirements from the business users and prepared the program specification and design document for the development.
• Responsible for developing, maintaining, enhancing and debugging complex PL/SQL Packages, Procedures, Functions and triggers.
• Developed competent PL/SQL programs using Collections, Record types, Cursors, Ref cursors.
• Design and develop ETL processes written in SQL, PL/SQL, and SQR for loading data from internal systems using SQL Loader and External tables.
• Created UNIX shell scripts to automate the process.
• Used DBMS JOB and DBMS SCHEDULER to create and schedule the execution of packages, standalone procedures and emailing of reports from the database.
• Created Tables, Views, Materialized views, Constraints.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes to improve performance of application.
• Involved in data migration by creating complex SQL scripts using multiple joins into Arena database.
• Involved in Unit testing, Code reviewing and preparing design specification document.
• Developed new Forms and deployed through UNIX environments into Test and Prod.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in Production support of existing Oracle PL/SQL packages.
• Handled errors using Exception Handling extensively for the ease of Debugging and displaying the error messages in the application.
• Uploading the Test cases, Manual Test Scripts, Codes and Specification Documents on SVN for version controlling.
• Involved in customization of several reports to serve important business processes very specific to the client. Such reports include GR MRP Monthly Demand Supply Report, GR Vendor Payments Report, GR Demand Push Out Report, GR Payment Register etc.
• Creation of Concurrent Programs for executables like PL/SQL, Reports, SQL*Loader.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures and reports.
• Created Concurrent programs and executables and attached it to various request groups, and responsibilities.
• Extensively used error and exception handling techniques for validation purposes in code.
• Involved in the production support of existing systems.
• Extensive use of Collections like Varrays and nested tables.
• Extensive use of Sub-queries and joins in stored procedures.
• Coordinated with the business users to collect requirements.
• Wrote Test Plans and Involved in Unit testing.
• Worked with the Business users to resolve issues rose through SR’s (Service Requests). The solution is fully tested to ensure the outcome is accepted by the business before moving it to the production environment.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 8.5, SQL*Loader, SQL Developer, UNIX.

Confidential, Detroit MI

Sr. Oracle Developer

Responsibilities:

• Designed and Developed Database objects like Tables, Indexes, Sequences and Views.
• Involved in design, development and Modification of PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using Joins, Sub Queries and Correlated Sub Queries.
• Created CTL files to load the data into Oracle database using SQL Loader.
• Written several Procedures, this uses Explicit Cursors to select data and Exception Handlers to raise errors.
• Responsible for writing and modifying Shell scripts in UNIX and scheduled CRON jobs.
• Involved in Database Performance Tuning using Oracle Hints, Partitioning and Indexes. 
• Used PL/SQL Tables, Array structures as a part of Oracle Collections and Used Bulk collect and for all in stored procedures to improve the performance and make the application to run faster. 
• Involved in Performance Tuning using Explain Plan, and SQL trace.
• Wrote the Shell script to call loader and PLSQL scripts and to get the data from other systems and to FTP data from one server to other server.
• Loading the Data into tables using SQL loader and using PLSQL Package UTL FILE (ETL).
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Modifying the queries by using BULK COLLECT and FOR ALL to reduce the time for performance issues.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 10.5, SQL*Loader, SQL Developer, HP UNIX, LINUX

Confidential

Oracle Developer/DBA

Responsibilities:

• Designed, developed, modified Tables, Views, Materialized Views, Stored Procedures Packages and Functions.
• Coded PLSQL Packages and Procedures to perform data loading, Error Handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted Hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Ref Cursors, Dynamic SQL, and Table Functions as part of Project/Application.
• Extensively worked with Bulk Collect, PL/SQL Tables and Arrays.
• To increase the performance and to manage large database objects Partitioned Tables using Range Partitioning, List Partitioning.
• Involved in using of features of Oracle 11g like Analytical functions, Flash back Query, regular expressions.
• Improve the performance of the slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement the new business.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Implemented all modules logic by using Triggers and Integrity Constraints.

Environment: Oracle 9i/10g, SQL Developer, SQL*Plus, TOAD 9.5, SQL*Loader, Erwin 7.2, Putty

Confidential

Oracle Developer/DBA

Responsibilities:

• Developed data mart Packages for collecting the business data from all the units of the organization.
• Developed the procedures to evaluate and synch the information regarding items manufactured.
• Manages the constraints throughout the database as per the business requirements.
• Written PL/SQL Stored Procedures and Packages to retrieve relevant information from various tables into intermediate tables.
• Assisted the business intelligence team in writing complex queries, PL/SQL scripts and database triggers.
• Created UNIX shell scripts, which call the PL/SQL scripts to test the source rows to destination rows.
• Written CRON Jobs in UNIX to run end-of-day processes automatically.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Converted the .CSV files from excel and other sources into Oracle database using SQL Loader.
• Created Indexes and partitioned the tables to improve the performance of the query.

Environment: Oracle 9i/10g, SQL Developer, SQL*Plus, TOAD 9.5, SQL*Loader, Putty, TFS, JIRA.