
Tsarakor
Operations Data and Excel Systems Specialist
Skills

See my services


Portfolio
Work experience
Production Manager Assistant
T • Full-time
May 2019 - Present • 7 yrs
• Built and maintained Excel spreadsheets used across operations for costing calculations, invoice tracking, order management, shipping and receiving logistics, payroll records, and financial monitoring within a Large-Scale wholesale bakery business. • Designed structured spreadsheets to support daily operational workflows including production costing, order tracking, and inventory-related logistics coordination. • Assisted the operations manager by developing customized Excel tools that improved data tracking, reporting accuracy, and operational efficiency. • Cleaned and organized operational datasets by removing duplicates, correcting inconsistencies, and standardizing data formats to ensure reliable reporting. • Developed formulas such as SUM, IF, VLOOKUP, INDEX MATCH, and COUNTIF to automate calculations and reduce manual work. • Generated operational and financial reports using pivot tables, summary tables, and structured datasets for management review. • Implemented data validation, conditional formatting, and structured tables to improve spreadsheet usability and reduce input errors. • Built Excel tools used alongside Sage 50 accounting software to support accounts payable, receivable tracking, and financial monitoring. • Developed automated spreadsheet workflows using Excel VBA macros to streamline repetitive tasks and improve operational efficiency. • Organized and structured business data to support reporting, operational visibility, and decision-making.
SURFACE MOUNTING TECHNOLOGY - Process Engineer
Fujikura Electronics Thailand • Full-time
Apr 2010 - Sep 2016 • 6 yrs 5 mos
• Developed and optimized Surface Mount Technology (SMT) processes for flexible printed circuits (FPC) used in electronic devices assemblies. • Supported new product introduction (NPI) by establishing process parameters, equipment settings, and production workflows for new circuit designs. • Conducted process validation and trial runs to ensure stable mass production and compliance with product specifications. • Monitored and improved SMT line performance including solder paste printing, component placement, and reflow soldering processes. • Investigated and resolved production defects such as solder bridging, tombstoning, misalignment, insufficient solder, and component placement errors. • Performed root cause analysis using quality tools such as 5 Whys, Fishbone Diagram, and Pareto analysis to identify and eliminate recurring issues. • Collaborated with quality assurance, production, and maintenance teams to improve yield, reliability, and overall manufacturing efficiency. • Optimized reflow oven temperature profiles and process parameters to ensure proper solder joint formation and component integrity. • Supported continuous improvement initiatives to reduce defects, improve line efficiency, and lower manufacturing costs. • Implemented and maintained process documentation, including work instructions, standard operating procedures (SOPs), and process flow charts. • Conducted process capability studies (Cp, Cpk) and monitored key process indicators to maintain stable production. • Assisted in equipment setup, qualification, and troubleshooting for SMT production lines. • Coordinated with design engineering teams to provide feedback on manufacturability and product design improvements. • Provided technical support and training to production operators and technicians to ensure correct process execution. • Participated in customer audits and internal quality audits to ensure compliance with manufacturing and quality standards.