Experienced engineer with MS in Computer & Information Science and MS in

Applied Mathematics with over 6 years experience in software industry and 3

years experience in teaching Computer Science. Recent experiences in

Software Development, Testing and Test automation in SDET role. Experience

includes working with SQL Server, JAVA, C#, VB 6.0, VBA, Data modeling,

tools such as Visual Studio Team Foundation 2008-2010, SSIS, ETL, SSAS and

SSRS. Good working experience in developing test specifications based on

detail understanding of business requirements, functional specifications

and providing appropriate solutions for test. Strong mathematical and

statistical skill. Excellent team player with good mentoring, organization,

communication and time management skills. Possess strong knowledge in

Relational Database system.

Technical skills:

. MS SQL Server 2005, 2008,Visual Studio Team Foundations 2010,

Microsoft Test

Manager 2010,SSIS, SSAS, SSRS, ETL,SAS, CRM, Backend database

Testing, MS

Sharepoint2007.Database unit testing with VSTS2010, Test

Automation,Test

Manager, SQLCode Coverage.

. C#, JAVA, C++ in .NET, C,XML,VB.

. Basic knowledge in WCF.

. Understand the concept of performance tuning of queries.

. Oracle 7.3.2, Developer2000, SQLPlus3.3, Embedded SQL (PL/SQL) in

UNIX

Platform.

. UNIX systems Programming.

. Windows 2003 server.

. Operating Systems : Windows 7,Windows XP, Windows Vista, Windows

2007, UNIX,

LINUX

. MS Office.

Education/Certification:

> MS in Computers &Information Science, Kutztown University, PA.

> M.Sc in Mathematics Indian Institute Of Technology, Kharagpur, India.

> Certification course on Visual Basic From Penn State University.

> Certification course in Data Warehouse/BI Project Planning & Design

from Univ. of Washington

Professional Experience:

Microsoft Cooperation:

Role: SDET(short contract) May -30th June 2010

Project: METaL( Meta Data driven Transform and Load)

> Create test automation code for testing METaL stored procedure using

VSTS 2010 and C#, .NET 4.0

> User interface testing with Microsoft Test Manager.

> SQL code coverage.

Bill & Melinda Gates Foundations:

Role: Senior EDWQA Test Development (Contract) Oct

2008-Dec 2009

Project: Unison

UNISON project integrates Microsoft CRM with legal document management

software. Integration layer is built with C# and WPF which communicates

with Document management software, Share Point portal and CRM

. Requirement Analysis. Function Spec verification.

. Creating test case, Test Scripts, CRM test data creation.

. Executing test cases, reporting defects and regressing defects.

. System Integration testing, data validation.

. SSRS Report testing with backend data.

Enterprise Data Warehouse, integrated data from CRM, Financial, UNISON and

Domain Data source through ETL process.

Responsibility:

. Develop Test Automation using C#, SSAS,VB,TSQL for schema and data

validation.

. Create Test Plan, test case scripts, execute test cases.

. White box testing, notifying and prioritize and analyze defect and

provide solution.

. Data compare and schema compare using VSTF tools.

. Back up and restore data bases.

. Monitoring jobs progress, analyze error message using SQL Agent.

.

Microsoft Corporation Oct 2007 --

Oct 2008

Role: Software Development in Test (contract)

Project: MMBC and MMRP

MMBC, a multi source data warehouse OLAP project, which provides

analytical support to Mid-Market data analysts for the purpose of customer

account segmentation, marketing campaign and revenue forecasting. These

data are processed to generate Customer Value Segmentation based on

revenue, with specified business logic defined by business team.

Responsibilities:

. Creating Code (complex TSQL Queries) to verify the validity of result

data sets.

. Analyze the code to verify implementation of business logic, schema

validation.

. Create and Verify SSIS packages(dtsx), various task ( Execute SQL,

Execute Package task)

. Involved in the entire life cycle of the test project.

. Create Traceability Matrix to map Functional Specification areas and

test case area

. Test case creation, writing SQL code for test case execution,

identify and report Bug.

. Web application testing Front and Back end.

Environment: SQL Server 2005, Visual Studio Team Foundation server, SSIS,

Microsoft Office 2008, Windows Vista.

United Way of King County

2006 - SEP 2007

Role: Programmer Analyst

Project: Speaker Bureau, Campaign Import Interface, Pledge Processing and

Verification.

Extensively involved in development and enhancement of all above

mentioned software, back end with SQL server 2005 and front end with

VB6.0, Access.

Responsibilities:

. Develop code for enhancements of the above mention software tools.

. Worked closely with the Fundraiser to understand the new

requirements, provide solution and documented and tested it.

. Modified the existing data model to support the new enhancements.

. Write Dynamic Query to automate the Reporting using VBA, VB6.0 for the

Donors and Agencies. Created SSRS Reports from Access reports.

. Developed code in SQL Server for some business logic to apply to the

new standalone system.

. Data modeling, data architecting, data extraction with SQLServer2005

for Donors, Agencies

. Implemented an application level security on a financial software

using WIN32 API.

Environment: SQL Server 2005, Visual Basic 6.0, Erwin, Windows XP,

Access, HTML

Group Health Cooperative

Oct 2005 - 2006

Role: Programmer Analyst

Project: Prognosis of Breast Cancer on Anti depressant

Analyze the existing data model, modified the model, developed SAS Macros

to automate the process of extracting sensitive medical and clinical data

from warehouse for cancer research.

Responsibilities:

. Analyzed the existing data warehouse, designed the new model for data

extraction using SAS, SQL 2005 .

. Developed with SQL Server 2005 and SAS using existing statistical

model(PROC SQL, PROC FREQ,ProcTranspose)

. Data validation With TSQL and Base SAS.

Environment: SQL Server 2005, SAS, MS Excel

Other Software Projects:

Kutztown University, PA:

2001 - 2002

Graduate Assistant:

Project 1: Developed a Data Base Management System for a pharmacy using

Oracle, Developer2000 and SQL on Sun system. Database design, create table,

stored procedure, user interface with Developer 2000.

Project 2: Developed a web based, multi - threaded application for a

pharmacy using JAVA for the front end and middle tier, and Oracle as back

end using JDBC for connectivity with database, RMI.

Project 3: Simulated an ATM machine with C++ in SUN SOLARIES platform.

Project4: Design, implementation and documentation of Customer Billing

system using UML and C++ for a services company in NJ.

Project 5: Organizing and analyzing survey data, statistical chart creation

and analysis for the Office of Human Diversity to support student retention

and improve student's experience at KU. Software tools used are SPSS,

MICROSOFT EXCEL and Access.

Teaching Experience:

Lake Washington Technical College:

2005 Fall

Instructor in Computer Science.

Courses taught:

. C++ ; JAVA

. Data structure and algorithm

Lehigh Carbon Community College,PA

2002 - 2005 Spring

Faculty in the Department of Computer Science.

Residency College, Hyderabad India

1991 - 1995

Lecturer of Applied Mathematics for M.C.A (Master of Computer Application)

Courses taught:

. Probability & Statistics

. Linear Algebra and Discrete Mathematics

. Graph Theory And Combinatorics

Contact this candidate