Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Sandeep Guguloth

Ann Arbor,USA

Summary

Data Analyst with 3+ years of experience building dashboards, optimizing SQL queries, and automating workflows with Python to deliver actionable insights. Skilled in process improvement, data governance, and cross-functional collaboration with IT and business stakeholders. Experienced in stakeholder communications, dashboard adoption strategies, and integrating workflows with enterprise systems. Familiar with REST APIs, JSON, and modern workplace automation practices to enhance user experience and engagement.

Overview

4
4
years of professional experience

Work History

Graduate Assistant - Data Visualization

Central Michigan University
01.2025 - 04.2025
  • Built interactive dashboards in Power BI/Tableau that improved academic reporting efficiency and reduced prep time by 30%.
  • Delivered targeted reporting to students and faculty, enabling audience-specific insights aligned with institutional goals.
  • Mentored 50+ graduate students in data storytelling and dashboard adoption, improving engagement and clarity of insights.
  • Tools Used: Power BI, Tableau, Excel, SQL

Data Strategy Analyst

Centene Corporation
08.2022 - 07.2023
  • Designed and deployed SQL pipelines and automated Python ETL workflows, ensuring reliable and accurate reporting across finance and operations.
  • Developed Power BI and Tableau dashboards tailored to executive and operational teams, improving decision-making efficiency.
  • Implemented data governance practices to enhance accuracy, completeness, and trust in reporting outputs.
  • Partnered with IT and business leaders to streamline workflows and adopt automation solutions that reduced manual effort by 15+ hours weekly.
  • Conducted cost and SLA modeling that drove $250K in projected savings and improved reporting consistency.
  • Project Overview: Supporting a leading logistics company in optimizing fleet management, delivery time prediction, and warehouse operations through advanced analytics.

Business Intelligence - Intern

Cognizant (schrill technologies)
01.2021 - 07.2022
  • Built SQL + Python ingestion pipelines integrating retail/finance datasets, cutting reporting latency by 40%.
  • Developed audience-segmented Tableau dashboards for campaign performance, enabling targeted marketing strategies and increasing ROI by 15%.
  • Partnered with marketing analysts to deliver data-driven communications (A/B testing insights), improving CTR by 9%.
  • Conducted data validation on 1M+ records, ensuring accuracy and compliance for enterprise reporting.
  • Documented best practices for BI workflows and communication reporting, enabling scalable solutions.
  • Project Overview: Supported retail analytics initiatives focused on customer segmentation, campaign performance, and inventory planning.

Education

Master of Science - Information Systems

Central Michigan University
Mount Pleasant
05.2025

Skills

  • Python and SQL
  • Data visualization with Tableau and Power BI
  • Excel proficiency
  • ETL processes and data pipelines
  • Reporting and analytics
  • Data governance and compliance frameworks
  • Data validation and reconciliation
  • KPI development
  • Workflow automation
  • Stakeholder engagement and communication
  • Mentoring and cross-functional collaboration

Projects

Job Management System | Python, MySQL, Tkinter

  • Built a full-stack hiring management application to streamline job postings, candidate applications, and employer tracking.
  • Designed interactive Tkinter interfaces for user-friendly navigation, including search and filtering functionality.
  • Developed normalized relational schemas in MySQL to manage job postings, applicants, and employers efficiently.
  • Automated candidate–job matching using optimized SQL queries, reducing manual screening time by 60%.
  • Completed full lifecycle delivery including requirements analysis, ER modeling, backend integration, and testing.

Airbnb Market & Profitability Analysis | Tableau, Excel, SQL

  • Analyzed 7M+ Airbnb rental records to identify pricing patterns, review distributions, and demand across NYC boroughs.
  • Designed Tableau dashboards (tree maps, bar charts, KPIs) to visualize market performance and pricing insights.
  • Conducted a profitability case study (“Story of Julie”), evaluating remodeling vs. renting scenarios for hosts.
  • Recommended maintaining current property state, achieving ~$5K annual revenue and reducing 3–5 year payback risk.
  • Delivered data-driven insights to support pricing strategy, investment planning, and competitive positioning.

Timeline

Graduate Assistant - Data Visualization

Central Michigan University
01.2025 - 04.2025

Data Strategy Analyst

Centene Corporation
08.2022 - 07.2023

Business Intelligence - Intern

Cognizant (schrill technologies)
01.2021 - 07.2022

Master of Science - Information Systems

Central Michigan University
Sandeep Guguloth
Want your own profile? Create for free at Resume-Now.com