Yiran S.

Business Operation| Supply Chain | Project Management| Buyer| Data Analysis| Customer Service

Sunnyvale, California, United States

About

I am respected as a customer-focused, results-driven bilingual Business Operation/Supply Chain Systems Analyst showcasing outstanding success in providing comprehensive operational, analytical, and forecasting support in fast-paced, remote environments. I offer a proven track record of designing, building, and maintaining dashboards and tools to drive outstanding business results. I am also an out-of-the-box, analytical thinker with a passion for executing against objectives/strategy while delivering analytics solutions to complex business challenges. Additionally, I possess exceptional academic qualifications, including a Master of Science in Accounting from Long Island University. In my free time at graduate school, I was an active member of my community, serving as a Volunteer Income Tax Assistance Volunteer for the Internal Revenue Service. Key area of expertise: B2B in Food&Beverage Industry Budgeting/Forecasting Project Management Operational Analysis Forecast/Statistical Models Demand Planning Data Maintenance Data visualization and analytics Research/Analytics Inventory Strategies Customer Action Planning Customer/Client Service Policy/Procedure Adherence Collaborative Planning Business Intelligence Purchasing On-time and In-full Service, ORAD control Skills: Microsoft Office (Word, Excel, PowerPoint) Microsoft SQL Server Data Visualization Tool: Tableau SaaS S2P(Source to Pay): PRGX, Lavante product SPS Commerce.com Database Linux A few of my selected accomplishments are: Demonstrated track record of boosting the project’s gross income 30% in 2020 while overseeing the Kroger Company’s (NYSE: KR) $5M+ portfolio. Commended by executive leadership for managing $1M+ in inventory and driving on-time order delivery while establishing numerous new business opportunities with West Coast suppliers in collaboration with logistics teams in NJ, CA, WA, and IL. Analyzed areas for improvement and investigated/evaluated 500+ accounts and bank activities potentially exposing the company to financial loss. Chosen by upper management to aid key clients in processing international and domestic wire requests worth $5M+ online weekly. Outstanding success providing top-level customer service by properly calculating owed taxes and preparing 1040 and 1065 tax returns for 100 clients during tax season. Looking for the new opportunities in North America, Europe and Asia. I look forward to meeting you!

Experience

  • Colgate-Palmolive (Full-time · 3 yrs 3 mos)
    • Integrated Marketing Coordinator
      Apr 2023 - Present · 3 yrs 3 mos

    • Media Budget Coordinator
      Apr 2023 - May 2023 · 2 mos

  • Account Manager at Food Import Industry
    Feb 2017 - Apr 2023 · 6 yrs 3 mos

    Manage 20+ accounts from Kroger Company’s (NYSE:KR) $5M+ portfolio, increasing the project’s gross income 30% of 6 distribution centers. Collect, analyze, visualize and evaluate complex data to identify key patterns and operational performance trends to develop business insights in support of increasing 20% productivities and planning. Prepare bid reports and contract documents; Purchase orders from 10+ vendors to meet client’s needs, work with category buyers in assessing supplier performance to maximize purchasing efficiency and cost-effectiveness, count the inventory regularly. Invoices reconciliation; Calculate cost on raw materials and transportation to generate budget reports; Support AP to make payments and file claims through Lavante system; Assist finance department in auditing and budgeting control; Lead cross-functional team to resolve issues and optimize customer service. Spearhead innovative new product pricing initiatives and launch 200+ overseas products, including Unilever, Lipton, Lotte, and other global brands, to the market, leading to a significant boost in revenues.

  • Operations Analyst at E*TRADE from Morgan Stanley
    May 2016 - Nov 2016 · 7 mos

    Supported the stock and bonds market teams with forecasting models. Monitored trade and money transaction alerts in Fraud Detection software in case of money laundering. Verified client personal information by client identification system in case of fraud. Identified risk factors and trends of potentially fraudulent activity utilizing technical data analysis and statistical interpretation. Assisted clients in processing international and domestic wire requests( over five millions) online weekly.

  • Tax Intern at Medows CPA, PLLC
    Mar 2016 - May 2016 · 3 mos

    Computed taxes owed, and prepare both 1040 and 1065 tax returns for over 100 clients in tax season Worked with individual and partnership client to analyze tax documents, interview every client to obtain additional information on taxable income to maximize tax deductions and tax credits Assisted in preparation of quarterly and annual financial statements for business owner clients and real-estate owners

  • Graduate Tutor at Long Island University
    Sep 2015 - May 2016 · 9 mos

    Taught students and helped them with their assignments of Mathematics, Accounting, Economics and English. Organized and managed students in the groups for their active participation in the group projects and assignments. Assisted with explaining concepts and provided information about different college courses