PROFILE AND AIM

• Having 10 years of professional experience in Software Designing and Development in diverse technologies with more emphasis on Oracle 10g/11g, ER studio Crystal Reports.
• Strong skills in understanding Business Process, Analytical and Communication skills.

Domian Knowledge.

• Banking and Finance.
• Healthcare.
• Insurance.

SKILL SETS:

Database : Oracle 9i, 10g, 11g PL/SQL

Reporting tool : Crystal Reports 9

Front End : Asp.net, Visual basic 6.0

OS : UNIX, Windows.

Data Model tool : ER Studio.

ETL : Informatica 8.1

PRIMARY SKILL SET:

Functional:

• Understanding the requirements and preparing technical function specification documents.
• Communicating with the client for gathering the requirements.
• Coordinating with the team members and assigning task to team members.
• Analysis of application by discussing with the technical team.

Technical:

• Optimizing Oracle SQL queries using hints and Explain plan.
• Optimizing PL/SQL stored procedures.
• Advance PL/SQL programming such as bulk handling, pipelined functions, analytical queries, collections, Objects etc.
• Load data using SQL Loader external tables from .csv .txt files

DETAILED DESCRIPTION OF THE PROJECTS

Project Title:

Confidential

Project Description

Paypal is developing a new web application ROCA which is developed to agents to call to customer to pay their left credit amount for this purpose they should have accurate information of their current phone number, address, account information etc. this for getting accurate information PAYPAL sends information for customers to third party vendors. In return these vendors get customer current accurate information. This information is loaded into database by using batch process and then loaded into ROCA which is then used by the agents for calling the customer.

Duration:

Confidential

Roles and Responsibilities:

Oracle PL/SQL Developer Lead

Role include

• Understanding process setting up meeting with business team
• Based on requirement Creating design document and getting it reviewed by business team, architect team and other team members.
• Using ER studio for creating data model of the project.
• Loading data using External table if required.
• Writing Packages, Stored procedure and functions.
• Writing automated Unit test package by creating test data for all test scenarios, writing asserts for the test case, executing test cases.
• Tuning SQL queries and packages to meet SLA.
• Co-coordinating with QA team for testing in QA Environment to get sign off

To get code pushed in production.

Team size:

12

Project Title:

Confidential

Project Description

• Ex Pharmacy feeds are processed for the applications Predictive Model and Active Health. After the data is processed, a view of the data is updated and made accessible to these applications.
• The intent of this project is to match external pharmacy Third Party claims to existing members and their medical claims to produce a full health evaluation in the Predictive Model. The resulting analysis becomes a selling point to prospective and current employers that Humana understands their clients' needs and presents them with tangible health solutions in VeriSight.
• The scope of this project includes the data transmission of pharmacy claims from PBM client on behalf of Humana's Customers, matching the medical membership to the external pharmacy claims, and sending the matched pharmacy claims to a table that the Predictive Model and VeriSight processing pick up on a Weekly/Monthly basis.

Solution Environment : Oracle 11g , Toad 9.7 , Informatica 8.6,Dollar Universe, Ultra Edit Editor for formatting Scripts .

Confidential

Roles and Responsibilities:

Oracle PL/SQL Developer and Project Leader

Role include

• Set up call with Ben if there is any gap with requirement and design document.
• Set up data loading job SQL LOADER / Informatica
• Write a stored procedure to Apply transformation
• Write a stored procedure to apply business/ matching logic
• And stored the matched claims permanently
• Code review
• peer to peer testing.
• Send the matching data for UAT.
• Once Approved move to production.

Team size:

5

Confidential

Roles and Responsibilities:

Project Leader

• Assigning those modules to team members
• Dividing project into different modules
• Analysis of requirement document prepare the design document.
• monitoring the development progress weekly.
• Updating Status to Onsite team.
• Solving Complex issues by proposing different approaches with the team members
• Maintaining version for release using Clear Case.

Team size:

5

Project Title:

Confidential

Software:

VISIO 2010,Excel 2010, Microsoft word.

Roles and Responsibilities:

• Responsible for scheduling calls and follow up with the business users to get the detail information of the application by referring to the 11 IT controls questionnaire to client and send this information to the PGB Project governance Board PGB team for verifying if the application meets AEMP 30 standards.
• Following up with the Biz T Integration team for the status of the application in SIQ Migrate, Decommissioned or Cancelled

Confidential

Software:

Sybase and UNIX

Team size:

3

Role:

• Understanding the Design Document.
• Creating loader for Data files from DQME to load into IDN.
• Creating Staging tables
• Writing transformation logic
• Extract Data in Excel / text file spool file and send it for UAT.
• After taking UAT approval implementing in production.
• Taking Sign off for closing project.