Muhammad Affandi Email & Phone Number

Jakarta, Indonesia

• Forecasting sales, inventory & buying by article level (rolling forecast) & brand level in order to give buying recommendation for merchandiser by attribute, similar article, number of quantity buying, sizing curve and the incoming period.• Review inventory level, sales,sell thru, margin, aging stock and inventory by discount bucket.• Review in season buying plan by historical SKU performance.• Prepare any adhoc analysis related to merchandising.• Monitor incoming goods and review the allocation in order to ensure the incoming on track and allocation already go to the right store.

Jakarta, Indonesia

• Analyze historical data and trend in Merchandising journey to determine accurate grading, depth, and number of article in buying.• Responsible to plan merchandise procurement from Stock Plan, OTB, & execute Buying process based on sell thru analysis, input the PI, and Weekly Repeat Order Proposal as well based on sound analysis to achieve category accuracy & growth target.• Determine initial retail price that considering the margin and most relevant price. Manage, control & monitoring pricing by weekly sell thru performance review and do necessary action plan and strategy to maintain the dilution• Review & analyze merchandising related reports then make summary reports & action/ plan to superior• Responsible to monitor & coordinate RO arrival planning vs realization thru order track and present in Repeat Tracker & RO Stockplan

Greater Jakarta Area, Indonesia

* Responsible for merchandising planning & data analyzing, to ensure achievement of category profitability as per management’s target* Responsible to generate, analyze & react on routine category related reports that support betterment in category processes such as Huddle Review & ABC Review on Monday, Sell Thru Review on Tuesday, ROS Review on Wednesday, and Sold Date Review on Thursday* Responsible to monitor & coordinate new arrival planning vs realization thru order track and plan the new arrival items in Plan Display Report based on principal launching schedule on Friday* Responsible to monitor & coordinate merchandise distribution planning vs realization in Distribution Monitoring on Tuesday and Friday* Visit retail stores to ensure merchandise placements, exposure as well as retail team knowledge already supporting target achievement and make a Visit Report at least once a week* Maintain data accuracy and develop the simple and user friendly report to best support for better analysis and problem solving with accuracy and timely manner

Greater Jakarta Area, Indonesia

• Responsible to performing data operational support duties of the Banking Transaction Division.• Responsible to generate data KPI team and operational reporting.• Developing and using generate coupon application for National wide program (135 branch)• Reviewing, analyzing data from multiple sources (Business Object, Qliksense) and also ensures the presentation of accurate and consistent for team.• Provide support and guidance to team to help analyze and present result of quantitative and qualitative assessment.• Use the transformation power of data and technology and create format data to provide business analytical cases.

West Java Province, Indonesia

• Responsible for working on a range of projects, designing appealing websites and interacting on a daily basis with graphic designers, back-end developers and marketers.• Developing and maintaining the front end functionality of websites.• Participating in discussions with clients to clarify what they want.• Designing prototypes for websites.• Contacting external webmasters to confirm link placements.• Provide guidance to other team members on web development issues.• Developing websites that have a consistent feel and look throughout all web properties.• Providing technical support to end users.• Experienced in updating website pages using a Content Management System (CMS) platform, with preference given to Typo3 and Wordpress.• Project handled:- PT. Agricon Putra Citra Optima (www.terminix.id)- RS PMI Bogor (www.rspmibogor.or.id)- PT. Aneka Design (www.anekadesign.id)- Badak Indonesia Organization (www.badak.id)- Por Pro DKI Jakarta 2015 (www.porprovdki2015.id)

West Java Province, Indonesia

• Experienced in writing content for social media.• Responsible to manage digital assets (social media).• Creating unique digital marketing programs and monitoring performance of digital campaign.• Project handled:- LG Electronics Digital Assets (facebook, twitter and instagram)

Banda Aceh Area, Aceh, Indonesia

• Gained new knowledge in the electricity industry by working as manage, monitoring and controlling for SCADA (Supervisory Controlling and Data Aqcuisition) PLN.

Banda Aceh Area, Aceh, Indonesia

• Development of projects from proposal right up to delivery.• Setting, communicating and maintaining timelines and priorities on every project.• Communicating, maintaining and developing client relationships.• Managing sponsor relationships.• Providing leadership, motivation, direction and support to team.• Being responsible for all project budgets from start to finish.

Banda Aceh Area, Aceh, Indonesia

Gained new knowledge in the telecommunication industry by working as manage network, fixed telephone network and network controlling.

Bachelor Of Science, Computer Science

Electrical And Electronics Engineering

High School