Harshavardhan Reddy Arem
Ann Arbor
Summary
Dynamic professional with experience as a Teaching Assistant at Lawrence Technological University, where I enhanced student learning through effective feedback and academic guidance. Proficient in SQL and skilled in Python, I excel in data analysis and visualization using Tableau and Power BI, driving impactful results in educational settings.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Teaching Assistance
Lawrence Technological University
Southfield
01.2024 - Current
- Assisted professor in preparing and grading assignments and exams in a timely and consistent manner
- Provided feedback to the students to support learning and improvement
- Guided 50+ students outside class hours on their academics concerns and time management
- Designed DDL statements to create database, tables, student roles and passwords for lab sessions
Summer Intern
Rayalaseema Thermal Power Plant
Kadapa
06.2022 - 07.2022
- Inspected the power plant and gained practical knowledge on generating the electricity.
- Inspected heavy duty industrial constructions which are used for crushing coal to bear the vibrations in the columns.
- Analyzed the data of the electricity produced and distributed.
Education
Master of Science - Computer Science
Lawrence Technological University
Southfield, MI12.2025
Bachelor of Technology - Civil Engineering
National Institute Of Technology, Silchar
Silchar, Assam05.2023
Skills
- python
- javascript
- html
- css
- react
- SQL and NoSQL expertise
- Tableau
- power bi
- microsoft azure
Hobbies and Interests
- Learning new Technologies
- Movies
- Music
- Cricket
Languages
English
Professional
Hindi
Professional
Telugu
Professional
Extracurricular Activities
Secured 2nd Position among 16 teams in NCPL held at NIT Silchar Tecnoesis and Incandescence organizing team, 08/22 - 05/23, Responsible for all front desk duties at check in, check out, providing guest assistance, and communicating with other hotel staff Organised cricket Tournaments (Telugu Premier League and Telugu Farewell League), 04/21 - 05/23 Part of the Hospitality And Food management Team in cultural events, 07/19 - 05/23
Projects
Hospital Management System
08/23 - 12/23
- Designed and developed a hospital management system to manage patients, doctors, and appointment bookings.
- Created user-friendly interfaces for efficient access to healthcare data and workflows.
- Applied database normalization techniques (1NF, 2NF, 3NF) to ensure data integrity and reduce redundancy.
- Designed ER diagrams and performed data modeling and mapping.
- Implemented security features including user roles, permissions, strong authentication, and data encryption.
Ride-Hailing Analytics Dashboard
- Built an executive KPI dashboard tracking Total Bookings, Success Rate, Cancellation Rate, Driver-Not-Found Rate, Revenue, and Ratings.
- Analyzed driver vs. customer cancellations to identify key operational failure points and top cancellation reasons.
- Evaluated vehicle performance by comparing success rates, booking value, ride distance, and driver ratings across vehicle types.
- Conducted time-based analysis of wait times (V_TAT, C_TAT) to identify peak congestion and high-delay periods.
- Designed interactive dashboards with filters (date, vehicle type, payment method) for dynamic business insights.
Advanced SQL Querying & Data Analysis
- Wrote complex SQL queries using SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOINs (INNER, LEFT, RIGHT, FULL) to extract and analyze structured data.
- Performed advanced data analysis using aggregate functions (SUM, AVG, COUNT, MIN, MAX), subqueries, and conditional logic to solve real-world business problems.
- Applied data transformation and formatting functions (CAST, REPLACE, ROUND, TRUNCATE) to clean, standardize, and validate datasets.
- Solved analytical challenges involving ranking, filtering, distance calculations (e.g., Manhattan distance), and edge-case handling with high accuracy.
- Optimized SQL queries for performance and readability, with hands-on experience in MySQL and solving advanced problems on platforms like HackerRank.
Certification
Salesforce Certified Platform Administrator
Timeline
Teaching Assistance
Lawrence Technological University
01.2024 - Current
Summer Intern
Rayalaseema Thermal Power Plant
06.2022 - 07.2022
Master of Science - Computer Science
Lawrence Technological University
Bachelor of Technology - Civil Engineering
National Institute Of Technology, Silchar