H3

Cloud Solution Implementation for Sales Forecasting

Client: Convenience Store Chain | Retail Sector

                                                               

Technologies Used:

  • Azure Data Factory: To orchestrate the data flow.
  • Azure Data Lake Storage: For storing transformed data.
  • Snowflake: Primary data source.
  • Parquet: Optimized storage format.

A leading convenience store company with a national presence, more than 20,000 branches, and a team of thousands of employees, offering a wide range of products and services to meet the daily needs of its customers.

Business Problem:

The client required expanding the functionality of a sales forecasting model (MVP 1) to include recipe items in 4 of the 12 interfaces sent to their planning system (Relex). The solution needed to automate the process in a cloud environment, enabling accurate sales forecasting calculations and ensuring efficient integration with existing data sources.

Provided Solution:

A solution based on Azure services was implemented to automate the data flow and expand the functionality of the sales forecasting model. This allowed for seamless integration of recipe items into the existing system, ensuring accurate and efficient sales forecasting.

Selected Solution:

 
  • Identification and Design of Extraction Strategies for Historical and Delta Data from Satellite Tables in Snowflake.
  • Creation of Pipelines in Azure Data Factory and Structures in Parquet Format to Optimize Storage and Processing.
  • Generation of 12 CSV Files from the Data Lake and Sending to the Relex System.
  • Conducting Unit Testing and Necessary Adjustments Before Production Deployment.
  • Complete Logging of Implemented Components and Processes.

 

Achievements and Benefits:

The main achievements and benefits obtained from this project were the following:

 

  • Optimization of the data flow for forecasting, ensuring real-time availability.
  • Successful integration of recipe items into the sales model, improving forecast accuracy.   
  • Reduction in data processing times.                                                                                                       

The solution was designed to be scalable and flexible, allowing for future expansions to accommodate new forecasting requirements or the integration of additional data sources.

Client Testimonial:

“Thanks to the implemented solution, we now have a more robust and accurate forecasting system, aligned with the needs of our daily operations.”

Go Live: January 2025

Technological Evolution: Migration to Drive Efficiency​

Client: GEPP
Legal Names:

  • Bebidas Purificadas S. de R.L. de C.V.
  • Servicios Administrativos SUMA S. de R.L. de C.V.

Technologies Used:

  • Oracle Database Enterprise Edition
  • Oracle SOA Suite
  • Oracle Data Integrator
  • WebLogic Suite
  • Oracle Cloud Infrastructure
  • Oracle Exadata Cloud Services
  • Oracle Integration Cloud

A leading company dedicated to the production of carbonated and non-carbonated beverages, as well as purified water, with a national presence and over 40,000 employees.

Business Problem:

GEPP (Grupo Embotellador PepsiCo) had multiple applications and different technological tools, including Oracle databases, the Oracle SOA Suite integration platform, and security components. The systems supported by this infrastructure were the main sales, distribution, logistics, and other applications. These environments operated on an IBM Power computing infrastructure with AIX operating systems, which required an update, demanding a significant investment in both hardware costs and migration services to transition from the current platform to a new one. Additionally, there was a need to upgrade various components, such as the existing database on version 11g, which was out of support. Therefore, it was necessary to upgrade to a more recent version that provided ongoing support and eliminated the high risks associated with being out of support.

Solution Alternatives:

Gepp had two options to address the issue of hardware platform obsolescence and having their main databases out of support. The first option was to make a significant investment in acquiring new IBM Power server equipment and performing a database upgrade to version 12c. The second option involved migrating all components to an Oracle Cloud environment and performing a database version upgrade.

Selected Solution:

Gepp decided to use the specialized services of H3 Consulting in Oracle Cloud technologies and services, which included:

1.- Definition of an architecture tailored to an Oracle Cloud environment, including the use of high-performance database services with Oracle Exadata Cloud Services.
2.- Execution of a highly efficient migration process that minimized downtime for the production environments.
3.- Database upgrade to version 19c during the same migration process.
4.- Execution of the re-platform process to move current environments from IBM Power/AIX to Intel x86/Linux platforms.

Achievements and Benefits:

The main achievements and benefits obtained in this project were as follows:

 1.- Execution of a highly efficient migration strategy that fully met the planned timelines, minimizing the blackout window of the production environments, ensuring that their operations were not interrupted beyond the normal offline times previously experienced by Gepp.

2.- Elimination of a significant investment in new IBM Power equipment.
3.- Database upgrade to a version that provides a long support lifecycle.
4.- Operation on a secure, high-performance, and elastic platform that adapts to the business’s processing demands.
5.- Transition from a capital expenditure (Capex) model to an operational expenditure (Opex) model, providing a more convenient financial management approach.
6.- Ease of incorporating new services and technologies, allowing for a much more agile response to Gepp’s business requirements.

Go Live: July  2024

Gracias por tu interés en Staffing H3.

Completa el siguiente formulario y accede a la página de descarga.





    Thank you for your interest in our Administered Services.

    Fill out the following form and access the download page.





      Thank you for your interest in our Administered Services.

      Fill out the following form and access the download page.





        Thank you for your interest in our Managed Services.

        Fill out the following form and access the download page.





          Gracias por tu interés en nuestros Servicios Administrados.

          Llena el siguiente formulario y accede a la página de descarga.





            Gracias por tu interés en nuestros Servicios Administrados.

            Llena el siguiente formulario y accede a la página de descarga.





              Gracias por tu interés en nuestros Servicios Administrados.

              Llena el siguiente formulario y accede a la página de descarga.





                Gracias por tu interés en nuestros Servicios Administrados.

                Llena el siguiente formulario y accede a la página de descarga.





                  Gracias por tu interés en nuestros Servicios Administrados.

                  Llena el siguiente formulario y accede a la página de descarga.





                    Gracias por tu interés en la Base de datos Oracle 23ai.

                    Llena el siguiente formulario y accede a la página de descarga.





                      Gracias por tu interés en la Base de datos Oracle 23ai.

                      Llena el siguiente formulario y accede a la página de descarga.





                        Thank you for your interest in H3 Solutions.

                        Fill out the following form and access the download page.





                          Thank you for your interest in Staffing H3.

                          Fill out the form below and access the download page.




                            Thank you for your interest in our Administered Services

                            Fill out the form below and access the download page.





                              Gracias por tu interés en Oracle Database 23ai.

                              Llena el siguiente formulario y accede a la página de descarga.





                                Gracias por tu interés en Oracle Database 23ai.

                                Llena el siguiente formulario y accede a la página de descarga.





                                  Gracias por tu interés en los Sistemas ERP H3.

                                  Llena el siguiente formulario y accede a la página de descarga.





                                    Gracias por tu interés en nuestros Servicios Administrados.

                                    Llena el siguiente formulario y accede a la página de descarga.





                                      Gracias por tu interés en nuestros Servicios Administrados

                                      Llena el siguiente formulario y accede a la página de descarga





                                        Gracias por tu interés en nuestros Servicios Administrados

                                        Llena el siguiente formulario y accede a la página de descarga.





                                          Gracias por tu interés en nuestros Servicios Administrados.
                                          Llena el siguiente formulario y accede a la página de descarga.





                                            Gracias por tu interés en las Soluciones H3.

                                            Llena el siguiente formulario y accede a la página de descarga.





                                              Gracias por tu interés en Staffing H3.
                                              Llena el siguiente formulario y accede a la página de descarga.





                                                Gracias por tu interés en H3.
                                                Llena el siguiente formulario y descarga la información.





                                                  Estamos a tu servicio

                                                  Compártenos tus datos