Joel Medina

Professional Portfolio

Professional Summary

Data-focused IT/OT Solutions Architect and Software Developer with 12+ years of experience transforming operational and business data into actionable insights. Expert in designing and implementing analytics-enabled solutions, predictive models, and custom reporting tools that optimize processes and support data-driven decision-making. Proven track record of bridging business requirements with technical solutions to drive measurable improvements in efficiency, reliability, and cost savings across Oil & Gas and process manufacturing environments. Experienced in designing and deploying AI/ML-enabled solutions, custom MES systems, and real-time analytics pipelines integrating edge-to-cloud technologies like REST APIs, MQTT, Ignition and historian systems. Proven ability to lead teams and align technical strategy with business value to drive measurable improvements in uptime, operational efficiency, and cost reduction

Education

California State University Bakersfield - B.S. Computer Science (2013)
Focus: Machine Learning

Core Competencies

  • Advanced SQL Development & Data Engineering: Complex SQL queries, ETL processes, data modeling, REST APIs, MQTT, and Enterprise Data Warehousing
  • Data Visualization & Reporting: Power BI, Tableau, SSRS, custom dashboards
  • Cloud & Distributed Computing: Azure, AWS, GCP, Kubernetes deployment
  • IT/OT Converged Architecture: SCADA, OPC UA, MQTT, Unified Namespace
  • Lean Six Sigma & Process Optimization: DMAIC methodology, root cause analysis
  • Business Intelligence & KPI Reporting: Executive dashboards, operational metrics
  • Predictive Analytics & Machine Learning: Python models, anomaly detection
  • MES Architecture & Integration: Custom systems, historian platforms, Manufacturing Intelligence
  • Full-Stack Software Development: C# .NET, Python, JavaScript, Blazor

Selected Projects & Achievements

  • Machine Learning for Asset Optimization: Developed predictive models in Python for steam generator optimization and beam pump failure prediction, increasing uptime and reducing costs.
  • Custom MES Development: Designed and implemented KPI dashboards, downtime tracking, and OEE reporting frameworks; delivered cross-functional visibility and reduced manual reporting effort by 70%.
  • IoT Data Architecture: Built Azure IoT Hub + MQTT pipelines for edge devices, integrating historian data (PI, Canary, Ignition) for real-time analytics and anomaly detection.
  • Data Warehouse Modernization: Led migration from legacy OSI PI historian to Canary Historian, improving reporting flexibility and cost efficiency; integrated with Snowflake for enterprise analytics.
  • Digital Transformation Leadership: Directed multi-year migration of operational data platforms, aligning IT/OT data under a Unified Namespace (ISA-95) and enabling scalable enterprise analytics.
  • Cybersecurity & Compliance: Strengthened OT cybersecurity posture by enforcing segmentation, TLS-based communication, and vendor compliance to reduce vulnerabilities.

Technical Proficiencies

  • Programming & Data: SQL, Python, C#, R (working knowledge), ETL Development, REST APIs
  • BI & Visualization: Power BI, Tableau, SSRS, Historian Dashboards (PI Vision, Canary)
  • Data Engineering & Warehousing: Snowflake, SQL Server, PostgreSQL, InfluxDB, Kafka, MQTT
  • Cloud & Edge: Azure, AWS, GCP, Kubernetes, Azure Functions, Edge Containerization
  • Operational Technology: MES (Custom, Ignition, AVEVA), PI Asset Framework, Canary, Unified Namespace (ISA-95), SCADA/OPC UA integration
  • Machine Learning & Analytics: Predictive/Prescriptive Analytics, Regression, Decision Trees, Random Forests, Anomaly Detection
  • Methodologies: Lean Six Sigma, DMAIC, PDCA, ITIL, Agile/Scrum, DevOps & CI/CD