Jose Rocha
PDF and invoice data extraction into Excel
Habilidades
Revisa mis servicios


Porfolio
Experiencia laboral
IT Trainee
OPTIMIZER • Tiempo completo
Mar 2026 - Jul 2026 • 4 mos
Built document automation tooling for an IT consultancy's project management practice - the machinery that turns structured data into finished documents. What I did: - Wrote generation pipelines producing Word, Excel and PowerPoint files from raw project data, working at the OOXML level when templates would not cooperate: table cell properties, section breaks, image relationships, character escaping. - Built an Excel generator that emits live formulas rather than pre-computed values, so the output stays a working spreadsheet instead of a static report. - Mapped and documented 19 end-to-end business processes, then turned the repeatable ones into tools usable by staff with no technical background. - Enforced one hard rule across every tool: never generate a document from assumed data. If an input was missing, the tool asked instead of inventing. Why this matters for the work I offer here: Document extraction is the same problem in reverse. Building generators taught me exactly how documents fall apart - where tables break across pages, how merged cells and inconsistent headers happen in the first place, why a date column arrives as text in three different formats. That is the knowledge I use pulling data back out of PDFs, scans and invoices. It also taught me where automated output goes wrong quietly, which is the expensive kind. That is why every delivery comes with a note listing what I could not read with confidence, instead of plausible guesses filling the gaps.