SUMMARY:

• An IT professional with more than 8 years of experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
• Extensive experience in complex backend data ETL (extraction, transformation and loading operations) on oracle using SQL*Loader.
• Extensive experience in creating XML files to store data and making them available when necessary.
• Strong domain knowledge inFinance & banking, Health Careand Insurance industries.
• Strong work experience in Query construction, Stored Procedures, Triggers and User Defined Functions using SQL, PL/SQL.
• Mastery of PL/SQL programming, using features such as Records, Collections, Exception Handling, Triggers, Bulk Bind, Ref. Cursors, and Dynamic SQL.
• Over 5 years of experience in UNIX Shell - Scripting.
• Expert knowledge of new features in Oracle 11g, such as Virtual Columns, Interval Partition, Result Cache, Flashback Table queries.
• Extensively used EXPLAIN PLAN, Hints, SQL TRACE, TKProf, DBMS PROFILER and DBMS TRACE for SQL query tuning and PL/SQL blocks.
• Experience inOracle backups, generally throughExportandImportutilities (Full, User, and Table).
• Expertise in Data Migration usingDatabase link, SQL*Loader and UTL File Utilities.
• Experience in using ERWindata modeling tool for creating data models and relational schema.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Experience in database administrative tasks like installation and configuration of database, creating database, partitioning of database, creating indexes.
• Experience in creating mappings using Informatica.
• Self-motivated with good analytical, problem solving and presentation skills.
• Excellent team player with enthusiastic, strong initiative and ability to accept responsibilities and meet tough deadlines.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Scripts, C, PHP.

RDBMS: Oracle 11g/10g/9i/8i/8.0/7.0, MS-SQL Server 2000/2005, MySQL.

ETL Tools: Informatica 9.5, IBM Datastage.

GUI: Oracle Forms & Reports 11g, SQL*Loader.

Database Tools: SQL PLUS, TOAD, and SQL developer.

Operating Systems: Windows XP/7, Windows Server 2008 and Linux (Redhat/Ubuntu).

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed data needs for customized reports and mapped data requirements.
• Developed Stored Procedures, Functions, Views, Materialized View and Triggers.
• Utilized database links to accommodate cross-database transactions.
• Worked with Bulk Collect to improve teh performance of fetching data.
• Handled errors using Named System Exceptions such as INVALID NUMBER, NO DATA FOUND and ZERO DIVIDE.
• Created aggregate materialized views in Data Warehouse.
• Worked on Oracle Performance tuning using SQL TRACE and EXPLAIN PLAN.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Used SQL*Loader and external table to successfully massive data migration.
• Used AUTONOMOUS TRANSACTION PRAGMA in teh framework procedures to log teh status when error occurred.
• Extensively used PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Performed Unit Testing on teh scripts and ensured all teh exceptions were handled according to teh business logic.
• Worked on Slowly Changing Dimensions to handle teh incremental load of teh Dimension data.
• Participated in design discussions with teh application architects and suggested design changes to improve database performance.
• Wrote complex queries and sub queries to do analysis work and generated reports to validate results.

Environment: Oracle 11g, UNIX, TOAD, PL/SQL, SQL*PLUS, SQL, SQL*Loader.

Confidential, Hartford, CT

Oracle PL/SQL - ETL Developer

Responsibilities:

• Involved in maintaining and updating teh procedure for ETL process.
• Responsible for requirements gathering, analysis, design and development of any enhancements in teh application.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet teh business requirements and update teh existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, and synonyms to meet teh business requirements.
• Modified existing SQL code.
• Executed upload and load procedures to check teh data feed was loaded correctly into teh tables.
• Wrote UNIX shell scripts to automate processes like data load and sent notification mails.
• Modified teh existing forms and reports and registered those in teh application.
• Modeled teh Data Warehousing Data marts using Star Schema.
• Directly interacted with users and helped in teh development of functional specifications.
• Coordinated with teh front-end design team to provide them with necessary stored procedures, packages and necessary data.
• Wrote technical specifications for all teh procedures developed in teh module. Maintained log files during analysis and reported any performance defects subsequently.
• Provided knowledge to other team members about teh new technology and allocation of tasks to teh team.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 11g, UNIX, Erwin, SQL* Plus, and Oracle Forms.

Confidential, Blue Bell, PA

Oracle PL/SQL Developer

Responsibilities:

• Created data warehouse objects - Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures with parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading (PEL).
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Extracted data into Oracle table using SQL*Loader.
• Used Bulk Collect, Bulk Binds to improve performance by minimizing teh number of context switches between teh PL/SQL and SQL engines.
• Developed and modified PL/SQL packages, functions, and procedures.
• Wrote complex SQL script, analytical function.
• Improved query performance by query optimization - tracing teh query execution plan (explain plan).
• Used job scheduling tool like Cron job.
• Created SDLC Documentation.
• Prepared Shell scripts for ETL to run in batch.
• Did analysis and functional design, along with a thorough knowledge of relational database concepts and design.

Environment: Oracle Application Server 11g, TOAD, UNIX.

Confidential, East Hanover, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing and developing data warehouse for teh corporate data repository.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Defined indexes on various tables to improve teh performance of teh queries for reporting purpose.
• Developed SQL* loader scripts to load data in teh custom tables.
• Run batch jobs for loading database tables from flat files using SQL* Loader.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Developed and optimized of SQL queries using TOAD, Explain Plan utilities.
• Involved in debugging and tuning teh PL/SQL code, tuning queries, optimization for teh Oracle database.
• Tuned SQL queries and performed refinement of teh database using tools like EXPLAIN PLAN and TKProf to improve teh system response, time and efficiency significantly.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Gathered teh requirements from teh users and analyzed their business needs and created SRS documents.
• Worked closely with users and developers team to resolve issues in teh developed reports.

Environment: Oracle 10g/11g, SQL, PL/SQL, SQL*Plus, SQL* Loader, TOAD, Erwin 7.2, UNIX, Shell scripts.

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Gathered development requirements from client’s functional team and functional design specification documents.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Performed logical database design.
• Responsible for teh development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement.
• Optimized teh Oracle PL/SQL queries by Performance Tuning.
• Fine-tuning of PL/SQL Stored Procedures using Hints in EXPLAIN PLAN.
• Worked on enhancement of existing pipelined functions and packages.
• Authored teh technical design documents for teh given functional design.
• Responsible for developing technical components for teh following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, Upc Resolve, Scope Resolve, View/SubTotal Resolve, Hierarch Resolve.
• Tested codes developed by self and team.
• Fixed bugs while in production with top priority.

Environment: Oracle 10/11g Database, PL/SQL Developer-5.1, SQL*Loader, TOAD.