VASUDHA P B

Summary

Software IT professional with around 8+ years of diversified experience in Software Testing and Quality Assurance with various client/server as well as web-based applications. Worked as a Senior Snowflake Developer with RevonextSoft Technologies Pvt Ltd from June 2024 to till date 2026. Worked as Senior Quality Engineer with LTI from Oct 2021 to Jul 2022. Worked as Software Test Engineer with Rosal Soft Technologies Pvt Ltd from Aug 2015 to July 2021. Having experience using JAVA, Selenium, Postman, Swagger, Karate Framework (API Testing) using BDD Gherkin Syntax. Having knowledge on TestNG, SQL, UNIX/Linux. Having proven experience in Azure Devops, GIT, Jenkins. Strong debugging knowledge on Core Java coding. Proven experience in developing the UI, API Automation Framework using BDD Cucumber.

Overview

1

Language

10

years of professional experience

Work History

Senior Software Snowflake Developer

RevonextSoft Technologies Pvt Ltd

06.2024 - 01.2026

Migrated legacy data warehouse from SQL Server to Snowflake, handling 10+ TB of data, improving scalability and reducing operational costs by 30%.
Designed and developed scalable Snowflake data models (Star Schema), database objects, and optimized queries for large-scale analytics.
Tuned and optimized complex Snowflake SQL queries, improving query performance by 35–45% through clustering, caching, and query tuning.
Loaded flat files into Snowflake.
Implemented ETL processes to integrate data from various sources into Snowflake.
Developed and maintained ETL/ELT pipelines to ingest data from multiple sources such as SQL Server, DB2, flat files into Snowflake.
Implemented batch and near real-time data ingestion using Snow pipe and COPY INTO, reducing latency from hours to near real-time.
Monitored database performance, identify bottlenecks, and optimized queries for better efficiency.
Designed data pipelines:
Full load using COPY command
Incremental (delta) load using Streams, Tasks, and MERGE Resulting in 60% faster data refresh cycles.
Implemented Slowly Changing Dimensions (SCD Type 1 & Type 2), ensuring accurate historical tracking and improving reporting accuracy by 25%.
Leveraged Snowflake features such as Time Travel, Zero-Copy Cloning, Stored Procedures, File Formats, Views, and Caching to enhance data processing efficiency.
Performed performance optimization on large datasets (1B+ records) by introducing surrogate keys, partitioning strategies and query tuning.
Ensured data quality through validation and reconciliation processes, reducing data discrepancies by 40%.
Monitored and troubleshot pipelines, reducing failure rates by 30% and improving system reliability.
Built Power BI dashboards to monitor data latency, pipeline health, and task execution, improving visibility and reducing issue resolution time by 25%.
Created views, materialized views, and UDTFs to support reporting and analytics for business teams.
Used zero-copy cloning for safe testing and development, reducing storage overhead by 50%
Collaborated with cross-functional teams to gather requirements and deliver scalable data solutions aligned with business needs.
Mentored junior developers and improved team productivity by 20% through knowledge sharing and code reviews.
Created Dashboard for different kind of process in snowflake to monitor data latency and task status etc.
Loading tables from Different sources like Oracle, SQL Server, DB2 and flat files & wrote complex snow SQL scripts in snowflake to business analysis and reporting.
Created updated with snowflake best practices and implemented improvements to enhance performance and efficiency.
Performed data quality issue analysis using Snow SQL by building analytical warehouse on Snowflake.
Performance optimization done on huge record tables by adding surrogate key and replay counter.
Created the tables, views, file formats to load the data from external stages such as AWS S3 Bucket.
Created views and materialized views (user defined table functions) and data from views will be exposed for reporting in Power BI.
Used COPY INTO command to load the data from stage files to stage tables then by applying transformations inserted the data to final tables.
Created Snowpipes to automate Continuous data ingestion & Implemented Streams and tasks to process incremental data.
Implemented cloning to maintain zero copies in Snowflake and Time travel. Aware of Fail-safe concept.
Environment: Snowflake, AWS, DBT, My SQL, Oracle, Matillion, Airflow, Jenkin, GitHub

Senior Quality Engineer

LTI

10.2021 - 07.2022

To test the API of ESG Manager Portfolio module and Data Feeds module
Gathered business requirement to determine the feasibility and to convert them to technical tasks.
Involved in functionality discussion and understanding the same.
Preparing test cases for API Manual & Automation scripting.
Executing the test cases using postman and swagger.
Defect Logging, Defect Fix Verification and Test Summary Reporting through JIRA tool.
Getting the test cases reviewed by the Peers, Lead & Client.
Developed Automation Karate Framework per client need as part of API Automation testing.
Parameterization with multiple test sets of data.
Involved in writing pretests/pre-defined functions.
Developed and configured to run cases via multiple environments.
Configured to run testcases in parallel.
Integrated CI/CD for the Framework developed.
Followed Clean Code principles in Framework development to not hardcode.
Client Demo
Developed Extent Report generation integrating to the Azure Pipeline.
Possess excellent analytical, presentation, interpersonal and communication skills and an ability to work independently in a team environment.
Proficiency in interacting with customers and technical professionals for issues and problems Resolution.
Ability to work both independently and as a team member, good understanding of Onsite-Offshore model projects.
JIRA, Postman, Swagger, Karate Framework Using BDD Gherkin Syntax
Received Client Appreciation (MSCI) for the successful completion of Framework Development E2E.

Software Test Engineer

RosalSoft Technologies Pvt Ltd

08.2015 - 07.2021

Experience in Cloud-based Data Ingestion, Data Processing, Data Consumption and Snowflake data warehouse solutions leveraging & in addition to Snowflake, have experience on Bigdata management using any platform with hands-on knowledge of tools Data processing DBT/ETL tools such as Matillion, DBT, etc.
Experience in end-to-end implementation of Snowflake cloud data warehouse and Data Migration from on-premises preferably on RDBMS or NOSQL to Snowflake & Having experience with Snowflake utilities, ELT using Snowflake SQL, implementing complex stored Procedures and Snow Pipe.
Expertise in Snowflake advanced concepts like virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features.
Involved in Writing Test Plan, Test Cases, RTM.
Handling Selenium IDE and tweaking the scripts.
Experience in writing Dynamic xpath to find dynamic elements.
Extensively involved in Backend testing of SQL Queries using Oracle SQL.
Experience in identifying, analyzing, reporting and monitoring defects using defect tracking tool Quality Center, JIRA, Clear Quest.
Expertise and experience in performing different kinds of testing like Black Box, Functional, Verification and Validation End-to-end, Backend, Frontend, Regression, User acceptance testing (UAT).
Development of Automation Framework as per requirement using Selenium, Java, BDD.
Writing Automation Scripts and Execution of the same.
Report logging, Client/Stakeholders meeting and Demo.

Education

BE - Information Science

Visvesvaraya Technology University, Karnataka

Skills

E-governance, Banking

JAVA, Selenium, Unix, BDD Cucumber Using Gherkin Language

HP ALM QC, JIRA, Zephyr

Bugzilla, Clear Quest, JIRA

Interests

Listening to Music, Badminton, Carrom

Primary Roles & Responsibilities

Experience in Cloud-based Data Ingestion, Data Processing, Data Consumption and Snowflake data warehouse solutions leveraging & in addition to Snowflake, have experience on Bigdata management using any platform with hands-on knowledge of tools Data processing DBT/ETL tools such as Matillion, DBT, etc.
Experience in end-to-end implementation of Snowflake cloud data warehouse and Data Migration from on-premises preferably on RDBMS or NOSQL to Snowflake & Having experience with Snowflake utilities, ELT using Snowflake SQL, implementing complex stored Procedures and Snow Pipe.
Expertise in Snowflake advanced concepts like virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features.
Involved in Writing Test Plan, Test Cases, RTM.
Handling Selenium IDE and tweaking the scripts.
Experience in writing Dynamic xpath to find dynamic elements.
Extensively involved in Backend testing of SQL Queries using Oracle SQL.
Experience in identifying, analyzing, reporting and monitoring defects using defect tracking tool Quality Center, JIRA, Clear Quest.
Expertise and experience in performing different kinds of testing like Black Box, Functional, Verification and Validation End-to-end, Backend, Frontend, Regression, User acceptance testing (UAT).
Development of Automation Framework as per requirement using Selenium, Java, BDD.
Writing Automation Scripts and Execution of the same.
Report logging, Client/Stakeholders meeting and Demo.

Timeline

Senior Software Snowflake Developer - RevonextSoft Technologies Pvt Ltd

06.2024 - 01.2026

Senior Quality Engineer - LTI

10.2021 - 07.2022

Software Test Engineer - RosalSoft Technologies Pvt Ltd

08.2015 - 07.2021

Visvesvaraya Technology University - BE, Information Science