Fran Siska Email & Phone Number

-Analyze historical data to forecast product demand, ensuring product availability exceeded 95%-Calculate upcoming campaign contributions to optimize stock levels for brands (Johnson & Johnson, Delfi, Pixy, etc.) under SBS (Service By Shopee)-Collaborate with internal stakeholders to coordinate stock levels, aligning with campaign requirements-Implement data-driven strategies to maintain optimal inventory levels and prevent stockouts during promotional campaigns-Develop… Show more -Analyze historical data to forecast product demand, ensuring product availability exceeded 95%-Calculate upcoming campaign contributions to optimize stock levels for brands (Johnson & Johnson, Delfi, Pixy, etc.) under SBS (Service By Shopee)-Collaborate with internal stakeholders to coordinate stock levels, aligning with campaign requirements-Implement data-driven strategies to maintain optimal inventory levels and prevent stockouts during promotional campaigns-Develop expertise in VBA (Visual Basic for Application) programming on Microsoft Excel, reducing manual workload by automating tasks such as discontinuing low-sales product, resulting in a significant time-saving from 1 hour to 15 minutes Show less

-Built partnerships with 30+ suppliers (mostly local farmers) to be our partner in Shopee Segar Jabodetabek and Surabaya-Led the suppliers acquisition (meat category) by canvassing potential suppliers and generating progress report to top level management-Analyzed price competitiveness and negotiated with suppliers to get the best margin

-Successfully listed over 500 mom and baby products and services on the company's website-Monitored content reviews in strict adherence to the website's Standard Operating Procedures (SOP)

-Maintained close communication with talents by introducing campaign briefs and reminding them of the post schedule-Generated campaign reports by analyzing Key Opinion Leaders' (KOLs) social media insights-Administered rate cards for 124 new TikTokers, updating the company's data assets

A booth installation project was held at Grand Metropolitan Mall, Bekasi on August 3rd, 2019.- Took minutes of meeting- Coordinated with all head divisions to develop the event proposal, sponsorship proposal, and final report

S.I.Kom, Mass Communication, 3.82 Out Of 4.00

1. Social Media Specialist Antar Makna A campaign project to promote healthy communication in relationships. -Prepared content and created.

Natural Sciences