SUMMARY:

• Oracle Certified Associate with overall experience of 9 years, an accomplished career in full lifecycle project development, coupled with hands - on touch of Oracle Database background with leading financial and software product development firms.
• Extensive Query Tuning experience with large production systems(500 GB) within financial environment & application development with Banking Databases
• Implementation experience in Capital Market investment tools such as Equity, Fixed Income, Money Market and Derivatives Interest Rate Swaps module for a large investment banking client.
• Experienced in performance tuning and optimization using Explain Plan, Trace Plans, hints, Toad, Enterprise Manager and Grid control.
• Proficient working experience in SQL, PL/SQL (Client and Server side Procedures, Functions, Packages, Objects, Triggers) for application development .
• Expert experience in developing generic API programs for Database Maintenance Operations such as Partitioning, Index Re-build, Analyze /Gather stats on Objects.
• Proficient hands on experience in building Production Release Deployment Scripts /Incremental Upgrade scripts for Clean-up,Resinstall of UAT/QA Databases.
• Good knowledge of Oracle ETL features such as Merge Statement, SQL Loader, External Tables, Pipelined/Table functions and Multi Table Inserts.
• Strong working Experience with CLOB, XML data types for Automating User manual feeds load and usage of Materialized views.
• Implementation of RDBMS Concepts and Oracle 10g OLAP features in building Zurich/KAM/CTS Data mart and ODS(oracle data source) and enhancing Client data warehouse (CDW) clubbed with Business Intelligence.
• Experience in Unix Shell Scripts, Perl Db routines for Connectivity.

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

Senior Oracle Developer

Responsibilities:

• Developed canned and parameterized reports using Business Objects.
• Worked on proof of concept for Fined Grained user Access Control using Oracle VPD features.Similirly, worked out this stuff using Business Objects. As part of that built one customized entitlement CSV file and developed Shell script to read this file to access Report prompt values and substitute in the Report XML configuration file on the fly.
• Involved in fine tuning the database code by eliminating redundancies and using Oracle Performance features such as Analytical functions.
• Designed Partitioning scheme for the tables and wrote generic Stored procedures to do various operations on them like Truncate,Drop,Add etc.As a part of this process evaluated other approaches and detail documentation of Pros and Cons of each method.
• Developed Load procedures to load the data from Staging area to Presentation area of the Data warehouse.

Confidential, Manhattan, NY

Senior Oracle Technical Analyst

Responsibilities:

• Worked on designing and developing Queue manager infrastructure using Oracle PL/SQL. This will mainly be used for Job scheduling using Request-Response mechanism to and from middle-tier and application server.
• As part of the Queue manager Framework developed PL/SQL procedure to do a Java Web service call to setup Request-Response from application. It was developed using SOAP standards with http as underlying Application Protocol.
• Involved in fine tuning the database code by eliminating redundancies and using Oracle Performance features such as Analytical functions.

Confidential, Jersey City, NJ

Oracle Technical Lead and Business Analyst

Responsibilities:

• SQL performance tuning for slow running queries.
• Writing Unix Shell Script based file alerts and notifications to track file feeds.
• Actively involved in Oracle PL/SQL code enhancement of the existing infrastructure.
• Performed data loads of flat file data using SQL LOADER.
• Liaison with Business for understanding requirements and prepare BSD and FSD. Then articulate these requirements into Technical specifications for offshore development team.
• Peer code review.

Environment: Oracle 10g, SVN, OEM, Unix shell scripting, Autosys

Confidential, Jersey City, NJ

Oracle Technical Lead

Responsibilities:

• Designed Staging and Fact area for Oracle Datawarehouse /Datamart.
• Devised a logical development method for ETL process consisting of Staging Load, Data Cleansing and Data warehouse load.
• Actively involved in Oracle PL/SQL code enhancement of the existing infrastructure.
• Performed data loads of flat file data using SQL LOADER.
• Monitoring and Enhancing ControlM job streams for batch processes.
• Develop and modify existing UNIX shell scripts (Korn shell).
• Used Enterprise UML Modeling tool SPARX.

Environment: Oracle 10g, Pl/SQL, UNIX Shell Scripts, Control - M, Red Hat Enterprise Linux 3, Actimize Intelligence Server, WINCVS, Mercury test director, Sql navigator

Confidential, Raleigh, NC

Oracle Technical Lead

Responsibilities:

• Worked on complex user enhancement(BAU) using Oracle Collections and Provided support for Oracle databases, existing batch processes and PL/SQL Web applications.
• Designed logon triggers for non schema owner users to have access to schma objects without creating synonyms.
• Designed and developed efficient ETL processes for end-to-end loading of the data using Oracle for different source systems like ARC, GESC,SPIDER..etc.
• Performance tuning of existing Oracle ETL procedures with extensive use of
• Customised generic Oracle Pl/Sql procedure for copy data refresh from Production database to either of the test databases.
• Developed new Customized and Generic Regression procedures for the data loads.
• Developed and Executed new techniques for loading high volume CLOB,XML data with Optimal Performance.
• Implemented Parallelism Techniques for Large Trade data file sourcing about 115 million rows into Presentation area with in the estimated SLA.
• Experience with Oracle Replication (Materialized views), External Tables and index/table partition.
• Performed ad-hoc data loads of CSV file using SQL LOADER.
• Monitoring and Enhancing ControlM job streams for batch processes.
• Evaluated various client tools which can be used for Subversion based on the features provided and efficiency of their use.

Environment: Oracle 10g, Pl/SQL, UNIX Shell Scripts, Clearcase, Subversion SVN, Control - M

Confidential, Westborough, MA

Oracle Technical Lead

Responsibilities:

• Database design, Database population, Scripting and Migration function
• Knowledge with hands on Oracle PL/SQL, Complex SQL queries (coding, development)..
• Worked on Importing/Exporting from/to different databases using oracleData pump and sql loader utilities..
• Web Page format conversions like XML to flat file /table format..

Environment: Oracle 10g, VSS, OEM, SQL SERVER 2008, Unix shell scripting, Autosys

Confidential, Westwood, MA

Techical Lead Developer

Responsibilities:

• Handling ETL transformations in Data warehousing environment using OWB.
• Working PL/SQL & SQL*PLUS on Data conversion strategies and processes to ensure the accurate processing and delivery on time.
• Use of SCCS on unix for version control.Manage database.

Environment: Sun Solaris/ Oracle 10g, PL/SQL & SQL*PLUS, Unix shell, ETL,SCCS, VSS, Oracle ware house builder (OWB), OEM, Oracle Discoverer, Oracle 10gAS, Crystal reports, Sql server 2005

Confidential, Boston, MA

Sr. Application Developer / DBA

Responsibilities:

• Performance tuning for various SQL scripts & PL/SQL codes.
• Writing shells scripts for regular maintenance jobs.
• Implemented Historical Solution for Business Units using Oracle Transportable Table space Concept.
• Hands on experience with Oracle Enterprise Manager (OEM) to configure / manage databases.

Environment: Sun Solaris/ Oracle 10g/ 9i/ Tomcat Servers, UNIX, HTML, XML, Crystal Reports,, PERL, Clear Case, PVCS, OEM.Autosys scheduling.

Confidential, Boston, MA

Sr. Application Developer / DBA

Responsibilities:

• Mapping data from new source system and maintains mappings of existing systems, modifying them as required by business user or source system maintenance changes.
• Working in Data warehousing environment for ETL process with OWB and
• Maintenance of loading jobs, reporting.

Environment: Sun Solaris/ IBM - AIX /HP/ Windows NT Server/2000, Oracle 9i PLSQL, PL/SQL & SQL*PLUS, Reports-6i, Business objects, Mercury Test Director, Unix, OEM.Cron jobs

Confidential

Application Developer / Module Lead

Responsibilities:

• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration.
• Performed database tuning using Explain Plan, Toad, and Oracle Enterprise Manager (OEM).

Environment: Windows NT Server/2000/2003, Oracle 9i PLSQL, PL/SQL & SQL*PLUS, ETL, Sybase, GUI JAVA J2EE, Actuate Reporting, WINCVS, PVCS

Confidential

Oracle Developer

Responsibilities:

• Performance Tuning included (Sql tuning, Analysing table statistics and explain plan index creation to minimise the query retrieval time).
• Update services, background jobs, and spool analysis, workload analysis and batch process. Involved in Materialized - View Replication.
• Implemented Stats pack for monitoring Database activities both in Peak hours and non-Peak Hours.

Environment: Windows NT Server, Oracle8i /9i, PL/SQL & SQL*PLUS, Oracle Ware house builder, IBM Ex Series SERVERS, Unix Shell scripting.

Confidential

Project Engineer

Responsibilities:

• Oracle warehouse builder, sql loader, OLAP features, Oracle Express & Oracle Cubes.

Environment: Oracle Discoverer, Oracle Express, Oracle 9i, Oracle Warehouse Builder, MS Access, MS SQL Server, Oracle 9i, UNIX scripts, SQL Server 2000, Developer 2000

Confidential

Project Engineer

Responsibilities:

• Preparation of the program specification for the various programs.
• Creation of the unit test cases of the units developed.
• Involved in Unit Testing, Peer Testing.

Environment: Oracle 8i PLSQL, SQL*PLUS, Developer 2000, Oracle Designer 2000, UNIX scripts