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.• Act as the primary liaison for payment-related inquiries from both clients and internal stakeholders, ensuring timely resolution and exceptional customer service.• Communicated comprehensive analysis to leadership, providing recommendations for optimizing data collection, analysis, management process to enhance data quality and system efficiency.

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 distribution of damaged goods.• 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