Profile Summary:
Software Test and QA engineer with 6+ years of experience in the field of SDLC (Software development Life Cycle) and STLC (Software Testing life cycle) with an earned reputation for meeting demanding deadlines and delivering critical solutions on various levels of Quality Assurance for Client/Server and web based applications in Financial, Health and Insurance, Pharmaceutical industries. Having onsite experience.
Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Testing and Implementation of Quality Software.
Experience with HP Tools such as QTP, ALM/Quality Center.
Testing of GUI and Web based applications on Windows platforms.
Experience in Testing and Analyzing Requirements, Test Plans, Technical Specifications, Test Strategy, Test Scenarios, Test Cases, System Specifications, Use Cases, Test Summary Reports, Bug Reports, Track Report and Traceability Matrix based on business requirements.
Effective at bug tracking, analysis and reporting tools like HP Application Lifecycle Management (ALM), Quality Center, and JIRA.
Hands on Experience with Selenium Web Driver Automation testing tools.
Hands on Experience with Mobile application testing, cross browser testing. Awareness of various mobile testing tools like Native Driver, Cucumber, Gherkin etc.
Expertise in execution of Test cases, Data Validation and Verifications, System Testing, System Integration, Regression, UAT.
Coordinate web application functional testing pre tasks. Ensure functional test requirements received. Develop product specific functional test plans.
Experience in object oriented programming, system analysis, requirements analysis, implementation and testing.
Worked with Waterfall Methodology and having knowledge of V Model and Agile methodologies.
Well versed with defect tracking tools ALM/Quality Center.
Expertise in writing and executing SQL Queries, Querying the database using SQL to check out for successful transactions.
In-depth knowledge of SQL for back-end testing.
Thorough understanding of Relational Database Management Systems (RDBMS).
Experience in Testing Web Services with Soap.
Quick learner, good organization skills and a committed team member.
Smart in mastering new skills and adapting to new tools and ever changing technology.
Skill Set:
Testing Tools : Quick Test Professional (QTP), Application Life Cycle Management (ALM), Quality Centre (QC), Selenium IDE & Web Driver.
Test Reporting Tool: : JIRA, Application Lifecycle Management (ALM), Quality Centre(QC)
Operating Systems : Windows 95/98/XP, Vista, UNIX, Win Server 2003, 2008.
Languages : Basic familiar with JAVA, VB Script, Java Script, HTML, XML
Databases : SQL 2000 and 2005, 2008,MySQL
Education:
Bachelor of Science in Chemistry
MS-CIT (Maharashtra State Certificate in Information Technology)
Work Experience:
Client: CITI Bank, Denver July 2015 – July 2017
Position: Quality Engineer
Project Details:
Citigroup's Global Consumer Group serves consumers through retail banking, cards, and consumer finance, providing a full range of innovative and comprehensive products and services. As one of the largest credit card issuer for consumer it provides wide range of services to its client through web based portal tailored to their needs. Worked on Online portal for bill central service which provides a centralized location to set up, view, edit, and manage single payments and/or recurring payments to various merchants using client's eligible credit cards that are linked in the system. Also worked on the retail banking program which helped client onboarding with various banking products, provided clients with account services like, statements, bill pay, online payments, electronic fund transfers(Bank EFTs) and wires.
Roles and Responsibilities:
As QA Engineer, my key responsibilities were as given below:
Created Test plans, managed team members, assigned tasks and conducted meetings.
Created test data for specific Test Cases, executed manual test cases, documented results and updated defect-tracking systems.
Identified test cases after going through the documents provided and developed systematic procedure for each test case and reviewed the test cases.
Extensively involved in all phases of SDLC (Software development Life cycle) and follows Agile methodology.
Involved in extensive DATA validation using SQL queries and back-end testing
Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the ALM.
Used SQL for Querying the Oracle database
Worked on Functional Testing of City for Citi Payment Web Application.
Used Quality Center/ALM for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking
Developed test cases for function, system, regression, end-to-end Testing,
Used ALM for writing test cases and linking them to functional specs.
Entered and maintained defect information in Defect Tracking System, JIRA.
Executed appropriate tests to ensure the application and integrating systems perform to the expected specifications and analyzed test results.
Performed End-to-End (E2E) Integration testing of the application.
Analysis of Test results and defects to estimate progress on a daily basis.
Open and Track defects using ALM and also worked as Defect Co-coordinator.
Participated in various meetings and discussed enhancement and modification
Participated in daily meetings to discuss defects, issues and risks of project
Organized and participated in final walk through with customers.
Performed Defect Management in HP ALM and prepared Test Summary Report and product defect metrics.
Organized and participated in triage for defect resolution and conflicts during system test.
Provided risk analysis of the system test defects to the management and helped to prioritize issues.
Technologies: Java, Eclipse, HTML, XML, HP, QTP, SOAP UI, Agile, ALM, SQL Server, Oracle, Windows 7, JIRA, MS Project, CSS.
State Farm Insurance, Sep 2014 – Apr 2015
Mobile QA Tester
Project: ICP (Integrated Centralized Platform) Customer Communication -Standardize customer facing document content and format, provide infrastructure to design, manage, compose, and assemble customer communications. Provide the delivery mechanism for paper and electronic versions (online and mobile) of all customer communications. Provide customers with access to a library of electronic documents that can be printed/forwarded on demand; and provide customers with the ability to respond to State Farm requests electronically.
Responsibilities
As a QA Tester for Customer Communication project of Integrated Centralized Platform using Agile methodology was responsible for:
•Execution of Smoke, Functional, System, Regression, Integration of End to End testing, JAVA Automation framework in Selenium Web driver for regression & cross browser testing.
•Create Test cases, regression and automation test scripts.
•Participate in daily scrum and all Retrospective meetings & resolved impediments for the team.
•Worked on iCloud based Perfecto mobile testing for IOS and Android application.
•Analysis of Test results and defects to estimate progress on a daily basis.
•Defect Triaging, support UAT, coordinated onsite-offshore model.
Environment: Selenium IDE & Web Driver, Visio, Oracle 10g, Java, HTML & XML/X-Path, SOAP UI, Windows 2000, IBM DB2, Win SQL Pro.
Client: BCBS, Pune India. Oct 2013 – Aug 2014
Position: Quality Engineer
Project Details: The Blue Cross Blue Shield Association (BCBSA) is a federation of 36 separate United States health insurance organizations and companies, providing health insurance to more than 106 million Americans. Worked on the Project for exchanging patient records between various Health Care Providers.
Key Responsibilities:
Analyzed the Business and System Requirement Document (SRS), explained requirement to team members and review Test Cases, Test Strategy created by Team Members.
Defects validation and manual test cases execution and m test scripts using JAVA in Selenium Web driver for regression and functional testing.
Responsible for complete manual testing of application under test (UAT)
Written SQL queries for data validation and to verify the extract rules
Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
Performed black box/functional testing, regression testing on Application Under Test
Performed manual testing on various modules of the Application
Did extensive backend testing using SQL, UNIX and PL/SQL
Written SQL queries for data validation and data verification
Executes the test suite to identify regressions and unexpected side effects
Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing for all ETL feeds
Monitors test coverage and achieves high coverage using branch coverage analysis.
Analyzed, reported and kept track of defects using ALM.
Technologies: Data Stage 6.5, Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, XSD, VSAM Files, JCL, MVS, ISPF, Web Services, SOAP, Manual Testing, Selenium IDE & Web driver, JAVA, Firebug, Developer Tool, ALM/Quality Center, Oracle, Java, Servlets and Java Script.
Client: All State Insurance Company, Mar 2013 – Sept 2013
Position: Test Engineer
Project Details: Allstate is one of the National Insurance companies in USA handle various insurance like Auto, Home, Business, Flood and life Insurances and offer various plans for these. The Current application is used by the sales advisors, prospective customers and allows them to quote and create sales illustrations various products. The project has been developed using Java/ J2EE technologies, Web Services on WebSphere application server.
As Test Engineer, my key responsibilities were as given below:
Responsible for preparation of Test cycle/progress reports, analysis of defect metrics.
Involved in Manual testing using Quality Center to develop Test Cases, Test Scripts, executing the Scripts and logging the Defects.
Created the tests that have no user interaction as a set and executed them as Batch tests.
Executed SOAP based web services API testing (Java client and SOAPUI).
Used XML files in Sending/receiving XML requests using SOAPUI.
Defect logging and tracking using Mercury Quality Centre (QC) and updated the test defects status with results.
Involved in testing of web application.
Documented and reported all found defects in Quality Center.
Data Validation and testing SQL using Toad.
Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
Participated in Agile software testing process with regular QA meetings to discuss major features of the application, test cases to write and execute.
Closely involved with development team, maintenance team and business team regarding changing requirements, builds and releases.
Technologies: Java, J2ee, IDE, Web Driver, x-Path, Eclipse, Maven, Web Services, SOAP, Soap UI Testing, Oracle, HTML, Java Script, Agile, SQL Navigator
State Farm Insurance Dec 11– Feb 13
Quality Analyst
Description: The ECHO is a Web Based system used by the State Farm Agents to provide an Auto Insurance Quotation to the prospective policyholders. To the prospective policyholders, the quotation would be primarily based on his driving history and is subjected to various discounts and coverage’s based on eligibility and the final premium to be paid would be calculated. Rate changes were administered periodically across all the states.
Responsibilities:
Manipulating the fields, creating Policy Requests, computing ARQ
Creation of work assignments which triggers different processes.
Reporting the defects, any deviations in the proposed workflow using Quality Center.
Writing exhaustive Test plans and cases to test missing objects for every Profile.
Gathering Test data and setting up test environment.
Testing the computation of Auto Rate Quote based on Discounts and Coverage’s.
Developing Test scripts.
Database Testing using SQL
Regression Testing
System Testing.
Prepare Defect statistics based on test results.
Testing the computation of Auto Rate Quote, Enhancements and implementing rate Changes periodically.
Developed weekly Test Metrics for senior management using MS Excel
Executing the Regression tests periodically whenever a rate change was done
Performing the rate change for a pilot state and then implementing the same in other states as well.
Testing the data flow between different processes and or teams.
Environment: .NET, VBScript, SQL, QTP 9.2/QTP 10, HP Quality Center 9.2/10, Hybrid Framework
Client: Health Markets, India Mar 2011 – Nov 11
Position: Quality Assurance Tester
Project Details:
Health markets Provides Health Insurance for the individual, self-employed and small business markets. Worked as QA Analyst involved in various health care applications like Eligibility, Creation of New Business Policies, Claims processing, Billing, Primary Reprising and Customer Complaints Management System.
Key Responsibilities:
Reviewed Business Requirements, Functional Requirements, along with the user groups, Business Analysts, Development teams and test teams. Provided QA feedback on the requirements in discussion.
Provided Sign off on the deliverables at different stages.
Prepared the Test Plans and the Technical Docs for the Testing Process and the Test Strategy and Contingency Plans.
Participated in Inspection and walk through sessions of the project requirements.
Completed early identification and resolution of business and/or project issues affecting delivery.
Prepared Risk Analysis and Mitigation Plans for various Test Phases.
Developed SQL scripts to test the table structures, data validation and table columns.
Involved in Regression testing to make sure the system meets the project goals.
Technologies: Java, PL/SQL, Web Logic, XML, Clear Quest, UNIX Shell Scripting, Silk Test and Windows Vista/XP.
Client: Prime Pathology Laboratory, India Aug 2010 – Feb 2011
Position: Quality Engineer
Project Details: Hospital laboratory management Project was to improve laboratory efficiencies, Reduce costs of managing test procedures. It was aimed at increasing productivity through standardized lean process improvements, Application was used to manage patient data from all stages of medical processes and tests. Also was used to coordinate varieties of inpatient and outpatient medical testing, including hematology, chemistry, immunology and microbiology. It also had other common features that manage patient check in, order entry, specimen processing, result entry and patient demographics. Patient data come through web service. We pulled that data and store in a database. We keep the records of various lab tests which are given by patient. We have maintained the lab records and Test results of patient. We stored that dada in the database. It contains patient information, test results, operative and pathology results. This system was built for greater end user satisfaction
Key Responsibilities:
Managed enterprise resource planning Hospital laboratory management software.
Arranged meetings with users to discuss project requirements to perform testing for different modules such as General Configuration, Patients Management, Diagnostic Reports, Inventory, Employees, Accounts, Bar Coding and Administration & Utilities module.
Understanding Client Requirement.
Developing test cases to test the complete functionality of the application.
Involved in the GUI testing, regression testing and functional testing.
Reporting Bugs.
Defined project scope, goal, and deliverables, Tracked defects and reported Bugs
Testing in testing management tool Test Director and HP QC. QC 9.0
Technologies: GUI, Windows 2000, MS-SQL Server, DB2, Test Director, HP QC 9.0
Other Qualification:
Certified Course of Diploma in Medical Laboratory Technology
2 Years of Experience in Medical Laboratory (2008 -2010)