Post Job Free

Resume

Sign in

Sql Server Test Cases

Location:
Irvine, CA
Posted:
August 05, 2016

Contact this candidate

Resume:

Devang Patel

acv1rx@r.postjobfree.com

614-***-****

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