Data Analyst Social Media

LAKSHMI SAI PRASANNA VURENUKA

Cleveland, OH ***** 216-***-**** **********@*****.***

Highly motivated and analytical graduate student in Information Systems, seeking a Data Analyst role. Proficient in data visualization

(Tableau, Power BI), data querying (SQL). Experienced with cloud platforms (OCI) and familiar with project management using Jira. Passionate about creating secure, scalable solutions in collaborative tech environments. RELEVENT PROJECTS

Project: Social Media Risk Analysis Using Kaggle Dataset May-2025

• Analyzed a dataset of 1,000+ students across 10 countries, focusing on social media usage and relationship behaviors using Python and Pandas.

• Cleaned and explored data to identify trends in average daily usage (0–24 hrs.), sleep hours, and mental health scores among students aged 16–25.

• Engineered a custom “Social Media Risk Score” by normalizing and combining 4 key factors: addiction level, usage hours, sleep, and mental health.

• Categorized students into 3 risk groups (Low, Moderate, High) and visualized risk distribution using Matplotlib and Seaborn, highlighting key behavioral patterns.

• Gained hands-on experience in processing and analyzing 1,000+ survey responses, performing feature engineering, and data visualization for actionable insights

Project: CSU GO Parking Application- Data Integration and Real-Time Parking Management System

(Cleveland State University) Spring 2024

• Integrated and analyzed cross-platform data from legacy systems (T2 and WPS) into a unified MySQL database, enabling real- time parking availability, payments and enforcement data tracking.

• Collaborated in designing and testing a centralized dashboard, using web flow API and PayPal POS system to streamline user operations and enforcement workflows with real-time data updates.

• Utilized database APIs to perform CRUD operations for managing parking user profiles, payment records, and violation logs, supporting data consistency and improved user experience. Project: Defect Rate Analysis and System Simulation using System Dynamics (Cleveland State University) Fall 2023

• Modeled and simulated defect reduction processes using vensim, applying system dynamics concepts such as stock and flow diagrams, casual loops, and time-step simulations.

• Analyzed trends and forecasted system behavior by quantifying key variables (e.g., defect introduction rate, maintenance wear), identifying bottlenecks and improvement opportunities.

• Generated actionable insights from simulation data to support decision-making in quality improvement initiatives, combining data analysis and systems thinking.

Project: Touchless Hand Hygiene and Automated Access Control System using Arduino

(Malla Reddy Engineering and Management Sciences) May 2022

• Designed and developed an embedded automation system using Arduino UNO, IR Sensors, Ultrasonic sensors, servo motors, and relay modules to ensure hands are washed before granting access through an automated door system.

• Integrated real-time sensor data processing to control water flow, monitor handwashing activity, and trigger door access via servo motor only upon successful hygiene verification.

• Programmed and tested the prototype using Arduino IDE and C/C++, showcasing potential applications in public hygiene- sensitive environments like malls, offices and hospitals during the COVID-19 pandemic. EDUCATION

CLEVELAND STATE UNIVERSITY, CLEVELAND, OHIO Master of Science, Dec 2024 Specialty: Information Systems

MALLA REDDY ENGINEERING AND MANAGEMENT SCIENCES Bachelor of Technology, Aug 2022 Major: Electronics and Communication Engineering

SKILLS

Programming: Python, SQL

Data Analysis & Visualization: Tableau, Power BI, Data Cleaning CERTIFICATIONS

• Oracle Cloud Infrastructure 2023 Certified Foundation Associate

• Hacker Rank Python Basic Certification

• Introduction to Programming Using Python

• Introduction to SQL

Contact this candidate