Post Job Free

Resume

Sign in

Project Sql Server

Location:
Florida
Salary:
100000$
Posted:
May 20, 2011

Contact this candidate

Resume:

ANUP KUMAR DAS

OBJECTIVE

Highly motivated innovative diligent professional with a proven record of accomplishment, result driven, focused, and extensive technical skills, seeks challenging and growth oriented technology position in the field of PRPC architecture definition and implementation.

SUMMARY

Having 5.2 yrs of progressive experience in Java software development. With an earned reputation for meeting deadlines and delivering critical solutions and 6 month of teaching experience.

Having 3.5 Years of progressive experience in PEGA PRPC Development. With an earned reputation for meeting deadlines and delivering critical solutions.

Good analytical abilities, quick grasping power zeal for learning new things.

Strong knowledge in Java, J2EE

Strong knowledge in server side programming with java using Servlets and JSP

Good knowledge in Struts Frame Work

Good knowledge in Model View Controller Architecture

Good knowledge in Web Servers Tomcat

Good Knowledge in SQL Server 2000

Knowledge in Enterprise Java Bean’s

Good knowledge in AIU Core Architecture

Good knowledge in UnderWriter Concept in General Insurance

Technical Expertise in PRPC

Defining and creating the Class Structure and Class Groups which includes Operator IDs, Access Groups, Rulesets, Work Pools and Setting up the Organizational Hierarchy

Identifying and creating Work Parties required in the Application

Creating custom Activities, Flows and different user interfaces which include FlowActions, Harnesses, Sections, Paragraph

Implementing and sending correspondence to different work parties using Notify shape and Activities

Creating Integration connectors and Services like SOAP, SQL, JMS, MQ, HTTP, and Java to connect/service to the External System

Expertise in using the out-of-box solutions provided in PRPC and reuse it to optimize the coding

Working experience in Inline Java coding in an Activity using Process Commander Public Application Programmer Interface (Public API)

Flexible in testing and debugging the PRPC Application using tools like Clipboard and Tracer

Certifications

Type Version Acquired On

PEGACSA203: PRPC v5.5 Certified System Architect PRPC v5.5 Certified System Architect 06-July-2010

Domain Academy Certificate: Certificate in Insurance Version 2.0 (CINS) 2.0 27-Nov-2009

iSecurity Certification: iSecurity QuizSet of role-based quizzes 1.0

21-Apr-2009

Education Summary

Qualification Category Qualification Subject

Bachelor Of Engineering BE Information Technology

Standard Xii / H.S.C. XII Physics, Chemistry & Mathematics

Ssc SCHL Maths, Physics and Science

Skill Set

Operating Systems Windows 2000/XP,Window 2000 Server NT Technology

Databases Microsoft SQL Server 2000, Microsoft SQL Server 2005 Sybase,oracle 10g,DB2,

Languages JAVA ,J2EE, C,C++

Internet Technologies JavaScript, HTML, Servlets, JSP, XML , XSL

Frameworks/API’s Apache Struts Framework and MVC,AIU Core Architecture

Middleware RMI

Application Servers WAS 6.0

Web Servers Apache Tomcat 5.0

BPM Product/Tool PegaRULES Process Commander V 6.1

Tools Eclipse, EditPlus, IBM Rational Application Developer for WebSphere Software, Visual Source safe, Microsoft visio,

Domain Knowledge General Insurance

Career Profile

Dates Organization Role

30 Sep2007 – Till Date TATA Consultancy Services Ltd ITA

26th Feb 2007- July 2007 Bizmatics Senior Devloper

Jan 2006 -23rd Feb 2007 Infotikasoft Devloper

PROJECT PROFILE

The details of the various assignments that I have handled are listed here, in chronological order

Project 1 CIBC

Client Canadian Imperial bank of Commerce

Period Nov-2010 to Still date

Environment XSL,XML,XSD, Pega PRPC V6.1x, Weblogic, DB2, Xml Spy, Pega(BRE), Pega(BPM),TMF,PCF,NBBL Framework

Description Lending Simplification project is a development project which involves building the entire Lending Origination system using PRPC and Chordiant Decision Manager for the Lending and Insurance line of business in CIBC. The scope of the project includes creating Proof of Concepts (POCs) and Proof of Technology (PoT), building integrations with other CIBC applications, creating UI rules, decision rules, flows, activities, security, using frameworks like PCF, TMF and NBBL to showcase the capabilities of PRPC and the feasibility of developing such a solution in PRPC.

Responsibilities Gathering requirements according to the given module.

Running DCO,Create Enterptrse Application Acelerator

Design user interface and Coding.

Test Plan, Test Cases.

System Development.

System testing and reviewing the code.

Product Configuration

Webservices and Intregation

Role Module Lead

Project 2 WebPOS

Client TATA-AIG General Insurance company

Period Jan-08 to Oct-2010

Environment Java 1.4, XSL/JSP, Pega PRPC, Docucorp, AIU Macro Engine, WebSphere, Sybase, Edit Plus, Xml Spy, DBArtisan, Pega(BRE), Eclipses 2.1, CVS, AIU Core Architecture

Description Web based Point-of-Sale System (WebPOS) will support insurance transaction processing & on the spot document issuance for multiple lines of business & products, mainly in the retail segment. The system will provide the opportunity to channel partners of TATA-AIG to enroll as e-Business Partners committed to a specific business model, which defines volume & value of different products to be sold over an agreed timeframe. Through WebPOS, the partners will be enabled to efficiently and effectively service the requirements of their customers from quote to policy issuance, and policy lifecycle management. They can also provide TATA-AIG underwriters with leads, which will be processed through S3.

Responsibilities Gathering requirements according to the given module.

Development and Maintenance of Pega part in the Project.

Design user interface and Coding.

Test Plan, Test Cases.

System Development.

System testing and reviewing the code.

Deployment of the system on IBM WebSphere.

PEGA sessions / Training

Role Team Member

.

Project 3 Integrated Insurance Portal (IIP)

Client TATA-AIG General Insurance company

Period Jun ‘08 – Sep ‘08

Environment PegaRULES Process Commander

Description Integrated Insurance Portal uses Product Configuration Framework which is a horizontal solution that enables you to define products (saleable commodities like insurance coverage and services, or material objects like furniture) in terms of standard and optional packages, components, subcomponents, and features. It provides the capability to rapidly develop, maintain, and uniquely deploy product (or service) specifications in a controlled and consistent manner.

The main objective of designing the Integrated Insurance Portal is to capture the required data from the external system into PRPC, which creates Quote and calculates the premium at Section, Product, Risk and Coverage component level for Auto Insurance and sends the resultant data to the external system.

Role • Building the Product Plans related to Private Motor Car Insurance

• Implementing Business Logic by creating activities for premium calculation and decision tables for obtaining rating factors

• Written Inline Java code in an activity for calculating the Features like Discounts, Commissions, Brokerage charges

• Unit testing of the Product Hierarchy, Decision Tables and Activities

Project 4 WebPOS – BCC Rules enhancement and Production issues

Client TATA-AIG General Insurance company

Environment Edit Plus, Xml Spy,DBArtisan, Eclipses 2.1, CVS,XML,XSL,Servlet,Java

Description BCC stands for Busines Control Configuration. This is a user interface through which UnderWriter can add ,update,delete Rules. Only Underwriter can able to see this BCC link in left side of window in WEBPOS. For Old Architecture we are using BCC. In NPI Architecture we are using Pega. If any policy is meeting erroneous state then it will be referred to under writer where he will decide whether to proceed or to reject the policy

Old Architecture

Auto secure (Private Car /Scooters)

Home Secure

Responsibilities Gathering requirements according to the given module.

Development and Maintenance of Pega part in the Project.

Design user interface and Coding.

Test Plan, Test Cases

Role Team Member

Project 5 WebPOS – PEGA enhancement and Production issues

Customer TATA-AIG General Insurance company

Description New Changes in Rules and production issues on PEGA was handled. Pega installation etc

Role Module Lead

Solution Environment PEGA PRPC 4.2(BRE Application),

Windows 98/ XP,Oracle 10g Enterprise Edition,Tomcat 4.1,Esclipse 3.1

Highlights With a minimum KT on PEGA, handled all the PRPC related stuff in the project.Pega new Enhansement, Pega Installation and mentainence.Creating pega instance.Taking pega backup.Deploying Pega Build.Taking Build. Given pega training to other Resourses. Made a Document on pega.

Project 6 Proof of Concept in PEGA

Customer TATA-AIG General Insurance company

Description In current Scenario Editing, deleting, update rules in pega done by pega developer. As of Client requirement, there should be a front end through they can update, add, delete Pega rules.

Role Module Lead

Solution Environment PEGA PRPC 4.2(BRE Application),

Windows 98/ XP,Oracle 10g Enterprise Edition,Tomcat 4.1,Esclipse 3.1

Highlights Created Decision Table for all rules and delegated that Decision table to a particular operator id who can login into pega and can see only those decision tables and can make changes in pega rule.

Project 7 Data Migration in PEGA

Customer TATA-AIG General Insurance company

Description In previous environment pega rulebase stored in Oracle 10 database.In current scenario Oracle 10 database migrated into SQL Server 2000 database

Role Module Lead

Solution Environment PEGA PRPC 4.2(BRE Application),

Windows 98/ XP,SQL Server 2000 devloper version,Tomcat 4.1,Esclipse 3.1

Project 8 PRPC Migration from 4.2 sp5 to 5.5 sp1

Customer TATA-AIG General Insurance company

Description In previous environment using PRPC 4.2 sp5. Now its migrated into 5.5sp1.

Role Module Lead

Solution Environment PEGA PRPC 4.2 SP5, PEGA PRPC 4.2 SP6, PEGA PRPC 5.1 SP1,

PEGA PRPC 5.5 SP1,Windows 98/ XP,SQL Server 2000 devloper version, SQL Server 2005 devloper version,Tomcat 4.1,Esclipse 3.1, Tomcat 5.5.17,JDK 1.5.

Project 9 WebPOS –Premium Calculation in PRPC(BRE)

Customer TATA-AIG General Insurance company

Environment PEGA PRPC 4.2(BRE Application),

Windows 98/ XP,SQL Server 2000 devloper version,Tomcat 4.1,Esclipse 3.1

Description WebPOS will generate the RatingReqestXML which acts as an Input for PRPC. The PRPC after processing the xml provides the premium and the values in the form of RatingResponceXML. PRPC uses different XMLs defined by us for the internal purpose. Depending on the RatingReqestXML the PRPC decides which rating services to be selected for calculating the premium. RatingReqestXML is generating at coverage level ie: For each Coverage RatingReqestXML is generating. WebPOS is using PRPC for premium calculation. Calculation is happening in the coverage level. For each coverage system generates an input XML to PRPC and get the response XML.

Responsibilities Implementing Business Logic by creating activities for premium calculation and decision tables for obtaining rating factors

Written Inline Java code in an activity for calculating the Features like Discounts, Commissions, Brokerage charges

Unit testing of the Product Hierarchy, Decision Tables and Activities

Project 10 Central Record Keeping Agency

Customer NSDL

Period Oct-2007 to Jan-2008

Environment EJB , DB2, WAS Server, IBM Rational Application Developer for WebSphere Software, Visual Source safe.

Description To help customer for achieving their mission of “To set up system based on a world class, state-of- the- art IT infrastructure to facilitate the efficient processing and allocation of pension funds” by delivering the System that meet customer needs.

Responsibilities Gathering requirements according to the given module.

Design user interface and Coding.

Test Plan, Test Cases.

System Development.

System testing and reviewing the code.

Deployment of the system on IBM WebSphere.

Role Team Member.

Project 11 Electronic Medical Recorder for Doctors called “Prognosis”

Module Process for Patch Release

Customer Hospital in USA

Period Feb-2007 to July-2007

Environment CoreJava , MySql, Jdbc, EditPlus2,Sql Analyzer

Description Have a properties file that will have the version number, patch number

Program should

• Verify that version number is correct. If not then give an error and come out.

• Stop tomcat

• Read the list of files to be copied from the properties file These will be along with the folder name

• For each file

1. Copy the file to a backup folder

2. Deletes the file

3. copy the new file

4. Start tomcat

5. Make sure that any error in the process is captured and logged

Responsibilities Gathering requirements according to the given module.

Design user interface and Coding.

Bug Fixing.

Role Team Member.

Project 12 Electronic Medical Recorder for Doctors called “Prognosis”

Module Patient Registration

Customer Hospital in USA

Period Feb-2007 to July-2007

Environment JSP, Struts, JDBC., Java Script, EditPlus2,Sql Analyzer

Description This is a web based application developed in Java Jakarta Struts. A good Patients database is the heart of the Application. A new patient has to be added before his Appointment is scheduled. Without defining a patient his encounter cannot be created. The application runs on Tomcat Web server with MS-SQL as the Back-End. This module was created for the registration of the patients where the patient can register themselves with the doctor by providing the information regarding themselves such as Name , Address SSN NO etc.and Its only after this registration encounter with the doctor begins

Responsibilities Gathering requirements according to the given module.

Design user interface and Coding.

Bug Fixing.

Role Team Member.

Personal Details

Sex : Male

Nationality : Indian

Language Known: English, Hindi,Bengali,Oriya

Marital Status : Married

Designation : IT-Analyst

Phone: : 976-***-****(Mumbai)

Passport Details

Passport Number Date of Issue Expiry Date Place of Issue

G7464270 16-apr-2008 15-apr-2018 Kolkata

Declaration:

I hereby declare that the information furnished above is true to the best of my Knowledge.

(Anup Kumar Das)



Contact this candidate