Nicolás Ramírez García

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.

Responsibilities:
- Planning, documenting, and developing models and data dashboards related to the health sector in Qlik.
- Migration of data models from Qlik View to Qlik Sense.
- Analysis of data model development requirements.

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.

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.

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.

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

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