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

Because of Unix Server Migration, the jobs which pertains to Load functionality start running fast and due to this cascading effect, the wait functionality performed instantly and hence the incomplete/Improper permission mode files gets pulled from NAS to Local system. Identifed this issue and provided a feasible solution by increasing the waiting period which tends to change its RunSql FrameWork.

Have introduced column transformation functionality in external table and provided a feasible solution that avoided more code changes

Do analysis on the code impacts Moved all the Waiting process from Datastage Script to Unix Shell Script

Do analysis on the code impacts Check on the Mount points involved Provide a detailed output about the user, group and sudo login details Get a Complete list of ACL account being used. Do a check on the Cron Jobs involved Create an automated script/tool which does the code changes Impact on the JIL Files Preparation of New Autosys Commands

Develop a new automated tool which has the intelligence to identify all the batch jobs which is going to meet SLA and publish/alarm the same via Email by utilizing the ORACLE built in package UTL_SMTP to all the support groups involved in ADS System.

FileLoad is the critical component exists in ADS. It plays a vital role in furnishing datapump from parent/remote system to local system. Recent days, it didnt functioned as it was expected. It started validating the earlier run with the current run. Due to this cascading effect, it started throwing failure messages in production environment. and the SLA got missed. To arrest this issue, did a thorough and in-depth research about this critical component and fixed up the issue and now its running without any failure in prod environment.

Research & Data Analysis Repository plays a vital role in NASD. Existing Application holds Trades as well as BBO data that takes part in Stock Exchange Market. In order to have trouble-free, this existing program has been split out and executed separately for Trades/Bbos.

Involved in 10g migration & successfully completed the same. Have hands-on expérience and came out by creating the spread sheets which has all the issues & solutions which happened during this phase. Circulated the created spread sheet to other projects for their future 10G-Migration.

Involved from Analysis Phase & developed a new pro*c program which has the forking techniques & call to PL/SQL to extract the ADF details to CQS.

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

Currently the processor module is used to extract the records from all parent systems. During the extraction there is a hard-coded check is being done to verify whether the records has been populated in parent database or not. Due to this cascading effect, the program use to go in sleeping state and number of data fix is being done to complete the extraction process. This check has been removed and the checking is done dynamically. This plays a vital role since this has been used for the integrity checks. Also written a tuned pro*c with embedded PLSQL program to populate the history data from production to QC and the Written pro*c program populates 20 corers records in 5 hours from production to QC.

Ahold is an international group of quality supermarkets and foodservice operators based in the United States and Europe. They provide an easy, convenient and appealing shopping experience through continuous customer focus. Ahold are committed to offering our customers the best value, the highest quality and healthy choices, while building value for our shareholders.

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

This project was designed to run the month-end process to create provision , accrual , amortization. According to the user given logic , it was developed and the accounting entries were passed to general ledger. Also given a provision to users to view the accounting entries and the same will get committed in the database once they issue a commit(thru Forms). This particular module is fully involved with Oracle 9i/10G, PL/SQL in UNIX environment.

This project was developed to calculate collection score for the customers. The main aim of this project is to compute scores based on some pre-defined calculations and to store the data in encrypted format and to retrieve the data from the database in decrypted manner using the PLSQL package DBMS_OBFUSCATION.

This project was developed to generate Email and Sms alerts for the customers who fall in the collection and recovery. This was achieved through designing the program in METHOD 4 in PRO*C which, is up and running excellently in production.

Involved in Oracle 9i Migration. Currently the version of Oracle used by us is 8.1.7 from which we are migrating to Oracle 9i.

This project was designed to generate reports which is web based by using the XML in Pro*C program for Hourly productivity of every tele-caller

A Stat Card Module was constituted to revisit and re-engineer all the letters generated to all the Customers who are in to collections with an objective of making it accurate and reduce the stationary cost in printing those letters. Prior to this enhancement there was a high stationary cost since, for each customers letters generated for 3 pages the first page includes the personal and demographic details of the customer and the second and third page the customers dues and other details. Post this enhancement the letter generation was cut short to half a page (i.e., two customers per page) which saved the stationary cost to nearly 30 lakhs per quarter.

In CACS system the telecallers will follow up the customers on daily basis. While following up the customers if the customer promises to pay his dues within the next 7 days from the date of follow up then PP marking will be done on the CACS system and on subsequent payment of the customers the PK marking will be done. Those customers with PP marking only will be followed by the collectors.

The eligibility criteria and credibility of the applicant will be analyzed and decision of converting the applicant to a prospective customer happens in CIBIL projects. This involves various functionalities as to verifying Credibility, verifying other loan status held by the applicant in other banks, Verifying other Credit card delinquencies and buckets, Repayment bounces, any legal file suit etc.,. CBIL sends the status as to whether an applicant is prospective or otherwise. This module has various database level Oracle hits viz., Cards database, Personal Loans database, Collection database, Home loans database, Auto loans database etc., which increased the complexity of the module and at normal run it took 72 hours to complete its full run for 75 lakhs Customers. As a part of tuning activity, Used Forking logic C filters in the place of Oracle searches. Used effective Hints in all external database hit queries wherever required. As per the cards functionality the customer will be categorized in one of the 14 billing cycles. Previously this program ran for all the 14 billing cycles one after the other. After analyzing the code, identified that there is no dependency between the billing cycles so, implemented the FORKING logic and ran the program for the said 14 cycles.

Under Cash Recovery Query Module the query which was giving effective output in the Oracle 7x Rule based index, failed in the Oracle 8x Cost based index usage and ran for 12 hours which was running for 2 hours. Fine tuned the query and forcibly made the query as Rule based and brought down the execution time to 20 minutes.

This project was designed to generate reports which is web based by using the XML in Pro*C program. Hourly productivity Management Information System would be generated for every tele-caller. The main aim is to increase the productivity of each and every tele-caller or collection agent (who are used to make first level calls and follow up of the delinquent customers in Collection System).

This project was designed to approach the Write-off Customers in the Collections System to go for settlement against his delinquent amount. Based, on the settlement amount decided by the higher officials (collector) the customers would be given an option to pay the settlement amount by cash / cheque mode.

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

This project was designed to enhance the Queuing for the Delinquent customers dynamically in Collections System. The dynamically given conditions would be stored in a temporary table and the program would dynamically pick the queries and based on the same delinquent customers would get allocated to the next collector in the queue.