Gilberto Silva Abrego Email and Phone Number

- Database administration.- SQL for data analysis.- Reporting with SQL Server Analysis Services and Business Intelligence activities.- ETL processes implementations with SQL Server Integration Services.

- Design end-to-end solutions for demand forecasting, inventory optimization, order management, and fulfillment processes within the supply chain domain. Collaborate with stakeholders to understand their specific requirements and align the solution design with business objectives.- Work closely with business analysts and stakeholders to gather and analyze functional and technical requirements for supply chain solutions. Translate business needs into clear and comprehensive technical specifications for system design and implementation.- Assess and integrate Blue Yonder's solutions with existing systems, applications, and data sources. Ensure seamless interoperability and data flow between different components, including ERP systems, warehouse management systems, and transportation management systems.- Provide technical leadership and guidance to development teams throughout the project lifecycle. Collaborate with cross-functional teams to ensure the successful implementation and integration of supply chain solutions, addressing any technical challenges or issues that arise.- Collaborate with project managers to define project scope, timelines, and resource requirements. Assist in project planning, estimation, and risk assessment. Provide technical expertise to ensure successful project execution and delivery.- Engage with stakeholders, including supply chain professionals, business users, and executive management, to understand their needs, address concerns, and communicate solution designs effectively.

- Works with project managers and key customer executives in JDA Inventory Optimization, Order Promising, Sales & Operations Planning, Factory Planning, Demand & Fulfillment and Enterprise Supply Planning project implementations. - Design and develop platform workflow/ user interface, integration scripts, ETL mapping, data modeling and data loading.- Responsible for services delivery of product implementation and related integration.

- Responsible of juice, purees and special products supply and demand fulfillment. - Responsible of sales forecast fulfillment. - Production, blending, shipping and inventory management KPI's implementation to assure on time delivery, quality and supply chain cost reductions.- Master planning scheduler.

Responsible of identifying potential customers based on market research and needs in fruit industry. First contact with customers and administration of client portfolio.

Responsible for the design of master planning, inventory management and variable costs modules in ERP project implementation. Responsabilities: - Deliver the real requirements of the processes of the area. - Validate and implement process "to be" and best practices. - Reponsible of training to final users.

Establishment of production, blending and shipping plans with plants considering sales forecasts, with the objective of meeting our client demands, reducing inventory maturity and benefiting logistics costs through the whole supply chain. Some of the specific objectives: - Sales FCST fulfillment- Operation plans and fulfillment- MPS anlaysis

Five month project at Veracruz, Mexico where the main objective was to get to know the citric industry starting with the purchase of fruit until the shipment ot concentrated and non-concentrated juice.Project focused in inventory management digitalization and shipment and blending juice optimization.

Leader of finish good warehouse and export department. Coordination of exports to national and international clients. Inventory controls and handling of returnable containers. Direct contact with clients, transport lines and customs agents.

Inventory and assortment controls, returnable container logistics, international exports and elaboration of export documents.

Export to different countries, coordination with clients, customs and transport and elaboration of export documents.

International export activities, control of inventories, forecasts for use of cardboard and totes and preparation of export documents.