Engineer Sql Server Management .Net Project Manager

Kalyani Kamma

Email: ablcka@r.postjobfree.com

Mobile: 213-***-****

Home: 425-***-****

Summary:

. Having 4+ years of experience in testing, development, design,

implementation and Test Automation of software applications that

include Console based, Windows based and Web based applications.

. Extensive experience in using and implementing different automated

test suites like Webtests, Unit tests, Database tests, Load tests in

VSTS 2005 and VSTS 2008.

. Experience in developing test plans, test cases and generating various

reports

. Experience in performing web testing, performance testing, load

testing, stress testing, regression testing, accessibility testing,

globalization and localization testing.

. Excellent programming skills in C#,VB.NET, C and T-SQL.

. Have strong knowledge and experience in developing and testing of .NET

applications using C#, ADO.NET, VB.NET and SQL Server.

. Strong knowledge of data structures, algorithms, object oriented(OOP)

and databases.

. A good team player with strong ability to lead and adapt

. New skills, and makes efforts to do the work at hand effectively.

Technical Skills:

Operating Systems/Platforms : Windows Vista, XP, 2000, 98, MS-

DOS,UNIX, Linux.

Languages : C#, VB.NET, Java,C++, C, and T-SQL

Scripting : MS-Dos Batch scripting, Perl scripting

Microsoft Technologies : ADO.NET,WCF.

Database : MS SQL Server 2008, 2005, 2000, Oracle.

Web Technologies: : ASP.NET, Webservices,

HTML, XML

Tools and Apps : Visual Source Safe (VSS), VSTS 2005 and

VSTS 2008, TFS

Professional Experience:

#1 AlStom, Redmond, WA Feb 2010 - Current

e-terrascada is a revolutionary step forward in the construction and

maintenance of models. It provides a powerful set of features that make

modeling tasks easy to coordinate and implement. Project contains an

ordered list of model changes and represents either the addition of a

record, the deletion of a record, or the update of a single record

property.

The main purpose is to provide models to other applications. There are

several mechanisms provided for the purpose of importing and exporting

model data. Models are exchanged between applications using an extensible

transformation subsystem. The Administration Explorer provides

administrative capabilities with regards to users, roles/privileges,

application parameters, model, import/export configuration.

Role: Software Development Engineer in Test (SDET)

Responsibilities:

. Prepared test plan and test cases.

. Participated in requirements, design doc, test plan and test case

reviews.

. Performed Functinal, Performance and E2E testing.

. Performed GUI testing.

. Automated the import, export process using C#.

. Participated in BVT runs.

. Involved in code reviews

. Reported bugs. Verified fixed bugs.

. Involved in regression, load and stress testing.

Technologies: C#.Net, MS T-SQL, XML, VSTS 2008, Sql Server 2005 and 2008,

Win forms,TFS, MS-Dos batch scripting

#2 SPOTRUNNER, Los Angeles, CA Mar 2009 - Jan

2010

Spot Runner is the first Internet-based ad agency that makes it easy and

affordable for local businesses to advertise on TV. With Spot Runner's

revolutionary approach, local businesses now have access to television, the

most powerful marketing tool available-one that, due to its traditional

cost and complexity, was previously out of reach.

Spot Runner offers a complete solution for television advertising-

commercial production, media planning and media buying-in a single turn-

key, self-service system. The entire process, which traditionally takes

months and hundreds of thousands of dollars, now takes just days at a

fraction of the cost.

Spot Runner was built to bring affordable advertising to the local

business. Our goal is to do everything we can do to make the process

easier, better, and more effective.

Role: Software Development Engineer in Test (SDET)

Responsibilities

. Review, verify and validate requirements, designs and functionality of

the system.

. Develop, execute and maintain test plans, test cases and test results.

. Writing Unit/Integration tests for the GUI, API on the front end.

. Performed web site testing both manually and automatically.

. Perform performance, load and stress tests. Automated all theses

tests.

. Work closely with the development team to review the system design.

. Validated the integration of this module with other modules using

black box and white box techniques.

. Looked after the builds and ensured test execution in different

labs(Integration lab, BETA, QA) in the process pipeline.

. Debugging the source code for trouble spots, isolating problems, and

executing creative tests to find new bugs while regression testing

recent fixes.

. Performed Functional, Performance, Load and Stress testing.

Technologies: C#.Net, MS T-SQL, VSTS 2005, VSTS 2008, Sql Server 2005 and

2008,TFS, Web Services, XML.

#3 CSG Consultants, San Mateo, CA. Nov 2007 -

Feb 2009

Building Department Application

The CSG Building Department Application (BDA) is a centralized database

application to manage permits and schedule operations for several municipal

departments include Building and Life Safety, Engineering and Code

Enforcement.

The process starts when a client comes with an idea of developing his/her

land to the City/CSG. The City will assign a project number to the client

and attach the APN (Assessor Parcel Number) to this. Then they will appoint

a project manager (PM) for this project. The PM consults the Building,

Planning, Engineering and the Fire departments and comes out with an

initial plan for the development of land.

The Plan/Design is reviewed and after taking the concern of all the

departments it is finalized by drafting the conditions of approval. This

whole process takes around 4-5 months. Once the plan is finalized the next

process is to take the permit for starting the construction process. Till

this stage project number tracks the project.

All the required documents with a checklist are submitted for getting the

permit number and once we get the permit number then permit number tracks

the project. Once the permit is received the construction activity can

start. In the different stages of the construction, Inspection has to be

done. The inspector goes to the site, checks the progress and other details

like material being used, etc.

At different stages the fee will be calculated and the client needs to pay

the fee before the respective process starts.

Role: Software Development Engineer in Test (SDET)

Responsibilities:

. Prepare the test plan based on the functional specs.

. Prepare the test cases,Execute the test cases followed by agile

methodologys.

. Participated in code reviews.

. Contributed to the design document of BDA Application modules

. Writing Unit/Integration tests for the GUI, API on the front end

. Implemented UNIT testing of all the Counter Technician module.

. Automated the integration tests using VSTS.

. Involved in perf, stress and load testing of the system..

. Implemented database T-SQL queries

. Validated the integration of this module with other modules using

black box and white box techniques.

. Performed end-to-end testing of the components.

. Verify and close the resolved bugs. Follow up on active bugs.

. Involved in regression test passes.

Technologies: Microsoft Visual C#.NET, Microsoft SQL Server 2005, Win

forms, ADO.NET, VSTS, Microsoft office

#4 Sparsh Communications Pvt Ltd Dec 2006 -

Oct 2007

Pain Management Center:

Clinical Management System is designed to optimize the functionality of a

Health Care Facility, with ease of use, better performance and high

scalability. This project includes various modules as listed below Patient

Registration, Appointment Scheduling, Practice Management, Surgery

Management, Billing Management, Electronic Medical Records, Clinical

Documentation, Relation Management also includes Administration module for

administering the product.

Configuring the initial settings like the name of the

Health Care Facility, color coding for the Health Care Facility, creating

roles / users for that particular Health Care Facility, creating pre-

defined alerts for the users, creating default color codification (for back

color of the screen and certain data elements), viewing registered Patients

information through search option providing with diff Information like

patient SSN,MRN, Fname, Lname,Sex, Spouse Name, DateOfBirth, Insurance

Id,RegistrationDate etc .

Role: Software Development Engineer in Test (SDET)

Responsibilities:

. Documented the test cases and testing results.

. Executed the test cases.

. Performed black box and white box testing of different modules.

. Identified and implemented UNIT test cases

. Identfied the end to end test scenarios.

. Prepared the integration test plan.

. Automated the integration tests using VSTS.

. Involved in User Interface design and development of front-end pages

using C#.

. Involved in technical design reviews.

. Written Sql Querries using MS SQL Server 2005 T-SQL.

. Implemented stored procedures

. Participated in code reviews.

. Developed the database components using ADO.NET to access the

database.

. Involved in system integration and performance testing.

Technologies: Microsoft Visual C#, ADO.NET, .Net Framework 2.0, Microsoft

SQL Server 2005

#5 Sparsh Communications Pvt Ltd Mar 2006 -

Nov 2006

Credit Union CRM:

Credit Union CRM is an Internet web based application that allows customers

to create/maintain account management with the credit union. The customers

are allowed to manage accounts by associated contacts. CRM enables

organizations to efficiently organize, populate, and maintain information

on all aspects of their customer relationships.

This Application features are:

> Account creation and management, with any number of Contacts

associated with each Account

> Activity history (Meetings, Calls, Tasks, Notes with optional file

attachments, and Emails) is tracked for Contacts, Accounts, Leads,Bug

Tracking, Opportunities and Cases

> Tasks may be assigned to users, and automatic email notifications may

optionally be sent to advise users of new tasks.

Role: Software Development Engineer in Test (SDET)

Responsibilities:

. Documented the test cases.

. Performed GUI testing.

. Performed black box testing of the project from end-2-end.

. Executed the test cases and documented the test results.

. Involved in code reviews.

. Participated in design reviews.

. Identified and gathered the testing requirements of application and

prepared Integration testing plan and User acceptance testing plan.

. Implemented validation logic for data validations on front-end web

pages.

. Performed Back end (Database) testing. As a part of Database testing,

we checked for proper database entries.

. Written many T-Sql queries using MS SQL Server 2005.

. Automated many use cases of the application using the test harness

Technologies: Microsoft Visual C#, ASP.NET, ADO.NET, Web services, XML,

SOAP, Microsoft SQL Server 2005, Microsoft visio.

Education :

. Master of Computer Applications (MCA)

. Bachelor of Computer Applications (BCA)

Contact this candidate