Alessandro Speranza

- Alessandro Speranza - Danais St., 15235 Athens (GR) Data Analyst | Remote amblasen Profile A freelancer, remote worker, self-starter and team player with excellent organizational attitudes, highly efficient with strong technical and analytical skills. Experience in cleaning, managing, manipulating, and analyzing datasets using the R tidyverse package and data visualization with R & Tableau. Ability to turn data into actionable insights, suggesting conclusions and supporting data-driven decision-making. Pro-active and result-oriented with broad capacity to improve the growth of the company. Excellent interpersonal and troubleshooting skills. Startup experience. SKILLS Data Analytics  R (RStudio | Data Wrangling (tidyverse package) | Exploratory Data Analysis | Data Visualization (ggplot2, ggmap, leaflet) | Text Mining | R Markdown | flexdashboard | htmlwidgets | R Shiny web applications)  Tableau (Desktop, Online) | Single reports & Dashboards  Alteryx Designer | ETL  Social Media Analysis (Twitter | YouTube)  Data Warehouse Analysis | Design | ETL (Kimball) Databases & Storage  SQL, T-SQL, PL/SQL  Git & GitHub version-control systems WORK EXPERIENCE Data Analyst | Remote Piptook | Bristol, U.K. May 2017 – present  Introduced Data Science new concepts (Text Mining) and R as programming language to clean, manipulate, explore and visualize data  Re-engineered and improved the data collection process from various social media sources (Twitter, Facebook and Instagram) using R and related text mining techniques  Standardized the process to create Datasift/Powertrack queries through ad-hoc Alteryx applications  Improved the existing Tableau reporting’s techniques introducing a new classifiers’ formula, new comparative visualizations (divert and slope bar charts) and new solutions for the dashboards’ layout  Converted the 3 most strategic Alteryx ETL processes to R scripts (JSON files parsing, aggregation and conversion into a single csv file to elaborate with R/Tableau, Full Network Edge List and Full Network Gatekeepers) reducing the data loading time by 65%  Started to use R Markdown and R Shiny to turn the analyses into high quality documents and publish interactive web applications  AWS Amazon Redshift, S3  Microsoft SQL Server-  PostgreSQL  Oracle Database 11g-12c LANGUAGES  Italian (Native) Senior BI Analyst / Data Visualizer | Remote DataKraft Ltd. | Dublin, Ireland Jul 2015 – Apr 2017  Implemented a SQL algorithm (procedures & triggers) to reschedule automatically (Auto Schedule) the Datakraft projects' tasks  Designed and developed 4 JMC Brands' dashboards using data from both AdWords and Double Click campaigns  Migrated 75 Banner reports from Oracle Reports 10g to Oracle BI Publisher improving both data quality and the layout  English (Professional Working)  Greek (Professional Working) Senior Data Warehouse & BI Engineer MR HealthTech | Athens (Greece) EDUCATION  Degree in Civil Engineering (108/110) University of Pavia (Italy) 1998 Mar 2012 – Jun 2015  Designed Data Warehouse ETL processes/workflows by defining both the overall architecture and single database objects  PL/SQL Programming, Best Practices, Tuning and Optimization  Created BI Reports and ad-hoc analyses using Oracle OBIEE 11g  PET Cambridge University (U.K.) BI | DWH Solutions Consultant Oracle Corp. | Athens (Greece) Jan 2007 – Mar 2012 Data Warehouse Analyst | Developer ING Direct Bank N.V | Milan (Italy) Apr 2004 – Dec 2006