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 delivery to the Relex system.
  • Unit testing and necessary adjustments before the move to production.
  • Complete record of the 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

Person working on a laptop with a digital cloud graphic

Implementation of Transactional Replication for Real-Time Data Synchronization

Client: Food and beverage company | Retail Sector 

Technologies Used:

  • Microsoft SQL Server 
  • Transactional Replication (distribution, publications and subscriptions).      
  • SQL Server Agents

A leading company in the food and beverage sector needed to optimize the synchronization of multiple critical databases supporting operations such as e-commerce, mobile monitoring and inventory management. Before the solution was implemented, the client experienced frequent synchronization delays and difficulties keeping data consistent between source and target servers, which affected system availability and reliability.

Business Problem:

The client required a robust and efficient transactional replication system to synchronize several operational databases in real time. The lack of timely synchronization caused inconsistencies that affected key business areas, especially those that rely on live data to operate.

Provided Solution:                                                                                                                                         

A transactional replication architecture was implemented in Microsoft SQL Server to ensure continuous and reliable synchronization of the critical databases.

The main activities included:

 
  • Configuration of a distribution database on the main server to manage the flow of replicated data.
  • Creation of publications to replicate key databases such as e-commerce, inventory and operational monitoring systems.
  • Configuration of subscriptions on secondary servers, ensuring automatic synchronization of information.
  • Implementation of initial snapshots and job scheduling to keep data up to date in real time or at defined intervals.
  • Configuration of secure credentials and optimization of SQL Server agents to ensure optimal performance of the replication process.

Achievements and Benefits:  

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

 

  • Efficient and continuous synchronization of 7 critical databases.
  • Significant improvement in data availability for mobile operations and e-commerce.
  • Greater reliability by ensuring consistency between source and target servers.
  • Reduced downtime during replication and maintenance processes.                                                                                                     

Client Testimonial:

“Thanks to the implementation of transactional replication, our critical operations are now faster and more reliable, allowing us to better respond to our customers’ needs.”

 Go Live: March 2024

 

Technological Evolution: Migration to Drive Efficiency​

Client: Beverage bottler | Consumer Sector

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:

The company 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:

The company 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:

The company 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 the company.

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 the company’s business requirements.

Go Live: July 2023

Servers in a data center rack

Oracle EBS Infrastructure Modernization: More Performance and Scalability for the Retail Sector

Client: Retail chain with presence in Monterrey

Technologies Used:

  • Oracle E-Business Suite Release 12.1.1
  • Red Hat Enterprise Linux 6
  • Oracle JDK 1.7.0_80
  • AutoConfig & Rapid Clone
  • InfoZip                                                                                                                                                                                                                                                                                                                        

A leading retail company with a high volume of daily transactions and multiple administrative, financial and logistics processes that depend on Oracle E-Business Suite to maintain operational continuity across all its business areas.

Business Problem:

The client’s technology platform was outdated, limiting the performance and stability of the EBS system. In addition, the existing infrastructure made patching difficult, reduced the ability to scale and posed technical support risks. The client needed a complete migration to modernize its technology environment, ensure operational continuity and prepare the platform for future upgrades.
 
 

Provided Solution:                                                                                                                         

A comprehensive migration of the Oracle E-Business Suite ecosystem was carried out, upgrading the technology stack and optimizing the configuration at both the application and database levels. 

The implemented solution included:

 
  • Thorough verification of versions, dependencies and compatibility between environments.
  • Application of critical patches for AutoConfig, Rapid Clone and essential system components.
  • Architecture adjustments to optimize response times and internal processes.
  • Implementation of an automated process for cloning and migrating environments.
  • Complete documentation of the process and implementation of Oracle best practices.
  • Unit and validation testing to ensure a successful Go-Live.

Achievements and Benefits:  

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

 

  • Increased overall stability and performance of the EBS system.
  • 25% reduction in processing times for key transactions.
  • Easier application of future patches, upgrades and configurations.
  • Reduced operational risks stemming from the previous infrastructure.
  • A scalable, secure platform ready to support growing workloads.
  • Total migration time: 11 months.
  • More than 10 patches and support technology improvements implemented per environment.
 
 

Client Testimonial:

“Thanks to the migration, we now have a more stable, modern Oracle environment that is ready for our operational challenges. The transition was carried out with no impact on our daily operations.”

Go Live: January 2024

Implementation and Optimization of PeopleSoft Infrastructure for Critical Business Operations

Client: Company in the Healthcare, Retail and Food sectors

Technologies Used:

  • PeopleSoft HCM 9.1 and 9.2
  • Oracle WebLogic 10.3.6
  • Oracle Tuxedo 10gR3 and 11g
  • Microsoft SQL Server and Oracle Database 11g
  • PeopleSoft Internet Architecture (PIA)
  • Oracle Data Guard
  • Oracle Cloud Infrastructure (OCI)
  • Exadata
  • Windows Server and Red Hat Linux operating systems                                                                                                                                                                                                                                                                                                                         

An organization in the healthcare, retail and food sectors needed to strengthen its technology infrastructure to support critical workforce management applications and daily operations. The company required stable, scalable and secure environments to ensure business continuity, improve system performance and enable additional environments for testing and development.

Business Problem:

The company faced several challenges within its PeopleSoft architecture, including:
 
  •  The need to start up production environments while ensuring stable, optimal operation.
  •  The requirement to clone complete environments for testing, development and functional validation.
  •  Full installation and configuration of web, application and database servers.
  •  Advanced tuning to optimize the Application Server, Process Scheduler and Web Server.
  •  Implementation of a complete disaster recovery plan to ensure operational continuity.
 

Provided Solution:                                                                                                                         

A series of specialized solutions was implemented to ensure efficient operation and continuous availability of the PeopleSoft system.

Selected Solution:

 
  • Start-up and configuration of production environments, validating databases, servers and critical system components.
  • Environment cloning using specialized methods such as RMAN, Data Pump and Oracle Enterprise Manager, ensuring exact, functional copies.
  • Complete installation of PeopleSoft, WebLogic, Tuxedo, PIA and databases in Linux and Windows environments.
  • Configuration and tuning of the Application Server and Process Scheduler to improve performance.
  • Implementation of an operational continuity solution using Oracle Data Guard and an OCI architecture, including switchover and failover testing.

Achievements and Benefits:  

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

 

  • Significant reduction in PeopleSoft environment implementation and deployment times.
  • Greater operational stability thanks to the correct configuration of servers and key processes.
  • Standardized environment creation, making testing and development processes easier.
  • Strengthened disaster recovery capabilities, ensuring continuous availability.
  • Infrastructure ready to support future expansions and PeopleSoft system requirements.
The solution was designed to be scalable and flexible, allowing for future upgrades, new functionality or integration with other enterprise systems.
 
 

Client Testimonial:

“Thanks to the implemented solution, we now have a more robust, stable PeopleSoft environment that is ready to support our critical daily operations.”

Go Live: Various dates between 2011 and 2024

Technology Migration of Oracle E-Business Suite to Optimize Performance and Scalability

Client: Retail chain with presence in Monterrey | Retail Sector 

Technologies Used:

  • Oracle E-Business Suite Release 12.1.1 
  • Red Hat Enterprise Linux 6    
  • Oracle JDK 1.7.0_80      
  • AutoConfig & Rapid Clone      
  • InfoZip              

A leading retail company with a high volume of daily transactions and multiple administrative, financial and logistics processes that depend on Oracle E-Business Suite to maintain operational continuity across all its business areas.

Business Problem:

The client’s technology platform was outdated, limiting the performance and stability of the EBS system. In addition, the existing infrastructure made patching difficult, reduced the ability to scale and posed technical support risks. The client needed a complete migration to modernize its technology environment, ensure operational continuity and prepare the platform for future upgrades.

Provided Solution:                             

A comprehensive migration of the Oracle E-Business Suite ecosystem was carried out, upgrading the technology stack and optimizing the configuration at both the application and database levels.

The implemented solution included:

 
  • Thorough verification of versions, dependencies and compatibility between environments.
  • Application of critical patches for AutoConfig, Rapid Clone and essential system components.
  • Architecture adjustments to optimize response times and internal processes.
  • Implementation of an automated process for cloning and migrating environments.
  • Complete documentation of the process and implementation of Oracle best practices.
  • Unit and validation testing to ensure a successful Go-Live.

Achievements and Benefits:  

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

 

  • Increased overall stability and performance of the EBS system.
  • 25% reduction in processing times for key transactions.
  • Easier application of future patches, upgrades and configurations.
  • Reduced operational risks stemming from the previous infrastructure.
  • A scalable, secure platform ready to support growing workloads.
The solution was designed to be flexible and aligned with Oracle’s recommended best practices, ensuring operational continuity and the capacity to evolve.
 
 

Client Testimonial:

“Thanks to the migration, we now have a more stable, modern Oracle environment that is ready for our operational challenges. The transition was carried out with no impact on our daily operations.”

Go Live: January 2024

Managed Core Support Service

Client: Nationwide retail chain | Retail Sector 

Technologies Used:

  • Oracle Retail Merchandising System (v10 and v16)
  • Oracle E-Business Suite                                                                                                                                                           
  • XPOS (Point of Sale)      
  • Software AG WebMethods     
  • In-house web developments        
  • Oracle Database 11          
  • Oracle GoldenGate      
  • AIX operating system                                                                                                                                                                                                                                                                                                                         

A leading retail company faced a critical challenge arising from the migration of its core merchandising system (Oracle Retail Merchandising System) from version 10 to version 16. The process involved operating in hybrid mode during a progressive rollout by groups of locations, which required simultaneous support for both versions without affecting operational continuity, inventory flow or data integrity.

Business Problem:

The organization needed to guarantee operational stability in a complex environment where two versions of the core system coexisted, significantly increasing the demand for support. It was also necessary to ensure that the location-by-location rollout ran without interruptions and with enough capacity to absorb a growing volume of tickets as the project progressed.

Provided Solution:                                                                                                                         

A managed core support service was implemented, designed to comprehensively cover critical platforms at both the application and infrastructure levels.

The main actions included:

 
  • Specialized support for Oracle Retail Merchandising System versions 10 and 16 throughout the hybrid operation period.
  • Operational support for Oracle E-Business Suite, XPOS, WebMethods and in-house developments.
  • Administration of Oracle 11 databases and replication with Oracle GoldenGate.
  • Detailed review of transaction volumes to define the initial capacity of the support team.
  • Execution of a progressive deployment plan aligned with the core project roadmap.
  • Review and adjustment of capacity in early 2024, in response to the exponential increase in tickets.
  • Restructuring of the team into a model based on operational cells, aligned with the client’s organizational chart: Commercial: pricing, promotions and clearances. Master Data: item setup and store replenishment. Distribution Centers: validation of orders and purchase orders. Inventory and Finance: inventory discrepancies and incomplete transactions.

Achievements and Benefits:  

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

 

  • Initial sizing based on the client’s actual demand.
  • Periodic capacity reviews to avoid overloads during ticket peaks.
  • Flexible teams that adapt to changes in the operational structure.
  • Simultaneous execution of critical activities without affecting daily operations.
  • War rooms and working sessions to resolve high-impact incidents.
  • Support during testing and cutover activities for the core project.
  • Timely execution of reporting activities for essential processes.
The solution was designed to keep pace with the project’s evolution and sustain a consistent service level despite the increase in requests.
 
 

Additional Comment:

The capacity strategy used in this project made it possible to make adjustments at key moments, avoiding overloads in incident handling and maintaining an optimal service level.

Go Live: February 2023

Descarga la ficha técnica






    Solicita tu cotización

    Déjanos tus datos y un asesor de H3 te contacta.







      Compártenos tus datos