Dante Alessandro Arnone
Dresher, PA 19025 adjcgw@r.postjobfree.com
Education
Pennsylvania State University - May 2017
Baccalaureate Degree in Business Management
Named to Dean’s List for 3 semesters
Technical Skills
Database SQL Server, PostgreSQL
Business Reporting Tools Tableau
Microsoft Software SSIS, Excel
Miscellaneous ETL, Pivot Tables, VLOOKUP, Stored Procedures, Dashboards
Certifications
Completed IBM Course “Python for Data Science” – October 2019
Completed IBM Course “SQL and Relational Databases” – July 2019
Completed Duke University Course “Managing Big Data with MySQL” – December 2018
Completed Duke University Course “Data Science Math Skills” – September 2018
Completed Duke University Course “Data Visualization and Communication with Tableau” – April 2019
Completed UC Davis Course “Essential Design Principles with Tableau” – June 2019
Completed UC Davis Course “Fundamentals of Visualization with Tableau” – June 2019
Relevant Projects and Coursework
Projects:
U.S. Startup Investment – May 2020 - September 2020
Performed ETL on excel startup data before importing into Tableau to join and analyze data
Utilized multiple dynamic sets to gauge profit threshold and recent growth percentages
Conclusions illustrated in interactive dashboard to demonstrate which startups were best to invest in
U.K. Bank Customer KPIs – December 2019 – March 2020
Performed ETL on excel U.K. Banking data to import into Tableau
Created various types of graphs to break down data by several different factors to illustrate KPIs on an interactive dashboard
Graphs and KPIs then broken down by each U.K. country with conclusions annotated in 5-page story
Coursework:
Created, modified, manipulated, retrieved and controlled access to SQL data
Employed stored procedures, views and temporary tables to query from stored hidden data
Wrote complex queries analyzing monetary data with the utilization of joins, subqueries and windows over several linking tables
Performed ETL on Excel files before importing into Tableau and SQL Server
Join and Blended data in Tableau to analyze KPIs on interactive dashboards and complex stories
Utilized SSIS to create integration service projects involving data flow tasks to convert excel, csv and SQL files