Swati Patel

New Jersey, USA

Summary:

** ***** ** ********** ** IT working with Automation Testing, ETL Testing,Mobile Testing and Manual Testing projects.

Experience working with Risk management (Basel II), Compliance (Actimize), Volker Rule,and Credit Card application projects.

Extensively worked in automating Data Warehouse projectsandActimize Web Applications.

Hands-On experience in Automation Tools -Selenium TestNG Framework, SeleniumBDD Framework, Selenium C#, Rest Assured, SPT Framework, TestNG, Winium, UFT, VB Script, Eggplant and Agile Designer

Experience in automating Web services (SOAP) using Selenium/Java and JMeter.

Successfully executed projects for clients like PNC Bank, Barclays, CITI Bank, KPMG, Prudential Insurance

Achievements:

Received Hackers of the Week trophy at Citibank for verifying critical business scenarios.

Awarded for best team performance at Citibank.

Automation tool developed at Tata Consultancy Services (TCS)using VB scriptsaved client cost around $1,20,000 annually.

Received the first prize for Eureka Idea drive at the TCS account level for developing a data warehouse automation tool.

Technical Skills:

Core Skills

Automation Testing

Automation Tools Used

Selenium, Cucumber,TestNG, Maven, UFT 14.0, Winium, Excel Macro VB Script, PhpUnit2 Framework, AWS Pipeline, Agile Designer, Eggplant, Jmeter

Database

Oracle, Toad for Oracle 10i/9i, SQL Server 2012, Teradata

Test Management Tools

HP ALM 11, JIRA TFS, VersionOne

Other Tools/Utility

Bitbucket, Business Object, Oracle Revelus,Micro strategy, SOAP UI, Autosys, Site Catalyst, IBM Mainframe

Certifications:

HP ALM 11 Certified with 96%.

DomainRisk Management and Basel II certified with 72%.

Diploma in Software Testing certified with A Grade.

ISTQB Foundation certified.

Education:

MASTERS OF BUSINESS ADMINISTRATION (M.B.A.) inInformation Technology

SICSR, Symbiosis International University, India, 2006

BACHELOR OF ENGINEERING (B.E) V.V.P. Engineering College, India, 2003

Work Experience:

VERISK, New Jersey, USA

Title: APlus Auto DPP

Senior Automation QA

Period:Feb 2023 – Till date

Description: ETL/APIWeb-based application project wherethe different source file is loaded at the Pentaho server. The file is then processed to different database layers and different batches are run to load them to the next level. At each layer data is extracted, transformed, and loaded from source to target and has been tested for values, data types,and reconcile. Verified different claims data generated in the Claims table with the original file as well from the Processing table.

Responsibilities:

Perform database testing by writing SQL queries at different database layers and validating different load IDs.

Execute different ETL batches – for file upload and loading data in different database tables by running jobs from Postman.

Verified API GET/POST requests by runninga JMeter automation script for API testing validation.

Performed Automation testing for Auto Claim processing web application.

Verifyend-to-end ETL process from staging to ODS and data export with source data.

Validate data flows from source to target and perform table-levelreconciliation.

Perform negative testing by mocking up different files to satisfy test-to-fail conditions.

Automated web application using Selenium C# .Net Framework with Visual Studio.

Source code management and code sharing done using Bitbucket.

Participated in the scrum, Sprint planning, Sprint retrospective

Environment:TFS, SQL Server 2012, Postman, Jmeter, JIRA, Selenium C#, Bitbucket

PRUDENTIAL, New Jersey, USA

Title: VPAS PIT CREW

Senior Automation QA

Period: Mar 2020 – Jan 2023

Description:VPAS(Variable product administration system) is an insurance-based desktop applicationthat maintains contract-level accounting for annuity holders. It supports product deposits, withdrawals, transfers, and scheduled events. Contact information is shared with customers via statements, confirmations, interactive voice responses, internet, and online information.

Responsibilities:

Implemented BDD Cucumber (UI & API) for In Sprint & E2E/ Regression Automation

Automating VPAS application for life insurance using SeleniumPage Object Frameworkand Winium and related web applications using Selenium web driver.

Developing Test suite and generating different methods/functions using TestNG Annotations and Data provider.

Execute test cases using the testNG test suite and configurethe TestNG xml file.

Responsible for In-sprint automation based on the User stories for the current sprint.

Tested request and response Rest / XML's based web services interfaces using REST ASSURED

AutomatingSOAP web services using Selenium/Java framework.

Responsible for developing automation test plans and identifying test cases for automation.

Source code management and code sharing are done using Bitbucket.

Creating Business functions in UFT for existing UFT automation.

Identified different web elements using Xpath or element locator using Winium tool.

Environment:Selenium,Cucumber Framework,TestNG Framework, Maven, Winium,Bitbuket, SPT framework, Rest API, SOAP UI, UFT, VPAS, Tectia server, ALM, IntelliJ, Eclipse, VPAS Editor, JIRA

VERIZON, New Jersey, USA

Title: Tax Central and TPRS(Tax Payment Request System)

Automation QA Lead

Period: Jan 2019 – Sept 2019

Description:TPRS is a web-based application that enables authorized users to create and approve corporate tax payments. The application facilitates tax payment by automating processes – CPS -103 DOA (Delegation of Authority) and Tax Payment process. Tax Central is used to maintain several related tables containing Account Payable (AP), Legal Entity, and Company details that are required to make payments via AP systems such as nSap and vSAP.

Responsibilities:

Automate web application using Selenium Web driver and TestNG java framework.

Environment setup using Eclipse, Java and Selenium web drivers.

Develop test cases using different testNG Annotations, grouping, prioritize and verify with different assert methods.

Execute test cases using the testNG test suite, TestNG xml fileand batch file.

Run different ETL batches – file handler and master scheduler for file upload.

Verify different reports and compare data in database.

Develop automation test plans and identify test cases for automation.

Environment:TFS, SQL Server 2012, Teradata, Windows 7, Selenium Web driver, Eclipse

Title: FA Compliance

Description:ETL project where data is loadedfrom source system table (TARS) to stagingdatabase. At staging, data is formatted and arranged into different tables. Staging data is loaded in the Data archive database and then loaded to Power Tax load (ODS) – Export.From Power Tax load (ODS) data is exported to verify against source data.At each layer data is extracted, transformed and loaded from source to target and has been tested for values, data types and reconciliation.

Responsibilities:

Perform database testing by writing SQL queries at different database layers and validate different load id.

Execute different ETL batches – file handler and master scheduler for file upload and loading data in different database tables.

Verifyend-to-end ETL process from staging to ODS and data export with source data.

Validate data flows from source to target and perform table-levelreconciliation.

Perform negative testing by mocking up different files to satisfy test-to-fail conditions.

Environment:TFS, SQL Server 2012, Teradata, Windows 7

CITIBANK, New York, USA

Title: KYC

Senior Automation QA

Company: Tata Consultancy Services (TCS), USA

Period: Oct 2016 – Dec 2018

Description: Process by which banks obtain information about the identity and address of the customers and periodically send notifications for outreach customers. The KYC procedure is to be completed by the banks while opening accounts.

Title: Citigold Enrollment

Description:Citigold credit card enrollment application used for enrolling and upgrading different customers to Citi gold and Fintech Investment used for trading different mutual funds/equity, portfolio tracking, and displaying different holdings.

Responsibilities:

Mobile automation testing using Agile Requirements Designer (ARD) and Eggplant toolfor Credit card application.

Responsible for developing automation test plans and identifying test cases for automation.

ExecuteVAPI-XP script in ALM.

Developtest cases, test scenarios, and user flows for various handheld devices covering iOS platform.

Test Data creation using the Mainframe application.

Participate in daily scrum calls, Sprint planning, troubleshooting, retesting defects, and regression of the final product.

Environment:iOS7, iOS6, Eggplant, ALM 12, ARD, Site Catalyst, IBM Mainframe, Selenium, Appium, SQL Server 2000

KPMG, New Jersey, USA

Title: Integrated Enterprise Program(IEP)

Company: Tata Consultancy Services (TCS), USA

Period: Apr 2016 –Sept 2016

Description:IEP will provide set of KPIs for Tax, Advisory and Auditthat will be utilized to access the health of the firm, examine performance results, and evaluate key enablers; which align to the Firm's vision, business model, and One Firm Imperatives.IEP will employ a data strategy that allows for a single point of reference for enterprise metrics and a sound foundation for future BI and analytics requirements.

Responsibilities:

Automate IEP application using Selenium Cucumber framework.

Reviewand develop test cases for IEP application.

Coordinate onsite-offshore testing activities for multiple projects.

Logging and tracking bugs using TFS.

Environment:Mobile and IPad, Qlikview, TFS, Selenium, Cucumber Framework,SQL Server 2008, Test complete

Barclays Capital, New York, USA

Title: IRIS/Finance Crime and Compliance

Senior Automation QA

Company: Tata Consultancy Services (TCS), USA

Period: July 2015 – Mar 2016

Description:Information Repository for Intelligence and Surveillance (IRIS) is an Actimize RCM instance.Actimize is the market leader in Financial Crime, Risk, and Compliance Surveillance software. IRIS enables financial crime to better manage and mitigate organizational risk by centralizing and correlating data and activities from across the business groups into a single interface, turning multiple flows of information into actionable intelligence (Case and Action).

Responsibilities:

Leading and DevelopedQTPscripts using Descriptive programming forthe Fin crime IRIS web application.

Leading and coordinated onsite-offshore testing activities for Compliance (Actimize)web application.

Ensure Defects and Test cases are reviewed and executed as per the project schedule.

Managingreleases and ensuringthe overall success of the testing process.

ExecutingQTP Script from QC.

DevelopingExcel macro for Entitlement and Data masking.

Writing and executing SQL queries for different ETL database layers.

PerformingData migration testingandwriting different SQL.

Environment: QTP 11.5, QC11, Excel Macro, Toad for Oracle 11,SQL Server 2000, Windows XP

Title: Volker Rule

Company: Tata Consultancy Services (TCS), USA

Senior ETL QA

Period: Dec 2014 – June 2015

Description:In house built tool for verification of Volker rule. The Volcker Rule refers to § 619[1] (12 U.S.C. § 1851) of the Dodd–Frank Wall Street Reform and Consumer Protection Act, originally proposed by American economist and former United States Federal Reserve Chairman Paul Volcker to restrict United States banks from making certain kinds of speculative investments that do not benefit their customers.[2] Volcker argued that such speculative activity played a key role in the financial crisis of 2007–2010. The rule is often referred to as a ban on proprietary trading by commercial banks, whereby deposits are used to trade on the bank's own accounts, although a number of exceptions to this ban were included in the Dodd-Frank law.

Responsibilities:

Preparation and execution of test scenarios and test cases.

Writing and executing test cases in ALM11.

Verification of Volker rule reports using Business objects.

Peer Review for automation scenarios prepared for different modules.

Executing QTP scripts from ALM11.

UAT Support

Title: Artemis Project

Senior Automation QA

Company: Tata Consultancy Services (TCS), USA

Period:Feb 2014 – Nov 2014

Description: WithinBarclays, the Control Room system is responsible for monitoring client, employee and firm trading to ensure compliance with regional, global firm, and regulatory requirements. The Control room performs daily surveillance of trades and issuers and corresponding securities which are tracked on a ‘watch’ list and a ‘restricted’ list in order to facilitate the monitoring and identification of potential insider trading via the leakage of material non-public information (MNPI)

Responsibilities:

Developingautomation tool for validating different source feed with target table.

Writing and executing SQL queries using SQL server for different modules at datamart.

Validating source files and target tables for different feeds.

Comparing different models result based on query with XML generated as well comparing XML generated with XML.

Environment: QC11, Excel Macro, SQL Server 2000,JIRA, Windows XP

PNC Bank, Cleveland, USA

Title: RWA testing for calculation of RWA

Automation QA Lead

Company: Tata Consultancy Services (TCS), USA

Period:Nov 2010 – Jan 2014

Description:Data warehouse testing project which performs the Basel II capital calculations for credit risk for retail, wholesale, equity, securitizations and counterparty exposures. Loss severity and probability estimates (PD, LGD, and EAD) will be used to calculate the required capital levels across the various asset classes. Risk Weighted Assets (RWA) involves validating data integrity from the Reveleus data staging area (EIP raw data drop) through the data processing tiers (Calculations) and up to the generated output OBIEE reporting layer RWA. The PNC Reveleus ETL team is responsible for populating output files in the format defined by Oracle RWA team from STG1 into STG2 layer. Once the data is loaded from STG1 to STG2, the SCD process is triggered for populating the staging reference data into dimension tables. Once the SCD process is completed, the DQ processes are triggered which performs the DQ checks on Stage product processor tables. DQ reports are available through OBIEE for analysis. After the SCD process, the GL reconciliation process and RWA calculation processes are triggered to reconcile GL data with Instrument data and for calculating capital and RWA. After the RWA calculations have been run, data will be available for analysis using the OBIEE reports.

Responsibilities:

PreparingAutomation Test Planfor Pillar III Report and different modules developed.

Ledautomation activities and mentored team members.

Automating Pillar IIIReports using the QTP tool and VB script.

Thoroughly analyzing test cases to be automated.

Designing, developing, and automating Pillar III Reports usingUser-defined functions, Generic functions with well-versed VB scripting, and Descriptive programming in scripting dynamic objects for Interact UI in Quick Test Professional 11.0

Executing the QTP Script from QC and updating the final status in the Test lab with attachments.

Developing Automation tools for different modules such as Data Load, SCD Process,and Data Quality using VB script.

Demoand presentation to Client and Onsite Co-coordinator forautomation tool developed using VBscript and Excel Macro.

Preparing and maintaining Input sheets for running different Test cases by the automation tool.

Writing and executing SQL queries using toad for different modules like Data Load, SCD Process, Data Quality, Asset Categorization and RWA Calculators for different assets for different releases.

Running and monitoring different batches from OracleRevelus Tool.

Verification of Pillar III BI Publisher and Drill down reports by comparing data with SQL Queries.

Used Descriptive programming to access child objects.

Analyzing the failed tests and defects; Comparing DQ failed test cases with DQ Reports generated from OBI Reports.

Logging and tracking defects by using ALM 11.

Writing SQL queriesfor generatingdifferent reports after running RWA Calculator batch and comparing the result with Reports generated from OBI Reports.

Environment: QC11, Excel Macro, Toad for Oracle 11,Excel Macro, VB Script, QTP

Yardi Software, India

Period: Sept 2008 – Oct 2010

Responsibilities:

Creating Issue reports for various clients.

Identifying Test Scenarios and Creating Test Plans and Test Scripts.

Working on different cases/Hotfixes for various accounts.

Environment: ASP.Net, C#, Fiddler Tool,Windows XP, Excel, MS SQL Server 2005

Project Undertaken:

Title: Residential Portal

Description: Residential Portal categorized asCorporate Site, Property site, and Residential site whichincludes features such as Property search, advanced search for property, Fusion map, Floor plans, Real-time Unit Availability, Floor Plans and Unit availability, Credit cards /ACH),

Accounts Tested:Greystar,Korman,Nevins, HNN,Alliance, Transglobe, Trinity Residential, StarPoint, BRE and Harward.

Title: Commercial Portal

Description: Commercial Portal designed as a fully integrated solution for real estate enterprises of all sizes. It seamlessly consolidates portfolio, financial, lease, property, budget, and construction data in a single centralized database that is globally accessible via the Internet.

Accounts Tested:Trinity SP6 Commercial, Arcadia.

Niche Software, India

Period: Sept 2007 - Aug 2008

Responsibilities:

Managingthe whole Test life cycle using Test Director.

Functional Testing, Regression Testing, Compatibility Testing, Usability Testing, Module Testing, Integration Testing, Performance Testing

Mentoring Junior Test Engineers by giving them Product demos and assigning various assignments.

Preparing and Executing Test Cases using various methods of Black Box Testing as per Functional requirement document.

Automating the functionality using QTP and creating Data-driven Test Scripts and various checkpoints using QTP.

Environment:Mentis, QTP, Test Director, Asp.net

Project Undertaken:

Title:Juvlon, Email Marketing Application

Description:Its Product is an Email marketing and database management tool specialized in providing extensive reporting to network partners for conveniently tracking the progress and success of a marketing program. It included mailer-sending facilities that have automated subscription/unsubscription, auto reminders, bounce-backs, opts-out, and generating extensive reporting that provided click-through rate and total emails sent.

.

Contact this candidate