Matthew Hanagan Email & Phone Number

Jersey City, New Jersey, United States

- Partner with business units to determine technology needs, develop priorities, and interface with IT staff and vendors to determine project scopes, budgets, and implementation schedules- Manage research and data mining for data analysis requests and present findings through data visualizations to other departments and executive leadership ensuring technical concepts are translated for non-technical audiences- Led implementation of Salesforce Marketing Cloud and developed data pipeline for effective segmentation, campaign targeting and automated patron journeys- Led marketing department in implementation of Audience Studio, the Salesforce DMP, and facilitated creation of distinct audience segments based on consumer behavioral data to develop marketing campaigns more closely aligned with 92Y audience interests- Managed gap analysis of technology solutions across 92Y to determine if business requirements were being met

Greater New York City Area

Greater New York City Area

-Created departmental data warehouse in MS SQL server to facilitate reporting, importing data from primary Oracle database and several internal data sources-Automated reporting and operational jobs using SQL SSRS and SSIS -Provided strategic data analysis and reporting for use by senior management steering committees-Analyzed operational workflow and procedures to develop strategies for maximizing efficiency via database jobs or functionality-Provided targeted segmented data files for outreach efforts, subscription renewal campaigns

-Developed and maintained all Barnes & Noble Publishing databases containing financial, shipping, and bibliographic data-Created new MS SQL Server tables and views for efficient database performance and/or reporting-Developed and oversaw the broadcast of Barnes & Noble publishing metadata for industry use -Maintained all MS SQL Server stored procedures feeding the Barnes & Noble Publishing database -Maintained daily data feeds from master database into proprietary financial database

-Managed and supervised the TIPCo database build in China-Executed and tracked monthly web loads for 6 TGR family websites-Performed ongoing quality assurance testing for website and internal software platforms-Tested various editorial database update procedures and evaluated procedures for efficiency -Assisted in development and management of advertising sales campaign in TIPCo Japan-Responsible for communication and central support for TIPCo Japan & TIPCo India offices-Coordinated and carried out database audits of the TIPCo Japan and TIPCo India offices