Built with datascienceportfol.io

Alec

Business Analyst Open to Work

Based in San Jose, CA

About

I recently graduated from San Jose State University with a bachelor's degree in Marketing / Business Analytics. Throughout my experience I have been able to learn many analytical skills like SQL, Tableau, Excel, RStudio, and statistics. I was fortunate enough to use these skills in an internship with The City of San Jose where I examined market segment demographics, collected/analyzed data, and provided findings using visuals from Tableau and descriptive statistics from RStudio. I am looking forward to further expanding my knowledge and experience in the data analytics field and most importantly provide value to companies who allow me to be a part of their community.

Skills

Projects

Experience

April 2022 - Present

Program Analyst for City of San Jose

Trusted with monitoring and cleaning company data handling over 50 documents and reports monthly. Utilized Excel Solver to assist in employee scheduling which increased employee productivity by 5%. Conducted an analysis on our recreation programs offered which has led to the increase of occupancy by 3% and customer satisfaction by 12%. Managed projects and held bi-weekly meetings to communicate to managers about project tasks, challenges, and proposed solutions. Assisted in project budgeting by analyzing operations and researching new efficient processes that resulted in cutting costs by 6%.

February 2024 - May 2024

Intern, Data Analyst for City of San Jose

Collaborated with peers to find a viable reuse of a historic building which is located on a new San Jose park that is being built soon. Research and analyzed the demographics of adjacent San Jose neighborhoods, the neighborhood needs, and the characteristics of the historic building using the GIS database cloud. Collected data from nearby San Jose community centers to estimate the demand for recreation programs and the demand for art galleries in the neighborhood which involved using statistics via RStudio. Created several recommendations for the reuse of the historic building that is supported by reliable and relevant data. Developed a detailed report that included descriptive statistics of the neighborhood demographics, tableau visualizations of our findings, and our recommendations

Education

2020 - 2024

Business Analytics at San Jose State University