Engineer Data

Experience Summary:

Meticulous and highly motivated person to pursue career in Information Technology.

Very good understanding of ETL workflow, reporting and Data warehousing concepts.

Know the concepts of Requirements Gathering, Requirements Analysis and creating Traceability Matrix.

Experience with Creating Test Plans, Preparation of Test Cases, Preparation of Test Data, Execution of Test Cases and Test Reports.

Understanding of various types of testing like Functionality, Manual, GUI, Smoke, Sanity, Black-Box, System Integration, End to End, Regression and Compatibility Testing, UAT, Pre-Prod Testing of various applications. Experience in Batch Testing.

Experience with Defect Logging, Defect Reporting, Monitoring and interactions with Business Analysts and Development team.

Exposure to Defect Tracking Systems like JIRA, QC, Rational tools like Rational Test Manager (RTM), Rational Manual Tester (RMT), Clear Quest, Lotus notes Basic and Bugzilla to report, track and update defect status.

Has gained good domain experience in Banking Domain.

Having good knowledge in STLC (Software Testing Life Cycle) and Defect Life Cycle concepts. Well acquainted with Software Development Life Cycle and Test Methodologies.

Knowledge of Agile/Scrum and Waterfall development models as part of Quality Assurance team in various projects.

Experience in back-end testing using SQL queries, and generating reports to ensure Data Integrity and validate business rules.

Professional Certifications

Testing methodologies

Agile and Waterfall.

Test Management Tools

ALM, Rational Clear Quest, JIRA

Testing Tool/Techniques

Manual, Functional, Database Testing, Sanity, Smoke, Integration, System, Regression,

UAT, ETL jobs Performance, Volume/Stress testing, Quick Test Pro(QTP), Black Box, White Box testing, Green Hat, Test Data Management

Databases

SQL Server, Oracle and Teradata

Operating Systems

Windows 7, UNIX, Linux

Professional Experience

Wells Fargo, Charlotte NC

QA Engineer July 2019 – Dec 2020

Project 2: Debt Capital Market Research team is responsible for providing the rate information based on the product category and market. As part of LIBOR to IBOR transition, SPECTRA application was modified to add additional fields to the frontend and also backend database.

Understanding business requirements and creating functional specifications and User stories.

Participated in all phases of the Software Testing Life Cycle (STLC)

Preparing Test Plan, Test Scripts and Test Cases for Spectra and IBOR transition.

Executing the test cases in ALM and logging the defects.

Creating Test data for testing. Comparing the results with upstream applications and through database SQL queries for validation.

Executing regression test scripts for each deployment.

Coordinated with Development Team for defect resolution.

Moving the Service calls through various SDLC phases post review of deliverable documents.

Defect Logging and Tracking to closure using ALM and JIRA.

Preparing Test results and self-reviewing the deliverables before final submission.

Attending daily scrum meetings and bi-weekly sprint planning sessions.

Environment: SPECTRA Application, Azure DevOps, JIRA, UI Testing and Windows

Project 1: Enterprise Risk team is responsible for reporting to Federal Reserve for counterparty credit limits. As part of this project, several reports are provided to Federal Reserve including Single counterparty credit limits (SCCL), FR 2590 etc. on daily, monthly and quarterly basis. Data gets loaded from disparate sources that is staged and standardized. Reports are generated on top of the repository.

Understanding business functionality and ETL integration and reports requirements.

Participated in all phases of the Software Development Life Cycle (SDLC)

Preparing Test Plan, Test Scripts and Test Cases for ETL and Reporting.

Writing complex SQL queries and performing data Verification. Validating the data in reports against database.

Executing the test cases in ALM and logging the defects.

Creating Test data for testing. Comparing the results with upstream applications and through database SQL queries for validation.

Coordinated with Development Team for defect resolution.

Moving the Service calls through various SDLC phases post review of deliverable documents.

Defect Logging and Tracking to closure using ALM and JIRA.

Preparing Test results and self-reviewing the deliverables before final submission.

Attending daily scrum meetings and bi-weekly sprint planning sessions.

Environment: SQL, ALM, JIRA, ETL, Microsoft SQL Server, Teradata, UI Testing, UNIX, and Windows

Paychex, Inc Charlotte NC

QA Engineer Apr 2015 – Jun 2019

Paychex is one of the largest employee payroll processing companies in the USA with a $3B revenue and offering services such as Payroll processing, 401K services and HR Services. Worked as QA analyst for Data Management Team.

Understanding business functionality and complex integration of EDW.

Participated in all phases of the Software Development Life Cycle (SDLC)

Preparing QA design and flow charts to understand the Application testing.

Preparing QA Scenarios and test cases using HP Quality Center and executing the test cases.

Writing complex SQL queries and performing data Verification and Validation at Database level.

Creating Test data for testing. Comparing the results with upstream applications and through database SQL queries for validation.

Coordinated with Development Manager for defect resolution.

Moving the Service calls through various SDLC phases post review of deliverable documents.

Defect Logging and Tracking to closure using HP Quality Center and JIRA.

Preparing Test results and self-reviewing the deliverables before client submission.

Attending daily scrum meetings and bi-weekly sprint planning sessions.

Environment: Data Stage, Autosys, JIRA, UNIX, SQL, Windows, HP Quality Center

Educational Qualification

Bachelor of Technology in Computer Science, 2013 Graduate.

Ashritha Saraff

Mobile: 980-***-****

************@*****.***

Contact this candidate