PROFESSIONAL SUMMARY

• Over 8 years of experience in Database development using Oracle, SQL, PL/SQL and Oracle Developer Forms and Reports.
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding, integration and system testing.
• Extensive experience in analyzing business requirement and converting them into efficient technical solutions.
• Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like cursors, collections, Exception Handling and good in developing Developer Forms and Reports.
• Experience in Database design using Normalization and ER Diagrams.
• Experience in loading data from sub systems using SQL * Loader, External tables and UTL FILE.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, TKPROF, Oracle hints, DBMS PROFILER, DBMS STATS.
• Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and Level3 Production system support.
• Good understanding of Relational database design and developed various data models using Erwin.
• Extensively worked with third party database tools like TOAD and SQL Developer
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data,
• Preparation of Architectural blueprint documents, High Level Design documents, Technical Design documents, Unit Test plans.
• Experience of working on different flavors of UNIX.
• Experienced in Unit testing and Integration testing with excellent debugging skills.
• Strong individual contributor and a good team player with proven abilities to interact negotiate and communicate with peers and clients.
• Assist with resolving complex Post 11g migration maintenance and testing issues with various industries.
• Extensively used Oracle Enterprise Manager - Database Control, 10G Grid control for monitoring and tuning the databases.

TECHNICAL SKILLS

Front End Tool: Oracle Developer 2000 (Forms 10g/6i, Reports 10g/6i)

RDBMS: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting

Database Tool: Toad, SQL Navigator, Rapid SQL, PL/SQL Developer, SQL Developer, SQL*Loader

Application Server: IIS 5.0, Oracle 9iAS/10gAS

Designing/Other Tool: MS - Visio, MS-Office

Operating Systems: Windows, UNIX, Linux

Retail Package: Oracle RMS

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, Iowa

PL/SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like TOAD.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Schedule Autosys jobs through inserting, deleting and updating jobs in various development instances.
• Created new JILS and Calendars to automate holiday schedules vs. placing streams on ICE and or HOLD.
• Designed Autosys JILS to schedule jobs.
• Performed conversions of Data Stage jobs to PL/SQL packages for higher performance.
• Involved in UAT testing, Bug fixing and Production move.

Environment: Oracle 11g, TOAD, Tortoise SVN, PL/SQL, SQL, SQL*PLUS, UNIX, PERL, AUTOSYS.

Confidential, Jacksonville, FL

PL/SQL Developer

Responsibilities:

• Worked on Estimation of CRs for Revenue Estimation and Group Settlement (REGS) application.
• Worked on preparation of Technical Design Document and UTC of REGS CRs.
• Prepared Technical workflow for REGS batch jobs.
• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• Designed a workflow management system to streamline the process. Used cursors and parameter passing with PL/SQL tables and data types, cursors Responsible for creating Data change. String Testing before deployment to production.
• Responding to Remedy case assigned by help desk.
• Designed and developed PL/SQL stored procedures, functions and database triggers required in the application.
• Used cursors and parameter passing with PL/SQL tables and data types, cursors.
• Worked with built in Oracle Packages (DBMS SQL, DBMS OUTPUT, DBMS XML and others).
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Scheduled oracle jobs through DBMS SCHEDULER.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Prepared Build and Unit Testing of Portal Data Differential CR.
• Provided Oracle and support to team members of current project.
• Coordinate with Onshore and Offshore team members.
• Reporting to client, Onsite Project Manager and Offshore Project Manager.

Environment: Oracle 11g, Oracle PL/SQL, SQL Navigator, UNIX.

Confidential, Valley View, OH

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed Shell Scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, KORN Shell script, SQL developer, Oracle Forms 10g, Reports10g.

Confidential, Grand Rapids, MI

PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Co-ordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Implemented Complex business Logic as per the client requirement in procedures, functions, packages.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Responsible for data migration from MS Access to Oracle 11g.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used PL/SQL tables, pragma autonomous transaction to avoid mutating problem in database trigger.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Wrote SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Managed problems, enhancement, and new functionality requests to meet changes in the business needs.

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

Confidential, Atlanta, GA

PL/SQL Developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Implemented Complex business Logic as per the client requirement.
• Prepared daily reports from the invoice data received for different department like sales, marketing.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Developed Reports to extract the monthly sales information.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• 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) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL, SQL*Loader, Reports, TOAD.

Confidential, Bridgewater, NJ

PL/SQL Developer

Responsibilities:

• Customized and developed Oracle Forms and Reports using Oracle Forms 9i and Reports 9i.
• Interacted with the business users and collected the requirements, Evaluated the feasibility of the requirements by analyzing the source systems.
• Involved in database development by creating PL/SQL Functions, Procedures, Triggers, Packages and Materialised views.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying error messages in the application.
• Analyzed existing Excel reports and developed replacements using Report9i.
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Created Unix Shell scripts for automating the execution process.
• Performed the data migration using SQL* loader.
• Developed new reports and customized existing according to the requirements.
• Responsible for data migration from Production to Test and created test data for analyzing problems and providing solution.

Environment: Oracle10g, SQL, PL/SQL, SQL Developer, SQL*Plus, Reports9i, Forms9i, Toad, UNIX Shell Scripts.

Confidential, Minneapolis, MN

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System design documents, Flows, Test Plan preparations and Development of Business Process and Work Flow charts.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Created Materialized views to calculate aggregated data, such as Sum of monthly revenue.
• Developed complex ORACLE stored procedures and packages to calculate borrower's debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed / modified PL/SQL code like stored procedures, packages for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Supported DBA team for the data migration from oracle 9i to 10g.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 9i (SQL, PL/SQL), SQL *loader, Toad 9.0.1, Forms/Reports 6i, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 9i.
• Created Control Files and used SQL* Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Involved in database Performance Tuning and monitoring.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Oracle 9i, SQL*Plus, SQL, PL/SQL, MS Office, MS Access, UNIX, Windows XP.