Highlights:

Skills:SQL, Tableau, Python, Excel, Dashboard, R

Data Analytics Intern 06/2022 - 08/2022
CommunityAmerica Credit Union, Lenexa Kansas, United States
Develop dashboards after extracting raw data and curating the data. SQL queries play a big role in data curation during this internship.
Data Analytics Internship (June 2022 – August 2022) Community America Credit Union • Data Extraction and Prep – database communication and extraction from open-source Capital IQ • Predictive modeling – Projected growth algorithm to calculate new product potential success using Holt-Winters method. • Python – projected growth functions with predictive modeling • SQL database management - building reports from the data warehouse • Tableau Visualization – developed a workbook to tell a story for market research in the state of Missouri and Kansas. • Product Line Analytics – Support each department with ad hoc analysis • Member Analytics – Quantitative methods to segment, analyze, and interpret the composition of our member base and their interaction with the credit union. • Process automation – leverage data and logical programming to develop prediction algorithms. • Innovation Management – Risk management focuses on developing a dashboard using OnSpring software. • Group Intern Project – Develop a new member referral program with the main focus on digital marketing.--

Rockhurst University 08/2020 - 06/2024
Kansas City, Missouri, United States
Degree: Bachelor's Degree
Major:Analytics and Technology
I mostly work with an organization's structured data. I learned to create reports, dashboards, and other visualizations on data associated with customers, business processes, market economics, and more to provide insights to senior management and business leaders in support of decision-making efforts

Login to view resume: Alfonso Esqueda -