NAMRATA CHANDRA

Cell: 862-***-****

Email:ac3zyf@r.postjobfree.com

Address: **** **** ***** *********, *************, PA

Summary:

An IT Professional with 6 years of experience in Quality Assurance and Testing. In depth knowledge of Software development life cycle, testing methodologies of Client/Server and Web Based applications. Focus includes Software Testing, design analysis, unit testing, System Integration Testing (SIT), User Acceptance Testing (UAT), performance and regression testing.

A creative and professional team player with diverse experience in all phases of the SDLC.

Strong experience in developing Test cases, test procedures and test scripts using requirements and design documents.

Generating and implementing templates for Test Strategy, Business Analysis, Gap Analysis, Test Defect Log, Test Case Checklist etc.

Extensive experience in different testing methods like System Testing, GUI Testing, Functional Testing, Integration Testing, Cross Browser Testing, Positive & Negative Testing, End to End Regression Testing, Web application testing, Database Testing and Performance testing.

Experience in SQL for various databases like SQL Server, Oracle, DB2 and conducted backend testing for the DB by writing extensive SQL queries to test the data integrity of the application and databases.

Excellent knowledge about QA Methodologies implementing industry standards to ensure robust functionality.

Proficient in conversion testing and data mapping from source to target tables.

Experienced in various quality assurance methodologies such as Waterfall methodology, Agile methodology etc.

Proficient in Quality Assurance (QA), testing using automated test tools such as Selenium IDE, Fire Bug and Xpath.

Experience in various tools like QC, JIRA and JAMA.

Experience in testing web services using SOAP UI.

Conducted cross browser testing using Browser Shots.

Experienced in conducting Functional, Manual, White Box and Black Box Testing.

Technical Skills:

Testing Tools

SOAP UI, Selenium IDE

Languages & Development tools

JAVA, HTML, Eclipse IDE, SQL Developer

Web Debugging Tool

XPath, Firebug, SOAP UI

Processes

Agile -Scrum, Waterfall

Bug Tracking Tools

JIRA, Quality Center (QC), Version One

Source Version Control Tool

SVN,GITHUB

Application

Microsoft Office, Excel, PowerPoint, Outlook

Databases

SQL Server, MS Access, Oracle, MySQL

Operating Systems

Windows (XP, Vista & 7, 8) Linux

Other Tools

Load Runner, Browser shots.

Banking Products:

Sales Force for Retail Banking, Finacle, SFMS and NFS (National Financial Switch) Analytics, ATM Testing.

Domain Expertise:

Knowledge on article management in Sales Force in retail banking.

Area of expertise comprises of extensive knowledge on core banking products like Finacle.

Knowledge on health insurance sector.

Expertise on Internet banking in electronic fund transfer.

Operational and functional knowledge in Structured Financial Messaging system (SFMS) software used in various banking applications across the world.

Operational and functional knowledge on ATM Switch used in ATM machines and experienced in ATM Testing.

Expertise in ECS (Electronic clearing services) process and ACH (Automated Clearing House)

Education:

West Bengal University of Technology, Kolkata, India

Degree: Bachelor of Technology, July 2004 to July 2008

Major: Information Technology

GPA: 3.5/4.0

Professional Experience:

PNC Financial Services (PNC Bank):-

Location:-Pittsburgh, PA.

Project:-Sales Force for Retail Banking

Role:-QA Analyst

This application enables retail banks to deliver the highly personalized, intelligent and connected banking experiences that consumers expect. Now every bank employee, from the personal banker to the teller to the mortgage officer, can have a complete view of their customers and work collaboratively to exceed expectations. This is a cloud-based application hosted in financial services cloud enabling retail banking and wealth management institutions to bring together disparate lines of business, geographies, and channels to put customers at the center of every interaction.

Responsibilities:-

Working as a QA, responsible for creation and execution of Test Cases and end-to-end to Test Scenarios for the System, Integration and Regression testing.

Write test cases and test scenario for various module of the application (Article Management, Knowledge Management and Distribution management)

Writing regression-testing scenarios for end to end testing.

Analyzed technical specification and business specifications and created Test plan and Test case in Version One.

Attending daily scrum meetings with Project Management and QA team.

Use QC to log defects and manage requirements, test cases and defects.

Developed test scenarios and test cases of workflow of Knowledge and Article management.

Conducting manual testing of the modules/functionality planned in the current sprint and conducted regression testing of stable application module.

Coordinating with offshore team and communicate requirements and manage daily assignments with offshore team.

Attending scrum meeting to identify the weightage of requirements planned for a sprint and estimating the time needed to develop test scenarios and executing test cases for the assigned modules.

Conducted backend testing by writing SQL queries to verify the data entered from the screen is visible or not.

Involved in sprint planning and attending daily scrum meetings.

Project: - AB Arogyadan (Andhra Bank Arogyadan)

Role: QA Tester

“AB AROGYADAAN SCHEME" is a Group Mediclaim Health Insurance scheme introduced in association with M/s United India Insurance Company Limited & administered by Good Health Plan Ltd (TPA).This scheme provides medical insurance and option of cashless treatment in over participating 860 network hospitals. Conversion was also part of this project to load old medical insurance data from legacy to target system.

Responsibilities:-

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analyzing requirements and creating and executing test cases

Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.

Working with the Development team for process improvement and release planning

Analyzed application data using the SQL to identify the ETL processes

Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.

Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.

Wrote queries to compare the counts and data from source to target.

Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.

Created, maintained and updated regression suites upon receiving new build.

Modifying and executing test scripts for web based environment-using Quality Center.

Created and executed goal oriented and manual scenarios using Load Runner Controller.

Creating traceability relationship between requirements in the same module and between different modules.

Involving in formulating the test plan, procedures and Wrote test cases.

Used JIRA for defect management and triaging.

Extensively JAMA for organizing Requirements, Test Cases and Defects.

Project: ANDHRA BANK-Online (AB INFI-net)

Role: QA Analyst

Andhra Bank is public sector mid-size bank providing banking facilities to millions of customer .The online banking application provides banking facilities to customers every day through internet for retail banking. Under Retail Banking Andhra bank offers deposits, loans, cards, DMAT services, P payment services, insurance, and mutual funds to individual customers

Responsibilities:

• Worked as a QA, responsible for the multiple roles like, understanding the requirements, creation and execution of Test Cases and end to end to Test Scenarios for the System, Integration, Regression and User Acceptance Testing for various modules.

Developed QA Test plan from technical specifications and requirements for the project.

Used Quality Center as manual testing tool and defect management.

Executed SQL statements to check that the data integrity is maintained as part of database testing.

Business Analysis as an when required to understand the customer policies and procedures relevant to project delivery activities we undertake

Performed Backend testing manually using complex SQL Queries and Query Analyzer by connecting to the database server.

Used Quality Center for organizing Requirements, Test Cases and Defects.

Retested user acceptance testing defects in SIT environment to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.

Data analysis and validation of reports generated by SFMS against the report generated by Finacle and finding out discrepancy in the reports if any.

Participated in test execution, issue identification, review and resolution process during QA phase.

Preparing a weekly-consolidated report to present it to higher management.

Conduct cross browser testing using Browser Stack.

Conducted performance testing using Load Runner.

Project: ATM Complaints (ATM Software for lodging and tracking complaints)

Complaints is an in-house intranet application developed for Andhra Bank, it aims to track the complaints lodged by customer. The application also helped in identifying incomplete transactions at ATM. The software had various modules to lodge complaints, execute complaints, tracking chargeback.

Role: Test Engineer/Analyst.

Responsibilities:

Developed QA Test plan from technical specifications and requirements for the project.

Wrote detailed test case checklists and test cases for the product, including traceability matrix to requirements.

Retested user acceptance testing defects in SIT environment to ensure that developed systems is operating as specified in the functional requirements.

Used Mercury Quality Center for organizing Requirements, Test Cases and Defects and logged defects for failed test cases.

Defect logging and tracking using Quality Center.

Identifying Critical test case on each release and updating Regression Suite.

Interact with the development teams in resolving several issues.

Project: Client Consolidation, Server Consolidation, ATK Cash Management.

Role: QA Analyst

Responsibilities

Analysis of Requirement documents, Design documents & Business Rules for designing testing activities that typically involves Test procedures, write test case scenarios, review and verify quality standards.

Manage Defects in QC for defects and reports for the status

Work closely with QA team on test execution/defects and update the status to management.

Create test scenarios and test cases based on functional documents and User stories.

Develop Traceability matrix, mapping Test cases to the Requirements.

Verify NDC CCPROT/JOURNAL logs and event logs at the end of the transaction.

Conducted Test Case reviews and presented the test cases/test scenarios to the team members for all iterations.

Worked with First Data team to setup the QA machines in correct environment before the Release begins and Cassette configurations and denominations are in sync.

Work with First Data team to make sure simulator is running in correct environment for Check Cashing transactions.

Performed and executed regression test plan for every build and on different vendor ATM’s like Wincor, NCR, Hyosung and Diebold.

Executed SQL queries to verify the database for the relevant test cases.

Unit Test PROD defects and release defects.

Verify transactions in Server using Admin Console.

Check Electronic Journal and Journal XML for the performed transactions.

Interact with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.

Interfaced with business users to prepare and update Business Requirements System and Software Requirements System.

Document the defects in quality center and assigned them to relevant developer.

Document and demonstrated the implementation procedures to improve process.

Project: ECS (Electronic Clearing Service), Andhra Bank

Role: Test Analyst

Electronic clearing Service (ECS) is an application for Andhra bank to clear daily inward and outward transactions. ECS system supports RTGS as well as NEFT transactions. This system is used to clear inward and outward transaction from various entities within the bank as well as outside the banks.

Responsibilities:

Documented Test cases and test plan corresponding to business rules and other operating conditions.

Developed the test cases based on the Client side and Server side error handling conditions in HP Quality Center.

Performed Functional, Integration and Performance testing manually.

Reported the bugs, Email notifications to the developers using the Quality center

Attended weekly status meetings, daily status meetings and project meetings.

Monitored QC to close the bugs/cases as and when developers fix the bugs.

Preparing test scenarios to integrate with other external payment systems like Finacle.

Performed Backend Testing using Structured Query Language (SQL) for testing reports.

Personal Information:-

Date of birth: 09/29/1984

Languages Spoken: English, Hindi, Bengali

Immigration Status: Green card holder (permanent resident)

References:-Will be provided on request.

Contact this candidate