• Helped establish R&D subsidiary (Exemplar Analytics) whose mandate is to research emerging BI technologies and identify value for parent company• Hired and managed team of BI developers and data scientists and created guidelines for Agile BI environment• Created overall architecture for predictive analytics initiative, overseeing data scientists and developers• Created overall architecture for PowerBI strategy, including the integration of Reporting Services and PowerBI• Initiated and led the concept of ETL Meta-Framework (based on BIML)• Initiated and led the concept of a bitemporal data strategy• Defined the cloud strategy and oversaw migration to Azure and AWS• Defined and implemented the public data set strategy to incorporate national and California-based data sets into the data warehouse• Oversaw the Geo-spatial and mapping initiatives• Oversaw the upgrade of the data warehouse to Data Vault 2.0

• Responsible for Analysis Services and Reporting Services architecture that supports business intelligence delivered to the health and social services departments of several counties in California• Led the design and development of the Engagement Matrix™, consisting of a configurable SSIS-based ETL application, SQL Server dimensional bitemporal data warehouse and web-based reporting suite that implemented Exemplar’s performance management framework; project’s success in the State of California led to subsequent contract in NYC• Implemented policies and procedures to support project activities, including standards for analysis and design, requirements management, change management and security policies• Trained junior staff on ETL framework and dimensional modeling• Architected all three versions of the measurement framework for past six years while client base has expanded to include 12 counties in California (including San Bernardino, Kern, Santa Cruz), New York City Human Resources Administration, and a government service provider in Tennesse.• Designed overall BI solution consisting of web-enabled interactive reporting, customized reports delivered via email, data exploration via SSAS Cubes and Excel front end, self-service BI via PowerPivot and PowerMap• Responsible for evolution of the data warehouse that was created in prior phase of project (see previous position) to incorporate an Anchor Model (6th normal form).

• Oversaw the design and creation of the data warehouse that supports business intelligence delivered to the health and social services departments of several counties in California, including San Bernardino, Kern, Santa Cruz and Stanislaus• Responsible for modeling data warehouse for both California case management systems (CalWIN, C-IV)• Designed ODS (normalized) and dimensional models• Implemented data warehouse using Microsoft technology – SQL Server, Analysis Services, Integration Services• Created ETL architecture which included change data capture strategy, data quality, OLAP cube refresh and the creation of highly-optimized reporting datasets (star schema, denormalized)• Optimized server configuration, implemented clustering and mirroring strategy, implemented table partitioning strategy• Implemented Data Vault 1.0

Customized ACL (business intelligence software) at Commerce Bank, Kansas City, MO.Designed solution that automatically imported mainframe data into ACL and generated audit reports for clearinghouse transactions

Carried out process and technology improvements to 24x7 Global Support Center to meet new increased demand for services related to ACL business intelligence softwareManaged team of 12 Analysts; conducted performance appraisals, compensation reviews and career planning Responsible for ongoing interviewing and hiring of new staff, retention initiatives and department restructuring

Project managed 100+ software implementations to clients, coordinating implementation, training and support teams.Played supporting role in development initiatives; performed business analysis, ER Modeling, UML modeling, use case modeling.

Responsible for project management and client management for Corporate Accounting System Initiatve (CAS); managed projects for three large ministries (Transportation, Children and Families, BC Assets and Lands) that were required for preparation for the Oracle 11i upgrade.

Implemented Longview (consolidation software) - Polaroid (Waltham, MA)- Lockheed Martin (Bethesda, MD)

Member of 300-person team tasked with replacing the City of New York's existing financial management system with a new Y2K-compliant systemResponsible for ER modeling, requirements definition, UML modeling and some project management for parts of the new system that would interface with the agencies across New York City (Human Resource Administration, District Attorney, Police).Received the AMS* Best Practices Award, a company-wide award that recognizes excellence in the utilization and continuous improvement of project management and performance management methodologies. *was AMS prior to the acquisition by CGI.