Sql Server .Net Developer Experience Sales Data

Background Summary:

. Over *+ Years experience in Software Analysis, Design Development,

Implementing, Testing & Supporting Distributed Client/Server and Web

based business solutions.

. Conversant in creating Unified Modeling Language (UML) Diagrams

including Use Case Diagrams, Activity/State Diagrams, Collaboration

Diagrams and Deployment Diagrams using MS Visio.

. Adept in mapping the requirements, custom designing solutions &

trouble shooting for complex software & application problems

. Extensive knowledge and experience in designing, developing, and

testing of Business/Commercial Applications using Visual Studio .NET

2008/2005/2003, Visual C#, VB.NET, ASP.NET 3.5/3.0/2.0/1.1, ADO.NET,

and SQL Server 2008/2005/2000, Oracle.

. Created C# / VB.Net Class Assemblies in ASP.Net for reusability and

worked with .NET Server controls, Web User Controls, Data Grid

control, Form validation controls and created custom controls.

. Good experience of Object Oriented Paradigm Design Patterns including

Model View Controller (MVC) and their implementation using

polymorphism, inheritance and encapsulation.

. Excellent skills in design and development in WINFORMS, WEBFORMS,

Client/Server application development using VB.Net, ASP.Net, C#.

. Strong experience in improving SQL code performance efficiency.

Experience with optimization and troubleshooting techniques to address

performance problems on SQL Server 2000 / 2005.

. Worked on .NET Security Model using Role Based security and Code

access security. Authentication and Authorization through Windows

Authentication, Form Based Authentication, Passport Authentication and

Impersonation.

. Good working experience in making web applications AJAX based to

improve the response time. Good experience in using AJAX.NET

framework, AJAX Extensions and AJAX Toolkit Library.

. Excellent knowledge of Object Oriented Design and Development and

experience in Web Services in .NET using XML and SOAP, WSDL,

experience in developing Web Services for performing specified

functions and as well as consuming from both Web and Windows

applications.

. Experience in working with Windows Communication Foundation (WCF),

Windows Card Space (WCS), Windows Presentation Foundation (WPF) and

Windows Workflow Foundation (WF) and Language Integrated Query (LINQ)

in .Net Framework 3.5/3.0.

. Extensive experience in developing, debugging n-tier applications

using C#, AJAX, XSLT, XML, XHTML, HTML, DHTML, Serialization, .Net

REMOTING, CSS, Reflection, Multithreading and Agile programming

methodologies.

. Proficiency in using various XML Technologies like XSLT, XSL-FO,

XPOINTER, XQUERY and XPATH. Experience on migrating existing classic

ASP systems into .NET systems.

. Worked With ASP.NET 2.0 Web Parts, Navigation Control, and Master

Pages and extensively used CSS, Themes, and Skins in Asp.Net.

. Good working experience in Microsoft Application Blocks, like

Exception Block and Data Access block.

. Hands on experience in ASP 3.0, VB Script, Java Script, and experience

in migrating applications from ASP to ASP.NET

. Experience in database development, for creating complex database

queries, writing Constraints, Indexes, Views, Stored Procedures,

Cursors and Triggers in SQL Server 2008/2005/2000, Oracle.

. Expertise in using database related techniques and their application

using LINQ, ADO. Net, T-SQL.

. Created reports using Crystal Reports/Data Reports tool including

Microsoft SQL Reporting Services 2005

. Good experience in working with teams and interacting with customer

and a team player with good interpersonal, communication and

presentation skills.

Technical Skills

Programming C#.NET, VB.NET, C, C++, SQL, T-SQL, PL/SQL, Oracle

Languages

Web Development HTML, DHTML, JavaScript, AJAX, ASP. Net, XML, CSS,

Technologies XSLT, SOAP, UDDI, WSDL.

Database MS Access 2000, MySQL, ADO. Net, SQL Server 2000,

Technologies 2005 and Oracle 8.0

Middle Ware ADO. Net, .Net Remoting, Web Services, COM, DCOM.

Development Visual Studio. NET 2010/2008/2005,Visual Web

Environments Developer, Dreamweaver 4.x.

Web Servers IIS 6.0

Reporting Tools Crystal Reports 10/9/8, Data Reports, SQL Server 2000

Reporting Services.

Design Tools UML 2.0, Microsoft Visio 2000, IBM Rational Modeler

Operating System Microsoft Windows XP Pro/2000/2000 Server /9x/3.x,

Linux Red Hat

Development SCRUM/ AGILE Methodology,Waterfall, XP, Iterative

Methodologies and Incremental

Professional Experience

Sales Order Processing,

Callaway Golf Interactive Inc, TX

Aug'09 - Till Date

.NET Developer,

SOP is an ASP.Net web intranet application that sales representatives at

Callaway Golf use to place orders received by phone. The application also

assists in tracking orders to assure that timely response to sales are

given, and to view and edit orders placed through other channels. Built on

the MVC framework, its sophisticated interface and high interactivity were

achieved through client side scripting using JavaScript.

Responsibilities:

. Developed the site as a Model View Controller application thus

achieving separation of business logic and UI concern enabling an

efficient test driven application.

. Used Linq to SQL as the ORM solution for mapping the Model to a SQL

Server 2005 database.

. Extensively used ASP. Net for webforms design and C# acting as code

behind.

. Utilized AJAX controls for instant updating of client side HTML fields

. thereby achieving Partial postback operation.

. Worked with the JSON results returned by the controllers and did

client without doing a full postback.

. Utilized XMLHttpRequest Object to exchange data with the server, side

scripting using the JQuery, the JavaScript Library.

. Implemented Windows authentication and Role based authorization for

the site. Enhanced the application from time to time for the varied

user authentication levels and access rights.

. Generated a standalone windows application using Windows Presentation

Foundation (WPF) to view database event updates using WPF Data

Binding. The result set was also enabled to be stored dynamically.

. Created Windows Communication Foundation (WCF) services to retrieve

electronic content from Vendor data.

. Used WCF to create Web Services to logically connect the UI with the

layers.

. Wrote T-SQL Stored Procedures and Triggers for SQL Server 2005

database.

. Used DataGrid and AJAX controls to view the orders placed and edit the

information in addition to sorting and summarizing them.

. Followed Test Driven Development (TDD) and maintained around 90%

coverage through Unit and integration tests. Used Rhino Mocks as the

mocking framework for the tests.

. Extensively used N-Unit Testing Framework to write test cases.

. Responsible for deployment and maintenance of the application in

secure intranet application hosting environment servers.

. Developed reports for the order placed using Crystal Reporting

Services.

Environment: Visual Studio 2008, .NET Framework 3.5, ASP.NET, C#, Web

Forms, Win Forms, CSS, AJAX, JavaScript, JQuery, WPF, WCF Services, SQL

Server 2005, VSS, IIS 6.0, NUNIT,Rhino Mocks, Crystal Reports.

AggieTrack,

New Mexico State University

Jan'08-Aug'09 .Net Web Developer, New Mexico, NM

AggieTRAK provides Student career management and support web application.

Provides the students of New Mexico State University with services like

post your resume, job postings, search jobs, online surveys for Offers and

Acceptances, provides updates and news on career based events in the

campus. It facilitates the vendors and employers to browse the student

resumes according to search criteria, schedule a meeting or an interview

with a student or post any job opening on the updates and news page.

Responsibilities:

. Created master pages and dynamically linked the master page based on

the user role.

. Used Form based Authentication to authenticate application security by

incorporating Role based Security model.

. Used intrinsic objects (Request, Response and Server) to mange page

navigation. Used Sessions, cookies, Query String, View State to

persist and transfer data between pages.

. Developed Mail Components, Upload Components using .Net Framework

classes, SMTP Mail Server.

. ASP. Net validation controls such as RegularExpressionValidator and

CutomValidator was used to validate the information provided by the

user.

. Generated and consumed Web Services for postal address standardization

and Zip code validation.

. Used WCF to facilitate the communication between the components and

services.

. Worked on WCF Services for building and running connected systems

which helped in security, distributed transaction coordination, and

reliable communication between applications.

. Coded multithreaded control libraries in C# for implementing business

process logic and utilized ThreadPool Class and properties to manage

asynchronous data processing.

. Designed Test Cases and Implemented Unit and Integration Test Cases

using NUnit Testing Framework.

. Developed XML, XSD and XSLT for communicating data to and from

database via XML Web Services.

. Extensive use of the Calendar and Data Grid controls for display and

interview date selection. Extended the functionality of the calendar

control to make it possible to display and work with the scheduling of

different interviews scheduled in each month.

. The backend used was a SQL server 2005 database and was involved in

writing queries and stored procedures to extract data from the server.

. Used ADO.NET classes like SqlConnection, SqlAdapters, SqlDataReader

and SqlCommand classes for data access.

. Used SSRS to develop various reports like list of employers

participated in various career fairs conducted by the Career services

department.

. Developed test documentations and performed unit tests and integrated

tests.

. Performed C# code reviews and verifications.

Environment: Visual Studio 2005, .Net Framework 3.0, ASP.NET, ADO. Net,

C#, SQL Server 2005, Web Forms, WCF Services, XML, XSLT, SSRS

2005, NUnit.

Patient Health Record,

Vensoft Inc, AZ

Nov'06- Aug'07

.Net Developer

MMP is the latest Healthcare solution. It is a web based platform that

keeps track patients health record that comes from different sources. The

system main capability is more than helping the provider a fast and

accurate service to the patient, but it also helps the patients to be able

to keep track and maintain their health. The application consisted broadly

of modules Manage Member, Manage Assessment, Manage Enrollment, Manage

Condition, Manage Interventions, Manage Program and EHR (Electronic Health

Record).

Responsibilities:

. Involved in initial system analysis, functional design specification,

and architecture design and UML diagrams such as use case diagrams

during designing phase using Microsoft Visio.

. Created ER (Entity Relationship) Diagram for the database and also

designed database schema, stored procedures, views and functions.

. Designed and developed ASP.NET pages using C# as code behind.

. Implemented layer architecture with emphasis on Programming Business

Logic and Data Access Layers.

. Constructed class libraries containing code for business and data

access layers in the n-tier architecture. The logic was implemented

using C#.Net and ADO. Net.

. Implemented membership provisioning to support SqlMembershipProvider,

which stores membership data in Microsoft SQL server.

. Followed Agile methodology to incorporate changes in the requirements

with project schedule.

. Used Form based Authentication to authenticate users, and ASP. Net

Validation controls were used for input validation.

. Worked on ASP.NET Web server controls and Navigation Components.

. Utilized .NET Remoting techniques for reusing and accessing some

business objects implemented in another application in an n-Tier

Architecture.

. Modified the Web. Config file to provide customized error handling and

error logs.

. Utilized Data Set to access Database using ADO.NET.

. Finalized approval for all Change Control Requests to Production.

. Used System.Diagnostic namespace to debug and trace developed ASP.NET

based pages.

. Used SQL Profiler to performance tune application when the application

was set to run with the SQL Server 2005.

Environment: Visual Studio 2005, ASP.NET, C#, Web Forms, Window Forms,

ADO.NET, SQL Server 2005, SQL Server Reporting Service 2005, MS Visio .

iFly:Airline Passenger Reservation System

IBS,Trivandrum,India

May'04- Aug'06

.NET Developer

iFly is an airline passenger reservation system which includes total

integration of airline reservation, ticketing and departure control

operations. The system, which supports the need of sophisticated full

service operators as well as low-cost operators, helps airlines to break

away from legacy systems, reduce cost, and improves revenues and

profitability.

Responsibilities:

. Designed and developed ASP. Net pages in passenger reservation module

which enables online customers to make reservations, view their

bookings, make special service requests and define their preferences

over the web.

. Form based Authentication and ASP. Net validation controls are used

for authenticating the users.

. Coded the entire VB. Net code behinds and components, for the web

controls, and database calls. Data grids used extensively for records

display.

. Worked on ASP. Net Web server controls and Navigation Components.

. Designed SQL 2000 database schema, stored procedures, user defined

functions, views and triggers. Resolved performance issues, fine-tuned

queries, indexes and stored procedures.

. Coded SQL server stored procedures to transfer data between source and

data warehouse systems.

. Designed and implemented a security model for role based authorization

for each code components.

. Used XML Web Services for exposing some important financial

calculation functions to all other applications.

. Created Reports using Crystal Reports for each module. Developed test

documentation and performed unit tests and integrated tests.

. Used VSS for maintaining source and data branches in version control

and debugging issues.

Environment: - ASP.Net, VB. Net, ADO.Net, HTML, CSS, SQL Server 2000,

Visual Source Safe.

Education

Masters in Computer Science, NM State University

Training

Oracle 8.0 and Data Modeling by IBS Software Solutions.

.Net Frame Work and AJAX framework by Vensoft Inc.

Contact this candidate