Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vishal Anand

Bangalore

Summary

Results-driven Data Analyst with over 4 years of experience in data integration, migration, transformation, and visualization. Proven success in managing large-scale datasets using Snowflake, SQL, ETL, and Teradata while ensuring quality and performance. Achieved significant efficiency improvements and cost reductions through the optimization and automation of data processes. Committed to continuous learning of new technologies to enhance skill sets and deliver exceptional value to clients and organizations.

Overview

4
4
years of professional experience

Work History

Senior Analyst

Accenture
Bangalore
09.2024 - Current
  • Worked as a backend developer on the dashboard migration project from Tableau to Power BI.
  • Responsible for developing DIM/FACT for the Power BI dashboard.
  • Responsible for requirement gathering, analysis, low-level designing, and implementation.
  • Creating and supporting customers with custom-built solutions through development, bug fixing, performance optimization, and business consultancy.

Snowflake Developer

TCS
Bangalore
03.2023 - 09.2024
  • Assessed customer requirements swiftly and implemented tailored code solutions.
  • Demonstrated expertise in Snowflake data modeling and advanced ELT development using Snowflake SQL.
  • Implemented virtual warehouse sizing and query performance tuning for optimal Snowflake usage.
  • Experience in data migration from RDMS to Snowflake cloud data warehouse.
  • Enhanced customer satisfaction through effective problem resolution.

Teradata and Snowflake Performance

Infosys
Bangalore
12.2021 - 02.2023
  • Designed and implemented complex database views and materialized views.
  • Enhanced operational aspects of queries through performance analysis.
  • Offered comprehensive support for troubleshooting user concerns with systems.
  • Assessed system diagnostics routinely to ensure consistent high-level performance.
  • Worked closely with DBA teams and infrastructure engineers to address technical problems.

Teradata to Snowflake Migration

Infosys
Bangalore
10.2020 - 12.2021
  • Engineered SQL-based technical solutions for Teradata and Snowflake applications.
  • Conducted comprehensive data analysis and database tuning.
  • Engineered ETL workflows for seamless data extraction, transformation, and loading into Snowflake warehouse.
  • Developed pipeline transitioning data from Teradata to Snowflake using Amazon S3 as an intermediate staging layer.
  • Utilized GitHub for version control in deploying the migration pipeline.
  • Conducted UAT testing through design of various test cases.
  • Resolved issues in advanced systems through comprehensive debugging.

Education

Bachelor of Technology - Computer Science

Institute of Technical Education And Research
Bhubaneswar
06-2020

Skills

  • Snowflake
  • Teradata
  • Query optimization
  • Data validation
  • Troubleshooting
  • Viewpoint Administration
  • Performance monitoring
  • Version control and Git
  • Stored procedures

Timeline

Senior Analyst

Accenture
09.2024 - Current

Snowflake Developer

TCS
03.2023 - 09.2024

Teradata and Snowflake Performance

Infosys
12.2021 - 02.2023

Teradata to Snowflake Migration

Infosys
10.2020 - 12.2021

Bachelor of Technology - Computer Science

Institute of Technical Education And Research
Vishal Anand