Juan-Pierre Louw Email & Phone Number

City Of Johannesburg, Gauteng, South Africa

Participate in the full scope of a BI Project/ Solution including specification and planning the technical design, ETL, data model development, report building, testing

Midrand, Gauteng, South Africa

Four months contract role. Temporary assignment to Client - Last date: 15 September 2023Procurement buyer for Manufacturing site

Midrand, Gauteng, South Africa

Analyzing Spend Management for a prestigious Pharmaceutical client in Europe, utilizing the power of PowerBI.My key contributions include:Spearheading the maintenance of current PowerBI reports within the Procurement domain. This encompasses a comprehensive range of reports such as:Spend Analytics, Top 20, Contract Management, E-Sourcing, Procurement Processes and Systems ,and Catalog Management.I take pride in diligently updating and maintaining numerous PowerBI reports to ensure accurate and up-to-date insights for our client.Playing a pivotal role in a significant project focused on streamlining the current data source, I was part of the team involved in the conversion of Data source from Rosslyn Analytics to Snowflake.I led the implementation of the PowerBI Spend Data source from Rosslyn Analytics to Snowflake, a highly scalable and efficient platform.This transition resulted in a substantial reduction in manual work involved in monthly report updates for Spend Analytics, Top 20, Contract Management, and Savings Management.By establishing a direct connection to Snowflake, we achieved seamless data integration and enhanced efficiency.Demonstrating my expertise in implementing advanced features, I successfully implemented Row-Level Security (RLS) to provide our consumers with the ability to test reports before publishing final versions in the Workspace. This meticulous approach ensures data integrity and fosters a secure environment for our stakeholders.Additionally, I enhanced the reporting infrastructure by enabling Scheduled Refresh on a daily basis.This automated process ensures that our reports are always up-to-date, allowing our team and stakeholders to make data-driven decisions faster, as spend can now be viewed daily instead of monthly.I am passionate about driving success and thrive in collaborative environments where data-driven insights are at the forefront.

Midrand, Gauteng, South Africa

Management Trainee- National Fleet:Working in a rotational team of 3 responsible for National Fleet team duties that include:• Acquisitions (CAPIN)• Disposals• Transfers• Activation & cancellation of tracking, insurance and fuel cardsMixed Fleet size of 5000+• Ensure tracking uptime SLA is met & maintained (NDA)• Ensure Fleet Master Data aligns to various external supplier databases (Fuel, Insurance, Tracking)• Ensure Fleet Master Data aligns to internal Fixed Asset RegisterMaintain the following PowerBI reports:• Company Car (weekly vehicle check)• LIC Cora dashboard• Fleet washI am the Lean Digital Transformation SPOC for the Fleet & Exports teams, and have also completed the following LDT training in my role:• Green belt trained & tested• Lean six sigma certified

Midrand, Gauteng, South Africa

Mainly responsible for Light Fleet requirements (Varying Fleet size 1200 to 1300+):• Disposals• Transfers• Activation & cancellation of tracking, insurance and fuel cards• Ensure vehicles are correctly registered and deregistered as requiredReporting:• Daily Fleet Excel downtime report to 10 sitesPowerBI:• Design, build and deploy reports and dashboards using PowerBICompany Car Report (refer to Projects)Maintained the below existing PowerBI reports:• In-trade BreakdownLiaise with various departments to ensure accuracy of Fleet Master Data including emergency contacts.Ad hoc:• CAPIN• Heavy Fleet* Moved to Genpact due to Section 197 transfer

Nelspruit, Mpumalanga, South Africa

My duties included the below key sections:Assisting the Fleet Controller with additional tasks:• Accident/ Abuse cost control charged to Distribution/ Warehouse where applicable• Allocation of other costs to responsible cost centers (Fleet, Distribution, Warehouse, Sales and Special Events)• Ensure load tests are conducted as per legislation, and filing of the applicable recordsFleet Administration:• Maintaining accurate fleet data in SAP, including maintenance and purchase requisitions and orders.• Ensuring that all licenses and COF renewals are completed on time and updated in SAP.• Recording odometer and hours operated on a weekly basis.Liaison and Coordination:• Collaborating with various departments, including distribution, warehouse, and sales, to ensure the timely availability of fleet for service and repairs.Tyre and Stock Management:• Managing the organization's Tyre management system, including capturing data and maintaining records for Tyre change slips, scrap Tyre analysis, and urgent attentions.• Processing stock receipts and invoices and managing spares on SAP and in the workshop.Filing and Records Management• Maintaining vehicle files and service records and ensuring that they are updated in line with OEM specifications• Sorting the archival room and disposing of historical records as necessaryAudits and Reports:• Participating in internal governance audits and ensuring that all findings are closed out.• Compiling reports and communicating information as needed.• Updating the daily out of service report and distributing it as instructed by the Fleet Controller.By effectively managing and coordinating these tasks, I contributed to the efficient and safe operation of our fleet, ensuring that the organization can continue to provide reliable and timely transportation services.

Nelspruit, Mpumalanga, South Africa

As a qualified Health and Safety Officer, I have performed the following duties:Key Responsibilities:• Improved the Safety Management System (SMS) to exceed requirements.• Fostered a culture of eliminating unsafe acts and promptly rectifying unsafe conditions.• Ensured Health & Safety compliance for a small workforce of up to 10 employees on work sites with varying degrees of risk, ranging from Forecourts to Fuel Depots.Key Achievements:• Achieved a green rating on the Total South Africa external audit and increased the score by 9.5% to 86%.• Prepared documentation for upcoming NOSA compliance (Engen requirement).• Maintained a 0 reportable Department of Labour incidents record.Project Safety Management:• Facilitated and participated in all Contractor accident/incident investigations.• Ensured all incidents were thoroughly investigated, and actions were promptly taken to prevent their reoccurrence.• Coordinated and ensured the pre-check and recording of all tools, plant, and equipment.• Ensured timely actions and closure of deviation, action plans, and recommendations.Risk Management:• Conducted proper risk assessments with key role players and sub-contractors (simultaneous operations) before the commencement of tasks.• Ensured final review and acknowledgment of Risk Assessments are signed off by Total Health and Safety Practitioner before the commencement of tasks.Project Management:• Implemented and maintained Project HSE Management Specification on site.• Developed a risk assessment plan for the week ahead based on the construction plan.• Conducted regular inspections, observations, audits, and reporting.Safety File Approvals:I achieved a 100% safety file approval rate for the following projects:• Total Additive upgrade project (Nelspruit)• Total ESD (Electrical Safety Stop) upgrade project (Nelspruit)• Total Saldanha• Matla mine.

Nelspruit, Mpumalanga, South Africa

My duties included the below key sections:Fleet Administration:• Maintaining accurate fleet data in SAP, including maintenance and purchase requisitions and orders.• Ensuring that all licenses and COF renewals are completed on time and updated in SAP.• Recording odometer and hours operated on a weekly basis.Liaison and Coordination:• Collaborating with various departments, including distribution, warehouse, and sales, to ensure the timely availability of fleet for service and repairs.Tyre and Stock Management:• Managing the organization's Tyre management system, including capturing data and maintaining records for Tyre change slips, scrap Tyre analysis, and urgent attentions.• Processing stock receipts and invoices and managing spares on SAP and in the workshop.Filing and Records Management• Maintaining vehicle files and service records and ensuring that they are updated in line with OEM specifications• Sorting the archival room and disposing of historical records as necessaryAudits and Reports:• Participating in internal governance audits and ensuring that all findings are closed out.• Compiling reports and communicating information as needed.• Updating the daily out of service report and distributing it as instructed by the Fleet Controller.By effectively managing and coordinating these tasks, I contributed to the efficient and safe operation of our fleet, ensuring that the organization can continue to provide reliable and timely transportation services.

South Africa

• Administer and manage a team of up to 20 drivers including sub-contractors, scheduling driver timetables and conducting driver brief and debrief sessions where required.• Manage fleet tracking for 10+ vehicles, ensuring optimal efficiency and performance of the fleet.• Oversee fuel and tollgate operations, ensuring that expenses are reported and optimized for cost-efficiency.• Manage licensing and permits for the fleet, ensuring compliance with all regulatory requirements.• Supervise the management of the Tyre store and wash bay operations, ensuring optimal maintenance and servicing of all vehicles.• Perform regular fleet inspections and maintain detailed safety files, ensuring compliance with Health, Safety and Environmental (HSE) standards.• Report fuel and tollgate expenses, providing valuable insights to optimize fleet fuel and maintenance costs.• Take on ad-hoc duties as required, demonstrating a willingness to adapt to new challenges and responsibilities.As a highly skilled and experienced Transport Manager, I am adept at managing and administering all aspects of fleet operations. My expertise in personnel management, fleet tracking, fuel and tollgate operations, and safety compliance makes me an ideal candidate for any organization seeking a top-performing Transport Manager.

National Diploma In Safety Management, Occupational Safety And Health, Occupational Health And Safety

2 subjects outstanding. ** Subjects Completed with Distinction:** ▪ Business Management 1A ▪ Communication Skills 1 ▪ Computer Skills 1.

Diploma In Safety Management, Occupational Health And Safety, Cum Laude

Legal Principles Management Principles Safety Management 1 & 2