About

https://www.gravatar.com/avatar/6f857b907c2edf7d71d705e6de716006?s=240&d=mp

Roberto Aguilar

Analyst @ McKinsey & Company, AI & Gaming

 Company:McKinsey & Company


 Occupation:AI & Data Science


 Location:San Jose, CR


Core Interests

AI & Gaming

95%

Metaverse

95%

F2P Monetization

95%

Hi there! I’m Roberto, and I’m glad you stopped by my portfolio website today

In this section, you’ll find details about my career, experience, and personal life. If you have any questions or comments, please feel free to contact me at the bottom of this page

 Important: Any views, material or statements expressed are mines and not those of my employer


 About me

As a Data Scientist and Engineer, I specialize in transforming complex data into tangible business outcomes, particularly for the retail and consumer packaged goods sectors.

My expertise lies in deploying advanced analytics algorithms, deep learning solutions, and machine learning approaches.


 Interests

The passion for exploring the convergence of graphics technology platforms and analytics solutions, particularly in areas such as gaming and the metaverse, has been a driving force in my career, as in the coming years this unique intersection will offer numerous innovative solutions that can contribute effectively to a tangible impact.

My journey in this field was initiated some years ago with a self-taught venture into Unity programming, which not only laid the foundation for my technical background but also sparked this deep interest.


 Experience

McKinsey & Company

Analyst, Software Delivery, Lilli GenAI, Feb 2024 - Present

Proven impact as Fullstack Data Scientist:

  • Contributed in the redesign of an advanced Named Entity Recognition System for McKinsey’s core GenAI product, significantly enhancing the precision of financial information searches using a LLM model (Internal Asset).

  • Enhanced various semantic techniques, leading to the development of a prompt engineering strategy that significantly boosted named entity detection coverage by over 45% (Internal Asset).

Data Scientist, QuantumBlack, Sep 2023 - Jan 2024

Proven impact as Data Scientist (seasonal staff):

  • Assetized Competitor Price Index scenario generator capable of increasing 5.2% Gross Margin uplift of middle demand class products within a 6pp CPI variation, in addition to the Python-based pricing recommendation engine (Electronics Retailer).

  • Integrated a QuantumBlack deep learning‑based demand transfer engine into Periscope’s Assortment Advisor platform by creating a highly efficient assembly module using PySpark, which resulted in a $3M signed‑up proof‑of‑concept (Food Retailer).

  • Enhanced a regressor model reproducibility and performance consistency by integrating a model registry with MLFlow and Databricks.

Data Analyst, Periscope, April 2023 - Aug 2023

Proven impact as Data Engineer:

  • Contributed in the migration of a +25TB customer database by seamlessly migrating it from ExasolDB to SparkSQL transcoding, optimizing critical inbound pipelines (Department Store & Luxury Goods).

  • Implemented a robust infrastructure within Periscope, orchestrated seamlessly with Jenkins, and enhanced data flow efficiency by integrating with secure SFTP protocols (Department Store & Luxury Goods).

Junior Data Analyst, Periscope, March 2022 - Mar 2023

Proven impact as Data Scientist:

  • Achieved a 0.5% profit uplift by implementing an AA module that optimized the pricing process by recommending package size relationships within product families of items formed by clusters based on NLP similarity scores (Food Retailer).

Learn more about the responsibilities of this role at LinkedIn.

Belcorp

Junior Business Intelligence Analyst, Belcorp, February 2021 - Jul 2021

Proven impact as Business Analyst:

  • Developed data analysis tools enabling LatAM teams and managers to derive actionable commercial insights, facilitating informed decision-making into a B2C functionality.

  • Integrated BI assets into CRM tasks, enhancing intelligence for service personnel. Designed tailored data collection models for efficient regional visualization.

  • Addressed BI inquiries from Central American personnel by creating user-friendly Tableau dashboards, presenting information clearly and comprehensibly.


Learn more about the responsibilities of this role at LinkedIn.

VMware

Enterprise Data & Analytics Intern, VMware, June 2020 - Sep 2020

Proven impact as Data Analyst:

  • Led comprehensive data analyses throughout the SaaS cycle, uncovering trends and patterns. Utilized data visualization techniques and charts to present findings effectively using Tableau.

  • Applied diverse statistical techniques for accurate customer data analysis, ensuring compliance with PEME agreements through CTA predictive analysis in R.

  • Expertly managed data extraction, loading, and reconciliation in Amazon Redshift, validating Customer 360° integrity and contributing to project success.


Learn more about the responsibilities of this role at LinkedIn.


 Honors & awards

Finalist at VMware BORATHON 2020, Palo Alto, California

Reached the final stage, ranking among the eight finalists for the annual VMware Hackathon. Recognized for developing a mockup of an internal social network to complement the Workspace ONE product. Supporting the proposed solution through a real-time dashboard that uses actual HR data to represent the prospect’s impact on the business. The activity was carried out virtually due to the sanitary restrictions of COVID-19.

Learn more about this program at VMware’s CTO Blog.

August 2020


 Licenses & certifications

Databricks Certified Associate Developer for Apache Spark 3.0

Databricks and Apache Software Foundation validated credential, which demonstrates an understanding of the Apache Spark architecture and the ability to apply the Spark DataFrame API to complete individual data manipulation tasks using parallelization coding with Pyspark.

Validate this credential here.

November 2022

Dassault Systèmes, Certified of Mechanical Design at Level of Associate (CSWA)

Credential that validates mechanical design ability through the application of SOLIDWORKS software, highlighting proficiency in leveraging core 3D modeling capabilities, including extrusion and revolution techniques.

Validate this credential ID: C-YKES524TBJ, here.

October 2019


 Education

Bachelor of Science in Engineering (B.S.E) - Industrial Engineering at TEC

Bachelor’s degree accredited by the Canadian Engineering Accreditation Board (CEAB) in the area of Industrial Engineering. Covering areas such as industrial statistics (Minitab), process simulation, computer aided design (CAD, Solid Works), computer aided manufacturing (CAM), industrial process control and programming (CNC), IT project management fundamentals (SCRUM), continuous improvement processes (Lean Six Sigma).

Learn more about this academic degree here.

Postgraduate Degree - Data Analytics at Cenfotec

Data Analytics Graduate Program, emphasizing data engineering and analytics, offers advanced statistical analysis through programming languages for Big Data processing. The program includes good Data Engineering practices using the Apache Software Foundation frameworks and adopts application concepts for end-to-end analytical solutions.

Learn more about this academic degree here.


 Voluteering

NVIDIA AI Workbench Beta tester

Contributed to the beta testing of NVIDIA AI Workbench, identifying software issues and providing feedback to improve usability and performance.

Product on testing: Unified, easy-to-use toolkit that allows developers to quickly create, test and customize pretrained generative AI models and LLMs on a PC or workstation, which can scale them to virtually any data center, public cloud or NVIDIA DGX Cloud. Using a simplified user interface enables collaboration across AI project teams and streamlined access to popular repositories like Hugging Face, GitHub and NVIDIA NGC.

Learn more about the product here.


 Personal life & Hobbies

I’m a person who loves to read about issues related to the gaming industry, especially in companies such as Activision Blizzard, Ubisoft, Bethesda, Xbox Studios, Supercell, among others; also in matters of marketing and applicability of Data Analysis in development, design, research and postproduction – That’s why two of my main appeals are Applied Data Science and Game Development.

Among other personal hobbies, I like playing video games and practicing outdoor sports like trail running. And a fun fact — I live with a golden Holland Lop named Jacka.


 Contact section