-- Managed all technology functions for a national for-profit educational company, with 160 retail tutoring centers in major cities throughout the US-- Directly managed 3-person development and sys admin team; indirectly (matrix) managed larger field engineering and desktop support team-- Responsible for all technology efforts, including maintaining and upgrading internal billing, CRM and business intelligence systems-- Led overhaul of an outdated business intelligence system. Worked directly with executive team to challenge and rethink the requirements, retiring dozens of existing but poorly defined metrics. Project resulted in a newly designed data warehouse and two key daily reports (down from twelve) that focused the company’s attention on vastly smaller number of Key Performance Indicators (KPI)-- Re-designed Order Entry system's GUI to reflect company’s shift from monthly membership-based products to fixed fee products-- Played hands-on role as lead BA for all projects, leading JAD sessions with stakeholders to gather requirements

-- Lead business analyst and database developer for two separate business units, playing senior role in two successful major, multi-year transitions from legacy client-server systems to modern webapplications using J2EE, JSP and Oracle database technologies-- Lead database developer supporting core proprietary billing system used by multiple business units; responsible for creating all tables, views, triggers and stored procedures-- Designed interfaces between KTPA’s e-commerce site and the back-end billing system, including daily reconciliation processes-- Designed all ETL interfaces and data models for new reporting application and data warehouse that aggregated data from 9 discrete data stores and presented reportable data to users with a lag of no more than 20 minutes, reducing lag time by hours-- Managed all DBA functions for non-Production database environments-- Extensive experience gathering and writing detailed requirements

-- Promoted from Austin field office to New York City corporate headquarters to take on role as top-level support, QA and business analyst-- Established self as Kaplan’s Oracle, SQL and PL/SQL expert, assisting users from Marketing, Accounting and Operations departments with all data extraction, data analysis and data conversion projects