Dheepthi N.v

SDET Lead with active experience as Senior Data Engineer with 14 years 5 months experience in data analysis, aggregating, preprocessing, cleaning, and transformation with cross-functional teams in Waterfall and Agile SDLC projects in Property & Casualty Domain.

Certified Snowpro Advanced

Professional with expertise in Snowflake architecture, data warehousing and cloud-based analytics. Skilled in SQL, ETL pipelines, and performance optimization. Enthusiastic about designing scalable data solutions to drive business insights. Based in Canada with Permanent Resident status.

SDET Lead at RANDSTAD INC (2026-08 – Present)

Client: Intact Insurance. Designed and executed data validation and testing strategies for enterprise applications, ensuring data accuracy, completeness, and integrity across systems.

• Performed end-to-end data testing using SQL to validate data transformations, business rules, and downstream data processing.
• Worked extensively with Snowflake for data validation, reconciliation, and testing of data pipelines and analytical datasets.
• Utilized AWS services for data staging, processing, and validation as part of cloud-based data workflows.
• Developed and executed complex SQL queries to validate source-to-target mappings, transformations, aggregations, and business rules.
• Performed Unix-based testing and troubleshooting, including execution and validation of data processing jobs and workflows.
• Analyzed requirements and collaborated with Business Analysts, Developers, Data Engineers, and SMEs to understand business rules and define test scenarios.
• Performed data reconciliation and defect analysis, identifying data discrepancies and working with development teams to determine root causes.
• Supported system integration and end-to-end testing across upstream and downstream applications and data processes.
• Reviewed test results, tracked defects, and communicated testing status, risks, data quality issues, and release readiness to project stakeholders.
• Provided technical guidance on SQL, Snowflake, AWS, Unix, and data testing practices and supported the team in troubleshooting complex data issues.

Senior Data Analyst & Engineer at COGNIZANT TECHNOLOGY SOLUTIONS (2021-07 – 2025-10)

Client: The Hartford. Designed and developed framework for migrating Data from Oracle to Snowflake using Talend & IDP tools.

• Worked on Setup AWS s3 & use it for staging process in Data migration.
• Worked on Postgres & Maria DB to create tables and design process to maintain the information needed for Premium Calculations.
• Worked as Technical Data Analyst and Business Analyst, interacted with Business customers, SMEs, and IT experts, and created Mapping for transforming & loading Data.
• Orchestrated Data preparation using Python & Snowflake scripting so that the relevant policy details used by Analytical Engine for calculating the Rating Premiums & Pricing factors.
• Involved in End-to-End Project activities like Design, Development, Testing and Product Delivery.
• Worked on creating scheduled jobs for Data loading, Data cleansing & Data transforming using JIL scripts and automated the same using Workload CA.
• Created Automated Test Framework using Python for automating the test case and test scenarios.
• Worked on Fixing Data issues reported by End users and Reporting teams to ensure Data quality.
• Built reports, dashboards, and analytics solutions using Guidewire data.
• Supported underwriting, claims, pricing, and operational analytics using data from Guidewire systems.

Software Development Engineer in Test at COGNIZANT TECHNOLOGY SOLUTIONS (2017-02 – 2021-06)

Client: The Hartford. Created Packages, Procedures and Functions as per the requirements to read, transform and load the data into Databases.

• Migrated data from various sources like excel, SQL, Oracle, XML files, Flat files using Oracle Packages and Commands.
• Created, Monitored, Debugged and Tuned Autosys jobs and Workflows.
• Created complex SQL queries for Data Analysis and Data manipulation. Organized Analytical Data, ensuring data quality and aggregate data for strategic reporting, performance optimization on Data Solutions.
• Worked in Both SDLC and Agile Scrum Development Model.
• Created scripts for converting CLOB files to XML files using Python/PySpark.
• Created scripts for parsing and loading XML files into HDFS directories using Python/PySpark.
• Created scripts for loading the XML files into Hive tables using HQL.
• Created shell scripts for sqooping data from Hive tables to Oracle tables.

Sr. Data warehousing /Business Intelligence Analyst at COGNIZANT TECHNOLOGY SOLUTIONS (2011-05 – 2017-01)

Client: The Hartford. Created Complex SQL queries, including table joins, triggers and other DML related operations to extract data from analytical data warehouse and ensured 100% data flow accuracy as per client needs.

• Created Test Plan/ Test strategy by analyzing the products and based on High level Design Document and Requirements.
• Written detailed and reusable Functional, System Integration and Regression Test cases.
• Developed business intelligence reports and dashboards indicating business metrics and KPIs utilizing business objects.
• Performed data analysis, data verification and validation of ETL source to target transformations and managed large databases to execute complex data manipulations.
• Expertise in ETL methodology, Slowly Changing Dimension types (SCD'S) analysis, validation of dimension and fact tables using star flake schema and snowflake schema based on relational and multidimensional modeling.
• Analyzed requirements and identified requirement gaps, conducted root cause analysis, created data reports, and monitored data thereby reducing validation effort by 20%.
• Identified gaps and inefficiencies in business process by profiling business requirements in P&C Insurance.
• Led a five-person offshore team for ETL projects, ensuring timely delivery; recognized by business stakeholders and higher management for excellent leadership skills and technical expertise.
• Collaborated with cross-functional project teams for data preparation, integration, ETL implementation and helped team for effective defect management utilizing HP Quality Center.
• Followed Shift-left process and transitioned SDLC to a test-driven development approach by bringing in data quality analysis during Requirements phase that helped doubling functionality, coding, and productivity.
• Automated regression suite for data extraction, analysis and information consolidation capabilities slashing manual effort in subsequent cycles by 60% and increased speed by 90%.

Master of Science in Software Engineering – VIT University (2011-05)