Vincenzo SANFRATELLO

8, Kirchberg, 6700 Sterpenich · (+32) 484 75 42 24 · sanfratellovincenzo1@hotmail.com

I usually act like this: "Anticipate, align, act". Having worked in both the business and development world for years, I want to continue to keep this "process automation" aspect which suits me well and take on new responsibilities.


Corporate Experience

Microsoft tech lead consultant

AKABI Luxembourg (customer in aluminium industry)

Maintain and extend the corporate datawarehouse. The system was developed by a 15+ years’ experience professional with a programming background. So everything was seamless to a extending a framework with strict rules, naming conventions and best practices.
As part of a team of 3 people, these were my responsibilities:
- Organize standup, sprint planning and sprint reviews meetings.
- Ingest data from several business units through SSIS data flows.
- Manipulate data with SSMS (tables, views, stored procedures,...)
- Use SSAS Tabular to pre-process multidimensional data model.
- Report data on PowerBI reports.
- Use Azure DevOps for code/projet versioning and release management.
- Create C# .NET console applications for business process automation.

August 2021 - Now

Data engineer consultant

AKABI Luxembourg (customer in banking industry)

Tracing of the business rules of a department on the basis of input and output data.
Using the SQL Server Integration Services ETL tool and all SQL Server Suite.

July 2021 - August 2021

Data analyst consultant

AKABI Luxembourg (customer in stainless steel industry)

Set up of a "Root Cause Analysis" functional dependencies tree. Customer had some slow PowerBI reports with too much functional dependencies (which often contributed to error generations).
Analysis and creation of a functional dependency tree as well as a possible optimized report.
Creation of a Microsoft Flow cloud flow which took care of generating tailor-made emails for members of the core business on a daily basis.

June 2021 - July 2021

Cloud data engineer Intern

AKABI Luxembourg

Development of a Framework for Cloud Big Data Platform, including staging, data warehousing and reporting using the Microsoft Azure technology stack. Creation of use cases around the theme of CO2 emissions from passenger cars. Collection of public datasets from European environmental agency and Luxembourg government.
Usage of:
- Azure Data Factory for orchestration
- Azure Databricks for transformation
- Azure Linked Services between Azure components
- Azure Databricks built-in secrets for sensitive information
- Azure DataLake with delta-lake approach for data cleaning and refinement
- Azure DevOps for CI/CD operations and tasks management
- Azure Microsoft Sql Server instance for Data Warehouse storage
- Power BI for designing dashboards and reports and visualizing insights

February 2021 - June 2021

Freelance Experience

QiwaInternationalFamily

Multilevel marketing web app development

Development of an ERP in PHP Laravel Framework with the use of Eloquent and SQL to query data from the database.
Design, implementation and modification of tables and constraints in the database with Datagrip.
Fine-tuning using javascript, css and bootstrap.
The most complex part of this project was the development of the affiliate system requested by the business department. The architecture needed to be maintenable and extensible as much as possible.

Artysmurf.com

Wordpress woocommerce e-shop (comics art industry)

Configuration of a Wordpress environment with woocommerce plugins' integration (web hosting, DNS, mail addresses, boutique, invoices, delivery and tracking).
Taking and editing pictures with professional tools such as Adobe Photoshop.
Customer training around the use of Wordpress and the installed plugins.
Fine-tuning using css.

PS/IC

Video production for municipal political campaign

Preparing the schedule.
On given guidelines, elaborating the copywriting, the scenario and the briefing to create a strong speech that was easy to remember.
On filming days, rehearsing as much as possible (priorities are framing and sound monitoring).
In post-production, usage of Adobe Premiere Pro and some sound effect from the Adobe Stock library.

Educational Experience

Gacci e-shop

Web Application DEVELOPMENT

Web application allowing any small producer to put their products online so that they can be purchased by Internet users. An 'unsold lots' section is also accessible and helps to reduce food waste.
The site is programmed in Asp.Net Core MVC 3.1.
The DAO part is provided thanks to EF Core.
Role management is done with Identity Framework.
Linq is used to manipulate data structures.
Data modeling is done via SQL server.
The UI is provided by bootstrap and very little CSS.

Virus Drive

N-tiers software architecture DEVELOPMENT

Project developed at the "Stay The Fuck At Home Hackathon" hackathon during the health crisis of Covid-19.
Development of a website and a mobile application that would allow supermarket customers to wait in their cars instead of lining up in front of stores (most hypermarkets have fairly large car parks) by scanning a single-use QR code at the entrance to the car park, which would reserve the order of the customer.
Building my first Restful API in Asp.Net Core MVC 3.1.
Developing my first Angular web application, which made calls to my API using the NGRX pattern.

MyMoney mobile app

Android Mobile app development

Mobile project, which consisted in facilitating the management of a monthly budget. The user could therefore enter a new expense or income, describe it and, if necessary, add a descriptive photo (a receipt for example).
Development done in Java.
Use of Android Jetpack for states and lifecycles management.
Exploit of external graphics library to schematize trends.
Data stored in local database.
Export / import data with JSON format.

Handsome

N-tiers software architecture DEVELOPMENT

Help your neighborhood and get paid with our app!

REST API
- C# ASP.NET Core MVC
- EF Core and Identity
- Linq to query the database data
- Swagger for documenting API endpoints and query these endpoints
- JWTs authentication
Front-end web app
- Angular
- NgRx for data flows management
- Bootstrap
Mobile app
- Flutter
- BLoC architecture for state management


Education

HELMo Campus Guillemins - Liège (Belgium)

Bachelor in Business ICT
Computer Science - Analyst Developer
2016 - 2021

Skills

Purpose Linguages and Tools
IDE Visual Studio, Eclipse, IntelliJ, Notepad++, PhpStorm, Rider
DB/BI Entity Framework, MySQL, Oracle DB, phpMyAdmin, SQL Server, Azure Data Factory, Azure Data Lake, Power BI, Access, JDBC
Frameworks ASP.NET Core MVC, ADO .Net, Bootstrap, Flutter, Linq, NUnit, RESTful, Laravel
Languages Java, C#, CSS, HTML, JavaScript, JSON, UML, Angular, Python, Perl, Powershell, TypeScript, JQuery, C, PHP
Collaboration GitLab, GitHub, Git, MS Teams, Redmine, Skype, Trello
Methodology/Modeling Design Patterns, DB-Main, Enterprise Architect, Entity-Association Model, Unit Testing, Microservice Architecture, REST, Scrum, Merise
Networks Active Directory, SOAP, DHCP, DNS, SSL
Operating Systems MacOS, Windows, Windows Server, Android, CentOS, iOS
Others Office365
Security Group Policies
Servers/Tools Active Directory Federation Services, DataGrip, Filezilla, IIS, JUnit, MS Word, Swagger, WebStorm, Postman, MS Excel, MS Outlook, Wireshark
Big Data/Machine Learning Azure Databricks

Interests

As a simple minimalist, I prefer to live with less and prioritize experiences over material possessions. I believe in the importance of living a simple and intentional life, free from excess and clutter. My focus is on the essentials, and I make a conscious effort to only own things that I truly need and that bring value to my life.

Being eco-friendly is also a key aspect of my lifestyle. I care deeply about the environment and take steps to reduce my carbon footprint. I strive to live sustainably, whether that means using reusable items, composting, reducing water and energy usage, or buying from ethical and eco-friendly companies.

Community is also important to me. I value strong relationships with those around me and enjoy being a part of a close-knit community. I believe in supporting and uplifting others, and often seek out opportunities to give back and make a positive impact in my community. I prioritize cooperation over competition and strive to create a sense of belonging for myself and those around me..