Vignesh Ravisekar

Quality Analyst

Experienced and self-motivated test Engineer specializing in Database and ETL Testing, with 3+ years of expertise in designing and executing comprehensive testing strategies. Proficient in ensuring data accuracy, integrity, and performance through rigorous testing of databases and ETL processes.

adxvbp@r.postjobfree.com 790-***-**** Coimbatore, India WORK EXPERIENCE

Technical Support Executive

U-Next Private Limited

09/2021 - Present, Bangalore

Automated data cleansing with robust scripts minimizes manual intervention, streamlines testing, and ensures accurate results with comprehensive test data sets.

SQL database testing, including integration testing, query optimization, and data validation. Proficient in writing SQL queries to validate data consistency,data integrity, and perform data quality checks Proficient in end-to-end testing encompassing data extraction, transformations, and loading processes(ETL). Developed and executed comprehensive test cases and scripts to ensure reliable data integration. Resolved production issues and defects through comprehensive test planning, defect tracking, including issue reproduction in UAT Developed Selenium Test automation using Java with BDD approach for multiple modules in an application.

Engineered Power BI dashboards and customized MS Excel models for effective testing and monitoring for interaction with Team. Created and executed detailed test scenarios, including sanity tests, to validate the functionality of software applications. Utilize daily Scrum meetings to facilitate efficient project management and Maintained comprehensive technical documentation in Azure DevOps(sprint plan)

Projects - TracMARKS (Evaluation Platform), merittrac Pariksha, TalentNext and Remote proctoring(Assessment Platform) Quality Analyst

Texila Educational and Management Services (P) Ltd 09/2019 - 05/2021, Coimbatore

Designed data models for a data warehousing application, enabling efficient process management within the ERP system for test plans. Performed quality assurance checks, root cause analyzing data to identify gaps and implementing corrective/preventive measures to enhance quality based on the findings to ensure customer focus. Performed requirement gathering for ETL testing, encompassing the creation of data flow diagrams and mock-ups for diverse projects. Developed visually engaging reports using data from warehousing-based applications, empowering executives to make informed decisions using advanced Excel capabilities by providing feedbacks. Generated comprehensive reports documenting the data cleansing and ETL processes, effectively communicating the results of data analysis and quality improvements with Test Execution report.

Project - ERP, CRM, LMS, Project Management

EDUCATION

M.Sc Software System (75%)

KG College of Arts and Science

06/2014 - 03/2019,

SKILLS

Strategic planning Gap analysis

Analytical thinking Defect Management

Conflict resolution Continuous learning

PROJECTS

TracMARKS (09/2021 - Present)

The project is based on an On-screen marking

solution (Evaluation Platform)

Achievements

I performed the integration with data reconciliation in UAT environment in SQL databases

Automated several processes by developing SQL

jobs and leveraging Advanced Excel for application testing.

Prepared timely defect reporting within SLA,

providing updates to the Tech lead with accurate and up-to-date information on the identified issues.

Pariksha and TalentNext

Both projects are based on the Assessment platform used for conducting assessments.

Achievements

Developed a few modules using Selenium java

enables behavior-driven development (BDD).

Implemented and managed Linux server backup

verification, ensuring backup file integrity and

accuracy, and migrated backups to AWS S3 Glacier.

ERP & CRM (09/2019 - 03/2021)

Created KPI dashboard using transformed and

loaded data, ensuring accurate representation of

calculations, aggregations, and visualizations.

CERTIFICATES

Google Data Analytics

Selenium WebDriver with Java

Databases and SQL Querying

TECHNICAL SKILLS

Selenium Java

Data Validation and Verification

Microsoft SQL

Microsoft Advanced Excel

Agile Methodology and STLC

Contact this candidate