Business Analyst Quality

linkedin.com/in/sukhvinder-mehta

Sukhvinder Mehta

669-***-****; *****************@*****.***

Professional Summary

* ***** ** ************ ****** in the field of Information technology as Software Quality Analyst / Testing Engineer.

Working as a Quality Analyst in Lam Research from August 2021 .

Worked as Quality Analyst in Wells Fargo from March 2020 for their CCAT team.

Worked as Software Testing Engineer at Ross, Inc in Dublin, CA for their MDM team from May2019 – Feb2020.

Worked as Software Testing Engineer at Bank of the West in San Ramon, CA from Sep, 2017 – Mar 2019 through IT Avalon consulting firm. Worked as Manual Testing engineer for their Touchpoint team and Cards team.

Worked as Software Testing Engineer at Wells Fargo Bank in San Francisco, CA from Feb, 2016 – Aug 2017 through Strategic Staffing Solutions consulting firm.

Domain experience in Banking and Retail.

Extensive understanding of the various SDLC methodologies like Waterfall, Agile including Scrum methodologies

Extensive experience in documentation and scripting including the Test plan, test scenarios, test cases and Bug reports.

Responsibilities included understanding the requirements, working with Dev team and setting up the test environment, installations and configuration.

Experience in analyzing business requirements, system and functional specifications including use cases along with coordination with various teams to ensure the timely delivery

Good Understanding of mapping of business / client requirements (FRD, BRD) and discussing best IT solutions involving understanding of scope of project, weekly status updates to Client about the testing plan and milestones.

Proficient in using Test Management tool Like Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Reporting.

Experience in both Manual and Automation testing of Web based, Mobile App Manual testing (iOS/Android), Multi - tier applications. Involved in testing of the Notification systems including Alerts and email/SMS messages.

Extensive experience in GUI, Regression, Functional, Integration, System, Sanity, Compatibility, web services, Reports, Usability, Security and Database Testing.

Expertise in RIT and QTP in developing and executing test automation scripts for Smoke, Functional and Regression Testing.

Experience in using SoapUI for testing Service Oriented Architectures (SOA) and Web Services (SOAP, REST, and WSDL).

Experience of backend database testing by writing and executing complex SQL queries for data validation and verification, etc.

Excellent Communication, Interpersonal and Leadership skills, Self-motivated, quick learner, Good team player and ability to work individually with strong desire to achieve quality results.

Ability to achieve targets and deliver results in a high-pressure environment.

Experience Highlights

08/2021- June2022 Lam Research Fremont, CA

Project #1:

Quality Analyst

Lam Research is an American supplier of wafer fabrication equipment and related services to semiconductor industry. To assemble we have manuals, installation guides and documentation.

Responsibilities

Performed testing of Manuals and content on different devices or tablets and HoloLens

Gathered requirements documents such as business requirements and design document and other related documents.

Reviewed the Test Basis, designed and documented Test Strategies, Test Plan, Test Cases and executed testcases.

Involved in testing the application utilizing the Scrum (Agile) methodology.

Manually tested, verified and validated that the product meets user requirements.

Developed and executed SQL queries to verify the proper insertion, deletion and updates into the Oracle supporting tables and cubes.

Performed SOA / web services testing using SOAP UI; wrote adaptors to test / invoke web services.

Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.

Performed End-to-End testing of database to check data integrity using SQL queries. Assisted QA lead in documenting User Acceptance Test report and reporting defect resolution.

Environment: JIRA, PowerShell, Confluence, SSMS

Joined as part

03/2020- July 2021 Wells Fargo San Francisco, CA

Project #2: CCAT

Quality Analyst

Joined as part of the CCAT ( Commercial Card Access Tool ) QA Team . CCAT is used to order Commercial card for business needs. Business can order new cards and replacement cards for their employees and maintain them . As a tester used to validate the created cards status and information in the Mainframe system TSYS where it is stored .

Leaded project User Creation in CCAT team under which validated UI of new screens and also validated through database whether Exceptions are showing up in Pending Exception while creating users and then resolve them and validate if they are closed and show up in Closed Exception .Also, validated email triggers and email validation .

Responsibilities

Responsibilities include working with the Client team as a Software Testing engineer.

Participated in Waterfall SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)

Run Defect Triaging and Review the Test Scenarios/ Test Cases.

Worked closely with the end user, business analyst and the technical team to ensure best practices in testing methodologies

Involved in Functional, Regression & Integration testing and writing Test Cases using Quality Center

Performed Back End Testing using SQL Queries

Involved in Defect tracking and defect review meetings and Defect prevention analysis

Environment: - Windows 10, SQL Server, HP Quality Center .

05/2019 – 02/2020 Ross, Inc Dublin, CA

Project # 2: MDM Integration

Software Testing Engineer

Module 1: MDM Supplier WEBUI

MDM supplier WEBUI program is about performing Web UI testing of different functionalities of supplier. Supplier workflow allows Ross to onboard new suppliers in STEP. Finance and MDO teams will be able to create Merchant, Expense and factor suppliers.

Supplier is a key master data domain of Ross stores and supplier onboarding is a key asset for Ross. In general, there are five types of suppliers that Ross deals with and they are Merchant supplier, Expense supplier, Factor supplier, Beneficiary supplier and Agent.

Merchant supplier creation process is initiated by a Ross merchant or a Ross agent. Master Data Office (MDO) receives these requests and create a draft supplier record in Master Data Management (MDM) System and sends a URL to supplier to complete the remaining details. After data validations AP finance department enriches with additional data elements and activates the supplier record in MDM system. After that, all stakeholders are informed about the active supplier record and supplier master data is sent to consuming systems.

Responsibilities

Responsibilities include creating test cases and executing them.

As a tester, my job was to login supplier web UI as Different user and validate all user access for Different pages like login as MDM manager and validate if he can submit a supplier, If he can do advance search.

Validations include validations of different workflows like create supplier and maintenance workflow, deactivation workflow and reactivation workflow.

Testing included validation of different workflow through different user and also integration testing to check whether that supplier has gone down stream like SOA, PeopleSoft, EDW since data was migrating from PeopleSoft.

Validation also included validation of different reports like supplier status report, active suppliers report, so it included validation of correct format of reports in Excel and do data validation whether correct data is pulled or not. Also, validated through work bench also validated in different environment like DEV, INT, TST, UST, STG.

09/2017 – 03/2019 Bank of the West San Ramon, CA

Project # 3: Touchpoint

Software Testing Engineer

Module 1: KYC (Know Your Customer)

KYC is the cornerstone of an effective program of Anti money laundering (AML), combating the financing of terrorism (CFT) and sanctions compliance and every line of business within the Bank must ensure compliance with the KYC requirements of the Bank’s Policy and local US requirements.

As part of the requirements, BOTW developed a KYC program to gather information that will allow the Bank to assess the AML risk level for every customer.

Executed and tested to enhance bank's KYC program is to support customer master data management. The major tracks of the project called Single KYC Record which involve mastering of KYC profiles and segments based on merged and unmerged data from MDM.

Module 2: Unauthorized Account Detection:

This project was to implement a mechanism for customer to confirm and authorize the validity of new deposit account relationships opened in their name.

We need to validate the file generated by Touchpoint and data file given by BIDM team and compare them in excel using Vlookup and make sure all accounts opened during that time through TouchPoint are also available in generated Data file and validate layout of Data file too

Module 3 : Cards

This project includes Testing on BOTW Credit, Debit, and ATM and Business card holders with additional self-service options for different modules for alerts/PIN change, travel notice/card controls, new card activation/order card, functionality, and credit card related payments capability and credit line increase with existing Online Banking (OLB) Portal and Mobile Banking (apps & Touch browser) integrating with First Data eCustomer Service site to provide customers with additional card related capabilities. Along with Single Sign On (SSO) from Online Banking and Mobile Banking to First Data eCS and UI changes in OLB portal and Mobile Banking to provide quick, easy, and seamless access to FD eCS

Responsibilities

Responsibilities include creating test cases and executing them .

Participated in Waterfall SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)

Run Defect Triaging and Review the Test Scenarios/ Test Cases.

Worked closely with the end user, business analyst and the technical team to ensure best practices in testing methodologies.

Involved in Defect tracking and defect review meetings and Defect prevention analysis

Performed cross-browsing testing to verify if the application provides accurate information in different browsers.

Involved in testing of the Notification systems including Alerts and email/sms messages.

Involved in Mobile Web and Mobile App manual testing (iOS, Android), regression and bug writing using manual methods.

Test execution with both RealDevices and Emulators/Simulators.

Worked closely with the end user, business analyst and the technical team to ensure best practices in testing methodologies

Involved in Functional, Regression & Integration testing and writing Test Cases using Quality Center

Performed Back End Testing using SQL Queries

Environment: - Windows 8, Mainframe, SQL server, HP Quality Center.

02/2016 – 07/ 2017 Wells Fargo Bank San Francisco, CA

Project # 4: CCBS

Software Testing Engineer

Wells Fargo Bank is a reputed name in the field of Banking.

CCBS/DCBS (Credit Card and Debit Card Business services) application processes requests for data for clients such as WIP/CIV/Prevent from various systems of records.

CCBS is an internally developed set of business services using Services Oriented Architecture (SOA) Robust integration supports multi-LOBs and service consumers and mission critical middleware.

Responsibilities include working with the Client team as a Software Testing engineer.

Participated in Waterfall SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)

Run Defect Triaging and Review the Test Scenarios/ Test Cases.

Performed Regression testing, running automated scripts in RIT and analyzing them .

Worked closely with the end user, business analyst and the technical team to ensure best practices in testing methodologies

Involved in Functional, Regression & Integration testing and writing Test Cases using Quality Center

Performed Back End Testing using SQL Queries

Involved in Defect tracking and defect review meetings and Defect prevention analysis

Environment: - Windows 8, SQL Server, HP Quality Center.

Competencies

Operating Systems: Windows XP, UNIX, LINUX, Mac, IOS, Android

Testing Tools: Quick Test Professional (QTP)/ HP-UFT

Defect Management: HP – QC/ALM, Bugzilla, IBM Rational Clear Quest, JIRA

Databases: Oracle, MS Access, MySQL, MS SQL SERVER, DB2

Languages: C, C++, Java, SQL, PL/SQL

Tools: MS Office Suite, MS Project, MS Visio.

Education

Bachelor of Technology (Computer Engineering), M.I.E.T Meerut, India

Contact this candidate