.Net Sql Server Business Project Data Experience

SAPNA PATEL

Ph. # 312-***-****

email:*****.***@*****.***

SUMMARY:

. Around 5 years of varied experience in developing N-tier applications

(both in Client/Server & WEB Applications development) using C#,

VB.NET, ASP.NET, ADO.NET, XML, VB, ASP, M.S SQL Server, Oracle and MS

Access.

. Experience developing applications in Microsoft .NET Framework 2.0,

3.0 using Visual Studio 2005 and 2008.

. Experienced in using .Net technologies Web Services, Http Handlers,

modules and XML/XSL/XSLT.

. Extensive experience in client side programming using VBScript,

JavaScript, and also in HTML/DHTML, CSS, AJAX.

. Developed Components/User Controls using C# with databases such as SQL

Server 2008/2005, Oracle and Access.

. Thorough understanding and experience tuning and designing database

tables, stored procedures, functions in SQL Server and Oracle.

. Work on Service Oriented Architecture (SOA) and Web Services.

. Strong working knowledge of query optimization techniques and writing

stored procedures.

. Implemented reports using SQL Server Reporting Services (SSRS) to

provide critical reports for senior management as well as reporting

for partners.

. Responds quickly and effectively to production & development issues

and taking responsibility for seeing those issues through resolution.

. Experienced in handling changing priorities, time constraints, along

with the ability to partner effectively, work independently and with a

team.

. Strong project coordination skills, relationship management and

negotiation skills. Strong verbal, written communication skills and

analytical skills.

TECHNICAL SKILLS SUMMARY:

Operating Systems DOS, Windows NT/XP/2000/2003, Linux 9.1

Languages C#, VB.NET, ASP, Visual Basic 6, XML, Java, JSP, Servlets, EJB

Databases SQL Server 2000/2005 ORACLE 7.x/8i/9i and MS Access

GUI ASP.NET, CSS

Technologies Web Services

Scripting Languages VBScript, Java Script, HTML, XML/XSL

Reporting Tools SQL Reporting Services, Crystal Reports, Data Reports

Employment history

Swirnow Building Systems & its independent dealers & affiliates. Baltimore,

MD (April 2010 to till date)

Major assignment at Swirnow building systems includes transformation of

Master Matrix application from Visual Basic to ASP.net and C#. In addition

to this, working for new change request to existing applications and

production support for multiple applications.

Project : Master Matrix and Finance department Reporting

Role : Programmer Analyst

Master matrix system used to keep information about Clients Company,

Contacts, Projects, Estimate, Jobs, Marketing, Time Entry and much more.

Environment: C# 3.0, ASP.Net, AJAX, RAD Controls for ASP.NET AJAX,

Visual Studio.Net 2008, ADO.NET, UML 1.2, T-SQL, SQL Server 2008, MS

Access 2007

Roles and responsibilities

. Discuss requirement with Business before development phase to

mitigate risk

. Developed reusable and optimized .NET components using C#.

. Implemented Data Access Layer using ADO.NET to communicate With the

SQL Server Database.

. Extensive use of the Data grids, Data Readers and Datasets for data

manipulation.

. Developed complex Stored Procedures and creating Tables, Views in T-

SQL.

. Worked closely with Business on Financial data reports and other

small utilities

. Worked extensively with AJAX and JavaScript to achieve rich user

experience.

. Extensively work on SQL Server Reporting Services (SSRS), SQL

Server Integration services (SSIS), SQL Server management studio

(SSMS).

. Developed business reports for all department using SQL Reporting

Services.

. Worked extensively on Ajax toolkit controls like validator extender

and masked edit extenders for providing rich user experience in

client side validation.

. Developed Navigation Component, for easy navigation in text boxes

using Enter and Arrow keys within the Form, For Clearing Text Box

Control that are placed on Panel, Group Box and Tab Control, For

Assigning Headers to the Data Grid.

. Extensively worked with Forms Authentication and successfully

implemented login mechanism for different levels and roles of

users.

. Implemented Custom Validation in asp.net to enable client side and

also server side validations whenever required.

. Designed two diff user interface prototype model for business.

. Worked on MS-Access to create some of the financial reports for

business

. Involved in taking Backups, Restoring, Import/Export data using SQL

Server

. Performed Unit and Integration testing.

. Developed test environment for tester.

. Used Web.config files for .Net security.

. Utilized ASP.NET input validation controls and JavaScript's to

perform client side validation.

Bitsofcode Inc. Houston, TX (Dec 2006 to Febuary 2010)

Major Assignment at Bitsofcode Inc. Houston, TX

Project : Drilling Forecast, Wise, Vault Monitoring, FPY,

Project Risk Tracker

Duration : September 2008 to Till Date

Role : Programmer Analyst

Client : Cameron

Environment: C# 3.0, ASP.Net, AJAX, RAD Controls for ASP.NET AJAX, Web

Services, Visual Studio.Net 2008, ADO.NET, UML 1.2, T-SQL, SQL Server

2008.

Roles and Responsibilities:

. Developed Web Forms, Classes and Business Logic.

. Worked on Data Access Layer using ADO.NET to communicate With the

SQL Server Database.

. Developed reusable and optimized .NET components using C#.

. Involved in writing Stored Procedures and creating Tables, Views in

T-SQL.

. Worked on Service Oriented Architecture (SOA services) and Web

Services to get data from DB2 database.

. Developed complex business reports using SQL Server Reporting

Services (SSRS)

. Used View State for the dynamic controls to speed up the

application.

. Worked on creating schedulers which will automatically update

another SQL server database.

. Extensively used Session state for reading values.

. Developed login mechanism for different levels and roles of users.

. Implemented Custom Validation in asp.net to enable client side and

also server side validations whenever required.

. Worked with modal popup extender of Ajax control toolkit to provide

validation for the site in the form of a popup window using

validation summary control of asp.net.

. Worked on creating schedulers which will automatically update data

in the Oracle data base.

. Performed Unit and Integration testing.

. Improved the application performance using stored procedures and

connection pooling.

. Involved in doing builds in both Development & Testing Server

. Used Web.config files for configuration of application

. Worked on ASP.NET input validation controls and JavaScript's to

perform client side validation.

Project : SureFix

Role : Programmer Analyst

Duration : October 2007 to September2008

Client : Comfort System USA

Environment: ASP.Net, C#, ADO.Net, HTML/DHTML, XML, JavaScript, SQL Server

2005, IIS, MS Excel, Windows XP

Project Description:

The scope of the system is to develop a Web Application using Microsoft

.net Technology to generate reports (HTML Reports and Excel Reports) from

the database maintained through SureFIX. SureFIX is a call tracking/

dispatching and documentation software. Every call in, call out, and

action taken is noted and time stamped in real time. SureFIX is also web

accessible to give vendors and customers real-time information on working

service calls. It is in turn connected to various servers like fax, printer

and coins server (which takes care of finance part).The application

business logic is implemented using C# components accessed from ASP.NET

pages. Data from a SQL Server 2005 database is accessed using ADO.NET and

XML. Different reports were developed based on various search criteria's

and generated as HTML tables from the code behind.

Roles and Responsibilities:

. Designed and developed the SureFix system using C#, SQL Server 2005

and ASP.NET.

. Utilized ADO.NET technology extensively for data retrieving, querying,

storage and manipulation.

. Created Crystal Report manually to generate Reports.

. Extensive use of the Data grids, Data Readers and Datasets for data

manipulation.

. Extensively used View State for the dynamic controls to speed up the

application.

. Developed T-SQL JOINS statements, Database Triggers, Stored Procedures

for data retrieval.

. Generated reports for the Business Executive based on various

conditions.

. Participated in documentation, reviewed, analyzed and fixed existing

code.

. Utilized project lifecycle management tools and techniques to track

the progress of multiple projects.

. Trained users how to use the application and wrote help files.

Customer: ZCubes, Inc. (www.zcubes.com and www.spiderbrowser.com)

Role: Developer

Project Duration: Dec 2006 - Oct 2007

Description of the Project:

ZCubes is an omni-functional platform and presents you immersive browsing

experience. You can browse while creating a document or creating a clipart.

You do not need to depend on different applications. Document editing is

easy and different in ZCubes with its cool Drag-and-Drop features.

Roles and Responsibilities:

. Developed web pages using ASP.net, HTML and Java Script.

. Developed re useable complex Java Script functions

. Worked on the search capability of the module which required

complex search criteria using stored procedures to retrieve data to

different pages.

. Involved in creating some of the advanced client side features for

the Browser such as browse Multiple websites within the same

window, Drag-Drop pictures and videos, Copy and Paste HTML content

from anywhere on the web

. Developed a Paint with unique content like sketches, tracings,

freehand- drawings and professional quality artwork

. Integrate different media content including pictures, video, audio

and RSS Feeds

. Integrate different file formats including PDF, Shockwave,

PowerPoint and Word

. Content using different font options, colors, special effects,

animation and multiple-layers

Environment: ASP.Net, C#, ADO.Net, HTML/DHTML, XML, JavaScript, SQL Server

2005, IIS

EDUCATIONAL QUALIFICATIONS:

. Bachelor of Computer Science & Engineering, INDIA

Contact this candidate