Marcela Hoyos Cano Email & Phone Number

• Developed BigQuery SQL large storage procedures for calculating the gross margin of the company’s various products, providing accurate financial insights that supported strategic decision‑making and improved profitability analysis.• Designed and built multiple dashboards in Looker Studio for tracking company metrics, integrating real‑time data visualization to enable stake‑holders to monitor performance effectively and make informed business decisions. The dashboards implemented alert… Show more • Developed BigQuery SQL large storage procedures for calculating the gross margin of the company’s various products, providing accurate financial insights that supported strategic decision‑making and improved profitability analysis.• Designed and built multiple dashboards in Looker Studio for tracking company metrics, integrating real‑time data visualization to enable stake‑holders to monitor performance effectively and make informed business decisions. The dashboards implemented alert systems to monitor changes in product gross margins, ensuring timely responses to fluctuations and enhancing overall financial management and interventions.• Developed LSTM‑based neural network forecasting models for accurate mobile plans consumption and profit predictions for global company operations. Show less

Medellín, Antioquia, Colombia

• Developed algorithms to combine multiple data sources from energy and production databases of different plastic manufacturing companies. This data was then consumed by ML models and other statistics methods to generate KPIs for the stakeholders.• Collaborated with team members to troubleshoot research challenges, maintain organized documentation, and contribute to the preparation of research reports, papers, and presentations, ensuring accuracy and clarity in all outputs.

• Developed a convolutional neural network to overcome CAPTCHA challenges that impeded web scraping efforts during ETL data ingestion, accelerating data retrieval process.• Created various Looker dashboards to visualize Service Level Agreements (SLAs) and monitor key performance indicators (KPIs). These dashboards provided clear, real‑time insights into operational performance, facilitating better understanding and tracking of critical metrics as well as enabling stakeholders to make better… Show more • Developed a convolutional neural network to overcome CAPTCHA challenges that impeded web scraping efforts during ETL data ingestion, accelerating data retrieval process.• Created various Looker dashboards to visualize Service Level Agreements (SLAs) and monitor key performance indicators (KPIs). These dashboards provided clear, real‑time insights into operational performance, facilitating better understanding and tracking of critical metrics as well as enabling stakeholders to make better data‑driven decisions.• Provided maintenance and support for Casetracking, a Ruby on Rails web‑based application used by legal professionals and entities in LATAM to manage documents and artifacts related to various legal matters. Ensured smooth operation, addressed technical issues, and implemented improvements to enhance the application’s reliability and user experience.• Developed multiple web scraping scripts using Ruby on Rails to extract relevant information for Casetracking’s ETL input, with a focus on delivering clean and compliant data through the use of Regular Expressions and Ruby‑based web scraping libraries like Nokogiri.• Conducted regular software releases and performed routine maintenance audits to ensure the system remained up‑to‑date and secure in compliance with company standards.• Collaborated with the development team to streamline future enhancements to Casetracking’s functionality and UX, integrating end‑user feedback and meeting management requirements. Show less

Medellín, Antioquia, Colombia

• Designed interactive dashboards in Power BI for Almacenes Éxito, Colombia’s largest retail company, delivering comprehensive insights and visualizations to enhance inventory management and performance tracking. These dashboards empowered decision‑makers with real‑time data, leading to more efficient operations and improved business outcomes.• Contributed to backend development for EAE, Unisys’ proprietary COBOL‑based product, leveraging programming and software engineering skills to… Show more • Designed interactive dashboards in Power BI for Almacenes Éxito, Colombia’s largest retail company, delivering comprehensive insights and visualizations to enhance inventory management and performance tracking. These dashboards empowered decision‑makers with real‑time data, leading to more efficient operations and improved business outcomes.• Contributed to backend development for EAE, Unisys’ proprietary COBOL‑based product, leveraging programming and software engineering skills to enhance functionality and performance. Played a key role in optimizing system efficiency, ensuring robust and reliable operations while maintaining security best practices for legacy applications.• Optimized and customized bar‑code printing templates using ZPL (Zebra Programming Language) to improve the printing process. These enhancements led to superior print quality, increased efficiency, and a significant reduction in errors during labeling of products price tags. Show less

Envigado, Antioquia, Colombia

• Provided field support for the installation of IoT (Internet of Things) equipment used for energy data telemetry, ensuring proper installation, configuration, and functionality for a diverse group of clients from the Colombian and Caribbean region.• Enhanced an existing user interface in Python by improving its functionality and user experience, resulting in a more efficient control and management of IoT devices installed by the company technicians on client’s physical infrastructure.

Master'S Degree, Ciencia De Datos Y Analítica

Ingenieria, Ingeniería Mecatrónica

Bachillerato, Bachiller Académico