IRSHAD MANSOORI

Irving, TX ***** 469-***-****

ad4ysa@r.postjobfree.com

Professional Summary

Dedicated and accomplished Test Lead with over a decade of experience in IT software. Successfully led and contributed to projects such as TDA Data Migration, Integrated DWH, and BI reports for exchange management. Proven expertise in leading successful projects, overcoming challenges, and contributing to integrated solutions. Seeking a challenging role as a Test Lead or Scrum Master to leverage skills in team leadership and project management.

Skills

Requirement Analysis

Project Management

Test Planning & Test management

SCRUM & AGILE Methodologies

SDLC & STLC

JIRA, Confluence, QC, HP ALM

Database and ETL Testing

Informatica, Data Stage, Talend

Python, Selenium, iCEDQ, Dataops

Cloud – AWS, Snowflake, GCP

Defect Tracking and Reporting

Data Warehousing and Data migration

Banking, Capital Market and HealthCare Domain

Manual, Functional, UAT & Regression Testing

Java, Oracle, SQL, PL/SQL, Netezza, UNIX

Cognos, OBIEE

Work Experience

ETL Test Lead, 01/2022 - Current

Mphasis Corporation – Irving, TX

Enhanced ETL testing efficiency by implementing advanced automation techniques and tools.

Optimized data validation processes, resulting in improved data accuracy and integrity.

Review SIT requirements and create ROM estimates.

Prepare Test Plan, strategy, test closure documents and conduct walkthrough meetings with stake holders.

Co-ordinate with onshore/offshore testers during test scenarios, cases and test data requirements creation.

Proficient in writing SQL queries to validate date transformations and identify discrepancies.

Validate transformation logic using SQL queries and iCEDQ tool, data integrity and consistency against mapping rules.

Maintain project deliverables on Confluence and create JIRA deployment tickets.

Set up defect triage calls and perform defect root cause analysis.

Publish test design, execution, defect and risk details in Daily and Weekly status reports.

Test Lead, 03/2020 - 12/2021

CitiusTech Inc. – Irving, TX

Worked with SMEs of various source systems to understand project requirements.

Reviewed requirements documents thoroughly, identifying potential gaps or before initiating test efforts.

Designed test scenarios for the project based on requirements and mapping sheets.

Created a regression script to validate all the QA activities for any changes in backend using Netezza.

Conducted defect walkthrough for the development team for clear understanding of defects and to make it to closure.

Responsible for testing and reviewing ETL mapping, and transformation specifications based on business requirements from business teams.

Conducted thorough analysis of ETL jobs using Datastage.

Conducted and participated in technical reviews/ walkthrough for QA deliverables such as test plan, test strategy, and test cases

ETL Tester, 09/2016 - 02/2020

CitiusTech Healthcare Technology Private Ltd – Mumbai, MH

Scrum Master:

Facilitate Scrum events – Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective

Manage end to end sprints

Conduct training on Scrum framework

QA:

Responsible for testing and reviewing ETL mapping, and transformation specifications based on business requirements from business teams.

Worked closely with on-shore lead and client as a back-up offshore test lead.

Conducted end to end testing of ETL processes on AWS, utilizing services such as AWS Glue Redshift and S3.

Data consistency validation within the tables to check all Transformation Rules are followed.

Responsible for checking DWH and Data Mart source to target data integrity by developing and executing different SQL queries.

Built automated test scripts to handle repetitive software testing work using Selenium.

Created business scenarios based on requirements documents, designed and executed test cases.

Used agile methodology to execute SDLC lifecycle solutions, including requirements gathering, design & implementation

Involved in reviewing test cases and test execution of team members.

Created and published daily status reports.

Scrum Agile SDLC Model

Data Analyst, 03/2011 - 08/2016

NSEIT LTD – Mumbai, MH

Worked on N-Vision, Risk Management and Surveillance systems of NCDEX as a module lead.

Created business scenarios based on requirements documents.

Created test data and test cases according to scenarios.

Responsible for planning and executing test cases.

Tested ETL DWH and MIS reports by developing and executing different SQL queries.

Automation test using Selenium/ Java.

Tested ETL batch processes using Unix Shell Scripting.

Enhanced business efficiency by identifying trends and patterns in complex datasets.

Created and published daily status reports.

Responsible for deploying code on FT environments.

QA Analyst, 09/2009 - 03/2011

MEGASOFT INFORMATION SYSTEM PVT LTD – Mumbai, MH

Worked on TDCC Easy Bank Core Banking System and NSDL DWH.

Worked on core banking modules like Transaction module and reports.

Tested ETL and DWH reports by developing and executing different SQL queries and QTP scripts.

Created business scenarios based on requirements documents.

Created test data and test cases according to scenarios.

Responsible for planning and executing test cases.

Raised defects in Bugzilla.

Certifications

ISTQB Certified Tester

Certified SCRUM Master

NCFM

Education

Master of Computer Application (MCA)

RJ College - Pune, Maharashtra (India)

Contact this candidate