Amruth Anil Vannan Kandy - DATA ENGINEER

Overview

2

years of professional experience

4

years of post-secondary education

2

Certifications

Work History

DATA ENGINEER

TATA CONSULTANCY SERVICES (Data Analyst)

12.2021 - 01.2024

Conducted comprehensive data analysis using SQL and Power Bif, analyzing datasets from various sources and internal dashboards to provide actionable insights that enhanced product performance and supported business decisions
Collected, cleansed, and validated data from multiple sources, ensuring data integrity for use in business intelligence reports and decision-making processes
Designed and maintained interactive Power Bi dashboards, leveraging Power Query, DAX, and SQL to provide real-time visualizations, business performance monitoring, and insights for key stakeholders
Built and automated ETL pipelines to streamline data ingestion, transformation, and loading, ensuring smooth data flow and improving accessibility across cloud databases like BigQuery
Continuously developed and optimized reporting landscapes by enhancing existing dashboards, ensuring the availability of up-to-date insights and business metrics
Designed efficient SQL queries and data models for on-premises and cloud databases, enhancing data accessibility and supporting business intelligence tools
Ensured end-to-end data validation by tracking data from its source to visualization, identifying and rectifying discrepancies to improve data quality and confidence in reports
Acted as a consultant for business stakeholders, translating complex data insights into clear and actionable reports
Collaborated with cross-functional teams, including product, CRM, and engineering teams, to translate business needs into data-driven solutions and optimize operations based on data insights
Led the successful transformation of raw data into refined datasets using ETL techniques, improving data reliability and readiness for analysis
Documented data processes, pipelines, and findings to ensure knowledge transfer and easy accessibility for future analyses
Supported business development through data-driven strategies, providing key metrics and insights to identify business opportunities and optimize overall performance
Continuously improved data validation and testing practices, ensuring data quality from source to visualization
Advanced proficiency in Power Bi for creating, maintaining, and enhancing interactive dashboards and data visualizations that drive business insights.

Education

BACHELOR OF ENGINEERING IN MECHANICAL ENGINEERING - undefined

Aarupadai Veedu Institute of Technology

08.2016 - 05.2020

Skills

Database Management: SQL, MySQL, MS SQL, Oracle, PostgreSQL, Cloudera, HQL, Impala, Hive

Data Analysis & Visualization Tools: Microsoft Excel, Power Bi, DAX, Power Query, Microsoft 365, SharePoint Online

Data Warehousing & ETL: Expertise in MS SQL, Data Warehousing, ETL processes, Data Migration, Data Processing & Transformation

Programming & Scripting: Advanced skills in Python and SQL for automating data engineering tasks and optimizing data workflows

Data Validation & Quality Assurance: Experience in data validation, regression testing, and ensuring data accuracy from source to destination

Business Intelligence: Proficient in dashboard design, maintenance, and reporting using Power Bi

Mathematical & Analytical Skills: Strong knowledge of calculus, statistics, strategic thinking, and root cause identification

Project Management: Experience in project planning, data engineering, and implementing effective data solutions

Problem-Solving: Adept at identifying root causes, resolving issues, and implementing effective solutions

Relational Databases: Strong knowledge of relational database systems and their applications in business intelligence

Communication: Fluent in English, with strong cross-functional collaboration and communication skills

Soft Skills: strong problem-solving abilities and strategic thinking

Certification

Infosys, Introduction to Data Science

Projects

EATON DATA HUB IMPLEMENTATION, Executed rigorous data validation techniques, ensuring accuracy for real-time analytics; developed automated scripts that processed and cleaned data sets, leading to a measurable increase in processing speed by 40%, SQL Data Extraction & Analysis: Leveraged SQL to extract, manipulate, and aggregate data from relational databases, enabling comprehensive analysis and data-driven decision-making., Dashboard Development & Maintenance: Designed and maintained data-driven dashboards using advanced visualization techniques, transforming complex datasets into actionable insights for stakeholders., Comprehensive Data Analysis & Reporting: Conducted in-depth data analysis to identify trends, patterns, and discrepancies, contributing to enhanced decision-making across multiple departments and increase the efficiency., Stakeholder Communication & Insight Delivery: Delivered clear, impactful presentations to both internal and external stakeholders, translating complex technical data into concise, business-relevant insights., Created over 15 interactive dashboards and visualizations using Power Bi, delivering key insights that identified critical bottlenecks in processes and guided three optimization initiatives resulting in enhanced operational efficiency.