PROFESSIONAL SUMMARY

* ***** ** ******* ********** in the field of IT with focus on QA and testing in all phases of SDLC and STLC including Analysis, Design, Development and Quality Assurance in manual and automation testing of Client/Server, Web Applications, Mainframe and Backend Testing.

Strong knowledge in various domains like Banking & Finance, Investment Banking, e-Commerce, Tele communications, Insurance and Health Care.

Working Experience in various testing lifecycle Methodologies such as V-Model, RUP, XP, Agile/Scrum and Waterfall and was also engaged in Sprint Planning Meeting, Scrum, Sprint Review and Retrospective Meetings.

Expertise in working with manual testing process and creation of automation environment by using UFT/QTP, Load runner, ALM, Emprix Tools, Rational Suite.

Hands on experience in Selenium Web Automation using Java.

Proficient at understanding Business Requirement Specifications, Functional Specifications and Design documentations and transforming them into Test Scenarios.

Performed effort estimation and tracked them during Project Management.

Provide expertise in preparing the test plan, test cases, Test scenarios creation from use-cases and test data based on the business requirements and the design documents

Experience in Test strategy design based on the various types of testing including Unit Testing, Integration Testing, Functional Testing, System Testing, Usability (UI) Testing, End to End Testing, Security Testing, load Testing, stress Testing, capacity Testing and Performance testing.

Hands on Experience in mapping all the Requirements with the test cases using Requirement traceability matrixExperience in developing the test suites for regression testing across multiple builds and releases.

Experience in maintaining different test environments (e.g., data loads, backup of database, requesting deployments, restarting servers, troubleshooting of issues).

Actively Involved with clients for Quality discussions and test deliverables,

Involved in PMO meetings, and Project management calls, Status reporting to management, issue escalations.

Conducted Daily stand up calls and technical walk-through with the teams.

Ability to work productively in a team as Well as individually, Problem solving skills with all management levels, good Leadership skills.

Experience in end to end testing and back-end testing in Oracle and MS-SQL Server

Experience in executing SQL queries in order to view successful transaction of data and for data validation.

Good experience in testing process documentation using MS-Office including Excel, Word, and MS-Project.

Working experience in monitoring ETL batch jobs during system, integration and acceptance test runs with Data stage.

Conducted weekly status meetings with Project managers to discuss Projects status and related I implementation plan for production releases.

Working experience using automation frame work in performance testing and functional testing.

Knowledge of Software Quality Assurance, ISO and CMM levels. Good analytical and communication skills and ability to work independently with minimal supervision and also perform as part of a team.

PROFESSIONAL EXPERIENCE

Client: American Express, Toronto, ON

Sr. QA Analyst

Apr 2019 - Current

Description:

Amex Applications are moving from the AS400 COBOL Applications to ETL (Extract Transform Load). The testing of the applications moved from the AS400 Platform to ETL should be completed. This is carried out by processing the same input file with the AS400 and ETL tool and comparing the output. The output should match as per the specifications in the AS400 and the ETL applications. Also check the AS400 DB2 data base content with ETL Oracle database for master tables loads and historical data of transactions.

Responsibilities:

Developed test plans and design specification for test cases to Ensure consistency and testability.

Collaborate with Development team to work on Test Plan and Creating the test cases for ETL testing using HPALM

Mapping of test case with requirements for Traceability using HP-ALM

Generate the Output files through AS400 Applications using specified input file.

Running the Unix Scripts based on the Text matrix through Putty for data loading into Database

Checking Log Files through Data stage director, execution and validating of Oracle database as per the specification using SQL query.

Using third party tool ‘Beyond Compare’ to compare files.

Documenting the defects in the Quality center and communicating with development team.

Responsible for Batch jobs execution and test data population

Worked closely with Developers and Business Analyst to understand the application architecture.

Participated in all stages of Software Development Life cycle (SDLC) and Software testing life cycle (STLC).

Participated in all stages of Test-Driven Development methodologies, using Waterfall, Agile methodologies.

Participated in estimation using Poker planning.

Experience in Web-Services and Testing using SOAP UI and generating XML Files for messaging.

Knowledge of API testing with SOAPUI tool, enhancement of Test harness and developing of multiple Test suites using XML and JSON.

Working on SOAP/REST services using SOAP UI, Groovy Script for testing the services.

Experience in data driven testing, used JDBC and Groovy script as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.

Generate Daily/Weekly status Report with test metrics by using Quality center and reported to project Stakeholders.

Setup weekly status meetings with Project team to discuss the Project status, and circulated the MOM to participants.

Generate and communicated the Bug reports to project team using ALM.

Preparing and sharing the Test closure Reports, UAT sign off to End Users.

Participated in Implementation plan for production.

Environment:

AS/400, Oracle, UNIX, Putty, ALM, IBM Mainframe, Data Stage, UDB-DB2, Quest, MS – Excel, Share Point, Beyond Compare, MPP, Jenkins, SOAP UI, Python, Maven, TestNG, JIRA, Eclipse, XPATH, Java, SQL Server, JMeter, Junit, TestNG

Canadian Western Bank, Calgary, AL

Sr. QA Analyst

Sep 2018 – Mar 2019

Description:

Canadian Western Bank is one of Canada’s largest banking and mortgage institutions. Over the last year, they have expanded significantly into the retail banking division with very compelling products and services. Part of the retail banking success is in providing the customers with ability to bank using the internet. The bank has many other divisions like the home loans, consumer loans, etc., which all has its own application being developed and tested. Each division has many modules such as servicing, bill pay, credit card, Transfers, etc. to facilitate the user for a comfort banking experience.

Responsibilities:

Attend the project kickoff meetings to understand the requirement and gathered scope of work.

Creating the Test Plan/Test Cases/Test Strategy documents.

Directly worked with project teams for the Review the Test execution.

Executing the existing Load Runner scripts/data pool for creating and parameterization. Correlations done by in both Manual/Auto

Testing of Load Runner scenarios/Performance Testing/Load Testing/Stress Testing.

Responsible for validating the test using SQL Queries on RDBMS for Back-end testing.

Working with system administrators and functional contacts to resolve Performance issues

Investigate the load test results and finding the Bottleneck

Compared the test result with previous successful test, along with resource utilizations.

Suggestions to development team for tuning the application based upon the Load test results.

Preparation the final test Report and submit to the Project team.

Reported and assigned the bug to dev team through Quality Center.

Generate the test coverage report by using QC after verified defects fixed by retesting and closing it in Quality Center.

Environment:

Windows, IE, Netscape, Oracle, C, ASP, .Net, VB script, IBM Web Sphere, XML, Load Runner, Toad, ALM, Share point

Desjardins Insurance, Calgary, AL

Software Tester

Aug 2017 – Aug 2018

Desjardins is one of the leading Health Insurance Company in Canada. CDH application is for processing of patient claims. This application will receive the information about claim (patient History) from hospital management system in the form of HL7 messages with the help of JMS messaging system and the CDH will process the claim. One of the main modules in the application is the electronic billing system (EDI). I was involved for production test Track. This track will identify the Defects that are running in Production after release.

Responsibilities:

Involved in gathering the Business Requirement and analysis the System specification and use cases in the initial phase of development.

Understand the Business Requirements Document (BRD) and prepared the Test Cases, Test Script based upon the requirement.

Created test cases to test Functionality and interface of the application.

Testing of different modules of the application with Manual and Automation Testing.

Testing of HL7Standards code sets and HIPAA Transactions.

Managed all the Tests in Quality Center.

Written multiple SQL Queries to retrieve the data from various Tables

Generate and reported bugs by using Quality Center.

Environment:

Rational Robot, Clear Quest, Rational Manager, VB, ASP, SQL, Oracle and Windows.

Laurentian Bank of Canada, Calgary, AL

Sr. QA Analyst

May 2015 – Jul 2017

State Street Enterprise Portfolio Record Keeping System is a complex portfolio Asset management system that records and accounts for all investments in an investment portfolio, and interfaces with other systems for data entry and data export. RKS needs to define information about security issuers and issues before enter transactions. After entering in to the transactions that are linked to security master file (SMF) records that contain security level information such as maturity date and coupon rate. Once enter transactions that establish the security positions within the user portfolio. Once investment positions exist on the RKS, we can view, report on, and analyze position and transaction information. The RKS system has a Several Systems like Information, operations, Admin, IL bonds, view, report, security master, reference tables, compliance setup, etc. subsystems.

Responsibilities:

Involved in gather the Business requirement

Create test cases, design test scenarios, test steps and mapped scenarios for Traceability matrix using Quality Center.

Generate the issues for common stock and purchase transaction for fixed income before executing test cases.

Involved in Data setup before executing the test cases for Manager, Broker, Bank, Portfolio, Bank Account set up (Cash Accounts, Custody Accounts), Portfolio with Bank Relationship, base rate names and Base rates.

Execute the all test case as per order.

Actual Results is compared with the Expected to ensure the correct output.

Calculated Inflation ratio manually through formula and compared with system generated output

Performing Functionality and GUI Testing.

Directly worked with Functional people and Development team to ensure overall quality and performance.

Interacting with offshore team and communicate the testing Progress to project team.

Logging the Defects in the Quality Center and submitting the Reports (Pie, Graph Charts) and up to date overall graphs Iteration wise.

Verified the integrity of the database by performed Backend testing with extensively using SQL queries.

Performed Backend Testing by using TOAD.

Conducted Regression testing when new builds was deployed.

Involved in weekly meetings and walkthroughs with the project team.

Worked and Supported many project releases with tight schedules, also worked on weekends and nights to support various deployment testing

Created the UNIX Shell Scripts and executed them to analyze the server logs.

Tracked and logged all defects in Quality Center

Handling and updating the testing documents in Quality Center.

Environment:

C++, SQL server 2000, SQL, Quality Center 8.0, VSS, UNIX, TOAD and Windows

FINRA, Toronto, ON

QC Tester

Sep 2012 – Apr 2014

The Financial Industry Regulatory Authority (FINRA), is the largest non-governmental regulator for all securities firms doing business in the United States. FINRA touches virtually every aspect of the securities business from registering and educating industry participants to examining securities firms; writing rules; enforcing those rules and the federal securities laws; informing and educating the investing public; providing trade reporting and other industry utilities; and administering the largest dispute resolution forum for investors and registered firms. It also performs market regulation under contract for The NASDAQ Stock Market, the American Stock Exchange, the International Securities Exchange and the Chicago Climate Exchange. FINRA maintains the qualification, employment and disclosure histories of the more than half a million registered securities employees of member firms through the automated Web CRD system. Web EFT is a secure, state-of-the-art electronic file transfer application that eliminates the need for firms to manually submit online form filings to Web CRD.

Responsibilities:

Analyze and understand the Business Requirement and Change Requirement documents in DOORS and VS. Created and performed the test cases in DOORS and analyzed the results.

To check the various functionalities of application WEBCRD by performed the Manual Testing.

Conducted some Automation Testing of the Application for regression test using UFT.

Virtual Source Safe was used to check in/check out/view various testing documents, automation test results, CR forms and design documents.

To view and analyze the Backend data in the Database by execution of SQL queries using TOAD.

Capture, log defect and track bugs using Merant Tracker and coordinated with developer to make sure the bugs were fixed and closed

Responsible for documenting the test results in DOORS and Tracker

Using the WEBEFT application upload and process the XML files, modifying XML files using XML Spy and verifying the filings processed.

Participated in doing regression testing of the application to make sure the new requirements did not impact the existing functionalities of the application.

Conducting walkthrough, daily status and Weekly status meetings.

Environments:

TOAD, Oracle 10g, UFT, Merant Tracker 8.0, teleologic DOORS, Virtual Source Safe, XMLSpy

Education: Bachelor of Science from (Rajasthan university) India. 2011

Neetika Bhardwaj

Email: adiw0k@r.postjobfree.com

Phone: +1-437-***-****

Contact this candidate