Swapna Janga
Mobile: 647-***-**** Email: ******.******@*****.***
LinkedIn Profile: ******.******@*****.***
Objective
To be employed in an organisation where I can put my strong technical skills in use and support to boost company’s productivity. Seeking challenging and rewarding position as QA software. Passion to learn and adjust to new Environments and technologies. Professional, dynamic and career minded with a strong work ethic.
Expertise
10+ of experience in quality assurance and testing in Client Server, Web and UNIX environments
Involved in all phases of Software Development Life Cycle (SDLC) with major emphasis in Software Testing Life Cycle (STLC)
Experienced in testing mobile, Client Server and multi-tier applications that are developed in ASP, HTML, DHTML, .Net, Java and VB Platforms
Developed automated regression test cases in Selenium WebDriver using Java programming language.
Experience in working with Page Object Model framework to develop automation scripts using Selenium, to have clean separation between test code and page specific code such as locators.
Delivered all the deliverables as defined in the test planning, test execution and test analysis phase
Hands on experience in creating Master Test Plan, System Test Plan, Test Scenarios and Test cases templates based on IEEE standards.
Ability to provide deliverables and streamline testing activities according CMM levels
Extensive experience in creating SIT and UAT Test Plans, Test Scenarios and Test cases based on requirements provided.
Prioritized tasks assigned, documented as necessary in software development life cycle.
Identified business and functional requirements in analysis, documented and coordinated with business.
Worked closely with Business, Developers to ensure the functionality as per business requirements.
Expertise in Mobile, Manual, Sanity, System, UAT, Integration, Regression, Functional, Load, Network, Database, Configuration and Black Box Testing
Experienced in using testing tools such as Quick Test Professional for Functional test automation and Quality Center test management
Tested applications on Siebel CRM.
Performed testing on mobile applications using both positive and negative approach on both Native (Standalone) and mobile Web versions with 3G and Wi-Fi connections
Validated functionality of mobile application using different Simulators and Emulators (IPhone, Blackberry, Android and Windows)
Tested Data encryption using Penetration and WML testing on different simulators for mobile application testing
Experienced in Testing Database Applications of RDBMS in ORACLE, MS SQL Server and DB2 using SQL
Good understanding of ETL testing principles and concepts,Vast experience with format ETL and Data Testing
Created automated test scripts for various testing stages like Functional, Performance, Regression, System and End-to end Testing.
Experience in planning, designing, installing and maintaining Oracle Database technologies (10G, 9i, 8i, 7.x) on multiple nodes in the UNIX/Linux, Apple MAC, Windows and clustered environments
Involved in Mainframe testing of different Java applications on Windows Environment
Working experience of performing backend testing on Database like DB2, SQL Server-SQL, Oracle and MS-Access
Solid experience with Back-End service testing with extensively used SQL for table manipulation from Oracle database table
Have an ability to perform multitasking and create testing deliverables according the deadlines and timelines
Very strong analytical and presentation skills, documentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills
Certification
CSTB Certified
Foundations of Business Analysis(University of Toronto)
Technologies and Process
SOAP UI 5.3, Selenium 2.4, Load Runner 8.0, and Quick Test Professional 11.0.
HP ALM, Jira, PVCS Tracker, Rational Rose, Rational Clear Quest
Mainframes, Window 2000, Windows NT, Windows XP, Linux and UNIX
SQL Server, Sybase, Oracle v7/v8i/v9i/10, MS Access and Lotus database
VB.NET, ASP.NET, C#, Microsoft Dynamics, Microsoft SharePoint
C, C++, SQL, XML, DHTML, Java, Java Script, J2EE, EJB, JUnit, Perl and HTML.
Java Scripts, VB Script, Test Scripting Language, Lotus scripts and SQL Basic
IOS SDK, Device Anywhere, Android OS, Siebel CRM,RIM Blackberry OS, Linux Mobile OS, Windows Mobile, HP Palm Web OS, Samsung Bada OS, J2ME
Education
Masters of Technology in Software Engineering – JNTUH University, Hyderabad, India.
Bachelor of Technology in Computer Science Engineering – JNTUH University, Hyderabad, India.
Professional Experience
AmerisourceBergen, ON July 2018-Till Date
IPACT-ePIR Portal
Sr.QA Test Analyst
The Technologies implemented in this Project are ALM 12.0, Mule soft and REST API, and .NET application, SaaS API, Salesforce and SQL Server.
ePIR Project is a web based application supporting the completion of Post infusion report electronically at Innomar strategy Inc. The EPIR portal is new developed system with increased auto features and minimal manual interventions for submitting patient’s electronic reports replaced with existing PIR (Post infusion reports).
Gathered specific requirements from the Business Analyst reviewed it and identified gaps in the BRD document.
Understood the functional flows mentioned in Use Case document.
Solid understanding in business flows and able to handle and prioritize multiple tasks effectively.
Created User requirement specification document. Maintained, updated and executed regression suites.
Identified, assessed, addressed, resolved and escalated, develop contingency plans as needed.
Prioritized tasks to ensure critical tasks are completed on time and meet requirements.
Identified risk analysis methodologies that aligned during project development approaches.
Involved in the creation of Test Plan based on the specific requirements and provided to the management for review and sign off.
Created test case design, test case creation, test data creation, testing approaches, and Entry and exit criteria reports.
Conducted triage meetings and informed daily status reports to QA manager and project manager.
Performed Functional, Integration, End to End, Cross browser testing. Tested application on Mobile devices on Android, IPhone, and Tablets etc.
Prepared Requirement Traceability Matrix for test coverage. Reported and tracked defects using ALM.
Identified Functional, Integration, Regression, Requirement gaps Logged as defects and tracked them in ALM.
Good understanding in audit trails and ability to analyze and identify root cause of the issues.
Verified and validated the system as per 21CFR Part 11 standards.
Maintained routine tasks, involved in corrective and preventive action (CAPA) associated to manufactured products.
Coordinated and worked closely with automation team to automate test cases and prepared test data for the Regression/Sanity and smoke testing.
Good Understanding on Mule soft and REST APIS for sending that interacts between multiple components.
Compared UI Form data populated information is similar to values stored in database.
TELUS Health, ON June 2016-June 2018
eClaims and Multi Benefit
Sr.QA Analyst
The technologies used in this project are Application Life cycle Management (ALM) 11.0, XML, SOAP UI (REST API), Load Runner, Java, and SQL Server.
eClaim’s Project is a Health Insurance project it submits different claims from the Provider Portal on behalf of Insured patient and finds correct response from adjudication system to Insurer system, Clinic/organisation or Broker system.
Multi Benefit Project is creating Groups,Members,division for providers on behalf of Insured patients for Dental,Drug and Electronic Health Care system project The system will integrates the flow from different API’s,send Request and receives response automatically when the claim get submitted through online and can submit claims for payment and Predetermination transactions.
Experience in reviewing the requirements provided by Business analyst and detected requirements gaps early in the project.
Implicit the requirements by reading Use Cases, and Workflows.
Involved in the creation of Test Plan based on the product specific requirements and provided to the management for review and sign off
Used SOAP UI for automating manual test scenarios of key modules in validating responses from different systems.
Experience in using XML coding in supporting SOAP UI for validating different response from various systems. Experience on web Service Testing to Map different environments by using SOAP UI.
Used ALM to document Test Scenarios and detailed Test Cases based on the Use Case Documents, Business Requirements, and Functional Specifications
Accomplished database testing by passing SQL Queries to retrieving data created during various transactions involved in Provider Portal.
Mapped the Test cases to the requirements using Requirement coverage tab in ALM, Prepared test data and documented test results with screen shots and notes in ALM
Used simulator for testing the functionality and integration for submitting claims online.
Done Cross browser testing for different scenarios created.
Prepared Functional, System, Integration, Regression, End to End, Performance and User Acceptance testing
Worked closely with Developer and DBA in identifying the test environments for test execution of claim’s online application.
Updated the Requirement Traceability Matrix based on the test coverage. Reported and tracked defects using ALM.
Executed test cases on different OS and devices to validate the Compatibility of the application by performing Cross platform testing and tested in mobile devices.
Strong interpersonal skills - including oral and written communication, meeting management, conflict resolution and team building.
Respond to all incoming support requests from clients in a timely manner.
Identified and resolved support requests and/or escalated them to right team.
Provided user support applications as well various technologies used
Support with report writing as required and worked with vendors to resolve support issues.
Comply with all quality related policies, procedures and system requirements
Ability to prioritize work assignments and manage time effectively.
Executed advanced SQL queries for validating the requirements.
Reported defects to the development team using ALM with proper priorities and severities
Provided daily execution and defect reports to QA Manager using customized reports from ALM.
Analysed performance results and generated reports and quality metrics for further improvements
Participated in Test Review and Status meeting and provided planning, Test execution status reports and communicated with team on current progress and problem encountered.
TJX Canada, ON Feb 2012 – April 2016
Transport Management System
Sr.QA Analyst & UAT Test Analyst
The technologies used in this project are SDLC, Quick Test Professional 10.0, Quality Center 10.0, SDK 3.2, IOS, Android OS, Blackberry OS, Eclipse, XCode, WML, Java, J2Me, JUnit, JavaScript, SQL Server, Selenium, GIS, MS Access and Oracle 9i
TMS project is an optimization engine that automatically finds the best solution to TJX for Logistics needs. The system creates more efficient velocity logistics network, Plan and execute shipments in one system, optimize the consolidate orders; streamline location flow and calendar’s.
Gathered device specific requirements from the BA and requested walkthrough and overview on the requirements
Understood the requirements by reading Use Case, Workflows and Wireframes
Involved in the creation of Test Plan based on the device specific requirements and provided to the management for review and sign off
Used Selenium WebDriver for automating manual test scenarios of key modules in Transport management System and also integration scenarios of TMS with Order Management System and Warehouse Management System
Developed a system to validate reference data in spreadsheets with database using Selenium web driver
Experience in using TestNG framework in supporting data driven testing for Warehouse management testing.
Used Quality Center to document Test Scenarios and detailed Test Cases based on the Use Case Documents, Business Requirements, and Functional Specifications
Performed database testing by passing SQL Queries to retrieving data created during various transactions involved in TMS, OMS and WMS systems.
Mapped the Test cases to the requirements using Requirement coverage tab in Quality Center
Updated the Requirement Traceability Matrix based on the test coverage
Prepared test data and documented test results with screen shots and notes in Quality Center
Requested simulated devices from Devise Anywhere for testing the functionality and integration of the Mobile banking application
Used devise anywhere for testing such as Functional/System, Integration, Regression, End to End, Performance and User Acceptance testing
Worked closely with Developer and DBA in identifying the test environments for test execution of WMS and online banking application.
Executed test cases on different OS and devices to validate the Compatibility of the application by performing Cross platform testing
Reported defects to the development team using Quality center with proper priorities and severities
Provided daily execution and defect reports to QA lead using customized reports from Quality center
Reported and tracked the defects using Quality Center
Provided technical support to the UAT analyst during UAT testing
Regularly participated in Test Review and Status meeting
Provided planning and execution status reports to the management
HSBC, Toronto July 2010 – February 2012
Seibel CRM Application
QA Analyst (UAT)
Siebel CRM, UML, Rational Requisite Pro, Siemens Team center, Java, .Net, PHP, Oracle, MS SQL 2000, MS Access, VNC, SQL Navigator, Rational Clear Case.
The project is about developing an application for Life & P&C (commercial & personal) lines division of an Insurance Client. The application can be used by life insurance and property & casualty insurance lines of business to retrieve quotes, policy conversion and renewal, process underwriting activities, manage claims, commercial auto analysis.
Gathered the BRD and SRS documents from the BA and BSA
Performed Gap Analysis reviews, identified gaps and logged them into MQC and tracked until fixed
Created Test scenarios and Test cases for Data migration, Data Conversion and Online Application Functionality
Automated Regression test suite in Selenium for all the flows in account opening modules of HSBC insurance domain.
Validated reference data in spreadsheets with database using Selenium web driver for clearing and settlement scenarios.
Experience in using TestNG framework in supporting data driven testing for user creation, various transactions in creating insurance product and the whole scenario for completing the transaction.
Executed medium to complex SQL queries to verify the database for the relevant test cases
Used SQL commands to validate the database and test its integration with various modules
Tested reports and ETL mappings from Source to Target
Tested various maps for Extraction of Data from various source systems and loading into Target SQL server Data warehouse and tested ETL Jobs
Performed BO reports testing by performing data validation of BO reports
Provided and reviewed the Test Coverage Matrix and Test cases with the Business users, Business analyst and Development groups and requested their approvals
Performed Smoke, Functional, System Integration, Performance, End to End and User Acceptance testing
Created projects and customized the options for test planning, test execution and defect tracking activities in Quality Center
Customized Quality Center Project entities, project lists, create group, create privileges and setup the work flow for the project
Generated Quality Center reports after customization and stored them as favorites
Generated defect reports for Defect Triage meeting and published updates
Ministry of Education, AB July 2008 – June 2010
Web Portal Application & COTS Assessment System
Quality Assurance Analyst
The technologies used in this project are SDLC, Microsoft outlook, Java, Java Script, J2EE, UNIX, Oracle, XML, MS Access, Microsoft SharePoint, Microsoft Excel, Web Sphere 6.0, Oracle 9i, Quality Center 9.0, Quick Test Professional 9.0, Toad, Crystal Reports 8.5, Web Logic 8.1, Windows XP
Online Web Portal of Alberta Education supports the needs of students, parents, teachers and administrators from Early Childhood Services (ECS) through Grade 12. Using the Online Web Portal the Ministry provides following information to the residents Develops curriculum and sets standards, Evaluates curriculum and assesses outcomes, Teacher development and certification, Supports special needs students, Funds and supports school boards, Aboriginal and francophone education, Management of the Alberta Initiative for School Improvement (AISI), Oversees basic education policy and regulations.
Gathered BRD, SRS and Use Cases for the Web Portal project
Worked as a QA Analyst in testing the Web Portal project and performed gap analysis on the received project documents
Developed test scripts in QTP using three recording modes Normal, Low level and Analog.
Experience in using virtual objects in mapping them to standard classes.
Created detailed Manual Test Scenarios and Test cases according to the Business/Functional requirements in Quality Center
Developed Test plans, recording various test sessions, replay and debug the scripts created, ran the test scripts and analyzed the test results generated in test fusion report.
Worked on optimization of memory and to increase CPU utilization during execution of automation regression test scenarios in ECS and COTS systems.
For Database testing and reference data validation used QTP.
Imported requirements and test cases from excel and word into Quality Center and ensured the completeness of the test cases
Mapped the test cases to the requirements and updated the RTM-Requirement Traceability Matrix document
Prepared test data with the help of DBA and mapped the test data to the test cases for execution purpose
Requested test environment according the test scenario and test cases and performed sanity checks on the test environment
Organized test case reviews with the Business analyst and updated them accordingly
Performed Manual testing for Functional, Integration, End to End and UAT testing for Web Portal project
Executed test cases for Cross browser compatibility on all the browsers
Validated the content on the application and tested the integration between web portal and content management server
Reported defects using Quality Center and generated on demand defect reports
Performed Retesting and Regression testing with the help of HP Quick Test Professional on the new application builds
Provided Status reports to the management by providing test execution and defect metrics