SUMMARY:

• 7+ years of experience in SQL, PL/SQL and Performance Tuning, Agile and SDLC Methodologies.
• Extensively used SQL and PL/SQL in creation of Stored Procedures, Triggers, Functions and Packages.
• Worked on Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Extensively worked with data interfaces and reconciliation process between systems.
• Very Good knowledge of Oracle Front End development and tools.
• Used QUEST Tools (TOAD), SQL*PLUS and also used SQL * Loader to load the huge data into source tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper10g and 11g environment
• Expertise in implementing RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) components in the area of technical design, development, Integration testing and deployment
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Extensively used Unix shell scripts to validate the data in oracle staging tables by calling Packages and its PLSQL functions.
• Good Business and System analysis skills to understand the requirements for the client applications.
• Strong writing and documentation skills for the management, development and control of documentation.
• Created and worked with different database objects like Sequences, Synonyms, Indexes, Views, and database links.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c, SQL Server 2008/2005

Tools: TOAD, PL/SQL Developer, ERWIN

Client/Server: Oracle Forms/Reports and Oracle Database

ETL Tools: SQL * Loader, Informatica ETL

Languages: SQL, PL/SQL, Java, J2EE, Shell Scripting, Pro*C

Operating Systems: UNIX, Redhat Linux, Sun Solaris, Windows 2003/NT/XP/7/8/10

Methodologies: Agile, SDLC, Waterfall

Application Servers: Oracle WebLogic Application Server 10.3, WebSphere 7.0

Documentation Tools: MS Office, MS Visio and MS SharePoint

Version Control Systems: Clearcase, CVS and Subversion

Others: Telnet, Putty, Unix VI Editor, JIRA

WORK EXPERIENCE:

Confidential, Chicago, IL

Senior Oracle Developer

Responsibilities:

• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Implemented Oracle Performance Optimization techniques for the existing CSB applications
• Developed SQL statements, PL/SQL packages, stored procedures, functions and triggers for CSB Application.
• Worked on N-Market application using Oracle Forms.
• Create scripts using SQL, PL/SQL and Unix shell scripts for data transferring
• Perform tuning of PL/SQL scripts and SQL statements or large datasets.
• Analyze business data using Toad software on Oracle
• Communicating with users in order to collect requests for improving of the data quality.
• Creating and making enhancements to UNIX scripts.
• Worked with Git for Source Code Management & Version Control.

Confidential, Anaheim, CA

Oracle Developer

Responsibilities:

• Worked on redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions.
• Designed and developed Oracle forms & reports.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Created database objects such as tables, views, indexes, sequences using Oracle 11g.
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL.
• Optimized and tuned PL/SQL subprograms to reduce the loading process.
• Developed row level and statement level triggers for auditing tables in PL/SQL.
• Created partitions on the tables to improve the performance.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
• Wrote complex queries involving multiple-joins to generate user reports.
• Participated in the ongoing process enhancements and modification requests
• Developed scripts in UNIX for daily backup using Cron tab
• Tested, installed, documented and provided on call support for the applications.

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL packages, functions and procedures and Oracle reports and adhoc reports.
• Involved in Tuning the Application, Queries to improve the Performance.
• Created and worked with different database objects like Sequences, Synonyms, Indexes & Views
• Worked with different utilities like Exp/Imp, SQL Loader, FTP to transporting data between databases and loading data into Flat-files.
• Developed control files for SQLLDR for loading data from flat files into the Landing area.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.