• Design and implemented star schema and ETL enhancements to integrate the Performance system into the Sumtotal LMS reporting system.
o Architected goal and assessment star schema based on business requirements through conferring with product management and technical leads.
o Implemented Goal and Assessment star schema before target dates.
o Re-architected key parts of the ETL to reduce transaction log consumption during the Extract phase and also improved inherent inefficiencies in the ETL computation of deleted records.
• Designed and implemented a complete framework for desigining and delivering hot fixes and customizations that provides database and file tracking. automatic installaton, and prerequisite management.
• Architected and implemented security layer of OLAP-based reporting system in the span of one month, due to customer demand.
• Integrated support and development teams to address key missing features and defects identified by customer support with immediate application into the Report Manager product.