Sql Server Test Cases
Resume:
Devang Patel
**********.*********@*****.***
Summary
•Over 5 years of experience in IT industry with strong knowledge of Quality Assurance and Software testing in banking and finance domains.
•Strong understanding of QA principles, QA processes and software development life cycle (SDLC).
•Very knowledgeable of all the stages of SDLC in various methodologies including Agile.
•Experience in working with on site as well as off-shore team environment.
•Expertise in Creating, and executing Test scripts and Test Cases based on the User, Functional and System Requirements documents, TSD, Use Cases, Product Requirements for functional, security, performance, configuration and usability testing. Also helped QA Lead in developing the Test Plan.
•Experience in performing different kinds of testing - smoke, GUI, functionality, integration, regression, compatibility and user acceptance (UAT) of web and client/server applications.
•Extensive knowledge of SQL queries for verification and validation of backend testing for different databases like SQL server, Oracle.
•Expertise in analyzing and reporting bugs and interacting with team members in fixing the errors.
•Extensively involved in managing defect tracking systems like Quality center.
•Experience in tracking test coverage and providing metrics to management.
•Responsive to effectively include the requirements and resource changes during the release cycle.
•Proven ability to support multiple projects, under tight deadlines, often with competing priorities.
•Good interpersonal skills, communication skills, result oriented, hard working as team player as well as individual contributor.
TECHNICAL SKILLS
Operating Systems
UNIX, Windows 2000/XP/Vista, Linux, Mac OS
Databases
Oracle, SQL Server
Browsers
IE, Mozilla Firefox, Google chrome
Programming Languages
SQL, HTML, XML
Testing Tools
SoapUI, Firebug, Selenium
Defect Tracking Tools
Quality Center
Other Tools
MS Office Suite, PAC2000, Putty, WinSCP, XML Spy, MKS Integrity, Fiddler, Rally, Confluence, Git, BMC control M
EXPERIENCE
Sr QA Analyst May 2015 – July 2016
Experian, Costa Mesa, CA
Responsibilities:
•Worked with Experian Consumer Services (ECS) for supporting migration projects testing.
•Worked with Product and development team through Agile practices, defined and executed testing for the team including UI and API testing as well as mobile testing for iOS and Android devices.
•Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
•Tested ETL user stories for Business Intelligence team. Identify defects and worked with developer for fix.
•Coordinated with database developers and batch ops team in order to verify the batch jobs that run stored procedures.
•Worked with Production support team to test the production issue fixes.
Environment: ASP.NET, SQL SERVER 2014, Rally, Confluence, Fiddler, Control M, Cucumber, Windows 8, IE, Chrome, Firefox.
QA Analyst II Feb 2012 – Apr 2015
Equator Financials, Los Angeles, CA
Equator is SaaS software provider and technology partner and provides comprehensive platform for mortgage institutions to efficiently manage their default process and sell REO properties. It is a Work Station for buyers, agents, vendors, sellers, investors and midsourcers. The projects involve testing of REO (real estate owned) and Short Sale modules for clients.
Responsibilities:
•Define testing strategy along with QA Lead. Define test items, requirements coverage, test steps.
•Document Test Requirements and Test cases using ALM to track the stakeholders requested enhancements and changes.
•Review change request documents and specifications from business and write test cases including positive and negative scenarios.
•Execute test cases for functional testing in lower environment (Alpha) and perform regression testing in higher environments (Beta and Stage).
•Conduct Smoke testing of the application with each new release and discuss the technical issues with developers.
•Perform integration data testing for EQ to client data flow and validate the XML results. Also working on Vendor integration projects to perform inbound and outbound functional testing using SoapUI.
•Work on client reported issues on priority basis, validate issues in lower environments and work with developers and business team to resolve it.
•Run Selenium scripts for pre and post production release workflow testing.
•Perform manual testing for different functionalities/workflow and log defects in MKS.
•Write simple/complex SQL queries to validate and verify data in SQL server database.
•Review requirements and help QA lead to provide efficient testing LOE for the projects.
• Responsible for the day to day monitoring of the progress of project and giving inputs to management for possible corrections and report the status to QA Lead on daily basis.
Environment: HP ALM 11.0, SQL SERVER 2008, Selenium, MKS Integrity, SoapUI, Windows Vista/7, UNIX, IE, Firefox.
QA Engineer Feb 2011 – Jan 2012
Wells Fargo, San Francisco, CA
The project involved Production Testing support, day to day application issues resolving and quality assurance of the Foreign Exchange online system of Wells Fargo Bank. The project is a part of merger of Wachovia to Wells Fargo.
Responsibilities:
•Worked on production support for Foreign Exchange Online system.
•Analyzed the production issues and found the technical solutions to resolve it.
•Designed and executed complex SQL queries to do data validation.
•Performed functional testing of the application and the process flow by checking interfaces to related
applications in the system.
•Managed Test Plan and Test Requirements in Quality Center.
•Reproduced and tested the production issues in SIT and UAT environments before deploying the
change in Production.
•Coordinated with the developers and team members to resolve the issues during test.
•Validated the applications after deployment/code change and major releases.
•Executed the automation scripts for the modules of application under test using QTP.
•Generated test cases for the application under test according to the requirements and reported the
defects using Quality Center.
•Frequently monitored the trades and transactions in Production environment for any errors or failures
and quickly analyzed the root causes and taken appropriate actions to resolve it.
•Coordinated to the business and other groups of following application to understand and resolve
issues reported by customers.
•Mentored colleagues in understanding application process and issue resolving.
Environment: Quality Center 10.0, SQL SERVER, Oracle, Weblogic, DB Visualizer, PAC2000, UNIX, IE, Firefox.
EDUCATION:
•MS in Electrical Engineering
San Jose State University, CA
References: Available Upon Request.
Contact this candidate