About me
I am a recent graduate from the University of Iowa Tippie College of Business, where I earned a B.B.A in Business Analytics & Information Systems and complemented it with a minor in Computer Science. As an aspiring business analyst, I possess a diverse skill set acquired through my education and hands-on experiences.
Throughout my academic journey, I have honed my expertise in data wrangling, data mining, data analysis, and data visualizations. I thrive in translating complex datasets into meaningful insights and actionable strategies. My ability to gather comprehensive business requirements empowers me to conduct in-depth analysis, leading to the creation of dynamic visualizations and interactive dashboards.
Proficient in both Python and R, I confidently undertake advanced analytics and machine learning projects. My passion for leveraging cutting-edge technologies to derive valuable business insights drives me to explore new methodologies and implement innovative solutions.
Having completed my studies in May 2023, I am now eager to embark on a fulfilling career where I can contribute my skills and dedication to drive organizational success. As a results-driven professional, I am committed to providing data-driven solutions that optimize business processes and foster growth.
Let’s connect and explore the possibilities of collaboration in the dynamic realm of data analytics and business intelligence.
I AM LOOKING FOR WORK IN THE GREATER CHICAGO AREA, IL.
- University of Iowa Tippie College of Business
- B.B.A Business Analytics & Information Systems
- Minor in Computer Science
Projects
Click tabs*
First, scraped data from PGATour.com using the website’s GraphQL API and python libraries such as pandas. The data contains various stats for golfer’s from 2007-2022. Exported the data as a CSV file.
Conducted Exploratory Data Analysis such as calculating summary statistics, visualizing distributions and relationships, detecting outliers, and checking for missing data. Additionally, performed correlation analysis to assess the relationships between different variables. This helps to better understand the data set as a whole.
Lastly, utilized Excel to package the data for Tableau. Created an interactive Tableau Dashboard to display useful information on PGA Tour Player Statistics.
Tools Used:
- Python (Jupyter Notebooks)
- Microsoft Excel
- Tableau
I successfully designed and implemented a data integration solution using Azure Data Factory (ADF) to streamline data processing and analysis. The primary objective was to populate custom Azure SQL Database tables with data from multiple views, ensuring efficient data organization and retrieval. To achieve this, I created a robust data pipeline in ADF that extracted data from the views and loaded it into the corresponding Azure SQL Database tables. This pipeline automated the data transfer process, eliminating manual intervention and ensuring data consistency.
Additionally, I leveraged ADF to develop a second pipeline, this time to handle JSON data stored in an Azure storage account and ingest it into Azure Cosmos DB containers. This allowed for seamless data synchronization and ensured that the data stored in Cosmos DB was up-to-date and aligned with the source data.
To enable data-driven insights and visualizations, I utilized Power BI. By connecting the data sources from Azure SQL Database and Azure Cosmos DB to Power BI, I created an interactive dashboard with insightful visuals.
Ultimately, this project exemplified my expertise in designing end-to-end data solutions, from data extraction to visualization, contributing to enhanced data-driven decision-making within an organization.
Data Mining Course Project
Utilized RStudio to build and test various machine learning models on a Kaggle dataset containing data on employee turnover.
- Collected data from kaggle: 9,000+ employees, 10 features
- Conducted EDA within RStudio
- Trained various models (Decision Tree, Random Forest, Gradiant Boost, Adaboost, Radial SVM, Polynomial SVM, Logistic Regression, Neural Network)
- Based on performance metrics (validation AUC, accuracy, precision, and recall), chose a Random forest model with 86.4% accuracy.
Collaborated with a sponsor to find ways to sell/monetize transactional data for FavTrip (gas-station/convenience store chain).
Met weekly to consider monetization techniques, utilized RStudio to clean/package the data, utilized Tableau to create an Interactive Dashboard of visuals. Some tasks we completed include:
- Cleaned FavTrip’s transactional data for analysis
- Packaged data for potential buyers
- Created R-scripts (e.g. basket analysis) to aid in internal operations
- Created an interactive Tableau dashboard to leverage data for selling ad space on gas pumps
Skills/Tools
March 2023
Plano, TX
U.S. Information Technology Collegiate Conference
● Placed among the top-5 in a national competition performing Microsoft Office Solutions case study assessing a wide variety of skills in Excel, Word, and PowerPoint
● Developed proficiency in C# and the .NET framework through self-directed learning to compete in an application development competition
● Demonstrated problem solving skills and ability to work under pressure while developing strong IT skills and experience
05/2023
Microsoft Certified
Azure Data Fundamentals (DP-900 Exam)
02/2024
Microsoft Certified
Power BI Data Analyst Associate (PL-300 Exam)
My Experience
10/2023 - Present
Tippie College of Business
BUSINESS INTELLIGENCE CONSULTANT | Kru-Marc Inc.
● Collaborate with a major pharmaceutical client to gather business requirements and identify data sources for sales leadership and field team analytics.
● Develop comprehensive Power BI applications that integrate pharmaceutical sales data (e.g., account, healthcare provider, prescription, and communication records) into cohesive, user-friendly dashboards.
● Write complex SQL queries to extract and manipulate data from Snowflake's cloud-based data warehouse, ensuring precise data retrieval for business-critical reporting.
● Design and implement robust Power BI data models, optimizing for performance and accuracy to handle large-scale, multi-source data sets.
● Spearheaded efforts to streamline Power BI development processes and enhance application performance through query optimization, indexing, and calculation improvements, leading to company-wide adoption of more efficient practices.
● Customize and extend Power BI functionality to meet unique client needs, including advanced DAX and dynamic reporting features.
● Provide ongoing support and training to sales team, ensuring they effectively utilize Power BI tools for decision-making.
● Utilized various Microsoft applications (e.g., Power Automate, SharePoint, Planner, etc.) to optimize internal office functions and automate redundant tasks.
06/2022 - 08/2022
Tippie College of Business
ANALYTICS CONSULTING INTERN | Tippie Analytics Cooperative
● Collaborated with multiple Non-Profit organizations to enhance data collection and analysis methods, resulting in improved insights and decisionmaking.
● Developed online surveys, an efficient REDCap database, an automated inventory system, and dynamic Tableau visualizations to enhance data management and reporting capabilities.
● Ensured a seamless transition to the upgraded database for each Non-Profit by delivering comprehensive and user-friendly instructions.
● Non-Profit Organizations: Iowa City Community Theater, Iowa Harm Reduction Coalition, and Linn County Mental Health Access Center
04/2022 - 04/2023
Bo-James Restaurant
Iowa City, IA
BARTENDER/SERVER | Bo-James Bar & Restaurant
● Served food & beverages accurately to customers.
● Learned to work effectively in a crowded, fast-paced environment.
● Demonstrated exceptional communication and interpersonal skills, fostering positive relationships with diverse customers, and enhancing overall customer experience
● Created a website for the restaurant using HTML, CSS, & JavaScript (soon to be published at bo-james.com)