To obtain a challenging Business Analyst position that enables me to make a positive contribution to company by utilizing my skills to their fullest potential.
MS Excel (Vlookup and Pivot Table), Access/SQL, PowerPoint and MicroStrategy,
*Teaching English as a Second Language (TEFL) certificate
01/2015 to Current
International Business AnalystManhattan Beach, USA, CA
Work closely with Merchandising, Marketing, Allocation and Legal Team to produce analysis and management reports for International Department such as Key Initiative Report, Top Sales Report, Key Outsole Projection Report, Forecast Projection Report, Grey Market Analysis, Month-End Sales Report/Sales History, and Backlog Report Analyze merchandise performance throughout International at Territory/Division/Gender/Outsole/Style/Color level Manage implementation of the data warehouse and business intelligence tool to reporting and analysis needs are met, automated and data validated the Key Initiative Report through MicroStrategy - which became the first report being successfully automated in the International Department.
Current projects including but not limit to, Weekly Backlog Report and Forecast Projection Report Conduct product pricing research for International including Subsidiaries, Joint Venture, and Distributors Compile and Manipulate large amount of data from multiple systems and formats by analyzing the data and presenting the findings in a clear, easy-to-interpret format Strategize with cross-functional teams, serve as liaison between business objectives and information technology capabilities Take full responsibility for Month-End VAT Reporting, VAT Invoice issuing, and Europe SARL Costing Issue tickets for various system malfunctions and enhancements, provide user testing and implementation.
07/2013 to 10/2014
Marketing Manager/InstructorEF － Shenzhen, China
Planned and executed education events that targeted for class promotions and successfully boosted the overall enrollment Strategized and managed business social events for students which led to a connection-based community establishment Created student portfolios and information spreadsheet for potential student referrals to ensure conformance within the center Organized and attended weekly sales & marketing meeting - maintained strong lines of communication with teammates Built outstanding business relationships with all cooperated companies - high partnership re-signs with more values Utilized online social media or in conventional ways to obtain feedbacks of pass marketing events.
04/2012 to 06/2013
Underwriting AssistantBliss & Glennon, Inc － Redondo Beach, CA
Assisted with building of policies, promotional materials, and quotations by working closely with broker agencies Evaluated and assessed risks using STATA and RMS Risk Browser to analyze quotations thus determining binder issuing Policy creation via AppX and organized over 150 active clients tracking all records, tasks, paperwork, etc.
with ITC (CRM) Handled policy submissions and coordinated between accounting and underwriters; and provided client supports Prospected new clients through market research, cold calls, and emails; delivered monthly progress/growth reports Maintained outstanding broker relationships with prompt/courteous responses to all requests.
08/2006 to 08/2008
Sales Associate/Beauty AdvisorThe Body Shop － Torrance, CA
Helped an average of 50 customers per day by responding to inquiries and providing information about skincare products Monitored, ordered and replenished the inventory level of all store merchandise Created/maintained relationships and loyalty with customers through personal interaction, designed and updated clients' file Performed in-store makeovers, skin care consultations and make up sessions Recommended better merchandise display to management, which was implemented and resulted in 35% improved sales Handled cash registers, organizing inventory room, labeling products, unloading merchandise, and cleaning up Aided Mandarin-speaking customers, increasing repeat and loyal customers by 30%.
Bachelors of Science: Management ScienceUniversity of California － San DiegoManagement Science
Bilingual in English and Mandarin/Cantonese
accounting, binder, business intelligence, Cantonese, cash registers, Color, Excellent communication, interpersonal skills, Costing, CRM, client, clients, data analysis, data warehouse, English, fast, functional, information technology, inventory, Legal, Mandarin, Market Analysis, market research, marketing, Merchandising, Access, MS Excel, PowerPoint, MicroStrategy, organizing, Pivot Table, policies, presenting, presentations, pricing, progress, promotional materials, speaking, reporting, research, RMS, Sales, skin care, spreadsheet, SQL, STATA, supervision, Teaching, team player