Miguel Castillo Perez
Data Analyst · Service & Contract AnalyticsTechnical Service Supervisor, Iberia · Johnson & Johnson Vision
Professional Summary
Data analyst working on service and contract analytics, with nine years of medtech operations behind the questions I put to the data. I build the whole path from source system to decision: Alteryx pipelines that reconcile three enterprise systems into a single record per asset, Tableau dashboards covering EMEA cost per system, install base and average sales price, and Salesforce reporting for service KPIs — PM completion, calls per system, callback rate and work-order completion.
The output feeds decisions rather than only reporting them: the ASP analysis is used to reprice maintenance contracts by platform, customer and contract type, and the install base dashboard doubles as the data-quality instrument across 1,000+ assets in 50+ countries. Currently Supervisor of Technical Service for Iberia at Johnson & Johnson Vision.
Professional Experience
- Built the Alteryx ETL and the automated Tableau dashboards behind EMEA cost per system, install base and average sales price, aggregated by cluster, country, platform, customer and contract type.
- Consolidated three enterprise systems into a single reconciled record per asset covering 1,000+ assets across 50+ countries; the same view surfaces incomplete or conflicting equipment records.
- Built Salesforce reports and dashboards for service KPIs: PM completion, calls per system, callback rate and work-order completion.
- ASP analysis is used to reprice maintenance contracts by platform, customer and contract type; a separate contract-expiry dashboard feeds the sales team.
- Built a business-plan tool that replaced each supervisor’s own spreadsheet with one standardised process, with risk, opportunity and scenario modelling.
- Lead the Technical Service team for Iberia against quality standards and operational KPIs.
- Built the first shared service reporting, moving recurring analysis off individual spreadsheets into Tableau dashboards.
- Coordinated daily technical operations, managing field service schedules and resource allocation.
- Primary escalation point for complex technical issues, ensuring rapid resolution.
- Supported new product launches through technical training and service-readiness planning.
- Built internal applications with Power Apps and Excel to support day-to-day service work.
- Installation, maintenance and repair of advanced ophthalmic surgical systems.
- Delivered technical training to hospital staff and clinical engineers.
Technical Skills
Education
Técnico Especialista en Electrónica Industrial — vocational qualification in industrial electronics, Spain.