Ying Liu Email & Phone Number

Seattle, WA, US

Seattle, WA, US

Seattle, WA, US

Columbus, Indiana, US

• Responsible for P&L variance analysis, forecast and simulation activities for Corporate Supply Chain function groups through HFM, Essbase and OBIEE; Directly partnering with function directors and Supply Chain PFR team.
• Prepare Prepaid, GRNI and CIP Journal Entry and Account Reconciliation on monthly basis. Initiate new process to improve timeliness and accuracy on cross charge JE submissions for all impacted sites
• Strategically support supply chain inventory trend analysis and valuation
• Establish and manage capital reporting and forecasting process for Supply Chain function groups
• Create Power BI dashboard to visualize MDC warehouse back orders and past dues for all product line. Effectively helped material planning process and improved supplier’s KPI

Columbus, Indiana, US

• Facilitated Memphis Distribution Center (above 1M sqft warehouse, monthly sales transaction value ~ $250M) external & internal SOX testing and achieved zero control deficiency in 2018 and 2019. Coordinated the Annual.
• Conducted control walkthrough on Revenue, Inventory, Fixed Asset, Direct and Indirect Expenditures, Close the Book, and Payroll. Developed control gap remediation plan as needed. Performed preliminary testing on.
• Analyzed aged drop shipments report from subledger system and investigated $3.3M aged dropships. Communicated the result with Material, Order Management and Finance to set up monthly monitoring process on the drop.
• Designed and rolled out PCJE scorecard across 8 global supply chain sites, effectively evaluating and controlling the root cause of the PCJE.
• Conducted Dallas Regional Distribution Center onsite testing on receiving, shipping, and cycle count process. Helped Dallas RDC detect the potential control risk in inventory cycle count process and warehouse security
• Participated Cummins Business Service (CBS) annual internal control testing with Internal Audit team as a guest auditor for two weeks.

Bloomington, Indiana, US

• Created the regional Asian alumni online communication group for alumni in Shenzhen, Hong Kong, and Chicago etc. Worked with IU Beijing and Shanghai Chapter to market local and international alumni events through.
• Collaborated with IU Arts & Humanities Council to market more than forty events of China Remixed Festival on IU campus

Columbus, Indiana, US

• Created the 2017 Annual Operation Plan (AOP) template for Memphis Distribution Center by collaborating with financial analysts and communicating with other functional departments for review in two months.Summer 2016
• Utilized Minitab and Excel regression and correlation tool to analyze the drivers of total logistics costs. The result showed the cost of packaging, scrap, and freight were the main drivers and could be reduced by.
• Reconciled the AR and AP accounts variance between Oracle subledger and general ledger. Communicated with IT to clear the variances on daily basis.

Benton Harbor, Michigan, US

• Analyzed historical order response time and demand forecast data from Whirlpool and its competitors. Concluded that improving demand accuracy and production efficiency could help reduce the overall operation process.
• Optimized the P&L forecast template by collaborating with the Tax, Commercial Finance and Accounting departments.
• Facilitated the department meetings in English and translated financial statements from Chinese to English for the team project

Bloomington, Indiana, US

Bloomington, Indiana, US

• Covered on-going events for Indiana Daily Student newspapers’ photo department and published photos
• Consulted with IDS staff 2 hours per week to edit photos by using Adobe Software
• Created PhotoshootNA.com with a team of six students and performed as accounting and marketing consultant to help U.S. college students locate photographers

Bloomington, Indiana, US

• Leveraged available resources to initiate weekly peer meetings of organizing outdoor events
• Performed reception duties and clerical work by using Excel and Outlook; Processed an average of 10 event reservations per hour
• Collaborated with three graduate students to support programs in community service, scholarship, internships and academics to increase the attendance of spring break leadership program by 10%

Bloomington, Indiana, US

• Helped 20 taxpayers file tax returns by using TaxWise software
• Navigated efficient communication with taxpayers both in English and Chinese with solid federal income tax knowledge.

Bloomington, Indiana, US

• Provided in-class assistance for more than 30 students, demonstrated direct help with professors and teaching assistants once a week to provide Excel and Access analysis to students.
• Established working relationships with other peer tutors and professor by encouraging attainable goals, and providing extensive feedback to improve and maintain individual effectiveness.

Master Of Business Administration - Mba, Accounting And Finance

Bachelor Of Business Administration - Bba, Accounting And Finance

Finance, General