Hey! I'm Devin, a recent graduate with a Master of Science in Business Analytics from UC Irvine, class of 2024. I specialize in turning complex data into clear, impactful insights. My journey in data analytics has been fueled by a passion for innovative problem-solving and storytelling. I’m excited to bring my skills to the business/data industry, where I can help solve complex challenges and drive results. Here’s a bit more about me!
- Master of Science in Business Analytics, University of California, Irvine - Paul Merage School of Business (2023-2024)
- Bachelor of Arts in Business Administration, Minor in Pyschological Sciences, University of California, Irvine (2018-2022)
Trace3
Data Analyst Intern (Jan 2024 - June 2024)
- Performed advanced data analysis using Python and Power BI, supporting Trace3 in its mission to reducing the likelihood of clients missing payments
Options Pilot
Financial Data Analyst (Jul 2022 - Jul 2023)
- Performed advanced data analysis using Python and Power BI, supporting Trace3 in its mission to reducing the likelihood of clients missing payments
UCI Administrative Intern Program
Analytics Intern (Aug 2021 - June 2022)
- Analyzed participant data from events and summarized it into quarterly reports, providing qualitative and quantitative feedback about event improvements
Marketing Association at UCI
Student Data Analyst (Apr 2020 - June 2021)
- Optimized social media strategies using Instagram and Facebook metrics and utilized Google Analytics to analyze website traffic and user behavior, driving engagement and awareness
To keep things simple, I’ve compiled detailed descriptions of all my projects in one place, showcasing my skills in ETL processes, exploratory data analysis, data modeling, visualization, and more. I will provide a brief description of my projects below as well for a quick overview. Visit my detailed project portfolio below:
-
Coffee Sales Analysis (08/2024): Cleaned and analyzed sales data using functions such as XLOOKUP and INDEX Match as well as pivot tables to identify key trends, leading to a potential 15% increase in revenue
-
X-Ray Detection (Spring 2024): Developed a TensorFlow-based neural network for classifying if an image is an X-ray or not with 98% accuracy to allow for cost and time savings for hospitals
-
Harry Potter Social Network Analysis (Winter 2024): Conducted network analysis using character interaction data in Python with NetworkX for the Harry Potter series
-
Predicting Adoption Success in Animal Shelters (Winter 2024): Utilized Python and R to analyze and model data, aiming to improve adoption rates in shelters
-
Recipe Recommendation Engine (Winter 2024): Created a recommendation system using NLP techniques such as Word2Vec and TF-IDF to enhance user experience by providing tailored suggestions based on text analysis
-
Million Song Dataset Analysis (Fall 2024): Analyzed song features and performed regression analysis to identify trends that contribute to a song’s popularity over time
-
COVID-19 Analysis (01/2024): Analyzed COVID-19 data to identify key trends in infection rates and recovery patterns using SQL and Tableau
- Technical Skills: Python, R, SQL, Spark, Tableau, Power BI, dbt, BigQuery, Snowflake, Jupyter Notebook, Microsoft Office Suite (Excel, PowerPoint, Word, Access)
- Libraries & Frameworks: ggplot2, Beautiful Soup, Application Programming Interfaces (API), K-Nearest Neighbors (KNN), Scikit-learn, Matplotlib, NumPy, Forecasting, NLP, Seaborn, Pandas
- Hobbies: Playing basketball, crocheting, learning new languages
- Email: [email protected]
- LinkedIn: Devin Tian
I'm currently open to opportunities where I can contribute to data-driven projects and initiatives. Whether it's through data analysis or strategic planning, I'm eager to apply my skills to help organizations achieve their goals.
Thank you for visiting my profile! Feel free to reach out if you have any opportunities you think I might be interested in.