Swati Patel *********@*****.*** Cell: 330-***-****
Parsippany, NJ, USA
Summary:
8+ years of experience in IT working with Automation Testing, ETL Testing and Manual Testing projects and currently working at KPMG, Roseland.
Leading and coordinating Automation and Manual Testing project activities.
Experience working with Risk management (Basel II), Compliance (Actimize) and Volker Rule projects.
Extensively worked in automating Data Warehouse project, Actimize Web Application using automation tools such as QTP, VB Script and PhpUnit2 Framework.
Worked with different software development models such as Agile and Waterfall methodologies.
Experience working with ETL testing consisting of Data transformation, sourcing, mapping.
Hands on experience in Functional, Automation and White box Testing, Regression Testing and Database Testing.
Certifications:
HP ALM 11 Certified with 96%.
Domain Risk Management and Basel II certified with 72%.
Diploma in Software Testing certified with A Grade.
ISTQB Foundation certified.
Technical Skills:
Automation Tools
QTP 11.53, Excel Macro VB Script, PhpUnit2 Framework
Database
Oracle, Toad for Oracle 10i/9i, SQL Server 2000
Testing Tool
HP ALM 11, Quality Center 11, Oracle Revelus Tool, Business Object, JIRA
Documentation Tools
MS-Office, Power point
Education:
MASTERS OF BUSINESS ADMINISTRATION (M.B.A.), INFORMATION TECHNOLOGY SICSR, Symbiosis International University, Pune, India, 2006
BACHLORE OF ENGINEERING (B.E), INFORMATION TECHNOLOGY
V.V.P. Engineering College, Saurashtra University, Rajkot, India, 2003
Achievements:
Automation tool developed at Tata Consultancy Services (TCS) using VB script saved client cost around $1,20,000 annually.
Received first prize for Eureka Idea drive at TCS account level for developing data warehouse automation tool.
Appreciations received from Clients and Manager for developing an indigenous automation tool at project level.
Awarded for conducting different sessions ALM 11, Metrics at TCS account level.
Work Experience:
KPMG, USA
Title: Integrated Enterprise Program (IEP)
Period: Apr 2016 – Till Date
Description: IEP will provide set of KPIs for Tax, Advisory and Audit that 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:
Coordinating onsite-offshore testing activities for IEP application.
Automating IEP application using Selenium Cucumber framework.
Reviewing and developing test cases for IEP application.
Performing functional testing, Regression Testing.
Logging and tracking bugs using TFS.
Environment: Mobile and IPad, Qlikview, TFS, Selenium, SQL Server 2000
Barclays Capital, USA
Title: IRIS/Finance Crime and Compliance
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:
Lead and Develop QTP scripts using Descriptive programming for Fin crime IRIS web application.
Leading and coordinating onsite-offshore testing activities for Compliance (Actimize) web-application.
Ensure Defects and Test cases are reviewed and executed as per project schedule.
Manage releases and ensure overall success of testing process.
Participate in project meetings and send Daily status report to clients.
Create data driven test with test data set and verified functionality.
Maintain and create new shared object repository for automation scripts.
Create functional library and reused functions across all scripts.
Execute QTP Script from QC.
Coordinate Performance testing, Automation Testing activities with team.
Develop excel macro for Entitlement and Data masking.
Writing and executing SQL queries for different ETL database layers.
Business Object Report validation.
Perform Data migration testing and writing different SQL.
UAT support
Environment: QTP 11.5, QC11, Excel Macro, Toad for Oracle 11, SQL Server 2000, Windows XP
Title: Volker Rule
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:
Analyze and understand business requirements.
Preparation and execution of test scenario and test cases.
Writing and executing test cases in ALM11.
Verification of Volker rule reports using Business objects.
Adding and tracking defects using JIRA.
Participating in daily status call with Client for understanding business requirements.
Conducting different types of testing such as System Testing, Regression Testing and Sanity Testing.
Peer Review for automation scenarios prepared for different modules.
Executing QTP scripts from ALM11.
UAT Support
Title: Artemis Project
Period: May 2014 – Nov 2014
Description: Within Barclays, 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:
Analyse and understand business requirements.
Preparation and execution of test scenario and test cases.
Developed automation tool for validating different source feed with target table.
Writing and executing SQL queries using SQL server for different modules at datamart.
Adding and tracking defects by using JIRA.
Participating in daily status call with Client.
Validating source files for different feeds.
Validating target tables for different feeds.
Comparing different models result based on query with XML generated as well comparing XML generated with XML.
Conducting different types of testing such as System Testing, Regression Testing, Database Testing, Sanity Testing.
Environment: QC11, Excel Macro, SQL Server 2000, JIRA, Windows XP
PNC Bank, USA
Title: RWA testing for calculation of RWA
Period: Mar 2011 – 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. PNC Reveleus ETL team is responsible for populating output files in format defined by Oracle RWA team from STG1 into STG2 layer. Once the data is loaded from STG1 to STG2, SCD process is triggered for populating the staging reference data into dimension tables. Once 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, 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:
Prepared the Automation Test Plan for Pillar III Report and different modules developed.
Leading automation activities and mentoring team members.
Leading and coordinating Onsite activities for Pillar III report
Automated Pillar III Reports using QTP tool and VB script.
Developing and working on huge Automation Framework.
Thoroughly analyze each and every test case to be automated.
Designed, developed and automated Pillar III Reports using User defined functions, Generic functions with well-versed VB scripting, Descriptive programming in scripting dynamic objects for Interact UI in Quick Test Professional 11.0
Creating Functions and Library Files using VB Script to maximize the reusability of scripts.
Customized and enhanced the test scripts defining various checkpoints, Synchronization point and reusable functions.
Created data driven test with test data set and verified functionality.
Maintain and create new shared object repository for automation scripts.
Executed the QTP Script from QC and updating the final status in Test lab with attachments.
Developing Automation tool for different modules such as Data Load, SCD Process and Data Quality using VB script.
Demo and presentation to Client and Onsite Co-coordinator for automation tool developed using VB script and Excel Macro.
Preparing and maintaining Input sheets for running different Test cases by automation tool.
Used Error handling methods (On Error Resume Next) to handle expected/predicted errors.
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 Oracle Revelus 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 queries for generating different report after running RWA Calculator batch and comparing the result with Reports generated from OBI Reports.
Conducting and participating in daily status call with Client and Onsite co-coordinator.
Preparing Weekly status activity report for the project.
Environment: QC11, Excel Macro, Toad for Oracle 11, Windows XP
Title: Basel II Testing
Period: Nov 2010 – Feb 2011
Description: It is data warehouse EIP project and one of US’s largest bank which is implementing Basel II norms, in which Pillar 1 deals with maintaince of regulatory capital calculated for credit risk, operation risk and market risk. The second pillar deals with the regulatory response to the first pillar, giving regulators much improved 'tools' over those available to them under Basel I. Aim of Pillar 3 is to allow market discipline to operate by requiring lenders to publicly provide details of their risk management activities, risk rating processes and risk distributions. As there are different entities working for this bank, data is maintained in different format like excel, Mainframe, Oracle etc. Data from various source systems is transformed to staging database. At staging, data is formatted and arranged into different tables at SIF according to different types of products (Traded and Non- Traded assets) like Installment, Mortgage and Mitigant etc. From SIF to EDR, data is further divided into different work areas like Arrangement, Product. From BDW to EDXF, data is converted into flat file system; data from EDXF to Revelus is transformed to calculate various Basel II norms and generating various reports. At each layer data is extracted, transformed and loaded from source to target and has been tested for values, data types and length.
Responsibilities:
Creating and executing test cases manually or by running test cases using automation tool for various mappings assigned for different releases on different databases.
Updating various sheets like Estimation base sheet, Data profiling, Regression sheet, E2E balance sheet etc.
Input sheet creation for running Test cases by automation tool.
Developed automation tool to verify SQL at different database layers using VB script and Excel Macro.
Generating Automation test scripts using VB script and performing unit testing on those test scripts.
Worked at SIF Layer with different mappings and of different types of products like traded and non-traded assets.
Peer Review of Test cases and Test execution.
Logging and Tracking defects by using Mercury Quality Centre 9.0 Tool.
Used Toad for writing SQL queries of different transformation.
Created Excel report using ALM for monthly release report using VB script and Macro.
Environment: QC11, Excel Macro, Toad for Oracle 10
Yardi Software, India
Period: Sept 2008 – Oct 2010
Responsibilities:
Creating Issue report for various clients.
Verifying websites on different versions of software.
Verifying, Reporting and Creating Trouble Requests on various modules and builds.
Identifying Test Scenarios and Creating Test Plans and Test Scripts.
Working on different cases/Hotfixes for various accounts.
Conducting GAP analysis by comparing website with live site and creating reports.
Testing Templates as per the design checklist.
Verifying functionalities using Voyager software for Residential site (Online leasing/ Property Sites/Resident Portal) Commercial and Condo accounts on different builds and releases.
Verification of various themes on different test environment.
Creation of Checklist document for developer, designer and QA.
Involved in Build Verification Testing.
Assignment given to QA for various account testing.
Environment: ASP.Net, C#, Fiddler Tool, Windows XP, Excel, MS SQL Server 2005
Project Undertaken:
Title: Residential Portal
Description: Residential Portal categorized as:
Corporate Site: It includes features such as Property search, advanced search for property, Fusion map, Floor plans and Unit availability.
Property Site: It includes features such as Property Tours and Photo Galleries, Real-time Unit Availability, Floor Plans with Space Planning, HTML/Flash eBrochure, Local maps, Appointment Scheduling, Rental Applications with Credit check.
Residential Site: It includes features such as Online Rent payments (Credit cards /ACH), Lease renewals, Work Order tracking, Community Bullein board and Yard sale, Revenue Management, Reservation, Survey and CTM ETL.
Accounts Tested: Greystar, Korman, Nevins, HNN, Alliance, Transglobe, Trinity Residential, StarPoint, BRE and Harward.
Title: Condo Portal
Description: Condo portal effectively manages condominiums, Co-operatives and homeowner associations. It tracks changes of transfers scheduled charges and automatically calculates one-time charges. It tracks properties, units, and multiple owners per unit and monitors in progress purchases, tracks work order and inventory control with an integrated maintenance module.
Accounts Tested: REMS, AARS
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. Commercial Portal includes key features such as administration of leases and amendments, online reports on leasing, space management and recovery reconciliation.
Accounts Tested: Trinity SP6 Commercial, Arcadia.
Niche Software, India
Period: Nov 2007 - Aug 2008
Responsibilities:
To manage whole Test life cycle using Test Director.
Functional Testing, Regression Testing, Compatibility Testing, Usability Testing, Module Testing, Integration Testing, Performance Testing
Analytics (Report) Testing: Testing of Real-time generated reports by creating various Test Scenarios and verification of various reports created using different calculation.
To Coordinate with Business Developer for understanding functional requirements for creating Test Plans and Test Scenarios.
Mentoring Junior Test Engineers by giving them Product demo and assigning various assignments.
Preparing and Executing Test Cases using various methods of Black Box Testing as per Functional requirement document.
Creating Daily Functionality Status report (Enhancement/Customization).
Bug reporting and tracking by Mentis Tool.
Automating the functionality using QTP and creating Data driven Test Script and various checkpoints using QTP.
Involved in shortlisting resumes.
Environment: Mentis, QTP, Test Director, Asp.net
Project Undertaken:
Title: Juvlon, Email marketing Application
Description: It’s Product which is Email marketing and database management tool specialized in providing extensive reporting to network partners for conveniently tracking the progress and success of 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 mails sent.
Title: HSBC IFA, Web based application for maintaining transactions of ARN
Description: The objective of this project was to develop a web based application which will keep record of the transactions done by ARN’s of HSBC Mutual Fund, and generate a Scorecard of points they have earned on the net sales through the transaction they have done. This included creating a porthole for ARNS to view the loyalty points they have earned which can be downloaded/viewed on various resources according to the category they belong.
Almighty Software, India
Period: June 2007 - Sept 2007
Title: Fotopankki – Shopping Cart Website
Environment: PhpUnit2 Framework, CVS, PhpMyAdmin, Functionality Testing, Usability Testing, Compatibility Testing, MySql
Responsibility:
To initiate Unit Testing by using PhpUnit2 Framework (Automation Tool) and verifying functions of the classes.
To Identify Test Scenarios and prepare Test Cases.
White Box Testing (Unit Testing) using Phpunit2 Framework.
Functionality Testing, Usability Testing and Compatibility Testing.
To create Unit Test Reports, User/Usability Reports and User Guide.
To coordinate with Project Manager and Test Leads.