Davide Sgroia
Data Scientist/Business Data Analyst at MAURELLI GROUP- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Inglese Professional working proficiency
-
Italiano Native or bilingual proficiency
Topline Score
Bio
Experience
-
MAURELLI GROUP
-
Italy
-
Transportation, Logistics, Supply Chain and Storage
-
1 - 100 Employee
-
Data Scientist/Business Data Analyst
-
May 2023 - Present
📌 Role and Responsibilities: Extraction and manipulation of raw data from various sources, such as SAP, through advanced use of T-SQL (Microsoft SQL Management Studio). Transformation of data through in-depth analysis using the DAX language and PowerBI, creating interactive reports and dynamic visualizations that guide informed decisions. Application of advanced Excel skills, including the use of advanced formulas, pivot tables, and the creation of dashboards for detailed analysis and visual communication of results. Automation of workflows using Knime. Utilization of Python, NumPy, and Pandas (basic level) for data analysis, process automation, and dataset manipulation. Collaboration with the decision-making team to identify trends, patterns, and opportunities through statistical analysis and data mining. Design and implementation of analytical solutions to address specific business questions. 📈 Key Skills: Advanced Excel: - Advanced formulas (VLOOKUP) - Interactive DashBoard - Automated spreadsheet - Pivot Table - Criticality data analysis - Data Mining PowerBI: - Report View - DAX language - Filters and Row Context - PowerQuery - Relational Database SQL: - Stored Procedures - Jobs - CTE (Common Table Expressions) - Functions and Triggers - Excellent communication and presentation skills - Ability to work in a team and collaborate with colleagues - Problem-solving skills and adaptability to new challenges Show less
-
-
-
SARIM AMBIENTE SRL
-
Italy
-
Environmental Services
-
1 - 100 Employee
-
Data Analyst
-
Feb 2020 - Mar 2023
◉ Company database reconciliation via: Excel - Qgis - Power BI - SQLAdvanced Excel: - Advanced formulas (vlookup) - Interactive DashBoard - Automated spreadsheet - Pivot Table - Criticality data analysis - Data MinigPowerBI: - Report View - Dax language - PowerQuery - Relational DatabaseSap: - Ticket Management - Reporting and data entry in SAP - Problem SolvingQgis: - Territorial Mapping - Database creation - itinerary analysis◉ Analysis and graphs in Excel, Power BI to facilitate business data reading◉ Sql language (base knowledge) for difficult database reconciliation◉ First support (Tier II) for internal problems (Hardware and software) Show less
-
-
Analista dati
-
Feb 2020 - Mar 2023
-
-
-
Iudav
-
Napoli, Italia
-
Unity Developer
-
Feb 2019 - May 2019
University project aimed at developing mini-games using Unity 3D University project aimed at developing mini-games using Unity 3D
-
-
-
Crown Imballaggi Italia S.r.l.
-
Battipaglia, Italia
-
Operaio Metalmeccanico
-
Jun 2013 - Oct 2018
-
-
Education
-
Institute Valletta Higher Education Institute (IUDAV)
Bachelor's degree, Digital Arts - specialization in programming, Bachelor Degree -
Udemy Alumni
Master SQL, Database Management & Design, Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL -
Udemy
Microsoft Power BI - The Complete Masterclass -
Udemy
Data Analysts Toolbox: Excel, Python, Power BI, PivotTables, Course -
Informa
Java programming