SUMMARY

• 8 years of experience in analysis, design and development of custom applications using Oracle PL/SQL, on various versions of Oracle 9i/10g and 11g, 12c.
• Able to handle and exceed the expectations of the clients with tight deadlines and assignments in fast - paced environments. Communicate effectively with users, clients, and within the team.
• Participated in all the Life Cycle phases including requirement analysis, Client Interaction, Design, Coding, Testing, Support and Documentation
• Participated in client meetings to understand the existing solution and proposed new solution based on client requirement.
• Strong programming skills in Oracle PL/SQL.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using PL/SQL.
• Experience in Client-Server Application Development using Oracle PLSQL.
• Expertise working withOracle 10g, 9i, SQL& PL/SQL, SQL * Loader, XML, Shell Scripting.
• Expertise working development tools such as TOAD, SQL navigator and PL/SQL developer.
• Experience in SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Expertise and developing object such as views, materialized views and scheduled jobs.
• Expertise in designing ETL process using PL/SQL, UNIX Shell scripting, external tables and SQL * Loader data cleansing experience using PL/SQL, UNIX Shell scripting.
• Knowledge on reporting tools such as business objects, Cognos and tableau.
• Expertise using oracle supplied packages such as Dbms Utility, Utl file, Dbms Crypto and Dbms Xmlgen.
• Expertise in developing exception handling using complex PL/SQL codes using error back trace and raising application error.
• Expertise in bulk operators using bulk collect and collections.
• Experience inOracle Forms and Reports.
• Developed Ref Cursors as per the requirement provide by the java/ui developers.
• Experienced in production support and ticketing system.
• Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Expertise in performed tuning using explain plan, PL/SQL profiler and tkprof.
• Good knowledge on table and index partition strategies.
• Creation and maintenance of Databases, Assigning Roles and managing user permissions, Tables, Views, Constraints, Indexes, Sequences & Analytical functions.

TECHNICAL SKILLS

Databases: Oracle RDBMS/ORDBMS 8i,9i,10G,11G,12c (RAC,ASM and MS SQL Server, My SQL)

Operating System: Linux, HP Unix, IBM AIX, Windows Server

Oracle Technologies: External Tables Transportable Table space Partitioning, Materialized views and snapshots, partitioning, Oracle Flashback, Data pump, asmlib Oracle Streams, ocfs/ocfs2,GoldenGate

Programming Languages: PL/SQL, SQL, Unix Shell scripting, (sh, bash, ksh), Perl, JAVA Scripting Development/Performance

Tools: and Utilities: RMAN with recovery catalog and without, SQL PlusSTATSPACK, AWR/ADDM,TKPROF, EXPLAIN PLAN, Oracle SQL Optimizer, hints, TRACE AnalyzerQuest TOAD, Oracle Enterprise Manager, Remedy, SqlDevloper.

Unix Tools: cron, at, vi, sed, awk, other Unix, Linux commands and utilities, Notepad ++

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in table structure designing (physical and logical structures), including primary, foreign constraints and indexes.
• Wrote database packages to facilitate the use of common stored procedures and functions used in development. Responsible for writing various database triggers.
• Largely involved in data uploads for testing using PL/SQL Loader.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Tuned PL/SQL statements using explain plan and logical grouping of the database for the project.
• Involved in writing PL/SQL packages/procedures/functions & implementing conversion of the client’s billing system from one database structure to a new one with different functionality.
• Extensively used PL/SQLtables and Bulk loader programs for processing data and loading into Oracle tables.
• Tuned PL/SQL queries with hints, created indexes, used Oracle bulk binding for faster execution of the conversion process.
• Created/maintained snapshots, dB links for reporting servers.
• Developed expense reports to provide claims from accessing different-2 tables.
• Wrote Pl/SQL triggers to ensure validity of data.
• Worked on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL and Union Queries and concentrated much on Query tuning.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked on data migration from PL/SQL Server to Oracle 9i. - Involved in daily, weekly and Monthly load of data from Mainframe data set to Oracle database.
• Worked on Very Large Database Environment in terabytes. And tuned queries for performance. - Extensively used ETL to load data from various flat files which involved both fixed width as well as delimited files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Performance tuning of Oracle Databases and User applications.
• Developed and maintained lot of batch scripts in UNIX shell scripts, like scheduled data loading, Create, databases, backup and Recovery

Environment: Oracle 10g/11gR2, PL/SQL, Oracle 12c RAC, PL/SQL Developer, HTML, SQL Developer, XML,Reports10g,Reports11g,Oracle web toolkit, SQL Loader, UNIX Shell Scripting, SQL*loader

Confidential, Omaha, Nebraska

Sr. PL/SQL Developer

Responsibilities:

• Develop PL/SQL procedures, functions, packages and triggers for inserting, updating, retrieving and validating of data using Oracle 10g.
• Extensive use of Ref cursors, bulk collects and PL/SQL tables like Associative Arrays and Records.
• Extensive Use of Analytical Functions.
• Analyze tables and underlying indexes on all tables.
• Extensive Use of SQL*LOADER to load daily feeds into worktables.
• Developed Claims reports that would produce Excel outputs for users.
• Developed Shell files and Schedule jobs using UNIX environment.
• Maintained version control on files using RCS.
• Support Java team and helped them by proving Queries for Claims Adjudication and Reporting.
• Developed the UNIX Shell script automated the process of loading the Connection Pool data usingSQL *Loader and scheduled daily using CRONTAB utility.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Monitored and modified Performance using execution plans and Index tuning.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Environment: Oracle 10g, 11gR2, PL/SQL, Oracle 12c RAC, PL/SQL Developer, HTML, SQL Developer, XML, Reports10g,Reports11g,Oracle web toolkit, SQL Loader, UNIX shell scripting

Confidential 

Oracle PL/SQL Developer

Responsibilities:

• Creating/Modifying /Enhancing Oracle PLSQL Procedures, Functions and Packages as per the Requirement.
• Attending calls with the Business and Offshore team on weekly basis for Requirement clarifications and delivery issues.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Creating User Requirement Specification (URS), Functional Specification (FS), Test Plan (UTP), Unit Test Results (UTR), User Acceptance Form (UAF).
• Wrote several stored procedures/Triggers in Oracle (PL/SQL) for the Enterprise Portal Application and data merge.
• Creating and configuring the Databases as per the requirement.
• Performing backups of PLSQL databases by setting up backup schedules at regular intervals and also restoring databases.
• Worked on apache tomcat.
• Experienced in Production databases restoration and recovering.
• Worked on various PL/SQL features like Cursors, REF Cursors, Collections, Analytical Functions and Bulk Binding along with the various Exceptions in the PL/SQL Stored Procedures.
• Written and Implemented PL/SQL Scripts to check the performance of database.
• Experience in migration of applications from lower to higher versions and troubleshooting application’s performance.
• Involved in automation of the table partitions and indexes for the data ware house databases.

Environment: Oracle 10g/11g R2, PL/SQL, Toad, Putty, SQL, Unix, MS SQL Server, My SQL

Confidential 

Database Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Extensively worked on PL/SQL Error/Exception handling, Control Structures in PL/SQL.
• Developed PL/SQL Procedures, Functions, Packages using TOAD andOracle 10g
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• Used PL/SQL Developer to develop code.
• Designed and DevelopedOracle PL/SQL and Shell Scripts, Data Import/Export.
• Involved in writing Bulk Collects, Cursors, Ref Cursors, and Exceptions within the various procedures.
• Worked on apache tomcat.

Environment: Oracle 10g, 11g R2, PL/SQL, Toad, Putty, SQL, Unix, MS SQL Server, My SQL