SUMMARY:

• IT professional with 14 years experience in Oracle (SQL & PL/SQL), Pro*C, Java
• Strong working experience with various Fortune 500 clients in the financial domain - Investment banking, Life Insurance, Credit Risk management
• Strong experience in writing SQL queries, Stored Procedures / Functions/ Packages / Database Triggers
• Excellent knowledge of Oracle internals - Memory Architecture, Processes, Files, Transactions, Sessions, Query processing
• Excellent understanding of performance tuning - CBO, execution plans, joins, row source generators, access paths, join orders etc
• Have extensively used Dynamic SQL, Global Temporary Tables, Data Base links and Partitioned Tables/Indexes, Index organized tables, Clustered Tables, Analytical Functions, Pipelined Functions, Flashback queries
• Experience in drawing ER diagrams, Data Flow Diagrams/Process Diagrams.
• Extensively worked with tools like TOAD, PL-SQL Developer, SQL Developer, iSQLPlus
• Involved in using utilities like SQL*Loader, Import/Export, External Tables, DataGuard
• Solid experience in Optimizing Query Plan, Performance Tuning.
• Involved in query level performance tuning using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQLs and tuned them by redefining query logic, remodeling database structure, creating indexes, using hints to suggest preferred execution plans etc.
• Involved in database instance level performance tuning by identifying poorly written sqls that fill up the library cache, caching tables in the keep pool, analyzing wait events
• Experienced in Replication techniques using Materialized views
• Experienced in Backup / Recovery setup with Oracle DataGuard
• Well experienced in writing Perl & UNIX Shell Scripts to automate day-to-day operations.
• Extensively involved in all stages of SDLC
• Good Experience in creation of Use Cases, Technical design document, DB design
• Excellent Skills in application performance tuning by profiling all the tiers in an N-tier architecture.
• Excellent analytical skills
• Excellent soft skills, have worked as a project lead from 2006 for Fortune 500 companies.
• Fast Learner, very good communication skills, very positive user interaction, a very hands on team lead

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8.x

Languages: SQL, PL/SQL, Pro*C, Java

Database Utilities: SQL*Loader, Import and Export, Explain Plan, TKPROF. UTL FILE, UTL HTML(and other supplied packages)

Operating System: Unix(AIX, Solaris, HP-UX), Linux, VMS

Scripting Languages: Perl, Shell Script, DOS Script

GUI: Oracle D2K (Forms, Reports), JSP, JSF, Adobe Flex

Schedulers: Autosys scheduler, DBMS JOBS, Cron

Repositories: CVS, SVN

IDE: TOAD, SQL- Developer, PL-SQL Developer, SQL*Plus, Eclipse

BPM: AquaLogic, TIBCO iProcess

Application servers: Weblogic, Websphere

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Tech Lead / Senior Database Developer

Responsibilities:

• Working as a Tech Lead / Senior Database Developer, did requirements analysis, designed, developed and implemented complex application logic in the Database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries in database objects (packages etc) and also in the DAO layer.
• Profiling and tuning Database process flows (procedures, functions, sql queries) in an Oracle database implemented in a single instance dedicated server mode.
• Profiling and Tuning application execution flows for better performance and accuracy - both at the Database layer and the application(java) layer.
• Have contributed to the design and development of the java layer too.
• Developed many perl and shell scripts for automating daily functions.
• Designed hierarchical job dependencies and implemented them using Autosys, DBMS JOBS.
• Managing a 15 member team distributed across 3 locations and ensuring all application SLAs are met as the application usage scales up
• Suggesting modifications to DataModel for reducing redundancy and improving query performance
• Liaising with client business managers and planning future development opportunities
• Clarifying requirements with client SMEs
• Reviewing Design decisions along with client architects and ensuring all relevant documentation is completed in time
• Analysing and solving critical application issues
• Handling escalations
• Identifying scopes for improvement for the application at the design, implementation or usage level

Technology Stack: Oracle 11g/10g, SQL, PL/SQL, Weblogic, Websphere, Java J2EE, JSP, Flex, UNIX, Linux, Autosys, ALBPM, TIBCO iProcess.

Confidential

Tech Lead / Senior Database Developer

Responsibilities:

• Worked as Tech Lead / Senior Database Developer, did requirement analysis, designed, developed, tested and implemented application logic in the database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries in database objects (packages etc) and also in the DAO layer.
• Profiling and tuning Database process flows (procedures, functions, sql queries) in an Oracle database implemented in an Oracle 10g database implemented on a RAC dedicated server mode.
• Exclusively designed the datamodel for all 3 modules that I led.
• Performance tuning of deliverables - both at the database layer and application layer.
• Performance benchmarking of all application logic flows.
• Developing the single largest outgoing feed(actuarial valuation) from the system and ensuring it met performance SLAs.
• Overseeing Application Support.

Technology Stack: Oracle 10g, SQL, PL/SQL, UNIX, Java J2EE, JSF, Documentum, Thunderhead.

Confidential

Module Lead / Database Developer

Responsibilities:

• Worked as Module Lead / Database Developer, did requirement analysis, designed, developed, tested and implemented application logic in the database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries
• Development & upgrade of an Interface module for Online Data Disclosure on a Daily basis via Nomura's SYNTAX to Confidential, Tokyo's customers - entirely on a pl/sql, sql stack
• Functional enhancement of the Systems' processing of Securities/FX/Derivatives’s Booking/Settlement/Reversal and portfolio wise Net Asset Valuation and related cash accounting with Pro*C and pl/sql
• Development of the interface modules with external entities like Nikkei, JIP, Reuters, SYNTAX, X-NET.
• Designed and led a team for developing an interface to automatically feed Nikkociti's newly acquired Reporting datawarehouse with transaction and position feeds from Futron - implemented with pl/sql.
• Successfully re-engineered the Corporate Actions module resutling in greater STP.
• Successfully migrated Futron data to Nikkociti’s replacement system (PX) purchased from Nomura and Developed an auxiliary market price feed system for it using Oracle D2K Forms, Report Builder and PL/SQL.
• Profiling and tuning Database process flows (procedures, functions, sql queries) in an Oracle database implemented in an Oracle database implemented on a single instance Oracle 9i Database server in dedicated server mode.

Technology Stack: Oracle 9i, SQL, PL/SQL, Pro*C, Oracle Forms 6i and Oracle reports in an X-Windows environment, VAX-VMS, NDM.

Confidential

Module Lead / Database Developer

Responsibilities:

• Worked as Module Lead / Database Developer, did requirement analysis, designed, developed, tested and implemented application logic in the database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries
• Profiling and tuning Database process flows (procedures, functions, sql queries) in an Oracle database implemented in an Oracle database implemented on a single instance Oracle 7.3 Database server in dedicated server mode.
• Developing GUI components with Powerbuilder 6.0

Technology Stack: Oracle 7.3, SQL, PL/SQL, Powerbuilder 6.0

Confidential

Database Developer

Responsibilities:

• Worked as Database Developer, did requirement analysis, designed, developed, tested and implemented application logic in the database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries
• Profiling and tuning data migration process flows (procedures, functions, sql queries) in an Oracle database implemented in an Oracle database implemented on a single instance Oracle 8i Database server in dedicated server mode.
• Design and validate Staging area and Main Data Models.
• Develop the data transformation and Load processes.

Technology Stack: Oracle 8i, SQL, PL/SQL

Confidential

Developer/Support

Responsibilities:

• Worked as Developer, did requirement analysis, designed, developed, tested and implemented application logic in the application and database layer (Data Modelling, Pl/Sql packages, sql etc)
• Extensively involved in designing and developing Procedures, Functions, Packages, Triggers and other Database objects to implement application logic in the database layer.
• Extensively involved in developing SQL queries
• Provided support to application users by answering queries, doing bug fixes.

Technology Stack: Oracle 7.3, SQL, PL/SQL, Powerbuilder 5.0.2

Confidential

Developer/Support

Responsibilities:

• Worked as Developer, did requirement analysis, designed, developed, tested and implemented application logic in the application and database layer
• Developed integration interfaces between APPM and other applications within GE.
• Extensively involved in developing SQL queries
• Provided support to application users by answering queries, doing bug fixes.

Technology Stack: MS SqlServer 6.5, Powerbuilder 5.0.2

Confidential

Developer/Support

Responsibilities:

• Worked as Developer, did requirement analysis, designed, developed, tested and implemented application logic in the application and database layer
• Developed IVR workflows .
• Provided support to application users by answering queries, doing bug fixes.

Technology Stack: MS SqlServer 6.5, Powerbuilder 5.0.2, EDIFY (IVR software)