Test Cases Project Manager

Pratyusha Datta **************@*****.*** 401-***-****

Summary:-

IT Professional with more than 6 years of software QA testing experience having full system development life cycle experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.

Have good knowledge in testing applications in various industry domains like Healthcare, Banking, Telecommunication and Retail.

Experience in defining Testing Methodologies, Designing Test Plans and Test Cases, Verifying and Validating Web based e-Commerce applications and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile (Scrum).

Experience in coordinating and mentoring offshore and onshore QA engineers.

Experience in setting up the test environment, installations and configuration.

Expertise in Manual and Automated testing of various Web based applications.

Created Test Plans, Test Cases, Test Procedures and Test Script.

Vast experience in different testing methods such as Functional, System, Regression, Integration, Performance, Security, Positive, Negative, End to End, UAT and Load testing.

Working experience with Developers, Business Analyst and Project manager to test and document new product and product enhancements.

Strong expertise in establishing QA policies, procedures, strategies and developing appropriate process to ensure the quality of product.

Expert in web technologies like HTML and XML.

Experience in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.

Well versed in automation testing tools such as Quick Test Professional (QTP), Load Runner and Selenium.

Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.

Knowledge of Defect/Bug tracking system with the use of tools like HP Quality Center and Bugzilla.

Experience in importing/ exporting the Scripts /data into QC by using MS Word and Excel Add-ins.

Strong working experience in various databases such as Oracle, MySQL, SQL Server and MS Access.

Strong knowledge and experience in constructing and executing queries in PL/SQL .Working experience in ETL projects. Validation of every step of ETL process.

Experience in using JOINs, database views, Sequence, Indices, performance tuning.

Good understanding and knowledge of UNIX and Shell commands.

Experience in UNIX shell scripting, job scheduling using Crontab.

Extensive experience in Web applications, Web services and Web methods. (Middleware Testing) SOA

Exceptional analytical, trouble shooting and problem solving skills.

Excellent Analytical, Decision-Making and Organizational Skills coupled with good co-ordination, communication and interpersonal skills describing a committed Team Player with an ability to handle/organize multiple projects simultaneously.

Technical skills: -

Packages

MS Office (Word, Excel (VBA), Access, PowerPoint, Visio, Front Page)

Environment

MS-DOS, LINUX, Windows NT/9X/2000/XP, UNIX.

Databases

SQL Server 2000, MS Access, Oracle 8i/9i/10g/11g,

Languages

HTML,SQL,SAS,PL/SQL, Shell Scripts, XML, DHTML, C/C++, Java, VBA, VB.Net

Testing Tools

HP Quality Center 9.0/11.0 (ALM), QTP 9.0,Perfecto(Mobile Testing), SOAP UI(Service Testing), Zeenyx Ascential Test (Automation Testing)

Tools

TOAD, SQL*Loader, SQL*PLUS, PL/SQL Developer, Business Objects 3.1, Cognos reports, Bugzilla

Professional Experience:-

Euclid Technologies LLC September 2017-Present

(Centene Corporation)

Senior PEGA and Database Test Engineer

Responsibilities:

Attended daily standup meeting within team. Part of various Scrum ceremonies like Backlog Grooming, Backlog refinement, Sprint Retrospective.

Attended Sprint demo sessions by Business Analysts.

Worked closely with Product owners, scrum masters, scrum coaches and development team.

Project strictly adheres to SaFe Agile framework.

Participated in PI event, planning for the next five consecutive sprints.

Experience in creating and modifying stories in JIRA.

Involved in regression testing every two weeks as each sprint lasts for two weeks.

Functional testing of Pega application, running on Pega 7 platform.

Database testing using Bethic Golden 6 client for Oracle database.

SOA testing using Swagger UI.

Web services testing using Soap UI 5.0

Involved in automating existing regression test cases.

Writing automation scripts in Soap UI.

Creating test cases in qTest, approving them and thereby executing them.

Working on functional and technical JIRAs by providing evidence in the form of screenshots.

Tools – Benthic Golden6, Pega7,Soap UI 5.0.0,qTest,JIRA

Euclid Technologies LLC October 2016-August 2017

(Sprint USA)

ETL Test Analyst

Responsibilities:

Developed Test Plans, test scripts and executed the test scripts for Sprint – Enterprise Data warehouse Project.

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing.

Developed complex SQL queries for querying data against different data bases for data verification process.

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.

Participated in regular project status meetings and QA status meetings.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)

Defects identified in testing environment are communicated to the developers using Quality Center – Defects module.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files and DB2 server.

Worked on issues with migration of Data from development to QA-Test Environment

Extensively tested several Business Objects Reports – Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 – Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Ericsson India Global Services Pvt Ltd September 2012-July 2014

(Walgreens USA)

Retail Automation Tester

Extensively involved in all phases of SDLC (Software development Life cycle) and follows Agile methodology.

Worked on POS self check out / POS QA Testing was involved in setting of QA Test environment with simulated POS test environment.

Involved in Preliminary discussions of the Project with the Core Team according to Business Requirement Document.

Prepared test plans and test cases for manual and automated testing.

Tested different functions of the POS system like scanning, payments and returns. Moreover, make sure that the system met the requirements and expectations.

Developed the test cases according to requirement.

Responsibilities of checking of data in database by writing and executing SQL statements and UAT on NGPOS Environment consist of MPOS, KIOSK, PHARMACY and PHOTO Ecommerce testing.

Validated Inbuilt CMS tool along with web application on different browsers.

Extensively worked on Web Service testing using SOAPUI.

Involved in Functional, Regression and Smoke testing.

Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.

Used VB Scripting in QTP, Generated test results using QTP and analyzed Actual Result and Expected result.

Developed data driven scripts in Quick Test Professional and executed scripts.

Used checkpoints to check the functionality in QTP.

Used synchronization, call function, parameterization, and reusable actions to enhance test affectivity.

Interacted with developers and Managers to identify and resolve technical issues while performing automation testing using Selenium in Twist.

Used Firefox browser to installed Selenium IDE to test the Catalina test portal BPT server.

Wrote SQL queries for searching, creating and updating test data.

Interacted with DBA\'s, Developers, Systems Engineers and Network Engineers during testing and isolated bottlenecks at different levels.

Performed Load testing by bombarding the server with users to test the performance of the application under stress conditions using Load Runner.

Managed and executed test cases and logged defects in defect reporting tool using Bugzilla.

Provided status reports to Project Manager.

Interacted with developers for resolving the defects and setting the priorities.

Environment: Quality Center 10, QTP 10, Selenium IDE 1.7.2, Load Runner 7.8, UNIX, Java, J2ee Windows XP, IE, Firefox, Mozilla, SQL Server, Bugzilla, Walgreens in house tools Jump server .

Tools/Technology: - SOAP UI, Java, XML, Zeenyx AscentialTest, Zee Language, Java, AS400, Version One (Defect Tracker)

Ericsson India Global Services Pvt Ltd December 2011-September 2012

Vietnam Mobifone Services

Functional Tester

Responsibilities:

Complete set-up of Jboss server in Solaris box

Involved in the deployment of code in the server using JBoss and Tomcat and troubleshooting

LDAP testing

Developed and maintained Scripts using SQL *PLUS to test Data Integrity

Designing test cases and test data preparation.

Execution of test scripts

Tested programs to ensure proper functionality doing unit testing.

Logging and tracking defects.

Tools: - Oracle10g/11g,Bugzilla, LDAP studio, TOAD, Shell Script, SQL*Loader and Unix (Sun Solaris 5.9), SVN, CSS,HTML, Java, Windows 2000

Tata Consultancy Services Pvt Ltd December 2009- December 2011

(Bank of America )

Fusion Application tester

Responsibilities:

Perform Functional Testing on banking MasterCard application in multi-channel like mobile, desktop and tablet

To perform functional end to end and regression testing on a banking application on a multi-channel /multiple device to make sure the application should work in any devices (Desktop, Mobile, Tablet) and any OS (android, iOS)

Involved in development and implementation of Test cases, Test plans, Test data and Test scripts

Involved in performing various kinds of testing like Unit Testing, System testing, Integration testing, Regression testing etc on PDA (Personal Digital Assistant) & Laptops and Synced the PDA & Laptops to host.

Involved in writing of Modification Reports for Errors Identified in Testing and clearly communicate with development via defect tracking database (Clarify).

Environment: Clarify, VC++, Oracle 8.0, Windows 2000

Tools: - Perfecto, Mobile Testing, QC, FDR, IBS

Education:-

Bachelor of Technology in Information Technology, WBUT, INDIA (May, 2009)

Contact this candidate