Andrew Jacques

Background

About Andrew Jacques

Thanks for visiting my profile. Conversations welcome!Email: akjacques@gmail.comHaving a hand in moving nearly 12% of all containers shipped across the planet, I’ve learned that painstaking planning, keeping track of thousands of moving parts, and staying in close contact with all the individuals routing them is required to reach their intended destinations.This takes relentless attention to detail, facility with technology, and a respectful tone convincing people to take the actions needed to resolve a given problem.Examples of making this work:• Supported VPs of Trade and Sales in formulating and implementing business plans. Conducted data analysis informing executive planning sessions and strategic initiatives’ development. Proposed specific projects in line with strategies for approval and implementation and follow through, including ongoing reporting.• Developed an early warning system to flag problem bookings or under-utilization. Models projected ships’ cargo capacity and service requirements (port docking schedule/routes) including average contribution (USD) per 20’ container.• Utilized VBA to automate reports reducing time required from 20-30 hours per week to 10 minutes daily. Developed a sales rate request process/tool integrated with legacy systems that reduced pricing analysts’ time ~10 hours per week while enabling rate request responses in ≤ 24 hours.STRATEGY & PLANNINGStrategic DevelopmentProcess Planning & ImprovementGross Profit ImprovementDecision SupportPricing StrategySales BudgetingLOGISTICS & SUPPLY CHAIN Forecasting Capacity/Utilization/ContributionDemand PlanningSales Support SYSTEMS & ANALYSISAnalysis & Decision SupportForecasting ModelsReporting Automation & Systems IntegrationTECHNOLOGY & TOOLSDatabase Maintenance Advanced ExcelVisual Basic for Applications (VBA)Automation Implementation Database Management & ComplianceTECHNICAL SKILLSExpert user Microsoft Office (Excel, PowerPoint, Word)Proficient with VBA programming language, processes and tasks automationProficient with SQL for database query and managmentDatabase platforms – BIQuery, Qlik Sense, IBM Cognos, Access