Professional Summary:

• Around 10 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Experience in all phases of Confidential including Requirement Analysis, Application Design, Development of Multi-tier Applications, Testing, Implementation and Maintenance
• Data model designing expertise
• Oracle Certified Senior Oracle Developer
• Proficient in SQL, PL/SQL stored procedures, packages and triggers
• Performance Tuning experience using HINTs, INDEX, Explain Plan and trace files generated by TKPROF
• Worked with partitioned tables in very large database environment 10 terabyte in replicated databases
• Experience in UNIX Shell scripting
• Basic Oracle DBA skills and maintainence experience of Oracle Application Server 10g on Red Hat Linux
• Experience in JSP, ASP and knowledge of Oracle Portal .

Technical skills:

Confidential

Sr.Oracle Pl/Sql consultant

Description:

Confidential is a web-based application that administers the federal government's prescription drug Part D , MA and MAPD coverage to the senior population 65 or Above and ESRD population, via Medicare information from the Centers for Medicare and Medicaid Services CMS . Major functional modules in GPS are Enrollment, Billing, Employer Accounts and Fulfillment.

Roles and Responsibility:

• Coordinate with business for prioritization of IT activities.
• Support Production maintenance activities.
• Analysis, Design development of the BSR's raised by the business.
• Providing GPS application batch support.
• Interaction with the client.
• Peer to peer code review and testing.
• Application system documentation.

Confidential

Description:

Confidential is a web-based application that administers the federal government's prescription drug Part D , MA and MAPD coverage to the senior population 65 or Above and ESRD population, via Medicare information from the Centers for Medicare and Medicaid Services CMS . Major functional modules in GPS are Enrollment, Billing, Employer Accounts and Fulfillment.

Roles and Responsibility:

• Coordinate with business for prioritization of IT activities.
• Support Production maintenance activities.
• Analysis, Design development of the BSR's raised by the business.
• Providing GPS application batch support.
• Interaction with the client.
• Peer to peer code review and testing.
• Application system documentation.

Solution Environment: Operating System: UNIX Database: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0.

Confidential

Description:

Confidential Archiving project is designed to move files from a high availability storage medium to a lower availability storage medium Tape . It removes the files from the production system which are no longer relevant for business operation to enhance the long term application management and reduce maintenance and administration cost.

Roles and Responsibility:

• Analysis, Design development of the shell script.
• Database package and procedure development.
• Unit testing and QA support.
• Application system documentation

Solution Environment: Operating System: UNIX Database: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0.

Confidential

Description:

The purpose of CERTS application is used to reconcile member enrollment differences between the CMS and Confidential organization as whole. Plan systems like COSMOS, NICE, PERADIGM, and GPS etc hold the plan data in UHG and are compared with the CMS provided as MMR files. Mothly load process identifies and creates discrepancies which for the members and are later handled by the business user.

Roles and Responsibility:

• Analysis, Design development of the BSR's raised by the business.
• Problem analysis and providing solutions using PL/SQL and shell scripting.
• Monthly O M activities e.g. loading monthly Plan Snapshot files.
• Interaction with the business.

Solution Environment: Operating System: UNIX Database: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0.

Description:

The purpose of Medicaid Add-On application is used to reconcile member eligible for Medicaid Facilities. Medicaid Add-on application will create the discrepancies for Medicaid and Medicaid Add-On by comparing the MMR True-up files received from the CMS. Later these files will be send to CMS for correction.

Roles Responsibility:

• Development of database procedures for the application.
• Initial database design of the application.
• Providing QA support for the application.
• Interaction with the business.

Confidential

Description:

• CVS Consumer Value Stores is America's largest retail pharmacy, operating approximately 6,200 retail and specialty pharmacy stores in 43 states.
• CVS-OSS provides Break/Fix Incident Resolution Services, Error Correction and Problem Management, Remediation, Management of Changes for the in-scope applications.
• DW module provides support and remediation to the Extra Care and Pharmacy Script Application.
• Extra Care application takes care of the customer reward point and coupon information to cash registers at the stores in real time. It is a reward point program earned for every purchase in-store online.
• Pharmacy Script application loads daily prescriptions to the Pharmacy Data warehouse is the used for the analytical reporting purposes.

Roles and Responsibility:

• Resolution to the production system defects for the Extra Care and Pharmacy Script applications.
• Problem analysis and providing solutions using PL/SQL and shell scripting.
• Collaborating with project manager and onsite offshore team for ensuring the SLAs are met
• Preparing test cases and testing the same.
• Interaction with the client.
• Participate in Knowledge transition sessions.
• Application system documentation

Solution Environment: Operating System: SunOS 5.9 Database: Oracle 9i Enterprise Edition 9.2.0.7.0

Confidential

Description:

• Quartz is a product of TCS. This product is a universal banking product and it is used by different clients of TCS across the globe.
• The Soci t G n rale Group is the sixth largest bank in the Euro zone.
• This Project is implementation of Quartz for Global Banking Services Division of Soci t G n rale.

Roles and Responsibility:

• Development with the aid of SQL, PL/SQL for the data migration. Written stored procedures and functions.
• Automation shell scripts for the BCP/DR clearcase daily backups.
• Automation shell scripts for the Build Packaging process.
• Designing the clearcase database integrating with the build packaging process.

Confidential

Description:

The client British Telecom BT is the leading provider of telecommunications services in UK providing national and international circuits and other telecom related services to its customers. The objective of project GenIUS, part of BT Wholesale division is to enable BT Wholesale to reduce the time between provision of service and issuing of bills.GenIUS is a billing and collect system designed for BT Wholesale Billing Operations. They bill other licensed operators, mainly large mobile network operators, for use of and connection to the BT network.

Roles and Responsibility:

• Impact analysis and Preparation of the Design and Requirement documents.
• Development with the aid of Ab-Initio, SQL, PL/SQL and Shell scripts.
• Production support to the different GenIUS modules.
• Preparing Test Specification documents.
• System and Unit Testing of different GenIUS modules.
• Knowledge of Geneva Billing System

Tools: Ab-Initio 1.13.11

Solution Environment: Operating System: HP Unix Database: Oracle 9i

.