Priyanki Roy
Tel: 860-***-****
Email: **************@*****.***
PROFESSIONAL SUMMARY:
• Around 1 year of work experience as a JAVA Developer.
• Around 3.5 years of work experience as a Quality Assurance analyst in Manual Testing and Automation Testing.
• Excellent experience of complete SDLC and Test Management Process
• Experienced in Comparison Testing, ETL Testing, Functionality Testing, Regression Testing, GUI Interface, Integration/System Testing, User Acceptance Testing, Data base testing.
• Strong analytical and QA/ testing skills, capacity to work and diagnostic ability, gathering different kind of projects requirement.
• Extensive experience in functional and regression of web-based and client-server applications using Quality Center for Insurance applications
• Having work experience in Waterfall methodologies.
• Proficiency in Maintenance, Developing, Editing and Execution of Test Cases within the framework.
• Executed tests and managed defects using Quality Center.
• Strong Knowledge on Core JAVA, J2EE, JAVA Applet
• Expertise in Selenium WebDriver tool
• Strong expertise in establishing QA policies, procedures, strategies and developing appropriate process to ensure the quality of product.
• Worked closely with Developers, Business Analyst and Project manager to test and document new product and new product enhancements.
• Specialized in writing Complex QUERIES using DML, DDL & Joins and testing them.
• Excellent Management, Communication and Presentation skills & ability to work either independently or as a part of a team.
• Self-starter and ability to learn new things in a quick span of time.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure. EDUCATION:
Masters of Technology in Computer Science and Information Technology from West Bengal University of Technology, India (2011)
Bachelors of Technology in Computer Science and Information Technology from West Bengal University of Technology, India (2008)
Achievements – Research Paper Publication:
“Reversible Masking: A novel fault-diagnosed secure design” to appear in Proc. 3rd International Conference on ARTCom 2011, Nov 14-15, 2011.
“Secure Reversible Masking” to appear in IEEE EDS Conference 2011, April 18, 2011. Certification:
CTFL (Certified Tester Foundation Level) – ISTQB
Technical Skills
Operating Systems : Windows 95/98/ XP/ 2000/ Prof/XP/ Windows Vista, Win 7, Windows 10 Defect Reporting Tools: Quality Center, ALM 11.0, Bugzilla and Jira. Languages : C, C++, VB 6.0, SQL, PL/SQL.
RDBMS : Oracle 8i/9i/10g, MS SQL Server 2008, MS Access. DB Tools : SQL developer, PL/SQL developer
Productivity Tools : MS Word, MS Excel, MS Office, Outlook Express Web Technologies : HTML, XML, DHTML
Development Tools : Visual studio
ETL Tool : SSIS
Reporting Tool : SSRS
Project Portfolio:
Atlas Healthcare Software, India Jan 2014 – Jan 2015 QA Analyst
The project is about to support a large health Care firm in India that will build an online system which can track the New Policy Enrollments, Disenrollment, Agent’s cumulative Amount, Claim, Cash Disbursement . This project will implement data from various systems to create a robust interconnected data set that can be used to create reports.
Reporting initiative is intended to deliver the end to end capability by providing visibility to the transactions within and across these systems. This process will provide reports on a daily basis for the management users to track different metrics about the process across multiple systems. Responsibilities:
• Involved in gathering requirements for Business, System and Functional for the application.
• Involved in developing Test Plan, Test Requirements, Test Cases and detailed test cases in Quality center to conduct UAT.
• Involved in writing detailed test cases in Quality Center.
• Developing test plans and test cases from functional requirements for UAT testing.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Involved with business user and stake holders and performed UAT.
• Involved in preparing Test cases and Test plan for the execution of UAT scenarios.
• Performed User Interface testing for the web application with equal to business requirement.
• Performed Functional, User Interface, End-to-End, Application, System, Integration, Regression, UAT and Back End Testing.
• Used Quality Center to track and report System Defects.
• Performed role of Automation Team member and used Selenium as an Automation Tool.
• Participated in defect reviews with the developers, managers and business people and presented the Defect reports in the defect review Meetings.
• Test Data preparation for matching the Matching Criteria test cases.
• Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources/Targets.
• Utilized SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services) to produce a Data Warehouse for reporting.
• Participated in Production rollouts and provided end-to-end support and post-implementation support to the customer community resolving production related issues.
• Data validation and Database integrity testing done by executing SQL statements.
• Checked database and with application queried result is being equal, SQL queries is being extensively used to check the data from the data base using Toad.
• Performed Data Analysis on the beta deployment and worked closely with the PI / Business team. Environment: Java, TOAD, Oracle, SQL Server SSIS 2008, SSRS, HTML, SQL Server, PL/SQL, Windows 7
Alumnus Software Ltd. INDIA Sept 2012 – Dec 2013
QA Analyst
The Project was to view the application to the customer online and maintain updated Policies in customer accounts for customer to view online for one of the largest Insurance Companies in India. Responsibilities:
• Designed and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on business requirements and Design documents for the online application.
• Identified the Test Cases and documented them in Quality Center.
• Worked with the Developers and the test lead to verify the Test Cases.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Performed System Integration, End to End and User Acceptance testing for the data services.
• Performed Functional testing and Regression testing to see the entire functionality.
• Used Joins like Inner and Outer joins while testing from multiple tables.
• Used Quality Center to store all testing result and for defect Tracking and Reporting.
• Used SELENIUM Web Driver Open Source Tool to automate the Web Browser testing
• Generated enhanced graphs and reports with Quality center.
• Provided weekly management status reports and coordinated meetings between test team and development team to review defects.
Environment: Quality Center 9.0, HTML, Windows XP, MS-Office, My SQL Star Net, INDIA Sept 2011 –Aug 2012
QA Tester
StarNet provides web hosting, email hosting, domain names, online publishing & web design services for customers based in India & South Asia. Our Web Servers are located at Premium Data Centers in USA, UK & India and have connections with all major carriers. Responsibilities:
• Execution of test scenarios, analyzing the actual results against the expected results and creation of test data.
• Performed UAT Testing and interacted with Business people.
• Worked with Business Analysts and other project team members to verify functional, business processes and/or user requirement to ensure thorough testing of application-under-test.
• Tracked outstanding defect reports and documented resolution after successful testing.
• Performed functional testing of all components.
• Web testing, database testing, GUI testing, end to end testing, production assurance, System testing, functionality, Regression and User Acceptance testing(UAT) were performed as a part of different quality activities such as bug tracking and control.
• Worked on Waterfall methodology for testing the application. Environment: JAVA, JSP, Portlets, SQL, QC (Quality Center), Waterfall Methodology. Tech Mahindra, INDIA
JAVA Developer - Integration between Front End & Back End Jul 2008 – Jul 2009 This project will enable multiple admin system to interact real time through single front end system. This front end will take the request and will send it to the different admin systems for processing in real time. It gets the response from admin system and display the status. This interaction is required while user inputs some policy level information for processing. The front end system parses the request and sends it to the Admin system through webservice. As a response, this front end system will receive the status of processing and display to user. Responsibilities:
In this requirement I worked on the UI part. The front end design and parsing the request . Below are the points to describe the roles and responsibilities within this project.
• Requirement Analysis: Have analyzed over all requirements specially the uses of different admin system and uses of integration. Also understand the impacts of changes.
• Test Case and Design Doc preparation: Prepared unit test cases and low level design document.
• Coding: Used J2EE to design the web page and to make it functional so that it can take necessary data and prepare the request object for web service invocation.
• Unit Testing: Executed the unit test cases to ensure the functionality is working as expected.
• Integration Testing: have done some part of integration testing like filling data in UI and checking the request with in admin system whether that was as expected or not. Environment: Core Java, J2EE, XML, Webspare and IBM MQ, Oracle