Daniel Macchio Email & Phone Number

New York, Ny, Us

Floral Park, New York, Us

- Manage 2 analysts and 3 interns across various analytics functions including Ticketing, Sales, Marketing, Sponsorship and more- Created more than 30 automated email alerts using SQL to help detect anomalies in data and clean up the database proactively (i.e. discrepancies between Premium Contracts and sales in Archtics) - This allowed us to streamline and clean up reporting for executives to more accurately project revenue streams - Spearheaded cleaning up and standardizing reporting to create a source of truth where various departments can view their data and reports; own Tableau dashboard creation and maintenance (30+ Tableau Reports)- Built SQL views that are regularly used for reporting to streamline the process of creating dashboards using cleaner data- Standardization of premium and sponsorship reporting to aid in forecasting and inventory management - Total of 60+ Sponsorship contracts and reporting for 700+ Premium Contracts to track renewals, contract management- Targeted segmentation of the database to grow campaigns for sales and marketing - Isolated segments that over-index on metrics like email engagement, hockey buying habits, etc. to generate additional leads for 50+ reps at the organization

- Program enhancement for all BC sports- Input for furthering the student experience

Beverly Hills, California, Us

- Measurement of Brand Effectiveness and Fan Experience at Festivals/Venues through extensive research and reporting of Survey Data, Spatial Intelligence, and Social Listening; enabled the organization to have a greater understanding of what drives success in sponsorships and event experienceo Data included roughly 1-2k responses per festival and demonstrated how interacting with fans at live events increased recognition and consideration of the brando Worked on deliverables for up to 50 brands and festivals per season- Spearheaded creating a measurement data warehouse for the above + built Tableau Dashboards from a variety of data sources/pipelines using Tableau Prep + SQL to move away from storing data in excel- Generated various segments and cuts of data from a range of data sources to create customized reporting and benchmarks with Tableau; used to measure brand KPIs and overall event experience to help provide value to more departments across the organization and more brand partnerso Satisfaction across 15-20 different aspects of the event and anywhere from 5-10 standardized brand related metrics (recall, purchase intent, etc)- Presented + visualized results/managed relationships with Brand Partners + Festival Teams to collaborate on future strategy

New York, New York, Us

- Facilitated data Collection and reporting for Club Financial, F&B, Retail, Venue, and Survey Data; optimized data pipelines to allow for streamlined benchmarking and reporting for all Clubs- Built and maintained Tableau Dashboards to share with Clubs and visualize results for league wide insights; allowed Clubs to compare themselves to league and like-market (selection of 4-5 clubs) averages on a rolling basis- Best Practice sharing + analysis for all 31 Clubs (now 32) – Co-led calls on F&B and Guest Experience to share case studies of what’s working/what isn’t- Due to protocols surrounding COVID-19, led vendor procurement initiatives for touchless tech which allowed clubs to obtain preferred pricing and maintained relationships with existing League partners- Built extensive reports in excel based off Club survey data for decks, reporting and analysis

Brooklyn, New York, Us

Brooklyn, New York, Us

- Developed a system based on sales rep metrics to determine pipeline capacity for each rep; this allowed sales reps to operate on a more efficient basis catered to individual habits that optimized their close rate (initial findings showed lift of 2-3 percentage points)- Segmented lists for Marketing based on customer profiles and buyer propensity to maximize ROI and target fans with most buying potential- Managed CRM system/database (using SQL), lead generation and all lead distribution campaignso Kept pipelines fresh by clearing out and reassigning leads that hadn’t been contacted in 45+ days (allowed for higher connect/conversion rate on leads in pipeline)o Generated hundreds of leads per week for the sales staff- Built and maintained Tableau reports for sales/marketing based on revenue, pipeline, and customer data sets; allowed sales department heads to evaluate their groups’ performance and measurement which campaigns were driving success and revenue

New York, Ny, Us

- Worked select Patriots Games at Gillette Stadium to provide assistance to broadcast crew and sideline reporters

Brooklyn, New York, Us

- Pulled and analyzed customer data concerning market potential- Interfaced with department executives throughout organization- Participated in projects to optimize sales and revenue using segmentation and database research

Port Jeffeson, Ny, Us

- Analyzed clinical data- Extracted data from Electronic Health Records using MS SQL

Bachelor'S Degree, Mathematics

Education record