Badges
Certifications
sophie_x_sun has not earned any certificates yet.
Work Experience
Finance Data ETL
Jukin Media•  September 2019 - Present
• Loaded data safely and systematically into QuickBooks from a variety of sources after data transformation • Transformed data by analyzing, filtering, aggregating, relabeling and mapping financial data • Built templates and reports for financial data documentation such as invoices, exchange rate charts
Inventory Allocation Analyst
Guess Inc.•  May 2019 - August 2019
• Allocated fashion or basic items to retails stores in North America with JDA Allocation system • Ran ad-hoc analysis to inform buy plans and assortment strategies
Product Developer
Travel Plus International•  June 2014 - May 2019
• Built profit margin models by loading in project-specific cost factors such as tariff duty, commission rate, royalty, warehousing and shipping cost, transaction cost, operation cost, packaging cost and FOB product cost • Created logistics plans by consolidating hundreds of orders over 300+ styles per season and directing the flow of goods via hundreds of ocean containers to their destinations during designated shipping windows • Developed products throughout lifecycles from conceptualizing, prototyping, costing, item ID setting, UPC barcode generating, packaging, testing, trouble shooting, to production, shipping, importing and warehousing
Education
University of California (UCLA), Los Angeles
Applied Statistics, MS•  September 2019 - Present
Computational, statistical, mathematical perspectives and training on data analysis, with a focus on the use of R, Python and SQL. My favorite class is Experimental Design, which provides frameworks, methodologies, principles on designing and conducting experiments effectively to find out Main Effects and interactions between factors.
University of Hawaii - Manoa
Merchandising, BS•  June 2006 - May 2009
Business operation education for the retail industry, including fashion forecasting, merchandising mathematics, consumer behavior, accounting 101, product development, apparel cut and sew, textile technology.
Links
Skills
sophie_x_sun has not updated skills details yet.