Post Job Free

Resume

Sign in

Data Analyst

Location:
Philadelphia, PA
Salary:
60000
Posted:
January 11, 2021

Contact this candidate

Resume:

Dante Alessandro Arnone

**** *** ****, 215-***-****

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



Contact this candidate