Chayan Mistry

Queens, NY

Contact: 347-***-**** Email: adkqg2@r.postjobfree.com

Status: U.S Citizen

Objective:

Over 10 + years of experience in Information Technology Industry with diversified experience in Software Testing of Client/Server and Web based Applications, seeking to work a position of IT Consultant /QA Test Engineer /Test Lead in an agency where my resourceful Technical/Academic skills and experience will add value to organizational operations.

Professional Summary:

Over 10 years of IT experience in Quality Assurance analysts and In-depth understanding of Software Development Life Cycle (SDLC) and different types of Methodologies such as Waterfall, Agile, Iterative.

Business area of expertise including Pension System, Investment Banking, Private Equity, Credit Ratings and Retails.

Ability to identify test objectives and use them to design and develop manual and automation test cases as appropriate to validate functionalities.

Experienced in effort estimation, writing Test plans, designing Test scenarios, Test cases, Test Scripts, preparing Test data, Test execution and defects logging, tracking, and reporting.

Hands on experience on conducting and managing Smoke, Functional, Integration, Regression, Load, Stress, and Performance testing in Sprint, SIT and UAT environments.

Experienced in test management tools – Quality Center (QC), Application Life Cycle Management (ALM),

Microsoft Team Foundation Server (TFS), Microsoft Test Manager (MTM).

Hands on experienced on Web Service testing.

Expertise in test Automation using QTP/UFT, Selenium WebDriver test automation tools.

Expertise in Web Service/API testing.

Experienced in writing SQL queries to perform Backend testing using SQL Server Management Studio, and TOAD.

Excellent communication and presentation skills, self-starter, and quick learner.

Proactively interacted with internal and external groups – Business User’s, Business Analysts, Developers and Project Management.

Ability to prioritize tasks along critical paths to meet project milestones and deliverable dates.

Experience in effectively training, leading, and working with cross functional teams to meet deadlines.

Education:

Bachelor of Science in Computer Science,

The City College, The City University of New York, New York – 2003

SQL Server DBA Trained-2014

Technical Skills:

Testing Tools:

TFS (Team Foundation Server), MTM (Microsoft Test Manager), HP ALM (Application Lifecycle Management), HP QC (Quality Center), HP Sprinter

Operating Systems:

Windows (XP, Vista, 7, 8, 10), Unix, Linux

Web Technologies:

Java, VBScript, Java Scripts, C++, XML, JSON

Databases:

Oracle (10g/11g), SQL Server, MySQL

Test Automation Tool:

HP Quick Test Professional (QTP), Unified Functional Testing (UFT),

Selenium WebDriver, SoapUI

Performance Testing tool:

LoadRunner

Other Office Tools:

Microsoft Word, Excel, PowerPoint, Outlook, Microsoft Office 365.

SharePoint, Confluence, Microsoft Teams, Lync, Skype for Business, MindAlign

Others:

PL/SQL developer, TOAD, PuTTY, Bugzilla, JIRA, VersionOne, GitHub, WinCVS,

IBM FileNet, FIX Version (4.0, 4.1, 4.2), Eclipse. Microsoft Dynamic CRM

Professional Experiences:

1)Teachers’ Retirement System of the City of New York - New York Jan 2019 – Present

Description: The Teacher’s Retirement System of the City of New York (TRSNYC) is a public pension fund that provides New York City teachers with retirement and death benefits.

Project: UPS/ASPEN Modernization

Role: Onsite QA Lead.

Responsibility:

Defining test strategy for complex legacy and modernization initiatives by reviewing and analyzing business requirements and design documents.

Developing test plans that define test scope, responsibilities, schedule, requirements, and objectives to ensure test coverage for quality products.

Designing test scenarios, test cases that include all conditions of functional changes made.

Managing and leading on-site and offshore testing team in test planning, effort estimations, tasks distribution and update, scheduling and coordinating issue resolutions.

Identifying and creating test data using Microsoft SQL Server Management Studio to execute test cases.

Executing SQL queries to perform Backend testing to ensure data validation, integrity, and consistency.

Performing Smoke/Sanity, Functional, Non-functional, Integration, Regression testing in Sprint QA, SIT and UAT environments.

Analyzing test results, identifying issues, and reporting to developers and Business Analysts.

Logging defects/issues and scheduling daily defect triage meetings during test execution and closely monitoring with developers to resolve.

Coordinating test execution status report with project management, development, Line of Business, vendors, and other internal departments.

Testing Web Services /XML/SOAP and RESTful services using SoapUI.

Validating WSDL, request and response XML, added assertion to validate response XML with Database.

Identifying regression testing scenarios and sharing with the Automation testing team to automate the scenarios.

Creating performance test plans to define approaches for performance testing

Creating performance testing Scripts using LoadRunner

Identifying bottleneck causing performance issue on the server and worked closely with development team to detect the root cause.

Providing production supports for post deployment activities.

Assisting QA Manager with testing assignments and reporting up to client management.

Software and Tools: Microsoft Test Manager (MTM), Team Foundation Server (TFS), SQL Server Management Studio, Oracle 11g, Java, XML, JMeter, IBM FileNet.

2)United Bank of Switzerland (UBS) - Stamford, CT Apr 2014 – Dec 2018

Project: A4: A4 Classic is a mission critical client server application responsible for connecting FIX(Client) and Order Management System (OMS) applications. It allows clients to connect with UBS and route orders, Allocations, confirmations to various stock exchanges.

Role: Onsite QA Lead

Responsibilities:

On-boarded FIX clients and certify Client Connectivity on various flow DMA/ALGO/CARE order for various products of multiple FIX versions – 4.0, 4.1, 4.2 and 4.4.

Created Cameron connections, client setup, applied different order routing rules from

A4 Classic and A4 FSA applications to flow orders as client requested

Logged into Unix server to verify Cameron and gateways connectivity heartbeat, logon, logout, and any error logs.

Created regional and interregional gateways and provided support

Analyzed Business, Functional and Technical requirements for upcoming releases and prepared effort estimation and test plan.

Created test scenarios, test cases and shared with Business Analysts for review for maximum test coverage.

Created Functional, System, Regression, and Integration test cases for QA, and UAT environments.

Proactively communicated with business, developers, and cross-functional teams.

Accountable for build deployment to QA and UAT environments.

Tracked test execution status through the release and took preventive actions to achieve targeted date.

Used HP ALM test management tool to design, develop and execute test cases

Developed automation test scripts using Selenium Web Driver, Java, Eclipse, TestNG framework.

Debugged and executed existing automation scripts using Selenium Web Driver, and shared reports to management team.

Worked on Microsoft Dynamic CRM software.

Performed back-end testing by inserting SQL queries to validate Data Integrity for Oracle database.

Used JIRA for defects logging, tracking and status reporting.

Scheduled defect status meetings daily during execution.

Software and Tools: HP ALM 11.00, UNIX, Oracle 11g, TOAD, JIRA, C++, C #, XML, FIX 4.0, 4.1,4.2 and 4.3.

3)Credit Suisse - New York, N.Y June 2012 – Mar 2014

Project: Cancel and Correct – Cancel and Correct Initiative to develop Securities system for effective supervision of post trade activities.

Role: Test Engineer

Responsibilities:

Worked with Business Analysts, Developers, and Management team to identify upcoming project deliverables and started project planning and effort estimations.

Analyzed Business Requirement documents, Function Requirement Document, and Rule’s specification documents for better understanding of upcoming features.

Prepared test plan, test scenarios and test cases to perform positive and negative testing of functionalities.

Prepared test data for positive and negative scenarios for business rules scripted in ETL.

Used HP ALM test management tool for test case design, test execution and Requirement Traceability Matrix.

Performed backend testing by using SQL queries to verify the integrity of Database.

Injected SQL queries and procedures to validate application functionalities.

Identified regression testing scenarios and developed test automation scripts.

Used GTAF framework to develop automation scripts for both GUI by using Quick Test professional (QTP) automation testing tool.

Updated existing automation scripts by adding new objects to the shared object repository.

Inserted different types of checkpoints to validate results and output values to capture runtime data into Data Table.

Executed automation test scripts after each release and shared test results with the management team.

Logged defects through HP ALM for tracking, report management and enhancements of testing

Involved in release planning, QA effort estimation for both manual and automation team.

Scheduled daily defect status and triage meetings daily during test execution.

Software and Tools:

HP Quality Center (QC), Quick Test professional (QTP), VB Scripts, Oracle, PL/SQL developer Tool, PuTTY, Windows SharePoint.

4)Standard & Poor’s (S&P Global) New York, N.Y Sep 2011 – May 2012

Project: Structured Finance– Residential Mortgage Backed Securities (RMBS) application is used to provide financial securities for worldwide mortgage companies.

Role: Test Engineer

Responsibilities:

Analyzed Functional Requirement documents, business requirement documents and design mockup for upcoming releases.

Worked closely with business to identify gaps to ensure documented business requirements are clear, consistent, and testable.

Participated PI planning, Sprint Planning, SCRUM meeting and Testing team status meeting as part of Agile Scrum Team Member.

Designed, developed, and executed functional / regression test cases to ensure the applications meets the intendent requirements and quality standards.

Performed different types of testing including (Sanity/Functional/Regression) in QA and UAT environments.

Maintained, executed, and validated test cases and test procedure for functional and non-functional testing.

Performed backend testing and data validation using SQL Queries and finding out bugs related to missing or incorrect data.

Interacted with the test team and other groups to identify, create, and maintain test data needed to execute test cases.

Executed regression testing automation suit using Quick Test Professional (QTP) and analyzed results and shared to QA Manager.

Provided detailed descriptions of the root cause of an issue/defects to Software Engineer/Developer and worked closely with them to resolve.

Documented the test result and presented daily and weekly status reports to the management team.

Software and tools:

HP Quality Center (QC), Quick Test professional (QTP), VB Scripts, Oracle, TOAD, VersionOne.

5)Travelocity - Southlake, TX Jun 2009 - Aug 2011

Project: Canadian Automobile Association (CAA) – CAA project is a web-based application that is used to manage vacation packages for their members.

Role: QA Analysts

Responsibilities:

Managed the entire QA process from beginning from application inception to data of product delivery including defining Test Objectives, designing Test Plan, and developing test cases are per business requirements documents.

Worked with different states of testing including Functional, System, Integration, Regression, and User Acceptance testing.

Extensively Used Quality Center to design, develop and execute test cases and generate test execution reports.

Reviewed test scenarios for completeness and work closely with Business, Developer and Leads.

Maintain Requirement Traceability Matrix (RTM) to establish traceability between requirements and test cases.

Developed and executed SQL queries to validate front end data with backend and manipulate data as needed to execute test cases.

Logged defect through Bugzilla for Defect tracking, Report management and enhancement of testing.

Worked closely with Business Analyst and developers for any reported issues/defects to resolve.

Ensured that all best practices and industries standards are followed.

Provided knowledge transfer to new joiners on their transition to business rules and procedures.

Performed cross browser testing and peer reviewed other team members’ work.

Attended daily Scrum meetings to update daily activities or issues to report.

Provided live support during production release.

Software and Tools:

HP Quality Center (QC), Bugzilla, TOAD, VersionOne.

Professional References:

Will be provided upon request.

Contact this candidate