Shrestha
Summary
Professional Product Quality Analyst II with 8+ years of experience in Software Quality Assurance and Manual Testing within high-stakes financial and SaaS environments. Expert in Requirement Analysis and Test Case Design, ensuring functional integrity through complex SQL validation and systematic Defect Tracking. Proven track record of collaborating in Agile Methodology settings to optimize software release quality and resolve critical production incidents.
Work Experience
Production Support/QA/ETL April 2021 – March 2025
PNC BANK, CLEVELAND OH
Analyzed production incidents for EDW and SFA applications, utilizing Dynatrace and Big Panda to monitor system performance and ensure high-tier reliability.
Executed complex SQL queries to validate Data Mart tables and Source-to-STAGE layer logic, conducting thorough data analysis to prevent software release inconsistencies.
Collaborated with Business Analysts and SMEs to perform Requirement Analysis, translating complex business logic into Test Case Design and Test Strategy documentation.
Documented and tracked software defects via Jira, creating detailed subtasks and attaching testing evidence to ensure user story acceptance and functional integrity.
Validated reporting accuracy within Tableau dashboards, collaborating with report owners to resolve business issues and improve end-user experience.
QA Analyst March 2018 – March 2021
GENWORTH, RICHMOND VA
Conducted Software Quality Assurance through Manual Testing of functional requirements for insurance and benefits administration modules, ensuring usability readiness.
Executed integration testing and GUI validation using Jenkins, ensuring seamless file movement and notification triggers within a SaaS framework.
Documented Requirement Traceability Matrix and gap analysis to facilitate User Acceptance Testing (UAT) and structured issue resolution workflows.
Analyzed production data against new requirements to perform impact analysis, identifying potential defect risks before code deployment.
Managed the defect lifecycle within HP Quality Center, documenting all anomalies and collaborating with cross-functional teams for rapid resolution.
Power BI, BA January 2017 – February 2018
VERITIV, FAIRFIELD OH
Validated Business Objects reports for data quality and precision, performing systematic data analysis to support corporate Quality Management initiatives.
Executed Data Driven Testing across multiple datasets to ensure the reliability and accuracy of data movement from staging to target environments.
Analyzed system requirements to transform business logic into functional manual test cases, improving the efficiency of the software release cycle.
Documented and presented test results and performance metrics to management through automated reports and graphical data visualizations.
BI/ETL /QA June 2016 – December 2016
CAPITALGROUP, LOS ANGLES, CA
Executed positive and negative manual testing scenarios in an Agile Methodology environment to enforce strict software change control policies.
Developed comprehensive test scripts and managed execution within Quality Center, focusing on data completeness and scalability for Teradata systems.
Collaborated with team members to establish test environments and documented Requirement Traceability Matrix to ensure 100% test coverage.
Analyzed and validated SSIS packages and Tableau reports, utilizing Analysis Studio to document results and track defects through Jira.
Additional Skills
Quality Assurance & Testing: Software Quality Assurance, Manual Testing, Test Case Design, Defect Tracking, Test Automation, API Testing, Regression Testing, UAT, Quality Management
Technical & Database Skills: SQL, Teradata, Oracle 10g/9i/8i, MS SQL Server, Greenplum, ETL Validation, Informatica Power Center
Monitoring & DevOps Tools: Jira, CA7, Mainframe, Informatica, SAAS Viya, SAS Enterprise, IBM, Confluence, Salesforce, Hadoop, Informatica View Point, Jupiter Hub, Dynatrace, Jenkins, Big Panda, AutoSys, Unix, Linux, BMC Control M, ServiceNow
Business Intelligence & Reporting: Tableau, Business Objects, Cognos Reports, SSRS, Crystal Reports, MS Excel Pivot Tables