Kiran Bagwan

  • Whippany NJ

Senior QA tester Engineer

Summary

Technical Skills

Operating systems:

Windows 95/98/NT/ME/2000/XP, UNIX Sun Solaris, and Linux

Languages:

JScript, Visual Basic, VB Script, QBasic, Shell Programming, SQL, PL/SQL, COBOL, HTML, XML

Testing Tools:

TestComplete, Selinium_IDE and web driver(MAVEN with ANT build) RestClient, SoapUI, Quick Test Professional WinRunner, LoadRunner, , Silk Test, SQA Robot

Test Management Tool:

JIraQuality Center 11/10.0, TestDirector 8.0

Defect Tracking Tools:

Clear Quest, Rally, PVCS Tracker, Quality Center, TestDirector, Bugzilla.

Databases:

Oracle 7i, 8i, 9i, 10g, My SQL, SQL Server 2000

Application Software:

MS Office 2000(Word, Excel, Excess, PowerPoint & Outlook); TOAD 6.3, SQL* Plus, FLASH, MS Visio, Macromedia, Dreamweaver, Adobe PhotoShop, Microsoft Project

Internet Technology:

Internet Explorer, Netscape Navigator, AOL, Mozilla Firefox

Hardware:

IBM RS/6000, AS400, Sun V880, SunFire 380R, Compaq ProLaint ML370, HP ProLaint DL380, Dell PowerEdge IBM PC, IBM mainframe, DEC/VAX, System Boards

 

Development Methodology

Agile, Scrum, Waterfall

Artifacts

Test Plan, Test Case, RTM, Test Summery Report, Bug report, User Stories, Backlogs

Automation Tool

Selenium WebDriver, Selenium IDE, Selenium RC, Selenium Grid, Cucumber, Gherkin, Quick Test Pro, TestComplete, Eclipse, SCCM 2012R2, MDT, UST, VSTS, CODED UI, APPIUM, PRODUCT STUDIO.

Framework

Junit, TestNG, Page Object Framework, Page Factory Cucumber.

Continuous Integration

Jenkins, Hudson

Performance Tool

HP LoadRunner, JMeter

Test Management

HP Quality Center, SVN , CVS.

Defect Management

JIRA, HP Quality Center

Web Service Tool/Language

SoapUI,  http client 4.4, XML, Gherkins

Programming Languages

Java, Java Script, VB Script, XML, CSS, XPath, POI

Database/Database tools

SQL, SQL Server, Oracle, Toad

Operating Systems

Linux, Windows 7, Windows 10, windows 2008.

 

Work History

Work History

System Engineer

Indian Express Newspapers  india

This is a comprehensive module that incorporates all purchases procedures of a typical purchase department.   The information flow that is handled by this software is Material indent. Purchase Request. Inquire, Quotation, Purchase Order and Delivery, Keeping track of anything in this cycle is for ready information at given point of time is one of the strong points of this software.

  • Involved in creating Test Plan using Business Transaction rules.
  • Developed in writing test cases for various functionalities of application
  • Performed Security testing by entering positive and negative data.
  • Involved in maintenance and improvement of existing scripts.
  • Performed in Regression testing against new builds and functional testing.
  • Participated in the preliminary and final design of Databases and User interfaces.
  • Tested the application manually for its GUI objects and their functionality and reported the bugs by Excel sheet.
  • Win Runner was used to generate automated test scripts for functionality and GUI testing and modified the script using TSL.
  • Performed regression testing for every modification in the application and new builds using Win Runner and Test Director.
  • Checked database to determine successful transaction of test data from the application by establishing database connectivity and by using Oracle SQL commands.

 

Environment:   VB, Java, JavaScript, Oracle, Windows NT, Win Runner, Test Director.

 

Jan 2011 - Aug 2014

Senior SQA Engineer

Financial Engines Inc. Sunnyvale, CA,

Financial Engines is an independent investment advisor to provide personalized advice for retirement.  Financial Engines gives online advice as well as professional management for retirement accounts such as 401(k), IRA as well as social security.

  • Actively participated design reviews of new features; Responsible for the design, development and maintenance of test automation to support automated functional testing.
  • Experience in working on multiple projects from conception to release and maintenance of automated tests.
  • Created and executed detailed test cases and test plans for consumer facing web pages with heavy dynamic data and testing from back end to front end and contributed methods to test infrastructure.
  • Performed manual testing as well as automation and maintenance of new features in Selenium-WebDriver/Java test framework using Eclipse IDE and integrated with Hudson for daily run monitoring.
  • High level experience in testing web applications developed in Sales Force, data syncing between Financial Engines and Sales Force databases using Informatica.
  • Familiar using version control tools such as Perforce.
  • Worked closely with the developers to analyze and find root cause of failures
  • Filing defects and feature enhancements, tracking them to closure; and extending automation tests for bug fixes and enhancements.
  • Member of an agile team to test applications to meet reporting needs for external and internal customers.
  • Strong experience in source to target mapping test between data warehouse and data marts using complex sql scripts and test automation using internally developed tools.
  • End to end testing experience from back end tables to meta data to reports on applications such as BI Publisher, Answers etc..
  • Experience in using pdf automation tools such as Stream Diff.
  • Involved in product end to end development process and worked closely with development team, business analysts, and product management.

Environment: Sql Server, Sql Server Management Studio, Perforce, Eclipse IDE, Selenium/WebDriver.

Dec 2012 - Dec 2013

AWS (Analyst Work Station)

Capital One, Richmond, VA

At Capital one Financial, worked as a QA Engineer for AWS Advantage Solution Universal Life Policy product. This product consisted of different phases, such as Submit, Issue, and Deliver. In Submits the Insurance policies are submitted with the riders and trailers and alter entered if any changes are need to be made and are checked for New Business Edits and Coverage Protection Values. In Issue the major part I checking the policy pint Vs the Spreadsheet for Values and Verbiage. In Deliver the policies are delivered and tested for the monthly added values and Testing.

 Conducted UI testing, Functional testing, Regression Testing, Acceptance testing and verifying the results with expected results, which should complain with the predefined requirements.

  • Used Selenium RC to test web sites and their systematic updates for functionality, usability, regression, performance, browser and operating systems compatibility.
  • Involved in working with JUnit, TestNG and Eclipse.
  • Built automated test-suites using WebDriver Java API / Selenium test suites, JUnit and TestNG. Creating test cases and test suits.
  • Developed and maintained release acceptance tests using Selenium IDE.
  • Analyzed project documentation and provide stakeholders with quality assurance risk assessment.
  • Identify record, track and prioritize defects within the integration and stage environments.
  • Worked in continuous integration environment and deploy code stored in Github to QA environment via Jenkins continuous integration tool.
  • Performed Web service testing using SOAPUI
  • Manages QA process for release candidate.
  • Reports progress to business and development.

 

Environment: Selenium WebDriver 2.38, Java 1.6, Eclipse, TestNg, Jenkins, Agile/Scrum, JIRA, Rally, Toad, Cucumber, SVN, SQL plus, Windows, Oracle11g, HTML

Jan 2010 - Dec 2012

Sr Analyst 

Dollar Financial Corp, Berwyn, PA

The objective of this project is to develop various E-commerce applications and also on RETAIL application. Line of business for these applications is the short term money lending (payday loans).

  • Understanding and analyzing the business requirements
  • Active participation in business requirements review meetings
  • Worked closely with the Business Analyst in analysing the requirements.
  • Work with the business stake holders helping them perform the User Acceptance Testing.
  • Helping the team understand the requirements.
  • Work on analyzing the issues reported by the QA team
  • Sending the QA open/resolved bug report on a timely basis to the product owner
  • Involved in creating test plan, test cases and test scripts
  • Performed the review of defects, test results, test cases created by other QA team members.
  • Reviewed the design documents and assisted Management for sign off from QA side
  • Proven the track record on analysing the production issues
  • Monitoring the production data after each release
  • Handled the testing of complex functionality related to score algorithm
  • Analysing the root cause of the defects before reporting to developers
  • Performed the manual testing, regression testing, smoke testing, UAT testing, back end/data base testing using the sql queries
  • Performed the complex backend testing using TSQL
  • Took initiative for sending the production activity report on a daily/weekly/monthly basis to the business team
  • Involved with the lead in providing the test estimates to the project manager
  • Assisted the lead in managing the testing artifacts like test strategy document, test plan, test cases and testing related status reports for each release and organising them in TFS and also in coordinating/managing the offshore QA resources
  • Wrote stored procedures to pull the data for production reports
  • Giving the updates on a daily basis in stand up/scrum meetings (Agile)
  • Worked on SOAP UI for testing the web services
  • Effective communication with the Offshore QA resources regarding task allocation/completion/follow up.
  • Actively involved in the development related technical discussions
  • Experience in creating scripts using Selenium IDE
  • Unit testing of the stored procedures written by developers for certain complex functionalities
  • Designed and developed automation framework as part of regression testing
  • Performed regression and data driven testing by using TestComplete automation tool
  • Developed Business, Object and generic functions by using VBScript
  • Executing/running the automated scripts before every release
  • End-to-End business understanding of the applications
  • Effective communication with the developers on the issues identified
  • Creating the defects using JIRA/TFS test manager
  • Used Selenium IDE to record and run the scripts for the Ecommerce applications
  • Worked on testing the Point of Sale (POS) application
  • Worked as a QA Lead co-ordinating the offshore-onsite QA resources, task allocation, resource planning, submitting the weekly QA updates to Project Manager
  • Worked as Business Analyst helping the Corporate Services group in documenting the requirements for the Global Work day project
Nov 2008 - Mar 2012

Software QA Project Engineer

Abbott Medical Optics, Inc. Milpitas, California

The company offers the widest range of proven refractive technologies for myopia, hyperopia, astigmatism, presbyopia, cataract, spherical aberration and corneal health.

  • Product validations utilizing BlackBox methodology
  • Architecture, design, implementation and maintenance of test automation framework for AMO iDesign Treatment Planning Software application.
  • Research, evaluation and utilization of TestComplete (Jscript) automation tool for Unit, Acceptance, Data driven, Functional, and Negative, Scale, Stress automated test scripts and test suites.
  • Software Issues identification with following resolution verifications
  • Setup and Maintenance of multiple Test Lab tools, platforms and environments.
  • Design and implementation of installation programs for Treatment Planning software; supporting localized Windows platforms, advanced prerequisites, silent installation process and various script executions utilizing InstallShield
  • Design and implementation of regulatory validation documentation.
  • Design and logistics of uniformed defect tracking system workflows and integration

May 2007 - Nov 2007

Software QA Engineer

Talent6, CA

Served as a team member of the QA group responsible for testing web site that caters to casting & modeling segment. Responsible for testing various web GUI components and features and online documentation. Deliver test plans & test cases.

  • Testing of www.talent6.com – online subscription network created for people interested in participating in casting calls offered all over the North America
  • Develop test cases for designated areas of testing (Extended Network, Message Center, etc.)
  • Execute formal test cases for regression testing of new weekly releases
  • Research software problems and make them reproducible
  • Write bug reports using Mantis application and monitor the status of bug reports
  • Communicate with Project Lead and QA Team members to resolve issues
  • Developed Test plans, Test Scripts based on design documentation and user requirements.
  • Executed Scripts on multiple targets using Quality Center
  • Failed cases were recorded, reproduced, and verified using a bug tracking system.
  • Performed Security Testing to ensure that system is secure of unauthorized access.
  • Performed Screen Navigation Test to ensure that the links are established as per the documentation provided.
  • Performed Data Driven Testing using Excel and database files.
  • Performed Regression testing to verify whether modifications made in the application have not caused unintended adverse side effects.
  • Performed Black Box testing from end user’s perspective without knowing the code.

Extensively used SQL Queries as needed for testing the application

Oct 2004 - Jul 2007

QA Lead

DoITT - NYC.gov

Performed day-to-day management of all the testing phases of the software applications including gathering requirements, designing, developing, testing and suggesting and deploying the solutions:

  • Lead Software Quality Assurance projects and team including hiring responsibilities;
  • Developed, enhance and document methodologies of testing Web based applications as well as SOA;
  • Document, implement, monitor, and enforce all testing processes and procedures that are established as standards defined by the organization and the industry;
  • Plan all resources and schedules functional /regression and performance testing of new and ongoing enterprise Internet-based software applications;
  • Set up and manage usability and browser compatibility testing lab;
  • Configure, maintain and administer enterprise-wide testing and defect tracking tools that have been used by external and internal agency teams (LoadRunner, Quality Center, QTP, SOAP UI);
  • Developed the strategy of preliminary performance and functional tests (POC) of SOA frameworks via webservices and provided training to QA team on this matter;
  • Conducted on-site user training classes.
Oct 1997 - Sep 2000

QA analyst

CheckFree Investment Services

Designed and performed all type of tests, including Y2K testing, installation, functional, regression, automation regression test suite, stress/load tests as well as UAT for a new system APL Plus, which provides portfolio management services and offers wide range of trading tools.

  • Performed functional, performance testing using Rational Robot and load testing using SQA Load Test 6.1, analyzed the data with the help of user-defined functions;
  • Verified bug fixes tracked and reported test execution status to management;
  • Developed test plans, test strategies, test requirements and technical documentation for test procedures;
  • Communicated with business users, developers and project leaders to map out new functional requirements and to determine when new condition required inclusion in existing scripts.

 

Education

Education
1995 - 1997

Bachelor of Computer Science from Bangalore University

Certifications

Certifications

ITIL V3 foundation certified professional.

Undergone Red Hat Enterprise Linux (RHEL) version 4.0 training in Mumbai at Red Hat institute

Microsoft Certified System Engineer (Windows 2003)