Michael Ocana

Lead the organization’s information technology strategy and software development, overseeing the infrastructure and creating custom database solutions to support international certification standards for marine life.

Key Responsibilities

• System Development: Architect and develop custom desktop applications using Windows Programming to manage certification workflows and traceability data.
• Database Administration: Design and optimize complex relational databases using SQL, MySQL, and VBA to ensure secure, high-speed access to global supply chain records.
• Web Engineering: Develop and maintain internal and external web portals using PHP, integrating backend databases with user-friendly interfaces for international stakeholders.
• IT Infrastructure Management: Oversee the organization’s network, hardware, and security protocols, ensuring 99.9% uptime for critical certification tracking systems.
• Process Automation: Create advanced VBA macros and scripts to automate cross-platform data synchronization between office productivity tools and core SQL databases.
• Strategic Leadership: Align IT initiatives with organizational goals, managing technology budgets and providing technical direction for data-driven marine conservation projects.

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.

Responsible for the design, development, and management of specialized relational databases to track and analyze marine and coastal resource data, supporting environmental conservation initiatives.

Key Responsibilities

• Application Development: Design and implement custom Windows-based applications and desktop tools to facilitate efficient biological and socio-economic data entry and retrieval.
• VBA Automation: Develop advanced VBA macros and scripts within Microsoft Excel and Access to automate complex data processing, reporting, and statistical summaries.
• Web Integration: Build and maintain PHP-driven web interfaces to allow project stakeholders to access and visualize database records remotely.
• Database Optimization: Ensure data integrity and performance through regular maintenance, indexing, and the creation of structured queries for large environmental datasets.
• Reporting Tools: Generate automated, high-accuracy technical reports and data visualizations to support policy-making and coastal management strategies.
• Technical Support: Provide troubleshooting and training for project staff on database usage and customized software tools.