Total 6 transportation logistics job vacancies in singapore south west

• Reporting and updating of daily KPI for ASEAN
• Managing and resolving customers complaints
• Collating and updating of various logistics information (Warehouse productivity, stock ageing, costs etc)
• Verifying invoice cost on warehouse, inbound/outbound cost
• Verifying ad-hoc cost for shipment invoices (DHL/Fedex)
• Updating and summarising incoming shipment report, inbound movement report and outbound shipment report
• Requesting for quotations from freight forwarders for both import and export shipment
• Cycle Counting using SAP to check physical stock using warehouse counts
• Coordinating monthly billings and subsequently hosting monthly department meeting
• Communication and coordination with leading logistics service providers and warehouse employees
• Other ad-hoc tasks may assigned

1.    To perform Data Analysis and Reporting
a.    Analyse and generate reports of Asia Pacific data on Customer Backlog (CBL) 
b.    Work with Sales Logistics Customer Interface Team to ensure data quality and track the progress of CBL.
c.    Perform data validation, identify the root cause and resolves issues to improve the order fulfilment rate and overall impact on customer service level. 
d.    Write complex SQL queries to extract, transform, and aggregate data from large databases efficiently. 
•    Utilize Common Table Expressions (CTEs) to create temporary result sets and simplify query readability. 
•    Leverage Window functions to perform advanced analytical operations, such as ranking, partitioning, and aggregations, within SQL queries.
•    Optimize SQL queries for performance by using appropriate indexing strategies and query execution plans.
•    Employ various JOIN operations (INNER JOIN, LEFT JOIN, FULL OUTER JOIN) to merge data from multiple database tables efficiently.
•    Create subqueries and correlated subqueries when necessary to retrieve specific subsets of data.
•    Implement conditional logic and CASE statements within SQL queries to handle complex data transformations.

e.    Continuously optimize SQL queries for performance, scalability, and maintainability. 
f.    Monitor and tune database performance to ensure efficient data retrieval.

2.    To build and enhance scripts / dashboards to support Process Automation
a.    Build and enhance Power BI dashboards with existing databases (SQL database, etc.) on different Order To Cash (O2C) topics.
b.    Maintain and improve current Power BI dashboards, including enhancing SQL scripts in databases and DAX measures in Power BI.
c.    Provide technical support to resolve data-related issues and troubleshoot problems in dashboards, and reports.
d.    Develop Python scripts to streamline and automate manual data transformation processes. 
e.    Identify repetitive data preparation tasks and create reusable Python scripts to perform data cleansing, formatting, and aggregation. 
f.    Continuously optimize and enhance Python scripts for performance, scalability, and efficiency.

3.    Cross-Functional Collaboration
a.    Collaborate and align with central departments / stakeholders to support in achieving sales targets.
b.    Manage multiple projects simultaneously, ensuring timely delivery of data analysis and reporting solutions. 
c.    Collaborate with project stakeholders to define project scope, objectives, and deliverables.

The Logistics Specialist in Transportation is responsible for managing intercontinental and intra-Asia shipping arrangements, ensuring smooth logistics operations. This role involves handling deviations, escalations, and exceptions with Logistics Service Provider (LSP) management, collecting data for analysis and improvement projects, participating in RFQ mapping and tendering processes, generating KPI reports, and managing transportation-related claims.

Key Responsibilities:

• Coordinate intercontinental and intra-Asia shipping arrangements.
• Ensure timely and efficient movement of goods across different regions.
• Handle deviations, escalations, and exceptions with LSP management.
• Ensure timely resolution of issues to maintain smooth logistics operations.
• Collect data for future analysis and improvement projects.
• Contribute to cost-saving initiatives and the enhancement of transportation processes.
• Participate in RFQ mapping and tendering processes.
• Provide insights and support as needed to ensure competitive and effective logistics solutions.
• Generate consolidated KPI reports for transportation operations.
• Create required dashboards to provide management with visibility into logistics performance.
• Provide support in managing claims related to transportation issues.
• Facilitate resolution processes to ensure claims are handled efficiently.

1.    To perform Data Analysis and Reporting

• Analyse and generate reports of Asia Pacific data on Customer Backlog (CBL) 
• Work with Sales Logistics Customer Interface Team to ensure data quality and track the progress of CBL   
• Perform data validation, identify the root cause and resolves issues to improve the order fulfilment rate and overall impact on customer service level 
• Write complex SQL queries to extract, transform, and aggregate data from large databases efficiently. 
• Utilize Common Table Expressions (CTEs) to create temporary result sets and simplify query readability. 
• Leverage Window functions to perform advanced analytical operations, such as ranking, partitioning, and aggregations, within SQL queries.
• Optimize SQL queries for performance by using appropriate indexing strategies and query execution plans.
• Employ various JOIN operations (INNER JOIN, LEFT JOIN, FULL OUTER JOIN) to merge data from multiple database tables efficiently.
• Create subqueries and correlated subqueries when necessary to retrieve specific subsets of data.
• Implement conditional logic and CASE statements within SQL queries to handle complex data transformations.
• Continuously optimize SQL queries for performance, scalability, and maintainability. 
• Monitor and tune database performance to ensure efficient data retrieval.

2.    To build and enhance dashboards to support Process Automation

• Build and enhance Power BI dashboards with existing databases (SQL database, etc.) on different Order To Cash (O2C) topics.
• Maintain and improve current Power BI dashboards, including enhancing SQL scripts in databases and DAX measures in Power BI.
• Provide technical support to resolve data-related issues and troubleshoot problems in dashboards, and reports.
• Develop Python scripts to streamline and automate manual data transformation processes. 
• Identify repetitive data preparation tasks and create reusable Python scripts to perform data cleansing, formatting, and aggregation. 
• Continuously optimize and enhance Python scripts for performance, scalability, and efficiency.

3.    Cross-Functional Collaboration

• Collaborate and align with central departments/stakeholders to support in achieving sales target
• Manage multiple projects simultaneously, ensuring timely delivery of data analysis and reporting solutions. 
• Collaborate with project stakeholders to define project scope, objectives, and deliverables.

As a Customer Logistics Planner for Asia Pacific-China (APCN), you will play a pivotal role in managing and optimizing the supply chain operations for APCN. The ideal candidate will have a strong background in logistics planning, preferably with proven experience in logistics planning or a similar role in the Asia Pacific region including internships or background in logistics planning or supply chain management. Proficiency in SAP for supply chain activities and excellent communication skills in English are essential for success in this role.

Key Responsibilities:

• Collaborate with overseas suppliers to manage and track purchase orders.
• Oversee inventory activities within the APCN regional warehouse.
• Implement effective inventory control strategies to optimize stock levels.
• Work closely with cross-functional teams to align demand planning with business plans and sales targets in the APCN region.
• Regularly monitor stock levels in the warehouse and take proactive measures to prevent stockouts or excess inventory.
• Coordinate with country order managing teams to ensure timely communication and resolution of issues.
• Handle the phase-in and phase-out of products in the portfolio.
• Manage the process of handling commercial returns efficiently.
• Oversee stock adjustment activities, including handling scrap, lost, and found items.
• Measure and optimize the number of days it takes to turn inventory.
• Monitor and manage the average value of inventory to ensure cost-effectiveness.
• Track and improve delivery performance metrics to meet customer expectations.
• Manage and optimize logistics costs related to freight, warehouse operations, etc.

1. Monthly Reporting

• Import/export shipment report
• Updating warehouse/transport cost
• GIT report
• ASN KPI availability Report
• HS code report
• Inventory report

1. Coordinating on incoming shipments with warehouse/sales team
2. Coordinating on incoming cargo damaged survey
3. Follow up on inventory discrepancy with warehouse/sales team
4. Requesting quotations from freight forwarders
5. Cost allocation for domestic transport for all sales dept
6. Verify Vendor Invoices
7. Host monthly dept meeting
8. Adhoc tasks