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 within Growth, Marketing and Sales, I’ve made a significant impact across various commercial sectors, including tech, consumer goods, and retail. Working closely with clients to deliver production-level assets based on advanced analytics algorithms, deep learning, and GenAI RAG systems for scalable E2E solutions.


 Interests

I’ve a lifelong interest in combining gaming growth and AI solutions for digital platforms, with a particular focus on free-to-play mobile gaming and the metaverse.

This journey began with a self-taught venture into Unity as a Game Developer when I was young, which sparked my deep interest and laid the foundation for my technical skills in this sector.


 Experience

McKinsey & Company

Analyst, Growth AI - CustomerOne | Aug 2024 - Present

As a Data Scientist focused on Customer Sales Growth, I harness data, NLP (Entity Resolution), and AI to elevate AI-driven CRM systems and drive B2B sales growth. My role is all about deploying McKinsey’s CustomerOne assets to enhance existing customer relationships, and identify new opportunities.

Data Scientist, Generative AI Core Tech - Lilli GenAI | Feb 2024 - Jul 2024

As Data Scientist and Software Engineer at Lilli, McKinsey’s Generative AI live service, I led the creation of the core NER system powered by LLMs, spaCy (Curated Transformer without Lemmatizer) and GLiNER, to enhance query parameters of a Knowledge Graph and other consumers. This drove significant advances in entities parsing from documents and response accuracy, making a distinctive impact on our GenAI Client Capabilities.

  • Reduced false-negative detection rates by 70% with a custom LLM-powered NER package implemented within the Lilli’s RAG workflow using FastAPI.
  • Enhanced response speed by 71% through GLiNER implementation, improving LLM-based NER processing.
  • Boosted NER adoption across 5+ workstreams with a few-shot prompt engineering module as a Python Package.

Data Scientist, CommercialX - QuantumBlack AI | Sep 2023 - Jan 2024

As a Data Scientist at CommercialX, QuantumBlack’s retail (B2C) vertical analytics engine, I focused on assetizing high-impact solutions in pricing and assortment optimization use cases, and supporting client deployments under a BOT model.

  • 5.2% gross margin uplift achieved for mid-demand products by integrating a Python optimization algorithm for gross margin maximization, leveraging XGBoost pricing model outputs, within a 6 pp CPI variation scenarios.
  • 4+ hours of runtime reduction achieved by engineering a high-performance distributed computing module using PySpark, optimizing data migration between Databricks DBFS and Azure Blob Storage while exporting Gensim-based neural network outputs for product complementarity.

Data Analyst, Growth Marketing & Sales - Periscope | April 2023 - Aug 2023

As a Data Engineer on Periscope’s suite for growth within pricing and promo solutions, I contributed on the migration of inbound data workflows for a Fortune 500 North American department store, becoming instrumental in optimizing data processes and infrastructure under a SaaS model.

  • 25TB customer database migrated by transitioning from ExasolDB to SparkSQL, optimizing critical inbound pipelines.
  • Enhanced dataflow efficiency by securing a robust infrastructure within Periscope, orchestrated with Jenkins, and integrated with secure SFTP protocols.

Junior Data Analyst, Growth Marketing & Sales - Periscope | March 2022 - Mar 2023

As an Analytics Developer at Periscope, I collaborated with Experts to make a NLP algorithm for product size and price recommendation management, delivering a tailored rule-based solutions for retail pricing use cases.

  • 40% speed improvement achieved by optimizing the search and build of product-pricing relationships using a Python TreeNode algorithm, detecting over 5 relationship types in the client’s product shelf assortment.
  • 0.5% profit uplift realized by implementing an AA module that optimized the pricing process, recommending package size relationships within product families based on Cosine similarity clusters.

Learn more about the responsibilities of this role at LinkedIn.

Belcorp

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

As a Business Analyst at Belcorp, a leading multinational in Beauty and Personal Care packaged cosmetics, I supported data-driven solutions that empowered LatAM business teams and managers.

  • Enabled informed decision-making with data analysis Excel tools for LatAM teams, driving actionable commercial insights within a B2C framework.
  • Enhanced service intelligence by integrating BI assets into CRM tasks and designing tailored data collection models for efficient regional visualization using Tableau.
  • Improved data accessibility by creating user-friendly Tableau dashboards that addressed BI inquiries from Central American personnel, presenting information clearly and effectively.

Learn more about the responsibilities of this role at LinkedIn.

VMware

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

As a Data Analyst at VMware (Broadcom Inc.), I supported data analysis initiatives throughout the SaaS cycle, providing actionable insights.

  • Uncovered key trends and patterns by making data analyses throughout the SaaS cycle, utilizing Tableau for effective data visualization and presentation.
  • Ensured compliance by applying diverse statistical techniques for accurate customer data analysis, conducting CTA predictive analysis in R to uphold PEME agreements.
  • Validated Customer 360° integrity by managing data extraction, loading, and reconciliation in Amazon Redshift, directly contributing to the success of major projects.

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