Tzu Ting Yu

Tzu Ting Yu

Sales Operation Analyst
United States of America

نبذة عني

Sales Operation Analyst with experience in data analysis, business analysis, data visualization, data modeling, data cleaning and preparation, machine learning, NLP, data mining, inventory management, customer relationsh…

الخبرة

Sales Operation Analyst

Best Babie Distribution, Irvine, CA
Nov 2023 - حتى الآن · 2 سنوات 8 أشهر

Utilized APIs (Target Plus API) and Python scripting to dynamically gather real-time data on baby product details from prominent retailers like Target, facilitating informed decision-making in inventory management and identifying popular products for potential growth opportunities.
Implemented weekly sales analysis with Excel Pivot Table from 5 warehouse locations across the United States, facilitating the analysis of sales performance and profit margins across a variety of brands and 1000+ products, including Mattel, Fisher-Price, and Graco.
Automated inventory outbound systems using XLOOKUP, VLOOKUP and conditional formatting, seamlessly integrating with Microsoft Power Automate to enhance operational efficiency by 85%.
Coordinated effective communication with sales specialists and conducted thorough analysis of 2000+ customer websites to understand preferences and needs, offering recommendations for baby products to drive customer satisfaction and increase sales performance.

Sales operation analyst

Best Babie Distribution
Nov 2023 - حتى الآن · 2 سنوات 8 أشهر

• Utilized APIs (Target Plus API) and Python scripting to dynamically gather real-time data on baby product details from prominent retailers like Target, facilitating informed decision-making in inventory management and identifying popular products for potential growth opportunities.
• Implemented weekly sales analysis with Excel Pivot Table from 5 warehouse locations across the United States, facilitating the analysis of sales performance and profit margins across a variety of brands and 1000+ products, including Mattel, Fisher-Price, and Graco.
• Automated inventory outbound systems using XLOOKUP, VLOOKUP and conditional formatting, seamlessly integrating with Microsoft Power Automate to enhance operational efficiency by 85%.
• Coordinated effective communication with sales specialists and conducted thorough analysis of 2000+ customer websites to understand preferences and needs, offering recommendations for baby products to drive customer satisfaction and increase sales performance.

Data Analyst

Obagi Medical, Long Beach, CA
Jan 2023 - Jun 2023 · 5 أشهر

Conducted market basket analysis, customer behavior analysis, and modeling using Python to support skin care products development, resulting in a 25% upswing in skin care products sales.
Automated SQL data pipelines to preprocess and transform customer data, achieving a 42% reduction in processing time and an 18% increase in accuracy.
Developed impactful Tableau dashboards revealing annual sales trends, top sellers, and geographic insights, leading strategic decision-making for stakeholders to instigate actionable changes to product combinations and business strategies.

Data Engineer/Analyst

Asgard System, Inc, Taipei, Taiwan
Feb 2020 - Jul 2022 · 2 سنوات 5 أشهر

Developed visualizations and reports using Tableau and Excel that were used by clients from different industries to make data-driven decisions, resulting in a 18% increase in operational efficiency.
Optimized and automated data cleansing, extraction, and analysis processes using SQL, resulting in a 25% reduction in data errors and inconsistencies.
Pioneered Machine Learning like Multiple linear regression and RPA, boosting talent acquisition efficiency by 23% in employee sourcing during the pandemic through external data extracting, cross-referencing, talent acquisition, and predictive modeling.
Collaborated with diverse industries to identify process optimization through consultative methodologies and RPA integration, delivering efficiency improvements ranging from 22% to 30% across diverse sectors.

Software Engineer

BNP PARIBAS CARDIF Assurance Vie, Taiwan Branch, Taipei, Taiwan
Jun 2019 - Dec 2019 · 6 أشهر

Analyzed users' ad-hoc data requests and developed GraphTalk scripts to extract specific clients’ data, facilitating the process of data verification.
Modified production-level code, such as transforming routine ad-hoc requests into system-integrated functionalities to ensure accurate data extraction, resulting in a significant 66% efficiency improvement for users retrieving data.

المهارات

إكسل بايثون (لغة برمجة) صيانة نظام إدارة علاقات العملاء واجهات برمجة التطبيقات SQL SAS Java Graphtalk Microsoft Excel Tableau PowerBI SAP Google Analytics Automation Anywhere Power Automate Adobe software Data analysis Business analysis Data visualization Data modeling Data cleaning and preparation Machine learning NLP Data mining Inventory Management Customer Relationship Management Supply Chain Management Critical thinking Presentation skills Communication skills Microsoft SQL XLOOKUP VLOOKUP Conditional formatting Pivot Table Market basket analysis Customer behavior analysis SQL data pipelines Data preprocessing Data transformation Dashboards Data cleansing Data extraction RPA Multiple linear regression Predictive modeling Consultative methodologies
الإبلاغ عن هذا الملف الشخصي؟