Colin Villamana Portfolio About

A Little Bit About Me

Welcome! Above are images of me enjoying my various hobbies.

Outside of analytics I am a martial artist whose passionate about Brazilian Jiu Jitsu, Judo, and Grappling. Other activities that I enjoy include skiing, programming, archery, fishing, and hiking.

My experience in martial arts has taught me that the journey to mastery is long and never-ending. I'm fundamentally drawn to analytics because it allows us to "grapple" with complex questions (pun intended). As a bit of a nerd, I find that analytics provides a constant outlet for learning new things.

You can find my resume and contact information below. Feel free to reach out or check out my portfolio page!

Resume

EDUCATION AND CERTIFICATIONS

University of Arizona | Tempe, AZ | Anticipated Graduation May 2025
- Master of Science in Business Analytics
University of Connecticut | Storrs, CT | Graduated May 2021
- Double Major: Bachelors of Arts in Economics and History
Data Analytics Boot Camps | 2021 – 2022
- Google Data Analytics Coursera Certification
- Udemy SQL Bootcamp
- Udemy Python Bootcamp

WORK EXPERIENCE

Practical Data Solutions | Southbury, CT | Excel Visualization Analyst | January 2022 – Present
- Became the in-house subject matter expert on how to integrate Microsoft Excel with internal software.
- Expertly applied design principles to develop new dashboards and collaborated with a team to establish a cyclical design process, effectively addressing business inquiries by leveraging KPIs and metrics.
- Maintained the company's Excel dashboard library, ensuring all dashboards were error-free and adhered to publishing standards. Cleaned the library eight months ahead of schedule.
- Conducted monthly comprehensive 90-minute training sessions to educate clients on utilizing company software, helping them grasp advanced concepts.
- Developed client-specific dashboards while adhering to HIPAA guidelines and ensuring client/patient confidentiality, treating confidential data with utmost scrutiny.
- Automated quarterly tasks using an Excel Macro and leveraged Python for data cleaning automation, increasing efficiency and reducing error margins for key business tasks.
- Responsible for testing company software, using Microsoft Azure for bug documentation and tracking. Collaborated with a lead programmer to enhance and test software tools.
- Proposed and developed a company webinar on dashboard design. Successfully presented live, increasing user engagement with the company brand.
JP Morgan Chase | Bethel, CT | Associate Banker | Summer 2021 – January 2022
- Cultivated strong client relationships via exceptional professional conduct with over 50 clients daily.
- Managed over $500,000 in cash, assisting coworkers with vault management and compliance tasks.
- Regularly verified work to ensure accuracy, learning the importance of being detail-oriented and maintaining excellent standards of performance.

PERSONAL PROJECTS

Automotive Data Mining and Analysis
- Executed a project exploring a dataset of car listings from Autotrader. The project's goals include using common machine learning and data mining algorithms, such as K-Means clustering and regression analysis, to gain insights, and predict car prices.
Local Fishing Dashboard
- Developed a data pipeline for extracting, transforming, and visualizing regional fishing data. The pipeline employs Python for gathering and refining data, and Excel for creating visual representations. Gained insights into process design and data refinement techniques during the project.
Grocery Competitive Analysis
- Developed a Python web scraper to analyze grocery prices across various stores by extracting data from Instacart. Utilized Power BI for data visualization. Acquired knowledge in data ethics, process development, and programming throughout the project.
Python Dashboard Generator
- Created a Python application to generate sample dashboard architectures. The application is currently being refined, further developing skills in application development and programming.

SKILLS AND VALUES

SQL, Azure DevOps, Python (Pandas, NumPy, Seaborn), HTML, Excel, GitHub, Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Access), Power BI, Tableau.
Data wrangling, data modeling, data mining, exploratory analysis, k-means cluster analysis, regression analysis, decision trees, random forests, machine learning, Basic Familiarity With ETL, Manual Reporting. Process Automation.
Continuous Improvement, with an attention to detail, and a desire to do things right the first time.

HOBBIES