SAP TM and SD Consultant Certified

“FEDERICO CARLOS CASTILLO MEJIA”
SAP TM  CONSULTANT
PROFILE
Computer Science engineer, with studies in management, extensive experience implementing SAP projects. More than 15 years experience in SAP consulting in different roles such as Leader consultant, Integrator and Project manager.
5 complete cycle projects as SAP TM Consultant.
Highly specialized in integrated logistics solutions. SAP SD and TM Certified consultant, with a good skill and experience in SAP industry solutions such as SAP TM and IS-Retail. Some else modules implemented WM, LE-Handling Unit, Customer Service (CS), WF Business Workflow-Abap with a strong background functional Management (MM), Transportation (LE-TRA) Material. It also has a strong technical knowledge, including software design and programming.
Federico has excellent communication and analysis skill, he is results-oriented and its knowledge in organizational processes in industries from different sectors. Has the ability to work under pressure, teamwork, leadership attitude, good interpersonal skills and easy adaptation to change.
SAP Studies
Type              Course                                                                Year
Certified Solution Consultant SCM – SD,  SAP ERP ECC 6.0  2007
Certified SAP TM 9.1                                                                  2016
Course   Sap Solution management 2007
Course   Abap Development2007
SAP Experience
Company ETHeinsen - Naves del Atlántico - Sea and Air Cargo Agent ( Hapag Lloyd, Yang Ming, Lufthansa, EcuWorldwide) Dominican Republic 
Role: SAP EWM leader Consultant
Project Name: ET Heinsen  Industry:  Cargo Transport LSP. 
Country: Dominican Republic
Start Date:  Abril 2017  End Date: Febrero 2018
Activities
Complete Implementation project (BBP, Customizing, Realization and Testing, Go live Preparation, Go Live and Support)
NADELA - Naves del Atlántico - Almacenamiento de carga
ET Heinsen is a cargo Agent that work in association with several container shipping sea lines like a Hapag Lloyd, Ecuworldwide and also with cargo shipping airlines like Lufthansa and LATAM.

• EWM - SAP TM Integration
• EM integration

CompanyTransportes Botero Soto 
Role: SAP TM Senior Consultant
Project Name: Botero soto   IndustryCargo Transport LSP.
Country: Colombia
Start Date: January 2016  End Date: March 2017
Activities
Complete Implementation project (BBP, Customizing, Testing, Going live Preparation, Going Live, Support)

• Transportation solution for street transport with local and international transportation
• Integration Configuration (CIF)
• Master Data Configuration

• Document lifecycle Configuration (Quotation , Forwarding Order, Freight order / Freight booking / Service order and forwarding settlement document and Freight Settlement document )
• Charges calculation (rate tables models, calculation sheets models), FW Agreement, FO Agreement. Formula for Charges types, Precondition for agreement and charges types.

• Planning Configuration (VSR Optimizer) - Transportation lanes and incompatibilities.
• Discrepancy management in Freight order.
• Tendering
• Sub-contrating Configuration
• Settlement Configuration and integration with SAP ERP (SD, MM, FI, CO)
• Event Management integration

Transport Scenarios:

• Consolidation and deconsolidation
• Maritime Import and Export FCL and LCL and Air integrated with SAP ERP .
• Land Transport (LCL, FCL, PARCEL)

Company: Muebles Jamar 
Role: SAP Retail and CS Consultant
Project Name: Assortment     Industry: Retail Furniture   Country: Colombia
Start Date: July 2015   End Date: December 2015
Activities
CS:
Warranty management
Quarantine product management – (customer returns – vendor returns )
Notification management (services request, Customer complaint, customer.rel.Defect) and service orders
Retail
Assortment  to store and distribution plant .
Master data for Assortment,
Workflow to Assortment approval .
Procurement planning – buying  and  replenishment .
Layouts Management (Space management) – shelves .


CompanyServientregaRoleSAP TM Senior Consultant
Project NameSIS evolutionIndustryTransports (Land, air, sea)CountryColombia
Start DateAugust 2014End DateApril 2015
Activities
Complete Implementation project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
Global forwarding Process, mu

• Basic Setting for Transportation management (Business Function, Roles, WEB Enable, SCM Basic)
• Integration Configuration (CIF)
• Master Data Configuration

• Document lifecycle Configuration (Quotation , Forwarding Order, Freight order / Freight booking / Service order and forwarding settlement document and Freight Settlement document )
• Charges calculation

• Planning and Vehícule Scheduling Configuration (VSR Optimizer)
• Sub-contrating Configuration
• Settlement Configuration and integration with SAP ERP (SD, MM, FI, CO)
• Event Management integration

Transport Scenarios:

• Global forwarding process, OTM model (operation transportation multimodal- Road, Air and Sea)
• Maritime Import and Export FCL and LCL and Air integrated with SAP ERP .
• Land Transport (LCL, FCL, PARCEL)

CompanyAlmacenes la 14RoleSAP IS Retail Consultant
Project NameIRACAIndustryRetailCountryColombia
Start DateJanuary 2014End DateAugust 2014
Activities
Complete Implementation project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)

• Procurement Planning
• Replenishment
• Warehouse Management for CEDI
• Assortment
• Allocation tables and distribution to stores
• Warehouse management 

CompanyIntegral de servicios Tecnicos - IST.RoleSAP SD-C leader and SAP TM Consultant
Project NameProyecto HORUS IndustryThe petroleum transport and drilling servicesCountryColombia
Start DateMay 2013End DateDecember 2013
Activities
Complete Impremantarion project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
CS

• Service orders management.
• Automatic creation of services orders from the creation of sales order
• Creation of Orders services settlement and generation of invoice 
• Depot repair
• Services with time and activity report billing.
• Catering services management
• Camp service
• Drilling services

Transportation

• Master Data Configuration

• Document lifecycle Configuration (Quotation , Forwarding Order, Freight order / Freight booking / Service order and forwarding settlement document and Freight Settlement document )

• Planning and Vehícule Scheduling Configuration (VSR Optimizer)
• Sub-contracting Configuration
• Settlement Configuration and integration with SAP ERP (SD, MM, FI, CO)

Transport Scenarios:

• Maritime Import and Export FCL and LCL and Air integrated with SAP ERP .
• Land Transport (LCL, FCL)
• Dedicated Transport (Continue Transport)

CompanyOMEGA ENERGYRoleSAP SD Leader Consultant
Project NameRollout company UTOE to NIKOILIndustriaOIL and GASCountryColombia
Start DateOctober  2012End DateMarch  2013
Activities

• Setting SD and LETRA model for new Company
• GAPS Analysis and Implementation
• Testing
• Going Live Support

CompanyDITRANSA S.A. – Medellín, Colombia.RoleSAP TM Consultant
Project NameTransportation management 8.1IndustriaTransportCountryColombia
Start DateFebruary 2011End DateSeptember 2012
Activities
Complete Impremantarion project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
CS

• Adaptation of a type of notification for to built the cockpit document control and output messages of transport.  
• Check list of documents for billing with Activities catalog
• Master Data Configuration

Transportation

• Defining the interactive planning solution (SAP SCM APO TP / VS - LETTER SAP ECC).
• Demand planning DP.
• CIF Configuration.
• Definition of integration Monitor Tracking (SAP SCM SAP ECC LETTER vs EM).
• Discrepancies Management

• Sub-contrating Configuration
• Settlement Configuration and integration with SAP ERP (SD, MM, FI, CO)
• Event Management integration

Transport Scenarios:

• Import and Export FCL and LCL and Air integrated with SAP ERP.
• Land Transport (LCL, FCL)
• Continue Transport

CompanyETAFASHION y RM, EcuadorRoleSAP IS-RETAIL  Leader Consultant
Project NameDominioIndustryRetail FashionCountryEcuador
Start DateMarch 2010End DateOctober 2010
Activities
Complete Impremantarion project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)

• Distribution Planning for product to Stores (Assignment Tables, Collectives orders,  Season orders)
• Distributions Plant management (Lean WM)
• Procurement and distribution planning – Replenishment (PULL, PUSH, forecast planning, maximum, minimum and reorder point).
• Crossdocking  and Flowthrough
• Sales by Catalog

CompanyEnergysolutions - Houston,TxRoleSAP SD Consultant
Project NameFacturación SDIndustryGas oilCountryUSA
Start date: November 2009    End Date: March 2010
Activities
Project Improvement of SAP

• Modeling SAP Process – BBP Document
• Implementing SAP SD

CompanyC.I. ACEPALMA S.A. y  SOLUTRANS LTDARoleProject Management and LETRA Consultant
Project Name RollOut de C.I. ACEPALMA S.A. a  SOLUTRANS LTDA de los módulos
FI, CO, CO-PA, MM, SD y LETRA.IndustryTransportCountryColombia
Start DateSeptember 2009End DateNovember  2009
Activities
Complete rollout project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)

• Design transportation model using LETRA
• Configuring LETRA
• TESTING
• Going Live

CompanySOFASA RENAULT – MedellínRoleSAP  SD, LETRA Consultant
Project Name
IndustryEnsambladora de VehículosPaísColombia
Start DateMarch 2009End DateSeptember 2009
Activities

• Implementation of Transportation and tracking process to control the export of parts  using SAP ERP SD and LETRA
• Pricing
• Some ABAP development such as (forms, user-exit, batch Input, Report)
• Intercompany sales processes Sofasa and IRTM.
• Logistics processes (LE- Handling unit, LE-TRA, etc) to IRTM enterprise.
• Sales workflow intercompany services.

CompanyHolasa S.A.RoleLETRA Consultant
Project Name
IndustryMetalCountryColombia
Start DateDecember de 2008End DateMarzo de 2009
Activities
Implementation of solution to plant and control the transport of product.

• Basic LETRA Configuration
• Lifecycle of Document (Sales Order, Deliveries, Shipping Document, Settlement Document, Billing)
• Pricing

CompanyGrupo Espumados, Espumas del litoral, Espumas del ValleRoleSAP SD Leader Consultant
Project nameEmperadorIndustryFurniture
Muebles y colchonesCountryColombia
Start DateJuly 2008End DateFebruary 2009
Activities
Complete implementation project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
Design and configuration of several scenarios:

• Make to order
• Pricing, local taxes
• Business Workflow to approval sales Documents
• Intercompany
• Credit control
• Distribution to Customer ( LETRA )
• Transportation
• Batch Management
• Consignment product management
• Some ABAP Development (FORMS, LSMW, User Exit, etc)

CompanySuper de Alimentos S.A.RoleSAP SD Leader Consultant
Project NameKAWAIndustryFoodCountry Colombia
Start DateJuly 2007End DateJanuary 2008
Activities
Complete implementation project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
Design and configuration of several scenarios:

• Make to order
• Make to stock
• Pricing
• Lean WM
• Handling Unit.
• Sales Export
• Transportation Exportation
• Return
• Batch Management
• Credit Management
• LIS

CompanySAP BrasilRoleSAP SD Consultant
Project NameUp-grade Baseline Best Practice ECC 6.0 Versión V1.5 a V1.3IndustrySoluciones ERPsCountryBrasil
Start DateFebruary 2007End DateJune 2007
Activities
In charge of update of baseline best practice for Colombia and Venezuela - Upgrade Baseline Best Practice ECC 6.0 Versión V1.5 a V1.6  SD and MM scenarios.
Creation and upgrade BC SETs, Data Masterlist, Creation and upgrade Building Blocks, baseline activation test.
BC SETs Creation and update, upgrade of Masterlist, Building Blocks Creation and upgrade, Documentation.


CompanyColchones RosenRoleSAP SD Consultant
Project managementImplementación Retail.IndustryRetailCountryChile
Start DateJuly  2005End DateJanuary 2006
Activities
Complete implementation project (project Preparation, BBP, Customizing, Testing, Going live Preparation, Going Live, Support)
SAP SD design and configuration of all scenarios

• Make to Order
• Make to stock
• Sales Exportation
• Local Sales
• Sales in POS

CompanySoprole,  ProleSur, miembro de Grupo Fonterra y MVCAmericas, Santiago, ChileRoleSAP SCM TP/VS Consultant
ProyectoTransport Planing IndustryFoodCountryChile
Start DateFebruary 2006End DateOctober 2016
Activities
Implementation Project SCM TP/VS

• Master Data and transport Requirement (CIF)
• Tp/vs planning (Optimizer)
• LETRA Integration

EnterpriseRED COLOMBIA S.A.RoleCONSULTOR CS, WF-ABAP
ProjectMunicipio de MedellínIndustriaPublic SectorPaísColombia
SinceJuly de 2003ToOctober de 2003
Activities
Service request notifications
Workflows for notifications and activities  


Other Project As SAP ERP SD, Workflow and Customer Service CS Consultant in around of 4 years
Those projects were in Colombia, Venezuela and Chile.

No SAP Skils

• Software Developer C, Delphi and Visual Basic
• Windows Server Administration
• Peoject Management of software development