SUMMARY

• Around 8+ years of experience in Application development and Production support using Oracle SQL, PL/SQL.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
• Extensively worked in Client - Server application development using Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Experience in ETL transformations using Oracle Data Integrator 12g.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Carried out testing in test database for upgrading/migrating from Oracle 9i to Oracle 10g.
• Experience in developing logical and physical database design, data modeling using Erwin & Informatica (Power Center 6.1).
• Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects.
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, Hints in Oracle 9i.
• Experience in Installing Software’s and Configuring Databases.
• Experience in UNIX Shell Scripting for batch processing.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

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

Oracle Tools: SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g), SQL*Plus, Discoverer, Power Builder 12.

ETL Tools: Informatica Power Center 8.6.X/6.1, Datastage

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, C, C++,Java, HTML,XML

Environment: Sun Solaris 2.6/2.7/2.8/8.0, Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Chelsea, MA

SQL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the lower environments to the Production database.
• Performed Extract, Transform and Load operating for processing the legacy data.
• Designed and developed Business Rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated job to clear the generated worksheets based on user-defined risk engine and clearance rules.
• Created Dynamic SQL queries to retrieve large amounts of data, which run with optimal performance and easy maintainability.
• Extensively used Global Temporary Tables for data processing both staging and session based.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Developed Mappings, reusable mappings, scenarios and load plans to automate the loading process.
• Created Packages for custom designed functionality using 3rd party tools like TOAD and Oracle SQLDeveloper.
• Utilized standard Change Management techniques using Rational’s ClearCase and ClearQuest Tools.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handling the defects using Clear Quest from the user applications based on the priority level.
• Used Exception Handling extensively to debug and log/display the error messages in error logging tables or the application respectively.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: OracleODI 12g, Oracle 10g/11g, Toad, SQLDeveloper, PL/SQL Developer, Perl, UNIX Shell Scripting, Rules Engine, Rational Clear Case and PAC 2000 Tool.

Confidential, Charlotte, NC

Oracle SQL, PL/SQL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the lower environments to the Production database.
• Developed an automated process that generates Audit Tables, Triggers, sequences, Grants and Synonyms for a particular table.
• Designed and developed Business Rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated job to clear the generated worksheets based on user-defined risk engine and clearance rules.
• Created Dynamic SQL queries to retrieve large amounts of data, which run with optimal performance and easy maintainability.
• Extensively used Global Temporary Tables for data processing both staging and session based.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Used UTL FILE package to extract and write data from OS files to TEXT/CSV file formats.
• Created automated jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking PL/SQL Procedures.
• Created Packages for custom designed functionality using 3rd party tools like TOAD and Oracle SQLDeveloper.
• Utilized standard Change Management techniques using Rational’s ClearCase and ClearQuest Tools.
• Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handling the defects using Clear Quest from the user applications based on the priority level.
• Used Exception Handling extensively to debug and log/display the error messages in error logging tables or the application respectively.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g/11g, Toad, SQLDeveloper, PL/SQL Developer, Perl, UNIX Shell Scripting, Rules Engine, Rational Clear Case and PAC 2000 Tool.

Confidential, NEWPORT NEWS, VA

Oracle SQL, PL/SQL Developer

Responsibilities:

• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Developed validation stored procedures and triggers to facilitate consistent data entry into database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes and synonyms.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Used UNIX Shell Scripts to automate backend jobs.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Used performance tuning utilities like EXPLAIN PLAN to improve the performance by reducing the run time of queries on the database.
• Based on the data loaded in the target database (oracle) various business reports are developed.
• For the reporting purpose extensively used REF cursors.
• Wrote complex SQL queries using Joins, Sub queries, Inline views and Group functions.
• Worked as an application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
• Trouble shooting performance issues within packages using DBMS OUTPUT
• Coordinating with the business users for System Test and User Acceptance Test.
• Developed scripts for validating the UAT deployment for the schema objects.
• Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting.

Environment: Oracle 11g, Oracle Application Servers, UNIX Server 4.3, Power Builder 12, Windows NT, SQL*LOADER, and TOAD.

Confidential, Dallas, TX

Oracle SQL, PL/SQL developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to develop interfaces to transfer the data from the intermediary database to the main database.
• Designed and Developed several reports using Oracle Reports 10g.
• Developed Procedures, Functions and Triggers to be implemented in the Reports.
• Created UNIX Shell scripts for automating the execution process and ftp the files to several UNIX servers.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes and materialized views and also by making use of Hints and EXPLAIN PLAN and TKPROF.
• Created Dimensional Data model in data warehouse using the star schema.
• Used ETL process to identify the new or the changed data in order to make better decisions in the project.
• Involved in storing and tracking changes to the individual files using PVCS to manage and monitor the project and maintain versioned work files.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Used Exception Handling extensively to display the error messages in the application.
• Involved in transferring the files from Windows environment to UNIX environment to be used by the host application/programs.
• Involved in creating Test Cases for the Reports based on detail design.
• Involved in creating Design and Technical Specifications (DATs) for each of the reports developed using Reports Builder 10g.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, Oracle Developer Suite 10g, PL/SQL Developer, Pro*C, SQL *Plus, LINUX shell script, Serena PVCS- project version control system, Reflection for UNIX and Digital.

Confidential, SAN FRANCISCO, CA

Oracle SQL, PL/SQL developer

Responsibilities:

• Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company’s education system.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created complex Stored Procedures and Views to be used for the Reports.

Environment: Oracle 11g/10g, Oracle REPORTS Developer (11g), UNIX Server 4.3, Rational Clear Quest, and TOAD, SQL NAVIGATOR.

Confidential

Oracle SQL/ PL-SQL developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Incorporated bulk incremental inserts in PL/SQL procedures.
• Created Database Trigger to audit search events.
• Embedded SQL queries in PL/SQL procedures and ran them dynamically.
• Operated BLOBS, CLOBS and BFILES using PL/SQL (DBMS LOB) packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Developed Java Stored Procedures and loaded Java Classes into Oracle.
• Designed Data Model Diagram using Designer 10g.
• Designed and Developed logical and physical database using Designer 10g.
• Created views, table, sequences, indexes and synonyms database objects.
• Created partitioned tables and indexes.
• Tuned PL/SQL packages to improve performance of the application.
• Created User Interfaces for search functionality using Oracle FORMS 10g.
• Created Menus, Object Libraries, and Properties Classes and integrated in application using Oracle FORMS 10g.
• Created and developed REPORTS for financial reporting using Oracle REPORTS 10g.
• Created Designed Documents and technical documents.

Environment: Oracle 9i/RAC, Oracle FORMS 10g, REPORTS 10g, Designer 10g, TOAD,SQL DEVELOPER, UNIX SHELL Scripting.