Michael Ocana

Technical lead focused on developing and scaling healthcare-oriented web applications, leveraging the Ruby on Rails framework to build secure, high-availability systems within a Linux environment.

Key Responsibilities

• Application Engineering: Design and develop robust, scalable backend services using Ruby on Rails, ensuring high performance and responsiveness to frontend requests.
• Legacy System Support: Maintain and optimize existing Perl/CGI scripts, facilitating the integration or migration of legacy data into modern Rails architectures.
• Full-Stack Implementation: Create dynamic and interactive user interfaces using HTML, JavaScript, and jQuery, focused on improving the clinician and patient user experience.
• Database Management: Architect and manage MySQL databases, optimizing complex queries and ensuring data integrity for sensitive healthcare information.
• System Administration: Manage application deployment and server configuration within a Linux environment, ensuring system security and 99.9% uptime.
• Technical Leadership: Lead code reviews, mentor junior developers, and contribute to architectural decisions to maintain a high-quality, test-driven codebase.

Technical lead and consultant responsible for the digital infrastructure of the institution, specializing in the development and maintenance of custom educational platforms and student management systems.

Key Responsibilities

• System Architecture: Managed the development and scaling of the school’s web ecosystem, utilizing Drupal 6 to build custom modules and specialized content types for academic tracking.
• Full-Stack Development: Engineered backend functionality with PHP and MySQL, ensuring a secure and efficient environment for sensitive student and faculty data.
• Frontend Optimization: Enhanced the user interface and institutional portals using HTML, JavaScript, and jQuery to ensure a responsive and intuitive experience for educators and parents.
• Database Administration: Optimized MySQL database performance and integrity, facilitating rapid access to large-scale academic records and reporting tools.
• Strategic Consulting: Provided expert guidance on technical roadmaps, site security, and the integration of third-party educational APIs into the existing Drupal framework.
• Workflow Automation: Designed and implemented custom scripts to automate administrative tasks, such as enrollment processing and automated grade reporting.

Lead developer and technical architect responsible for building, maintaining, and scaling complex enterprise web applications within a diverse technical stack, specializing in high-performance Drupal and Zend Framework implementations.

Key Responsibilities

• Application Architecture: Designed and engineered scalable web solutions using PHP and the PHP Zend Framework, ensuring robust backend logic and efficient system performance.
• Drupal Development: Led the customization and deployment of Drupal 6 platforms, including the creation of custom modules and advanced theme integration.
• Legacy System Integration: Maintained and optimized existing Perl/CGI scripts, facilitating seamless transitions and data flow between legacy systems and modern PHP environments.
• Frontend Engineering: Developed interactive, responsive user interfaces using HTML, JavaScript, and jQuery to enhance client-side functionality and user experience.
• Database Management: Architected and optimized MySQL schemas, focusing on query performance, data integrity, and complex relational mapping for large-scale datasets.
• Technical Leadership: Provided high-level troubleshooting and code optimization strategies to improve application security, stability, and development velocity.

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.