Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Additional Information
Timeline
Intern

Amrit Guha

QA Test Lead | Tester | ETL DWH Testing| Automation & Mobile Testing
Kolkata,WB

Summary

  • Having 10yrs 1month of experience as a QA Software Test Lead/BI Tester in the field of Software Testing of web based applications, Mobile ,BI Tools, Impala, Hue, Hive, Unix and Mongo DB.
  • Expertise in Database, Big Data & DWH Testing.
  • Ensure the overall ETL checks(Data,Count,Duplicate,Null and Metadata) as well as functional checks as per the required mapping document, so the overall testing coverage is covered for the same.
  • Have successfully managed team as a Team Lead.
  • Have Successfully completed the Certified Scrum Master(CSM) certification
  • Extensive expertise in Web Based Testing, Database Testing, Micro strategy Testing (BI Testing), ETL Testing, ETL source files, source-target data load, mapping and transformations in the Banking and Financial Services Domain.
  • Validation of the HQL in hive platform. Validating the same to check the correct values are been feed to the end report testing (Microstrategy.Web Focus)
  • Extensive expertise in HP QC 10.00,ALM 12, Jira ,Rally, Microstrategy, Abinitio Control Center , Informatica Power Center, IBM Data Stage 11.7.
  • Performed extensive testing on Hue interface server for the validation of queries.
  • Participated actively in the meetings & teleconferences periodically with users,business analyst team, development team and QA team members.
  • Extensive expertise in HP ALM 12.53 and previous versions of Quality Center.
  • Experience of Automation testing using Selenium Web driver and row by row comparison,excel to excel ,csv to csv comparison, xml/json to cached database in Tosca
  • Hands on Experience in Mobile Testing. Performed end to end testing for the project app
  • Ability to quickly acquire new skills, adaptability to rapidly changing work practices and building and maintaining excellent working relationships with colleagues.
  • Sincere, dedicated and hardworking.
  • Involved in different types of Black Box testing like Sanity Testing, Regression Testing, Retesting, End-to-End scenario Testing, Ad hoc Testing, and Compatibility Testing.
  • Strong Experience in writing and executing the test cases.
  • Strong exposure on Test Plan and Defect Life Cycle.
  • Proficient in STLC with focused exposure and expertise on Business Requirement Analysis, Test Estimation, Test Strategizing, Test Planning, Test Design, Test Execution, Defect Tracking and End to End System testing, debugging, and documentations.
  • Experience in Functional, Regression, Integration, Database, User Interface and System Testing.

Overview

3
3
Languages
6
6
Certifications
6
6
years of post-secondary education
10
10
years of professional experience

Work History

Senior Associate

Cognizant
07.2019 - Current

1)PROJECT Name: World Pay Vantiv

Company : Cognizant

Client : FIS(formerly WorldPay)

Domain : Banking

Roles Played : BI Tester/Test Lead

Team Size : 6(Onsite/Offshore)

Technology : Cloud

Database : AQT, Oracle SQL Developer ,IBM Data Studio ,Hue(Hive & Impala),Snowflake,Salesforce (Workbench)

Testing Tools :Rally

Application : IBM DataStage 11.7, Unix, Tosca ,Womply

Description:

Project deals with multiple small capex projects like EPPE, FICO, Schnucks, Actimize ,Brighterion etc. Highlight of Ohio River is E2E testing on various rails(where billing generation process is involved) & Testers are involved from debugging to running of jobs for any failure and handling over files to other team. Majority of the project is of Big Data Landspace and also on DWBI testing.

Plaform : To replace existing data store built in DB2 to Hadoop data lake that can handle large transactional records and there after building webfocus reports on top of it.

2)PROJECT Name: IDW SMD Metfacs/ iComp SCP

Company : Cognizant

Client : Metlife

Domain : Insurance

Roles Played : BI Test Lead

Team Size : 3(Offshore)

Technology : Cloud

Database : IBM Data Studio

Testing Tools :ALM

Application : Informatica

Associate Consultant

TCS
03.2011 - 07.2019

PROJECT Name: Citi Insight BCBS

Company : Tata Consultancy Services

Client : Citibank

Domain : Banking and Financial Services.

Roles Played : Quality Assurance Test Analyst, Test Lead

Team Size : 21(Onsite/Offshore)

Technology : Cloud

Database : SQL Server(Interactive SQL)

Testing Tools :ALM

Application : Microstrategy, Tectia, Abinitio

Description: The major requirements introduced through BCBS project are

  • Basel Committee on Banking Supervision (BCBS) regulation 239 has the objective of strengthening banks’ risk data aggregation and internal risk reporting practices thereby enhancing risk management and decision making processes at banks. Citi’s BCBS 239 program supports this objective by eliminating risk management reports that rely on manual data manipulation and calculations (aka End User Computing) and replacing them with Standard Management Reports delivered via Citi Insight and sourced from strategic data repositories (SDRs) via CTO Data Services. Under this program, the regulators have identified 43 reports as critical which requires greater degree of production automation.

PROJECT Name: RESPA Tila Project Z

Company : Tata Consultancy Services

Client : Citibank

Domain : Banking and Financial Services.

Roles Played : Quality Assurance Tester, Test Lead

Team Size : 5(Onsite/Offshore)

Technology : Java

Database : SQL Server

Testing Tools : Quality Center

Application : CFI, LOIS, Citiworks, Filenet, Kofax,Corweb

Description: The major changes introduced through Respa Tila Z are

•LRS code changes.

•New Doc Class, Type and Code to generate the new set of documents.

•CORR Fee Tolerance

•CFI event and notes

•Changes in CFI Documents and Letters, Citiworks Activity.

The major changes introduced in CFI through Respa Tila Z are

  • Modification of "Correspondent Lending Fee Tolerance Validation" screen for Correspondence loans.
  • Certain sets of Citiworks activities and loan level changes got implemented
  • CFI Events and Notes were implemented
  • CFI Error messages and Warning Messages were brought in which were a part of CFI

Education

B.Tech - Applied Electronics & Instrumentation

West Bengal University of Technology
07.2006 - 07.2010

Higher Secondary (XII) -

National High School For Boys, South Point High School
West Bengal (Kolkata)
06.2004 - 06.2006

Skills

QA

undefined

Accomplishments

  • Received many significant appreciations for critical projects which have gone to production without a single INC raised from the business side.
  • Received appreciation for handling the team during critical situation for running multiple Regression cycles as well as PCR changes in a single week.
  • Received numerous appreciations for various deliveries from our end.

Certification

Completed ISTQB Foundation level Certification

Additional Information

Additional Activities (Other than Project Work)

  • Involvement in outreach activity ( Helping the needy,disabled in terms of some amount charity work and knowledge session
  • Have being rewarded and recognized for the work done from my end.
  • Involvement on BCP (Call Tree Test) during the pandemic phase.
  • Involvement in the internal company audit as well as project scanning as required

Timeline

Senior Associate

Cognizant
07.2019 - Current

Associate Consultant

TCS
03.2011 - 07.2019

B.Tech - Applied Electronics & Instrumentation

West Bengal University of Technology
07.2006 - 07.2010

Higher Secondary (XII) -

National High School For Boys, South Point High School
06.2004 - 06.2006
Completed the foundation course of Leadership Program (Ascent-“The foundation of your Leadership Journey”)
Completed HP ALM (Version 11.x) Certification(HP Accredited Integration specialist)
Completed Prince 2 Foundation Level Certification
Completed AWS Certified Developer Associate Certification.
Completed Certified Scrum Master(CSM) Certification
Completed ISTQB Foundation level Certification
Amrit GuhaQA Test Lead | Tester | ETL DWH Testing| Automation & Mobile Testing