• Conducted 24/7 support for all production databases and related processes
• Designed and implemented a high availability MySQL database cluster using LVM, DRBD and Heartbeat
• Managed a multi-tier MySQL replication scheme, spinning up new databases as required for scaling
• Completed a full migration of production database services from a managed hosting facility to a co-location facility with zero downtime
• Monitored database performance and growth and developed strategies for addressing potential issues before they became a problem
• Implemented a partitioning plan on large tables to address performance issues
• Reviewed proposed code and architecture changes for potential performance and scalability issues
• Pulled snapshots from production to regularly refresh development and testing environments with relevant data
• Modified existing procedures to ensure they were fully transactional and crash safe
• Developed a database release management strategy that ensures data model changes and additions are properly tested and contained within source control

• Conducted production database support for the Bill Me Later payment system
• Maintained application performance standards through database performance tuning
• Created database users and roles and maintained database security
• Scheduled backups and duplicated databases using RMAN
• Wrote shell scripts and created database jobs to perform routine tasks
• Maintained Datamart through use of logical standby, database links, and ETL processes
• Designed, developed, and tested database objects for new development including: tables, indexes, constraints, procedures, functions, and triggers
• Developed push and rollback scripts for migration of database changes to QA and production
• Developed comprehensive unit tests for regression testing of critical procedures and functions
• Ensured all SQL code is properly maintained and current within the source control system
• Documented engineering requirements, standard procedures, and best practices

• Managed all reporting systems and data warehousing relating to Wyeth’s contracting systems
• Supervised a team of 2 internal staff members and 3 contractors
• Responsible for creation and maintenance of 200 reports used by over 150 employees
• Designed reports for managed care, Medicaid, and Medicare disciplines
• Revised all existing reporting templates and methods, resulting in standardized look and feel and faster response times across all reports.
• Developed ways of extending exiting reporting frameworks to achieve new levels of functionality - allowing creation of reports that clients were once told could not be done
• Created a tool that allows national and regional account managers to effectively track the formulary status of contracted products at managed care accounts across the country

• Managed 8 small- to medium-sized projects throughout the system development lifecycle
• Created a system that allows account managers to order and track customized sales pieces
• Designed, developed and implemented strategic enhancements to web-based sales tools
• Developed technical and functional specification documents and training manuals
• Conducted training sessions and demonstrations of applications with hundreds of end-users
• Worked with business teams on regular basis to determine new desired functionality and new ways to leverage existing functionality to perform new tasks
• Performed maintenance and provided technical support for new and existing applications

• Developed interactive media products for various large pharmaceuticals companies
• Interfaced with clients on a daily basis from proposal to discovery to product launch
• Ensured clients’ needs were met by managing projects and internal and external personnel
• Authorized product launches by performing final QA and testing

• Sought and developed new business opportunities with clients
• Managed regional and national meetings from organization to on-site management
• Monitored and maintained current projects on a day-to-day basis

• Routed slide kits, promotional pieces, and medical monographs for review and approval
• Created time-and-events schedules to monitor and manage efficient workflow
• Generated daily hotsheet and weekly status reports to track active jobs

• Created music library with related packaging and marketing tools
• Re-mixed two seasons of Your New House for the Discovery Channel
• Mixed and recorded music for Pepsi, Frito Lay, and the American Heart Association

• Full administrative and client self-management sections with secure logins
• Automated tabulations of results; summary and detail reports streamed to PDF
• Dynamic survey options and calculations created with Javascript and CSS

• Internet-based system for creation and monitoring of Employee Action Plans
• Alert system based on due-dates and percent complete

• Focus on utilization of web standards for cross-browser compliance and accessibility
• Job Posting and News sections complete with administrative publishing tools
• Javascript menu and slideshow that fails gracefully when not enabled in browser

B.S. Music Recording

• Dean’s List
• Member of Order of the Omega leadership organization
• Studio Manager for the School of Music recording studio