- 搭建潘多拉5人数据团队，对接品牌方和店铺运营，商品的一系列数据需求，主导部门数据、报表的自动化，理清，整合现有重复数据，提升数据生成和使用效率。及时反馈品牌方对数据的各种需求，包括GMV,UV,ATV,CVR等指标，涉及店铺，竞店，市场大盘，动销，商品等各个数据维度。- 搭建事业1群6人的数据团队，涉及品牌包括Cartier, Piaget, 梵克雅宝，Qeelin，Jimmy Choo, Kenzo, BV, TK等，品类涉及珠宝，腕表，箱包，男女鞋，男女装，香水等。负责团队数据人员的业务指导和培训，通过PYTHON、SQL和fine bi去优化现有的数据操作流程，包括历史数据的存档，数据采集与整合等- 负责事业1群总体的数据处理工作，包括设计各类数据报表模型，追踪自己店铺与竞店数据， dashboard搭建，外部数据与报告的分析与分享，事业群内部的各种维度的数据分析，复盘报告的撰写等- BD数据支持，负责提供事业1群涉及类目的各类数据，support BD 去pitch新的品牌

- BI development, in charge of whole BI construction and development in SCG top management. It was been divided 4 phases. In phase 1, I designed SCG daily GMV dashboard, and co-work with TIC colleague to develop dashboard both PC and mobile platform, now the mission of phase 1 had accomplished. In phase 2, I plan and design monthly SCG dashboard, it will include more data dimensions, such as SLP, HCs, productivity, order quantity, average order value and so on. On the other hand, it will cover all the SCG business groups, such as Nike Tmall, Nike official store, Converse Tmall, Nike HK official store, Microsoft HK, NBA (Taiwan) official store and so on. Now the project is in process.- Business Development, take part in customer business develop, both domestic and oversea, the job contents including customer communication, business analysis, pitch ppt design, customer quotation etc. Our clients including Adidas HK, MLB, AUsuperme, Casaba Sea, Hasbro, Pony etc.- Liby Tmall project, as core member to participate in Liby Tmall project pitch. I was responsible for Liby quotation measure and calculate. After signed contract with Liby, I in charge of supply chain management of Liby Tmall flagship store in short term in order to through the run-in period more smoothly.- IKEA Tmall Project, as core member to participate in IKEA Tmall project pitch. In this project, I was responsible for IKEA quotation measure and calculate, give my opinion or logic for goods select range, BI report, data analysis etc. Now the project is moving on.- Business review report design and implement. Related KPI including GMV, store level profit, revenue, headcount, AR, productivity. By different store and brand, break down into different functions, compare with forecast, budget and actual result to analyze and reflect business status of SCG and give advice to management for enhancement.

- GfK report development with Taiwan IT, responsible for report design, data verify and maintain. Base on Gfk raw data which Acer bought from GfK company, consolidate different dimensions, increase new fields and grouping for new PAP Gfk report, make it could cover all PAP countries and users.- Channel inventory report, collect and consolidate sellout and inventory data from PAP countries, use MS BI tool to design PAP channel inventory report, in order to reflects weekly sales and inventory status in Tier 1/ Tier 2 of PAP countries- Acer own inventory report, which is reflect Acer own inventory quantity in different countries warehouse or in forwarders warehouse, it need to consolidate the data from AAP, china and Taiwan, divide different buckets according to stock age, calculate stock value throgh currency unification- Develop PCP system with IT together, in order to collect detailed channel partners information from PAP countries, including channel tier, customer name, customer type, integrate raw data to one format, one customer code in system- Gaming series report, designed gaming series report for the Acer gaming products launch and tracking, it covers all the Acer gaming products in PAP countries, both sellout and inventory. HQ management could know the gaming products sales and stock in all PAP countries by weekly.

- In charge of Acer dealer's target and shop's target management and enhancement, including target collection, consolidation and analyzation. Verify regional data if it meet company target requirement, such as shop incentive policy, channel policy and minimum sales target.- Cooperate with IT department to develop Acer Target System, in order to collect dealer and shop target from different regional sales. Regional managers and sales director could use this platform to review and approve target. We use target data to review and analyze dealer business status and dealer forecast and generate sales target report for daily business tracking.- Enhance current E-channel interface. Through the system, dealers could find quarterly channel policy, target setting and their rebate- Quarterly dealer rebate calculation depends on dealer target setting and rebate policy- Participate in "节能惠民”project, in charge of dealer material review and subsidy calculation- Support Monitor BU for rebate calculation, target collection, special case application and price protect calculation.

Responsible for HP commercial NB and PC management, including product order management, inventory management, product category management and promotion management.

Work at business management,including:- Sales forecast, including BU sales forecast, regional sales forecast and customers sales forecast, compare and analyse different forecast, report to CEO, CFO, CSO etc.- Sales data collection, maintain and update(Both PRC and HK all related sales data, input file update, database maintain, in order to support sales analysis and reports)- Report design, making(PRC+HK, establish reporting system, according to leader's request.The frequency of reports divide daily report, weekly report and monthly report. The contents of reports concern product category, sales revenue, margin, sales runrate, sales forecast, sales target, vendor target and so on. Especially, prepare statement for sales director weekly meeting)- Data/Report analysis(PRC+HK, make different report for boss, analyze the data and give the solution) - BI Project Management.(Responsibility for reports of BI project, include report's demand, requirement revise and confirm, report testing, update, training.The reports are provided to different key users, such as CEO, sales director, sales managers, vendor managers, BU managers, regional managers, OS and IS ……- Sales scorecard(a part of sales commission,evalue sales performance/achievement, main index including vendor target, sales target,city coverage, effective customers)- Sales rebate management(Responsibility for HK rebate program, inculding rabate contract management, tracking report, rebate calculation, work with HK colleague and accountant)- Other sales management(Including prepare for morning sales review, meeting minutes sending, communicate with sales in order to handle marketing status, keep in touch with HK colleagues)Ingram Micro Key accounts: ACER, AMD, CISCO, EMERSON, EPSON, HP, INTEL, MICROSOFT, SAMSUNG, LOGITECH

-Communicate and maintain the relationship with key account-Provide quotation and solution to the customers-Coordinate the affair between customer and logistics department-Especially, responsible for UPS business,include quotation、logistics solution, communication and so on.Key Accounts: DHL-EXEL、UPS、FEDEX、GE、INTEL、IBM、BOSCH、OLYMPUS、LV、MOLEX

In charge of all the business reports of logistics enterprise,such as sales reports, marketing analysis reports, customer analysis reports, business units report and so on.-Trainning statisticians of business departments.-Edit SOP for report's collection requirment-Provide all the analysis reports to top managements

Assist market manager to in charge of market reports、products promotion and keep good relations with our customers.