Back to Developers
Vandana Kandagatla

Vandana Kandagatla

Data Analytics and Data Engineering professional

Michigan, USA 1+ yrs exp 89 · Excellent

About

Data Analytics and Data Engineering professional with hands-on experience building data pipelines and analytics workflows using Azure Data Factory, Azure Databricks, and Azure Data Lake. Proficient in SQL and Python (PySpark) for data processing, transformation, and ETL workflows. Experienced in data analysis and visualization using Power BI and Excel to track KPIs and deliver actionable business insights. Capable of bridging data engineering and analytics to support scalable data solutions and business decision-making.

Skills & Expertise (31)

Power BI Advanced
8.2/10
2
Years Exp
Python Intermediate
7.4/10
2
Years Exp
DAX Intermediate
7.4/10
2
Years Exp
SQL Intermediate
7.4/10
2
Years Exp
Data Modeling Intermediate
7.0/10
2
Years Exp
Power Query Intermediate
7.0/10
2
Years Exp
ETL Intermediate
6.6/10
2
Years Exp
Azure Data Factory Intermediate
6.6/10
2
Years Exp
Azure Databricks Intermediate
6.0/10
2
Years Exp
Data Warehousing concepts Intermediate
6.0/10
2
Years Exp
Data Cleaning Intermediate
6.0/10
2
Years Exp
Tableau Intermediate
6.0/10
2
Years Exp
Power BI Service NumPy Pandas GitHub Git NoSQL concepts relational databases MySql Medallion Architecture PySpark Pivot Tables KPI Dashboards Delta Lake Azure SQL Database Azure Synapse Analytics Azure Data Lake Storage Excel KPI Reporting Exploratory data analysis

Work Experience

Orientation Data Analyst

Grand Valley State University

Jan 2025 - Aug 2025

Collected, cleaned, and analyzed orientation survey, registration, and attendance data from Qualtrics and Slate CRM to support data-driven evaluation of the Student Orientation program. Built automated data processing workflows using SQL and Python, simulating ETL pipelines for extraction, transformation, and consolidation of structured data. Developed interactive Power BI dashboards using DAX measures, calculated columns, data modeling, drill-through functionality, slicers, and KPI scorecards to track student satisfaction, session effectiveness, academic preparedness, and engagement trends while improving stakeholder reporting and self-service analytics. Analyzed survey responses and attendance patterns, producing analytical summaries and visualizations that informed weekly performance reporting, program planning, and orientation improvements. Collaborated with stakeholders through iterative feedback cycles to refine reporting requirements and improve reporting workflows.

Associate Consultant

Infor

Apr 2022 - Jul 2023

Resolved production incidents in Infor ERP LN, analyzing finance and manufacturing data to identify inconsistencies, reporting gaps, and functional issues. Implemented ERP customizations and enhancements to support client-specific reporting and data requirements. Analyzed ERP transactional data using SQL-based data access to investigate anomalies, validate data flows, and support issue resolution. Developed and maintained Power BI dashboards and reports based on ERP data, creating DAX measures, KPI dashboards, and interactive visualizations to monitor operational performance. Created and streamlined Excel-based reports, pivot tables, and KPI tracking solutions that enabled faster analysis, decision-making, and response to recurring data requests. Collaborated with consultants, technical teams, and client stakeholders to translate business requirements into data-driven solutions. Supported client projects including Aston Martin Lagonda (AML) by addressing ERP data issues and reporting-related customization requests.

Education

Master of Science, Data Science and Analytics - Grand Valley State University

- 2025 · Afghanistan

Bachelor of Technology, Information Technology - JNTUH University College of Engineering

- 2022 · Afghanistan

Certifications

PL-300: Microsoft Certified Power BI Data Analyst Associate

· 2025

Google Data Analytics Professional Certificate

· 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 89/100

Profile Overview

Member sinceJul 2026