Nicolás Alberto Ramírez García Email & Phone Number

Madrid, Es

Responsibilities:- Creation and implementation of ETL processes using various tools and data sources (MySQL, BigQuery, Python, among others).- Automation of processes to support the management of operations and client-facing deliveries.- Task and ticket management to support the development of innovative solutions that optimize the effective use of data.Achievements:- Developed and implemented a logistics planning model that utilized GCP and MySQL as data sources, enabling the optimal allocation of points according to routes generated by the team. This improved the quality of data collection and ensured the necessary information was gathered.- Automated processes through Cloud Functions, providing real-time visibility of data useful for operations and the Client Service team. This allowed stakeholders to easily access reliable and up-to-date information.- Created processes that consolidated stored procedures, Python codes, and Pentaho JOBS, including controls and optimizing code to limit resource consumption to what was necessary.

Bogotá, Distrito Capital, Colombia

Responsibilities:- Perform ETL processes using Power Query and Python resulting in the creation of automated data models for CISCO operations.- Develop weekly, monthly and quarterly reports through Power BI.- Execute queries in SQL language on databases stored in PostgreSQL.Accomplishments:- I decreased ≈ 80% the time to generate internal and external reports.- I managed to automate 5 data processes related to the development of the operation and business interests through code generated in Python.- Implemented a Machine Learning project developing classification and regression models for decision making within operations.

Bogotá, Distrito Capital, Colombia

Responsibilities:- Analyze processes related to projects executed by the university from the technology and innovation office.- Extract data using SQL and generate valuable information for decision-making through interactive dashboards.- Conduct process documentation supported by the BPMN methodology.Achievements:- Created a template for periodic reports in Power BI, allowing easier access to information and reducing the time to extract insights by approximately 35%.- Automated SQL queries considering business rules, reducing data load times in the model, with refresh times decreasing from 1 hour to 20 minutes.

Colombia

Responsibilities:- Execute SQL queries for the generation of dashboards in powerBI, supporting different departments of the organization, with main focus on the marketing department.- Participate in the design of interactive and practical dashboards for decision making.Achievements:- I participated in a Machine learning project related to recommendation systems that allowed the company to identify potential products for customer groups.

Bogotá, Distrito Capital, Colombia

Customer Experience Representative for Turo's Verification Team: Worked at a tech company specializing in car rentals across the US, UK, Italy, and Canada.

Colombia

Responsible for planning, executing, and controlling social projects aimed at improving the quality of life within Colombian communities.

Master'S Degree, Big Data Science

Emphasis, Business Intelligence Analytics

Grado En Ingeniería, Industrial Engineering

Grado En Ingeniería, Civil Engineering