Engineer Developer .Net Service Sql Server Development

Professional Summary

. *+ years of experience working as a .NET Developer / Functional

Analyst.

. Microsoft Certified Specialist, Technology Specialist in Web and

Database development.

. Extensive experience in working on large Enterprise projects, online

commerce applications.

. Successfully served in both technical and analytical roles during the

analysis, design, development and implementation stages of Application

Development.

. Worked on all phases of the project life cycle, conducted requirement

analysis, database/ network/ schema design, logical and physical

modeling and implementation.

. Used Agile methodologies, test driven development and automated

builds.

. Actively involved in gathering user Requirements, User/System

Documentation, Functional/Technical Documentation, user training and

testing, developing reports for final deployment.

. Leadership capabilities in providing workable strategies and building

teams for maximum effectiveness.

. On job experience in managing day-to-day activities of the development

team by defining, implementing and maintaining a coherent, progressive

development strategy.

. Exceptional ability to communicate and to interact in a professional

manner with customers and colleagues.

. Production maintenance and troubleshooting experience.

. Very strong hands-on experience in architecting and developing

distributed .NET applications using ASP.NET, C#, HTML, DHTML, and

JavaScript.

. Experience in developing WCF, REST, Web Services and WPF technologies.

. Experience in SharePoint customization and development

. Excellent command on writing nested queries and complex joins against

databases.

. Work experience in integration projects using BizTalk server as the

EAI tool.

Crash Dump Analysis & Advanced Debugging Techniques.

. Good oral and written communication skills

Education

Bachelor of Technology in Computer Science & Engineering

(1999 - 2003)

Program Management Training (Fall 2010) Bellevue Community College,

Washington, USA

Certifications

Microsoft Certified Professional - HTML5 and CSS3

Microsoft Certified Professional - WCF .NET Framework

Microsoft Certified Professional - MCPD Web Developer .NET Framework

Microsoft Certified Professional - SQL server

Microsoft Certified Professional - XML Web Services and Server Components

Microsoft Certified Professional - Developing Implementing Web Applications

Microsoft Certified Professional - SharePoint 2010

Awards

Best Performer Award - Perot Systems

Technologies

Technologies : .NET Framework 4.0/3.5/3.0/2.0/1.1, ASP.NET 4.0/2.0/1.1,

MVC 4.0,C#, WCF, WPF, Web 2.0, LINQ, Remoting and Web

Services, Windows Application, Windows Services, MS

SharePoint, ADO .NET, Community Server, CMS, Wikii

development, Entity Framework

Databases : MS-SQL Server 2008 R2/2005/2000, T -SQL, Query Analyzer

Enterprise Servers : BizTalk Server 2000/2004

Web development : JavaScript, JQuery, XML/XSL, XPath, HTML/DHTML, AJAX,

ASP, Visual Basic

Middleware : IIS 6/7, MTS/COM+ Services, MSMQ, MQ Series

Design Tools : Design Patterns, UML, and Use Case creation

Modeling : Visio 2000/2003/2007

Utility Frameworks : Microsoft Application Blocks, NANT, NUnit, NMock,

Rhino Mock, FxCop, Source Analysis, Code Analysis,

PerfCollector

Version Control : Team foundation Server, Visual Source Safe, Tortoise

SVN, Source Gear-Vault

Development Environment : Visual Studio 2003/2005/2008/2010/2012

Operating System : Windows 2000/XP/Vista/2008/7

Professional Experience

Client: Western Forest Products (Nanaimo, Canada)

Feb 13 - Jun 13

Sr Software Engineer

Timber Lumber Forecasting Tool - This tool is used by the business users

to forecast the timber and lumber quantities required every quarter of the

fiscal year by different mills. The usage quantities of the different types

of the lumber/timber are entered in predefined excel format and uploaded to

the tool by the mill users. This upload updates the inventory details of

the lumber/ timber quantities. The tool generates automatic notifications

to the business users if the lumber/timber quantity varies from the pre-

defined thresholds.

Responsibilities:

. Production support of the tool.

. Development of new web views in the tool.

. Bug Fixing and New feature implementation.

. Technical documentation.

. Unit and Integration testing.

. Production roll outs and change management control.

. Sql Server DB deployments of schemas, packages, jobs.

Technologies : ASP.NET MVC 4.0 Razor Engine, C#.NET 4.5, SQL Server

2008 R2, SSIS, LINQ, XML, Ajax, JQuery, Entity Framework 4.0, SQL Job

Employer: Dell International Services (Bangalore, India)

May 11 - Jan 13

Software Development Advisor

Validation Services / Compliance Service (E-Dell) - Developer - Current and

Future state dell services. Validation Services is used by all Dell

internal tools to validate config item, order group, order form, sku, SE

Item and SNP Item. The rules for each validation type will be authored by

business using the Incite tool which saves the rules into DB. Validation

service executes these rules based on the input it receives from the

client. The rules can vary for different regions based on the input item

type. This is a WCF service catering to both .net and non .net clients.

Compliance Service ensures that the Dell Products sold to US Federal

customers are compliant per the contract signed. Compliance logic ensures

that the sku's/ parts of the order code sold are from the accepted list of

counties.

Configurator (E-Dell) - Developer - current and future state dell.com and

dell services. Dell.com is used worldwide for purchase of dell products.

Configurator is the module which helps users to configure their order codes

with the available options for each module. Configurator interlocks with

different other modules for data that needs to be displayed in the UI like

Discounts and flavor rules that needs to be executed based on the customer

set, region and order code. The asp.net UI is rendered in runtime with Ajax

calls.

Responsibilities:

. Allocate tasks to development team.

. Work with PM and BSA for new requirements.

. Track progress of task and update management on project status.

. Analysis of the requirement and develop technical specification

document.

. Develop & Maintain WCF services, Web services.

. Develop & Maintain website build on ASP.NET.

. Develop & Maintain E-Dell SharePoint Portal

. Develop & Maintain stored procedures, functions, scripts

. Develop & maintain unit test cases.

Technologies : WCF, C#.NET 2.0/3.5/4.0/4.5, Web 2.0, ASP.NET 2.0/4.0,

WCF, Web Services, SQL Server 2008, LINQ, XML, JavaScript, Ajax, JQuery,

Entity Framework.

Client: Microsoft (WA, USA) Sept 09 - April

11

Software Development Engineer /Programmer Analyst

OSDC / VLSC (Oct 10 - April 11):

Online Services Catalog Manager - Developer for Online Services web site

and Catalog Manager Windows's application. The web site is used by OCP

(Online Commerce Platform), which is the external client of Volume

licensing group. The site is used to access online service products that

are part of the customer's product catalog and also to access the keys and

downloads for the online services products. The windows application

(CATMAN) is an internal tool used by the project management team to make

changes in the catalogs based on the request from business. Agile

development methodology is followed for the project with monthly sprints

and daily stand up meetings.

Responsibilities:

. Participated in Analysis and Design.

. Develop& Maintain WCF services.

. Develop& Maintain website build on ASP.NET.

. Develop &Maintain Windows Application.

. Develop & Maintain stored procedures, functions, scripts

. Document drop notes for sprint releases.

. Develop & maintain unit test cases.

Technologies : Web 2.0, ASP.NET 4.0, C#.NET 4.0, WCF, Web Services,

Windows Application, Entity Framework, SQL Server 2008, LINQ, XML,

JavaScript, Ajax, JQuery.

Software + Services (Sept 09 - Oct 10):

Software + Services - Technical programmer analyst in Entitlement service

group for Online Service programs.

Responsibilities:

. Participated in Joint Requirement Analysis, Joint Analysis and

Design.

. Interacting with the business and external teams to get the

requirements and questions clarified for the team.

. Analysis of the existing functionality and rules which are present

in database (SQL) and business layer (C#).

. Provide estimates for analysis task, and co-ordinate with

development and test team to get the development and testing

estimates for the project management team.

. Analyze and log risk if any for the project requirement and work

with business to track and close the risk.

. Documenting the functional requirements based on the business

requirement document.

. Creating and maintaining project plan.

. Reviewing Technical documentation and assisting the engineering team

with the questions and clarification required on the requirements.

. Review of test plans and work closely with test team in test phase.

. Work with the dependent teams and make sure there are no contingencies

for the engineering team to complete the tasks as per the schedule.

Technologies : Web 2.0, Microsoft Project 2010, VSTF, Product Studio,

Office 2010, C#.NET 3.5, SQL Server 2008,WCF, LINQ, Web Services, Windows

Services, Unity Framework, XML, Visual Studio 2008/2010, Microsoft

SharePoint 2010

Client: Satex Inc (CA, USA) Jun

09 - Sep 09

Sr Software Development Engineer

Order Entry:

Developer for building Order Entry tool, which is an internal web site used

by sales agents/ customer service to gather the customer information and to

place Satellite TV orders. The site is integrated with phone system which

makes it easier for agents to call the customers for new orders or follow

up.

The phone system is integrated with 3rd party phone systems like ZCom and

Avaya.

Responsibilities:

. Involved in the Requirement Analysis, Design, Development and Unit

Testing.

. Re-Engineer the Order Entry site for better look and feel,

performance.

. Migration of existing VB.NET user interface to ASP.NET and C#

backend.

. Design and develop new User Interface for Order Entry application

in ASP.NET 2.0.

. Develop business and database components in C#.

. Develop Stored Procedures.

. Production support of Order Entry application.

Technologies : Web 2.0, SOAP Services, ASP.NET 2.0, C#.NET 2.0,

JavaScript, SQL SERVER 2005, Visual Studio 2005, VSS, and SVN.

Employer: MySpace (CA, USA) Nov 08 - Jun

09

.NET Developer

MySpace (CA) - myspace.com:

Developer - MySpace mobile project. MySpace Mobile Web services team is

responsible for building MySpace mobile services which are used by 3rd

party mobile devices for developing MySpace application e.g. RIM, Danger,

Nokia, IPhone, Android. The services are of type SOAP Web Services, WCF and

Restful Services. Services provide all the functionalities that are present

in www.myspace.com so that users can access the same features from the

MySpace App in their smart phone.

Responsibilities:

. Participated in Requirement Analysis, Design, and Development.

. Design, develop and maintain new services for myspace mobile.

. Develop and maintenance of Stored Procedures.

. Create unit tests for mobile services.

. Developing new pages for the community server site which is

provided for partners and also used internally for partner

maintenance.

. Support and maintenance of services in production.

. Creating new pages for myspace wikii site and documenting project

specs.

Technologies : WCF, SOAP Services, ASP.NET, C#.NET 3.5, LINQ, WPF,

JavaScript, Community Server, CMS, wikii development, SQL SERVER 2005/

2008, Visual Studio 2008, VSTF, NUnit, NMock

Client: Starbucks (WA, USA) Sept 08 - Nov

08

.NET Developer

STARBUCKS.COM: (Contracting through TekSystems)

Developer - starbucks.com project. This website is used by Starbucks

employees as well as partners/public users for different services

including the star bucks coffee/products purchase, card recharge, gift

program, access of Wi-Fi in star bucks shop and to access the press

releases.

Responsibilities:

. Design and develop new pages for Starbucks.com

. Maintenance and enhancement of the Starbucks.com website

. Develop Stored Procedures.

. Involved in the Requirement Analysis, Design, Development and Unit

Testing.

. Production support of startbucks.com site.

Technologies : Web 2.0, Classic ASP, ASP.NET, C#.NET 3.5, WCF, LINQ,

JavaScript, VBScript, Commerce Server,SQL Server 2000, SQL SERVER 2005,

Visual Interdev, Visual Studio 2008, VSTF

Client: Microsoft (WA, USA)

Oct 07 - Sept 08

Software Development Engineer

SEWS, LIS:

Software Developer Engineer for (SEWS, LIS - WCF service) projects in

Licensing and Pricing group. This service is used by TSC and similar

clients to get entitlement details for an agreement and to subscribe to the

entitled programs. The service and UI clients are both internal and

external to Microsoft.

Responsibilities:

. Develop Business and Data Access components using C#.

. Develop Data Contracts, Service Contract and Operation Contracts

for the service.

. Develop Schemas and XSLT's.

. Involved in the Requirement Analysis, Design, Development and Unit

Testing.

. Document technical specification for the project requirements.

. Develop Unit Test Case for service methods.

. Develop WPF test client used to test the WCF operation contracts.

Technologies : Web 2.0, C#.NET 3.5, WCF, WPF, LINQ, Entity Framework,

SQL SERVER 2005, Windows Service, XML, XSD, XSLT, Microsoft Enterprise

Validation Application Blocks, Visual Studio 2008, VSTF

Client: Surf Control (MA, USA)

May 07 - Oct 07

Software Engineer

Quote Manger Tool:

Programmer Analyst for implementing UI tool, used by Internal and External

users for ordering products (S/W or H/W) from Surf Control. Quotes are

generated by this tool for the orders.

The generated quotes can be emailed as well as viewed in PDF format.

Windows service is used to connect the Client and Server which communicates

using Remoting and also to BizTalk service. The Quote Manger Web Service

has the Add/Create/Delete/Preview methods related to the quote.

BizTalk Rules engine is used for executing the rules required in order to

generate the quote.

Responsibilities:

. Develop Business and Data Access components using C#.

. The system is implemented as a web application using Microsoft .NET

framework 1.1, ASP.net and C# with SQL Server 2000 as backend.

. Involved in implementation and feature request addition phases of

the project.

. Implemented the Quote Manger Web Service.

. Designed and developed assemblies used in BizTalk Rules Engine.

. Involved in the Development, Testing and Support of the application.

. Production support of quote manager tool.

Technologies : C#.NET, ASP.NET, BizTalk Server 2004, SQL SERVER 2000,

Remoting, Web Service,

Windows Service, XML, NANT, NUnit, Visual Studio 2003 / 2005,

ADO .NET, Web 2.0

Client: M: Metrics (WA, USA)

Mar 07 - May 07

Software Engineer

Survey Tool:

Software Engineer / Programmer Analyst for designing and implementing an

application for Report Generation for M: Metrics. The application helps

user to find the Trends available in mobile market allowing the user to

choose the different criteria available. User has the option to view the

report numerically or graphically.

Responsibilities:

. Design and Implement Survey Tool User Interface using ASP .NET 2.0.

. Responsible for designing and creating the tables.

. Develop business and databases components using C#.

. Develop Stored Procedures, Functions using SQL Server 2005.

. The system is implemented as a web application using Microsoft .NET

framework 2.0, ASP.net 2.0 and C# with SQL Server 2005 as backend.

. Involved in all phases of the project full life cycle, conducted

requirement analysis, database design, logical and physical

modeling and implementation.

. Reviewed all ongoing database schemas and E-R diagramming/modeling

to ensure compliance with normalization rules and principles.

. Implemented the application.

Technologies : C#.NET, ASP.NET 2.0, SQL SERVER 2005, XML, Chart

Director, Aspose Excel, Visual Studio 2005, ADO .NET

Client: CARTUS Danbury (CT, USA) Apr 06 -

Mar07

Software Engineer

OD2 (Enterprise Application Integration Interfaces):

Software Engineer / Programmer Analyst for designing and implementing an

EAI application Framework to interface various internal/external business

functions with ATLAS (core enterprise application). Developed a message

based interface for bridging the organizational data across various

disparate enterprise systems such as Oracle Financials (AP/AR/PA),

Mainframe.

Responsibilities:

. Design and implement a robust common component (publisher-

subscriber pattern) to publish base business function events and

configurable event router agent to notify the subscribers for the

respective events with targeted systems event mapping.

. Responsible for designing the request and response schema messages.

. Develop business and databases components using C#.

. The system is implemented as a web application using Microsoft .NET

framework, ASP.net and C# with SQL Server 2005 as backend.

. Involved in all phases of the project full life cycle, conducted

requirement analysis, database/network/schema design, logical and

physical modeling and implementation.

. Reviewed all ongoing database schemas and E-R diagramming/modeling

to ensure compliance with normalization rules and principles.

. Designed and developed assemblies used in BizTalk. Created Ports

for Sending and Receiving message and developed Custom Pipeline

Component for Send Pipeline.

. Production support of the Cartus site.

Technologies : C#.NET, ASP.NET, BizTalk Server 2004, SQL SERVER 2005,

Remoting, COM+, MSMQ, MQ Series, XML, Microsoft Application Blocks,

NANT, NUnit, FxCop, Visual Studio 2003, ADO .NET

Email Integration - Developed a Web Based Application which is integrated

with Outlook that enables the user to attach an email as Email or Fax to

the Web Application and save the documents to the Document Management

System (DMS). Outlook Plug-In was integrated using VB .Net and Middle Tier

developed in C#.

Responsibilities:

. Designing and developing the application.

. Develop the VB Component which is integrated with Outlook.

. Develop the Web Service to communicate between Client and

Server.

. Develop stored Procedures for Activity Center.

. Develop Stored Procedures, Functions.

. Supported application developers by providing expertise on

tuning and performance of the SQL queries.

Technologies : ASP .Net, C#, C++, COM+, Web Service, SQL Server 2004, T-

SQL, Java Script, XML.

Employer: Perot Systems (Bangalore, India)

Mar 04 - Apr 06

Client: CARTUS (CT, USA)

Software Engineer

. Contingency Removal: Software Engineer / Programmer Analyst for a Web

Based Application by which a company entering into a contract with

Cendant assigns Cendant to manage the various activities involved in

relocating an employee from one place to another. Contingency Removal

is the process in which all the information of sale and subsequent

activities related to entering, tracking, and closing of contingencies

are captured. It also involves bridging the data captured using Sale

Synopsis screens to the legacy Mainframe systems. This is carried out

through Biz talk server.

Responsibilities:

. Responsible for developing the middleware components (HTTP-

remote) in C#, data access components, ASP.NET web pages, stored

procedures and NANT for automated build process.

. Responsible for developing and implementing the assemblies used

in BizTalk orchestrations for event generation.

. Designing and implementing the application

. Reviewed all ongoing database schemas

. Reviewed E-R diagramming/modeling to ensure compliance with

normalization rules and principles.

. Participated in all phases of the project full life cycle.

. Responsible for conducting requirement analysis,

database/network/schema design, logical and physical modeling

and implementation.

Technologies : C#.NET, ASP .NET, JavaScript, Remoting, BizTalk Server

2004, SQL SERVER, COM+, Microsoft Application Blocks, XML, NANT, NUnit,

FxCop, Visual Studio 2003, ADO .NET

. Needs Analysis: Software Engineer / Programmer Analyst for a Web Based

Application by which Cendant Mobility provides variety of services to

the transferee such as relocation, rental assistance, property

management, home finding, and attorney services.

Responsibilities:

. Used .Net Technologies(C#.Net). Data access components, ASP.NET

web pages, stored procedures and NANT for automated build

process.

. Participated in all phases of the project full life cycle,

conducted requirement analysis, database/network/schema design,

logical and physical modeling and implementation.

. Design and Develop the application.

. Creating and maintaining database using SQL Server Enterprise

Manager.

. Responsible for Writing Procedures, Functions, PL/SQL, and T-SQL

Statements as needed.

. Troubleshooting at various levels, providing real time 24/7

physical, phone and email support for SQL Problems and

performance issues.

. Responsible for developing BizTalk orchestrations for event

generation.

Technologies : C#.NET, ASP .NET, JavaScript, Remoting,BizTalk Server

2004, SQL SERVER, XML,COM+, Microsoft Application Blocks NANT,NUnit,

FxCop, Visual Studio 2003, ADO .NET

. Policy: Developer for the Web Based Application which is used by

Cendant Mobility to capture the various Policies for Client and

Customer and the Services provided by the Policies.

Responsibilities:

. Design and developed the web application in ASP.NET.

. Develop the middleware components (HTTP-remote) in C#.

. Develop for data access components, web pages.

. Develop stored procedures, NANT for automated build process.

. Responsible for Configuration Management using VSS Server.

. Conducted requirement analysis, database/network/schema design,

logical and physical modeling and implementation.

. Creating and maintaining Procedures, Functions, PL/SQL, and T-

SQL Statements.

. Troubleshooting at various levels.

. Provided real time 24/7 physical, phone and email support for

SQL Problems and performance issues.

Technologies : C#.NET, ASP .NET, JavaScript, Remoting,SQL Server,

Microsoft Application Blocks, COM+,XML, NANT, NUnit, FxCop, Visual Studio

2003, ADO .NET

LAST DATE UPDATED: 5th June 2013

Contact this candidate