Anyeli Cárdenas Email & Phone Number

Bogotá, Capital District, Colombia

Bogotá, Capital District, Colombia

Corala was a company specializing in legal services, focused on connecting clients with independent legal professionals through a web platform.The primary purpose of the Corala project was to bridge the gap between independent professionals and potential clients in Colombia by creating a website that facilitates those connections. To achieve this, the tech stack included Python for backend development, Pandas for transforming and cleaning the data, PostgreSQL for securely storing professional data, and Airflow for managing our data workflows. Responsibilities:- Developed a data pipeline that extracted and transformed information from CSV files using Apache Airflow for daily updates.- Cleaned and transformed the data using the Pandas library to ensure accuracy and consistency in the database.- Created EDA on the professional data to assess trends and inform strategic decision-making.- Conducted SQL queries to generate report information that drives business improvements and growth.- Generated a set of SQL views that provided key metrics and analytics on professional data for enhanced decision-making support.