Chetan K. Shrestha Contact: 248-***-****

ady834@r.postjobfree.com

OBJECTIVE

I seek to obtain a position as a Lead QA Analyst/ Senior QA Analyst in a company where I can utilize my expertise in resolving the problems in test plans and advocate my analytical skills towards the growth of the organization. I truly believe myself to adapt to the working environment and maintain the integrity and work ethics, thereby keeping up the reputation of the organization.

PROFESSIONAL SUMMARY

Expertise in implementing quality assurance and control methodologies to ensure compliance with QA standards and customer specifications.

Assisted for the requirement gathering, estimation and developing test scenario and test cases.

Extensive experience in implementing test verification and performing back end and front-end business user application testing.

Ability to apply technical expertise to organize and implement functional test efforts and to analyze requirements for software design, development, and validation.

Proficient in identifying the areas of the application to be regression tested.

Demonstrated proficiency in handling multiple tasks/projects in a fast-paced environment, often within tight time frames.

Participation in daily team meetings, test scenario walkthrough, technical review meetings, defect triage meetings with the developers and end users.

Effectively communicated and reported bug/ defects identified in different phases of testing and generated defect reports, bug validation with defect tools.

Interacted with customers/ business users to understand their business and consult with them on QA strategies for user acceptance testing, confirming the scope of testing providing clarity on the test environment.

Performed extensive backend testing by developing, modifying and executing SQL queries for data validation and identification.

Managed different phases of testing progression, planning, estimation and project tracking ensuring the problems are reported and issues are resolved or escalated to concerned teams.

Solid understanding of client requirements, analyzing software specifications, design techniques and checking that developed product is within specified requirements and quality parameters.

Expertise in entire Software Development Life Cycle (SDLC) and testing life cycle in different environments and platforms.

Quick learner and effective team player with the ability to work productively and independently.

Excellent written and strong communication skills and interaction with end users, developers, business analyst and management.

TECHNICAL SKILLS

Operating Systems

UNIX, Windows 7, Windows 10

Testing Tools

ALM Quality Center, Quick Test Professional, FACETS

ETL Tool

Informatica

Desktop Technologies

MS Word, MS Excel, MS Access, MS Visio, PowerPoint, MS Project

Databases

Oracle, SQL DBX, SQL Server, TOAD

EDI Transaction Sets

834, 835, 820, 270,271, 837

Defect Tracking Tool

ALM Quality Center, Clear Quest, JIRA

Others

SOAP UI, Service Manager, Share Point, Ultra Edit, Claredi, Postman Tool

PROFESSIONAL EXPERIENCES

000

Veros Real Estate Solutions, CA

May 2022 to May 2023

Quality Assurance Analyst

Veros provides commitment in providing the solution and collateral risk management solutions to help clients meet the demands of complex industry regulations as well successfully adapt to the evolving mortgage landscape for profitable business results. They provide innovative solutions to address the modern evolving needs in the real estate and mortgage industries. Our platform enables to predict and control portfolio risk, mortgage fraud.

Responsibilities:

Prepared test scenarios and reviewed with the team mates to meet the business requirements.

Performed extensive backend queries in TOAD to verify the membership data on the front end.

Used UCDP (Uniform Collateral Data Portal) application to submit the appraisal for FNM and FRE clients.

Used EAD (Electronic Appraisal Delivery) application to submit the appraisal for FHA clients.

Used AWS portal to submit the appraisal for VA affairs.

Extensively performed smoke test for all maintenance/server updates done for each environment.

Involved in the regression test of UCDP and EAD new releases.

Used DI tool as an open-source testing solution for receiving, storing and sending data over http as XML.

Defects also tracked at JIRA and shared the report to the management teams on a weekly basis.

Generated daily and weekly status reports to keep track of the overall testing progress.

Capital Blue Cross, PA

July 2017 to Feb 2022

UAT Test Lead

Capital Blue Cross is the leading health solutions and insurance company in Central Pennsylvania and the Lehigh Valley. They offer health insurance products, services and technology solutions that provide peace of mind to consumers and promote health and wellness for our customers. More than a health insurer, the company delivers innovative solutions through a family of diversified businesses that creates a healthier future and lowering health care costs. Capital Blue Cross is an independent licensee of the Blue Cross Blue Shield Association.

Responsibilities:

Tested all the impacted components of business as usual (BAU) as well as new components that are dependencies and related downstream.

Prepared test strategy and plan for multiple projects based on the requirement document and discussion with the business users.

Partnering with the business team, development team and third-party vendors to ensure that testing strategy is understood, in use, test prerequisites are completed and that test outputs are analyzed.

Driving test deliverables on a project’s basis being responsive to schedule and quality requirements.

Keeping management informed of project schedules, status, issues and metrics.

Ensured the extract files were generated on Eligibility, Medical Claim, Dental Claim, RX Claim, Medicare and Activity File for vendor Bravo.

Ensured the replication of claim, provider and member data from FACETS to a new sandbox database for Excellus.

Helped the business users creating test scenarios. Uploaded them to ALM Quality Center and linked to appropriate detailed business requirements.

Defects also tracked at Quality Center and shared the report to the management teams on a weekly basis.

Generated daily and weekly status reports using ALM Quality Center to keep track of the overall testing progress.

Blue Care Network, MI

Sept 2014 to Apr 2017

Lead QA Analyst/ Senior QA Analyst

Blue Care Network of Michigan is a nonprofit health maintenance organization. They are owned by Blue Cross Blue Shield of Michigan. They offer insurance plans within defined regions under one of both association brands. They offer some of the health insurance coverage in every US state. They also act as administrators of Medicare in many states or regions of the US and provide coverage to state government employees as well as to the federal government employees under a nationwide option of the federal employee health benefit plan.

Responsibilities:

Verified the source data in Workload Management for BCN, BCBSM and DUAL customers with proper indicator for the source type in Highmark Pricing System (HiPS) application.

Generated trigger file on the experience period and run out months provided by the business for a given renewal month.

Responsible for data mapping activities during ETL process from source to target and involved in extensive data validation using SQL queries.

Made sure FARE extracts generated with proper naming convention and placed in the server for Highmark to pick up.

Made sure Highmark has the consumption process completed and all the data loaded into HiPS successfully.

Created work item for the given large group on the experience period and run out months provided in the trigger file.

Ran the master flow calculation for the large group to generate the BCN Rates for the renewal purpose.

Send the data downstream for the calculated large group and verified Rate File and Renewal Package Data were generated.

Verified the most current and active products in BCN Rate File generated.

Ran the UNIX scripts for BCN Rate File to load the rates successfully into FACETS.

Made sure Response File got generated after BCN Rates were loaded into FACETS.

Got the BCN Outbound Files loaded to FARE database for BI tool to generate the Final BCN Renewal Package.

Involved in testing FACETS for group information, enrolling subscribers, adding members, related entities, class/plan definitions and premium rate tables.

Generated, managed and developed EDI specifications for data feeds and mappings to follow ANSI X12 5010-834 format to meet HIPAA requirements.

Modified 834 transactions into XML file format and verified the member data loaded to FACETS for further processing.

Tracked/monitored defects and results for management, categorized issues and created defect reports using Clear Quest.

Dean Health Plan, WI

June 2014 to Sept 2014

Senior QA Analyst

Dean is one of the largest integrated health-care delivery systems in the country headquartered in Madison, Wisconsin. It provides medical and health services through a network of Dean or St. Mary’s/Dean-owned clinics throughout southern Wisconsin. Dean is for a profit, integrated health care organization which consists of network of more than 60 clinics in south-central Wisconsin. Approximately 500 physicians provide primary, specialty and tertiary care in the clinics and the system serves more than 300,000 health plan members.

Responsibilities:

Prepared test scenarios and reviewed with business users to meet business requirement and to cover business scenarios.

Performed extensive backend queries in SQL server to verify membership data on the front end.

Designed and developed the test strategies and test plans through the entire project life cycle.

Used HP Quality Center as test management tool for defect tracking and test case execution.

Created multiple users in Selenium for the validation of application certain function.

Tested the portal application to make sure claims and members were loaded to Meta Vance and made sure providers could check the member eligibility and claim status.

Worked on 834 EDI transaction including syntax and business rules for X12 HIPAA 4010 and 5010 validations for loops, segments, qualifiers and code sets.

Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.

Re-engineered and created test scripts in Selenium to test the function of an application.

Followed the HIPAA implementation guides for preparing the EDI files.

Used Claredi tool to check the EDI files for HIPAA errors.

Worked with team members to incorporate agile methodology into project.

Blue Cross Blue Shield, MI

August 2010 to June 2014

QA Analyst/ Business System Analyst

Blue Cross Blue Shield of Michigan is one of the largest independent licensees of Blue Cross Blue Shield Association. Currently it is headquartered in 600 E. Lafayette Blvd. in downtown Detroit. Blue Cross Blue Shield of Michigan, a nonprofit organization, provides and administers health benefits to more than 4.3 million Members residing in Michigan in addition to members of Michigan-headquartered groups who reside outside the state.

Responsibilities:

Reviewed complex scenarios for all instances based upon workflow and recommended actions to facilitate and improve the efficiency of testing quality and coverage.

Prepared detailed test cases by understanding the user requirements and ETL logic from Incentive Management Tracking to Light Weight Data Store.

Worked on another set of test cases using Store Procedure Logic from Light Weight Data Store to Member Portal User Interface.

Generated XML file for membership, activity, milestone and compliance details.

Ran Tivoli jobs for various ETL job stream created and checked the status of the job stream with its job detail.

Prepared Sales Notification File for Solution Mapping Solution and verified all the error codes in the notification file running UNIX scripts.

Used Soap UI as an open source testing solution for receiving, storing and sending data over HTTP as XML.

Verified the reprocessing job for all the error codes present in the notification file.

Created and executed SQL queries in TOAD to validate back end data population.

Updated and maintained test data accurately with the current workflows and uploaded the test results in SharePoint.

Reported all the bugs in Clear Quest and facilitated defect call based on bug’s status as well on severity and priority of the defect.

EDUCATION

Bachelor’s Degree in engineering (Completed in 2004)

Kathmandu Engineering College, Kathmandu, NEPAL

Master Degree in Engineering (Completed in 2010)

Old Dominion University, Norfolk, VIRGINIA

Contact this candidate