Database Developer in Tampa, FL, United States

Developed DotNetNuke 9 reporting and administration module that instantly converted a database procedure, view, or table into a web-based and role-secured interactive report supporting custom styling, pagination, filtering, sorting, drilling, pop-outs, tool tips, cell/row level action definitions, role-based column viewing/access, along with with the ability to have delivered to email or exported to Excel/PDF.

The administrative interface automatically generated default report definitions for admins, which could then be modified down to the column level as needed, reducing report development time to stored procedure development time plus two minutes of administration in most cases. This module responded to frequent client requests for custom reporting and allowed us to over-deliver high quality and branded new reports usually within hours and some times within minutes of the request. Since the feature-rich module supported role-based access/actions, it was also used as an administrative interface for internal project directors to view and/or modify 20+ tables/views.

Built a complete system for creating and managing surveys or graded tests. The system included an administrative interface supporting system-level and event-level templates and tokens, an automated workflow featuring real-time grading with instant feedback, email communications, dynamic PDF certificate generation/issuance, and a back-end process to provide ad hoc and scheduled reporting, auditing, and ETL processes with partnered accrediting institutions.

Designed and implemented a company-wide email system integrated with Mandrill/Mailchimp, allowing to generate scheduled email campaigns, templates with customizable tokens, and dynamically generated attachments, along with tracking capabilities. The robust system included whitelisting and blacklisting, CC/BCC/Replace recipient capabilities, work flow integration, logging, auditing, and automated reporting of delivery failures to internal admins. The system also presented a web interface with different views to easily track and manage emails per event, user, or across the entire portal.