Rachana Agrawal

  • Gurgaon Harayana
Rachana Agrawal

Test Manager

Summary

Result Oriented QA Test Lead with more than 10 years of professional experience in Investment banking(Trade Life Cycle, Derivatives, Money Markets,FX) and shipping domain with an extensive background in quality assurance, requirement analysis, system integration and testing Methodologies.

Hands on in designing Test strategy, traceability matrix, developing and maintaining test cases and documentation in both manual(Big Data, Database, Data ware house, Coherence application) and automation testing

Ability to train, lead and motivate team members. Excellent self-starter and ability to do multi-tasking, prioritize difficult project to maintain highest quality while reaching the timeline. Very proactive, results-oriented, fast learning are some of the core strengths.

Work History

Work History
Jun 2010 - Present

Test Manager

Royal Bank of Scotland

Responsible for managing entire QA process for every releases,  which includes defining test objectives, designing test Plan, integration testing and UAT sign off.

Responsible for Preparing traceability matrices, daily reports to improve quality processes and develop successful estimation model.

Managing a team of 15 people. Defining the test strategy which include effort estimation, risk mitigation. 

Ensure the Quality Assurance with continuous deployment.

Responsible for one click deployment to all environment including UAT and PROD.

Responsible for maintaining regression pack and automate it with every release and save time of regression cycle. 

Oct 2004 - May 2010

Test Lead

Tata Consultancy Services

Responsible for Execution of the test cases as well as to detect the problems in the existing system to minimize the defects in final deliverable product. Logging, tracking, and verifying defects using Mercury Quality Centre.     

Skills

Skills

Business Domain

Have worked in investment banking(Trade Life Cycle, Money Markets, derivatives, options) and Transport domain(Shipping).

Test Management Tools

Worked on JIRA, Quality Centre  for end to end test management including writing test cases and generating test reports

Test Automation Framework

Hands on experience on automation  tool which includes daily execution on regression test pack on latest code base to get early feedback.

Database

Oracle 9i/10G,  Sysbase

Test Management

Extensive experience in creating Test Approach, tractability matrix,requirement analysis, test estimation, review of test scripts

Testing Methodologies

Black box testing, Database testing , dataware house testing, coherence based application and rest API testing

Agile Methodology

Scrum, Sprint or Iteration

Education

Education
2001 - 2004

MCA

Banasthali Vidyapith

76%

Certifications

Certifications
Feb 2009 - Jan 2009

Testing Foundation level 1

ISQTB
Feb 2006 - 2006

QTP

HP

Onsite Experience

London, UK : Training of Investment Domain by RBS

New Jersey USA: Duration: 6 Month. Role: Customer Interaction, UAT Sign-off

Projects

Operational Data Cache (ODC)

Organization: RBS Markets & International Banking

Testing Team:15 members

Business Domain:Derivatives, Finance(FX and Money Markets), Trade Life Cycle, Debt Instruments

Tools: JIRA, Quality Center, ART (inhouse Automation Tool)

Database:Oracle 12G, Sybase

Description: ODC is a Coherence data grid technology backed by persistent storage. On the input side, the ODC has an enrichment and transformation layer which can process EMM and non-EMM messages. Clients can query data in the ODC via an Access Layer. 

NYK Logistics (Japan) Co. Ltd. - MIS(Management Information system)

Organization: Tata Consultancy Services

Testing Team:5 members

Business Domain:Shipping and Transportation Domain

Tools:  Mercury Quality Centre 9.0, HP Service Desk, Oracle SQL developer,   Toad

Database:Oracle 9i

Description: The project includes the understanding the existing system for NYK Logistics, major shipping company, by which equipment can be tracked, customer information, booking data can be stored and retrieved. 

P&ONL –FULL FOCUS 4

Organization: Tata Consultancy Services

Business Domain:Shipping and Transportation Domain

Tools:  Test Director