Jonathan Prins Email & Phone Number

Jakarta, Indonesia

▪ Identify improvement areas of dealer onboarding and loan origination end-to-end flow in terms of conversion rate and Service Level Agreement (SLA) for optimizing and making the process more efficient.▪ Collaborate with strategy team to find new initiatives to increase the sales growth level by finding the best incentive schemes and doing marketplace project on a pilot scale.▪ Work closely with Product, Data Engineer, and Software Team to ensure the data integrity and accuracy of each table stored in Database for dashboarding and reporting purposes.▪ Conduct financial audit by reconciling amount received and loss utilizing Google Sheets and BigQuery.

Data Science and Analytics Department (Jun'22 - Jun’23):▪ Created time series modeling to predict sell-out and sell-in for specific modern trade channel, resulting in time saving, which decreasing 1-2 working days into < 1 hour and increasing sell-in forecast accuracy performance by 6%.▪ Worked on Vietnam’s GT outlet segmentation by analyzing outlet’s geographical location (geospatial) and brand sales revenue. Handled qualitative (SQL database) and quantitative data (outlet survey) to get more accurate analysis.▪ Integrated data from SQL database and built automated end-to-end dashboards using Power BI for monitoring and reporting that generates insight for several stakeholders.Sales Development & Capability Department (Jun'23 - Nov’23)▪ Analyze salesmen productivity by looking up on historical pattern and give recommendation to stakeholders in order to create a new incentive scheme for next period and Monthly Business Review (MBR).▪ Build interactive dashboards for monitoring field team activities using API call from handheld application to track store's improvements.▪ Design a structure of database for storing promotion and in-store execution data by collaborating with IT team, which leads to flexibility usage for stakeholders.▪ Assist Sales Data & System Support Manager on day-to-day tasks.

▪ Manage online marketing tactical and always on campaigns (awareness, traffic, engagement, app install, conversion) across digital platforms. Work closely with Brand Marketing, Category, Engineering, and Marketing Design.▪ Analyze and report campaign performance to improve effectiveness using a data-driven approach.▪ Collaborate with Advertising Solution team to execute and monitor the daily performance of paid promotion features on web and app campaign.▪ Handle administrative duties (invoice, agreement, payment process) and onboard new affiliate partners.Tools: Google Ads (Search, Shopping, Display, Video, UAC), Facebook Ads, TikTok Ads

▪ Created forecast and analyzed the demand of cream detergent and bar soap based on historical demand, current situation, and promotion. Maintained the Forecast Accuracy (FA) of cream by 79% and bar soap by 68%.▪ Led Sales and Operation (S&OP) meeting and work closely with Marketing, Fulfillment and PPIC team.▪ Supported the Demand and Supply Head through Sales & Demand Review (SDR), daily report, and OFR analysis.Tools: JDA, Access, BI, SAP, SCM View Report

▪ Improved an interactive dashboard of distribution process and LIFR out percentage for annual and monthly report.▪ Worked closely with Business Intelligence to visualize the order fulfillment rate using Power BI.▪ Created an integrated dashboard using Power Query and Power Pivot for monitoring Inventory Health Report.▪ Built a database to harmonize all documents related to SAP that eliminates the effort and time needed.

▪ Assisted an end-to-end Quality Logistic analysis report to Senior Manager and four Industrial Region Managers.▪ Created data processing sheet and deck template for monitoring gallon storage time by weekly.▪ Analyzed bad stocks and monitor incoming products from plant to warehouse.

▪ Evaluated the process safety devices of crude distillation unit for RDMP Balikpapan Project owned by Pertamina.▪ Analyzed process flow diagram, piping and instrumentation diagram, cause and effect diagram of CDU-IV.▪ Calculated internal parameters for KO drum pump and control valves based on its process data sheet.

▪ One of 40 selected interns out of 1400+ applicants to intern in this outsourcing startup.▪ Applied self-onboarding system and successfully decreased Service Level Agreement (SLA) each activity by 50%.▪ Collaborated with 4 Project Management Officers and conducted 3 qualitative and quantitative surveys.

Bachelor'S Degree, Chemical Engineering

High School Diploma, Natural Sciences