Eugene Tsai Email & Phone Number

Chicago, Illinois, US

• Analyzed a daily influx of over 50 error reports sourced form healthcare, government, and insurance datasets via Excel along with CUBS software and Epic system to identify improvement areas.
• Facilitated access to systems and fostered cross-functional collaboration to optimize ETL processes for reliability and efficiency.
• Developed and maintained process SOPs, ensuring alignment with company standards and client needs while establishing robust data standards and methodologies.
• Reviewed account reconciliations to mitigate data discrepancies and ensure uniformity across various data sources.
• Posted payments, adjustments and reversed chargebacks to maintain data consistency and accuracy across clients’ and company systems.
• Assessed financial statements to ensure accurate representation of payment transactions and resolve inconsistencies, maintaining integrity in financial reporting.

56 Rue Charles Martel, LU

• Developed an advanced resource allocation model for over 3M cans utilizing Python.
• Optimized capacity/demand utilization across 8 manufacturing plants, managing a total of over 20M cans, using Excel and Python.
• Collaborated across functions to automate business processes and optimize ETL performance.
• Presented interactive dashboards featuring route maps, bubble charts, histograms, and line with clustered column charts to over 30 senior executives in-person via PowerBI.
• Conducted CPG (Consumer Packaged Goods) analysis utilizing Nielsen, APO, LRP, Sales and Forecast datasets, employing Python, Excel, and PowerBI.

Sparks Glencoe, Maryland, US

• Improved SLA (Service-Level Agreement) adherence by 10% through analysis over 100,000 supplier transactions via SAP and Excel.
• Achieved a cost reduction of $1.1M in purchasing expenditure through negotiation and execution of rebate contracts with suppliers.
• Streamlined operations by reducing lead times by 5-10 days and extending payment terms by 5-10 days through strategic engagement with suppliers for signing MSA (Master Supplier Agreement).
• Generated purchase orders by analyzing inventory needs and conducting audits to support operational efficiency.
• Conducted demand forecasting and supply planning by leveraging historical data and market trends to refine supply chain strategies.
• Optimized performance reporting metrics through the development of interactive data visualizations using Python and PowerBI, leveraging MPS, MRP, and BOM datasets.

• Achieved a 10% reduction in unnecessary costs by cleaning, sorting, and visualizing over 4,000 data points pertaining to donated goods utilizing Excel.
• Elevated recipient satisfaction rate by 30% through the implementation of an inventory management system on Google Sheets, ensuring adherence to FIFO (First In, First Out) principles and safeguarding against the.
• Created insightful data dashboards on KPIs (Key Performance Indicators) and metrics on time to inform executives and improve operations.

Dalian, Liaoning, CN

• Conducted product research paper, compiled data, implemented ideas, created manual to a new product, Cassava.
• Provided audience demographic/personas, competitor analysis, industry analysis, and marketing share research to all investors.

Master'S Degree, Business Analytics

Bachelor Of Arts, Political Economy