Oversaw the Business Intelligence and Data Integration Architecture for one of the oldest wildlife conservation nonprofit organizations. Managed, coached and mentored small team of geographically disbursed developers. Fostered culture of learning; encouraged stretch assignments to expand core skill sets. Remote worker, headquarters in Reston, VA. ⇛ Created an Enterprise Business Intelligence and Data Integration Roadmap to move the organization from multiple point to point integrations to a centralized data hub architecture. Planning included sequencing of multiple strategic initiatives including CRM platform upgrade, migration to a new cloud based digital marketing platform, data warehouse modernization, and self-service analytics.⇛ Designed, developed and refactored Data Warehouse databases and cubes to support fundraising analytics. ⇛ Proposed and created proof of concept to aid selection of data visualization application (Tableau) for self-service analytics.⇛ Managed the implementation of custom analytical marketing application for segmentation of donors (customers). Held vendor accountable to contract terms for delivery of feature complete system. ⇛ Implemented first phase of enterprise data hub integrating donor (customer) data with new cloud-based digital marketing application and with on-premises CRM application.⇛ Developed highly flexible data integration framework that simplified integration of new data sources.⇛ Planned and oversaw upgrade of Microsoft Dynamics CRM 2011 to Dynamics 365.

Managed engagements for boutique Data Warehouse and Business Intelligence consulting firm. Staffed and monitored upcoming skills demand for new work. Achieved high project delivery success rate. ⇛ Delivered successful projects, and attracted multiple repeat clients. ⇛ Managed consultants and solution architects across multiple projects.⇛ Mentored consultants to build skills and lead projects.⇛ Developed proposals and statements of work. Monitored project progress and upcoming deals in the pipeline.

Managed the analytical data warehouse and campaign management solution for a loyalty program of a large financial institution. ⇛ Led the design and development of data marts for marketing analytics. Subject areas included marketing campaign response, click-stream analysis of member website behavior, member earn/redemption activity.⇛ Simplified legacy campaign data feed, reducing post-processing time from 16 hours to 20 minutes.⇛ Managed team of 10 technology professionals including report developers, database administrators, web application developers, and data engineers.

Responsible for full life cycle Data Warehouse design, ETL development, and support for a subsidiary of Nintendo of America that provides electronic product registration services for many of the top manufacturers of consumer electronic goods. Designed and implemented the first dimensional data marts for the Data Warehouse. Developed ETL to source information from the registration system and populate data marts. Designed and developed a process to generate and distribute reports to external parties.

Supported the Enterprise Architecture function, contributed to the definition of enterprise standards for data architecture. Created architecture for a central data repository for housing enterprise master reference data. Designed conceptual and logical data models for several Master Data subjects. Defined standard XML message structures for the exchange of information between applications. Designed a dimensional data mart to support the Retail Inventory Planning application. Contributed to the selection of an enterprise messaging platform and enterprise applications to replace legacy systems.

Database administration for all aspects of the enterprise data warehouse environment. Centralized operational Database Administration function from Data Warehouse to centralized enterprise focus. Led database administration team prior to moving into an enterprise-focused architecture role.