senior test analyst

7
Curriculum Vitae Karthick Subramanian Email:- [email protected] M- 0745 105 1453 Professional Summary An action orientated and energetic Test Lead who has expertise knowledge in identifying areas within a business which needs optimization. He has proven record of delivery, strong strategic vision and demonstrated ability to mentor QA/Dev teams. He has 8 years of experience in Quality assurance in banking sector. He is expert in analyzing business requirements to develop effective test plan and approach and has applied his knowledge and skills in all phases of Software Development and Testing Life Cycle. He possesses exemplary professional skills in testing tools. Snapshot 8 years of experience in working with major banking clients like Deutsche bank and UBS. Good knowledge in converting business requirements into documentation and determining the projects scope and vision. Experience in handling multiple priorities in a time sensitive and dynamic environment. Excellent knowledge in SUMMIT, Global 1, Equilend and DTC applications. Excellent Investment banking knowledge with good understanding in the Trade life cycle. Expertise in handling Front, Middle and Back office systems. Good working knowledge on the testing methodologies, Agile, water fall & V- model and SDLC & STLC. Has got 3+ years of experience in managing 10-member team. Well versed in Test management tools – JIRA, Quality Center and Test Director. Excellent knowledge in MS Excel (Daily / Weekly status reports, Pivot table, Look Up, Macros) and VBA. Experience in testing Client-Server, web-based applications including API’s like Restful Service. Experienced in Functional, ad-hoc, Sanity, regression, integration, UAT and system testing Experience in back end testing by interrogating the databases like Oracle, Sybase and Gemfire. Good Working knowledge on HP QTP and Cognos reporting system. Good hands on experience in testing Maintenance, Major, Decommission and flagship releases. Have delivered more than 50 releases in Production. Excellent stake holder management skills. Expert in providing training & technical walk through to the IT, Business, PDG teams. Excellent team player, individual contributor with good documentation skills. Exceptional communication skills with proficiency in grasping new technical concepts quickly and utilize the same in a productive manner. Career Graph

Upload: karthick-subramanian

Post on 08-Apr-2017

38 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Senior Test Analyst

Curriculum Vitae

Karthick Subramanian Email:- [email protected] M- 0745 105 1453

Professional SummaryAn action orientated and energetic Test Lead who has expertise knowledge in identifying areas within a business which needs optimization. He has proven record of delivery, strong strategic vision and demonstrated ability to mentor QA/Dev teams. He has 8 years of experience in Quality assurance in banking sector. He is expert in analyzing business requirements to develop effective test plan and approach and has applied his knowledge and skills in all phases of Software Development and Testing Life Cycle. He possesses exemplary professional skills in testing tools.

Snapshot

8 years of experience in working with major banking clients like Deutsche bank and UBS. Good knowledge in converting business requirements into documentation and determining the projects

scope and vision. Experience in handling multiple priorities in a time sensitive and dynamic environment. Excellent knowledge in SUMMIT, Global 1, Equilend and DTC applications. Excellent Investment banking knowledge with good understanding in the Trade life cycle. Expertise in handling Front, Middle and Back office systems. Good working knowledge on the testing methodologies, Agile, water fall & V-model and SDLC &

STLC. Has got 3+ years of experience in managing 10-member team. Well versed in Test management tools – JIRA, Quality Center and Test Director. Excellent knowledge in MS Excel (Daily / Weekly status reports, Pivot table, Look Up, Macros) and

VBA. Experience in testing Client-Server, web-based applications including API’s like Restful Service. Experienced in Functional, ad-hoc, Sanity, regression, integration, UAT and system testing Experience in back end testing by interrogating the databases like Oracle, Sybase and Gemfire. Good Working knowledge on HP QTP and Cognos reporting system. Good hands on experience in testing Maintenance, Major, Decommission and flagship releases. Have delivered more than 50 releases in Production. Excellent stake holder management skills. Expert in providing training & technical walk through to the IT, Business, PDG teams. Excellent team player, individual contributor with good documentation skills. Exceptional communication skills with proficiency in grasping new technical concepts quickly and utilize the

same in a productive manner.

Career Graph

Clients Tenure Duration Location Roles HSBC Feb 16 – Current 4 Months London Test Analyst

UBS Jan 11 – Jan 16 5 Years London, Singapore

Test Analyst & Test Lead

Deutsche Bank Jul 08 - Dec 10 2 years and 6 months

Pune, India Assistant Test Engineer

Functional Skill Set

Business Analysis Developing charts and flowcharts of current and future business processes. Good knowledge in converting business requirements into documentation. Identifying client business requirements and defining project scope and objectives. Work closely with PDG to determine the priority of specific requirements based on their value

to the business. Preparing PowerPoint presentations and Excel spreadsheets for business meetings. Flagging up potential problems at an early stage.

Page 2: Senior Test Analyst

Software Quality Assurance Interact with client side professionals for system study, requirements verification and analysis. To provide scope, resource and time estimates for projects. Testing software programs against business requirements. Documenting, tracking, communicating test plans, test results & analysis. Debugging/ troubleshooting the application. To deliver the project as per scheduled milestones. Identifying and analyzing defects, questionable functions, errors, and inconsistencies in

software program functions, outputs, online screens, and content. Post Implementation review of the requirements and provide RCA of the issues skipped in

production.Team Management

Designing and coordinating the implementation and availability of the QA test environments. Providing QA test status and progress reports as appropriate to higher management. Working with business analysts to ensure QA testing requirements are appropriately identified

and matches with the user requirements. Coordinate between onsite and offshore teams to get status update and resolve queries if any. Liaise with the users for sign off for their requirements. Provide demo of the changes to Stake holders / Business. Review the Change requests and approve it.

Noteworthy Milestone

Received Tester of the month award from Infosys Technologies ltd. Received certificate of appreciation from Deutsche bank for the successful implementation of the

project, Thunderhead. Received certificate of appreciation from UBS for outstanding performance during Jul – Dec 2011. Received insta award from Infosys Technologies ltd continuously from the year 2009-2013 (4 times).

Academic Credentials

Examination % Of marks Year of Passing College University / Board

B.sc Information Technology 71 May 2008

N.M.S.S.V.N college Madurai Kamaraj University

PROJECT EXPERIENCE 1. HSBC (Working as a “Test Analyst”, London)

Title Volcker (Regulatory Project)

Client HSBC

Tools Quality Center, MS Access, SQL Developer, Cognos

Team Size 12

Duration Feb 2016 to current

This is a regulatory project which involves testing of the implementation of 7 Volcker rules. I am responsible for testing rules / metrics 5 to 7. This project uses calculators built on excel / MS Access for different metrics to perform the reconciliation testing. Reconciliation testing is performed with the trades which are booked across multiple upstream system (FIDESSA / SUMMIT / GCAL) and it sent down to the database where Volcker specific enrichments takes place for it and final results of the metrics are displayed in Cognos reporting system. Below mentioned are roles & responsibilities of myself in Volcker testing:

Roles and Responsibilities in Volcker Testing (HSBC)

Requirement Analysis & Test Planning I go through the change requests and come up with the test approach and discuss the same with BA’s and

senior management. Once it is reviewed and approved then I come up with the test cases to execute it.

Functional Test Execution & Reporting

Page 3: Senior Test Analyst

Once the test cases are signed off or approved, I perform the execution of it and log issues in Quality center. The defects logged are discussed in the daily triage call.

Test execution status reports are sent out to individual stake holders for the major projects on daily basis and the same is updated to the stake holders over the daily QA progress call.

Regression Testing: I used to analyze the regression impact of the applications which has undergone changes for the current

release and send out regression test plan with timelines and test coverage of the applications. Send out daily status reports to the stake holders and follow up with Dev team on the issues reported.

Post Implementation Review: Post production release, I used to analyze the issues reported in production and come up with detailed root

cause analysis.

Toolset Optimization: I am involved in optimizing of the expected and actual result calculators used for the metrics. I have migrated the calculators from MS Access to excel and also merged 2 documents into one by which I have reduced the time significantly to execute the metrics.

Project Description – SBL (Stock Borrow Lending)

2. UBS (Worked as a “Test lead & Analyst”, London & Singapore)

Title SBL(Stock Borrow Lending)

Client UBS

Tools Test Director, Quality Center, Jira, QTP, Toad, Aqua data studio, Gemfire

Team Size 10

Duration Jan 2011 to Dec 2015

.Project Description – SBL (Stock Borrow Lending)

Stock Borrow Lending is a project related to Equities (Derivatives). The exchange traded stocks with different status (General and Special) and the different stock types like Common, Bond, CVB are traded in SBL. The trade types like Borrow, Loan and Rehypothecation are booked from internal front office systems and the flow is validated in Back office systems like Global One (SunGard’s product) and Equilend. The trade actions, rate change, reallocation, settlement, cancellation and rebooking are performed from the front office. It is then validated in the downstream systems. The reconciliation activities are carried out for the booked trades between the counterparties and those that are grouped into different categories like Mark, contract, Billing and settlement. Reconciliation has a unique functionality to be performed. E: G:- In Mark reconciliation every day we mark to market and check the prices of the security for the booked trades and if there is a difference in price then we book the difference in price from internal systems to GL1.

Global 1:Global One is a trade booking application with vast features in it. It has been used by many investment banks across globe. I have an excellent working knowledge on Global 1 trading application to perform the below activities:

Booking of Trades Amending of trades Settling of Trades Authorizing of trades Viewing and updating counterparty and security static Returning of trades

Equilend:Equilend application is created by group of investment banks for booking of Autborrow trades and different reconciliation activities like Mark, Contract, Settlement, Billing, and Dividend. It is also used for Autoborrow trade booking and returning and recalling of the existing trades.Roles and Responsibilities in the current Project

Stake Holder Management:

Page 4: Senior Test Analyst

• As a test lead, I effectively communicate with 40+ stake holders during all stages of software testing. Which are explained in detail below.

Requirement Analysis & Scope Closure: As a test lead, I go through the requirements logged in Jira against the specific release and run through it

with the Project managers, Product owners and Release managers and perform scope closure for the respective releases.

Test Estimation and Prioritization: Post scope closure, I come up with the estimates for the different projects planned for the respective release

and bandwidth of the team to accommodate the requirements. Estimates are then shared with the stakeholders and if there is shortfall on the QA bandwidth then

prioritization of the project takes place and the projects which can be accommodated with in QA cycle will be considered for QA scope and remaining will be de-scoped to subsequent releases / tested by Dev team and the users.

Test Planning & Run Through: Post prioritization the requirements are cascaded to the team members and they will come up high level test

scenarios & queries for the requirements. Post completion of the test scenarios, I used to schedule call with the stake holders involved in the project

and run through the test scenarios and resolve the queries and incorporate any review comments.

Functional Test Execution & Reporting: Post sign off on the test plans, I used to schedule call with the release and environment management to

finalize the environment requirements and test data set up (if required) and request to deploy the code for QA to test.

During the Test execution phase, I used to perform the health checks for initial days and hand it over to the team to continue for the remaining days and I will be as an escalation point of contact.

I have daily call with the team spread across US, UK & Singapore to get the detailed status on what they are working and ETA for completion and are there any issues blocking them to complete the testing.

Test execution status reports are sent out to individual stake holders for the major projects on daily basis and the same is updated to the stake holders over the daily QA progress call.

Defects for the failed cases are logged in the Jira as form of QA defects and I schedule call to run through with Dev team to address the same and get turnaround time to fix the issues.

Post completion of the testing for the respective requirements. Call is scheduled with the business users to run through the QA test results and perform testing of more scenarios if required else get sign off on the QA testing.

User Testing & reporting: During the user testing phase, I used to schedule call with the key stake holders to update the progress on

each of the requirements and their availability to test. Perform testing on behalf of the users on need basis and run through the test results with them. Follow up with the users for sign off on their requirement. Regression Testing: I used to analyze the regression impact of the applications which has undergone changes for the current

release and send out regression test plan with timelines and test coverage of the applications. Send out daily status reports to the stake holders and follow up with Dev team on the issues reported. Post Implementation Review: Post production release, I used to analyze the issues reported in production and come up with detailed root

cause analysis.MS Excel: I have excellent working knowledge in excel to prepare Daily/Weekly Status report, Pivot table, V look up,

Macros, Data Comparisons, Exporting cases to QC, Test result document, charts).

3. Deutsche Bank (Worked as a “Testing Executive”)

Title ThunderheadClient DB (Deutsche Bank)Tool Test Director, Quality CenterTeam Size 40Duration July 2008 to December 2010

Page 5: Senior Test Analyst

Project Description – Thunderhead

Thunderhead is a third party tool used for generating the documents for the trade bookings done on the Front offices. It has a batch config logic which decides the type of template that needs to be selected for a particular type of trade booked. This application is used for generating the confirmations both for the rates as well credit products that are traded over the counter (OTC).

Summit application:Summit, a product of Misys is used by major banking clients for booking of different types of OTC trades between one or more counterparties. It is available in different versions like 3.7, 3.8, 5.2, and 5.3. I worked on Version 3.8. This application is used for booking both Credits and Rates trade. Depending on this utility/module differs. The below mentioned products were majorly booked in summit:

Swap Cap / Floor FRA Swaption Bond option

Trade booking is a 2 step process. In step 1, the trade is booked in front office by logging in as user 1. In step 2, the trade is confirmed on the front office by logging in as user 2.

Once the trade is verified the trade details are sent to Summit back office which is known as Global Back Office (GBO). The trades are dispatched from GBO to the downstream system to generate the confirmation documents and send it to the clients for verification.

Trade Actions:The trade booking is followed by multiple actions like:

Termination Assignment Amendment Rebooking.

Roles and Responsibilities in Deutsche Bank To identify client business requirements and defining project scope and objectives. To work closely with PDG to determine the priority of specific requirements based on their value to the

business. Producing test plans and scenarios on behalf of the business. Documenting, testing and implementing software updates. Meeting with project teams to review deliverables and deadlines. Allocating junior staff to tasks and then tracking the progress of their work. Ensuring all tests are conducted and documented according to the plan. Provide clients with initial and ongoing support throughout the Testing lifecycle. Carrying out business improvement reviews and identifying issues and recommending solutions.

PERSONAL DETAIILS Gender - Male Martial status - Married Nationality - Indian Date of birth - 16th May 1986 Languages known - English, Hindi, Tamil & Sanskrit

HOBBIESListening to Indian Classical Music, Follower of Indian Politics & Playing Cricket.

I hereby declare that all the details mentioned above are correct to the best of my knowledge and belief. - Karthick Subramanian.