Michael Ocana

Technical Lead & Drupal Specialist

Coastal Resource Management Project

Position
Database Programmer
Start Date
01, Jan 2001 - 30, Jul 2004

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.
Tools
Windows Programming
VBA
PHP

© 2026 michaelocana.com