Business Analyst Quality Assurance

Farzana Hossain

Cell phone I 571-***-**** I Email address: ************@*****.***

PROFESSIONAL SUMMARY

Multifaceted and results-driven QA Lead and Business Analyst with 10+ years of progressive experience in enterprise software testing, backend database validation, and agile business analysis. Proven expertise in implementing structured QA strategies using SQL, REST API testing, and CI/CD pipelines across ServiceNow, web, and data-centric applications. Skilled in leveraging tools such as Jira, HP ALM, ATF, and Postman to drive defect management, test automation, and cross-functional collaboration. Adept at designing data-driven test plans, leading UAT coordination, building dashboards with Power BI/Tableau, and aligning test outcomes with evolving business priorities. Excels in fast-paced Agile environments, supporting large-scale digital transformation initiatives across government and enterprise sectors.

SUMMARY OF QUALIFICATIONS

Experienced & in-depth understanding of Software Quality Assurance - including Software Development Life Cycle (SDLC), methodologies, Test Planning, Test Design, execution of manual & automated test scripts using Quality Center (QC), Quick Test Professional (QTP), and QA best practices.

Expertise in Parameterization, Descriptive Programming, Checkpoints, Output Values, and Data-Driven Scripts.

Manual and automation testing experience in client/server and web-based applications across Windows and UNIX environments.

Hands-on experience querying SQL functions against databases for test data generation and troubleshooting in Oracle and SQL Server.

Proficient in writing test cases using HP Quality Center (QC), reporting bugs, and raising issues to the team lead, QA manager, project manager, and other teams.

Experienced in mobile testing on Android, iPhone, and iPad applications, with strong knowledge of wireless technologies such as CDMA, LTE, GSM, GPRS, 3G, 4G, W-CDMA, and EDGE.

Designed, developed, and authored test plans, Requirements Traceability Matrices (RTM), test cases, and test scripts from use cases, design documents, and other project documentation.

Highly skilled and experienced in the QA testing process and its relationship to producing quality products in various environments and methodologies, including Waterfall, Iterative, Agile, Scrum, and XP.

Participated in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems.

Self-managed and able to adjust competing priorities while allocating time as necessary to complete tasks effectively.

Experience in PL/SQL, DML, and DDL, writing complex SQL and testing scripts for backend testing in Oracle.

Highly motivated, detail-oriented, and capable of working independently as well as part of a team, with excellent technical, analytical, organizational, and communication skills in both oral and written forms.

Prepared, maintained, and reviewed QA test documentation, metrics, and artifacts to ensure compliance with quality assurance standards and requirements.

Created Webpages on SiteCore composing various components and features upon clients’ requests. Validated on various web browsers and mobile devices utilizing emulators to verify the fonts, designs, images, buttons, texts and layout.

Utilized Content editor and Experience editor on SiteCore to create, test, verify and validate in QA environment.

COMPUTER & TECHNICAL SKILLS

QA & Testing Tools: ServiceNow ATF, Zephyr, Jira, Trello, TestRail, Quality Center (HP ALM), Quickest Professional (QTP), Excel, Box, Postman, SiteCore, Azure Devops, Browser Stack

Business Intelligence & Reporting: Power BI, Tableau, ServiceNow Dashboards/Reporting, Excel (Pivot Tables, Charts)

Databases & Programming Languages: Oracle, MS SQL Server, MySQL, SQL, PL/SQL, MS Access, Java, JavaScript, Python, HTML, VBScript, C++, J2EE, Perl, HTTP

ServiceNow & ITSM: Incident Management, Knowledge Management, Reporting, Scheduled Jobs, Transform Maps, Email Notifications, and REST API,

Environment & Methodologies: Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle (BLC), Agile (Scrum), Waterfall

Testing Type(s): UAT, Regression, E2E Testing, API Testing, Automation, Functional, System, Compatibility and Performance Testing

Project & Documentation Tools: Confluence, Jira, SharePoint, Lucid chart, Figma, Microsoft Project, ServiceNow KB

Microsoft Office Suite: Excel, Word, PowerPoint, Outlook, SharePoint, Visio, Project, Teams

Mobile & Device Testing: See Test, Mite, Android OS, Apple iOS, Tablet Testing

Professional Experience

QA Lead – Backend / Database Testing

Department of Education Brooklyn, NY (Remote) January 2020 to Present

Drive end-to-end QA for a high-volume, data-centric Special Education web application by executing modular backend validation, data integrity checks, and system-level regression testing across environments.

Design and execute highly optimized SQL queries using complex joins, subqueries, CTEs, aggregations, CASE statements, EXISTS/NOT EXISTS, and SET operators to validate data pipelines, backend triggers, ETL jobs, and business rule execution against source-of-truth values.

Perform data reconciliation testing across transactional layers, ensuring data consistency between user-facing modules and backend storage, especially for critical workflows involving eligibility, service delivery, and compliance metrics.

Build traceable, data-driven test cases from Business Requirements Documents (BRDs) and system specifications, ensuring end-to-end alignment between test scenarios and acceptance criteria using HP ALM Quality Center, Azure DevOps and Jira/Xray.

Integrate test planning with CI/CD pipelines by providing structured test scripts and SQL assertions for pre-deployment smoke validation and post-deployment verification in UAT and PROD environments.

Own the full defect lifecycle: isolate root cause via query analysis and log tracing, reproduce defects across environments, collaborate with Devs for debug sessions, and validate fixes using rollback queries and parallel validation checks.

Create detailed test strategy documents including test case modularization, risk-based prioritization, data coverage matrices, and traceability matrices mapped to business criticality.

Conduct requirements gap analysis in sprint grooming sessions, identifying edge cases, integration points, and negative test scenarios omitted from the spec.

Perform structured manual backend testing for validation layers, stored procedures, triggers, and audit trails; test referential integrity, update/delete cascades, and audit compliance using direct SQL and log sampling.

Support API-level testing and data layer validations for JSON/XML payloads, focusing on backend response correctness, payload schema, error handling, and downstream DB persistence.

Lead regression suite optimization by mining test history, production defect trends, and code change impact maps to build lean, targeted regression sets that increase coverage while minimizing execution time.

Collaborate across Agile teams in sprint planning, test effort estimation, and retrospective root cause reviews; track QA metrics, blocker resolution, and test status in Jira, contributing to sprint velocity reports.

Maintain QA documentation on SharePoint/Confluence, including test charters, exploratory testing outcomes, release validation summaries, rollback procedures, and production issue post-mortems.

Develop and maintain internal QA dashboards to monitor test run stats, open defect trends, and high-risk components using Excel, Jira filters, and SQL-based reports.

Quality Assurance Analyst / Business Analyst

IBM (International Business Machines) New York, NY (Remote) August 2017 to November 2019

Collaborated with stakeholders and cross-functional teams to gather, analyze, and document business and functional requirements for system applications.

Translated business needs into clear user stories, acceptance criteria, and functional specifications to support development and QA efforts in Agile environments.

Assisted Senior Business Analysts and Project Managers by reviewing test coverage, identifying undocumented requirements and risks, and ensuring accurate impact assessment to improve project planning and documentation.

Conducted requirement gap analysis sessions and maintained traceability across the SDLC using Confluence and Jira.

Designed business process workflows and data flow diagrams using Visio and Lucid chart to illustrate current-state and future-state operations for solution planning.

Created and prioritized product backlogs in collaboration with product owners to align sprint goals with business priorities.

Facilitated User Acceptance Testing (UAT) by defining acceptance criteria, coordinating with end users, and capturing feedback to confirm business needs were met.

Developed and customized dashboards and reports using ServiceNow Reporting and Excel to help stakeholders track KPIs such as SLA compliance, resolution timelines, and ticket volume trends.

Utilized Power BI and Tableau integrated with ServiceNow and third-party applications to deliver enriched, dynamic reporting aligned with evolving business requirements.

Designed and executed comprehensive end-to-end, functional, regression, and backend test cases, validating system functionality and data accuracy using complex SQL queries (Oracle, MySQL).

Partnered with developers to troubleshoot staging and production issues by reproducing bugs, documenting replication steps, recording video/screenshot evidence, and logging detailed ServiceNow incident and defect tickets.

Authored knowledge base articles in ServiceNow to document troubleshooting steps, provide self-service guidance to end users, and reduce voice support volume.

Created and updated incident tickets, linking relevant documentation and KB articles to improve Tier 1 support resolution effectiveness.

Validated ServiceNow scheduled jobs and transformed maps to ensure correct field mappings, data imports, and script behavior across environments.

Conducted bulk data update testing using impersonation features and audit logs to verify data integrity, role-based access, and compliance standards.

Tested ServiceNow platform features including email notifications, REST API integrations, and global system configurations using impersonation and log validation.

Executed automated regression testing using ServiceNow Automated Test Framework (ATF) to ensure platform stability across release cycles.

Performed manual test case creation and execution using Excel and Box; tracked defects and maintained test artifact traceability.

Led QA planning by establishing test objectives, risk assessments, and test strategies; collaborated with cross-functional teams to ensure quality across SDLC.

Quality Assurance Specialist- Geekhive Warwick, NY November 2016 to June 2017

Composed Webpages on SiteCore using various components and features upon clients’ requests. Validated on various web browsers and mobile devices utilizing emulators to verify the fonts, designs, images, buttons, texts and layout.

Utilized Content editor and Experience editor on SiteCore to create, test, verify and validate in QA environment the header, footer, navigation bar and carosuel images.

Reviewed User Stories on Jira with BA, PM, and Dev Team to understand testing needs. Provided story points on the user stories to give an estimation of the level of effort into the work.

Performed Functional and Compatibility Tests for various web browsers utilizing browser stack, physical mobile devices and emulators.

Logged Defects in Jira following Defect(Bug) Lifecycle and relayed observations and issues to the Dev and Team to discuss further on the outcome.

Lead Requirement Gap Calls and Defect Management meetings with the Team, Client and Stakeholders.

Worked in fast paced environments both independently and collaboratively with onshore and offshore members of the team.

QA Tester– Mobile Health Manhattan, NY June 2016 to November 2016

Analyzed and provided story points on user stories on Jira.

Performed various tests - system, end to end, regression, functional and backend testing to verify business requirements and detect defects.

Wrote complex sql queries on MS sql server to retrieve patient information to verify and validate if both front and back end data matches.

Composed positive and negative Test Cases and Scenarios based on business requirements on Azure DevOps

Followed SDLC and STLC to deliver defect free products on a timely manner to clients and stakeholders.

Detected and Logged Defect in Jira. Discussed with the team testing observations.

Provided testing observations and notes on issues found in each testing cycles and provided QA sign off on defect free tickets.

QA Engineer - Fresh Direct Long Island City, NY October 2015 to June 2016

Responsibilities:

•Translated Business requirements and technical design into Requirements in HP Quality Center (QC)

•Performed Functional and System Integration Testing on modifications and enhancements prior to production release on Mobile OS/Devices (iPhone, Blackberry, Android) and Web-based applications

•Used See Test for automated mobile testing and run the scripts for multiple devices with VBScript using QTP and also perform manual mobile testing according to the requirements.

•Used Requirements Verification Traceability Matrix (RVTM) to map Requirements to Test Cases

•Developed Test Cases, Test Procedures, and Scenarios to test the system against defined requirements by established Test Plans for Functional, Regression, System, and UAT Testing

•Constructed complex SQL queries to validate the data in between Source Tables as per the Transformations defined in the Data Specification documents.

•Used HP Quality Center (QC) for writing & executing Test Cases, defect tracking, and test management

•Performed Quality Center (QC) Administrative & Project Administration tasks for various projects

•Mentored and trained team members on the Software Development Lifecycle (SDLC), test practices such as test script writing and execution, defect management, and Agile testing methods

•Prepared and coordinated User Acceptance Testing (UAT) and worked with the business area to define the acceptance criteria

•Developed functional and regression automation code in VBScript from test case requirements using QuickTest Professional (QTP)

•Created Test Cases for Component, Integration, and System testing of project software applications

•Monitored and re-tested defects that have been fixed by the Development team in Quality Center (QC) & Jira

•Effectively collaborated with Developers and Analysts to address project requirements, deliverables, and any potential roadblocks

•Developed complex SQL and PL/SQL statements for Backend Testing of AUT by various Joins, TOP, and Conditional statements

•Prepared and communicated Daily/Weekly Status Reports to the project team, including system changes, issues, and potential impact analysis.

Quality Analyst – Comcast Herndon, VA January 2015 to August 2015

Responsibilities:

•Developed, executed, and maintained Test Plan, Test Case, Test Script, and Test Data for Manual and Automated Testing approaches

•Performed Manual & Backend Testing using SQL queries to validate data in the Oracle database.

•Performed Functional, Regression and Smoke Tests on the new enhancements as added to AUT.

•Designed cost effective, long-term QA automation strategy for regression, feature and performance testing that helps Agile development.

•Maintained and updated existing suite of tests based on understanding of AUT and requirements.

•Worked with project teams and QA management to determine when automated testing is appropriate, and the expense warranted to improve efficiency, coverage, and overall testing effectiveness

•Created test scripts using Quick Test Pro tool by using VBScript to perform Functional & Regression Testing on new builds of the software to perform Data Driven test using test data from excel files.

•Performed Manual Testing by using HP Quality Center (QC) for reserving, executing test cases, defect tracking, and the complete test management.

•The projects followed Agile methodology, where developers, users and testers worked together to create stories, document requirements by interviews and analysis.

•Acquainted in existing automation team as a seasoned/proficient automation development resource, providing leadership, mentoring and technical knowledge.

•Used Quality Center (QC) for requirements management, planning, scheduling, running tests, defect tracking and managing the defects.

•Performed peer review test cases, wrote and analyzed customized HP QC-Excel reports.

Software Tester- Sun Trust Banks Atlanta, GA July 2014 to December 2014

Responsibilities:

Designed, developed, and executed detailed manual and automated test plans for UI, functional, system, and ad-hoc testing across client-server banking applications.

Participated in the full SDLC, contributing to the analysis, design, development, and testing phases to ensure high-quality financial software solutions.

Authored and maintained test strategies, test cases, and acceptance criteria aligned with business and technical requirements for integration and system-level validation.

Performed comprehensive regression and backend testing to ensure stability across releases and accurate data flow between front-end and Oracle-based backend systems.

Wrote complex SQL queries to verify backend data integrity, validate business logic, and support test case execution using Oracle database.

Utilized Quality Center (QC) for defect tracking, reporting, and lifecycle management; worked closely with developers to reproduce, prioritize, and retest issues.

Maintained traceability matrices to ensure complete test coverage and alignment with project deliverables.

Collaborated with cross-functional teams to conduct UAT preparation and coordination, helping ensure stakeholder expectations were met before go-live.

Education: Bachelor of Science in Medicine I Dhaka Medical College and Hospital I 2014

Contact this candidate