Test Cases Sql Server

Bala k

Mail ID: ac1p9f@r.postjobfree.com Contact No: 425-***-****

Experience Summary:

Worked at MICROSOFT for 7.5 years as SDET on web, Native apps.

* ****** ** ****** ** SDET on Web and API automation.

Have extensive mobile testing experience on iOS, Android, Windows phone and Tablets like Samsung, Nokia, Surface.

Professional Experience:

Overall 10+ Years of IT experience.

8+ years of SDET experience at Microsoft and Amazon in Design, developing test automation framework, UI automation using selenium, End to End testing, Protractor, Powershell, Phantom JS, Manual, Regression, Functional Testing, API Testing in C#, REST API testing, Integration, Java Script testing, AWS, Azure Active Directory, Git, Performance testing in VSTS, UAT, Windows metro Apps testing, SQL Server DB testing, Security Testing. Native application mobile testing on iOS, Android, Windows phone, surface, Samsung, Nokia tablets.

Expertise on tools and frameworks such as VSTS, TFS, Selenium, Coded UI, PS, .NET 3.5, 4.0, CICD, VSTS web load tests, MTM.

Strong experience in performance testing using VSTS 2012, Perfmon and xPerf.

Expertise in writing master test plans, End to End test cases, test scripts including payment, transfer payments processing.

Have Native app testing experience on devices such as iOS, Android, Windows phone, Surface Pro/RT, Qualcomm and Samsung Nike, Nokia ARM.

Extensive experience in Agile methodologies such as Sprint, Scrum, User stories and Kanban.

Educational Qualification:

PG – MCA [ Master of Computer Applications] graduated at JNT University, Hyderabad, A.P

Project Details

Client: WA State, Seattle, WA – Oct 2016 to June, 2017.

Project: CAT (CALCULATE ANNUAL TAX Rates FOR EMPLOYERS)

Technologies: C#, PowerShell, Selenium, WCF testing, TFS, VSTS 2015, MTM, Agile.

Platform: Web, iOS, Android, Samsung, surface tablets.

Role: SDET

Understand Business Rules, Design, FS and identify test scenarios.

Write test plan for CAT web app and APIs.

Automate E2E P0, P1 test case scenarios using selenium for UI and NUnit for DB validation.

WCF Testing and End to End validation.

Regression testing and Performance testing (Load and Stress).

Sanity/Exploratory testing on CAT application including Data validation against SQL DB.

Writing SQL Queries to Save and get different type of Employers to validate End to End.

Bug filing, investigation, bug repro and follow up.

Client: Microsoft, Redmond, WA - Feb 2016 to September,2016.

Project: ESTS (Azure Active Directory Authentication- Evolved STS)

Technologies: C#, Selenium, Azure Active Directory, TFS, VSTS 2015, MTM, Git, SQL Server, Rest API, Agile, PowerShell.

Role: SDET3

Wrote test plans for functional, security, performance testing.

Design, develop test automation framework using selenium to automate test cases.

Writing queries, stored procs for data validations against SQL Server.

Test payment, transfer payment features from one employer to another.

Rest Api testing to check the behavior of the service.

Exploratory, Browser compatibility testing on IE, Chrome, Edge, FF, Safari.

Performance testing for response time, stability, resource usage.

Security testing.

Client: Microsoft, Redmond, WA - March 2015 to Jan 2016.

Project: Azure Active Directory Business to Consumer [B2C].

Platform: Laptop, iOS, Android, Windows phone, Samsung tablet, Surface.

Technologies: C#, Rest API, Azure AD, Selenium, TFS, VSTS 2015, MTM, SQL Server, Power shell.

Role: SDET3

Write test plan for Azure AD B2C web application functional cases, smoke testing on native apps on iOS, Android, Windows phone.

Design, develop automation framework, Automate End to End test cases using selenium for UI.

Rest API testing to check the service behavior.

Writing queries, stored procs for the data validation.

Test plan creation for the B2C features, Azure portal and working with all partner teams i.e, ESTS, SSPR, MFA, Azure portal).

Native app testing on iOS, Android, Windows phone to validate End to End.

Performance tests to check response time, stability, resource usage.

Client: AMAZON, Seattle, WA - September 2014 to March 2015.

Projects: Legal Integration Services for Applications [LISA]

Technologies: C#, SQL, .NET 3.5, AWS, Load tests, TFS, VSTS 2013, MTM, SQL Server.

Role: SDET3

Writing test plan for LISA Quartz job services, Re processor service, Process pending documents and for AWS.

LISA Quartz API services automation using AWS, and writing SQL stored procedures.

Rest API, End2End testing from Source to destination. Contract payment processing End to End testing.

Performance testing to verify stability, response time, resource usage.

Filing bugs in TFS and follow up with DEV team on the fixes.

Investigate bugs using fiddler for the exceptions, failures.

Client: AMAZON, Seattle, WA - July 2014 to Aug 2014.

Projects: SHIFT Web Application

Technologies: C#, SQL Server, Protractor, Load tests, TFS, VSTS 2013, REST API, MTM, CICD, Fiddler, PowerShell.

Role: SDET3

Writing test plans for SHIFT web application, SHIFT Api, Shift Engine service.

Native app testing on iOS, Android.

Shift Api automation in C#.

Shift web UI automation using Protractor to test angular JS.

Service Engine test automation in C# and writing SQL stored procedures to verify the data validation get and save.

Load & Stress testing for the web application, Shift API and service engine to verify the performance, scalability, memory leaks, break point.

Debug, investigate defects using fiddler.

Client: Microsoft, Redmond, WA - Aug 2013 to June 2014.

Project: LMX [Lync Modern Experience, Windows Apps).

Technologies: C#, MITA, JIRA, TFS, VSTS, MTM, SOAP testing, Load tests.

Platform: Laptop, Surface, Nokia, Samsung, Windows phone.

Role: SDET2

Writing test plans for LMX windows metro app functional cases.

UAT testing with Skype, Lync 2013, LMX to verify user experience.

Devices testing such as Surface, NOKIA retail ARM, Samsung NIKE, Desktops, BAYTRAIL device and Qualcomm ARM.

Web services testing.

Security testing to check vulnerable.

Performance testing to check response time, memory leaks, CPU usage, stability and latency.

Connected Standby testing for the scenarios on lock screen. Identify the network tokens and CPU usage when the devices are in Connected Standby.

Client: Microsoft, Redmond, WA -March 2013 to July 2013.

Project: Bloodhound [An EXE used in support.microsoft.com]

Platform: Web, Surface PRO V1 and V2, Surface V1 and V2, Samsung NIKE, NOKIA retail ARM.

Technologies: C#, Windows Azure, .Net 3.5, WCF, TFS, VSTS, MTM, Powershell.

Role: SDET3

Write test plan and Automate test cases in C#.

Manual testing and code coverage.

WCF testing to check the behavior of service.

Build deployments in Windows Azure for the test, INT, Staging and PPE environments.

Performance testing in Azure environment using VSTS 2012 to check memory leaks, response time, stability and break point.

Executing MS security tools to check the vulnerable in exe.

Client: Microsoft, Redmond, WA -March 2012 to Feb 2013.

Project: Lync Client 2013 [Desktop]

Role: SDET

Wrote performance test cases to test the performance of Lync 2013.

Executing P0 & P1 scenarios for memory leak testing of Lync 2013 using Perfmon.

SOAP testing.

Automate Lync 2013 End to End test cases.

Create a document for Long Haul run execution guide lines for Lync client.

Bug logging into PS.

Client: Microsoft, Bellevue, WA -November 2011 to Jan 2012.

Project: Ad Center [Adcenter.com online]

Identifying test cases and automating test cases in C#.

Client side validation using Java script.

Logging bugs into VSTS 2010.

Deployments using Octopus and Autopilot tools.

Performing smoke test on PPE site and live Ad center site.

Client: Microsoft, USA -July 2011 to October 2011.

Project: MSN Autos

Wrote test plan for Autos UI.

Automation testing using C#, VSTS 2010 and XML.

Client side validation using java script for the Autos UI.

Upgrading all production servers and lab servers to Win 2008 R2 and SQL server 2008 R2 for MSN Autos site.

Executing the batch jobs on the production & test servers and debugging the root cause for the failures and inform Dev team.

Client: Microsoft, USA October 2010 – June 2011.

Project: WFM

Test cases writing and automating test cases in C#.

E2E testing and Bug filing in TFS.

Client: Microsoft, USA - May 2010 – September 2010.

Project: PVP [Partner Velocity Platform]

Wrote test plans and automated test cases in C#.

Bug filing in TFS.

Deployments using Octopus and Autopilot tools.

Client: Microsoft, USA - July 2009 – April 2010.

Project: CVP [Customer Velocity Platform]

Identifying test cases and automating test cases in C#.

Manual testing and Loc testing.

Bug filing.

Client: Microsoft, USA -June 2007 – June 2009

Project: GSC Setup

Unit testing and writing functional test cases.

Smoke testing, Regression testing.

Filing bugs in TFS.

Contact this candidate