Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

1

SUMMARY

Over five years of diversified experience in Data Analyst, Software Quality Assurance and Testing on Client/Server,Automation testing with Selenium, ETL Testing with Informatica tool, Windows based and Web based applications.

Proven success in meeting or exceeding customer needs as an individual contributor and as team member.

Strong Experience in Automating Web Application Testing using Selenium Webdriver with JUnit, TestNG Frameworks. Experience in developing Test automation frameworks which include Data Driven, Keyword and Hybrid Frameworks.

Experience in Functional, Regression, Integration, Smoke and Usability Testing.

Experience in designing and developing application solutions in Java. Good experience with Java OOPS concepts, Collections, Exception Handling, I/O File Operations and Struts Framework.

Experience in modifying the Automation Framework to improve Test Execution Performance.

Understanding and Analyzing Project Requirements, creating Test Plans, Test cases, Developing and Maintaining Automated Test scripts, Test case Execution, Test Reporting and Defect Tracking.

Agile Testing experience for more than a year and handled scrum calls on a daily basis.

Experience in developing Unix Shell Scripts and writing SQL queries.

Well acquainted with all stages of Software Development Life Cycle (SDLC).

Strong knowledge of and experience with reporting packages (Business Objects etc), databases

(SQL etc), programming (XML, Javascript, or ETL frameworks)

Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

Extensively experience in analyzing business requirements and specifications, development and execution of Test Plans, Test Scripts and Test Cases.

Involved in Manual testing & Tracking defects using Quality Center and ALM.

Developed Test scripts for automated testing using Quick Test Pro and ability to run HCK test suite .

Good working knowledge on Windows and UNIX Environment.

Involved in Writing, Updating and maintaining the Test documents for various stages of Testing for reference and auditing purpose.

Strong experience in all levels of Testing such as Positive testing, Negative testing, Integration Testing, Functional Testing, System Testing, Regression Testing and User Acceptance Testing

(UAT), Black box testing, Browser testing.

Experience in programming and testing on Mainframes using COBOL, SQL, JCL, VSAM,DB2.

Good Communication, interpersonal, and Teamwork skills.

Excellent Organization, Analytical and Problem Solving skills and ability to quickly learn new technologies.

Self Confident, Honest, Sincere and a Hard Worker with a high level of Integrity. Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

2

TECHNICAL SKILLS

Testing Tools Selenium, Quick Test Pro,HCK Test Suite, TestNG, JUnit Defect Tracking Tools Quality Center, VersionOne

Microsoft Tools MS office Suite (Word, Excel, PowerPoint), Adobe Reader. Operating System Windows XP, 7, Vista, UNIX, z/OS

Languages HTML, SQL, VB Script, COBOL, JCL

Database SQL Server, Microsoft Access, Oracle, DB2, VSAM Browsers Internet Explorer, Netscape navigator, Firefox, Chrome Other tools Oracle SQL Devloper,SQL plus, Toad, SPUFI CERTIFICATION

ISTQB (International Software Testing Qualification Board) Certified Tester

HP Certified AIS - Functional Testing v11 (Quick Test PRO) professional

Training on Testing methodologies, Quality Center, QTP and other Mainframe Technologies i.e. Cobol,JCL,DB2,CICS in Infosys Academy.

Infosys Level 0 – Manual Testing

Infosys Level 1 – Validation Testing

Banking and Finance – Level 0

Infosys Certified Mainframe Professional

FUNCTIONAL SKILLS

Expereince in Data validation analyzings Source and Traget systems data.

Involved in entire data flow from start to end, validating each stage from OLTP to OLAP.

Involved in the requirement analysis of various systems per QA requirement.

Experience interacting directly with clients to analyze requirements, develop test cases, test planning, & test execution

Good understanding of Software Development Life cycle methodologies.

Excellent communication skills and talented problem solver. PROFESSIONAL EXPERIENCE

Project #1 (Jun 2014-March 2016)

Title Clinical Data

Client KnowledgeLens LLC

Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

3

Tools and Technologies Selenium Webdriver, Java, TestNG, ANT, JIRA, SQL Server, Quality center, Office, Windows 2000, XML,HCK Test Role Quality Assurance

Project Description

Clinical trials are conducted on many people to test the new medical composition. Verified and analyzed data of Patients, medicine samples, clinical reports, data reports. Supported verifying the data types,data integrity in soruce system and prepared documents to load into Target systems for Big Data Reporting.

Responsibilities

Preparation of Test Strategy, Test Cases and Test Data.

Developed Automated Test Scripts in Java using Selenium Web-Driver and used Hybrid Automation Framework to execute the test cases in Test Suite.

Provided effort estimates, logged User Stories for each Sprint in VersionOne and set-up Scrum calls on a daily basis to discuss milestones and issues

Developed Ant Scripts to automate the upload of feed files from downstream systems

Integrated TestNG into the Selenium Webdriver to perform Unit Testing and generate Test Reports

Automated all of the possible manual Test cases for each module using Agile Testing Methodology

Attended daily scrum calls to track the progress and discuss the recorded issues.

Performed thorough Functional and Regression Testing of the Web Application.

Updated the existing Hybrid Automation Framework as and when needed in order to improve test execution time and generate bug-free Test Results.

Analyzed the Test Results and created weekly status Report

Analyzing business and functional requirement to design SIT and UAT Test Cases.

Supported UAT testing, re-verified the bugs by reproducing, documenting the steps and coordinated the team for resolution based on prioritization.

Performed smoke testing, Functionality testing, Integration testing, and Regression testing.

Participated in review meetings for creating Test plan and test results summary.

Reviewed requirements for testability and usability, and consulted development staff with regards to system functionality.

Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.

Project #2 (Jan 2012- Feb 2013)

Title VOIP application

Client H2K infosys

Tools and Technologies Selenium Web Driver, Mercury’s Quick Test Pro, Test Director, Quality center, SQL, Oracle, MS Office, Windows 2000, XML, VB Script. Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

4

Role Quality Assurance

Project Description

Supported the VOICE OVER IP (VOIP) application to support call activity, Customer information, Call forwarding, Call wait and confrencing features. The application generated reports with call history, Payment or billing history from a quter to any year duration. Responsibilities

Developed QTP Test Plans, Test Case design using HP Quality Center.

Selenium RC with Web Driver in implementing design patterns in automation frameworks.

Developed hybrid automation framework that integrates between QTP (UFT), QC (ALM) and external data sheet the drove keywords and data inputs.

Created Automation Execution Strategy that laid out a work plan and engagement model for both the, manual and automation team during automation executions.

Implemented new automation modular framework to handle checkpoints from functional libraries instead of hard coded checkpoints for script robustness and ease of maintenance

Designed the VU-Gen scripts using Load Runner VU-generator

Load runner supported protocols (HTTP/HTML, Web Services, Citrix, Flex, AMF, TCP/IP, SQL).

Executed the VU-Scripts in Load Runner Controller in distributed load balancers.

Generated the Application Performance reports and reported to the analysis group of Performance Testing for fine tuning the application Performance.

Involved in the project scope meeting and provided QA possibility to the team.

Developed and executed Test plan and Test cases for functional, integration and regression testing

Verified the Project Goals meet the current and long term corporate objectives.

Interacted with Developers and Business Analysts to understand the requirements.

Attended Project meetings, Release meetings, and QA status meetings.

Extensively use QC to document the requirement traceability, test plans, test case and defect tracking.

Used Excel macros to automate the testing process.

Supported UAT testing, re-verified the bugs by reproducing, documenting the steps and coordinated the team for resolution based on prioritization.

Participated in the meetings with business users to present future functionality of the application, gather information from them to know about their need and send this information to test manager.

Project #3 (Jan 2011 – Dec 2011)

Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

5

Title Grange Auto Testing

Client Grange Insurance Group

Tools and Technologies Mercury’s Quick Test Pro, Selenium Web Driver, Quality center, VB Script, SQL, Oracle, MS Office

Role Quality Assurance

Project Description

The Grange Insurance Group (Grange) was implementing Insuresoft’s Diamond system across the states such as Idaho, Wyoming, Colorado, Washington, California and Oregon where it writes insurance, for its Personal Auto LOB (Line of Business), Homeowners. Responsibilities

Analyzed user and business requirements for the new build and compared of those with the old build to modify test plans for positive and negative scenarios for functional and performance testing.

Prepared Test Plan and templates to create test cases, test scripts.

The whole application manually tested before going for the automated testing.

Involved in Data validations, Data type miss match and sanity checks.

Experience working with SQL Server and Oracle Databases.

Implemented and worked on Quick Test Pro for automated testing.

Performed the Positive and Negative Testing, User Interface Testing on the application

Performed manual and Automated Regression testing after every build Installation.

Used Test Director/Quality Center for bug tracking and test management.

Run Regression Test to ensure that introduction of new component into application doesn't affect the existing functionality.

Developed / Enhanced VB script in Quick Test Pro to add check points, Parameterize data etc.

Made schedules for system and integration testing for each release.

Kept track of the customer bugs, deciding their priority and then assigned them to the different developers.

Attended status review meetings, interacted with developers, Architects to resolve the issues. Project #4 (September 2008 – December 2009)

Title Online Banking – Product Launch

Client Merrill Lynch

Tools and Technologies Mercury’s Quick Test Pro, Test Director/ Quality center, SQL, Oracle, MS Office, Windows 2000, XML, VB Script.

Role QA Tester

Project Description

Merrill Lynch is one of the world's leading wealth management, capital markets and advisory companies, with offices in 40 countries and territories and total client assets of approximately $1.6 trillion. Merrill Lynch offers a broad range of services to private clients, small businesses, and Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

6

institutions and corporations, organizing its activities into two interrelated business segments - Global Markets & Investment Banking and Global Wealth Management, which is comprised of Global Private Client and Global Investment Management. As an investment bank, it is a leading global trader and underwriter of securities and derivatives across a broad range of asset classes and serves as a strategic advisor to corporations, governments, institutions and individuals worldwide. As By July 31, 2009, all market participants must comply with the new options symbology method data. It will have a maximum of 21 characters as against five alpha characters. The Options Clearing Corporation (OCC) will also include the expiration day and decimal strike price as part of its standard production series contract. Because of this it was required to change this field from existing 17 characters to 21 characters.

Responsibilities

Communicated overall project schedule and testing effort to various stackholders.

Prepared Test Strategy and Test Cases for the project based on Requirements Specification Document (RSD) and Business Requirement Document (BRD).

Accessed Homeowners Data Entry System (HDES) mainframe region and NetPOSitive Java application to create Home Owners Policies, and perform endorsements on the policies.

Interacted with business team in resolving the issues.

Accessed Exstream server to obtain documents/XML’s generated. Validated them by cross verifying with business requirements.

Performed system integration testing (SIT) and executed Test scripts in Mercury Quality Center.

Validated test results based on business requirements.

Logged defects in Mercury Quality Center for corresponding failed test scripts. Attended defect review meetings and provided Status updates on Testing. Project #5 (May 2007 – August 2008)

Title ABN AMRO Data Reconciliation

Client ABN AMRO

Tools and Technologies Quality center, SQL, Oracle, MS Office, Mainframes, COBOL, DB2, JCL, ChangeMan

Role QA Tester

Project Description

Traditionally known as a strong diamond financing bank, ABN AMRO today offers unparalleled suite of client services worldwide. With assets over US $504 billion and an AA credit rating, ABN AMRO Bank ranks among the top 10 banks in the world in size and strength. By leveraging its global reach and drawing on the expertise of the team of research, sales and trading, equity capital market and M&A advisory professionals, it has led many of the biggest and most innovative landmark transactions for its Corporate and Institutional Clients.

Swagatika Mishra

503-***-****

ac06b9@r.postjobfree.com

7

Recently ABN AMRO sold some of it's part to bank of America. So data from both the banks had to be merged especially for System Balancing and Recon Plus modules which were to be done by ABN AMRO.

Responsibilities

Engaged in Manual Testing

Preparing Test Cases.

Investigation of Defects using Defect Tracking tool

Involved in developing full suite of test Cases to test the product’s Functionality.

Used GUI, Bitmap, Text and Database checkpoints.

Requirement Document Review, Test Planning, Test Case design and Testing

Version Control using ChangeMan

UI Test Case Design and Testing

Involved in Functional Testing.

Reported & tracked defects With Proper Severity levels. EDUCATION

Bachelor of Technology (Electrical and Electronics Engineering) from Silicon Institute of Technology, Bhubaneswar, India

Contact this candidate