Rogelio Antonio Melo Juárez Email & Phone Number

Mexico City, Cdmx, Mx

Ciudad De México, México

• Transforming PepsiCo Mexico Foods into a data driven company by designing the data strategy, delivering data products creating the necessary ecosystem between technical and business teams, establishing the right ways of working as well as ensuring data quality, governance and change management strategies.• B2C analytics: Joy App (+600K active users)Designing and implementing proofs of value through advanced analytics which help us understand our consumer behavior and obtain valuable insights for our business functions.• Integrated Business Plan: Leading the data strategy track of our IBP (Demand Planning) program for PepsiCo Mexico Foods, which involves aligning business team’s objectives with the Enterprise Data Foundation development team, to validate and ensure data quality, governance and functional requirements are met before the forecasting model is deployed.• B2B analytics:Lead the data analytics phase which involves understanding the behavior of our customers inthe application by developing valuable KPI’s and applying advanced analytics strategies.Planning the scalability of our processes through our centralized Data Lake infrastructure.Experiment design (AB Testing)Ensuring data foundations are set to make data driven decisions.

Ciudad De México, México

• Led a team of 20+ people between PepsiCo employees and contractors focused on developing D&A initiatives, starting from the business engagement, translation of requirements to technical teams, data fabric development and sustain. (Scope divided between Data Engineering, Advanced Analytics and Business Intelligence)-Business engagement and requirement understanding-Financial planning-InfoSec analysis to ensure safety and security of our data.-Cloud Infrastructure provisioning-Assembling a team to develop the solution which typically consists of a scrum master, data engineers, data scientists and PowerBI developers.-Deployment and sustain• Joy App Analytics (B2C)Led the construction of the application's Data LakeDeployed a data science team to achieve:• Customer segmentation• Fraud detection• Profiling• Insights dasboards in PowerBI• Organized Trade Colombia Analytics SuiteLed the revamp of a recommendation engine and analytics suite for the OT Channel in Colombia which involved understanding the KAM’s necessities to transform them in a Data Product.• Business Intelligence Center of ExcellenceCreated a Center of Excellence in Business Intelligence which provides LATAM with strategy and resources to accomplish BI objectives. We provide a whole development ecosystem which includes design thinking workshops, project managers, PowerBI developers and business analysts.• Revenue Management 2.0Led the construction of the advanced analytics ecosystem in the cloud (Azure), led the data engineering and analytics team, vendor management and ensuring that the application has the right support for business users.

Ciudad De México Y Alrededores, México

Led the Data Strategy section of the implementation of Bimbo’s B2B, T-Conecta reporting directly toBimbo Mexico C-Level.Led a multidisciplinary team of data scientists, data engineers, software developers and businessanalysts, to design and implement several data products and web platforms for Grupo Bimbo, rangingfrom S&OP optimization, sales forecasting and boosting via recommendation systems, traditionalchannel digitalization and geographic intelligence.Led the implementation of a business planning platform for Barcel, which focused on forecastingdemand for a 3-6 month horizon based on a Perfect Order forecasting model at a PoS level butreaching several planning areas such as supply chain, finance, marketing, etc.Developed in depth analysis of sales forecast results nationwideDevelopment of Machine Learning Models, evaluating performance, proposing proofs ofvalue to potentiate engagement, etc.Efficiently working with overseas teams in Brazil, Perú, India and US to deploy data scienceproducts.Led a project which boosted sales in Bimbo Perú more than 3% vs a control group byimplementing a geographic intelligence platform combined with the deployment of arecommendation engine during the COVID-19 lockdown in 2020.Lead a project to predict user’s churn for one of the digital services apps part of GrupoBimbo, actual results show accuracy levels between 80-90%.Direct experience in supply chain operations, starting from distribution centers until the point of sale.o Led the nationwide implementation Perfect Orfer platform for Barcel México (Machine learningmodels consumed through a web platform for sales representatives)Designed and implemented a Geographic Intelligence Application for market supervision, customeracquisition and segmentation.

Ciudad De México Y Alrededores, México

Ciudad De México Y Alrededores, México

Ciudad De México

Data collection, analysis and economic research discussion with professor Alexandros Fakos Ph.D.

Diplomatura, Dirección Y Desarrollo De Negocios

One year program consisting in preparing professionals in all the strategic areas of an enterprise: -Business Processes -Marketing -Human.

Industrial Organization Course, Industrial Organization, A

Industrial Organization course covering topics on microeconomics, competition, pricing and monopoly theory. Concluded in the top 10%.

Bachelor'S Degree, Economics

Activities and Societies: University ChoirB.Sc. of Economics with specialization in finance. Graduated with Honors with the thesis: ".