Matthew Bracci Email & Phone Number

Portland, Me, Us

Pleasanton, California, Us

-Data Services team member working under Principal Data Engineer for digital sales of giftcards under blackhawk network -Maintain and build ETL/ELT jobs - sourcing from multitude of APIs, storefront sites, and transactional databases - targeted to both MySQL and Redshift data warehouses-Designed and built star schema in redshift tracking all click events per site visit, from over 600 different storefront sties. Built the staging, integration and presentation layers. Created views from the fact that enabled the construction of a highly utilized dashboard tracking user drop-off patterns throughout the buy flow.-Converted large scale aggregation scripts written in R to redshift. Job runtime reduced from 12 hours to 5 mins. Enabled the retirement of the R server -Other responsibilities include assisting with dashboard development planning. Navigate linux servers. Help plan migrations and infrastructure change initiatives. Deliver adhoc and reoccurring reports to external and internal clients via scheduled cronjobs (monitor failures with self developed audits, fix any ETL issues, build and implement new reports)

Stamford, Connecticut, Us

-Act as data supporting agent for executive leadership of Spectrum Enterprise, directly providing reoccurring and adhoc reports to Directors, VPs, GVP, and occasionally C-suite level executives. Promptly provide data requests – whether that is an intelligible visual story, an analysis, or just clean and accurate raw data. The analysis and reporting I am responsible for covers a wide breadth of business metrics and initiatives. -Write SQL in SSMS to extract and clean data across a wide range of tables and multiple databases. Query through and manipulate history tables to capture changes to fields not reflected in current data. Utilize openquery to data lake, temp tables, correlated subqueries - and whatever method is necessary to get the right data. -Automate data driven powerpoint decks using R. Single scripts pull and clean data from database, create visualizations and output results as a complete and polished presentation. Have saved our reporting team over 50 hours of monthly work through automation of decks in 2022. Visualizations are made with ggplot2-Restructure dashboards containing calculated fields, joins, and other data manipulations being performed in tableau to SQL. Familiar with tableau design and functions, minimal experience building dashboards -Work with executive leadership and BI team members to understand and define data requirements

Worked as a temp in the customer setup department assisting with data analysis and data clean up projects. I worked with many pivot tables, VLOOKUP, and a multitude of nested IF functions.

Portsmouth, New Hampshire, Us

I performed data clean up by updating fields for various office software and extracting and recording key information from Franchise Disclosure Documents. I also helped with generating leads, initiating marketing campaigns, creating surveys, and researching information on specific franchisors or sectors.

Portsmouth, Nh, Us

-Researched Greenhouse Gas emissions under the GHG Protocol -Found how the data can mislead shareholders in their Environmental, Social and Governance analysis. -Wrote research paper on need to account for avoided emissions-Developed calculator in Excel to account for CO2 avoided by PV solar manufacturers-Researched other renewable energy and energy efficient technologies to see the potential for other avoided emissions within Pax World's Funds-Recorded these emissions where applicable and aggregated the data to the largest fund

-Created and analyzed excel files for specific economic development sites -Helped pass the Epping Road Economic Development TIF Initiative -designed advertisements -Attended Town Council meetings-Created maps using basic software

Master Of Arts - Ma, Economics

Bachelor Of Science - Bs, Economics