* supported analytical data for General Manager of Merchandising (GM) and 4 Head Managers of Merchandising’ strategic plan for Books and Non Books (Stationery and Lifestyle) Division* directed reports of periodic sales and inventory performance to the GM, managers and team* manage forecast of monthly target sales for more than 100 active Gramedia stores all over Indonesia* pioneered budgeted planning for buyer of Stationery and Lifestyle Division * coordinate with regional teams to optimalized budget * directed periodic reports for budget consumption for more than 100 active Gramedia stores all over Indonesia* managed master data for sales and inventory per store per department for both Books and Non Books Division* coordinating with SIT Dept to create direct ETL reports * joined the team for redesigning and calculating pricing policy in Gramedia stores for Stationery Division, as well as communicate to the store and team (stores and head office) for technical timeplan

* directed a team of 4 with each responsibility in data (sales and inventory performance, vendor performance) for Non Books Stationery Division and warehouse analysis * organized a data support periodic planning * managed database for sales and inventory per store per department for Non Books Stationery Division* directed a team of 4 for managing different product category (Art Supplies, Binding and Filing)* screening new item to sell in stores* coordinate a good stock level at store for product category responsibility and Homebrand product* strategic plan for product responsibility* created and developed new items strategies, collaborated with Product Development team* managed tender for production, along with Product Development team* develop competitive product pricing to gain the optimal margin for company and value to customer

* analyzed need and forecast sales and target of home brand products for Non Books Stationery Division* pioneered market acquisition plan to get best product with best margin * created and developed new items strategies, collaborated with Product Development team* managed tender for production, along with Product Development team* managed QC for new items* managed stock distribution either direct to store or via warehouse* coordinate a good stock level at store for Homebrand product * develop promotional activities to achieve target and marketing timeplan* managed imported goods from overseas* initiated SNI for overseas suppliers as requirement for selling products* develop competitive product pricing to gain the optimal margin for company and value to customer

* managed a team of two for Imported products* supervised team for importing and clearing the custom process * coordinate a good stock level at store for imported product * approved needs and assist fulfilment of imported goods for Gramedia store* collaborated with Marketing and Communication team for annual events* pioneered events to familiarize potential product, collab with Sales Promotion Department* enhanced sales by assembling nationwide coloring events, collab with Sales Promotion Department* develop competitive product pricing to gain the optimal margin for company and value to customer* managed training / product knowedge for store on how to sell the product better * collaborate with overseas supplier regarding production and planning events

* analyze needs and assist fulfilment of imported goods for Gramedia store* managed stock distribution from warehouse * assist merchandiser for product knowledge / training plan * collaborate with Marketing and Communication team for annual events* collaborate with overseas supplier regarding production and shipment* collaborate with Indonesia forwarder for clearing the custom process

As per study case from Surplus.id, we mainly analyzed about customer behavior. Below our core analysis for this internship :* data understanding for sales and order for certain timeframe of dataset* exploratory data analysis for customer type and behavior related to several parameter such as user registration, payment method, shipment method, voucher activity, product category, and customer location* exploratory data analysis for merchant profiles related to merchant parameter, such as merchant registration, merchant notification, merchant category, product category, and merchant location* customer clustering by using KMeans Algorithm (machine learning) for RFM parameters* marketing strategy and recommendation

I worked as store manager at Century Healthcare Botani square Bogor for about 2 years. Store manager were supposed to plan and select potential goods to be sold in the drugstore. Also, we supposed to manage the sales to a certain growth as well as maintain good relationship with customer and give the best advise about product as per customer necessity.