00 / Lucas Rosate — Engineering portfolio
Evidence → Analysis → Action → Verification
Quality, process and materials guide the investigation. Data and digital systems expand its reach. These projects document my contribution, the technical decisions and the operational results.
Selected projects
Four case studies document the problem, implementation and available evidence.
Case 01 / Customer complaints
I coordinated the redesign with the participating teams: we mapped bottlenecks, structured inputs and monitored adoption of the 8D standard.
Disconnected channels and control points
Case 02 / Traceability automation
I automated extraction and integration of supply, material and order-book data. The routine enabled on-demand updates across shifts.
Supply and raw material sources
Repeatable extraction
Split · arrays · processing rules
Connection to the order book and supply context
On-demand updates · different shifts
Select a stage to explore its role in the flow.
← Scroll horizontally to explore the diagram →
Case 03 / Operational intelligence
I modelled quality, production, maintenance, delivery and material data in Qlik Sense, reducing repeated consolidation and retaining history for analysis.
Quality · production · maintenance · delivery · materials
Python · VBA · SQL — extraction and integration
Mapping · joins · concatenation · filters · history
Controlled keys · relationships across 80+ tables
Dimensions · measures · decisions in context
Select a stage to explore its role in the flow.
← Scroll horizontally to explore the diagram →
Case 04 / Audits and actions
I developed SISVE with Power Apps, SharePoint and automations to connect audits, actions and effectiveness assessment. Qlik Sense brings process analysis together.
Power Apps — structured execution
SharePoint — evidence and history
Traceable corrective action starts
Planner — owners and due dates
Power Automate — notifications and integration
Effectiveness and recurrence after action
Qlik Sense — analysis across 16 processes
↺ Effectiveness and recurrence history informs subsequent audit analysis.
Select a stage to explore its role in the flow.
← Scroll horizontally to explore the diagram →
Technical depth
Applications of statistical analysis, Core Tools and nonconformity investigation.
Quality Engineering / SPC
Signal: apparently acceptable capability. Evidence to examine: changes in variation over time. Decision: establish process stability before interpreting capability.
I first verify whether variation remains under control over time.
Product / process
Documented work includes experimental tests, specifications and process follow-up. APQP and PPAP participation covered specific stages, rather than ownership of the complete frameworks.
Technical requirement → test → comparison with the criterion → decision
Investigation / decision
An occurrence requires containment; recurrence requires investigating the mechanism. Methods, owners and tests need to connect to the hypothesis being assessed.
Occurrence → hypothesis → test → action assessment
Customer Quality / decision
Response time tracks the flow of complaint handling. Effectiveness assessment examines the outcome of the action. The customer complaint case keeps these two interpretations separate.
Response → action → effectiveness → recurrence
Oracle SQL / IBM Cognos
Custom views, historical queries and reports were structured while respecting the performance, access and stability constraints of the existing infrastructure.
Source and history
Adjusted view
Analysis and access
Select a stage to explore its role in the flow.
← Scroll horizontally to explore the diagram →
Technical toolkit
Select a method or tool to inspect its application context.
Requirements, prevention, investigation and effectiveness assessment.
Methods for reading flow, prioritising causes and sustaining change.
Modelling, integration and visualisation for interpreting operations.
Process-adjacent solutions that reduce manual effort and improve traceability.
Technical exploration; not presented as consolidated professional experience.
Keep in touch
View my career on LinkedIn, explore projects on GitHub or contact me by email.