Summary
Overview
Work History
Education
Skills
Timeline
Generic
Revathy Baskar

Revathy Baskar

Azure Data Analyst
Chennai

Summary

Senior QA Analyst with 8 plus years of IT experience in ETL/ Data warehouse backend testing, BI Intelligence reports testing and Application testing. Highly determined and detail oriented with profound knowledge of transformation rules verification processes and data sample comparisons. As a QA Analyst, indulged in various industry verticals like Retail, Banking and Finance, Capital marketing, Insurance ,Compliance and EPMO Firm understanding on ETL workflows and data architecture Have profound knowledge in retail domain along with EMV technology, cards and payment processing and IBM sterling Logistics Well acquainted with testing methodologies –Agile, STLC Thorough working experience in System testing, System Integration Testing, Functional testing and Regression Testing Demonstrated the ability to analyze and understand the business requirements using BRD, prepared Requirement Traceability Matrix, Test Design Artifacts-MTP, DTP, Test scenarios and test cases. Strong exposure in SQL query writing based on the mapping Transformation logic Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data warehouse / BI applications Proficient in Test management using HP-ALM and RALLY. Direct interaction with ITPM, Business stakeholders and driven walkthrough /Demo of test evidences Engaged in Agile Sprint Planning meeting, DSU calls ,Retrospective meeting-put forth risks and dependencies to count on key decision points, challenges and action items to be implemented in upcoming sprints Providing technical assistance and committed to mentoring team members/Newbie to enhance productivity. Good verbal and written communication skills and self-motivated to quickly cross skill on new technologies.

Overview

14
14
years of professional experience
4
4
years of post-secondary education

Work History

Senior Test Engineer

  • Domain Capital Market
  • Contribution:
  • Involved in analyzing the BRD,engage in requirement walkthrough meetings to ensure clarity of requirement changes
  • Preparation and tracking of Requirement traceability matrix to ensure 100 % test coverage
  • Created detail Test cases for each test phase to ensure complete coverage
  • Test Cases incorporates both positive and negative test conditions
  • Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData
  • Performed Count Validation, Metadata validation, Statistical Analysis and Data Quality Validation in Data Migration
  • Performed data validation(Nulls, duplicates, Missing data, Extra data, Special characters, FK/PK referential integrity, Default Values, SCD validation, Data type, Column Name, etc.) in both in Bulk and Incremental ETL
  • Executed Test Cases with respect to Source and Target database tables
  • Written SQL scripts for verifying CCAR reports against Database
  • Performing XML and Database validation for CCAR Reports
  • Performing Edit check validation for all CCAR Reports based on the latest requirement documents
  • Designed layout(source,target,testcase)on Inhouse ETL Tool( State street) based on the mapping logic , execute layout and identify bugs in case of entry in error log
  • Documented test evidences and raise defects in Test management tool HP ALM
  • Involved in Sprint Demo calls to walkthrough test results for every sprint

Test Engineer | Database Admin

  • Domain Retail
  • Contribution:
  • Understanding the EMV functionality for secure payment processing and business requirements
  • Involved in knowledge transfer on EMV functionality to the team
  • Analysis and preparation of test scenarios test cases
  • Test data setup and execution of test cases
  • Written SQL queries and executed DataStage jobs to test the functionality
  • Reporting the defects and getting them fixed and day to day onsite co-ordination
  • Comparison and Analysis of Mapping sheet with data loaded into Grid tables
  • Validation of execution logs and documentation of test results
  • Defect management using HP ALM
  • As a database Admin, involved in creation of users,grant and revoke access as per the user request
  • Deployment of DDLs changes in DEV and QA environment as per the change request
  • Data movement between environments (PROD,DEV,QA) using multiload & fast load export utilities in teradata

Developer

Atos Syntel
01.2020 - Current
  • Microsoft SQL Server management studio, Oracle SQL, , Hive terminal, Putty(Pyspark),RALLY, JIRA,Tableau, SDLC Compliance Dashboard, Power BI, Apptio ,PMT,SWCAP reports

Senior ETL Test Engineer

Atos Syntel
01.2018 - 01.2020
  • Domain EPMO(Compliance)
  • Contribution:
  • Involve in Sprint planning meeting , provide user story points and test estimation based on complexity of the user story
  • Elicit & understand ETL testing requirements, and Mapping including direct and complex transformation logic
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application and reporting changes
  • Developed ETL test scripts, framing complex SQL queries based on technical specifications/Data design documents and Source to Target mappings
  • Validate Pre and post upgrade changes in reports( PowerBI, Apptio, SWCAP reports)
  • Execute test scenarios on compliance Dashboard (Tableau) changes
  • Conduct DB validation tests, document test results in RALLY and communicate findings to development teams
  • Report and document defects found during test cycles in JIRA(defect management)
  • Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
  • Communicate timely status in DSU calls, including any potential risks/issues to the appropriate teams to ensure completion of all deliverables within schedule, budget and quality constraints
  • Engage in Show and Tell meeting to walkthrough test evidences to Business and Stake holders for every sprint
  • Key team player in maintaining and tracking team member activities using EQUIP and present the agile Metrics report and Equip closure report to manager to ensure there is no slippage for auditing, Tools handled: Oracle, Moody's application, Datastage, ALM (QC), CCAR, ETL Testing Tool, SQL Oracle SQL developer

Test Lead

Wipro Technologies Pvt.Ltd
01.2016 - 01.2018
  • Informatica DVO (ETL testing tool), SOAP UI, SQL server management studio 2012, HP ALM 12.2
  • Role:, Domain Insurance
  • Contribution:
  • Participation in analysis and identifying the Application background and process within a short span, when project had been taken over from other vendor at critical stage
  • Understanding of Business requirements, preparation of TDA, RTM and acquire appropriate approval from Business
  • Preparation of test scenarios, Test data, QA environment set up for test execution
  • Review the test cases designed and obtain sign-off from Business
  • Delegation of every day task to team members and have always ensured good productivity have been captured
  • Execution results and defect are managed using HP- ALM
  • Co-ordination with dev team to make sure defect closure are accelerated on time
  • Project status reports, Weekly status reports provided on daily/weekly basis to ITPM, Business and other platform leads to keep them informed on the progress from QA side
  • Preparation of Demo document to provide walkthrough on tested modules and complete end to end test activities to business.

Test Lead/ Senior test engineer

Wipro Technologies Pvt.Ltd
01.2014 - 01.2016
  • Informatica DVO (ETL testing tool), SOAP UI, SQL server management studio 2012, Putty, IBM Sterling- OMS (Order Management Systems),
  • WinSCP, Oracle SQL developer, UNIX, HP ALM, RALLY, Domain Retail
  • Contribution:
  • Understanding the user story and planning the test strategy to be followed for each user story
  • Involved in sprint planning and providing user story points for every user story
  • Co-ordination with dev team to understand the technical design and functionality
  • Preparation of test scenarios and test cases, get approval from Business
  • Test data preparation and configuration of applications in test environment required for test execution
  • Test execution for Table to Table, Table to File and File to Table validation
  • File validation includes Manual validation through SQL Queries and Automated Validation using Informatica 9.6.1 DVO (Data Validation Option Tool)
  • Executing UNIX jobs, Informatica workflows, SQL Queries to test the functionality
  • Maintain the execution progress using Rally tool for effective project management
  • Test execution results and defects are managed using HP ALM
  • Effectively communicated the daily progress with the program manager and the business analysts on daily scrum calls
  • Accepted ad-hoc requirements and supported for business value analysis and post live support
  • Have taken up the lead role in critical stage of the project and successfully accomplished the responsibilities within a short span of time

SQL Assistant

Wipro Technologies Pvt.Ltd
Putty
01.2012 - 01.2014

Education

B.Tech - Information Technology

01.2008 - 01.2012

Higher Secondary (12th) - undefined

10th - undefined

Skills

Technical skillsDatabaseSQL server 2005/2008, OracleUtility ToolsMicrosoft SQL Server management studio, Oracle SQL Developer, Hive terminal, Putty(Pyspark), CCAR,CCAS( Moody’s Application), Informatica DVO, WinSCP server(FTP), SOAP UI, Inhouse Automated ETL testing toolEquip(Internal audit activity)Test Management Tool HP Quality Center 90/110 (ALM),RALLY, JIRAReporting tool: Tableau, SDLC Compliance Dashboard, Power BI, Apptio ,PMT,SWCAP reportsServers: UNIX, WindowsProfessional skills

Timeline

Developer

Atos Syntel
01.2020 - Current

Senior ETL Test Engineer

Atos Syntel
01.2018 - 01.2020

Test Lead

Wipro Technologies Pvt.Ltd
01.2016 - 01.2018

Test Lead/ Senior test engineer

Wipro Technologies Pvt.Ltd
01.2014 - 01.2016

SQL Assistant

Wipro Technologies Pvt.Ltd
01.2012 - 01.2014

B.Tech - Information Technology

01.2008 - 01.2012

Senior Test Engineer

Test Engineer | Database Admin

Higher Secondary (12th) - undefined

10th - undefined

Revathy BaskarAzure Data Analyst