Sql Server Project Visual Studio .Net 2008 Experience

Mesha Parveen Saddique

408-***-**** *****.********@*****.***

SUMMARY

. Extensive IT experience in all phases of SDLC including design,

development, testing and maintenance of Web/Windows applications using

Microsoft Technologies.

. Strong in design and development of web and windows based applications

using C#, ASP.Net, ADO.Net, XML, XSLT, IIS.

. Have good knowledge in HTML5 and CSS3

. Have experience in .NET framework (Version 1.1, 2.0, 3.0 and 3.5), Web

Services, WCF, WPF, LINQ and HTML.

. Currently have H1B Visa valid until September 30, 2015.

. Good in C# concept.

. Hands on experience in design using Object Oriented Principles.

. Have experience in Visual Studio 2005 / 2008.

. Developed highly complex and critical business process solutions in

SQL Server 2005/2008 in which involved writing stored procedures, user-

defined functions and designing tables and views.

. Have experience in creating packages using SSIS

. Experience in preparing unit test plan and unit testing.

. Strong experience in preparing deployment set ups for web and windows

applications using .Net framework techniques of installation such as

Microsoft Installer (MSI)

. Have experience in Requirement Analysis, Preparations of Technical

Specifications Document, Design documents, Code Review, Unit testing

and System Testing and Regression Testing.

. Excellent track record as a leader and team player with effective

communication skills and fast learner with an ability to do

multitasking

TECHNICAL SKILLS

Operating Systems Windows 2k, 2003 server, NT/XP and Vista

Application Servers IIS 6.0

Programming Languages C#.Net, VB.Net, ASP .Net, AJAX, VB 6.0, .Net Web

Services, LINQ, WCF, WPF, HTML, HTML5, XSLT,

JAVA/J2EE

Scripting Languages Java Script, JQuery, CSS, CSS3

RDBMS SQL Server 2005 and 2008

Development Tools Visual Studio.Net, Visual Studio 2005 / 2008

Other Tools SSIS, SSRS, Visual Source Safe(VSS)

.Net Frameworks Framework 1.1, 2.0, 3.0 and 3.5

EDUCATIONAL DETAILS

. Bachelor of Engineering (Electronics and Communication) from

Adhiyamaan College of Engineering, Hosur affiliated to Anna

University, Chennai, India.

EXPERIENCE

Esurance Insurance Services,Inc., San Francisco

Nov 2012 - Present

Esurance Insurance Services, Inc is an American auto insurance provider,

which is owned by Allstate,, sells car insurance direct to consumers

online and over the phone offering services to nearly 90 percent of the

U.S. population in 34 states. Esurance has 849,000 policies-in-

force,[1] and also serves as a shopping and comparison site for car

insurance in the 20 remaining states that it does not sell.

PROJECT #1

Title SSRS Report admin.

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages c#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture),SSRS, SSIS

Team Size 1

Role All rounder

Period Nov 2012 - Jan 2013.

Project Description

It is an ASP.NET Website to be used as an admin site for the SSRS

Website. The reports admin was

1. To give roles and responsibilities to other users.

2. Create new report / folder in SSRS website using distinct RDL.

3. Edit the previously created reports.

4. Etc...

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Worked with SSRS Website.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit, regression Testing, Debugging and bug fixing

PROJECT #2

Title Single Sign On

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages c#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture),SSRS, SSIS

Team Size 1

Role All rounder

Period Jun 2013 - Jul 2013.

Project Description

Created single sign On tool for all the back office applications used

in Esurance.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit, regression Testing, Debugging and bug fixing

PROJECT #3

Title Sales Incentive Template tool

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages c#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture),SSRS, SSIS

Team Size 1

Role All rounder

Period Jul 2013 - Nov 2013.

Project Description

Created Sales Incentive template tool for the sales agents incentive

calculation.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit, regression Testing, Debugging and bug fixing

PROJECT #4

Title Maintenance of all the other internal projects

/ websites.

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages c#, VB

Cognizant Technology Solutions, Chennai.

Jan 2010 - Mar 2012

Cognizant Technology Solutions, is an American multinational Corporation,

headquartered in Teaneck, New Jersey. Provider of custom information

technology, consulting company, included in the NASDAQ-100 and the S&P

500 indices.

PROJECT #1

Title ETT Reports.

Client Enterprise Transformation Team.

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages c#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture), SSIS

Team Size 3

Role Team Member

Period May 2010 - August 2010

Project Description

It was a set of reports added to the Cognizant 20 site. The reports

were to show the statistics on timesheet, Associate's work management,

project tracking, project status, load factor and other details related to

top level management. We had to get the details from peoplesoft website and

port it using SSIS package on a daily basis. Work out on the calculations

and display the reports based on the associates allocation and designation.

We used fusion charts to display graphs. It had multilayered ADO

architecture for security reasons.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Created AJAX and Jquery enabled web parts to improve site

performance using Visual Studio 2008.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit and regression Testing.

. Debugging and bug fixing

PROJECT #2

Title Bayers Reports.

Client Bayer's Pharmaceuticals

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages C#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture), SSIS

Team Size 1

Role Single resource All rounder.

Period August 2010 - December 2010

Project Description

It was a set of 20 reports added to the Cognizant 20 site according

to the needs of the Bayer's Pharmaceuticals with medical terms and

calculations. The reports were visible only to the Client and people who

were working on that particular project. We had to develop a macro based

excel template in which the Client enters the data and we had to manipulate

it on backend and show with relevant graph and other exporting options.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Created AJAX and Jquery enabled web parts to improve site

performance using Visual Studio 2008.

. Deployed custom pages, created custom web parts.

. Designed and created Excel macro templates.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit and regression Testing.

. Debugging and bug fixing

PROJECT #3

Title Testing Lean Metrics Module.

Client CTS

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages C#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture), SSIS

Team Size 5

Role Team Member

Period December 2010 - March 2011, October 2011

- December 2011

Project Description

It is a complete module which is used to track all the Testing

Projects in CTS. It also calculates all the metrics necessary and shows

reports and other data shown in C2. It was a challenging module which we

had to finish in a very small deadline.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Created AJAX and Jquery enabled web parts to improve site

performance using Visual Studio 2008.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit and regression Testing.

. Debugging and bug fixing

PROJECT #4

Title AZ Reports.

Client AstraZeneca Pharmaceuticals.

Operating System Windows 2007

Tools MS Visual Studio TFS, MS SQL Server 2008

Programming Languages C#, VB

Scripting Languages JavaScript, HTML, XML, Jquery, AJAX

Technology ASP.NET, ADO.NET (3 layer architecture), SSIS

Team Size 1

Role Single Resource All rounder

Period March 2011 - October 2011

Project Description

Following the success of Bayer's reports, Aztrazeneca also came up

with a similar requirement tailored according to their needs.

Role and Responsibilities

. Involvement in Requirement gathering, Analysis, Design,

Development, Testing and Deployment.

. Created user controls and web pages using ASP.Net and C#.

. Customized Master pages.

. Created AJAX and Jquery enabled web parts to improve site

performance using Visual Studio 2008.

. Deployed custom pages, created custom web parts.

. Configured SQL database and planned and normalized the database

designed.

. Designed tables, views, functions and Stored procedures.

. Created SSIS Packages to port values from different servers.

. Worked on the different Layers of solution architecture.

. Building, Hosting and Deploying the solution in different servers

. Coding.

. Unit and regression Testing.

. Debugging and bug fixing

WORK AUTHORIZATION

. Currently have H1B Visa valid until September 30, 2015.

Contact this candidate