Test Cases Data
Resume:
ALPA SHAH
************@*****.***
Skilled QA Test Lead /QA Tester/ Business Analyst possessing 15+ years of IT experience as a Software Quality Lead/ Tester for Client Server, and Web based applications and data warehousing large volume data applications with using ETL tools on Windows and UNIX platform. Manual testing by using Algorithmic reporting tool for Basel II regulatory reports using ALGO.Performed Manual and automated testing utilizing Quick Test Pro,Mercury Quality Center, Load Runner 7.5 and Test Director 7.0,Access,OWB (Oracle Warehouse Builder), Oracle 8i, IBM mainframe, COBOL, DB2, CICS, As/400, PL/SQL on Windows and UNIX platform. Experience working in Bank, Insurance (Annuities), Financial (Mortgage, Broker, Trading, Regulators), Retail brokerage, Retail banking, Accounting and Banking business sectors. Proficient in establishing QA Procedures, Standard methods and software requirement specification. Experienced in Integration, Performance, Regression, Functional, System, Navigational and Unit testing.
TECHNICAL SKILLS
Win Runner 7.5, Test Director 7.0, Load Runner 7.5, Quick Test pro (QTP), Mercury HP Quality Center, Test Partner 6.3, Unified Test Pro(UTP), Clear quest, JIRA, MS-Web Stress Tool, SPEG, CMM Questioner, Languages : Microsoft Visual Studio. NET, Microsoft Front Page 98 in/2000, Visual Interdev, VB.Net, VB 6.0, SQL, UML, C, C++, Java, PL/SQL,, DHTML, ASP, ASP.NET, VB Script, Java Script, Java, JSP and Servlets, Sql Navigator, Oracle Warehouse Builder, Oracle 8, IBM mainframe 3090, COBOL, DB2, CICS, IBM-MVS, IBM-VM/ESA, IMS DB/DC, JCL, IBM Debugger, Endeavor, Changeman, Task Manager, File Aid, CMIS, Expediter,MS Access, Agile, SCRUM,MS SQL server 2000, MS Word, MS EXCEL, MS PowerPoint, MS Projects, Visio, Basel II Credit Regulatory Reports, Management Reports, Algorithmic tool, RWA, Algo input database, ACRDB, Crystal Reports, SQR Reports, Oracle Discover, FIX Tags, UNIX, Linux, Sun Solaris 8.0, MS-DOS and MS-Windows 95/98, Windows NT 4.0/2000/XP, IBM, PC Compatibles.
PROFESSIONAL EXPERIENCE
BNP PARIBAS Sept 2015 – May 2017
Sr. QA Tester
Liquidity Management (Balance sheets) & 5G
BNP Paribas is an IHC company which reports basic financial data on a consolidated basis in the form of different Balance sheets. Triton is a front end tool which used to generate all different balance sheets (Ex: Seccorp BS, Prime brokerage, ALMT, CB BS etc..) and each balance sheet contains data for different products. Triton provide a Liquidity balance sheet of the legal entities in the US including branches of BNP.There are separate Balance sheets which contains all 5G and US LCR data across all products which mainly developed as a part of regulatory reporting requirement (5G and US LCR). There are different HQLA Collateral reports which contains collateral data. Each BS provides assets and liabilities data.
Participated in all cycles of test life cycle from test planning, Creating test cases to defect tracking and managing defect life cycle.
Tested all different Balancesheets fields display by different legal entities in Triton front end tool.
Validating Assets and liabities amounts for each different legal entities. Tested more granular transactional data across different products in each different BS in Triton front end tool.
For each different line of business tested and verified 5G data by different 5G product group in Triton.
SIERRA and SERENO are referential systems which gives details of all securities. In Triton for each ISIN compared data (HQLA LEVEL etc..) with SIERRA and SERENO systems.
There is a separate BS CUSO which contains all 5G data which required regulatory reporting req. Tested BS in detail for all 5G fields, rules and data. Mainly 10 5G tables data verified which are Inflow Assets, Inflow Unsecured, Inflow secured, Inflow other, Outflow deposits, Outflow wholesale, Outflow secured, Outflow other, Supplemental informational, Supplemental FX and comments in Oracle database.
Tested cash different maturity buckets and other data for 5G.
Verified and validated data for HQLA Collateral report which mainly contains all collateral amounts compared with different Balance sheets,
Interacted with Business Analysts, Developers, Other team members, and Project Managers during all phases Prior and after QA phase.
Provided Test Estimates for various phases of the project
Performed extensive Web Application Testing. Functional Testing, Integration Testing, Unit Testing, Regression Testing, System testing and Negative testing.
Troubleshoot issues in UAT & QA and perform root cause analysis of issue on hand before passing issues to developer team
QA lead for the entire project responsible in planning and delivering all different releases.
Created and Reviewed detailed Test plan, Test cases/Test scenarios for Manual Testing
Used HP Quality Center as a test management tool for documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.
Analyzed and Evaluated the Business Requirement Documents, Functional/System Requirement Documents and Use Cases for the application, which involved a series of meetings with developers, and Business Analysts to verify the testability and verifiability of the requirements and documented test Plan and test cases using Quality Center.
Performed Component Integration, Regression and End to End testing to ensure readiness for user acceptance testing.
Involved in ALL review meetings and walk through.
Participated in Walkthrough and Periodic Meetings with Business team and Development team leads to coordinate, resolve and schedule testing efforts.
Responsible to support and co-ordinate during UAT (User Acceptance Test) with users and technology team
performed performance testing by using Load runner for more than 200 users and application developed on Java.
Involved in backend database testing using different SQL queries for multiple databases
Scheduled and Conduced End-to-End Test in QA & UAT with all the systems and users affected by the different releases before go to Production.
Having meeting with BA to understand business requirements, getting deadline updates of development, discussing QA issues and decide priority based on users needs.
Created and maintained the defect reports for each release, if deadline is near mark priorities of defects after having meeting with users, and update status of issues after verifying fix made by developers.
Produced and managed QA deliverables through formal Project Plans
Environment: Oracle 11.2.0 database, Triton Front end reporting tool, HP Quality Center, Toad, Lotus Notes, MS Excel, Java, JSP, XML, Web logic, EJB, Servlet, JavaScript, QTP, Load runner.
JPMorgan Chase March 2014 – Jul 2015
QA Lead/Sr. QA Tester
CFG(Cash Flow Generator)
Cash Flow Generator(CFG) is a part of LRI(Liquidity Risk Infrastrcuture) project which is web based front end and backend system for cash flow calculation which provides the capability to generate cash or security flow buckets as needed for Regulatory reporting(Basel, LCR,4G,US LCR etc.).Worked in the project, CFG expand the scope to produce non contractual cash flows through a set of vectors(Percentages) applied by LOBs/GT for deposits,commitments,derivatives,securedfinancing,debtbuyback,Collateral,Loans, Borrowings and other products.NCCF was mainly requirement for US LCR reporting.
Participated in all cycles of test life cycle from test plannin1.
g, Creating test cases to defect tracking and managing defect life cycle.
Backend database Oracle used for writing different SQL queries to ensuring data coming properly in database from GUI.
Validating cash flow calculation by writing different SQL queries for each product by given vectors and based on different business rules.
Responsible for entire NCCF UI(User interface) web based testing for all different products. Tested all vectors details applied corrected by given LOB/GT for each product.
Interacted with Business Analysts, Developers, Other team members, and Project Managers during all phases Prior and after QA phase.
Provided Test Estimates for various phases of the project
Performed extensive Web Application Testing. Functional Testing, Integration Testing, Unit Testing, Regression Testing, System testing and Negative testing.
Troubleshoot issues in production, UAT & QA and perform root cause analysis of issue on hand before passing issues to developer team
QA lead for the entire project responsible in planning and delivering all different releases.
Created and Reviewed detailed Test plan, Test cases/Test scenarios for Manual Testing
Used HP Quality Center as a test management tool for documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.
Analyzed and Evaluated the Business Requirement Documents, Functional/System Requirement Documents and Use Cases for the application, which involved a series of meetings with developers, and Business Analysts to verify the testability and verifiability of the requirements and documented test Plan and test cases using Quality Center.
Performed Component Integration, Regression and End to End testing to ensure readiness for user acceptance testing.
performed load and performance testing for java based application using load runner.
As a QA Lead took initiative for giving training to users, actively testing with users in UAT phase, proactively solve issues in Production, Co-ordination with Project manager and developers to fix issues on time and get system back after regression testing.
Chair the Application level Daily QA meeting to discuss project updates, defects, design gaps, brainstorm possible solutions.
Involved in ALL review meetings and walk through.
Participated in Walkthrough and Periodic Meetings with Business team and Development team leads to coordinate, resolve and schedule testing efforts.
Performed manual testing for NCCF web based application. Ensured all UI functionality by positive testing and negative testing.
Responsible to support and co-ordinate during UAT (User Acceptance Test) with users and technology team
Involved in backend database testing using different SQL queries for multiple databases
Scheduled and Conduced End-to-End Test in QA & UAT with all the systems and users affected by the different releases before go to Production.
Having meeting with BA to understand business requirements, getting deadline updates of development, discussing QA issues and decide priority based on users needs.
Created and maintained the defect reports for each release, if deadline is near mark priorities of defects after having meeting with users, and update status of issues after verifying fix made by developers.
Produced and managed QA deliverables through formal Project Plans
Worked with different team of testers involved in multiple projects and get delivery for QA on time.
Environment: Oracle 11.2.0 database, Aggregation Engine, Cognos reporting tool, HTML5, Apache, Tomcat, HP Quality Center, Toad, Lotus Notes, Ms Excel, Java, JSP, XML, Web logic, EJB, Servlet, JavaScript, QTP, Load runner.
NYSE (New York Stock Exchange) Oct 2012 – Feb 2014
Sr. QA Tester
NYSE UTP Options Trading System
ArcaEx is a current trading system which NYSE uses for options trading(AMEX and ARCA Exchanges) which supports all of the Order Types. NYSE Arca is a Order driven model using FIX protocol tags with straight price time priority and a fast routing to external markets. This system supports end to end trading platform for orders management and Trade management. It utilize existing structure which includes Navigator front end,TTconnect gateways (CustomeFirms Connectivity), Matching Engine(UX Trade process),OX_Router, Trade and Quote reporting(Quote and OPRA server). ARCAbook (customers get all info from ARCAbook) etc..
Participated in all cycles of test life cycle from test planning to defect tracking and managing defect life cycle.
Used Navigator front end for creating & managing test suits, test cases, Executing & verifying test cases, Checking Test results etc.
Defects were tracked, reviewed, analyzed and comp
ared using Team Tracker tool.
Different set of test cases for different order types verified by FIX tag values with proper sequence for each FIX tag before executing and after executing cases.
Testing application FIX messages like logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages.
Read and understand the FIX log file and to interpret format and different tag combinations.
Used Arcadirect Test tool for manually creating orders & sending quotes for Arcadirect(gccg) gateway Quote take down, Risk Mitigation etc.. for MM direct gateways.
For each test cases in book board ex: for different orders verify Buy order values, sell order values for MM, LMM, Customer or Firm etc.. also away market values and verify NBBO is updating properly.
Verified different orders details on view orders screen by checking orders got filled, rejected, executed, cancelled for each order id. Same way different trade details for all orders verified on view trades screen.
Extensively used Unix for verifying gateway and matching engine logs for verifying order & trade details for different FIX tag values by making sure first each FIX sequence order details in gateway and ME logs and at last in Navigator final result data comes properly.
Verified Orders Routed properly to different exchanges like BOX, ISX, ASE and finally NBBO update proper values based on other exchange values.
Tested orders and trade details for different order types of Options for different markets AMEX and ARCA.
Created and updated test cases for separate module Security enhancement only for gateways security data.
Scheduled and Conduced End-to-End Test in QA & UAT with all the systems and users affected by the different releases before go to Production.
Created and maintained the defect reports for each release, if deadline is near mark priorities of defects after having meeting with users, and update status of issues after verifying fix made by developers.
Environment: Navigator, Arcadirect Test Tool, TT connect gateway, GTM(Global Trade Management), Quote Web Ops, Java, SQL developer, Oracle, Windows 7,, Ms Excel, Windows NT, Unix, FIX Protocol 4.0.
FINRA (The Financial Industry Regulatory Authority) Feb 2012 – Sep 2012
Sr. QA Tester
FINRA Integration
FINRA Integration project is basically migration of the NYSE and ARCA surveillances (Options and Equities) to the FINRA environment. This testing will ensure that all components of patterns(Violation of Rules) run successfully when migrated to the FINRA. A parallel testing approach used for all patterns, NYSE PROD reports compared to FINRA reports side by side for markets AMEX and ARCA. Using different trade dates and months. All reports from NYSE platform and from FINRA environment generated daily (EGR) as well as monthly (AGR).
Participated in all cycles of test life cycle from test planning to defect tracking and managing defect life cycle.
Involved coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalations.
Defects were tracked, reviewed, analyzed and compared using Quality Center.
Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline
Created Test cases, stored result of executed test cases & updated test cases along with Master test plan using a Quality center.
Troubleshoot issues in production, UAT & QA and perform root cause analysis of issue on hand before passing issues to developer team.
NYSE and FINRA reports data tested in database for each options pattern by writing multiple SQL queries using different databases.
Designed tests using Keyword driven methodology for selected areas using QTP.
Each keyword file (Automation scripts) written with different logic based on functionality then executed and run properly with proper debugging scripts using QTP..
Tested data for different patterns of Options and equities for different markets AMEX and ARCA using Microsoft Excel.
Scheduled and Conduced End-to-End Test in QA & UAT with all the systems and users affected by the different releases before go to Production.
Responsible to support and co-ordinate during UAT (User Acceptance Test) with users and technology team.
Involved in backend database testing using different SQL queries for multiple databases.
Produced and managed QA deliverables through formal Project Plans
Helped business users for testing reports for different patterns in User Acceptance testing.
Involved giving answers to business users, Project manager, Business analyst for all their questions related to test data, testing approach, test results for different patterns.
Had written TSR(Test Summary report) for each pattern separately. TSR contains detailed scope of testing, approach, defect summary, review information, risk summary and recommendation for each pattern.
Environment: Mercury Quality Center 10.0, SQL developer, Oracle, Windows 7, Lotus Notes, Ms Excel, Windows NT, Unix.
Federal Reserve Bank of New York Sep 2011-Jan 2012
Sr. QA Tester
Oracle 11 G Funds and Securities project
Oracle 11 G is a project basically to transfer all current applications data from IBM to Oracle 11 G platform.There are so many various application like FLA Funds, FLA securities, Fedwire funds,NSS,CI Funds, Customer Inquiries etc.. all applications are GUI based front end applications. The purpose of testing is to test functionality by writing automation scripts for all pages/each application using database and MQ messages.
All valid scenarios for different pages for each application has been written in keyword files by automation scripts using UTP and Test Partner.
All defects entered and tracked, Defects link with proper test cases and after regression testing all defects updated using Quality Center.
Performed functional Testing, Integration Testing, Unit Testing, Regression Testing, system testing and Negative testing.
Designed tests using Keyword driven methodology for selected areas using QTP.
Each keyword file (Automation scripts) written with different logic based on functionality then executed and run properly with proper debugging scripts using QTP..
Backend database SQL server used for writing different SQL queries to see data from different databases to make sure data populating correctly in GUI from database.
Involved in Windows 7 testing for different applications for Funds and securities by doing manual testing only.
Test cases created and executed test cases, test results stored in Quality Center.
Created Test Strategy, Test Plan documents, Test cases, Issues tracking document.
Test data has been created and tested for different products of funds and securities.
Worked with different team of testers involved in multiple projects and get delivery for QA on time.
Environment: UTP(Unified Test Pro), Test Partner 6.3, Quality Center, Quick Test Pro(QTP), Microsoft SQL server 2000, Oracle, Windows 7, Lotus Notes, MQ messages, Ms Excel, Windows NT, Load runner, IBM, DB2, Java, JSP, XML, Web logic, EJB, Servlet, JavaScript.
Prudential Bache Commodities Oct 2009-Jun 2011
QA Lead/ Sr. QA Tester
BacheConnect
BacheConnect is a web based Front end Electronic trading platform for Futures, Options and Spreads.It offer a variety of ways to create,submit, modify and cancel trades.Application includes stand alone floating trade tickets, Trade tickets integrated into Quote Window, Order Blotter window and Price ladder. There are different blotters screens for Orders, Position tracking and filled orders.(Fill blotter).To maintain historical orders there is a separate Audit trail.This system supported trading for native orders as well as synthetic orders. There is other system FIX 4.2 message format for executing Futures and Options on Futures trades through ‘FIX’ engine.
Tested orders created and placed properly into the integrated trade ticket and Floating trade tickets.
Tested data into Orders blotter for different orders like Hold orders, Working orders, Filled orders, Cancelled orders and modified orders.
Set up testing environment, Created Test Strategy, Test Plan documents, Test cases, Issues tracking document after reviewing BRD.
Created Test plan, Test cases and execution of test cases using Quality Center.
Created Test cases, stored result of executed test cases in test results using a Quality center.
Issues have been placed, tracked and regression testing fixes tracked using Quality center.
Tested data for different products of Futures, Options and different spreads for different exchanges.
Tested all Front end screens like Quote window, Price ladder, Order blotter, Integrated trade ticket, Floating trade ticket, Quote window, Price ladder, Fill Blotter, Position blotter, Historical search screen and Audit trail based on BRD.
Issues has been placed and tracked by issues tracking system JIRA.
Worked with Offshore team of developers (Tradehalm) from Chicago to discuss issues and get delivery for QA.
Environment: Manual testing, FIX 4.2 Engine, JIRA, Lotus Notes, Ms Excel, Load runner, Windows NT. Java, JSP, Mercury Quality Center, XML, Web logic, EJB, Servlet, JavaScript,Oracle 8.0.
Northern Trust Bank Sep 2008-Oct 2009
QA Lead/ Sr. QA Tester
Basel II Regulatory Capital Reporting project
The scope of this project is focused on Basel II Pillar 1 – Minimum capital requirements and related Regulatory Reporting. In terms of calculation methodology, the focus would be on the Credit Risk mitigation. Mainly focus on different products like Credit derivatives (Credit default swap, Total return swap), Repo, Fixed Income. Retail brokerage products like Mortgages, Loans etc. much risk is involved for different products
Set up testing environment, Created Test Strategy, Test Plan documents, Test cases, Issues Tracking document, Requirement traceability matrix after reviewing BRD, URS and technical specification.
Highly involved in backend testing writing SQL queries for Data warehousing for almost 34 source systems of Northern.
Verified all tables (Northern data) in Data Warehouse. This is a final area where data loaded from staging to Warehouse dimensions and Facts
Tested Data integration, data migration, data mapping and data transformation for testing ETL process.
Task allocation, monitoring & successful completion within the team.
Worked as ETL Testers responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project for large amount of data.
Involved in data migration, data integration, data mapping, transformation of data using by using oracle warehouse builder by ETL process.
Worked closely with credit risk department and finance department to verify test results with business data.
Verified dimensional data modeling while testing data warehousing by ETL process.
Tested different Credit derivatives products like Credit default swap, Total return swap etc and Fixed Income products based on different business logic.
Verify results of all Basel II regulatory reports (Schedule A through Schedule R) based on Pillar 1 requirement.
Coordinating and leading teams of testers for multiple projects.
Managed offshore of up to nine staff. Coordinated efforts between onshore and offshore groups.
Worked with Offshore team of developers to discuss issues and get delivery for QA.
Created and maintained the defect reports for each release, if deadline is near mark priorities of defects after having meeting with users, and update status of issues after verifying fix made by developers.
Written and execute basic UNIX commands and scripts on UNIX editor.
Provided Test Estimates for various phases of the project.
Environment: Algorithmic Credit Regulatory Capital Solution, Todd, Oracle Warehouse builder, Oracle,Sql Navigator, AlGO Input database, Quick Test Pro, Risk Watch Engine (RWA), ACRDB database, Lotus Domino, Lotus Notes, Ms Excel, Windows NT. Unix(Sun Solaris 8.0), Java, JSP, XML, Web logic, EJB, Servlet, JavaScript.
Prudential Financials Mar 04 - Sep 08
Sr. QA Tester
SAAS/ Territory Management/ Epiphany Contact Mgmt System
The Integration of Prudential and American Scandia Organization necessitates a system for the sales organization that provides and integrated view of appropriate and related data for strategic and business. Worked with Insurance department, other departments of Annuities and Insurance.
Reviewed Business Requirement Document (BRD), URS, and Technical Specifications and wrote Test Scripts for the UAT.
Conducted the database testing of application by writing SQL Queries utilizing Oracle Warehouse Builder.
Verified staging area which is Data Transformation. Addition tables, merging of data for publishing to the Data Warehouse.
Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
Verified ETL Data Warehousing, database testing for Workflow process.
Verified all tables in Data Warehouse. This is a final area where data loaded from staging to Warehouse dimensions and Facts
Performed data integrity testing by executing SQL Queries in Oracle database by using OWB by ETL.
Implemented all relational tables in SQL and writing queries for checking multiple sets of data utilizing Oracle Warehouse Builder and Microsoft Excel for validation of Data.
Created and tested Data migration scripts for data comparison between legacy (Spike) system and Epiphany.
All different objects properties has been tested using a different checkpoints to verify a expected result with a actual result using a different checkpoints like Text, Page, Data table, Standard checkpoints in QTP.
Verified data finally in SAAS Warehouse which comes from Sales admin database.
Tested reports utilizing Oracle Discover. Reports developed from SAAS Warehouse utilizing different tables according to business requirements.
Implemented relational tables in SQL and wrote queries for checking multiple sets of data utilizing Oracle Warehouse Builder.
Environment: Oracle 8.0, Oracle Warehouse Builder, OLAP,ETL, Oracle Discover, SQL, UNIX, Windows NT, Oracle Discover, Quick Test Pro(QTP), Ms Excel, Test Director,Quality center, Load runner, Agile, SCRUM, TOAD, ASP.Net, Visual Basic, C#, SOAPUI, SOATest Visual source safe, VB Script, QTP, Quality Center, JavaScript, COM/DCOM.
Tullet Liberty Jun 02 to Feb 04
Sr. QA Tester
The OTC marker is Front office electronic trading system intended for the use of Tullet and Tokyo Liberty Inc. (T&TL) a leading Wall Street based brokerage and trading firm, and their external brokers. It is a flexible system that not only caters for trading many financial instruments but also provides easy expansion to new products like Credit Derivatives, Medium term Swaps, IR Swaps, Money Markets, FRAs, Swaptions, Hedge funds, Bonds, Futures, Repos and other derivative instruments, Interest Rate Swaps (for US markets and Sterling markets), Money Markets (For Euro Dollar Products) are in production.Worked with Exchange Traded Funds,. Mutual Fund, Fixed Income etc and Retail brokerage products.
Created and reviewed the documents like Test Cases and Test Plan Test Scripts. Training the Users how to use the tracking system and the Life cycle of the Defects in the Tracking System during the Project Life Cycle.
Performed extensive Web Application Testing. Functional Testing, Integration Testing, Unit Testing, Stress and Load Testing, Regression Testing, System testing and Negative testing.
Madhuban Securities Oct 97-May 02
Gujarat, India
Project Title: ITrade
EDUCATION
Bachelor in Engineering Computer Science Sardar Patel University, Gujarat, India. Microsoft Certified Professional
Contact this candidate