Hamraj Singh Rattanpal
Email ID: ******.*****@*****.***
Cell No: +91-956*******
Experience Summary:
Hamraj Singh Rattanpal has 12+ years of work experience in software testing. He has been working as Test Lead. He is specialised in testing complex applications (client server and web based) of Retail banking, Investment banking, credit card and fraud management under Banking and Financial Services (BFS) domain. He has in-depth knowledge of Test Management. As part of his assignments, he has been involved in Requirements Gathering & Analysis, test effort estimation and Testing (Functional Testing, Integration Testing and System Testing). He has acquired work experience in Fidessa product which is a middle office product used in investment banks. He has exposure of working on offshore (India - 9.8 yrs) and onsite locations (UK and US - 2.4 yrs).
Excellent knowledge of SDLC and STLC
Involved in requirement analysis with business teams and client
Experience in preparing test plans, test estimation and (Risk, Assumptions and Dependencies) RAID logs. Involved with reviewing test cases and sending reports to project stakeholders
Well versed with functional testing, integration testing, system testing, regression testing, GUI testing and UAT
Experience in manual testing using ALM Quality Center and Bugzilla
Expertise in UNIX Shell (commands),SQL and Data structures.
Expertise in testing TMAR module of Fidessa.
Experience in Perl and Shell scripting
Knowledge of Selenium Webdriver.
Basic knowledge of languages like C, C#
Company Name
Years of work experience
Cognizant Technology Solutions India Pvt. Ltd., Pune
10.5 years
Infosys Technologies, Pune
1.7 years
Certifications
Certified Software Test Engineer (CSTE) - 2006
Banking and Financial Services (BFS) certification (Cognizant certified) completed.
Technical skills
Testing Tools
ALM Quality Center 12, Bugzilla, JIRA and Test Director 6.x, 7.x, 8.x
Test Scripting
Perl and Shell scripting,
Knowledge of Selenium Webdriver.
Languages
Unix Shell (commands),SQL, HTML, XML, knowledge of C and C#
Database
Sybase, SQL Server, Oracle, MS Access
Operating Systems
UNIX, Linux, Windows-XP/ 2000 / NT (Server, workstation)
Tools
Squirrel, TOAD, Putty
Project Experience Summary
Following is the experience gained from Cognizant Technology Solutions.
1)
Client: One of the biggest investment banks in US
Location: Pune.
Duration: Feb 2013 to till date.
Role: Test Lead
Project Description:
Fidessa is used as a middle office product for booking of trades, which is an important activity in the trade management lifecycle. Once trades are executed, trade has to be booked by Fidessa so that it can be routed to back office. Testing of various trade flows in Fidessa is one of the core activities.
Responsibilities:
Understanding Fidessa product and testing it in various regions
Understanding the functionality based on business requirement document
Estimate time required for testing activity
Prepare Test plan and review test scenarios and get approval from business stakeholders
Automated test cases using Perl scripting which led to significant reduction in test execution time.
Involved with test case execution and defect management.
2)
Client: One of the biggest retail banks in UK
Location: Pune
Duration: Feb 2012 to Jan 2013
Role: Test Lead
Project Description:
The Foreign Account Tax Compliance Act (FATCA) is an important development in U.S. efforts to improve tax compliance involving foreign financial assets and offshore accounts
Responsibilities:
Understanding the functionality based on functional specifications and estimate the time required to develop and execute test cases
Review test plans and test scenarios prepared by QA team
Involved with test case execution and defect management.
3)
Client: One of the biggest banks in UK
Location: Pune.
Duration: July 2011 to Jan 2012.
Role: QA Lead
Project Description:
CAS (Customer Acquisition System) is an internal credit card system which is used for processing customer applications and providing decision to the application.
Responsibilities:
Understanding system functionality based on functional specifications and estimate the time required to develop and execute test cases
Review test plans and test scenarios prepared by QA team
Involved with test case execution and defect management.
4)
Client: Company providing its ebanking product in US
Location: United States and Chennai.
Duration: July 2009 to Jan 2011.
Role: Onsite QA Analyst
Project Description:
There were many changes done to FX ebanking product to cater to user alerts and to feature External Transfer to Mexico as a service.
Responsibilities
Understanding the functionality based on functional specifications and requirements from business team
Preparation of Test Plan, design and delivery of test cases as per requirements for system testing
Defect Management and Test Metrics preparation.
5)
Client: One of the biggest retail banks in UK
Location: United Kingdom
Duration: Jan 2008 to Feb 2009
Role: Onsite Test Lead
Project Description:
Involved in enhancement of existing regression pack for banking and savings product. Later, involved in testing of new system (SAS) used for fraud prevention to reduce transactional fraud losses.
Responsibilities
Involved with requirement analysis and test estimation, test plan preparation and review of test cases and coordinating with business stakeholders.
6)
Client: One of the biggest investment banks in US
Location: Pune
Duration: April 2006 to Dec 2007
Role: Test Member
Project Description:
The Give-Up Solution is for the prime brokerage line of business of the client.
Following is the experience gained from Infosys Technologies.
7)
Client: One of the biggest investment banks
Location: Pune
Duration: July 2004 to March 2006
Role: Team Member
Project Description:
Involved in testing program trading which occurs when the placing of trades in the exchange takes place automatically without any human intervention.