t
tsarakor

Tsarakor

@tsarakor

Operations Data and Excel Systems Specialist

Canada
Engels, Thais
Sommige informatie wordt in het Engels weergegeven.
Over mij
Hi! I help structuring Excel/ CSV/ Google Sheets to be reliable tools that support daily business operations. My experience includes building Excel solutions for costing calculations, invoice tracking, order management, and financial reporting. Whether you need a quick cleanup, formula fixes, or a fully automated workflow, I can make your data accurate, organized, and easier to manage. My services include: • Excel data cleaning & organization • Spreadsheet formatting & restructuring • Formula creation & troubleshooting • Data summaries, pivot tables & reporting • Excel VBA automation & macros... Lees meer

Skills

t
tsarakor
Tsarakor
offline • 
Gemiddelde reactietijd: 3 uur

Bekijk mijn diensten

Gegevens opschonen
I will clean, format, organize and remove duplicates from your excel or CSV data
Formules en macro's
I will fix excel formulas, calculations, and spreadsheet errors

Portfolio

Werkervaring

Production Manager Assistant

T • Fulltime

May 2019 - Present7 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 • Fulltime

Apr 2010 - Sep 20166 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.