SUMMARY:

• Dynamic professional with almost 6 years of extensive experience as an Oracle PL/SQL Developer with ETL, shell scripting experience in diverse sectors including Finance, telecommunication, Health care.
• Expertise in Software Development Life Cycle (SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation and support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g database.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i, Reports10g/9i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Strong technical background with approximately three years of production support experience in SQL, PL/SQL, Oracle, UNIX, and Shell Scripting.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Involved in Oracle Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQLTrace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL Plus, FileZilla, WinSCP.
• Working experience in Data Extraction, Transmission and Loading (ETL).
• Experience in using data sources/targets such as Oracle 12c/11g/10g, MS SQL Server 2008/20012, DB2, XML and Flat files.
• Good understanding of data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Developed Oracle Forms and Oracle Reports using 11g,10g depending on the functional requirement document.
• Proven ability to work efficiently in both independent and team work environments.
• Excellent communications and analytical skills.
• Highly organized and efficient to prioritize and manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, MS SQL 2008/2012, MS Access, DB2

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming.

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML

Operating Systems: Windows Family, MS: DOS

Other Tools: Jenkins, Github

PROFESSIONAL EXPERIENCE:

Senior Oracle Pl/SQL Developer

Confidential, El Paso TX

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Generated PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to processing layer.
• Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• 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
• Extensively used bulk collection in PL/SQL objects for improving the performing
• Created records, tables, collections (nested tables and associative arrays) for improving Query performance by reducing context switching
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• AWR/ASH report analysis for DEV/PERF/PROD environments
• Explain plan analysis on low performing SQL queries and providing recommendations to improve response time
• Work with data migration/development/testing teams for successful completion of performance tests
• Monitor the system resources during performance testing using OEM/AppDynamics tools and identify the bottlenecks

Environment: Oracle 12c, Informatica, AppDynamics, OEM

Oracle PL/SQL developer

Confidential, El Paso, TX

Responsibilities:

• Worked with Oracle database consisted of more than 50GB sized tables.
• Extensively used EXPLAIN PLAN and TKPROF for SQL tuning.
• Tuned approximately 100 complex SQL queries.
• Used Optimizer HINT for tuning SQL and Advanced PL/SQL.
• Generated the trace files for more than 40 batch jobs to find the optimal queries.
• Tuned auto generated SQL - created INDEX based on the requirement of the table.
• Worked with DBMS PROFILER to tune PL/SQL Procedures.
• Created log on trigger and new user to run batch jobs for collecting the trace files.
• Used cursor, ref cursor, bulk collect and bulk insert (Bulk Binding) in procedure to reduce its execution time.
• Created packages and stored procedures for data conversion by using DBMS RANDOM package
• Worked with DBMS SCHEDULER to schedule jobs.
• Created Materialized Views to reduce the network load.
• Extensively used TOAD for tuning, for database monitoring.
• Created UNIX shell scripts for regular tasks and used UNIX commands as per needed.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Optimize existing T-SQL code.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• PARTITION 4 to 5 tables (size of those tables are more than 100GB) to manage database and to improve the performance.
• Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that run Oracle PL/SQL.

Environment: Oracle 10g/11g, Oracle SQL Developer, TOAD, SQL*Loader, FTP, AutoSys, Linux, SQL.

Oracle PL/SQL Developer

Confidential, Orange County CA

Responsibilities:

• Designing the database based on the requirements of the projects
• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system
• Worked with Business Analysts during requirement gathering
• Creating Tables, Indexes, Views, Triggers
• Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers
• Writing complex PL/SQL scripts, packages, procedures, functions and DB triggers to implement the business logic
• Writing Shell scripts to call stored procedures and packages to load data files using external tables
• Scheduling oracle jobs to trigger procedures and packages to perform daily routines and tasks
• Created Indexes and used hints to improve performance
• Writing shell scripts to call stored procedures to extract data from the database to external files
• Experience in working with Warehouse Management Software also with Data Integration Projects
• Worked with Range Partitioning of a table, also involved in dropping of partitions
• Created Oracle packages with advanced sql queries like analytical and aggregate functions to process and load daily enrollment files
• Extensively worked with PL/SQL packages, Stored Procedures based on the requirements provided by business
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables
• Provided production support for multiple projects
• Worked for ICD 10 Project to differentiate between ICD 9 and ICD 10, as per the requirements provided by Business
• Experience in working with PL/SQL Packages and Stored Procedures, Triggers
• Involved in doing Unit Testing, Integration Testing and System Testing
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based)
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Involved in writing Unix shell scripting also placed some of the files in Unix server as per the requirement specified by Business people
• Experience in the usage of Autosys scheduler in order to schedule workflows and sessions
• Good Understanding of AGILE and Waterfall development approach
• Used different types of Indexes like Function-Based Index, etc.. to improve the Package Performance
• Used Indexes in PL/SQL Packages in order to increase the performance
• Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels

Environment: Oracle 11g, Windows XP/7, UNIX, PL/SQL Developer, MS SQL Server 2008, Informatica Power Center 9.1

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in writing DDL and DML operations.
• Worked very closely with functional team to understand their Development related requirements.
• Wrote complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect and minus set operators.
• Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
• Created Collections for accessing and storing complex data resulted from joining of large number of tables.
• Used Database trigger for making history of insertion, updation, deletion and all kind of Audit.
• Optimized critical queries to eliminate Full Table scans and reduce Disk I/O and Sorts.
• Handled errors using Exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Created partitioned tables and partitioned indexes to improve the performance of the applications
• 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.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.

Environment: Oracle 10g/11g, SQL Developer, SQL *Plus, Toad, UNIX Shell Scripts.