Sr. QA Analyst

Summary of Qualification:

Seeking a challenging position as Senior QA Analyst in all phases of testing for Client Server environment and Web application. Proficient in various testing methodologies and tools, with a strong ability to collaborate with cross-functional teams to deliver high-quality solutions. Extensive professional experience in Manual and Automation as Software QA engineer in Client Server Application in both Front End & Back End testing with a focus in quality management, analyzing the business requirements, Gap Analysis, Customer Experience.

Summary of Skills:

Analytical Skill: Requirement and Gap Analysis, Defect Root Cause Analysis

Technical Documentation: Test Plan/Test Cases, Defect Tracking, User Stories

Testing Methodology: Waterfall and Agile Methodology, Black box, White box, Regression, Boundary and Negative testing.

Automation of Testing: TOSCA, Selenium with Java, UNIX Shell Scripts

Communication Skill: Team interaction, User interaction, Inter and Oral Communication skill.

Technical Skill: SQL, API testing, UNIX, Unix Scripting, ETL Testing, SoapUI, JIRA, Microsoft SQL Server, Microsoft Azure SQL Database

CORE OF EXPERTISE

Languages: SQL, PL/SQL, C/C++, Java, XML, HTML, Shell (Korn) Scripting, Visual Basic

RDBMS Servers: Oracle 11g/10g/9i, MS Access, TOAD, Microsoft SQL Server Management Studio 17, SQL Server, DB2, TOAD SQL Server

Operating Systems: Windows 10, Windows XP/2000, Windows 7, HP UNIX, Linux

Database Tools: SQL*PLUS, Microsoft Azure SQL Database, DB Artisan, Rapid SQL, ORACLE SQL,Developer 18.2, TOAD

QA Tools: TOSCA, Quality Center, Selenium, Silk Central, SoapUI, Team Track, iTrack, Rational Clear Quest, JIRA, Digital.ai.Agility

Front ends: Visual Basic, JAVA

Web Technologies: HTML, JavaScript, JDBC, Servlets and JSP

FICO Products: FICO Fraud Manager Expert, FICO Case Manager Tool

Other Tools: Splunk, Kibana, DynaTrace

PROFESSIONAL EXPERIENCE

Walgreens Inc. IL January 2022 TO Date

Sr. QA Analyst

Project: POS Config and SCT Application. POS config is a central interface between SCT (Store Configuration Tool) and POS store environment which ensures all the store configuration change made in SCT applications are converted in the POS consumable format (XML1) and send to CPOS/POS. SCT is Web application which is used by support users for setting and sending the POS related data like Coupons, Store Department, Discounts, Taxes and Drug Rules.

Created Test Plan for identifying Scope, determining Testing Methods, decides on timeline, forecast Risk & Assumption and also declares Entry & Exit Criteria for Testing Phase.

Design and developed SCT and POS-Config test execution report, shared report on daily basis with the team which includes overall status, Key Highlights, Test Execution status and Defect Metrics details.

Utilized Azure DevOps for test management, defect tracking, and integration with CI/CD workflows.

Written SQL scripts to pull the data from the existing database based on the business rules and updating the database tables for the Backend Testing.

Performed test design automation and validated Regression test scripts using Java Selenium automation tool.

Contributed to Risk Management Plan, Communication Plan and Test Plan. Regularly published Project Matrices like Defect Reports, Test Coverage and Test Execution Reports.

Validate ETL test scripts for transformation logic to ensure data is correctly transformed according to business rules.

Coordinated with development and operations teams to ensure smooth deployment of releases through Azure DevOps.

Performed API testing using SOAPUI tool and tested various status codes messages.

Used DynaTrace tool to analyze and monitored the performance during regression testing.

Verified ETL extracted data for Transformation between Source and Target schema by developing SQL scripts

Fiserv Inc., NJ April 2016 TO September 2021

Software Test Engineer, Sr

Project: FALCON5.2c to FALCON 6 (FICO product) upgrade. Fiserv uses Enfact as a major part of its Risk offering to Card Services clients. Card services is currently running version 5.2c of Falcon Fraud Manager which is at almost end of life from a support perspective. FICO has noted that there are major changes to the Falcon Fraud Manager suite of products from an infrastructure perspective. For this reason, FICO recommends that Card Services fully upgrade a new full implementation rather than migrate from the current version to the new version. FICO has completely changed the database structure and the APIs and added some new features which card services may want to consider using it.

Performed in depth level of various types of transactions feed testing including DBTRAN\CRTRAN (debit\Credit transaction), RBTRAN (Retail banking), NONMON (Non monetary transactions), CIS\PIS (customer and payment transaction), Hotlist and Compromised cards transactions.

Responsibilities also included to test and validate other Risk services related application such as Compromised Card, EnFact Alert Notification (Alert Broker –Nuance), Risk Gateway, CaseTracker and CWSi – Card Management.

Involved in automatic test scripts designing and performed regression suite validation using Java Selenium test automation tool.

Managed test cases, tracked defects, and reported on test progress using Azure DevOps, ensuring seamless tracking and reporting.

Experienced in working with Splunk tool in order to monitor, search and analyzed big data. Generated various graphs, alerts and dashboards.

Implemented API testing using SOAPUI and tested REST and JSON messages for Alert outcome Notification components while working with third party vendor Nuance.

Extensively involved in Mobile Site testing on iOS (Mobile and IPad) and Android Device.

Bank of New York Mellon, NY April 2015 TO December 2015

Sr. QA Analyst

Project: MISMO SFPDM (Mortgage Industry Standards Maintenance Organization) The Mortgage Industry Standards Maintenance Organization (MISMO) has developed a data standard using Extensible Markup Language (XML) for the exchange of mortgage servicing related data, from loan delivery to investor reporting and creating holistic view of loan and pool delivery data. Ginnie Mae and BNY Mellon are engaged in a major systems modernization effort. As part of this modernization effort, Ginnie Mae seeks to align with the mortgage industry and adopt The Mortgage Industry Standards Maintenance Organization (MISMO) for its single family at issuance pool delivery data for forward mortgages. Ginnie Mae and BNY Mellon have leveraged the MISMO standard to create the Pool Delivery Dataset. As a Sr. QA analyst I was responsible to test MISMO SFPDM (Single Family Pool Delivery Module) application.

Performed Enterprise Wide Operational Data Store(EWODS) to Online Transaction Processing (OLTP) database testing

Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules

Involved in ETL Data conversion and ETL Incremental Delta Load testing

Verified ETL extracted data for Transformation between Source and Target schema by developing SQL scripts

Developed and executed automated test scripts in Java Selenium, achieving a 90% automation coverage for critical functionalities.

Participated in UAT testing to ensure that new features met client expectations and industry standards.

Validated Ginnie Mae Enterpise Portal (GMEP) for various application such as MISMO, Platinum Pool Processing and Issuer Management

Tiffany & Co, Parsippany, NJ November 2014 TO March 2015

Sr. QA Analyst

Project: Vertex 6.0 Tax Software Upgrade. Testing project at Tiffany & Co consist of various applications throughout enterprise. Company is going through transformation phase where all legacy system are being upgraded or replace by new applications including E Com site, Enterprise Order Management, Content Management, POS Terminal, Product Management and Warehouse Management System. Involved in testing Vertex 6.0 Tax Software Upgrade project which ensure the proper tax is calculated, applied and reported to the satisfaction of the stakeholders.

Involved in evaluation of Business Requirement Document and Software Requirement Specification.

Performed E-Commerce testing on GUI application and validated proper tax calculation.

Written SQL scripts to pull the data from the existing database based on the business rules and updating the database tables for the Backend Testing.

Coordinated Defect life Cycle and daily Defect tracking meetings. Prepared test status reports and Execution plan during test execution process

UBS, NJ September 2011 TO October 2012

Technical Test Lead

Project: COBRA (Cost Basis Regulation Act) Tax Software Upgrade. UBS offers high net worth and affluent individuals around the world a complete range of tailored advice and investment services. Involved in testing real time application called COBRA (Cost Basis Regulation Act) which basically all about reporting gain or loss while buying and selling securities such as Equities, Option and Mutual Funds.

Responsible for analyzing system requirements and developing a test plan for the project based on SDLC by performing Gap Analysis and major and minor function.

Experienced in testing of COE (Consolidated order entry) system for different financial instruments like equities, options, fixed income and mutual funds

Executed various equities and mutual fund order using CTPS - Rumba application

Review QA Test Plan (System, SIT) with cross functional team, updated test plan, baseline test plan and updated in each release and make baseline.

ADP, NJ August 2010 TO June 2011

QA Analyst

Project: Vantage HCM application. ADP offers a wide range of HR, payroll, tax and benefits administration solutions from a single source. Responsibilities included testing a Vantage HCM – Is a cornerstone solution with (R)evolution UI built from the inside out by providing required functionality (Employee Recordkeeping, Position Management and HR Compliance) along with the ability to integrate current ADP solutions as well as those ADP may build, partner with and/or acquire in the future.

Designed and executed Business Process Tests (BPTs) for each testing cycle and analyze the results in Quality Center.

Designed Business Components request using Quality Center for Benefit area, Client Notes, Tier Groups, Programs and General Setup modules.

Developed and maintain test cases, test plans, project plans and traceability matrix and ensure all documentation and test cases are complete and comprehensive.

Performed Baseline Testing and then Regression Testing (Executed old functionality to verify result) for each Software Release.

EDUCATION

B.S.in Accounting & Business Management

Diploma in Computer Application

RERERENCES

Available upon request.

Nikunj Patel

Cell: 732-***-**** · ********@*******.***

www.linkedin.com/in/nikunj-patel-030b842

Contact this candidate