Sara estefania C.

Sara estefania C.

Cloud Data and BI Engineer

Bogotá , Colombia

Experience: 3 Years

Sara estefania

Bogotá , Colombia

Cloud Data and BI Engineer

30426.2 USD / Year

  • Start Date / Notice Period end date: 2022-04-29

3 Years

Now you can Instantly Chat with Sara estefania!

About Me

I am a Systems and Telecommunications Engineer focused on data analytics and business intelligence, using cloud tools from Microsoft Azure and Google Cloud Platform. I can develop ETLs, data warehouses, cubes (in Analysis Services) and reports (...

Show More

Portfolio Projects

Analytics and Information Management for Pensions - Ministry of Labor Colombia

Company

Analytics and Information Management for Pensions - Ministry of Labor Colombia

Role

Data Scientist

Description

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.

Show More Show Less

Development of Open Data for the Attorney General's Office of Colombia

Company

Development of Open Data for the Attorney General's Office of Colombia

Role

Data Scientist

Description

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).

Show More Show Less

BI project in Google Cloud Platform for SURA-IM

Company

BI project in Google Cloud Platform for SURA-IM

Role

Data Scientist

Description

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.

Show More Show Less