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.

Responsible for the stability, security, and optimization of the institution's server infrastructure and web-based systems, managing a Linux-centric environment to support international academic operations.

Key Responsibilities

• Server Management: Administer and maintain Linux-based servers, ensuring high availability, routine backups, and robust security protocols for educational databases and applications.
• System Development: Develop and refine internal tools and automation scripts using Perl/CGI and PHP to streamline administrative workflows and student data management.
• Web Administration: Oversee the frontend and backend health of institutional web portals, utilizing HTML and JavaScript to enhance user interface functionality and client-side performance.
• Network Security: Monitor system logs and implement firewall configurations to protect sensitive academic records and ensure compliance with data privacy standards.
• Technical Support & Integration: Troubleshoot complex system-level issues and integrate open-source software solutions to meet the evolving digital needs of the faculty and staff.
• Process Automation: Write and maintain server-side scripts to automate repetitive tasks, improving overall operational efficiency and reducing system downtime.

Technical lead responsible for the architecture, development, and maintenance of high-performance web applications, utilizing a diverse full-stack environment to deliver scalable business solutions.

Key Responsibilities

• Full-Stack Engineering: Lead the development of robust applications using PHP and Perl/CGI for backend logic, integrated with dynamic HTML and JavaScript frontends.
• Architectural Leadership: Design and optimize system architectures, ensuring seamless integration between legacy Perl environments and modern PHP frameworks.
• Technical Mentorship: Oversee code reviews and provide technical guidance to junior developers to ensure high-quality, maintainable code across the stack.
• Performance Optimization: Debug and refine complex scripts and database queries to improve server-side response times and client-side interactivity.
• System Integration: Manage the lifecycle of web-based tools, from initial requirements gathering and UI/UX implementation to deployment and server-side configuration.
• Agile Delivery: Collaborate with cross-functional teams to translate business requirements into technical specifications within an Agile environment.

Responsible for managing geospatial databases and performing advanced spatial analysis to support sustainable development and urban planning initiatives across the Visayas.

Key Responsibilities

• Spatial Analysis & Modeling: Execute complex overlay and proximity analyses to identify trends in land use, environmental hazards, and socio-economic data.
• Data Management: Maintain high-integrity GIS databases, ensuring accurate metadata and seamless integration of GPS field data and satellite imagery.
• Cartographic Design: Produce professional thematic maps and interactive web dashboards for stakeholders, government partners, and community presentations.
• Remote Sensing: Process and interpret aerial and drone-captured imagery for environmental monitoring and site assessments.
• Technical Collaboration: Provide GIS expertise for project design, supporting the development of Comprehensive Land Use Plans (CLUP) and environmental grant proposals.