Traditional analytics and advanced analytics project that generated 8 models to analyze information related to pensions in the ministry of Labor in Colombia. The development carried out for this project includes:

- Documentation.
- Information architecture.
- Creation of ETLs in Azure Data Factory.
- Management of SQL Server databases.
- Creation of data warehouse in SQL Server.
- Creation of cubes in Analysis Services.
- Creation of reports in Power BI.

For this project, the Open Data methodology proposed by the ICT Ministry was implemented, in which the following activities were carried out:

- Identify the information available.
- Analyze the information to determine if it is publishable or not.
- Prioritize the information to define what is published in the short, medium or long term.
- Document the information, thus defining its metadata and
- Structure the data to present it in open formats.
- Publish the data so that it is accessible to citizens (process carried out through SQLdata warehouse, ETLs in Azure Data Factory, Web Apps to create APIs, Azure Functions to automate this process and Logic Apps to integrate these components).
- Communicate the publication made and promote the use of data.
- Monitor the quality and use of open data (a dashboard was implemented in Power BI connected to Azure Functions).

The client wanted to know the income from all the different countries in which they had activities. I worked building Data Warehouses in Google Cloud Platform with Big Query and I used Cloud Dataflow to design the needed ETLs. I stared this project by testing someone else's code, but after that, I had to build my own data pipelines.