Oversee the internal data warehouse and all external community data sources to enable the planning and evaluation of community-based, recovery-oriented mental health and addiction services.Routinely conduct database updates to reflect the latest service claims and billing information. This process includes intensive ETL SSIS solutions, the automated execution of stored procedures, updates to a large number of data warehouse tables and views, and management of on-demand reports (SSRS).Lead community crisis care reporting efforts, including data collection from 11 community partners, data processing (ETL) and warehousing (SSIS), output procedures execution (SQL), report creation, distribution, and presentation.Author and owner of a portfolio of reports, enabling optimized, data-based decision-making about the delivery of mental health and addiction services.Serve as Privacy Officer for the organization, helping to develop and maintain HIPAA-compliant privacy policies, organize privacy policy mailings, research and report data breaches, and execute the annual destruction of data in accordance with data retention policies.

Processed more than 100,000 COVID-19 reports received through Electronic Laboratory Reporting into the Ohio Disease Reporting System (ODRS), applying standardized case definitions to ensure consistent COVID-19 reporting between Ohio and national surveillance efforts.Spearheaded a weekly SQL query process to reduce the duplication of reports arriving from multiple sources, resulting in the improved accuracy of reporting total COVID-19 cases, hospitalizations, and deaths.Manually reconciled COVID-19 data in the Ohio Disease Reporting System with external systems including the Electronic Death Reporting System (EDRS) and Ohio Department of Health Laboratory REDCap database used for variant surveillance.Communicated with Ohio local health districts and dozens of other states to ensure timely public health follow-up on the transfer of COVID-19 cases and contacts.

Created and managed an independent consultancy, rooted in substantial corporate experience, maintaining a pronounced focus on business research, analysis, and planning.Founded and actively managed a private fund trading U.S. equities, ETFs, options, and futures contracts, posting double-digit investment profits each year, and exceeding S&P500 returns in 41 of 60 weeks.

Created and managed an extensive floor-planning database with access to fixture-level information for 12–14 annual floorsets executed in more than 1,000 stores. Leveraged this database to build strong relationships between home office planning teams and field operations leadership, resulting in optimal merchandise presentation and significant increases in shopper conversion rates.Initiated and directed a floor planning and execution process fully integrated across core home office and store functions. Implemented a payroll optimization practice, annually saving 40,000 payroll hours while creating an expense savings of $500,000 and an opportunity for stores to grow top-line sales by $13 million.Led a cross-functional effort among the planning, operations, finance, and marketing departments to create and operationalize customer segmentation and tiering for an elite fashion retail brand. Authored an innovative store and space planning framework for multiple national brands. Oversaw implementation of the framework during a substantial enterprise-wide ERP technology implementation.Directed the work and development of a team of five resources, including seven new hires and four promotions. Grew headcount by 67% and payroll by 100% to capitalize on sales growth opportunities.

Managed all company primary and secondary research projects; analyzed results to define target customers and clarify the competitive landscape. Wrote multi-year strategic plans; presented monthly updates to the Executive Committee and quarterly updates to the Board of Directors.Originated and managed in-house customer satisfaction measurement programs, including vendor selection, survey scripting, data management, reporting, and operationalizing the results. Established relationships with 3rd-party market data sources (NPD, MRI, Nielsen, Forrester).Generated over $100k in annual net profits by negotiating trade of data for funds. Significantly improved the quality of merchant-vendor negotiations by providing market analysis and insights.