Michael Ocana

Technical Lead & Drupal Specialist

The Fisheries Improved for Sustainable Harvest (FISH) Project

Position
MIS Specialist / Database Programmer
Start Date
01, Aug 2004 - 30, Aug 2005

Manage the Management Information System (MIS) to support sustainable fisheries management, focusing on the development of robust database solutions and automated reporting tools for monitoring and evaluation.

Key Responsibilities

  • Database Architecture: Design and maintain relational databases to track fishery loads, biological indicators, and project benchmarks across multiple sites.
  • Windows Application Development: Create custom desktop solutions using Windows Programming to streamline data collection and field-office synchronization.
  • VBA & Office Automation: Develop sophisticated VBA modules to transform raw field data into automated analytical reports, charts, and dashboards within Microsoft Excel/Access.
  • Web-Based Reporting: Build and optimize PHP backend scripts to facilitate secure, web-based access to MIS data for regional stakeholders and project leads.
  • Data Integrity & Quality: Implement strict validation protocols and cleanup scripts to ensure the accuracy of large-scale environmental and socio-economic datasets.
  • System Training: Provide technical documentation and hands-on training for field researchers and local partners on MIS software and data entry standards.
Tools
Windows Programming
VBA
PHP

© 2026 michaelocana.com