Michael Valeri Email & Phone Number

Redmond, Washington, Us

Cybersecurity GTM analytics

San Francisco, Ca, Us

Business Problem: Events and Digital teams lacked efficient, curated data products for campaign funnel reporting.  Solutions: Developed a funnel methodology for tracking leads through the sales process and served as the primary product owner and developer for a Databricks/Tableau powered Marketing Events data source.  Outcomes: Enhanced lead tracking accuracy and efficiency, significantly improving the conversion rate from marketing leads to sales opportunities for Events marketing resulting in a 2% increase in overall bookings.

Seattle, Wa, Us

Supporting Customer Experience Analytics.• Assisted in migration of tables, datasources and Tableau workbooks from Google Big Query SQL to Snowflake SQL• Acted as liaison between marketing managers and data engineering to construct over +20 email monitoring dashboards• Experience using Gitlab, Github and dbt language to construct deployable Snowflake views/tables.• Winner of Q4FY22 Amazing Marketer Award - Authenticity

Seattle, Wa, Us

• Scope, construct and monitor Tableau Renewal programs KPIs for Customer Experience team.• Execute analysis for major projects on event performance for Tableau sponsored events• Own and maintain Tableau dashboards to help event marketing team make criticaldecisions and understand the overall health of their initiatives• Pursue ad hoc questions pertaining to events• Collaborate with stakeholders from different business functions – marketing, operations, sales, finance,procurement, sourcing and technology teams to develop data architecture and ‘source of truth’ for measuring KPIs and performance of initiatives• Drive solutions to improve data quality issues and design data architecture by collaborating with internalstakeholders and external vendors

Seattle, Washington, Us

Since 2017, we have been bringing data analytics to life in the form of on-site workshops and virtual webinars to empowering individuals of all backgrounds to become data literate.Data literacy is defined as the ability to read, understand, create and communicate data as information. It’s estimated that only 33% of employees are data literate.We believe data literacy skills are within reach of all professionals, regardless of their technical aptitude or background. Are you ready to empower your workforce?

New York, Ny, Us

• Leveraging professional knowledge and student feedback to create engaging and relevant curriculum in SQL, Tableau and Excel• Taught over +400 analytics workshops for students of various technical aptitudes• Recurring guest, moderator and panel designer• https://generalassemb.ly/instructors/michael-valeri/13994 - Instructor Profile

Redmond, Washington, Us

Avenue In Consulting - Reporting, Insights and Data PM on one of Microsoft's FastTrack Pilot Programs.* Technical data advisor to Principal Product Manager* Used DAX, SQL and Power BI to develop data-driven Command Center (Power BI Dashboard)* Utilized linear regression models to facilitate changes in engagement approach in pilot program

Bellevue, Wa, Us

* Built Tableau based dashboards for reporting on newly re-designed mobile app* Surfaced and evangelized issues related to page load performance on re-designed app* Assessed bottlenecks of data infrastructure platform and offered recommendation

Seattle, Washington, Us

• Responsible for ownership of entire ETL process for upcoming mobile game• Transforming data from Hive based JSON extracts to +50 automated Tableau dashboards• Defining core KPIs to track player engagement to facilitate changes in game design• Working as primary PM for all data related inquiries associated with upcoming mobile game

Seattle, Wa, Us

• Monitoring, understanding, and preventing chargebacks generated by affiliate payment API• Saved $200K annually by developing first ever SQL based logic to flag duplicate bookings• Utilized Tableau and Excel to find +200 bps improvement opportunity to payment success rate• Enhanced fraud reporting granularity by adding +60 dimensions from Hadoop based data sources • Point of contact for all SQL related development in organization

Tempe, Az, Us

• Facilitated Weekly Site Data Review; addressing web performance trends for +30 business partners• Built over +100 Tableau dashboards for business partners and multiple Hadoop sourced data-marts• Conducted Hadoop sourced data-mart presentations for organization on monthly basis• Trained +100 individuals quarterly on Google Analytics; delivering content in-person and virtually• Created over +50 Google Analytics based funnel reports for traffic analysis/acquisition

Seattle, Wa, Us

Driving revenue and selection across Amazon's third party business by acting as a strategic consultant to over 27 third-party sellers on Amazon's platform. Support account management team by creating scalable business reports and providing business intelligence.Highlights:• Managed and consulted 27 third-party sellers in a portfolio totalling $317MM (+5.0% YoY Growth)• Created scalable metrics dashboard for 11 account managers by utilizing Excel, SQL and VBA• Streamlined workflow by creating first ever SQL based weekly revenue variance analysis report • Created over +30 automated SQL reports to identify high opportunity products on the platform• Leveraged internal data to help sign a $740K advertising campaign with a third-party seller

Seattle, Wa, Us

Support Amazon Kindle Content Finance by publishing Weekly/Monthly/Quarterly business reviews. Perform rigorous ad-hoc analysis and report sales drivers to management. Train, co-manage, and collaborate with financial analyst internsHighlights:• Built, oversaw and published +10 weekly reports and +10 monthly P&Ls for 12 marketplaces• Wrote, maintained and oversaw +200 SQL queries used to report financial information to VPs• Educated and co-managed 4 interns with one-on-one training in SQL and Excel• Reduced weekly report length by 50% by collaborating with Amazon SVP on data capturing • Tracked user engagement levels against all Kindle devices by building cohort analysis file• Promoted Amazon brand at campus recruiting events engaging undergrads into employee community

Seattle, Wa, Us

Supported Amazon Music and Movies Finance team by publishing Weekly Business Review (WBR) and preforming ad-hoc analysis by utilizing SQL and Microsoft Excel. Highlights:• Wrote VBA macro for WBR files that automatically renames file and places it into the current week folder. Decreased file creation process from roughly 1 minute to 1 second.• Implemented a new deck structure for the Movies team that combined both Physical/Digital data into the same WBR. Developed naming logic and new drop point location that ensured a smooth transition to the new process.• Revamped a product line's reporting metrics and developed an automated slide for the WBR. Migrated Access data into Excel. Increased overall transparency for the business team with inclusion of slide in WBR.• Automated data collection for a category's WBR by linking Excel spreadsheet to SQL server. Decreased creation time from 30 minutes to less than 1 minute.Ad-hoc Analysis• Developed IBM Cognos formatting tool for pulling year to date contribution profit data for the Movies team.• Analyzed the contribution profit impact a Vendor Cost Reduction made on the DVD category as a whole. Discovered a positive contribution profit bucket that can be used in future situations to increase overall profitability.

Ba, Business - Accounting

Meisner Technique

Education record