Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages Known
Timeline
Manager
Priyanka Sinha

Priyanka Sinha

Kolkata

Summary

QA Analyst with 12.5 years of relevant experience in ETL, MDM, Big data and BI Report Testing on Energy and Utilities domain, Insurance domain and Banking Payment gateway domain. My commitment towards test process improvements and Value-adds has been my key strength. Confident leader with strong interpersonal and communication skills, proficient in fostering teamwork and collaboration. Experienced in leading teams to achieve operational excellence and driving projects from conception to completion. Successfully acting as a coordinator between Organization and Customer to ensure they are benefiting each other and aligning with overall business goals.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Manager

Capgemini
06.2022 - Current
  • Leading Team for a team of 8-10 members from Offshore.
  • Requirements study & Planning - Analysis of Functional & Business requirement documents. Understanding the business information flow between the different upstream & downstream applications.
  • Test Case designing, data preparation for various scenarios and execution using SQL server and POstgreSQL.
  • Planning the entire testing activities including assignments for the team.
  • Coordinated cross-functional team efforts, leading to a 25% improvement in project completion time.
  • Delivered clear, timely and detailed status reports to project stakeholders, fostering better communication and collaboration.
  • Trained and mentored 10 junior testers, improving team productivity by 30%.
  • Test Plan Preparation, Test Case Preparation, Requirement Traceability Matrix (RTM), Test Data preparation and execution.
  • Peer Review- Reviewing the test cases and test data of team members. Uploading Test Cases in ALM and performing Test Case mapping against requirements. Providing detailed walkthrough of the Test Case Document to the client.
  • Handling/Leading the UAT activities-conference calls, overview sessions and any other forums with Business, and other teams concerned with the project.
  • Implemented advanced SQL techniques, increasing data validation efficiency by 40%.
  • Designed and executed over 200 functional test cases, reducing system failures by 30%.
  • Conducted thorough analysis of ETL jobs using Unix, mitigating risk of data issues by 40%.
  • Identified, analyzed and rectified 500+ data defects, enhancing overall system stability by 35%
  • Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.

Specialist

Wipro Technologies
11.2017 - 05.2022
  • Leading Team for a team of 8-10 members from Offshore.


  • Leading a crucial role during Automation Framework preparation and contributing views as needed.
  • Grooming new comers in the team with hands on activity
  • Planning the entire testing activities including assignments for the team.
  • Test Plan Preparation, Test Case Preparation, Requirement Traceability Matrix (RTM), Test Data preparation and execution.
  • Traceability – Linking the requirements to Test Cases, Test Logs & defects (if any) in HP ALM to ensure end-to-end traceability
  • Worked with systems engineer team to deploy and test new Hadoop environments
  • Creating Hive Queries which help analysts spot emerging trends by comparing current data with historical data metrics and creating hive tables, loading, and analyzing data using Hive queries.
  • Peer Review- Reviewing the test cases and test data of team members. Uploading Test Cases in ALM and performing Test Case mapping against requirements. Providing detailed walkthrough of the Test Case Document to the client.
  • Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.
  • Collaborated with cross-functional teams to achieve project goals on time and within budget.
  • Implemented new training programs for staff, leading to higher employee retention rates and better overall performance.

Associate

Cognizant Technologies
12.2015 - 11.2017
  • Increased customer satisfaction by resolving complex issues and providing exceptional service at all times.
  • Requirements study & Planning - Analysis of Functional & Business requirement documents. Understanding the business information flow between the different upstream & downstream applications.
  • Preparation of Test Cases - Preparation of ETL test cases
  • Test Data Preparation – Preparing Test data for different test scenarios
  • Defect Tracking & Issue Reporting using HP Application Lifecycle Management (ALM) 11.52


  • Peer Review – Reviewing the test cases prepared by the team


  • Preparing Daily Execution Report – Involved in preparing the Daily Execution Status report and sharing with onshore and offshore managers/leads.
  • Creating complex sql queries based on ETL mappings and requirements.

Senior Software Engineer

RS Software (I) Ltd, IND
09.2011 - 12.2015


  • Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
  • Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
  • Enhanced software functionality by identifying and resolving complex technical issues.
  • Requirements study & Planning - Analysis of Functional & Business requirement documents. Understanding the business information flow between the different upstream & downstream applications.
  • Test Data Preparation – Preparing Test data for different test scenarios
  • Defect Tracking & Issue Reporting using Clear Quest
  • Peer Review – Reviewing the test cases prepared by the team
  • Test Execution – System Integration Testing, Regression Testing, End-to-End testing, Interface testing and UAT
  • Preparing Daily Execution Report – Involved in preparing the Daily Execution Status report and sharing with onshore and offshore managers/leads

Education

Bachelor of Technology - Electronics and Communication Engineering

College of Engineering and Management

Intermediate (10+2) - undefined

Hijli High School

Skills

  • Hardware / Platforms: Windows NT/2000 Server, UNIX (AIX 61)
  • Defect Tracking Tools: JIRA, Rally, HP-ALM, Clear Quest
  • Programming Languages: C
  • Databases: DB2, Toad, MY SQL, SQL Server, Oracle
  • Scripting Languages: Unix and basics of shell scripting
  • Defect Tracking Tools: Rally, Clear Quest, JIRA
  • ETL Tools Used: Ab Initio GDE 3161 and 3173
  • Reporting Tool: Power BI 13015022868
  • Informatica
  • Hadoop: Hadoop 22, HDFS, Hive 013, MapReduce
  • Time management
  • Team leadership
  • Customer service
  • Decision-making

Accomplishments

  • Winner of RS Star of the Month Award for the month of January & September 2012.
  • Client and Business team appreciation on June -2023 for crucial delivery

Certification


  • Certified in ISTQB Foundation Level
  • Introduction to Agile development and Scrum
  • Certified ScrumMaster(CSM)
  • ·Certified Scrum Product Owner

Languages Known

English (Full proficiency)
Hindi (Full proficiency)
Bengali (Full proficiency)

Timeline

Manager

Capgemini
06.2022 - Current

Specialist

Wipro Technologies
11.2017 - 05.2022

Associate

Cognizant Technologies
12.2015 - 11.2017

Senior Software Engineer

RS Software (I) Ltd, IND
09.2011 - 12.2015

Intermediate (10+2) - undefined

Hijli High School

Bachelor of Technology - Electronics and Communication Engineering

College of Engineering and Management
Priyanka Sinha