PROFESSIONAL SUMMARY:

• 8years of overall IT experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Over 2 years of experience in using Informatica 9.5.1.
• Utilized transformations like Router, Expression, Update Transformation, Sequence Generator, Filter, Aggregator, and Lookups.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Expertise inSQL and PL/SQL programmingand strong Knowledge onoracle architecture and database design.
• Excellent working experience in Property & Casualty Insurance domain.
• Good Knowledge in Relational Data Modeling.
• Strong knowledge ofOracle 9i/10g/11g.
• Excellent Analytical, conceptual and root cause analysis and problem solving skills.
• Strong Experience in designing and developing oracle objectsTables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Strong knowledge inOracleCursor management, Exception Handling,REF Cursors
• Worked on advancedPL/SQLconstructslike Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Experience inPL/SQLcollections, Bulk collections and Exception handling.
• Extensively worked with variousSQL scriptsfor relational databases.
• Knowledge of working with theOracle Application serverfor theForms and Reportsapplication in various projects.
• Extensively worked onPL/SQLfeatures likeForms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
• Experience in designing and developing various reports usingOracle Reports
• Good understanding ofOracle Data Dictionary, RDBMS and Normalizationtechniques.
• Experience with database query optimization andperformance tuningusingExplain Plan, SQL - Trace, TK-Proforacle utilities and creating relevant system and users documentation
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing usingData Extraction, Data Transformation and Data Loading (ETL)
• Familiar with Slowly Changing Dimensions Type1, Type2 and Type3.
• Experienced inUnit testingandIntegration Testingwith excellent debugging skills.
• Ability to programUNIX shell scriptsin applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Great Team player with Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus

Tools: PL/SQL Developer, SQL Developer, Forms10g/9i/6i, TOAD, Oracle Enterprise Manager, Informatica 9.5.1

Operating Systems: UNIX, Windows NT/2000/2003/XP/7

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

Version Control: Visual Source Safe (VSS), Tortoise SVN

Defect Tracking: Rational Clear Quest, LANdesk, JIRA

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing.
• Participated in system analysis and data modeling, which included creatingtables, views, indexes, synonyms, triggers, functions, procedures, cursorsandpackages.
• CreatedIndexes and sequencesfor faster retrieval of the visitor information.
• Worked withBulk Collect & Bulk Bindto improve the retrieval of multi row.
• ImplementedJoinconditions, group byfunctions, correlated subqueries, nested subqueries.
• Createdprocedures and functionsfor validation of transaction records into interface tables.
• Database security by authenticating users, using logon triggers.
• Created indexes on tables and optimized procedure queries.
• Design few pages using HTML and XML to interact with database.
• Used several Oracle provided packages such asUTL FILE, DBMS JOB, and DBMS SCHEDULER
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Involved in writing technical documentation, and writing test plan.

Environment:UNIX, Oracle 11g, TOAD, PL/SQL, SQL*Plus, SQL Developer, FileZilla, MS Project 2010.

Confidential, Jacksonville, FL

Sr. Oracle 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.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages according to the new business measures.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Wrote complex SQL queries usingJoins, Sub queries and Group functions.
• Executed PL/SQL blocks usingcursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Worked onpackagemore than 15000 lines.
• Good experience in communicating with offshore team.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Trained business & IT users on various modules like Application entry, issuance, endorsements, rating, cancellation, billing system.

Environment:UNIX, Oracle 11g, TOAD, PL/SQL, SQL*Plus, SQL Developer, FileZilla, MS Project 2010, Sharepoint, Webservices, JBOSS, Apache, Eclipse, SOAP UI.

Confidential, Morristown, NJ

Oracle PL SQL Developer, Informatica 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 stored procedures and triggers to facilitate consistent data entry into database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• UtilizedInformaticato load flat files database tables.
• Initialized utilization ofData WarehouseETL software during conversion of data to Oracle DB.
• UsedUNIXShell Scripts to automate backend jobs.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Used performance tuning utilities likeEXPLAIN PLAN, SQL Trace and DBMS PROFILERto improve the performance by reducing the run time of queries on the database.
• For the reporting purpose extensively usedSQL Scripts.
• Wrote complex SQL queries usingJoins, Sub queries and Group functions.
• Involved in modifying various existingpackages, procedures, functions and triggersaccording to the new business measures.
• Executed PL/SQL blocks usingcursors, 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.
• UsedMaterialized viewsin order to improve the performance.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• 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 forDocumentationof all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Handling every week’sproduction deployment.

Environment:UNIX, Oracle 11g, TOAD, PL/SQL, SQL*Plus, SQL Developer, FileZilla, MS Project 2010.

Confidential, Mineola, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed variousPL/SQL stored procedures and functions
• Implemented various Data Transformations usingSlowly Changing Dimensions
• Developed back end interfaces usingPL/SQL Stored packages,Procedures, Functions, Collections, Object Types, Triggers.
• DevelopedPL/SQL Proceduresat the database level that were used in the mappings throughStored Procedure Transformation.
• Responsible forSQL tuning and optimizationusingExplain Plan, TKPROFutility and optimizer hints
• UtilizedSQL*Loaderto load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulatedprocedures, functions and packages;ensured that the quality, programming and project management standards were met.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table
• Used Bulk Collect feature to improve performance.
• Created indexeson tables for fast retrieval of data.
• Developed Complex SQL queries using variousJoins, Sub-Queries, Analytical and Group Functionsand developed various dynamic SQL’sthorough out the projects.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages likeDBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
• Designing and rebuilding indexes for faster overall data processing.
• Gathering the requirements through meetings with the Business Users
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Test case/data preparation, execution and verification of the test results.
• Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment:UNIX, Oracle 11g, TOAD, PL/SQL, SQL*Plus, SQL Developer, FileZilla, MS Project 2010.