Harika Keshetty
abh2wg@r.postjobfree.com
SUMMARY
Over 8+ Years of experience in managing software requirements throughout the different phases of
software development life cycle (SDLC) including requirement engineering, design, analysis and
Quality Assurance of Client/Server, Multi-tier, Web based applications as Functional and
Automation Tester.
Experience in working with projects built using various SDLC methodologies including Waterfall,
Agile/Scrum.
Experience in writing System defining test cases, developing and maintaining test scripts and
documenting all phases of QA process.
Experience working with HP Quality Center for Test Management and SeleniumWebDriver for
Automation Testing.
Experience in Database testing &ETL Testing, running various scripts, queries & stored
procedures.
Involved in both Black Box & White Box testing of various functional components.
Excellent Product Development & Testing experience in building the applications, which handles
Project Management, Requirement Management, Workflow Management, Build and Release
Management, Quality Management and Configuration Management.
Proficient in developing Test plans, writing test scenarios and conducting various kinds of testing
like System, Integration & Regression.
Expertise in system analysis, design, coding, bug fixing and troubleshooting.
Experience in testing database applications of RDBMS in ORACLE, SQL Server& ETLs.
Development experience in JavaScript, ASP.Net, HTML, DHTML and IIS.
Expertise in working with Configuration Management using TFS, Visual SourceSafe.
Hands on experience in preparing workflow diagrams, test case requirements from Scenario Lists,
Use Cases, Business Process documents.
Excellent Team Leading, Inter-personal and Communication skills.
Good skills of taking responsibility with an open-minded & hard working nature.
TECHNICAL SKILLS
Languages : C, C#, VB, VB.Net, Core Java.
Technologies : ASP.Net, Web Services, AJAX, XML, JavaScript, VBScript, HTML,CSS
RDBMS : SQL Server 2000/2005, ORACLE 9i.
Tools : Clear Quest, Test Manager, Quality Center, Selenium, Team Track,
Java, Load Runner, Winrunner, Visual Studio, Soap UI,
Microsoft SQLServer Query Analyzer and Microsoft Office.
Reporting Tools : Crystal Reports.
Configuration Tools : Team Foundation Server, Visual Source Safe.
EDUCATION:
• Bachelors in Technology (Computer Science and Engineering) from J.N.T.University, India.
PROJECT DETAILS
United American Insurance - TorchMark Jan 2013 to Till Date
Sr. QA Analyst.
Lead Management System is a web application which allows agents to map their leads into mobile
devices. It has various capabilities from lead Assignment, status updates, scheduling lead
appointments, Lead Resolution, Call Capture and review for Agents. Developed Web Application works
on various devices like Desktop, tablet & mobile. Application is built on responsive design.
Responsibilities:
Understanding the application Requirementsfrom Business Requirement Specifications and
analyze the functionality of the application and the business logic.
Involved in preparing the high level Test Plan and developed Test Cases in accordance with the
functional specifications.
Responsible for doing the Manual Testing of various web pages in the application on different
browsers and devices.
Performing High level Functional and Smoke after the Production update. Responsible for
Functional and End to End testing.
Involved in database testing by executing various SQL Queries for data persistence using SQL
Server 2008.
Mentored ETL staff in developing data warehouse load jobs, in staging data from mainframe files to
flat-files for discovery profiling Leverage enterprise tools to schedule, automate and monitor ETL
processes.
Involved in mobile testing using Chrome Emulators to support for iOS, Android.
Prepared all test data to run all the test scenarios in staging before pushing into production.
Actively participated in weekly sprint meetings and daily standup meetings as part of agile
methodology.
Automated test scripts using Selenium with Firebug and Firefox Add-ons (XPath Checker, XPather
andJavaScript) to enhance efficiency of IDE testing.
Involved in testing flow of data in multiple applications that synced with the mainframe based
application for data integration
Used java and Javascript for automation script development in Selenium.
Worked with Quality Center for creating & managing Test Cases.
Tracked and logged defects in Quality Center and coordinated meetings with developers and
business analysts to prioritize the bugs, bug fixes and problem resolution.
Performed GUI, functionality testing, System Testing and Regression testing.
Worked closely with build integration team, business analysts and developers in order to perform
testing activities as per schedules.
Preparing Bug/Defect Reports, bug Tracking and Defect Analysis.
Involved in Change Control and Version Management for the project documents using
TeamFoundationServer.
Environment: Windows8, MS Office, QualityCenter, Selenium Webdriver, Test Manager, VMWare,
SQL Server 2008, TeamFoundationServer, C#, IE 11, Chrome, Firefox.
DMCS (Debt Management Collection System) - ACS – Xerox, MD Oct’ 10 –Dec 2012
SQA/ETLTester
Debt Management Collection System provides a storage, retrieval, and editing of debtor information
anduses this information to collect defaulted accounts. Information may be collected as part of
the student loan application, processing, collection, and disposition of the account.
This information is available through a Customer Information Control System (CICS) online
system allowing ED, the NPC, the commercial collection agencies, and the FFEL Production
Staff access to the data.
Responsibilities:
Involved in Requirement Gathering & Analysis and prepared the Detailed Requirement
Specification with all the Use Case Scenarios.
Involved in writing and executing the Test Cases as per the Requirements.
Worked with Quality Center & Test Manager to write all the Test Cases.
Ran various ETL Jobs using batch files and made sure data has been recorded properly in
database by executing various complex queries.
Followed agile methodologies and Test Driven Development.
Involved in verifying the various data points of the application and database testing using Oracle.
Involved in writing SQL Queries using complex joins to verify & validate the data.
Involved in Major functionality Testing & Integration Testing in various environments.
Working in close coordination with Business Users to resolve issues arising during functional
requirements analysis.
Test Scripts were written in Excel and then imported to Quality Center.
Used Clear Questfor logging, tracking & updating the status of defects.
Managing the test plan, test cases and defects through TeamTrack and generating necessary
status reports through QC to gauge the overall testing progress.
Categorized bugs based on the severity and interfaced with developers to resolve them.
Involved in Change Control and Version Management for the project documents.
Environment: Windows7, MS Office Suite, Quality Center, Test Manager, ClearQuest, VMWare,
Oracle, TeamFoundationServer, TOAD, Oracle, Java.
LMS - Countrywide Home Loans – Bank of America Aug2009 – Sep 2010
Senior QA Analyst
Lead Management System was conceptualized in order to automate the process of managing Leads
who are looking for mortgage loans. There are two ways Lead can come through system either
Inbound/Outbound. This system is developed as a Web Application which consists of complex workflow
& business logic involving Lead Entry, Lead Assignment, Scheduling& Resolution.
Responsibilities:
Developed test plan based on Business Requirements and functional specifications.
Prepared detailed level test cases and scripts covering all the functionality of the application. These
test cases comprised of detailed steps, expected results, actual results, & test conditions.
Involved in entire testing process like Planning, Preparation, Execution and Completion.
Responsible for writing test cases for functional, regression, system, integration, end to end and
black box testing.
Used SOAP UI for testing Web Services, inspection of WSDL files, generation of SOA envelopes,
and acceleration of many other common XML tasks encountered during development of Web-
Service enabled applications.
Involved in positive, negative, Cross platform and Cross browser testing manually.
Responsible for maintaining test cases and test scripts for the application using Quality Center.
Used quality center for defect tracking and maintaining the test documents.
Created and manipulated SQL expressions in Oracle to support the validation of test results and
creation/management of Test Data and performing Back-end Testing.
Prepared and submitted reports to Project Management on a daily basis.
Performed Component testing, Functionality Testing, Integration Testing, Data validation testing,
Regression Testing in UAT.
Involved in Change Control and Version Management for the project documents.
Environment: Windows7, MS Office Suite, Quality Center, Test Manager, ClearQuest, VMWare,
Oracle, TOAD, Oracle, Java.
Viper - Countrywide Home Loans – Bank of America Jan’08 – Jul’09
QA Analyst
Viper is an Enterprise Management Tool which is a highly scalable and customizable solution that can
be adapted to meet the specific needs of your Enterprise. It helps in managing change from concept to
delivery of a software product, project or a solution. While minimizing the need for manual intervention it
seamlessly integrates the business processes and human resources impacted by the change.
Responsibilities:
Analyzed user requirements and technical specifications in order to develop overall quality Test
Plan.
Coordinated the System Testing, Unit Testing and Integration testing as per specifications. MS
Visual Source Safe was used for Version Control purpose.
Created detailed level test cases and scripts covering all the functionality of the application. These
test cases comprised of detailed steps, expected results, actual results, & test conditions.
Performed integration, system and regression testing. Regression testing was conducted in order to
ensure that there is no impact on previously released software.
Tracking Defects using an Online Error Tracking system, maintaining test metrics and analyzing the
test results. Rational Clear Quest, MS-Access and MS-Excel are used for the purpose.
Generating Test plan and creating test scenarios based on the Use Cases in coordination with the
Development team.
Mapping requirements with the test scenarios and creating the traceability matrix to ensure the
thorough coverage.
Created Test Coverage plan and schedule by identifying individual tasks, primary responsibilities of
fellow team members, worked on daily and weekly deliverables, contingency plan for high level
testing etc.
Environment: Windows XP, MS Office 2007, C#, SQL Server, Visual Source Safe.
Project: A-Boss Sep’06 – Dec’07
QA Engineer
A-BOSS is software solution system; A-BOSS is designed& developed to meet the needs of Small &
Medium Size with “make and sell” concept in business organizations. A-BOSS is an ERP framework,
flexible and adaptable enough to customize the specific needs of enterprises in different business
environment. It is designed to cover all the functional areas of the enterprise and serve as an effective
decision support tool for management in terms of man, money & material management.
Responsibilities:
Conducted comprehensive analysis of the client’s business thoroughly and put together business
proposal documents based on the interaction with client’s staff, specific industry’s best practices
and customers.
Managed various client deliverables and project documentations such as Business Process
Models, Workflow Diagrams which were used iteratively for many projects.
Created Requirements Traceability Matrix using Microsoft Excel to make sure that all the
requirements have been covered by the Development team and finally putting together test
scenarios based on it.
Performed System Integration, Smoke Test, Functional, Positive and Negative, Regression,
System and End-To-End tests for various client applications.
Environment: Sql Server 2000, HTML, MS Office 2003, MS Access, Mercury Test Director.