SUMMARY:

• More than 10 years of extensive work experience with Oracle 9i, 10g, 11g, PL/SQL, TOAD, SQL* PLUS and SQL*Loader, developing back - end modules for multi-tier business applications, both Data Warehous ing and OLTP systems, in SQL and PL/SQL.
• Comprehensive Experience in various types of oracle technology based projects in multi-tier environment for sectors like Banking, Insurance and Healthcare .
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
• Extensive Experience in building Database architecture and models.
• Excellent knowledge of data warehousing concepts like star schema and snowflake schema, data marts used in relational and dimensional modeling
• Rich experience in ETL mappings, analysis and documentation of OLAP requirements.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Well-versed in UNIX scripts for executing various concurrent jobs and data migration and set Cron tab for repetitive database processes.
• Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and plans.
• Strong development and support knowledge on Oracle, SQL, PL/SQL programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views
• Rich experience in developing stored procedures using advanced PL/SQL Packages, Index Tables, VArrays, Record Types, and Dynamic SQL
• Solid experience in batch processing techniques: bulk collect, bulk bind, FORALL
• Expertise in Optimizing Database performance , Hints, Indexing , Materialized View , Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.
• Expert in Performance Tuning, using various Oracle utilities, including Explain plan, hints, SQL Trace, and DBMS. Profiler to identify bottlenecks and provide solutions
• Proficiency in ETL tools like SQL*loader, Informatica
• Great experience in several Oracle provided packages such as UTL FILE and DBMS JOB
• Proficient in documenting business rules, functional and technical designs, test cases, and user guides
• Excellent writing, presentation, documentation and communication skills for management development.
• Highly self-motivated, strong software background and ability to take challenges.

TECHNICAL SKILLS:

Databases: Oracle 8i, 9i, 10g, 11g, Oracle RAC

Languages: SQL, PL/SQL, Java J2EE

Operating Systems: Windows, Linux, Unix, Shell

DB Dev. Tools: TOAD, SQL Developer, SQL*Plus, SQL Loader, Warehouse Builder

PROFESSIONAL EXPERIENCE:

Confidential, New York

Senior Oracle PL/SQL Developer

Responsibilities:

• Participated in design discussions with the application architects and suggested design changes for improving database performance .
• Was involved in all phases of application development: analysis, design, development, and testing.
• Developed stored packages, procedures, and functions for data transformation
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Analyzed the data needs for customized reports.
• Mapped data requirements developing Stored Procedures, Functions, Views, Materialized Viewand Triggers .
• Conducted Oracle Performance tuning using SQL Trace and EXPLAIN PLAN.
• Applied ETL methodologies including data extraction and loading with SQL Loader.
• Extensively used PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Created and modified several views on tables which will be populating Warehouse system.
• Involved in creation of aggregate materialized views on Data Warehousing.
• Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.
• Extensively used advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader
• Wrote the shell scripts and scheduled with using cronjob for the database backups and old archive log deletion.
• Worked on Slowly Changing Dimensions to handle the incremental load of Dimension data.
• Performed Data Quality Analysis to reconcile and determine cleansing requirements.
• Worked with Bulk Collects to improve the performance of multi-row queries
• Participated in Functional Testing and Unit Testing.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.

Environment: UNIX, Oracle 11g, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, Toad, Java J2EE .

Confidential

Oracle P/L SQL Developer

Responsibilities:

• Responsible for analysis, design, development, and testing of the application.
• Created table definitions, indexes, primary and foreign keys, constraints, triggers, functions, views, procedures and data to Oracle using SQL Developer.
• Analyzed and designed tables based on small and large database transactions .
• O ptimized SQL queries tuning by analyzing different query options and indexing strategies.
• Used SQL*Loader utilities to Export and Import Large Volumes of Data in the Excel Sheets into the Tables.
• Extensively worked on cursors and ref-cursors for processing the data.
• Extensively used indexes for fine tuning and optimizing SQL and PL/SQL queries.
• Made use of With clause to make complex SQL statements simple and make them more efficient
• Extensively worked on PL/SQL Error/Exception handling.
• Created and Modified primary database objects, such as Triggers, Procedures, Functions, P ackages and bulk collections using PL/SQL.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using PL/SQL to enhance read operation.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Used DBMS SCHEDULER to set batch jobs for processing large amount of data in parallel.
• Worked with performance tuning tools like Oracle optimizer, explain plan, and hints

Environment: UNIX, Oracle 10g/11g, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, Toad, Java J2EE

Confidential

Oracle Developer

Responsibilities:

• Involved in DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
• Involved in ETL jobs to extract, cleansing, transforming, integrating and loading data.
• Analyzed the sources, transforming data, mapping the data and loading the data into targets using Informatica
• Developed ETL mappings, transformations using Informatica Power Center 8.1.
• Involved in documenting users requirements, technical specifications and Reporting manuals.
• Automated loading and processing of servicer provided Loss Mitigation data that was provided from servicer portal.
• Created various PL/SQL packages, procedures and function.
• Created triggers on database objects to perform automatic updates and insertions in OLTP .
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Enhanced performance of large complex SQL queries using explains plan, indexes and hints.

Environment: Windows XP, Oracle9i, PL/SQL, HTML, Informatica Power Center 8.1, Java, Unix, Linux.

Confidential, Cincinnati, OH

PL/SQL Developer

Responsibilities:

• Gathered business requirements
• Creating database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating and working with GTT (Global Temporary Table)
• Used set operators in PL/SQL like Union, Union all, Intersect and Minus
• Worked with packages like DBMS UTILITY.FORMAT CALL STACK&DBMS UTILITY.FORMAT ERROR STACK
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance

Environment: Oracle 9i, Windows, PL/SQL, SQL Loader, Shell Scripting, Crystal Reports 11.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in developing a platform of databases supporting supply chain management, order management, inventory, Data warehousing management system, and purchasing.
• Created DDL scripts, Created database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Created stored database procedures, packages, function, triggers, tables, views, constraints, foreign keys and indexes using Oracle 9iacross the application for manipulating data.
• Used ETL to load data into SQL Server database from Oracle database.
• Utilized SQL*Loader to load flat files database tables.
• Used triggers for automatic audit creation for all the major master databases.
• Designed and implemented error checking and correction protocols and programs.

Environment: Oracle9i, Oracle PL/SQL, SQL*Loader