Sql Server .Net

Prabhakar Jagtap

Microsoft Certified Professional

Contact 347-***-****

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

PROFESSIONAL SUMMARY:

9+ Years of Software development experience, with a concentration in mission critical enterprise Web

based applications.

Microsoft Certified Professional in Framework 2.0.

Experience in all phases of Software Development Life Cycle (SDLC) including Requirement Analysis, Design,

Development, Implementation, Testing, Integration, Deployment, Documentation and Maintenance.

Experience in the development of database driven systems with web and client server interfaces along

with .Net Framework Experience (ASP.NET, ADO.NET and C#).

Experience in using Visual Studio 2010, 2008, 2005 and 2003 and Microsoft .Net Framework 4.0, 3.5, 2.0 and

1.1.

Expert in using ASP.NET Server controls, AJAX Controls, User Controls and HTML controls.

Extensive experience of Object Oriented Analysis and Design.

Designed and developed applications using SOAP and .Net Web services.

Extensively used AGILE methodologies in various projects.

Expertise in XML, XSLT, XSD, HTML, CSS, VBScript, JavaScript .

Good experience in developing applications using Windows Communication Foundation (WCF) in .Net

Framework 3.5, 4.0 and MVC.

RDBMS experience includes SQL Server, T SQL, Oracle and PL/SQL, DB2. Involved in accessing database using

ADO.NET.

Experience in developing complex SSIS Packages, SSRS reports, Queries, Stored Procedures, Triggers, Views

and Cursors using SQL Server 2000/2005/2008.

Experience in working as IIS Admin and windows administrator.

Extensively used BladeLogic tool to deploy code in various environments.

Experience working with version management tools like Visual Source Safe (VSS), TFS and IBM Synergy.

Self motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

A well organized, goal oriented, highly motivated effective team member with excellent analytical, troubleshooting,

and problem solving skills.

TECHNICAL SKILLS:

Web Technology: ASP.Net, ADO.Net, MVC, XML Web Services, AJAX, XML, XSL, DHTML, CSS, HTML

Frameworks: Net Framework 4.0/3.5/2.0

Languages: C#, VB.Net, Visual Basic, PL/SQL, T SQL, UML

Scripting Languages: JavaScript, VBScript

Databases: SQL Server 2008/2005/2000, MySQL, IBM DB2, MS Access

Development Tools: Visual Studio.Net 2010/2008/2005/2003

Data Access Technology: ADO.NET, ADO

Web Server: IIS 7.0/6.0/5.0

Directory Services: Active Directory, LDAP

Operating Systems: Windows Server 2003, Windows NT 4.0, Windows XP/2000/98/95, Windows

Vista, Windows 7

Source Control: MS Visual Source Safe, IBM Synergy.

Reporting/Portal Tools: SSRS, SSIS, Crystal Reports 9.0, Netcool, Autosys, Falcon, Quality Center, Service

Manager, Hyperion Essbase, putty, DBArtesian, Blade Logic, Siteminder.

EDUCATIONAL QUALIFICATION:

Master in Computer Science from Pune University, India.

PROFESSIONAL EXPERIENCE:

Morgan Stanley Smith Barney, NYC Aug 2008 Till Date

Project: Enterprise Alerts Systems Dec 2012 Till Date

Client Name: Morgan Stanley Smith Barney, NYC

Technical Lead

Alerts System is a project intended to provide centralized alerting engine to entire firm. Alerts system has capability to

receive the messages and deliver to end user’s desktop in form of mails or proactive notification like image blinkers on

screen.

Alerts System can send/receive alerts in form window POPUP. Based on the priority and severity of the alert decision can

be made to send a window POPUP on users screen to seek immediate attention. POPUP mechanism helps in receiving

immediate check approvals, approvals for completions of multilayer business workflows etc. that helps in saving time and

in turn, it helps in increasing the revenue of firm.

Responsibilities:

Full Software Development Life Cycle (SDLC) in a multi tiered enterprise application environment.

Involved in the Design and Development of the web pages using ASP.NET, C#, Java Script, AJAX, HTML, XML,

CSS and OOPS concepts.

Extensively used WCF Services to integrate and communicate with multiple applications.

Developed using N Tier Architecture, Event handling and OOPS concepts, including Abstract

classes interfaces, Involved in full Software Development Life Cycle (SDLC) namely requirement

gathering, analysis and documenting Technical Specifications, implementation and testing.

Coded business objects (using C#) and data access layer objects (using ADO.NET) for accessing database.

Adding User Controls to the framework that can be used across the application.

Interaction with the Business Users to understand requirements.

Performed data validations using ASP.NET validation controls.

Used Synergy for maintaining different versions of code, HP Quality Center for issue tracking and fixing, Service

Manager for code promotion in various environments.

Responsible for Unit Testing and bug fixing of code produced.

Performing QA and UAT cycles and fixing bugs identified by QA/UAT teams.

Involved in planning for new releases, live support, monitoring the system/portal and maintenance work related to

existing and future applications.

Environment: C#, ASP.NET, ADO.NET, XML, HTML, CSS, AJAX, WCF, java script, VBScript, Visual Studio 2010/2008,

Synergy, .NET Framework4.0, Web Services, IIS7.0, SQL Server, IBM Quality Centre, HP Service Manager.

Project: JVC Environment development support July 2010 Nov 2012

Client Name: Morgan Stanley Smith Barney, NYC

Technical Lead

Environment development support team has wide scope and is built to support all activities that are being conducted while

performing testing of different applications in Morgan Stanley Smith Barney, it includes web application support,

infrastructure knowledge, different application components and their functioning, executing activities in scheduled time.

Responsibilities:

Created tools using .Net and windows script to perform daily activities.

Worked on gathering information and defining the scope.

Involved in code deployment for different applications using Blade Logic tool.

Primary contact for environment related issues including web applications issues for business users.

Troubleshooting application issues.

Worked as IIS Admin, windows administrator for environment.

Interacting with different business users for their issues and working with required teams till issue gets resolved.

Communicating to wider audience regarding environmental activities and downtimes.

Performing primary checks for infrastructure, application and resolving them if issue occurs

Co ordinating for successful batch(mainframe and distributed) execution on daily basis in the environment.

Used Quality Centre (QC) for defect tracking and as a code repository and IT Service manager to track the user

issues.

Developed using N Tier Architecture, Event handling and OOPS concepts, including Abstract

classes interfaces, Involved in full Software Development Life Cycle (SDLC) namely requirement

gathering, analysis and documenting Technical Specifications, implementation and testing.

Interaction with the Business Users to understand requirements.

Involved in planning for new releases, live support, monitoring the system/portal and maintenance work related to

existing and future applications.

Environment: C#, ASP.NET, ADO.NET, XML, HTML, CSS, AJAX, WCF,MVC, JavaScript, Visual Studio 2010, .NET

Framework4.0, IIS6.0, T SQL, SQL Server, BladeLogic.

Project: FINASG Aug 2008 June 2010

Client Name: Morgan Stanley Smith Barney, NYC

Programmer Analyst

Financial Applications Support Group belongs to Global Financial IT team of Morgan Stanley to support financial

applications like cost allocation, budgeting forecasting and Planning, Filegate, ABACUS, Acorn and Datacraft Hospitality

suit. Critical part of these applications is to support month end, quarter end and year end processing activities where

chances of having system breakdowns are more due to bulk data processing.

Responsibilities:

Provide deep analysis support to Critical Technical Issues of the customer.

Help team members on issue resolutions.

Provide technical resolutions to customers and system issues.

Devise automated solutions to routine activities.

Standard checking and code walk through to ensure the quality of the code.

Performing Unit and system testing.

Creating, assigning and maintaining tasks.

As a Subject matter expert provided suggestions to the customer on the system design and UI layout and

integration strategy.

Worked with Infrastructure/Environment development teams for setting up required environment on the servers.

Coordinating with team members for team activities, knowledge sharing and Project related discussions.

Performing Impact Analysis of the requirements for existing applications and review the estimations and do re

estimation, if needed.

Debugging SQL queries, stored procedures using SQL query Analyser tool and optimise the queries for better

performance.

Writing SQL queries, stored procedures in Sql using query analyser tool.

Optimising SQL queries and stored procedures in Sql Server for ensuring better performance and data accuracy

Simulate the issues in dev/test environments for root cause analysis and post mortem reports.

Analyse functional and technical changes of the applications/interfaces.

Environment: JavaScript, Visual Studio 2010, .NET, IIS6.0, T SQL, SQL Server, Netcool, Sockeye, Falcon, Autosys, DB

Artesian, Putty, Hyperion.

National Cable Communications (NCC), NY, USA June 2005 July 2008

Project: Lock Box Mar 2007 July 2008

Client Name: National Cable Communications (NCC), NY, USA

Programmer Analyst

LockBox Application is used to read the data files from the FTP site, depending upon the user, these files are then

download in to the database after applying the business logic. This files contain the information about the Receipt and

Apply. The receipt and apply related to that receipt are batched and depending on Receipt Amt and Apply related to it are

then send to Great Plains using the different objects of Econnect as Great Plains uses the XML formatted String for its

input.

Responsibilities:

Developed various screens using ASP.NET Web pages.

Developed classes in business Layer and in Data Access Layer in VB.NET.

Developed using N Tier Architecture and OOPS concepts.

Developing database schema, stored procedures using SQL server 2005.

Designed and Developed Exception Handling and Logging for the Web Application and Web Services.

Developed Reports using SQL reporting Services and Crystal Reports.

Used JavaScript for client side scripting.

Created Functional documents and Test case Documents.

Performing Code Reviews and Test Case Reviews.

Manage work allocations, Follow up to team members and Team co ordination.

Environment: VB.NET, ASP.NET 2.0, Visual Studio.NET 2003, SQL Server 2005, T SQL, SSRS, SSIS, ADO.NET,

GreatPlains, Econnect, IIS, XML, Stored Procedures, Crystal Reports.

Project: Dynamic Info Sheet Creator (DISC) Jan 2006 Feb 2007

Client Name: National Cable Communications (NCC), NY, USA

Programmer Analyst

The DISC is the application which provides interface to upload the program data and different types of images. Search

functionality is given to search specific data.

Application has ability to display program data in different formats e.g. Program guide(MS word), ecard(MS Power point)

and one sheeter(MS Power point) respective templates are assigned while loading program data. User can modify

templates and reload them. User can download data in any above format.

Responsibilities:

Developed various screens using ASP.NET Web pages.

Developed classes in business Layer and in Data Access Layer in VB.NET.

Created multiple Templates.

Developing database schema using SQL server 2005.

Designed and Developed Exception Handling and Logging for the Web Application and Web Services.

Created Functional documents and Test case Documents.

Performing Code Reviews and Test Case Reviews.

Manage work allocations, Follow up to team members and Team co ordination.

Environment: VB.NET, ASP.NET 2.0, Visual Studio.NET 2003, SQL Server 2005, ADO.NET, IIS, Crystal Reports.

Project: SQC and Packaging June 2005 Dec 2005

Client Name: Victor Gaskets, Pune, India

Programmer

SQC This application is developed for Victor Gaskets Pvt. Ltd situated at Pune India. This application is designed to

manage the statistical Control over the organization. In this application different inspections (Daily, Monthly) are done on

various departments according to the plan made. This application provides receiving Quality Plan, Components Auto CAD

Drawing facility, Supplier PPM Analysis for any duration, Corrective and Preventing Actions, Interlinked to linked process

and Inspection, Rejection and Rework Analysis, Control and Non Confirming products. It helps in increasing the

productivity and performance of the system, which is cost effective factor for the company. It follows ISO 9000 Standards.

Packaging This application is designed to manage the packaging records of gaskets. Mainly it has two types of

packaging Single packaging and Multi packaging. Packaging is done either in poly bags or wooden boxes. Multi

Packaging may contain different levels i.e. Primary Packaging, Secondary Packaging and Final Packaging. Each different

level may contain assembly of gaskets or single gasket.

Responsibilities:

Developed various screens using VB.

Developed business Layer and Data Access Layer in VB.

Created multiple Templates for SQC and packaging.

Developing database schema using SQL server 2000.

Designed and Developed Exception Handling and Logging for the application.

Created Functional documents and Test case Documents.

Performing Code Reviews and Test Case Reviews.

Manage work allocations, Follow up to team members and Team co ordination.

Environment: VB 6.0, SQL Server 2000, Crystal Reports.

Contact this candidate