SUMMARY

• Over 7 years of experience in Testing. Strong background in Analyzing requirements, Writing and Executing Test Cases.
• Experience with SDLC in an AGILE testing environment
• Worked with Development Manager and Project Architect to understand scope and schedule for individual work items.
• Worked with Architect and development teams to resolve queries regarding business requirements.
• Created various test documents such as Test Plan, Test Cases and Test Execution reports .
• Performed both Functional and non - Functional testing.
• Performed System integration testing, Performance testing and Stress Testing .
• Have good hands on Experience in Defect tracking tools - HP ALM, Jira & VSTS.
• Good hands on experience in Sql scripting.
• Used SOAP UI to test Web Services
• Used Postman to test Rest Services
• Experience writing SQL to retrieve and verify Test data.
• Have executed queries both in Oracle DB and SQL Server .
• Worked in Waterfall and Agile projects
• Created presentations to explain suggestions for future project enhancement.

TECHNICAL SKILLS

Languages: Java, C

Databases: Oracle 10g/11i/12c, MySQL, SQL Server 2016/2012/2008

Operating System: Windows 10/8/7/Vista/XP/2000/98, UNIX, Linux

Tools: & Utilities: SOAPUI, Postman, Agile Manager, JIRA, VSTS, HP ALM

Office Tools: MS Word, Excel, PowerPoint

Methodologies: Waterfall and Agile

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Quality Assurance Engineer

Responsibilities:

• Worked with Architect and Developers to understand scope of project and assign work to different QA team members
• Responsible for Functional testing during product Launch/Upgrade.
• Responsible for performing regression testing of the overall application during after every Release.
• Involved in UAT testing, Prepared UAT test cases and testing estimates.
• Aligned to test design, test execution activities as suggested by the client and provided with few out of box scenarios which were highly complemented.
• Took test summary report initiation for every release, which consists of Test Execution Summary, Defect Summary, Test Results, Challenges and lessons learned, Defect Tracking Log.
• Created Test documents such as Test Plans, Test cases and Test execution report.
• Responsible to prepare the ambiguity document after analysis of FSD, BRD and Net Change document.
• Execute test cases and update VSTS tool with execution status.
• Log defects in VSTS and explain developers about the defect.
• Provide recommendations to improve application.
• Run SQL queries on SQL server and extract test data.
• Create clear and concise test execution and defect report.
• Managed Defects by Logging and Tracking bugs during execution in ALM.
• Provided signoff/partial signoff for application release to Production implementation.
• Conducted presentations with architects and clients to review test results and provide suggestions for applications enhancement.

Tools Used: VSTS, SOAPUI, Postman, ALM, SQL Server, SharePoint, MS Office

Confidential, Libertyville, IL

Database QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Performed Verification, Validation, and Transformations on the Input data Text files, XML files before loading into target database.
• Developed test plan and responsible for creating test strategy for the Data Warehouse.
• Loading the test data in testing environment to ensure the tests are done with no data issues.
• Perform Functional, Data Validation, Integration, Regression and User Acceptance testing.
• Rigorously performed regression testing for every modification/enhancement of the project.
• Tested ETL's to ensure that the source and the target are mapped as per the requirements/specifications.
• Ensure that data quality validation is done before loading the data into data warehouse.
• Initial loading of records on data warehouse and incremental loading of records at a later date to verify newly inserted/updated data.
• Prepared scripts, running tests, Analyzing results in LoadRunner for Performance testing
• Developed and Executed SQL statements in Toad to retrieve data and to validate data
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Worked with business team to test the reports developed in Cognos
• Responsible for documentation of test results, test matrix, LoadRunner and participated in daily/weekly QA meetings.

Tools Used: informatica 9.1/9.5, PL/SQL, SQL Server 2012, Cognos, MS Office Suite, HP Quality Center 11.0, QTP, UNIX, Share point

Confidential, Columbus, OH

Quality Assurance Engineer

Responsibilities:

• Responsible for product testing and ensuring accuracy in the applications.
• Tested software to ensure application is defect free before releasing it to production implementation
• Created test plan and test cases and executed each test cases.
• Conducted formal and informal product design reviews throughout the software development lifecycle to provide input on functional requirements, product designs, schedules and potential issues.
• Leveraged developer background to communicate effectively with software design team, quickly gaining their respect and becoming a valued, “go-to” team member on challenging test cases.
• Accelerated average QA testing turn-around time by 25% or more, allowing company to accept more testing projects without increasing staff.
• Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• Provided daily updates to Team Lead and Project Manager.

Tools Used: VSTS, Oracle DB, SharePoint, MS Office

Confidential, Troy, MI

QA Analyst

Responsibilities:

• Review technical document given by architect.
• Assisted with user-acceptance testing and defect tracking for three new software releases
• Created and executed automated software test plans, cases and scripts to uncover, identify and document software problems and their causes
• Created test cases based on requirement documents.
• Transitioned software development efforts to a test-driven development ( TDD ) process, which brought QA testing in on the front-end of the development cycle for gains in code quality, software functionality and programmer productivity.
• Updated test case and test execution updates in JIRA .
• Provided daily status to team lead.

Tools Used: JIRA, MS Office