• Conduct cost-benefit analyses using Excel, leveraging VLOOKUP and XLOOKUP functions to evaluate the financial impact of proposed changes to products and processes. Provide data-driven insights to support strategic decision-making and optimize resource allocation.• Create PivotTable quoting dashboard filtering by product line and material type, enabling the sales team to automatically check quotes against contractual requirements. • Collaborate with cross-functional teams to identify cost-saving opportunities, implement process improvements, and develop detailed project plans, including timeline and budget. ● Communicate project status, risks, and issues to senior management, ensuring timely delivery of projects and alignment with business objectives. • Implemented process improvements, in partnership with QC team, to address quality issues and improve on-time delivery.

• Utilized QuickBooks by preparing and distributing invoices, processing payments, and following up on outstanding accounts receivable. • Handled orders, ensuring accurate and timely processing, and collaborating with sales, QC, and logistics to fulfill client requests. • Validated the reconciled data to ensure that the discrepancies have been appropriately resolved and data aligns across the different systems.• Investigated data entry errors, and data transformation problems to identify discrepancies and determine the cause and correct errors, updating data to ensure the datasets are aligned. • Reviewed financial data to identify and resolve discrepancies in invoices, payments, and accounting data. Communicated effectively with finance and operations to address issues.

• Identified, designed, and implemented internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability, using Excel.• Acted as a liaison between the Chinese auto parts vendors and the sales department for quote analysis and market search analysis.