SUMMARY:

• Over 4 years of experience as Oracle PL/SQL Developer, Database Maintenance, Coding, Design, testing Methodologies and Production Support using Oracle 10g, 11g, 12c in production, Staging environments.
• Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Test, Implementation and Support.
• Experience in SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, cursors and Indexes.
• Strong in Designing, Development (coding), Testing, Implementation and Documentation as per standards.
• Knowledge in data migration activities like Export and Import utilities, Bulk copy processing (BCP), data scrubbing using Oracle data pump and SQL *Loader.
• Proficient in requirements gathering and analysis, validation, Business Requirements Specifications and Functional Specifications for schema creations and table creations.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS) by using UML and ER (Entity Relationship) diagram.
• Proficient in using advance features for PL/SQL programming like Using cursor variables, Ref. cursors, System Ref. cursor and Dynamic SQL.
• Worked on Oracle Forms 10g and Reports 10g.
• Used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization and de-normalization.
• Hand on experience in Performance tuning, gathering table statistics for Query optimization, troubleshooting and monitored the daily running scripts to maintain and increase the performance of database.
• Provided support for RDBMS in Development, Test and Production environments using Oracle Tools.
• Knowledge of Autonomous Transactions Materialized Views, Bulk Collects and Collections.
• Involved in Migrating Data to Oracle database from different data source such as SQL, Flat files, Excel
• Experience in preparing technical documentation & user manuals.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS:

• Windows
• AIX 7.1
• Red Hat LINUX
• ORACLE 10g/11g
• 12c
• MS Access
• MS Excel (VBA)
• SQL Server 2008
• Oracle Developer suite 10g/11g/12c
• ERWIN 7.x
• TOAD 10.6
• SQL Developer
• SQL*PLUS
• SQL*LOADER
• Informatica
• PVCS
• MS Visio
• Oracle Forms 10g
• UNIX Shell Scripting
• MS-Outlook
• IBM Lotus Notes
• HTML
• CSS
• WinCVS
• AppWorx.

PROFESSIONAL EXPERIENCE:

Confidential, Melville, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed complex PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Worked in data warehouse environment across multiple databases.
• Creation of new packages and modification of existing codes to resolve application bugs.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed reports using PL/SQL to export into CRYSTAL reports.
• Coordinated with DBA in creating and managing tables, indexes, DB links and privileges.
• Created database objects, packages, procedures and functions according to the business requirements.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Used bulk processing for better performance and easy retrieval of data, participated in performance tuning of procedures and packages.
• Extensively used dynamic SQL, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Used advanced SQL, analytical functions, aggregate functions for mathematical and statistical calculations.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Developed various form-level and DML triggers to perform validation checks.
• Fixed Production Issues and Critical Problems.
• Worked extensively with the Business analyst and was involved in discussions with the end users about new requirements and any change request of high priority.
• Provided 24/7 on call production support on 4 weeks rotation basis, was responsible for monitoring bugs and keeping track of all the Service request.
• Created indexes on the tables for faster retrieval of the data.
• Used hints in select, insert, update statements to improve the performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Autotrace and DBMS APPLICATION INFO.
• Set up production jobs through AppWorx.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.
• Developed user documentation for all of new application modules.

Environment: Oracle 11g/12c, SQL*Loader, UNIX, SQL, PL/SQL, TOAD, Windows, SQL*Plus, AppWorx, UltraEdit32, JIRA, WinCVS.

Confidential, Livingston, NJ

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
• Created different schemas and maintained schema objects.
• Creation of new packages and modification of existing codes to resolve application bugs.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Used advanced queuing concept to deque the exceptions raised during the cron job execution which will be notified by mail using UTL MAIL package and enque it into main table for error reprocessing.
• Developed various form-level and DML triggers to perform validation checks
• Worked Extensively in Menu Modules in forms Builder worked on calling new menu’s and auto populating the form with the data from the previous screen calling screens.
• Developed Templates for new forms and generate scripts for database objects using oracle designer 10g
• Fixed Production Issues and Critical Problems.
• Worked extensively with the Business analyst and involved in discussions with the users in requirements and any change request those were requested by the business.
• Supported the new system and old system in Production and worked in high-Priority bugs and written SBM scripts for prod fixes and released to the Application Support.
• Responsible for monitoring bugs and keeping track of all the Service request.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used hints in select statement for improving the performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKprof, Autotrace and DBMS APPLICATION INFO.
• Dropped and recreated the indexes on tables for performance improvements.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

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

Confidential, Bridgeton, NJ

Oracle PL/SQL Developer

Responsibilities:

• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in reports to improve performance dramatically.
• Tuned and optimized the complex SQL queries.
• Had to design database model risk management application.
• Worked with Business users to gather requirements for developing new Reports or changes in the Reports.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Generated fully functional Microsoft Excel Spreadsheets using PL/SQL directly from the database.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Performed ETL using Informatica Powercenter.
• Created Cursors, Collections and DB Triggers.
• Created INDEX BY Table Method to Fetch Records in Random Selection.
• Fine-Tuned and optimized number of SQL queries and performed code debugging using TOAD.
• Set up batch and production jobs through Tidal.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Tuned SQL queries, performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from tables.

Environment: Oracle 10g/11g, SQL, PL/SQL, SQL*LOADER, Oracle 10g RAC, Forms 10g, Reports 10g, ERWIN 7.x, Informatica Powercenter, SQL Developer.