Post Job Free

Resume

Sign in

Sql Server Quality Assurance

Location:
Washington, DC
Salary:
100000
Posted:
September 27, 2023

Contact this candidate

Resume:

Andrian Peceriga

adzzsz@r.postjobfree.com

703-***-****

LinkedIn Profile

PROFILE SUMMARY:

Over seven years of experience in Software Testing, Quality Assurance, and Development of various business applications in Web-based and Client/Server environments and well versed in all stages of testing aimed at providing complete business solutions.

Experienced in formulating Test Scenarios, Test Approach and set up testing environment.

Extensively experienced in creating Test Plan, Test Case, Test Scenarios, Test Case Review Template, and Traceability Matrix.

Expert in both Manual and Automation testing of the applications and writing Training documents.

Expertise in participating in requirement analysis reviews and working sessions to understand the requirements and system design.

Experienced in developing use cases, user interface specifications, and user requirement specification documents.

Experienced with web service testing using Open Source tools like SOAP UI.

Proficient in overall Defect Management/Problem solving including tracking bugs and reporting using Micro Focus ALM.

Good Knowledge in writing SQL queries for Back-end testing.

Experienced in writing automation test scripts inside QTP/UFT environment using VB script.

Proficient in Descriptive programming and Data Driven Test Scripts in QTP/UFT to perform functional and regression testing.

Experienced in creating Architecture design and Framework for automation suite, which involves Data, library using QTP/UFT.

Self-motivated and ability to master new technologies, meet deadlines and work extra hours when needed.

Ability to work in a team and as an individual and work under pressure and to tight deadlines.

Excellent problem solving, interpersonal, analytical, communication and project management skills.

SKILL SET:

Development Methodologies

Waterfall, Agile, Scrum

Testing Tools Knowledge

Quick Test Pro (QTP), Micro Focus UFT, Micro Focus ALM, JIRA, SOAP UI, Selenium, Eclipse, Postman, SourceTree, Github

Databases

Oracle, MS SQL Server, Rapid SQL

Programming/Scripting Languages

Java, VB Script, SQL, PL-SQL, JavaScript, HTML, C/C++, C#, .Net

Other Technology tools

PowerPoint, MS-Office, MS Excel, MS Visio, MS Outlook

WORK EXPERIENCE:

Freddie Mac, McLean, VA

Software QA Analyst Aug, 2020 - Dec, 2022

Responsibilities:

Analyzed business needs and requirements by asking probing and thoughtful questions to understand customer impacts and needs.

Developed and implemented comprehensive test scenarios, test cases, and data files for UAT, regression, and smoke validations to ensure the quality of software applications.

Identified, tracked, and resolved or escalated project-level risks, issues, and concerns to the UAT Lead to ensure timely resolution.

Interacted with business partners to support defect analysis, reproduction, and documentation to ensure accurate and complete defect reporting.

Recommended effective approaches and solutions to problems and communicated pros and cons to stakeholders to facilitate decision-making.

Shared valuable ideas for process improvement opportunities to optimize testing efforts and enhance software quality.

Demonstrated expertise in writing and executing SQL queries to perform data validation and back-end testing of databases to check the integrity of data.

Documented defects with a high level of detail, accuracy, and informative recreation steps using JIRA tool.

Conducted thorough API testing to ensure proper functionality of various application programming interfaces using tools such as Postman.

Executed the application's automated regression testing suite, and subsequently delivered comprehensive test results to both the management and product teams.

Created and updated testing scenarios using the Selenium framework and the Java programming language.

Proficient in creating and managing test cases and test plans within GitHub and SourceTree.

Experienced in Agile methodologies, DevOps, and Continuous Integration/Continuous Deployment (CI/CD).

Collaborated effectively with developers and product owners to ensure timely delivery of high-quality software applications.

Prepared comprehensive test reports, metrics, and status updates to communicate testing progress and results to management.

Actively participated in team meetings and contributed to a positive team culture by sharing knowledge and experience with team members.

Northern Natural Gas, Omaha, NE

QA Analyst Dec, 2018 - July, 2020

Responsibilities:

Analyzed the Business Requirement Documents, Functional Specification Documents to prepare Test Cases and Effort Estimation.

·Developed, maintained and upgraded Test scripts, Utilities, Datasets and the other Programmatic Test tools required to execute Test Plans.

Attended the Requirement Gathering Sessions and JAD Sessions.

Working in Agile-Scrum Software Development Methodology for aiding business requirements change.

Validating User Stories by creating test expressions to be used by the system configuration team.

Created Manual Test Cases and Test Suites for different modules of the application.

Worked with the development team to create a suite of test data including both input files and expected results.

Executed the Tests manually to verify the application functionality and developed Smoke scripts for weekly builds and scripts for the installation process.

Tracked Bugs and Prepared Quality Reports and Metrics Collection using HP ALM, JIRA

Used HP ALM for bug tracking and reporting, also followed up with the development team to verify defect fixes and update bug status.

Created Bug Reports to present the testing results using HP ALM.

Developed various SQL queries to perform backend database testing.

Created Test Case Scenarios for Manual and Automation Tests and executed Data-Driven, Keyword-Driven based Regression Testing and did GUI verification by using UFT.

Responsible for developing Automated Test Cases within UFT and custom scripting as appropriate to the test case.

Created Automated Test Scripts, developed Function Libraries, Shared Repository, Descriptive Programming and Recovery Scenarios for UFT using VB script.

Involved in Hybrid Automation Frameworks using VBScript in UFT.

Prepared and conducted functionality and regression testing during the various phases of the application using UFT.

Prepared and validated the test results proactively in explaining and working through variances.

Attended the Test Planning sessions to help the team to understand the testing approach and to make testing components articulate.

Performed extensive User Acceptance Testing (UAT).

Documented the UAT test plan and Result for sign-off from Stakeholders.

Provided Training in testing to other employees for the best automation practices.

Tested all the applications under different Operating Systems and under different Web Server environments.

Environment: UFT, HP ALM, C/C++, C#, Oracle, Windows, Mainframe, SQL Server, SOAP UI,

VB Script, Asp.Net, MS Excel, MS Office, MS Project, XML, HTML.

PNC Bank, Wilmington, DE

QA Analyst Sept, 2016 – Dec, 2018

Responsibilities:

Developed Automated Test Scripts using VB Script.

Performed step by step testing of software systems and fully documented results within the test scripts.

Performed both manual & automated testing procedures.

Worked with engineers to drive improvements in code quality via automated and manual testing.

Participated in all phases of test execution and documentation including functional, regression, System, usability, integration and acceptance testing.

Involved in whole life cycle of QA methodology starting from planning, capturing, logging, executing reporting and tracking the defects using HP ALM.

Executed test plan and defect tracking with HP ALM.

Worked with project management tools such as JIRA.

Created SQL Queries and did extensive Data validation in backend.

Enhanced and Maintained test scripts for various functional and regression testing using UFT.

Created Test scripts using VB Script and added objects in Object Repository in UFT.

Created Smoke test script using UFT for any new project or any tested modified.

Automated AUT application using UFT.

Involved extensive multi browser testing with UFT.

Performed Web Service testing using SOAP UI.

Involved in Full STLC, Coordination with the offshore team, Defect Reporting, making Test Strategy/Plan.

Assisted in maintaining quality assurance operation logs, databases, and generating metrics for status reporting as needed.

Controlled and managed daily test activities.

Communicated issues and risks related to work assignments.

Assisted with meeting agendas and meeting notes.

Environment: JMeter, HTML, HP ALM, JIRA, HP UFT, MS Project, MS Visio, Java, J2EE, Java Script, VB Script, XML, SQL Server, MS Office, Windows, SOAP UI, UNIX, C++, C#, .Net.

EDUCATION:

Bachelor of Science



Contact this candidate