Project Design .Net Business Sql Server Development

Summary

. Over ** years of IT industry experience with 9 years working as

Team Lead and architect role.

. Experience in architecture design and development of database

driven Web based and client server applications using Microsoft

technologies.

. Complete product development lifecycle of applications, including

participation in requirements gathering, planning, technical

analysis, architecture design, development, testing, deployment and

maintenance.

. Experience on developing windows and web applications using .NET

Framework 3.5 using C#, ASP.NET, WCF, Web Services, JQuery, CSS,

SQL Server, T-SQL.

. Experience on analysis, design and developing Data Warehouse

applications and Reports using SSIS, SSAS and SSRS.

. Follow Agile software development methodologies and practices.

. Implemented Service Oriented Architecture (SOA), object oriented

methodologies and practices, Software design patterns.

. Designing large and highly scalable multi tier web based systems,

client server system, web services and desktop applications.

. Experience with Database design, Data Modelling, Transact SQL,

performance tuning, optimization and troubleshooting.

. Target oriented with ability to work in small / large teams as well

as independently with excellent interpersonal skills.

. Business Domain: Banking, Insurance, Publishing, Manufacturing

Education

. Microsoft Certified Database Administrator (MCDBA) from Microsoft,

USA

. Postgraduate Diploma in Computer Application, New Delhi, INDIA

. M.S. in Mathematical Statistics, Utkal University, INDIA

. B.Sc(Physics) from Sambalpur University, INDIA

Skills Summary

Programming C#.NET, ASP.NET, HTML, XML, AJAX, JQuery, CSS

Languages

Databases & SQL Server 2008/2012, SSIS, SSAS, SSRS, MDX

Reporting

Servers IIS 7.0, TFS

Web Services WCF, REST,

Tools & Visual Studio 2010, SQL Server 2008/2012, TOAD data

Utilities modeler, Crystal Reports, SQL Profiler, Infragistics,

Resharper, XML Spy, PDF Lib, Install shield, Clear Quest,

Soap UI.

Design Tools Visio, UML,

Operating Windows 7/ Windows XP / Windows 2008

Systems

Professional Experience

Client: COMCAST, Philadelphia, PA

Duration: March 2012 - Contd.

Role : Technical Lead and Architect

Environment: C#, ASP.NET, WCF, REST Web services, Visual Studio 2010, TFS,

SQL Server 2012, TSQL

1. Project SIK OMS is a multiuser, multitier, web based intranet order

management system for maintaining client orders. It is based on

ASP.NET, WCF web services and SQL Server.

2. Project Veener Layer: WCF REST based web services developed with C#

and visual studio 2010.

Role:

. Architecture design, development and implementation of asp.net web

application.

. Data architecture design and Implementation.

. Coordinate a team of developers from offshore and manage development

works regularly.

. Coordinate design review and code review.

. Logical database design and implementation.

. Code and Unit Test software modules.

. Follow SCRUM software development methodology.

. Documentation of process and product implementation.

Client: Wells Fargo, Minneapolis, MN

Duration: October 2010 - Feb 2012

Role: Consultant ( Architect )

Environment: C#, ASP.NET, WCF, SSIS, SSAS, SSRS, MDX, SQL Server 2008

Visual Studio 2010 / 2008.

Project Online Activation (UAM): Used by companies to manage their bank

account and products offered by Wells Fargo bank. Online Activation is part

of UAM. It helps business analysts for activating products online requested

by a company.

Responsibilities:

. Complete architecture design of implementation of asp.net web

application.

. Complete architecture design and implementation of data warehouse

application.

. Created technology proof of concept.

. Involved in architecting full front to back multi tier application.

. Interact with business leaders for business requirements.

. Designed and developed ETL process using SSIS packages and stored

procedures for data import from various database including sql server

and Oracle.

. Designed and developed data warehouse reports.

. Requirement Analysis, System Design and Logical Database Modeling.

. Follow agile software development methodology.

. Documentation

Client: StoneRiver, Cedar Rapids, IA

Duration: October 2007 - July 2010

Role: Senior .NET Developer

Environment: .NET Framework 3.5 (C#.NET), SQL Server 2008, SSIS, SSRS,

WinForms, Infragistics, Web services, WCF, IIS 6.0, LLB Gen Pro, Visual

Studio 2008, Windows XP

StoneRiver is a leading provider of technology, systems and services to

clients in Insurance service Industries.

eFreedom Solution

A client server solution based on Service Oriented Architecture used for

NAIC filing for Insurance companies, it's a multi tier application fully

developed using Service Oriented Architecture and with .NET Framework 3.5.

Responsibilities:

. Requirement Analysis and System Analysis

. Created system prototype, use cases diagram and documentation.

. High level design and documents of the system using UML

. Logical Database Modelling

. Implemented the system using Service Oriented Architecture and used

design patterns.

. Written code using C#.NET 3.5 to implement .NET Web services and used

XML extensively.

. Written Stored Procedures and Views using SQL Server 2008.

. Unit testing on all implemented modules using NUnits.

. Documentation of the product for end user.

. Followed agile software development methodology.

Client: Midland Information Resources, Davenport, IA

Duration: July 2001 - September 2007

Role: Team Lead

Environment: C#.NET, ASP.NET, SQL Server 2005, SSIS, SSRS, JavaScript, IIS

6.0, Visual Studio 2005.Win 2003

Midland Information Resources is a provider of software solutions, on-

demand printing solutions and content management solutions to the clients.

Project 1: Batch Submission project:

A multi tier web based system which provides on demand printing solutions.

It imports and processes orders and generates pdf books, submits jobs to

the printers and generates reports. The web interface was designed using

asp.net and CSS style sheet.The business layer and data access layer was

developed using c#.net. The system houses on IIS 6.0 web server. Logging

and security has been implemented.

Responsibilities:

. Worked as Team Lead and participate in requirements gathering,

. Application Architecture design,

. Developed code,

. Testing,

. Deployment and maintenance.

. Design and build logical and physical database models, stored

procedures and queries.

. Optimize and performance tune stored procedures and queries.

. Collaborate in documenting the system workflow.

Project 2: System Service Log (SSL)

SSL is a Three Tier Web based Intranet Application which supports the print

vendors for the system service log maintenance.

Environment: VB.NET, ASP.NET, JavaScript, IIS 6.0, SQL Server 2005, Crystal

Report 10, Win 2003

Responsibilities:

. Worked as Team Lead and was involved in the full project lifecycle.

. Created User Interface Design using asp.net master pages, created

Database design and class design using UML.

. Created scripts for database and stored procedures and collaborated in

documenting the system workflow.

Project 3: Pick and Pack Version 2.0 (for Von Hoffmann, Davenport, IA)

Von Hoffmann is a document printing and distribution company which manages

large volume of books for distribution to various organizations. Pick and

Pack Version 2.0 is written using .NET 2.0, and SQL Server 2005. This is a

Warehouse management system which facilitates order import, process,

validation and shipping.

Environment: VB.Net 2.0, ASP.NET 2.0, JavaScript, Crystal Reports 10, IIS

6.0, SQL Server 2005, Win 2003.

Responsibilities:

. Worked as Team Lead and involved in requirement gathering with

business team.

. Involved with full application architecture design including user

interface design and high level class design.

. Designed database and written stored procedures.

. Created SSIS packages for importing data to SQL Server 2005 database.

. Optimized SQL queries for performance.

. Involved with coding with team members.

. Unit Testing

. Collaborated with team members on documentation.

Project 4: CMS Import Services (for Center for Medicare Services,

Washington DC)

The CMS Web application uses CMS Import services for order download and

LMRP and PDP Book Components to create pdf books and print component for

OCE printer. The components use XML files to generate pdf books.

Environment: ASP.NET, VB.NET, PDFLIB, XML, Windows2003, SQL Server 2000,

IIS 6.0

Responsibilities:

. Worked as Team Lead and involved with analysis of requirements, high

level design, coding and implementation of the system.

. Used pdf library a third party tool in the component.

. Designed and implemented LMRP and PDP components

. Designed and implemented Print Component for OCE printer

. Created SQL scripts for stored procedures.

. Performed Unit, Integration and System Testing.

. Managed code-base version controlling using MS Source safe Utility

. Collaborated with documentation.

Project 5: CMS .NET (for Center for Medicare Services, Washington DC)

This is a rewrite of the CMS web applications and the COM components using

.NET framework 1.1.

Environment: ASP.NET, VB.NET, PDFLIB 6.0, XML, Windows2003, SQL Server

2000, IIS 6.0.

Responsibilities:

. Worked as a Team Lead and involved in System Analysis and Design,

. Created prototype and high level design document.

. Involved with coding and testing.

. Used MS Visio for design and documentation of the workflow.

. Written SQL stored procedures for the Business logic.

. Used Source Safe for Source code Version maintenance.

. Created database schema design and class diagrams

Project 6: Pick and Pack V1 (for Von Hoffmann, IA)

Pick and Pack is a ware house management system which facilitates order

import, process, validation and shipping. It generates reports for the

management and the customers. This is a three tier web based intranet

application which is used 24X7.

Environment: VB.Net 1.1, ASP.NET 1.1, XML, JavaScript, Crystal Reports 9,

IIS 6.0, SQL Server 2000, Win 2003.

Responsibilities:

. Involved in full project life cycle including analysis, system design,

database design, coding and implementation at the client site.

. Involved in Component Design, prototyped the necessary Business and

Data layer components in VB.NET and created Web Pages using ASP. Net.

. Created scripts for Database and Stored Procedures and using SQL

Server 2000.

. Worked in Crystal Report to create various reports and integrated

reports to application.

. Used MS Visio for class design and documentation.

. Collaborated with team members for the documentation of the system.

. Used MS Source Safe for source control management.

Project 7: CMS (for Center for Medicare Services, Washington DC)

This is an intranet web based asp.net application which downloads orders

and data xml files corresponding to a batch from CMS web server and imports

the data to the database, process orders and submits the generated pdf

books to the printers. Reports are generated based on the status of batch

process.

Environment: ASP, Visual Basic (VB6), PDFLIB, COM, XML, Windows2000, SQL

Server 2000, IIS Web server, Crystal Report

Responsibilities:

. Worked as Team Lead and involved with requirement analysis and system

design.

. Created prototype of user interfaces.

. Designed class diagrams and involved with coding of components.

. Involved with database design.

. Used Visio for design of the system.

. Created SQL stored procedures to implement business rules.

. Collaborate with team members throughout the development life cycle.

. Involved with implementation and user training.

Project 8: Parts profile viewer (for Maytag, Amana, IA)

The Maytag Parts system provides information on model and parts including

images and price. This is a standalone visual basic application which

accesses the MS Access database.

Environment: Visual Basic, COM, Windows2000, SQL Server 2000, MS Access

Responsibilities:

. Worked as a team lead and involved in analysis of the requirements.

. Designed user interfaces.

. Created database design and class diagrams.

. Involved in development of the system.

. Used Visio for class design

. Involved with documenting the workflow.

. Written SQL stored procedures for the business rule.

. Collaborate with team members throughout the development life cycle.

Client : 4CS, Moline, IL

October 1998 to July 2001

Role : Programmer Analyst

Project 1: Single Copy Circulation Palm Application (for Lee Enterprise,

Davenport, IA)

The distribution person at Lee will use this application to capture the

data for delivery and returns of news papers and magazines. The delivery

and returns information is captured through the application and updated to

the server. At the server side various reports are generated based on the

data captured in the palm pilot.

Environment: Visual Basic, COM, CASL 3.0, Palm OS 3.1, WindowsNT,

Responsibilities:

. Involved in System Analysis, Design and Coding as Team leader and

developer.

. Created database design and class diagrams.

Project 2: AdTicket Palm Application (for Lee Enterprise, Davenport, IA)

The salespeople at Lee use this application to capture data for the Ad

tickets using palm pilot and synchronize data to server at day end.

Environment: CASL 3.0, Palm OS 3.1, Windows NT, Visual Basic

Responsibilities:

. Worked as a Team leader and involved with requirement analysis.

. Design of user interface prototype, application design and database

design.

. Created database design and class diagrams.

. Implemented business rules using SQL stored procedures

. Collaborate with team members throughout the development life cycle.

Project 3: E-commerce project for Jay Industries, Cincinnati, OH

The Jay Industries system allows the user for online shopping on different

products. It has other features like content management, personalization,

online request for quotation.

Environment: ASP, ADSI, AUO, Visual Interdev 6, COM, HTML,XML, Site Server

3.0, JavaScript, VBScript, ADO, IIS 4.0 and SQL Server 7.0, Windows NT 4.0,

Visual Basic.

Responsibilities:

. Design of prototype of user interface and development of web interface

using HTML and ASP, Java script

. Implemented business rules using COM components in visual basic

. Written stored procedures in SQL Server 2000.

. Involved with documenting the workflow process.

Project 4: Customer 1st for John Deere, Moline, IL

The application is divided into two parts i.e. Synch Administration and

Data synchronization. Synch administration allows the user to maintain

customer profile information through web based system. Changes of the

server data is uploaded to the client's database and vice versa in the Data

Synchronization system.

Environment: ASP, Visual Interdev 6, COM, HTML, JavaScript, VBScript, ADO,

IIS 4.0 and SQL Server 7.0, Windows NT 4.0

Responsibilities:

. Designed user interface prototype using HTML and ASP.

. Development of ASP Pages for Synch administration using ADO and COM

objects.

Project 5: DMAG (for John Deere, Moline, IL)

This is a web based intranet application which manages customer and

magazine subscription information through user friendly HTML pages

developed using Java Servlets.

Environment: Java Servlet, JDBC, HTML, DB2, Visual Age, Netscape

Enterprise server, Windows NT.

Responsibilities:

. Developed user interface using HTML and java script.

. Developed server side business objects using java servlets for

management of customer information

Project 6: Project Issues Tracker System (for John Deere, Moline, IL)

This is a web application designed and developed to manage the projects

information for the client GVC, John Deere. It has Add, Modify, Delete and

Search facilities on project information. It generates various reports on

project information in HTML format.

Environment: ASP, Java Script, VBScript, HTML, SQL Server 7.0, IIS, Visual

Interdev, Windows NT

Responsibilities:

. User Interface design, database design and coding the application.

Project 7: NSD (for John Deere, Moline, IL)

Web based data management system for the client John Deere (CEC) sales

team. The system maintains sold machine information, runs batch jobs to

process machine data and generates reports.

Environment: ASP, ODBC, Java script, HTML, DB2, Visual Interdev, IIS,

Windows NT.

Responsibilities:

. Analysis of user requirements, Application Design using UML,

. Coding ASP pages and testing the application.

Project 8: ERS Y2K (for John Deere, Moline, IL)

Web based information management system for the John Deere (CEC). The

system maintains data for machines and expenses.

Environment: ASP, Java Script, HTML, SQL Server 7.0, Visual Interdev,

Windows NT.

Responsibilities:

. Analyzed user requirements,

. Designed user interface and database.

. Developed the application using ASP, Java Script, and HTML.

Client: CMC India

December 1996 - October 1998

Role : Engineer ( Software Integration )

Project 1

Crime Investigation support tools ( CIST)

CIST is an application being developed for the purpose of reducing and

enhancing the quality of investigation against crimes being done by the

Investigating officer. It provides tools for handling large volume of data.

Responsibilities:

. Involved with writing codes for data entry screens.

. Responsible for Oracle database administration.

. Worked on Replication manager for transferring data between branch

offices and head office of the organization.

. Regular customer interaction with clients.

Environment: VC++ 5.0, MFC 4.0, OLE controls, Oracle 7.3, Windows NT 4,

UML, Rational Rose98, TCP/IP, Ethernet, ODBC.

Project 2

Administrative Information System

ADMINS is a centralized database management system being developed for the

purpose of computerization of administrative activities of all the branches

and Head Office of CBI. It has been designed and developed on the basis of

Client Server architecture.

Responsibilities:

. Designed and developed the front end data entry interface screens.

. Developed a general purpose utility class which contains general

validation functions for checking errors while entering data in

different controls.

. Written stored procedures for implementing business rules.

Environment: VC++ 5.0, MFC 4.0, OLE controls, Oracle 7.3, Windows NT 4,

UML, Rational Rose98, TCP/IP, Ethernet, ODBC.

Client : AIIMS (India)

May 1993 - December 1996

Role : Programmer

Project 1

Medical Image Processing System

The system displays medical images which is used for medical diagnosis and

research work.

Responsibilities:

. Designed and developed the system using VC++ on Windows 95 platform.

Environment: VC++ 5.0, MFC 4.0, OLE controls, Oracle 7.3, Windows NT 4,

UML, Rational Rose98, TCP/IP, Ethernet, ODBC.

Project 2

Patient Care system

PCS System keeps information of patients in the hospital. Front end is

forms 3.0 and backend is Oracle database.

Responsibilities:

Responsibilities include involved in design of the database and development

of the system.

Environment: Oracle 6.0, Forms 3.0, SQL, PL/SQL

Contact this candidate