.Net Sql Server Project Business Developer Management

Kanishka Pathak

* ***** *****

Jersey City, NJ **310

Email: ******@*****.***

Phone: 267-***-****

______________________________________________________________________________

SUMMARY

• Over 6 years of extensive experience in business analysis, design and development of

business information systems and web applications using Microsoft Technologies in

fields such as Insurance, Government, Education, Healthcare and Interior Design.

Extensive experience in all stages of software design lifecycle in Waterfall as well as Agile

methodologies.

Demonstrated success in designing mission-critical systems. Excellent working knowledge of

data modeling and large-scale enterprise software design.

Expertise in OOPS technology, with extensive experience and knowledge in .NET, ASP.NET,

ADO.NET, C#, XML, Web Services.

Strong SQL Server 2000 and 2005 database skills including database design, stored procedures,

triggers, functions, views and DTS packages.

• Strong knowledge of configuration management tool – Visual SourceSafe.

• Working knowledge of FLASH and Silverlight.

• Innovative problem solver, able to see the business and technical sides of a problem.

Team player with effective interpersonal communication skills, desire to learn and a

positive, can-do attitude.

SKILLS PROFILE

Languages/Technologies: C#, VB.NET, ASP.NET, ADO.NET, VSTO, XML, SQL, CSS,

JavaScript

Databases/RDBMS: SQL Server (2000/2005), T-SQL, Stored Procedures, triggers, SQL

Enterprise Manager, MS Access

Source Control: Visual SourceSafe

Operating Systems: Windows 2000/2003/NT/XP

Software: Macromedia Fireworks, Dreamweaver MX 2004, FLASH MX 2004, MS-Excel, MS

Project, Visio, Word, PowerPoint, FrontPage

Tools: Active Reports

Insurance Packages: RMS and AIR

EDUCATION

New York University

Degree: Master of Business Administration

Field: Finance, IT and Marketing

Status: Currently pursuing

Temple University

Degree: Master of Science

Field: Computer and Information Sciences

Graduated: Dec 2004

Mumbai University

Degree: Bachelor of Engineering

Field: Computer Science

Graduated: July 2002

PROFESSIONAL EXPERIENCE

ACE USA Sept 2007 – Present

Sr. Business Analyst/.NET Developer

FuturTech Consulting, LLC Jan 2005 – Aug 2007

Programmer Analyst III

Database & Client Server Computing Jun 2004 – Dec 2004

Software Developer

PROJECTS

ACE USA Sept 2007 – Present

Project: Catastrophic Risk Modeling

Environment: ASP.NET, C#, ADO.NET, JavaScript, CSS, AJAX, SQL Server 2000 & 2005,

IIS 6, Visual Source Safe, MS Visual Studio 2005 (.NET 2.0), MS Visual Studio 2008 (.NET 3.5)

Description: This project combines results from three different pricing engines to come up with

competitive price estimates for insurance underwriters. The project entails managing accounts,

users, work queue and generating Excel reports for accounts run.

Responsibilities:

• Analyze unique catastrophic risk pricing model to estimate competitive price selection

for underwriters using SQL, RMS and AIR

Develop ASP .NET C# application to manage accounts, workflow and generate Excel reports

using XML

Develop business component C# libraries to handle pricing and process flow

Create and maintain SQL Server databases and perform data analysis

Create DTS/ SSIS packages in SQL Server for data load

Work closely with business on a daily basis to gather requirements, analyze the problem,

implement as well as document solution accordingly

• Conduct detailed analysis of new risk tools and their feasibility to business

• Design and implement project to model accounts directly from customized Excel

spreadsheet using VSTO, thereby eliminating reliance on third party software

• Work directly with QA team to develop testing strategies for the UAT environment

Generate custom as well as ad-hoc reports for periodic review by higher management

Manage production rollouts to new business units

Provide production support as and when needed

• Actively participate in new initiative to move towards Agile development methodology

Delaware Department of Labor

Workers’ Compensation Unit Mar 2006 – Aug 2007

Project: Scheduling, Case Management, Accounting & Reporting System (SCARS)

Environment: ASP.NET, C#, ADO.NET, VSTO, JavaScript, CSS, AJAX, SQL Server 2005, IIS

6, Visual Source Safe, MS Visual Studio 2005 (.NET 2.0)

Description: When employees are injured at their work place, they file a petition against their

employer to demand compensation. This results in the generation of a case. SCARS handles all

aspects of this case - right from it's generation to disposition.

Responsibilities:

• Actively involved in requirement gathering, scoping, prototyping, documenting

functional and business requirements

Solely responsible for designing the web layout and style sheets.

• Lead developer for Case Management and Document Management Modules of the

system.

• Actively involved in coding the Scheduling module of SCARS.

• Extensively designed and implemented stored procedures and functions.

• JavaScript and ASP.NET validation controls used for client-side and server-side

validations of the controls and fields used.

Used AJAX to code auto-complete textboxes.

Delaware Secretary of State

Division of Corporations Sept 2005 – Feb 2006

Project: Integrated Corporation Information System (ICIS)

Environment: ASP.NET, C#, ADO.NET, JavaScript, CSS, SQL Server 2005, IIS 6, Visual

Source Safe, MS Visual Studio 2005 (.NET 2.0)

Description: Division of Corporations wanted to convert their legacy system to a newer

technology (.NET/J2EE) to enable faster and more efficient processing of day-to-day business.

This project involved conducting a software requirement analysis for this system. Project also

involved generating a web portal replete with surveys, questionnaires and a message board to

help the employees of the department to participate more effectively and efficiently in the

process.

Responsibilities:

• Interviewed users and gathered current and new system requirements

Reviewed the application to be converted and documented its features

• Designed and developed a web portal consisting of surveys, questionnaires and a

message board for assisting in the Software Requirement Document generation

process.

Created class libraries in C# to handle database transactions.

• Generated statistics of survey/questionnaire results

• Created a requirements document designed to the Division’s standards.

Data Service Center

School District of Delaware Jan 2005 – Jun 2005

Project: Reported Time Payroll

Environment: ASP.NET, VB.NET, ADO.NET, JavaScript, CSS, SQL Server 2005, IIS 6, Visual

Source Safe, MS Visual Studio (.NET 1.1), Active Reports

Description: This was an extensive web based application whereby employees of the school

district of Delaware can enter their hours of work on a form online. The hours thus reported, are

then approved/denied by their respective approvers and periodic reports are generated.

Responsibilities:

• Designed and developed web based Reported Time Payroll System using ASP.NET,

VB.NET, ADO.NET and SQL Server 2000

• Involved in website design, database design, writing stored procedures, views

• Created DTS packages in SQL Server for data transfer from flat files to SQL Server

tables

Creating reports using Active Reports

Design and Development of websites Jun 2005 – Aug 2007

Projects: Design and Development of websites/ web applications/web portals

Environment: ASP.NET, VB.NET, ADO.NET, JavaScript, CSS, SQL Server 2000/2005, IIS 6,

Visual Source Safe, MS Visual Studio (.NET 1.1/ 2.0), Macromedia Fireworks, FLASH MX

2004

Description: Designed and developed websites for wide ranging clients including interior

decorators, congressmen, doctors and the government.

Responsibilities:

• Meet with the users to gather requirements

Generate project scope and time frame

Create screen prototypes

Design the layout of the website and establish style sheets

• Develop logos and graphics to be put on the website including images and FLASH

movies using Macromedia Fireworks and FLASH MX 2004

Design and develop database (SQL Server 2000/2005)

Create static pages and dynamic pages of the website using ASP.NET and C#

• Create system administration unit to facilitate the clients to administer the website

themselves

Test and deploy the website

Philadelphia Gas Works (PGW) Jun 2004 – Dec 2004

Project: Transaction management System (TMS)

Environment: VB.NET, ADO.NET, XML, Oracle 9i, Visual Studio .NET 1.1

Description: The TMS handles the transactions between various Gas vendors and PGW. These

transactions involve requests and responses from vendors to PGW and vice versa. The

transactions are XML messages that are validated against XDR schemas, parsed and used to

populate the tables in PGW database. VB.NET was used to process and build the XML messages.

The database used was Oracle 9i.

Responsibilities:

• Designed and developed the application in VB.NET

Involved in designing the database in Oracle 9i

Created XML parser to read data sent from the vendors and save it in the database

Validate the XML file against a schema

• Writing stored procedures and views

Philadelphia Gas Works (PGW) Sep 2004 – Dec 2004

Project: Collections System

Environment: ASP.NET, VB.NET, ADO.NET, Map Location Web Service, Oracle 9i, Visual

Studio .NET 1.1

Description: The system was developed for collecting the gas bill from PGW defaulters; it

involved dividing Philadelphia into clusters and assigning these clusters to the PGW collectors.

Map Location Web Service was used to get the X, Y coordinates of an address and based on these

X,Y values, the city was divided into clusters. A GUI was developed for assigning these clusters

to the PGW collectors.

Responsibilities:

• Designed and developed the application using VB.NET

• Conducted extensive research on available web services to suit our needs

• Used Map Location web service to locate a destination based on its X and Y co-

ordinates.

References: Available upon request

Contact this candidate