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%.
