RACHNA KAPOOR

919-***-**** ac30km@r.postjobfree.com

CAREER OBJECTIVE:

A position as an active employee, involving responsibility and working with others as a team player to achieve advancement and growth for myself and the company.

SUMMARY:

9 years and 11 months of HCL experience in Quality Assurance (QA), Business and Data Analysis and Software Development Lifecycle (SDLC).

3+ years of experience managing teams as a Test Lead.

Expertise in Manual and Automation Testing on the Client/Server, Web, GUI and database applications.

Strong skills in Database and ETL testing using SQL queries on Microsoft SQL Server.

Expertise: Quality Management: Test Planning, Test Strategy, Test Scenarios, Test Cases and QA Assessments.

Experienced in Waterfall Model and Agile Model Methodologies, Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC), Software Quality Assurance (SQA).

Worked on various complex Business stories in detailed manner, identifying testing scenarios/requirements.

Extensively Involved in Test planning activities, writing Test plan, Business Process understanding and identification of testing requirements, Estimation of Test battery development and Designing of System and Integration Test cases, Design High level Test Scenarios, Test Battery and environment Setup, Test Execution planning and Test execution, Business rule and Business flow Execution.

Providing application business demos presentations to team and client.

Experience in Functional/Non-Functional testing, Smoke/Sanity, System, Integration, End-to-End, Regression, UI Testing, Prototype, GUI and Validation testing approaches. Accessibility Compliance Testing Section – 508 Testing as per W3C Standard guidelines, WCAG 2.0 level AA.

Experience in complex Data analysis and Data calculations.

Defect Management for System Testing and Integration testing levels; excellent analytical skills in troubleshooting software defects, provide user context and testable Information/test data to developers for bug fixes. Logging and tracking of defects to the closure. Worked on root cause analysis for critical defects and prevent them for reoccurrence in the project.

Worked on different Domains – Unemployment Insurance, Mobility Services, Vocational Rehabilitation, Financial Services, Worker’s Compensation, Child Welfare and Inland Revenue, Retail and Publishing, Banking, Marketing and Insurance.

Exposure to Automation testing using Selenium IDE to support UAT for Test data creation.

Experience in making automation test scripts using QTP.

Exposure to Performance testing using VSTS Visual Studio Team Suite and Web-application testing.

Involved in Walkthroughs, Review meetings, DPA activities – Casual Analysis and Preventive action (CAPA) organized and experienced in analyzing Business Requirements, Specifications, Functional Requirements Specifications, Program Specifications and Use Cases.

Experience in Requirement gathering from clients and documentation of the requirement, making BRDs.

Expert in reporting activities per the requirements of management. Creation of daily/weekly Defect Status Reports, Testing Progress Reports / Dashboard and various other reports per project requirements in different formats using pivot/formulae in excel and publish to the management and stakeholders of the project. Expert in excel.

Involved in planning and presentations to the team for various Knowledge sharing sessions.

Experience in offshore/onsite coordination work environment.

Presentation, Technical, Problem solving skills, Analytical Skills with the ability to prioritize tasks and deliver the Quality work under the strict timelines with minimal supervision.

Possess Good Oral and Written Communication skills, Interpersonal skills, Leadership qualities, work independently, good estimation skills, Self-motivated, Proactive, Task oriented, Team player with excellent work ethics and quick learner in new technologies. Worked directly with HCL clients in various projects.

Technical Skills:

QA Testing Tool

HP Quality Center ALM, JIRA, Test Link, Selenium IDE, Selenium Web Driver, QTP – HP Quick Test Professional

Bug Tracking Tool

Bugzilla, JIRA, PM Smart, HP Quality Center ALM

RDBMS

Oracle, Microsoft SQL Server, MS Access, DB2

Programming Languages

C++, Java, Visual Basic, VB Script, Java Script, PL/SQL, .NET

Operating Systems

Windows, UNIX, DOS

Performance Testing Tool

Microsoft Team Foundation Server - Visual Studio Team Suite – VSTS

Application Package

MS Office (MS Word / Excel), Power Point, Microsoft Team Foundation Server

Version Control Tool

SVN, PVCS, Visual Source Safe, RTC (IBM Rational Team Suite), Share Point, Smart

Web Technologies

ASP, JSP, .NET, HTML and XML

Academic Qualification:

•Master of Computer Application (MCA), 2007 %age: 75

Kurukshetra University, India (Major in Computer Science)

•Bachelor of Commerce (B.Com - Computer Vocational), 2004 %age: 70

Kurukshetra University, India (Bachelor in Computers)

Project Experience:

HCL-Harte-Hanks Nationwide Project, Trevose, Pennsylvania, USA Mar’16 – May'17

Test Lead

Client: Harte-Hanks and Nationwide

NATIONWIDE offers a full range of insurance and financial services across the country, including car, motorcycle, boat, homeowners, pet, farm, life and commercial insurance, as well as administrative services, annuities, mortgages, mutual funds, pensions, long-term savings plans and specialty health services. Harte Hanks has been hired to help them with supporting their Nationwide Affinity Solutions (“NAS”) entire process. The NAS process includes populating and creating the Affinity Insights Marketing Engine and matching Affinity Member records to Policy records. This database includes the Affinity Member Repository which holds all the affinity member data, quote /policy data, and campaign selection and history data.

Harte Hanks has implemented a database solution called Affinity Insight Marketing Engine (AIME) for Nationwide. AIME allows for new campaign setup, tracking of key marketing activities, as well as to enable comprehensive reporting and analysis via the creation of an Analytics Mart.

Responsibilities:

•Understand the testing effort by analyzing the requirements of the project.

•Worked on various Change Requests from the customers.

•Creation and updation of Test Strategy document.

•Attend daily Stand-up meetings.

•Creation/updation of Test Cases.

•Execution of Test Cases, complete ETL testing.

•Creation and Execution of SQL queries in database.

•Database Testing, Data Analysis, Data Validation, Data Integrity and Data Manipulation.

•Update daily tasks in Smart and project specific documents in Visual Source Safe.

•Discussion of Testable requirements with business and development team.

•Validation of data that it is transformed correctly from source to target according to system requirements and business rules.

•Performing Smoke, Regression and Sanity testing.

•Attend Retrospective meetings after completion of CRs.

•Defect logging, tracking, closure.

•Assign different CRs to teammates and work with them for any huddles.

•Track status of CRs and provide status updates to higher management.

Environment: PL/SQL Developer, Oracle, HP Quality Center ALM, Bugzilla, JIRA, Smart, ETL, Allink Transact.

HCL-USAA – IPF Project, San Antonio, Texas, USA Sep’15 – Mar’16

Test Lead

Client: USAA

USAA-IPF is solution for Market Stream along with DRM includes - Point Forward Staging – Funnel, Product, Member, household, SOR, FIH Processing – Funnel, Product, Member, household, SOR and Data Loads to Market Model BSO, Historical Data Processing and Loading, FIH Externals - FIH External Results for Market to Market Reporting, FIH External Results for Market to Legacy, Market Forecast to FIH External Results, Market Forecast To Other Hyperion Apps, Reporting Cubes.

Workforce Stream along with DRM - Supply and Pricing – Dimensions, Properties, Mapping, Connections to Legacy, Transfer to FIH Processing and Supply – Dimension Security Process, Contact Center Supply – Dimensions, Properties, Mapping, Connections to Legacy, Transfer to FIH Processing, Call Center Model, Reports, Security Process, Supply, CC and Pricing Model. Data Work – Workforce FIH Calcs, Workforce Actual, Separations Model (SAS), Benefits data, Workforce Actual Dollars (PeopleSoft), Load data from FIH to Planning.

Responsibilities:

•Creation and updating of Test Plan and Test Strategy document.

•Worked on Agile Methodology – Attend daily Stand-up meetings and giving updates for my daily tasks.

•Take daily call with offshore team to discuss daily updates and tasks.

•Add/update QA Tasks, Test cases in Quality Center ALM.

•Execution of Test Cases.

•Creation and Execution of SQL queries in database.

•Handled defect triage meetings with clients and team in meetings.

•Update daily tasks in IBM RTC and add/update project specific documents in Share point.

•Discussion of Testable requirements with business and dev team.

•Coordinate with onsite and offshore team and assign them daily tasks to do.

•Communicate test status updates to management team in daily stand-up meetings.

Environment: ETL Tools - Datastage, Informatica, Hadoop, Unix and control-M, DRM, Hyperion Planning, SQL Server, Oracle, HP Quality Center – ALM, HP QTP, DVO, ODI, IBM Rational Team Concert.

HCL - WyCAN Consortium, Cary, NC, USA Jan’14 – Aug’15

Test Lead

Client: WyCAN

The charter for the WyCAN Project is to implement a common, integrated, Unemployment Insurance benefits and tax system for the WyCAN Consortium. To achieve this purpose HCLA will configure and customize the iGOVERN; Unemployment Insurance System product in accordance with WyCAN requirements. The product will interface with supporting applications and agencies and the implementation will include the conversion of historical UI data from each WyCAN state. HCLA will provide a scalable, multi-tenant architecture and will host and support the system using the Software as a Service (Saas) model. The project scope includes the customization, implementation, and deployment of the functionalities as further described in the WyCAN MSA Exhibit B--SOW FINAL document. For additional scope points that are traditionally captured in a project charter or a Statement of Work, please refer to Exhibit B of the MSA.

Responsibilities:

•Creation of Test Strategy document and Test Schedule plan in MPP for various modules

•Estimation and assigning of Extensions and requirements for TC writing to team

•Created automation scripts using Selenium IDE and executed for functional testing and User Test data creation

•Creation and Updation of Extensions Test cases

•Creation and Updation of Test Scenarios

•Preparing Test Strategy document

•Tracking the Test Scenarios and another activities with functional team

•Discussion and understanding the Extensions for iterations

•Writing Test cases for Extensions and Review Test cases

•Execution of Product Test scenarios and Query Handling

•Product Testing for various modules

•Defects logging using Bugzilla and PM Smart.

•Creation and Updation of Smoke Test Cases

•Created and Updated modules RTM.

•Created Test scripts using Selenium IDE and Execution of scripts for Business Rules and UAT Test Data creation.

•Support Functional Team with client in UAT.

•Mentoring and managing three juniors for their daily activities.

Environment: JAVA/J2EE, Spring, Hibernate,Webservices, HTML, javaScript, jQuery, PM Smart, Bugzilla, Testlink, Jama Contour, Oracle PL/SQL,FileNet, Mule, jTest, ActiveMQ, Selenium IDE, HP QTP.

Unemployment Insurance Project, Cary, NC, USA Dec’10 – Dec’13

Client: Virginia Employment Commission

Senior Test Engineer

Unemployment Insurance is a program composed of both federal and state laws. While the federal government has provided a UI framework, each state has implemented their own laws, regulations, rules, polices and interpretations which are as unique as snowflakes in a snowstorm. Because of this federal state partnership, UI is laden with acronyms, legalese, form numbers and professional terms specific to the industry. In addition to helping workers and their families, the Unemployment Insurance programs play a key role in helping businesses, communities, and the nation's economy.

Responsibilities:

•Test Battery Creation, Test Battery Setup, Test Execution planning, Defect Management for at System and Integration Testing levels for Functional Testing; Database Testing; Query Optimization;

•Performance Testing; UI Testing; User Experience Testing; SaaS enablement, Operations testing; for enterprise web applications and mobility applications

•Section 508 accessibility Testing using standard and complete guidelines from customer.

•Understanding of Business Requirements and identification of testing requirements.

•Test Planning activities.

•Database Testing

•Batch Jobs Testing

•Defect Management for at a system and integration test levels

•GUI Testing

Environment: ASP.NET #.5, Microsoft Team Foundation Server Visual Studio 2008, Eclipse3.1, jdk6.0, JDE5.0, BB8900 Simulator, Microsoft SQL Server 2005, JAWS, WCF, and WINDOWS SERVICE, BIRT Report viewer.

CWAP-NIMP Project, Gurgaon, India Feb’10 – Nov’10

Client: Cable and Wireless

Senior Test Engineer

The Mobile and Remote Working Interface (MRWI) solution for UK Police frontline field service automation. The solution enable frontline field personnel to work efficiently from field locations by communicating securely with the back-office information systems, post real-time information to the back-office systems and get up-to-date information from the back-office systems using Laptops, Desktops, Tablets and Hand-held computers or Mobile Phones (PDA / Smart Phone) through secured channel. This solution is designed with Service Oriented Architecture (SOA) in order

Responsibilities:

•Test Battery Creation, Test Battery Setup, Test Execution planning, Defect Management for at System and Integration Testing levels for Functional Testing; Database Testing; Query Optimization;

•Performance Testing; UI Testing; User Experience Testing; SaaS enablement, Operations testing; for enterprise web applications and mobility applications

•Testing web services (REST API’s) SOAP UI.

•Understanding of Business Requirements and identification of testing requirements.

•Test Planning activities.

Environment: ASP.NET #.5, Microsoft Team Foundation Server Visual Studio 2008, Eclipse3.1, jdk6.0, JDE5.0, BB8900 Simulator, Microsoft

DRC (Dynamics Research Corporation), Gurgaon, India Apr’09 – Dec’09

Client: State of Nashville

Senior Test Engineer

Statewide Automated Child Welfare Information Systems (SACWIS) is a comprehensive automated case management tool that meets the needs of all staff (including social workers and their supervisors, whether employed by the State, county, or contracted private providers) involved in foster care and adoptions assistance case management which is being developed by DRC for the state of Tennessee. SACWIS facilitate the delivery of child welfare support services, including family support and family preservation.

Responsibilities:

•Designing of High Level Scenarios.

•Designing of System and Integration Test cases.

•Logging and tracking of defects.

•Test Planning activities.

•Understanding of Business Requirements and identification of testing requirements.

•Test Battery Creation

•Test Battery Setup

•Test Execution planning

•Database Testing

•Query Optimization

•Performance Testing

•UI Testing

Environment: Oracle 10g, Crystal Report 11, Business Object, Eclipse, Jboss, CVS, TOAD, VSS, VSTS 2008, TN SACWIS.

WCS (Worker’s Compensation System) Project, Gurgaon, India Apr’08 – Mar’09

Client: State of Columbia

Senior Test Engineer

WCS is the Worker Compensation System for Internal and External users for the claim processing and online submission of claim request. WCS application will be a web based application, accessible to users within the DOES network and users outside the network. The internal user list is as per the existing DOES users maintained in the Active Directory. Whereas, the external users, needs to register themselves first with the WCS application. The registered external users, including the Attorneys, Insurance Carriers, Self-Insured Employers, Third Party Administrators and Employers would then be able to submit forms online.

WCS application will share the same database currently being maintained for CORE application. In order to meet user requirements, the WCS application will add/modify to/the schema of CORE application when and where required. Thus ensuring, any modifications done to the master data, using CORE, will be available to the WCS application users at the same time.

Further, WCS application will make use of the existing FileNet Content Management Server to store and retrieve documents. FileNet CS, comes with an enrich feature of indexing and versioning, thus different version of the same document will be maintained in FileNet. WCS application will always be retrieve the latest version of the document. Though, the administrator of FileNet will be able to retrieve the older versions of the document, but retrieval of older versions of the document from FileNet will not be in scope of WCS application.

Responsibilities:

•Requirement gathering from onsite team.

•Plan and given KT sessions to testing team.

•Designing of High Level Scenarios.

•Designing of System and Integration Test cases.

•Logging and tracking of defects.

Environment: VB, ASP.NET, Microsoft SQL Server 2000, Windows 2000, Windows Service, EDF framework, Filenet.

NV-NCCS Project, Gurgaon, India Nov’07 – Mar’08

Client: Department of Human Resources (DHR) Welfare Division, Nevada State

Test Engineer

The Department of Human Resources (DHR), Welfare Division has contracted the work of developing and implementing a comprehensive web based childcare system called the Nevada Child Care System (NCCS). The NCCS is a resource referral and subsidy management system for the Child Care Program. The system will administer childcare funds for eligible parents in Nevada, and support the collection, storing and reporting of information to the federal government. It will determine participant eligibility, provide resource referrals, process attendance rosters, provide case management capabilities and authorize payments to childcare providers. In addition, the system will be designed to interact with existing Welfare databases, provide data and reports, and send notices for the Child Care Program.

.

Responsibilities:

•Testing of the project.

•Execution of Test cases.

•Execution of Business Rules,

•Filing and Tracking defects in PM Smart.

•Creation of Daily Defect Status Reports / Dashboard

Environment: Java, J2EE, AIX, Novell I-Chain, Adobe Form Server, FileNet PE and FileNet CE.

CO-RISE (Rehabilitation Info. System for Employment), Gurgaon, India May’07 – Nov’07

Client: State of Colorado

Test Engineer

Department of Vocational Rehabilitation (DVR), intends to design and develop web based computerized management information system to enhance information flows and coordination.

The scope of the application is to provide mechanism for capturing data of Cases and their workflow as Case Management System and track their status. The system will also generate various analytical reports in Management Reporting for Federal / DVR / Client users.

Responsibilities:

•Understanding of Business domain and Requirement.

•Testing of the prototype.

•Writing of Test Scenarios

•Test case writing

•Execution of Test cases in Test link.

•Execution of Business Rules.

•Filing and Tracking defects in PM Smart.

Environment: C#, ASP.NET, Microsoft SQL Server 2000, Windows 2000, Jaws and Dragon.

Contact this candidate