Sql Server Project Manager

KAUSHIK BHATTACHARYA

***,** ** ****** **,APT #***

Rochester MN – 55906, USA

Contact: 862368664(Cell)

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

PROFESSIONAL SUMMARY

Summary: 13 years of experience with system analysis, design and development in various stages of the

software development lifecycle. Specifically: Requirements analysis, functional design, systems migration,

business system modeling and development. Have worked in multiple industries such as healthcare,

financial services, shipping industry and chemical lab solutions.

Experienced with SDLC with variety of methodologies including Rational Unified Process,

•

Waterfall, Spiral and Agile Software Development using MVC framework.

Experienced in object oriented analysis, modeling and designing, UML and design patterns.

•

Expertise in .Net 3.0, SQL Server 2005, Sybase 12.5, Crystal Report XI, MS Reporting Services.

•

• Experience with Financial Fusion Server 2.0 (a product of Sybase), which conforms to the e-

banking industry standards like OFX, FIX protocols.

Experience and Skills

• .Net 2008 with C#,SQL Server 2008,SSIS,SSRS,Powerbuilder 9.0,C++,UNIX – Shell Script, Pl/SQL,

Pro*C,SQL Server Reporting Services,UNIX – Shell Script,Oracle PL/SQL, Sapphire,Java, JTF,

Crystal Report XI,LoadRunner 8.1,Quick Test Pro 9.2

.

Areas of Expertise

• .Net Technical Lead

• Onsite Project Manager

• System Analyst

• SQL Server 2005 developer

• MS Reporting Services Developer

• Oracle Developer

• Powerbuilder Developer

• Software Testing with LoadRunner

• Software Testing with QuickTestPro

Education

• New York Institute of Technology, New York, NY

Master of Science in Computer Science with Distinction,2005

• RCC at Jadavpur University Campus, Calcutta, India

Post Graduate Diploma In Computer Application with Distinction, 1997

• University Of Calcutta, India

Bachelor of Science with Honours in Chemistry with 2nd Class, 1995

Experience Highlights

.NET Technical Lead – WellsFargo – Performed mission critical application support and new

development as a technical lead under .Net 2005 and 2008 technologies.

System Analyst and Designer – Mayo Clinic- Performed as a business system analyst using Rational Case

Tools and Erwin, failure / risk analysis of vendor/3rd party created software.

.NET Web Developer – United Health Group, Mayo Clinic – Worked as web developer and report

designer with Microsoft SQL Server 2005, SSIS, ASP .Net 2008.

Project Manager – United Health Group - Managed several small healthcares IT Projects with 4 to 6

offshore developers. Performed scope development, timeline scheduling, resource management, project

risk identification, budget and cost tracking. Implemented CMM Level 4 methodologies.

SSRS Report Developer – United Health Group – Developed over 40 reports in SSRS for a client

healthcare analytics tool.

Crystal Report Developer – United Health Group, Mayo Clinic, NYSDOT - Analyzed and developed

several complex healthcare analytics crystal reports for Healthnumerics.

Software Testing – Mayo Clinic - Worked with Mercury Load Runner, QuickTestPro, TestDirector and

Compuware DevPartner Studio for performance testing. Developed quality guidelines for black box testing,

load testing, beta testing, and performance testing.

SQL Server 2000 Application DBA – Kaplan Scheweser - Served as application DBA with SQL Server

2000 for query optimization, database backup, running jobs and running SSIS packages.

PowerBuilder Designer and Developer – Contract Services - Designed and developed application

software with PowerBuilder 10 as client and SQL Server or Sybase as back end.

Java and J2EE Developer- Financial Fusion at Sybase - Worked as a developer with JavaBeans, JTF,

JavaScript and Message Broker, Financial Fusion Server 2.0 (a product of Sybase), which conformed to the

e-banking industry standards like OFX, FIX protocols.

Professional Experience Summery

Comsys LLC 02/02/2009 – 09/31/2009

Finance- Wells Fargo Bank

Industry:

Consultant

Position:

Environment: Microsoft web technologies

C#, .Net 2008, SQL Server 2005, SQL Server Reporting Services, SSIS,JSON

Tools:

Working as lead technical,business analyst and .Net developer with Wells COPS project.

Responsibilities:

• Detail System Analysis of the existing software

• JSON, JavaScript and Web Service development with WCF and C#

• Designed 16 main functional screen in .NET for Wells Internal Credit check application

• Client script with ASP.NET AJAX

• Designed main business logic flow of COPS

• Excel import of Customer Data with SSIS packages

• Developed CLR procedure in SQL Server 2008 and called them from .NET

• Designed 12 complex reports with SSRS and SQL Server runs from .NET application

• SQL SERVER 2008 stored procedure optimization

Compuware Corporation 11/17/2008 – 01/31/2009

Healthcare - United Health Group

Industry:

Lead Consultant

Position:

Environment: Microsoft web technologies

C#, .Net 2008, SQL Server 2005, SQL Server Reporting Services

Tools:

United Health Group via enterprise compliance was implementing a united audit for patient electronic

medical records. The main purpose of the project was to generate complex audit reports as a healthcare

analytics tool.

Responsibilities:

• System analysis and design of the existing software

• Requirement analysis of United Audit Reports

• Developed SSRS Reports with complex financial formulas

• Wrote SQL Server 2005 stored procedures to get the data from back end database

Williams and Williams Auction Network 07/30/2008 – 11/15/2008

Real Estate - Auction Network

Industry:

Senior Web Developer

Position:

Environment: Microsoft web technologies

C#, .Net 2008, SQL Server 2005, ASP, Flash,VB6.0

Tools:

Williams and Williams, through its online real estate portal, was preparing an online bidding

application to make it compatible with OpenTV interface. The objective of the project was to enhance

and rebuild their website to make it online auction compatible for their customers.

Responsibilities:

• Conversion from VB6/ASP pages to .NET WebForms

• Store procedure with SQL Server 2005

• Open TV integration with web site and flash module

• Support and enhancement of existing ASP website application

• Software testing and integration

Taj Technologies Inc 05/23/2005 – 07/29/2008

Projects Worked On :

Financial - Kaplan Scheweser Duration: 02/22/2008 – 07/29/2008

Industry:

Sr System Analyst

Position:

Environment: Microsoft web technologies

Microsoft SQL Server 2005, SSIS

Tools:

The main purpose of the project was to develop the Kaplan Order Processing System Application to

make it compatible with their online and physical training course products.

Responsibilities:

• Lead analyst and chief database designer

• Data extraction from OPS with complex business rules with SQL Server 2005

• Wrote several complex stored procedures for data extraction

• SSIS package creation to export data in flat file

• Troubleshot and resolved application and infrastructure errors, performance and scalability issues

Healthcare - Mayo Clinic Duration: 02/15/2007 - 02/21/2008

Industry:

Sr System Analyst

Position:

Microsoft web technologies and cold fusion technologies

Environment:

.Net 2005, MS SQL Server 2005, Sybase ASE, SSIS, LoadRunner, Quick Test Pro,

Tools:

Cold Fusion, Tortoise SVN,VB6

Expert RN is 24/7 nurse triaz application responsible for patient care and patient electronic medical

records.

The purpose of the project was to do performance testing and develop new tools for ExpertRn.

Responsibilities:

• Lead analyst and chief .Net designer

• System analysis of the existing software

• Failure analysis of the existing software

• Supported existing Expert RN .Net 2005 application

• Support cold fusion website

• Conversion of VB6 to .NET 2.0

• Performance testing with Load Runner and QuickTestPro

• Developed several stored procedures in Sybase to access CRD repository

• SSIS data transformation

• Reverse engineering for database design diagram with Sybase Power designer

• MS SQL server 2005 stored procedure optimization

Healthcare - United Health Group Duration: 01/02/2006 – 02/14/2007

Industry:

Sr System Analyst

Position:

Microsoft web technologies

Environment:

Microsoft Visual Studio .Net Framework 2.0, C#, Web Form, Win form, Ajax 2.0,

Tools:

Crystal Enterprise XI, MS SQL Server 2005 with DTS, Microsoft Web Reporting

Services for .Net 2005, MS Project

Designed and developed HealthNumerics Analytics project for United Health UK. The project dealt

with 40 million UK HES data objects and performed risk assessment and healthcare cost budget

tracking for NHS healthcare organizations all over the country.

Responsibilities:

• Requirement analysis and client interaction

• Onsite technical lead and project manager

• Experience with onsite offshore development module

• Designed and developed HN3.0 in VS.net 2005 Webforms with MS reporting services

• Supported existing .Net based Winform application with C# for United Health UK

• Supported existing HN2.0 C# /.Net Winform application

• Stored procedure for SQL Server 2005

• AJAX client scripting

• 40 million UK HES data processing

• Dashboard report with Dundas Chart

• Report Design with Crystal Enterprise XI and Crystal report Viewer Control

Industry: Healthcare - Mayo Clinic Duration: 05/23/2005 – 12/31/2005

Sr System Analyst

Position:

Environment: Microsoft web technologies

.Net 2005, Crystal Enterprise XI, MS SQLServer 2000, MS Project

Tools:

Software development for Medicare Strategy Unit in Medicare based transplant surgeries.

This project was developed for mayo transplant physicians and mayo allied staff to enter their billable

time and demographic information. Several complex reports were developed with this system which

served as a decision support system.

Responsibilities:

System design with VISIO

•

Developed .Net 2005 reimbursement module of Medicare paid transplant surgeries

•

Developed employee salary module

•

Developed custom stored procedure to store data in MS SQL Server 2000

•

MS SQL Server 2000 stored procedure

•

Report using Crystal Report XI

•

Assembly and product testing

•

Version control with PVCS

•

Mayo Clinic 05/09/2004 – 09/31/2004

Healthcare - Mayo Clinic

Industry:

Position: IS Intern

RFID Tracking with Microsoft technologies and cold fusion technologies

Environment:

Microsoft Visual Studio .Net, C#, Winform, Globe Ranger iMotion middleware,

Tools:

Cold Fusion, Crystal Report 10.0, DTS, HTML and Sybase Adaptive Server

Enterprise 12.5, MS Project

Mayo Clinic wanted to track their medical and hospital equipment in Saint Mary’s hospital with RFID.

These projects created workflow solutions by reading the RFID tags from the equipment, tracked them

graphically by storing all the information in the database, and managed their inventory.

RFID tracking for medical equipment

•

RFID active and passive tag detection through Imotion Edgeware and C# in .Net

•

SmartShelf implementation at Mayo Pharmacy with RFID

•

Automatic inventory update and purchase order generation for pharmacy

•

Designed custom workflow with Imotion Edgeware (3rd Part GUI) and C# in .Net

•

Developed C# routine for handshaking with RFID tags module with WINFORM

•

Developed special C# module to capture RFID tag, distinction between active and passive tag

•

Developed custom stored procedure to store data in Sybase

•

Sybase RDBMS trigger and stored procedure

•

C# routine for custom email /pager message generation and capture dynamic Video

•

System Design with Sybase Power Designer 12.5

•

Worked with AR system (Remedy)

•

Report generation with Cold Fusion and Crystal Report 10.0

•

Windows messaging through RFID Workflow and C#

•

New York Institute of Technology 09/15/2003 to 05/06/2004 & 10/1/2004 to 05/22/2005

Education – NYIT

Industry:

Position: Graduate Assistant

Environment: Microsoft technologies

C#, Microsoft.Net (ASP.net), Winform, SQL Server 2000, DTS, Crystal Report 9.0

Tools:

Project :Medical Billing System with patient database.

Project:Student Information Management System for College Writing Center

Responsibilities:

• Object-oriented system analysis and design with UML

• Client interaction and project management

• Experience in cleaning up and optimizing database schema

• Designed Patient, Therapist, Session, Payment, Adjustment, Referral Source, Insurance, Employer

module with WINFORM

• SQL Server stored procedure and trigger experience

• Data transformation with DTS

• Design and development of reports using Crystal Report

Contract Services 08/01/ 2002 - 08/12/ 2003

Software Consulting

Industry:

Consultant

Position:

Oracle platform

Environment:

UNIX Shell Script, Oracle 8i, Proc *C, Informix, Oracle Application Server,

Tools:

Business Objects, PVCS

Designed and implemented an in-house data warehouse. Data was collected from Oracle, flat files

(Web Logs), SAP database (INFORMIX) and were transformed into a warehouse. OLAP application

was built on top of the warehouse stored in oracle 8i using Business Object.

Responsibilities:

• Involved in SRS preparation and functional analysis

• Prepared all the functional screens

• Implemented test results and employee history by OLAP application

• Migration of legacy database into Oracle 8I

• Pro*C sub routine generation

• Unix shell scripting under Sun Solaris 8.0

TCG SOFTWARE INC 08/14/2000 – 05/20/2002

Duration: 01/16/2002 - 05/20/2002

Projects Worked On:

Transportation - New York State Department of Transportation

Industry:

Sr. Consulting Analyst

Position:

Environment: PowerBuilder technologies

Sapphire 1.4, PowerBuilder 8.0 with PFC, VbScript, ORACLE 8I, PL/SQL, PRC*C,

Tools:

Business Objects, PVCS

Project: LIMS for Technical Services Division NYSDOT Lab

This project was developed to help lab chemist to perform sample tracking using Lab Vantage sapphire

LIMS and generate complex reports for their research process.

Responsibilities:

• Involved in SRS preparation and functional analysis with VISIO

• Client interaction and managed three developers

• Involved in designing the workflow model using SAPPHIRE 3.0

• Created Universe and Business Views in Business Objects Business View Manager

• Data transformation with stored procedure

• Strong stored procedure and trigger experience with PL/SQL and PRC*C

• Assembly and product testing

• Version control with PVCS

Research - Material Research Corporation Duration: 09/01/2001 – 01/15/2002

Industry:

Consultant

Position:

PowerBuilder technologies

Environment:

Sapphire 1.4, PowerBuilder 8.0 with PFC, VbScript, Oracle 8I, Business Objects,

Tools:

PVCS, MS Project

Project: LIMS for Material Research Corporation

This project was developed to help lab chemist to perform sample tracking using Lab Vantage sapphire

LIMS and generate complex reports for their research process.

Responsibilities:

• Worked as a lead system analyst and designed the Laboratory Automation system using

SAPPHIRE (A Core PowerBuilder 8.0 product which provided a graphical interface that allowed

users to create workflows- models that described the events and decisions that occurred as data

moved through a process or procedure. Using workflows, users could easily automate both

analytical processes in the laboratory and manual tasks that were performed on a regular basis.)

• Client interaction and managed three developers

• Involved in SRS preparation, database design with Oracle 8i, implementation of business logic

through SAPPHIRE

• Developed the user interface for MRC lab in order to automate repetitive tasks that users

performed such as printing reports and sending e-mails of sample results

• Strong stored procedure and trigger experience with PL/SQL

• Data transformation with stored procedure

• Created Universe and Business Views in Business Objects Business View Manager

Financial – Sybase - Financial Fusion Duration: 08/14/2000 – 08/14/2001

Industry:

Consultant

Position:

J2EE Technologies

Environment:

Java Beans, Java Template Framework, JSP, CORBA, OFX, FIX Message Broker,

Tools:

XML, XSLT, HTML, Financial Fusion Server, WebSphere, Jaguar CTS, UNIX

Shell Script, and Oracle 8i, MS Project

Projects: Online Banking Project for First Citizens Bank

Online Banking Project for BANCO MERCANTIL Bank, Miami

Online Banking Project for ABN AMRO Bank, Chicago

Online Banking Project for MI BANCO POPULAR Bank, Puerto Rico

The above four online banking projects were developed to enable customers to do online banking

using OFX and FIX technologies.

Responsibilities:

• Developed risk management tools for business customers

• Involved in customer pin authentication

• Solution implemented using JTF, Servlet, CORBA, Message Broker, UML Modeling with

Rational Rose

• Data modeling and database design using Sybase Server 11. Stored procedure development using

T-SQL

• Involved in t+1 STP (Straight Through Processing)

• Implementation of FIX, OFX, SWIFT using Sybase Financial Fusion Server

• Developed JTF (JSP equivalent) pages for login and enrollment module, secondary user

maintenance module, updating the profile of the primary business or retail customers

• Developed JTF (JSP equivalent) pages for Accounts, Transfer, Service/Mail modules

• Developed JTF (JSP equivalent) pages for Privacy Statement and Disclaimer modules

• Developed JTF (JSP equivalent) pages for Online Help module

• Shell scripting In Unix

• XML, DTD, XSLT, CSS, JavaScript development

• Performance management, capacity planning and configuration management for the systems

• Involved in software testing

TCG SOFTARE SERVICES PVT LTD 09/01/1998 – 08/13/2000

Consulting

Industry:

Software Engineer

Position:

Environment: PowerBuilder 6.5 technologies

Power Builder 6.5, Power tool, C++, DataArchitect, Sybase under Unix, PVCS

Tools:

Project: LIMS For Trilogy Advanced Prescheduling System (LVTAPS), India

This project was a Lab vantage-LIMS solution for UK based water treatment plant.

Responsibilities:

• Involved in system design

• Developed almost all the screens, forms in Powerbuilder 6.5

• Developed C++ customized user objects used in the application

• Developed all the functional algorithm, implemented business logic, generated reports

• Performed unit testing for desired performance

Transportation - Terminal Automation System

Industry:

Consultant

Position:

PowerBuilder technologies

Environment:

Power Builder 6.5, PFC, Visio, MSSQL Server 6.5, PVCS, Winrunner and

Tools:

Mainframe CICS

This project was developed for SEALAND, one of the largest container manufacturing companies, to

track their shipments electronically throughout the globe.

Responsibilities:

• Involved in system design and performed the role as one of the key developers

• Developed screens for Gate, Inbound, Empty Dispatch, Yard in Powerbuilder 6.5

• Implemented business logic for the handheld PC in yard

• Developed all functional algorithms, implemented business logic, enhancement and bug fixing,

generated reports for all modules listed above

• Performed unit testing for desired performance

Government - Haldia Land Acquisition Maintenance System

Industry:

Consultant

Position:

Environment: PowerBuilder 6.5 technologies

PowerBuilder 6.5, Sybase System 11.0 under Windows NT, Winrunner, Visio

Tools:

Project: Haldia Land Acquisition Maintenance System

Responsibilities:

• Involved in system enhancement and bug fixing of the existing system

• Developed all functional algorithms, implemented business logic, enhancement and bug fixing,

generated reports for three modules

• Performed unit testing for desired performance

Financial

Industry:

Consultant

Position:

Environment: PowerBuilder 6.5 technologies

Power Builder 6, Sybase System 11.0 on Windows NT

Tools:

Project: Inventory Control System

Responsibilities:

• Involved in system enhancement, integration, bug fixing, change request of the existing system

• Developed major functional algorithms for enhancement

• Performed unit testing for the desired performance

Financial

Industry:

Consultant

Position:

Environment: PowerBuilder 6.5 technologies

Power Builder 6.5, C, Sybase System 11.0 under Unix, Visio

Tools:

Project: Treasury-2000+

Responsibilities:

• Performed requirement analysis and design

• Developed and implemented analytical algorithms for the risk management of complex securities

• Implemented option value algorithms and Black & Stoles algorithms of the securities using C

• Performed client interaction

• Performed unit testing for the desired performance

Regional Computer Center, Jadavpur University Campus 01/01/1997 – 08/31/1998

Education - RCC

Industry:

Project Trainee

Position:

Environment: Power Builder 6.0 Technologies

Power Builder 6.0, Turbo Analyst, Sybase System11.0 and Sybase SQL Anywhere

Tools:

Project: Tea Tracking System

Responsibilities:

• Performed requirement analysis and design of the existing system for enhancement

• Performed client interaction

• Designed the major screens

• Performed unit testing for the desired performance

Contact this candidate