Engineer Project Service Software .Net Business

PURSHOTTAM VAISHNAV

Link Road, Goregaon (W) Mumbai- 400 104, India.

Phone: +91-902*******/922-***-**** Email: ******************@*****.***

OBJECTIVE

Seeking assignments as Software Development with a latest technology

oriented organization

SUMMARY

. A highly dynamic, self-motivated diligent professional with 4+

years of experience in analysis, design, development, testing,

deployment of full life cycle of applications

. Currently handling Indian Motor Third Party Declined Risk Insurance

Pool (IMTPDRP) team and responsible for smooth and efficient

execution of activities

. Functional experience includes Web Application Creation,

Development of user interface elements for online applications,

Designing, Developing and unit Testing Enterprise Microsoft .Net

applications, creating database schema's, tables SQL queries,

involved in creating xsl to convert xml and dynamic data into web

pages

. Strong skills in ASP.Net, C#.Net, VB.NET, WCF, AJAX Control,

JavaScript, SQL & T-SQL, RDLC, Oracle 10g, Crystal Reports, TOAD,

SQL PLUS, PL/SQL Developer

. Hands on with WPF, Silver light and WWF.

. Highly motivated and focused on delivering project requirements &

technical solutions on-time, whilst achieving goals, and delivering

timely

. Deftness in monitoring delivery to ensure high-quality, elevating

customer satisfaction, while adhering to the SLAs & work processes

. Skilled at business requirement gathering & understanding the

business

. Endowed with a profound customer centric and systems driven

approach to designing business solutions

. Hands on using designing tools such as Rational Rows for developing

Sequence diagrams, Use Cases, and Class diagrams.

. Provide post-implementation, application maintenance and

enhancement support to the client with regard to the product /

software application.

. Domain Skills: Insurance, Telecommunication, Retail, Mobile

Banking, and Internet Services.

PROFICIENCY MATRIX

Software Languages : ASP .Net, VB.Net, C#.Net, VBA (Macros), Core Java,

C++, C

RDBMS : MS SQL Server 2000-2008, Oracle 10G

Tools : RDLC, Crystal Report 10, UML (Rational Rose), Gnu Win32

Operating System : Windows Family

Scripting Languages : Java Script, VB Script and AJAX

Tags : HTML, CSS, XML

Framework : Microsoft .Net 2.0-4.0, XML

Testing : Manual Testing

Servers : IIS 6.0-7.5

EDUCATION

Master of Computer Application from Mumbai University in 2011 with 62.33

percentages.

B.Com from Mumbai University in 2008 with 76 percentages

PROFESSIONAL EXPERIENCE

Currently associated with NSE.IT Ltd as a System Analyst from Jan-12

Company: NSEIT (A fully Owned Subsidiary Of National Stock Exchange of

India Limited)

PROJECTS UNDERTAKEN

Project : Indian Motor Third Party Declined Risk Insurance Pool Feb

2012- Till Date

Client : General Insurance Corporation (GIC) Team Size: 6

Platform : ASP.Net 3.5, C#, Oracle 10g, J-Query, Ajax, WCF, VSS and

Web Services

Project Description:

Indian Motor Third Party Declined Risk Pool is setup collectively by all

General Insurers in India to serve the Commercial Vehicle Standalone Third

Party Liability Insurance policies. Indian Motor Third Party Declined Risk

Insurance Pool operates in the auto arena for the commercial vehicles to

have equitable and fair sharing by all insurers, simplicity to administer

and to bring claims management efficiency. It has modules as Party

Authentication Module, XML Upload Module, MIS Module and Dashboard Module.

Role: .Net Developer (Team Leader)

< The pool application will provide a Web based mechanism (Web Service

and Web Portal) with real time reporting and Data Warehouse

< Application will support the upload process for Policy, Endorsement,

Cancellation and Claims with various validations

< Created Test Case scenarios for Functional Testing

< Developed mechanism to keep record and store transaction details.

< Developed User Authentication, Transaction and Session Module

< Design and Implement GUI and used Data Grid to show user transaction

history.

< Handled complex SQL Queries, Stored Procedures, Rollup and Triggers to

implement the business requirements

< Made use of the Cursors, Sequences, Jobs, Types, Packages, Temp Table

and Extract Value functions

< Involved in fine tuning stored procedures by making use of PL/SQL

Collections and its BULK FETCH and BULK INSERT features

< Developed various charts and graphs like Bar chart (side-by-side,

stacked), Pie Chart and line graphs

< Co-ordination between the business user with respect to business

requirement and system analysis

< Requirement reviews and discussions providing recommendations related

to proposed solution

< Application is live since 02-Jul-2012(http://www.motorpool.co.in/)

Prior work experience

Contakt Tech Solution India PTE Ltd as a Software Engineer from Jun-08 to

Jan-12

PROJECTS UNDERTAKEN

Project : Service Delivery Platform (SDP) Jul 2011- Jan2012

Platform : ASP.Net 3.5, Silver light, SQL Server, SSRS Reports and WCF

Team Size: 4

Project Description:

SDP provides service delivery architecture (such as service creation,

session control and protocols) for a type of service. It has modules as

Service Creation Environment, Execution Environment, Services information

model, Integration and Relationship to Service-oriented architecture

(SOA).SDP offered and managed a real time service to the operator and to

the customers. SDP handles the velocity of the online business events.

Services information model used in the SDP design that represents the

online business of the operator.

Role: Software Engineer

< Designed and Implemented runtime menu creation module

< Involved in integration support application, such as CRM, billing,

service activation, third party applications and services

< Designed and developed cross tab reports, reports with sub-reports

(linked and unlinked) and chart reports

[pic]

Project : mChat Application Feb 2011-Jun 2011

Client : Reliance and Vodafone Team Size: 2

Platform : ASP.Net, SQL Server 2005And WCF

Project Description:

Mobile based USSD application Software which helps to visitors for

communicating with the respective SME/Therapist when they are online. mChat

System is a fun filling and social networking service which provides fast

and interactive way to Communicate within friends. Responsible for the

development of front end, back end designing and coding etc. Developed

session module, friend list module, Design and Implement runtime menu

creation module

[pic]

Project : 3paisa Sep2010 - Jan2011

Platform : ASP.Net, SQL Server 2005, Crystal Reports XI and WCF Team

Size: 3

Project Description:

3paisa is web based application, where client request for bulk SMS push.

Users can purchase a SMS account where they can upload the cell no for the

promotional message with a Login ID. SMS account shows all the transaction

of user & Credit and debit amount in account.

Role: Software Engineer

< Developed User Authentication Module and Session Module to maintain

user states

< Developed and maintained code to high standard and project maintenance

< Developed SMS Credit module to buy new SMS for the existing user

< Developed Transaction module to keep record for each transaction

< Developed FTP module where user upload file contains cell no for SMS

push.

< Design and Implement GUI and used Data Grid to show user transaction

history.

< Worked with team members to cross-train on application

< Designed and developed cross tab reports, reports with sub-reports

(linked and unlinked) and chart reports.

< Set filters, suppression formulae and used highlighting expert to show

the data the users would like to see in a more concise and presentable

format.

< Developed various charts and graphs like Bar chart (side-by-side,

stacked), line graphs, Gantt Chart etc by using Chart Expert using

Crystal Reports XI.

[pic]

Project : Electronic Billing System May2010 -Aug2010

Client : Climate Control

Platform : VB.Net, MS Access 2003 and Crystal Report 10

Project Description:

Computerization the manual invoice and bill generation process

Role: Software Engineer

< Developed Product master module, where client import all product data

from Excel.

< Developed Billing master module where client maintain bill details,

client details, etc

< Developed Billing Details module where client maintain details

transaction like price, product, quantity etc

< Designed and Implemented Reports in Crystal Report for easy print and

export options

< Built the mechanism to export reports into various formats like Excel,

PDF, text and XML formats

[pic]

Project : Games on USSD Jan2010 - Apr2010

Client : Reliance Communications, Vodafone

Platform : ASP.Net, SQL Server 2005

Project Description:

: A) Tic Tac Toe:-Reliance Communications Games on USSD is being

launched with one of the most popular games Tic Tac Toe also commonly known

as Noughts & Crosses. The simplicity of tic-tac-toe makes it ideal as an

educational yet fun tool for teaching concepts of strategy. Here users will

pit themselves against the program itself. The player who succeeds in

placing three respective marks in a horizontal, vertical or diagonal row

wins the game.

: B) Cricket Game:-Cricket Game on USSD is a interactive game, Where

user play a cricket by selecting the team. The computer will select

opposition team randomly from the remains, after that user will select to

bowl or bat. And games begin, its 2 over match (12 balls game) each side.

[pic]

Project : Reports & Error Tracker Oct2009

- Dec2009

Client : Contakt Tech Solution India Pvt. Ltd.

Platform : VB.Net, SQL Server 2005, Crystal Reports

Project Description:

It is a window based application which helps to generate and send daily

basis auto report to subsequent E-mail ID on time. Executions of auto

reports, 24hrs running Exe added. If Exe turn off than software will

automatically restart the application. Maintains reports and errors

generate by application & displaying at error viewer Screen.

Role: Software Engineer

< Created Crystal Reports using Crystal Reports formulae, Grouping,

Parameters, Selection criteria

< Extensively worked on reports that contained several Static and

Dynamic prompts

< Built the mechanism to export reports into various formats such as

Excel (including data only, Excel export), PDF, text and XML formats,

Assisted the team working on the scheduling the reports via Auto Sys.

[pic]

Project : LPG Gas Booking via SMS and USSD Jun2009 - Sep2009

Client : IOCL, BPCL Team Size: 3

Platform : VB.Net, MS-Access

Project Description:

A) SMS BASED Indian Oil (IOC) and Bharat Petroleum (BPCL) consumers

will have to do a onetime registration of their mobile phone number by

text messaging their local LPG distributor number and consumer number to

54625 and 52725 respectively. Thereafter, they are required to type LPG and

send it to the same number to book LPG refills.

B) Customers with USSD facility in their mobiles, Customers will have

to register their cell numbers by dialing *501* for IOC and *502* for BPCL,

followed by the distributor's number, again *, consumer number and #

without any space. Currently SMS and USSD facility is available with

Airtel, Vodafone, IDEA, TATA &MTNL services.

[pic]

Project : ICICI Mobile Banking Jan2009 -May2009

Client : ICICI Bank Team Size: 2

Platform : Asp.net, MS SQL Server 2005

Project Description:

It is a web based application where the user can request for mobile banking

service by dialing *525# code on his mobile. User can request for service

like bank account, Credit Card, Demat Account and for other services

(customer care number, find an ATM, find a branch and apply for new

account).

Role: Software Engineer

< Developed Session Module to maintain user states

< Design and Implement runtime menu creation module

< Implement cache memory to store data from database, to avoid frequent

hit on database for mapping the user dialed string for menu.

[pic]

Project : Requesting Application Framework For USSD Jun2008 - Jan2009

Platform : Asp.net, MS SQL Server 2005 and Excel Macros (VBA) Team

Size: 3

Client : Vodafone, MTNL & BSNL, Reliance GSM, TATA Docomo, Videocon,

Air Tel

Project Description:

USSD Center enables subscribers to establish interactive, menu-driven

sessions where they can request text/data from the system. Through the USSD

center, requests/commands can be sent under full operator control, to

numerous sources of information: operator internal systems, corporate ERP

system or to Internet.

Absence of store and forward, transaction-oriented technology ensures that

USSD is seven times faster than SMS and significantly reduces turn-around

response time for dialogue-based responsive services like customer care,

banking and information services.

Role: Software Engineer

< Developed Session Module to maintain user states

< Design and Implement runtime menu creation module

< Implement cache memory to store data from database, to avoid frequent

hit on database for mapping the user dialed string for menu.

< Design and Implement VBA (macros) to generate MIS report and chart

ACADAMIC PROJECT

Project : Induction Programme

Client : ICICI Bank

Platform : Asp, Java Script, VB Script and MS Access 2003

Project Description:

It's Specific on-the-job training, which aims to assist the employee to

attain proficiency in the job as soon as possible.

< Developed Security Module to maintain user, department, and

transaction like new employee entry, issuing necessary book permission

for induction

< Developed Transaction Module to keeps record of employee transition

throughout the session from various departments.

< Developed Master Module to maintain employee id, department, user

rights, and report details.

< MIS reports, for each trainee, on how much time he had taken on a

topic, has he completed the entire course ware.

PERSONAL DETAILS

Date of Birth : 20th Jan 1986

Language Known : English, Hindi and Marathi

Valid Indian Passport Holder

(Purshottam Vaishnav)

Contact this candidate