Project Sql Server

Mithila Das

Address

* ******** ** *** *

Maple Shade, NJ 08052 U.S.A.

Contact Details

Phone: 856-***-**** Email: *******.***@*****.***

Experience Summary

. 2 years and 8 months of experience in Analysis, Design, Development

and Implementation phases of PRPC based applications.

. Cognizant Technology Solutions certified PRPC professional.

. Has advanced training in ULTIMUS BPM tool.

Technical Skills

Hardware / Windows 98/XP/2000/VISTA/2003 Server.

Platforms

Technology PEGA-PRPC, Ultimus, Basics of Microsoft Dot.NET

Databases SQL Server 2000. SQL Server 2005

Scripting JavaScript, HTML, XML

Languages

Tools PEGA Rules Process Commander(PRPC) 4.2,5.1,5.3,

Ultimus version 7.1 and 8.0, Visual Studio Dot NET

2003

Application Tomcat, Web-Sphere Application Development

Server

Education

Title of the Degree with College/University Year of Passing

Branch

Bachelor of Technology Techno India College, 2006.

in Information Saltlake, Kolkata, India

Technology.

Relevant Project Experience

Organization: Cognizant Technology Solutions

Project #1

Project Title Hanover Real Time Rating

PROJECT DESCRIPTION: This project is aimed at enabling Agents to do the

real-time-rating using AMS by integrating Hanover's real-time rating

application with T-Station to accelerate the delivery cycle. This project

includes design and builds a new ACORD based interface to accept requests

to quote both Homeowners and Auto Personal Lines of Business States: OH and

NH, New Business Transactions. The scope includes development of the major

components like changes in Agency Connect to validate /transform data from

AL3 to ACORD 1.7 version, Orchestration of various services for data

gathering and validations, Pega rules engine for handling Knock out,

bumping and slotting limits and deductibles and other data validations -

Interview Screen, Rating using PMS online rating component, Post Rating,

bridging to the POS application for issuance.

TECHNOLOGIES USED

PRPC 5.3, HTML, Java script, Oracle 9i, IBM MQ Series, T-Stations

(Middleware).

Project #2

Project Title TD Visa Fraud Management

Extension.

PROJECT DESCRIPTION: This project was an enhancement to the existing

Lost/Stolen visa card application( flow).The need was to make changes for

eliminating the General Information Section, Modification of the Fraud

Qualifying Questions, Enhancement to the ATM Cash Advance workflow,

embedding Authorizations into the Lost & Stolen workflow, enhancements to

the Transaction Section, elimination of 2 Lost & Stolen Screens, update

Lost & Stolen workflow with Multicard functionality and allow for ordering

a Plastics request without exiting the current Interaction.

The changes to the Lost & Stolen workflow are designed to make the flow

more user friendly for the operators and to further reduce AHT. The

reduction in AHT will occur as a result of the users completing fewer Lost

& Stolen screens, less checks to TSYS and having the Plastic Request

functionality made available within the existing workflow.

TECHNOLOGIES USED

PRPC 4.2, PRPC 5.3, HTML, Java script, Oracle 9i, IBM MQ Series, TSYS

(Middleware).

Project #3

Project Title Anthem Wellpoint, Group Enrollment

Application

PROJECT DESCRIPTION: The client is USA's leading health benefits company

serving the needs of approximately 34 million medical members nationwide.

The present case deals with the enhancement of Group Enrollment Application

for client's business for the Central American Region

Source Systems: PRPC V 5.1, SQL server, Sybase, web logic.

1. Group Enrollment Application

a. New Group Load - Automate the entire process of loading a new group

into Facets database.

b. Group Renewal - To automate the process of renewal of a group

already loaded into the system.

TECHNOLOGIES USED

PRPC 4.2, PRPC 5.3, HTML, Java script, Oracle 9i, IBM MQ Series, TSYS

(Middleware).

Project #4

Project Title Anthem Wellpoint, Benefit Selector

PROJECT DESCRIPTION: The client is USA's leading health benefits company

serving the needs of approximately 34 million medical members nationwide.

The present case deals with the enhancement of Benefit Selector Application

for client's business for the Central American Region

Source Systems: PRPC V 5.1, SQL server, Sybase, web logic.

TECHNOLOGIES USED

PRPC 4.2, PRPC 5.3, HTML, Java script, Oracle 9i, IBM MQ Series, TSYS

(Middleware).

Contact this candidate