BHISHMA THAPA

adymvr@r.postjobfree.com +1-561-***-**** Loxahatchee Groves, FL33470

Summary:

Five plus years of extensive experience in Quality Assurance testing of data warehousing and business intelligence processes, web based and client /server applications. Excellent knowledge in implementation of different QA methodologies/ policies, strategies, and plans in all stages of SDLC. Proficient in querying various RDMS like Oracle and SQL Server Excellent knowledge in test planning, coordinating, execution and leading the testing process. Extensive understanding fixing bugs and defects. Experience working under the Agile and Waterfall methodologies. Self-conscientious starter, strong team skills and ability to lead a team towards achieving organizational objectives. Performed UAT, Security, Positive and Negative Testing. Experienced in developing and testing BI reports as per business rules.

Skills:

Databases: MS SQL Server, Oracle 11g,

Programming Languages: SQL, XML/XML SPY, UNIX,

Software and Tools: Eclipse, Microsoft Office, Selenium, Gherkin, Workday, Sales Force, Service Now, IBM Maximo, Data Splice (Mobile Testing), Git, Linux, Node.js, React.js, Express.js, .NET framework, Informatica, FDR (Financial Data Repository), Data stage, Microsoft Azure, Azure Data Studio

Bug Tracking: Team Foundation Server, Jira, Azure Devops, HP ALM QC and Confluence

API Testing: API Swagger, Postman

Methodologies: Agile, Waterfall

Reporting tool: Power BI, SQR (Structured Query Report), Tableau, Cognos

Platform: Windows, Mac OS X, Android OS, Linux

Experience:

Agile Thought, Sr. Quality Analyst

03/2021 – 05/2023

Vystar

09/2022 – 05/2023

Kirkland and Ellis

04/2022 – 08/2022

Polaris, PwC

04/2021 – 04/2022

Citi Group

UAT Tester/Analyst SQL

06/2018 – 03/2020

Electronic Data Inc., EDI

Quality Assurance Analyst

03/2017 -06/2018

RSC Solutions, Fitch Ratings

ETL QA Analyst

04/2016 – 11/2016

Create/identify test data for testing scenarios from the frontend and backend application and perform detailed, Batch, Online as well as backend database testing (QA + UAT) to ensure the results are in line with the requirements.

Tested Internal Transfers, Mobile deposits, External Transfers, integration with other vendors like Zelle, transfer history

Run SQL queries to check the data in backend in Azure Date Studio and SQL server.

Created and verified Web services API requests using Postman

Worked with Test Engineers to identify test cases that are good candidates for automation.

Maintain and track Acceptance Criteria, testing status, defect tracking and defect metrics in Azure DevOps and Jira.

Collaborated with Agile Thought team members and clients to identify process gaps and provide the best testing solution on a project-by-project basis.

Collaborate with product owner to identify gaps and suggest improvements to requirements.

Tested BI reports by utilizing knowledge of SQL

Attended refinement/triage meetings and recommended corrective actions.

Ensure all testing artifacts like Test Strategy, Test Plan, Test Scripts, QA sign off document etc. are properly curated in accordance with the testing framework

Assisted as a Tester in high performing testing team through all phases of application development; ensured that information systems, products and services met or exceeded organization/industry quality standards and end user-requirements.

Analyzed and interpreted data and manuals to determine precise specifications per each protocol.

Wrote highly detailed front-end manual test cases following a standardized test case template.

Created and verified Web services API requests using Postman.

Created API automation test scripts using Postman API and Swagger

Created test data for conducting UAT testing

Tested .Net framework applications in the frontend

Experience documenting business requirements and/or flows and can prepare tests which are realistic to the business; can pro-actively solve for front-end issues with familiar systems

Define entry and exit criteria for UAT phase

Reviewed, managed and raised defects identified during UAT testing

Collaborated with Agile Thought team members and clients to identify process gaps and provide the best testing solution on a project-by-project basis

Analyzed system specifications and user stories to design and develop test cases.

Wrote front-end and backend manual test cases following a standardized test case template.

Worked with Test Engineers to identify test cases that are good candidates for automation.

Executed test cases, document defects, and create dashboards with Azure DevOps or HP Quality Center.

Tested GUI of Salesforce application according to user stories.

Performed role of Scrum Master when needed.

Documented and facilitated user acceptance testing.

Mentored younger talent within the quality community of practice.

Performed validation of data transformations and perform End to End data validation for ETL and BI systems.

Analyzed and understand the ETL workflows.

Developed test mock data as per the template to facilitate the testing efficiency in QA environment.

Tested BI reports by utilizing knowledge of SQL queries and created dashboards for month end reports.

Strong in BI report validation developed using SSRS BI.

Created and verified Web services API requests using Postman.

Created API automation test scripts using Postman API and Swagger

Collaborated with Agile Thought team members and clients to identify process gaps and provide the best testing solution on a project-by-project basis.

Project: Workday Integration and Data Bridge (HR Data)

Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.

Extensively worked on Workday Data Conversion and Workday Integrations

Developed detail test strategies, plans and scripts to test specific HCM Compensation business process.

Created and verified Web services API requests using Postman.

Created API automation test scripts using Postman API

Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data warehouse/BI applications using Team Foundation Server.

Tested various HR transactions involved in Workday modules Staffing, Compensation, Time and absence, Goals and Payroll.

Tested the Redacted data between Source and Target.

Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.

Writing complex SQL queries for checking the counts and for validating the data at field level.

Writing the requirements in CSV format from SQR in the Data Bridge UAL.

Execute UAT test scripts in SQL.

Tested the format of the reports according to the specifications provided and compared the data in the reports with the backend DataMart through SQL using xml and excel for data comparison.

Worked on System, UAT, Integration and Regression Testing through out testing phase of the project in Workday Implementation.

Co-ordinated with the offshore counterpart for testing needs and also gave KT sessions on the business requirements.

Generated month end reports.

Was responsible for maintaining all the test cases and defects in TFS (Team Foundation Server) for all the team members to review.

Tested .Net framework applications in the frontend

Was the point of contact for the QA team for escalations and lead the bug triage meetings.

Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Supporting PROD issues with Service now Tickets Offshore/onshore

Project: eSAM Implementation (IBM) and Mobile (Data Splice).

Software Testing IBM, DATA QA Front End and Back End (Manual and Automation).

Participated in daily scrum stand-up meeting and clarified on questions and issues related to the stories raised by the development team.

Manually tested each module of the application and verified against expected results.

Written Test Plans and Test Cases to meet the business requirements and the user requirement.

Wrote Test Cases for user-interface, which usually consisted of the screens and the various GUI objects following functional specification and User Test Cases.

Performed end-to-end testing of all business processes, workflows, and output.

Performed UAT, Security, Positive and Negative Testing.

Conducted User Acceptance Testing (UAT).

Experienced in developing Test Plans, Test Cases and Test Reports based upon the business requirements.

Extensive knowledge of SDLC and Agile methodologies.

Experienced in testing Client-Server and Web-Based Applications.

Experience in Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.

Wrote automated test scripts using Automax (Gherkin).

Executed test plans that integrated with release control process Document. Conclusions/recommendations and verify results support that information Determine time estimates and schedule for work and resolve issues in a timely manner.

Anticipate and resolve issues specific to the team.

Deliver services consistent with established standard of quality Review available user documentation; create test plans, test cases.

Execute test plans and provide detailed bug reports.

Showed excellent personal initiative to take on tasks and learn the systems with minimal supervision.

Actively worked with Developers, PM, BA, DBA`s for any issue that comes to the plate to meet the aggressive deadline.

Performed Security testing of various applications.

Involved in Test Matrix and Traceability Matrix and performing Gap Analysis.

Skill in reporting bugs in eTrips (Maximo).

Performed extensive Backend Testing of applications using SQL queries.

Ability to multitask and flexible in adjusting as per demand.

Active team player with outstanding reputation and communication skills for meeting demanding deadlines and delivering critical solutions on various levels.

Project: Markit Feeds

Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.

Responsible to translate business requirements into quality assurance test cases Review of test scenarios, test cases and Data warehouse Test Results.

Developed test scripts using SQL queries to validate data.

Worked on testing data migration, data integration and data transformation. Responsible in testing Initial and daily loads of ETL jobs.

Validated various Ab Initio graphs according to functional requirements. Interacted with design team to decide on the various dimensions and facts to test the application.

Planned of time to test the mapping parameters and variables by discussing with BA's.

Extensively used HPALM QC to track defects and managed them.

Running SQL queries and extracting data from Oracle for data migration

Extensively tested several Micro strategy Reports for data quality, fonts, headers, footers, and cosmetics.

Tested Informatica mappings for various ETL functions.

Education:

Hope International College, Nepal

Bachelor’s Degree in Public Health

2005-2008

Contact this candidate