Project: Merck – Merck Research Laboratory – Clinical Trial Applications.

Roles and responsibilities: Onsite Support Lead

• Support lead for Clinical Trial applications.
• Working with the business team in understanding the new requirements.
• Supervising the onsite team of 5 resources and offshore team of 6 resource  and overall management of 11 resources.
• Understanding complex business application and Participate in Business Meeting for Requirement Gathering.
• Creating Complex PLSQL components to meet client requirements.
• Responsible for all major and minor enhancements.
• Collection and Presentation of metrics.
• Working on the daily day to day activities, and production issues.
• Working on the new enhancements development works.
• Architectural design review of the systems.
• Configuration and Release management using remedy workflow system.

Tools and Technology used: Oracle & PLSQL,Unix,Korn Shell Scripting

Project : ADS – Advance Detective System for FINRA

               Commercial Banking System for WORLD BANK

Roles and responsibilities: Developer, Onsite Coordinator, Project and Support Lead

• Performed data analysis and created conceptual, logical and physical data model
• Developed numerous programs using PL/SQL packages to do the validations
• Extensively worked on Performance Tuning Project to bring down the execution time of BATCH/EOD Processors
• Designed and developed different database objects containing functions, triggers, store procedures to manipulate database of the application
• Used materialized view for reporting purpose
• Created DB triggers to update in master tables
• Used SQL*LOADER to upload the information into the database
• Responsible for SQL tuning, Bug fixes and Testing
• Handle Client Escalation

Tools and Technology used:  Oracle, PLSQL ,Pro*c,Pro*c++,Unix,SQL Loader

Project : Ashok Leyland Corporate & Finance Applications

Roles and responsibilities: Developer and Support Lead

• Support lead for corporate, & finance applications.
• Worked on gathering new requirements for enhancements.
• Support  applications integrated with Oracle Forms & Reports
• Worked as a developer on multiple new enhancements for these applications

• Worked with the business on various requirements to the existing applications.

Tools and Technology used: Oracle and PLSQL, Oralce Forms & Reports, Unix

Project : CACS ( Computer Aided Collection System ) for

                CITIBANK

Roles and responsibilities: Developer and Tester

• Worked on PLSQL – DBMS OBFUSCATION to Encrypt the data
• Implementation of METHOD4 in PRO*C
• Modified/Develop the database structure as per the client requirements
• Developed packages, stored functions, procedures and database triggers
• Used Ref cursors to retrieve data from database
• Worked on creating the test scripts, and tested the applications by performing regression and volume testing

Tools and Technology used: Unix, Pro*C, Shell Scripting