SUMMARY

• Over 5 years’ experience as Oracle PL/SQL Developer, Database Maintenance, Coding, Design, testing Methodologies and Production Support using Oracle 8i, 9i, 10g & 11g 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.
• 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
• Solaris 8/9/10
• AIX 7.1
• Red Hat LINUX
• ORACLE 9i/10g/11g
• MS Access
• MS Excel (VBA)
• SQL Server 2005/2008
• Oracle Developer suite 9i/10g/11g
• ERWIN 7.x
• TOAD 10.6
• SQL Developer
• SQL*PLUS
• SQL*LOADER
• PVCS
• MS Visio
• Oracle Forms 6i/9i/10g
• UNIX Shell Scripting
• MS-Outlook
• IBM Lotus Notes
• HTML
• CSS.

PROFESSIONAL EXPERIENCE

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.
• 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, SQL*Plus

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.
• 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.
• 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 11g, SQL, PL/SQL, SQL*LOADER, Oracle 10g RAC.

Confidential, New York City, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed and reviewed Business Requirement and Functional Requirement documentation. Converted User Requirements into formal Technical specification and Interfacing with clients.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers.
• Created custom functions, stored procedures, packages, database triggers to retrieve the data from data base.
• Written complex SQL statements using joins, sub queries, and correlated sub queries.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas
• Involved in Performance Tuning of the application using Explain Plan, Hints and TKPROF
• Involved in optimization process through creation of partition tables, views, indexes etc. Also tuned and optimized SQL statements.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Built process to write CSV files to load in third party applications and Parse CSV files using EXTERNAL TABLES and load them
• Develop on demand refreshed materialized views to reduce network latency in distributed SQL queries
• Document technical specifications for future reference and technical manuals for users to deploy process on remote databases
• Develop scripts to deploy jobs using oracle DBMS SCHEDULAR to gather statistics on regular intervals to get better Execution plans

Environment: Oracle 10g, UNIX, Windows, Export/Import, SQL Developer, SQL *Loader, MS Office

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions
• Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Optimized critical queries to eliminate Full Table scans.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Gathering and Analyzing Business requirements with product management for new release cycles
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: Oracle, Sun Solaris with Windows, XML, SQL, SQL*Plus, PL/SQL, SQL*Loader, Export/Import, TKPROF, Apache, Oracle Web Application Server, CVS, Toad.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the data transfer and creating tables from various tables, coding using PL/SQL, packages, stored procedures and triggers.
• Coordinated with DBA in creating and managing tables, indexes, db links and privileges.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Developed screens and reports using Oracle Forms/Reports 6i/9i and PL/SQL.
• Utilized SQL*Loader to load flat files database tables.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Responsible for performing code reviews.
• Developed user documentation for all the application modules.

Environment: Oracle 9i, PL/SQL, SQL*PLUS, SQL, TOAD, C, SQL*Loader, Forms 6i, Reports 6i.