Camila Schmith's Work | ContraWork by Camila SchmithCamila Schmith
Automation Engineer | Data, Excel & Technical Solutions
Built an automated data-processing workflow to combine multiple monthly CSV files, clean and standardise inconsistent data, remove duplicates, flag exceptions and generate a structured Excel report with KPIs and visual summaries. The project demonstrates how repetitive manual data tasks can be converted into a reliable and repeatable process. Transformed unstructured technical notes into a clear, professionally formatted operating procedure. I organised the content into controlled sections covering safety, prerequisites, start-up steps, alarms, troubleshooting and shutdown, while adding document control, revision history, structured tables and consistent formatting. Cleaned and transformed a messy sales dataset into a structured Excel workbook, removing duplicates, standardising data and identifying missing values. I then created key business KPIs and visual reports, resulting in a clean, analysis-ready dashboard. Created a structured supplier research project to demonstrate how scattered information can be transformed into clear, decision-ready data. I defined research criteria, organised supplier profiles, categorised capabilities and locations, assessed suitability and produced a concise comparison dashboard and shortlist.