Overview
Work History
Education
Skills
Projects
Leadership
Timeline
Generic

William Czech

Chicago,IL

Overview

2
2
years of professional experience

Work History

Governance Data and Analytics Intern

Schneider Electric
Boston, MA
06.2024 - 12.2024
  • Implemented a data visualization dashboard in Tableau that provides KPIs on travel security metrics, improving data reporting processes and allowing supervisors to assess travel risks more effectively
  • Performed ETL operations on travel security reports using VBA programs in Microsoft Excel to create standardized data that can be integrated into Tableau dashboards
  • Communicated data management strategies to non-technical supervisors, enabling sustained data reporting procedures for security metrics
  • Coordinated with data suppliers to ensure data quality, improving the reliability of reporting metrics presented in Tableau and simplifying data validation processes

IT Development Intern

Aldridge Electric
Libertyville, IL
05.2023 - 08.2023
  • Improved the management of company datasets using Microsoft SQL Server and BigQuery to develop informative views of data, generate statistics, and create functions that simplified existing queries
  • Analyzed financial datasets on labor, time, and material costs using Tableau and SQL to discover metrics impacting the profitability of construction jobs
  • Presented data insights and internship performance to company employees through a PowerPoint presentation

Education

Bachelor - Computer Science and Engineering

University of Michigan
Ann Arbor, MI
04.2025

Skills

  • Python
  • Microsoft Excel
  • C/C
  • SQL
  • HTML
  • Tableau
  • Microsoft SQL Server
  • Git

Projects

Instagram Clone, 10/23-11/23

  • Collaborated with a partner to build an application that mimics Instagram, implementing Python functions and REST APIs to transfer data from a local database to a server, allowing users to create interactive posts,
  • Designed a series of HTML templates with embedded Python modules to create unique home screen and account pages based on user data, providing an interactive user experience

Relational SQL Database, 02/23-03/23 

  • Programmed a database in C++ that allows the user to input and modify information, join data tables, and generate indexes to speed up queries, imitating the functions of an SQL server,
  • Earned a project score of 97/100 for meeting requirements with memory usage, runtime speed, and functionality

Leadership

Executive Board Member, Alpha Delta Phi Fraternity, 12/21-12/23

  • Collaborated with an executive board team to manage internal finances, establish plans for gaining new members, and coordinate with the university to follow guidelines
  • Initiated trips to sports games, brotherhood dinners, and other social outings for members of the fraternity while managing an event budget

Timeline

Governance Data and Analytics Intern

Schneider Electric
06.2024 - 12.2024

IT Development Intern

Aldridge Electric
05.2023 - 08.2023

Bachelor - Computer Science and Engineering

University of Michigan

Similar Profiles

CREATE PROFILE
William Czech