PROFESSIONAL SUMMARY:

• Over 11 years of extensive experience in Database Design, Data Architecture, Application Development and Database Administration using ORACLE 9i/10g/11g RDBMS.
• Functional areas of expertise include database design for large scale data - driven OLTP and OLAP applications including entity-relation modeling, ETL Process design and business intelligence (BI).
• Extensive business domain experience in Financial Services, Property and Causality (P&C) Insurance and HealthCare Management Industries and concepts such as HIPAA, TPA and Risk Management.
• Expert skills in Oracle SQL, PL/SQL, Database design including Schema design and table design, packages, stored procedures, triggers, views, indexes and database links and managing very large tables.
• Very proficient in Performance Tuning, Data Warehousing, ER & Dimensional Data Modeling, ERWIN Tool, Oracle Data Pump, Import & Export and UNIX shell scripting.
• Excellent expertise in SDLC including code development, testing, implementing, maintenance and implementing Java and .NET applications interfacing wif large scale Oracle databases.
• Extensive experience in using Oracle tools like SQL*Loader, IMP/EXP utilities, EXTERNAL tables, Materialized views, PL/SQL collections and records and performance tuning tools like EXPLAIN PLAN, HINTS, AUTOTRACE, DBMS PROFILER etc.
• Experience in migrating database application objects and data from SQL server 2008 R2 database to Oracle database and programming using T-SQL.
• Experienced wif Oracle high performance Oracle tuning techniques including bitmapped indexes, partitioning, partition pruning, local indexes, bulk loading, table space and I/O balancing and clusters.
• Worked on System Study & Analysis, Reverse & Forward Engineering of database and User Interface (UI) development using Oracle Mod PL/SQL web component programming using Java Script and HTML on Oracle Application Server environment
• Hands on experience in design, development of Complex Batch Jobs, custom ETL solutions and adaptation of technical solutions to complex business situations and strategies.
• Experience wif application DBA activities including Performance tuning; job scheduling using DBMS SCHEDULER and monitoring using Oracle GRID Control/OEM.
• Strong knowledge and experience in database architecture, db engineering and database administration (Oracle Server Architecture, SGA, Oracle Internals, Background Processes and implementing applications on RAC infrastructure).
• Worked wif XML, XSD, XSLT and DTD data feeds either to develop from source to relational targets and relational sources to XML data feed file formats.
• Extensive experience in Designing, Planning & Successfully delivering high quality Applications thru Onsite/Offshore Delivery Model.
• Successfully managed software development teams, technical lead for more TEMPthan 4 years, demonstrated skill in assimilating new concepts and technologies and capitalizing on teh primary competencies of teh development team.
• Good team player wif organized working habits, ability to multitask, easy adaptability and accessibility to any environment.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g RAC and Oracle 11g, SQL Server 2008 R2

Data Modeling: ERwin 7.3, ER/Studio, Visio, Logical and Physical Data Modeling

Data Warehousing: Informatica Power Center 7.1, OLAP, OLTP, Oracle Discoverer

Programming Languages: SQL, PL/SQL, MOD PL/SQL, Java

Tools and Utilities: SQL*PLUS, SQL*LOADER, SQL Navigator, Toad, TKPROFAutomatic Workload Repository (AWR), Oracle OEM/GRIDPVCS Tracker, SVN, Citrix, Autosys and Control-M

Operating Systems: UNIX, LINUX, Windows95/98/2000/XP

Internet Technologies: Java Servlets, JSP, JavaScript and HTML

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Oracle Developer / Data Architect

Responsibilities:

• Architected OLTP Erwin Data Model using consistent naming conventions and data types to enhance usability, productivity, and data integrity.
• Worked closely wif Middle-tier, Front-end, Account Management, Operations, Product, QA, and DBA groups to define product features, devise production build plans, strategize database capacity and performance, and to design interfaces between tiers.
• Set PL/SQL coding standards and conducted code reviews wif Oracle developers to increase maintainability and ensure accuracy.
• Assisted DBA for job scheduling, data loading, and performance tuning using ORM, Sql tuning/access advisor, hints, explain plan, SQL trace and V$ performance views under Unix .
• Created Oracle PL/SQL packages and designed stored procedures to process complex business logic in performance oriented approach.
• Tuned Oracle queries using Explain Plan and SQL Trace.
• Heavily involved in conversion of data and processing logic from legacy application which is in MS SQL server to Oracle database.
• Designed scalable batch process for loading data into snapshots using Materialized views for clinical R&D team reporting analysis purpose.
• Working wif teh web team to design, develop and test web-based reports.
• Heavily involved in creating oracle packages, indexes, procedures, partitions, functions, triggers, object, collections, views etc as a part of teh development effort.
• Performance tuning queries dat are used by ETL processes, data loads and report generations.
• Designing, coding and testing teh actual system dat would do teh conversion using PL/SQL. This included a large number of packages, procedures and functions and SQL scripts.

Environment: Oracle 11g/10g RAC, SQL Server, ERWin, PL/SQL, VB .Net, Java, SQL Navigator, AUTOSYS, UNIX, TOAD, SQL Developer, SVN Version control

Confidential, Hartford, CT

Technical Lead / Senior Oracle Developer

Responsibilities:

• Gathering system requirements and functional inputs from business users.
• Assisting teh application architecture team in teh design of teh data model using oracle 10g features and advanced techniques.
• Lead teh team of four Oracle developers in system development and customization.
• Creating common batch utility packages and non-functional utility packages.
• Mentoring junior team’s members teh coding standards and best practices to follow.
• “Go to” person for wealth of platform knowledge.
• Implementing Oracle flash back technology in teh application and SCN capture points.
• Implemented scalable application on Oracle Real Application Clusters (RAC) on Oracle 10g R2 environment.
• Implementing transformation mappings as per mapping document.
• Designed partitioning methods and implemented Oracle Partitioning for teh RMIS application.
• Implemented performance oriented designs using Oracle partition pruning and partitioned indexes.
• Performed Application DBA role for teh development and Production Support and Performance Testing Environments.
• Performance tuning SQL statements and PL/SQL packages using Explain Plan and OEM GRID Control.
• Tuned performance for system modules, e.g. SQL statement tuning and data restructuring.
• Creating UNIX shell scripts for ad-hoc batch jobs.
• Developing PL/SQL packages, Procedures and Functions for ETL process.
• Created coding best practices and implemented teh same.
• Used BLOB and CLOB for displaying and downloading documents.
• Created dynamic reports selection screens and personalized reports.
• Implementing advanced techniques like Merge statements,bulk binds and partitioning.
• Optimizing SQL and PL/SQL and web pages using explain plan and code walkthroughs.
• Creating UNIX Shell scripts for scheduled batch jobs.
• Code walkthrough and a review of team coding to ensure optimized code is released.
• Integrating application in development server after unit testing.
• Worked wif QA and provided support to provide timely technical resolutions for defects.

Environment: Oracle 10g, Windows XP, UNIX, PVCS tracker, Visio, Erwin, SQL *plus, PL/SQL, SQL Navigator, WinNT and UNIX Shell scripting, Oracle DBMS scheduler, Autosys, PVCS version control

Confidential

Senior Oracle Developer

Responsibilities:

• Involved in analyzing teh existing business process, application and Database design.
• Has done Development and Unit testing of all teh required PL/SQL packages, stored procedures and triggers.
• Written Stored Procedures and functions using PL/SQL for common utilities.
• Tuned SQL and PL/SQL using TKPROF and explain plan.
• Developed scripts for creating Materialized views, bitmap indexes and gathering statistics.
• Developed UNIX shell scripts to run jobs and to test teh application.
• Created Jobs and stored procedures using Dynamic SQL for refreshing materialized views.
• Used PL/SQL packages like DBMS JOB, DBMS METADATA and DBMS OUTPUT.
• Created CUSTOM ETL scripts wif PL/SQL stored procedures and functions.
• Created SQL*Loader scripts and Oracle external tables for ETL.
• Setting up Control-M jobs
• Investigated and resolved external production tickets and internal QA tickets.
• Worked wif QA and provided support to provide timely technical resolutions for defects.

Environment: Oracle 9i, Windows NT 4.0, HP-Unix, Harvest, Visio, SQL *plus, PL/SQL, Informatica, TOAD, WinNT and UNIX Shell scripting.

Confidential

Oracle Developer / Performance Tuning

Responsibilities:

• Developed Pl/SQL Packages, Stored Procedures and functions for common utilities.
• Designed and developed Database Triggers for audit and validation purpose.
• Developed SQL scripts for data extraction.
• Developed Unit test documents and Shell scripts for unit testing.
• Identified time and resource consuming production SQL statements using PRECISE.
• Tuned SQL statements using SQL trace and TKPROF.
• Gatheird statistics on database objects in development environment.
• Trouble shooting teh performance issues on teh application backend & databases.
• Has done performance code review for code optimization before code migration to production.
• Modified code wifout effecting teh functionality to cut down teh execution time and minimize resource consumption.

Environment: Oracle 11i, Sun-Unix, PVCS Tracker & Version Manager, Precise, SQL *plus, PL/SQL, TOAD, WinNT and UNIX Shell scripting.

Confidential

Programmer / Implementer

Responsibilities:

• Developed Installation scripts for all teh deliverables.
• Actively involved in developing back-end procedures, functions, packages and triggers. Involved in developing screens and generating reports.
• Used PL/SQL packages like dbms output, SPOOLING techniques and sub-blocks to track exceptions and debugging teh application and PL/SQL blocks.
• Done changes to teh database objects as per teh change request
• Tuned teh database SQL statements and packages.
• Developed Unit test documents and involved wif testing too.
• Generated teh backend reports for data verification and validation.

Environment: Oracle 8i, SCO-Unix, VSS, SQL *plus, PL/SQL, TOAD, WinNT, Java 2.0, JSP and UNIX Shell scripting.

Confidential

Programmer / Analyst

Responsibilities:

• Preparation of SRS and SDD documents.
• Preparation of sequence diagrams, data model, class diagrams, component diagram and navigation documents.
• Coded JDBC classes for sales and marketing subsystem module.
• Deeply involved in teh development of UI for Customer Orders and Billing using JSP.
• Unit testing of JSP and Java servlets.
• Created database packages, procedures and functions for Queries and Reports module.

Environment: Oracle 8, SCO-Unix, VSS, SQL *plus, PL/SQL, WinNT, Java 2.0, JSP, Java servlet, JDBC, Apache Tomcat and UNIX Shell scripting.