Sign in

Test Cases Sql Server

South Brunswick Township, New Jersey, 08852, United States
January 15, 2018

Contact this candidate

Raja Samala

Phone: 425-***-**** Email:

Software Test/Automation Engineer with over 12 years of IT experience in Development, Quality Assurance, Support, Design and Deployment divisions of Software Industry. Worked in Agile/Scrum Environment. Worked in SDLC and STLC. Experienced in various methodologies, Manual and Automation testing in quality assurance. Expertise in writing comprehensive test plans, designing procedures, and executing embedded, system and integration tests. Known for solving problems, which help software developers reduce debugging time.



Development Tools

VSTS, C#.Net, SQL Server, Java, Oracle, PL/SQL Testing

Enterprise Solutions

VS 2015 & 2013, MSCRM, MSMQ, TFS


Windows 10/Win 7 XP/ Vista/XP/2K/98/95, WinNT4.0, MS-DOS, UNIX and Mac OS


C#, ASP.Net, MTM, TFS, Visual SourceSafe, Java, JSP, Servlets, Ajax, Java Script, VBScript, COM, COM+, DCOM, XML, HTML, IIS,

Project Management & Design

MTM, MS Coded UI, MS Product Studio, QTP 11.0, HP ALM (QC 11.0), Selenium, WinRunner, HP Load Runner, Test Director, Nunit, Jira, Confluence, Git, Jenkins & Toad.


SQL Server 2014, 2008, 2005, 2000, Oracle 10

Testing Methodologies

Manual, Automation, Agile, Water Fall.

Professional Experience Details

Sr. QA Analyst/ Automation Engineer, Addison Lee Tandem Tech, NJ Apr 16 – Present

Tandem/Transdev, is the largest private- sector operator of multiple modes of transit in North America, including bus, rail, paratransit, shuttle, and sedan and taxi services. Tandem/Transdev operates public transportation in 20 countries. Tandem/ Transdev is the trusted partner of cities, transit authorities and airports through quality execution and innovations in mobility. Recognizable brands include: Super Shuttle, Golden Touch, zTrip, and Exec-u-car.


Manually Tested the Scrubbing rules with different scenarios in multiple Environments.

Tested rules such as conf_no, ride dates, base rate, tolls, tips, wait time and OT-to-OT.

Developed SQL Scripts for Validating above rules, also logged the Issues found.

Manually tested Builds in QA Environment, approved and released for further environments.

Individually completed QA process using smoke, functional, database and regression testing.

Documented Test cases, results and defects/bugs for tracking and reporting.

Worked closely with Developers, Product Manager and other team members.

Worked with the team members to resolve the issues found in Testing.

Responsible for testing the Assigned Testing Tickets and working with team.

Successfully completed UI Regression Testing on portal during releases.

Followed AGILE (SCRUM) methodologies, took part in sprint planning every two weeks and daily stand up meetings to update/monitor the progress and status.

Developed UI Test Automation using Selenium & C# and able to book reservations.

Created Web Performance Tests with different high priority Tests Scenarios.

Provided the App speed, stability and scalability using the Performance Test.

Developed Load Tests with different combinations of high priority Test Scenarios.

Collected the Load Test counters for 100, 200, 300, 400 Users.

Found bottlenecks in the Application/Product that required attention.

Developed and Updated API Automation with C# as the App is updated with features.

Developed Logic where single, multiple and range of test cases can be executed.

Created Model classes and used some Models developed by the team for API Automation.

Completed the Data layer, from where all the parameters are read and results are written back.

Designed Automation to log the API Responses for every Test Run.

Developed the Logic to validate the actual API Responses with the expected Responses.

Deployed the API Automation on load VM and it is as expected and using for API Regression Test.

API Automation is used in Dev, Test, Stage and Prod just by changing the Test Data Source.

Project Technologies/ Products: Manual Testing, UI Automation, API Automation, Performance Testing, Load Testing, Visual Studio 2015, C#, SQL Server 2014, Fiddler, Selenium, Jira, Git/Bitbuket, Agile Methodology.

Sr. QA Automation Analyst, ECRI Institute, PA May 15 – Dec 15

The organization serves over 5,000 healthcare organizations worldwide, including hospitals, health systems, public and private players, U.S. federal and state government agencies, ministries of health, voluntary sector organizations, associations, and accrediting agencies. With these groups, ECRI Institute shares its experience in patient safety improvement, comparative effectiveness, risk and quality management, evidence-based practice, healthcare processes, devices, procedures, and drug technology.


Created Test Plan, Test Cases and executed them.

Automated PSO UI using Selenium with Visual Studio and C#

Responsible for Automation using Visual Studio 2013, C# for PSO uploads.

Developed code to gather ECRI upload and export file question and answer codes as per business.

Developed customize code for ARHQ upload and export file question and answer codes.

Responsible for Automation of comparing the upload and export file question and answer codes.

Included gathering the GUID and Event IDs from SQL Server DB to locate exact export file in code.

Automated the Upload service within code, to run upload, gathering and compare codes.

Responsible for updating Automation code as per the changing requirement.

Designed test Framework and segregated on different kinds of files for reading and writing.

Used TFS to get the latest version builds and check in the latest automation code.

Reported bugs found in the application and worked through their resolution.

Reviewed Business Test cases, commented and suggested the areas to be improved.

Created a Guide line document for Business team to follow for creating test cases.

Updated Team with status and defects in Daily Scrum status meeting.

Project Technologies/ Products: Automation, Manual Testing, Visual Studio 2013, Selenium, TFS, C#, XML, SQL Server 2014, JavaScript, SharePoint, Agile Methodology, SDLC & STLC.

Sr. Quality Assurance Analyst, J Knipper and Co, NJ Dec 14 – Mar 15

J. Knipper and Company is a fully integrated direct marketing and drug sampling firm dedicated to the pharmaceutical and healthcare industry providing a wide variety of Healthcare Marketing Services including, Crisis Management and Recall Management.


Reviewed the SRS documents for Abbvie File Import and Export and found the missing details.

Drafted Test cases for Abbvie File Import with valid, invalid data, mandatory and optional fields.

Prepared Test data for field level record acceptance and rejection for Abbvie Import.

Created Test cases and data for File level acceptance and rejection for Abbvie import.

Validated files for field level record acceptance and rejection scenarios on import process.

Validated file level acceptance and rejection using import files as per FDA standards.

Performed Database integrity testing by validating data created, updated and deleted in DB.

Ensured that the Staging, Data, Invalid, Invalid reason tables are updated in SQL Server DB.

Executed the Test cases and logged the bugs for the issues found, followed them through resolution.

Successfully tested all the 7 imports and 2 export files process for FDA reporting.

Tested the Business Rules of orders with missing signature, zip, city and illegible.

Successfully tested the Bug fixes for Assure HCP Statistics percentage & Exclusion details.

Tested Federal reports Details (FDA), summary & XML Tabs for Smith & Nephew

Validated the Pharmacomply latest address is of type shipping on Export all and 3 new reports.

Validated the Threshold, incomplete & Do not ship Alert reports.

Communicated about the blocking defects in Daily Scrum status meeting.

Worked with BA’s, PM, Developers and assisted in UAT Testing.

Project Technologies/ Products: Manual Testing, UAT Testing, VSTS 2010, SQL Server 2008,, C#, Quality Center (QC), SharePoint, SDLC & STLC.

Quality Assurance Lead, Verizon Wireless, NJ Aug 13 – Oct 14

PSMS, Cellcrypt and ISIS are mobile applications for One Time, Subscriptions and Donations. Involved in configuration of test environments and in functional and integration testing. Created Automation testing, defects, managed defects, debugged and analyzed.


Analyzed Approach documents from business and verified the functionality.

Worked with BA’s and Project Management on the missing details in Approach and Design documents.

Developed test plans, test cases, and prepared test data and selected the corresponding transactions.

Used Web performance test for Performance testing and Verified/validated test results.

Logged defects and tracked them till their resolution using TFS.

Created Automation Tests for GUI and regression testing using Selenium IWebdriver and C#.

Developed Selenium Custom libraries for Entering values, Click and Select values from dropdown lists.

Designed Selenium Framework libraries for reading Text from dropdown and Textbox controls.

Enhanced custom methods of control libraries and page navigation and designed the Test framework

Developed Data Driven Test – Reading Excel, Parsing the data, Store locally and Read Data.

Effectively managed time in order to successfully meet the set targets and handled multiple priorities.

Effectively communicated and interacted with peers, other teams, managers & directors.

Worked closely with Development teams to ensure the effectiveness and quality of the components.

Extensively used reporting tools / reports testing – TFS, QC, SharePoint, JIRA & Confluence.

Captured realtime, rbttagging and event handler logs from UNIX servers to find issues origin.

Tracked invoices in CMP and SCM tables of Sql Server Databases.

Reported the progress and challenges faced in the Scrum stand up meetings.

Used SQL Server to capture database logs for successful and failed transactions.

Bounced Servers using Jenkins after updating configuration files.

Worked with System analysts, PM, Developers and assisted in UAT Testing.

Project Technologies/ Products: Manual Testing, VSTS 2010, Test Manager, Selenium, NUnit, TFS ALM, C #, XML, SQL Server, JavaScript, SharePoint, Jira, Confluence, Agile/Scrum Methodology, QC- Quality Center .

Sr QA Analyst (UAT & Support), DOE, NY Jan 13 – May 13

The Special Education Student Information System (SESIS) is a web-based application that assists school staff and related service providers in managing the special education process for students entering kindergarten through age 21. The following processes are managed in SESIS: Referral, Evaluation, IEP, Placement and Related services


Analyzed Business Requirement from business and verified with QC requirements from Vendors.

Raised defects in HPQC for the missing requirements, requirement ambiguities and functionality.

Established and maintained traceability between QA test cases and requirements/design documents

Enforced the currently established defect management processes using a (HPQC)

Responsible for configuring the SQL, Web and Web services Servers.

Used SharePoint and MS Project for tracking tasks.

Developed Stored Procedures and optimized the existing SQL Server scripts for testing.

Developed Automation testing using VSTS coded UI, web performance and Load Test.

Reported, and prioritized defects, worked with the Integration team, and coordinated with SME’s

Assisted Developers to locate identify and resolve software defects.

Worked with SME’s, Stake holders, BA’s, Developer team lead and QA Lead.

Performed testing on browsers like IE 8, IE 9, IE 10, Firefox 19.0 and Firefox 20.0.

Responsible for UAT testing in accordance with the User stories.

Project Technologies/ Products: Manual Testing, Automation- VSTS 2010 Coded UI,, C#, VB.Net, VBScript, Quality Center (QC), SQL Server 2008

Automation Analyst, Sanofi, NJ Feb 12 – Oct 12

Project Description

SANOFI is a French Multinational PHARMA company, the world’s fourth-largest by prescription sales.

SANOFI engages in the research and Development, manufacturing and marketing of pharmaceutical products for sale principally in the prescription market, also develops over-the-counter medication. Company covers 7 major therapeutic areas: Cardiovascular, central nervous system, diabetes, internal medicine, oncology, thrombosis and vaccines (world’s largest producer of the latter through its subsidiary Sanofi Pasteur).


Analyzed Business Requirement and Functional Specifications documents.

Developed Test Plans, Test Cases in QC and executed them.

Responsible for Automation and Testing Aegis_MS 5.0 build on 400 Remote Servers.

Introduced the Coded UI method of UI Testing in the team.

Responsible for Automation and Testing SAW 3.0 build on Workstations.

Used QC to Document Test Cases and to log defects.

Launched Automation Testing from QC.

Responsible for Testing Vortex 5.10 using Bare Metal and In Place Provisioning

Automated Aegis_MS 3.0 & SAW3.0 using QTP, VBScript, WMI and QC.

Performed the integration of QTP Scripts into QC ALM.

Extensive Web Testing with Black box testing method.

Extensively used QC for Test Planning, Test case Designing, Test Analysis, Test Execution, Defect Tracking, Test Evaluation and Test Execution Summary.

Project Technologies/ Products : VSTS 2010, C#, Coded UI,, C++, VB.Net, Ajax, SQL Server 2008, JavaScript, Automation Testing, Manual Testing, QTP, Quality Center, VBScript.

Lead Automation Engineer, Fiserv, NJ Nov 10 – Jan 12

Project Description

Fiserv, Inc. (NASDAQ: FISV) is a global provider of financial services technology for solutions, information management and electronic commerce systems for the banks, credit unions, securities processing organizations, insurance companies, brokerage and investment firms. Worked on Advantage Application version 5.6, 6.11 & 6.12. Accomplishments

Reviewed BRD, Functional Specifications documents.

Created Test Plan (TDD), Test Cases in QC and executed them.

Responsible for Testing Access & SSRS Reports and logged defects in QC

Efficiently managed the migration of reporting features from Access to SSRS Reports.

Reported Bugs (Defects) using QC, ensured that they got the correct priority.

Created test framework for GUI and regression testing using Selenium IWebdriver, C# & VSTS.

Managing the Defects and verifying the fixes, and tracked through the resolution.

Facilitated Project Defect Triage Meetings. Provided Management with Defect Management Metrics.

Responsible for testing Bank of New York, SEI and CCM Invoice Formats.

Worked closely with Client Services while testing Invoice Formats.

Tested Canadian Invoice Formats and worked with Dev Team to resolve issues.

Efficiently deployed instances of BNY, CCM Invoice Formats and uploading new XML builds.

Used SQL Server 2008 extensively in BNY Invoice Formats Testing.

Created and managed SQL Queries and Stored Procedures for testing.

Project Technologies/ Products : Automation, C#, Selenium IDE & Selenium Webdriver, QTP, QC-Quality Center,, VB.Net, VBScript, Ajax, SQL Server, VSTS2010, TFS, JavaScript, Agile Env, Manual Testing

QA Analyst Lead, Education Dynamics, NJ Feb 10–Sept 10

Education Dynamics: : As a QA Analyst I was responsible for ensuring the quality of the product using all available tools - white-box testing, manual testing and automation. Here 3 applications are integrated as one application.

Lead the Automation Framework design Module Diagrams, Logic/action Flow Chart.

Designed, developed and implemented test scripts and managed Selenium test automation process.

Developed Win Forms and Forms builder module Using

Enhanced Forms Builder Database module.

Proficient in using TFS for source control, creating and tracking work items.

Responsible for Database SQL queries and Store procedures in MS SQL Server.

Used TFS extensively for version control of the source code.

Efficiently updated the Status in daily Scrum meetings and in Sprint meetings.

Project Technologies: Selenium IDE, Selenium Webdriver, VSTS, TFS, Ajax,, C#.Net, JavaScript, SQL Server, Manual Testing.


Worked as Consultant for NetSoft and provided Manual/Automation Testing consulting support for clients over a five year period. Client summaries listed below.

QA Analyst/SDET, Microsoft Corporation, WA

Developed manual test cases and executed for OSLO and Dublin projects.

Designed and executed test cases for multiple modules of project.

Automated the DB2OLEDB and on demand XMLAB domain project using and VSTS.

Database testing like field size validation, validating constraints, Indexes and stored procedures

Followed up the test runs through SQL profiler and helped in optimizing the scripts.

Responsible for adding and updating SQL Server logons, users, and groups.

Developed SQL Scripts and Stored Procedures for Database testing.

Responsible for debugging and troubleshooting issues with the deleting and reprovisioning.

Automated (Test Matrix Manager) applications emerging features using VSTS.

Used WTT to test WF’s & Jobs and used Asset explorer to manage test environment.

Logged and tracked bugs(Defects) using Product studio.

Project Technologies: Automation, Manual Testing, C#.Net, VB.Net, VBScript, Visual Studio.Net, Ajax, SQL Server 2005, XML, WTT, TFS, Virtualization with Hyper-V, Product Studio.

QA Lead/SDET Lead, Microsoft Corporation, WA

Responsible developing Test Plan and Test Cases to Test WTT Infrastructure for GFS.

Automated administrative tasks on remote computers using WMI and C#.Net.

Used System.IO namespace extensively to create files & directories on remote machines.

Created logic to find the status of ports from local user machine to client machine.

Executed batch files automatically on client machines to verify the status of WTTSvc and RPCSS

Automated the logging process for WTTSvc and RPCSS logs from client machine to controllers.

Created Databases, tables and stored procedures as per the emerging requirements in Automation.

Worked with TFS as the source for version control and project / issue management.

Created and tested virtual machines using Coordinatorclient. Tested builds in Host servers.

Tested IPak, SQL and IIS Images on virtual machines in MIA, BL2, BY2, and SIN environments.

Project Technologies: C#.Net, WTT, VBScript, Visual Studio, TFS, .Net, SQL Server 2005, XML, Product Studio, SDLC & STLC

QA Analyst Lead/SDET Lead, Microsoft Corporation, WA

Created manual test cases and executed for existing and new features of UI and Database.

Responsible for writing Automation for middle tier using C#.Net

Automated and executed cases for Checkpoint Express using using Test Manager in VSTS with TFS.

Integrated automated test cases with ETCM Framework, where one can easily run the test cases.

Automation of Webservices, Auto bug logging with the errors in Product Studio and emails for bugs.

Updated the bug reporting websites, and created new bug reporting websites.

Created and administered the TeamStats Share Point portal site for the group.

Developed and executed SQL Scripts and Stored Procedures for back end testing.

Automated middle tier test cases and executed using C#.Net and NUnit.

Applied builds, configured Websites, Web Services on Virtual Servers and installed hot fixes.

Project Technologies: C#.Net, VB.Net, ASP.Net, Visual Studio.Net, Product Studio, SQL Server 2000, XML.

ETCM Framework, HTML, VB Script, COM, VSS, Windows XP, NUnit, Windows 2003 Server, SDLC & STLC.

Production Support Engineer, Microsoft Corporation, WA

This Project is on MS Dynamics CRM Application, where my responsibility is to deploy the base builds and make the environment ready for new Instances of MS DYNAMICS CRM.

Deployed and configured the vanilla builds for new MS CRM Dynamics Instances.

Worked with build team to troubleshoot the Reporting services issues in CRM.

Upgraded and Applied QFE's to MS DYNAMICS CRM Instances from time to time.

Applied Hot fixes for the MS DYNAMICS CRM Instances. Upgraded MS DYNAMICS CRM CRM Instance with new c360 feature.

Investigated and resolved the issues that were faced by the user support and clients.

Coordinated with Fargo team, dev teams, Mom team and other teams to resolve issues.

Project Technologies/ Products

IIS 5, Active Directory, Visual Source Safe, SQL Server, Siebel, MS Dynamics CRM, Windows 2003 Server, Product Studio

Quality Assurance Analyst/Software Test Engineer, Microsoft Corporation, WA

Reviewed functional specification and resolved issues found in it.

Tested the Applications compatibility on IE and Netscape on Windows and Mac environments.

Wrote SQL scripts to validate the database records.

Got appreciation from seniors for finding bug, where a user can hack the site

And get the product for 0 dollars.

Microsoft Business Connection (

Built and configured web, database, and clustered servers. Conducted smoke tests to validate.

Deployed MS Business Connection build to application and web servers (Test, UAT, and Production). Created new users in Siebel. Followed users’ invitation statuses throughout the workflow

Upgraded aging test lab to mirror production environment. With faster servers, I could record accurate usability metrics.

Project Technologies : VB.Net, C#.Net, ASP.Net, Product Studio, SQL Server 2000, Visual Studio.Net, Siebel, XML, HTML, VB Script,COM, VSS, Windows XP, Mac OS.


Post Graduate Diploma in Computer Sciences, India 1998 - 1999

Masters of Commerce at Osmania University, India 1996 - 1998

Contact this candidate