Shah Paran

I have 6+ years of IT experience in Manual and Automation Software Testing, Data Warehouse Testing, and Data analysis. Proficiency in writing Test Plan, Test Scenarios and Test Cases using requirements, design specifications and process flow diagrams.

Experience in Front-end testing such as: System, Smoke, Integration, Functional, Regression and Ad-hoc testing on many Client/Server and web-based applications. Experienced in performing Quality Test to determine the quality of the ETL processes with Teradata SQL. Extensively worked on databases including Oracle, Teradata, SQL Server, and DB2.

Practiced AGILE methodology with daily meetings following the onsite-offshore model. Utilized JIRA and HP Quality Center to manage and keep track of testing and analysis. Experienced in testing Star and Snowflake Schema Dimensional Data Models.

Experienced in end-to-end testing of ETL, Reference Data, Date Warehousing and Business Intelligence solutions for large enterprise data.

Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance. Skilled in full life cycle development for building a Data Warehouse. Excellent problem-solving skills with a strong technical background and good interpersonal skills. Quick learner, able to work independently, and excellent team player, ability to meet tight deadlines and work under pressure.

QA /ETL Tester - Golden1 Credit Union - Sacramento, CA

(2021-08 - 2025-08)

• Analyzed functional requirements and technical documentation to create and execute detailed test plans and test cases in ALM.
• Executed Test cases in finding errors, reported defects, determined repair priorities, performed Regression Testing and closed by using ALM.
• Worked in Agile Development Environment and participated in Sprint Planning, Sprint Review, meeting and daily stand-up and retrospective meetings and update day to day status to agile team.
• Worked closely with Business Analysts and Developers to fill the gaps in the requirements.
• Performed System, Negative, Integration, Regression, Sanity and User Acceptance Testing for applications.
• Used JIRA for adding issues on what is being worked and tracking project all subtasks.
• Executed automated test scripts using UFT to perform through testing.
• Performed using UFT after each new build of the application with Hybrid Framework approach.
• Collaborated with Business, Program/Project Manager to get requirement, project scopes, setting priority, expected results in low project risk, efficiency and timely delivery of projects.
• Responsible for giving demonstrations and presentations to the management and mentoring other junior team members.
• Coordinated between offshore and onside team and managed the entire project for testing needs.
• Generated the detailed reports of the Bugs, Pass-Fail report, and comparison chart.
• Involved to UAT and logged the Ticket if discovered any issue by the client.
• Provided timely well-documented QA reports, which allows project to maintain high quality and successful completion of it.

System QA Analyst / ETL Tester - Wells Fargo - Charlotte, NC

(2019-11 - 2021-06)

• Created test case scenarios, executed test cases, and maintained defects in internal bug tracking systems.
• Tracked the defects, RTM with application teams and assisted in closure using ALM.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata/Oracle database.
• Created complex SQL queries for data validation to verify the ETL mapping rules.
• Performed transformation and data quality for various data feeds coming from different source systems.
• Tested and validated the Report by running similar SQL queries against the source system(s).
• Extensively used Informatica power center for extraction, transformation and loading process.
• Analyzed the Requirement Traceability Matrix, daily test status reports, weekly defects report, and risk analysis, including regular communications with the business team.
• Used JIRA for adding issues on what is being worked, used ALM to create and execute test cases.
• Participated in defining and executing test strategies using agile methodology.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
• Involved in Unit testing and integration testing of Informatica mappings.
• Tested the data warehouse using data mapping documents for various data feeds.
• Created test data in Teradata QA Environment for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Coordinated between offshore and onsite team and managed the entire project for testing needs.

QA Analyst - Wells Fargo - Richmond, VA

(2018-09 - 2019-10)

• Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements documents for test purpose.
• Prepared and executed Test Cases manually according to the BRD, Technical Specification, Functional Design and Use Case documents, identifying application's functionality, test requirements and coverage.
• Performed regression testing against the various builds of the application.
• Wrote SQL queries and tested front end developed data in the databases.
• Executed automated test scripts using UFT to perform through testing.
• Performed Configuration and verified the application on different operating systems.
• Interfaced with developers to resolve technical issues and investigate software faults.
• Prepared the RTM Document to ensure that all the requirements had sufficient coverage for through testing.
• Defects were tracked, reviewed, analyzed, and reported using ALM.
• The reports tested in the system as per company standards and requirements.
• Responsible for giving demonstrations and presentations to the management and mentoring other team members.
• Prepared and executed test cases and defect tracking and reporting processes using ALM.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Involved in testing Reports and actively worked with operations, and Release teams to resolve the production issues.

Bachelors in science - National University, Bangladesh