Hunter Calvert Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Leading the analytics initiative for NYT Games, which includes the 80+ years old NYT Crossword, Spelling Bee, Wordle, and many more fun and engaging puzzle games.

New York, New York, Us

Redwood City, Ca, Us

● Studio Analytics Manager at Maxis responsible for creating analytical frameworks/processes, data modeling, job automation, analysts' growth, and developing cross-discipline studio relationships.● Productionalized behavioral segmentation models for The Sims Mobile, SimCity BuildIt, and The Sims 4, sorting users into behavioral cohorts daily and reporting on their performance.

Redwood City, Ca, Us

● Lead Analyst for The Sims Mobile, responsible for running a team of analysts and defining the project’s analytics roadmap, which includes ad-hoc analysis, long term data projects, ETL/infrastructure building, and BI tool creation● Built a completely open source and custom data product using Bootstrap, R Shiny, and R Markdown that handles all of the reporting and dashboarding for the project without any additional costs to the studio● Ran studio-wide “Data Readout” meetings where I presented on a myriad of topics including post-update performance, kpi change investigations, or the results of our long term analytics projects.

Vancouver, British Columbia, Ca

● Owns the game data creation, transformation, modeling, and visualization process for all studio titles, representing a portfolio of ~$30 million annual revenue and 6.5 million yearly installs● Lead Analyst at 60 person Phoenix Age studio responsible for managing the tracking, reporting, and analysis of game data for two of the top three revenue games at Kabam, as well as two pre-launch titles● Defined and prioritized analytics road map while creating dashboards and ad-hoc analyses for cross-functional teams encompassing Engineering, Design, UI/UX, Support, and Business Development● Learned PHP, allowing analytics to create data logging triggers on client/server code while freeing developers from the process● Performed basic statistical analysis using R and Python to research and predict user behavior and in-game events

San Francisco, California, Us

● Monitored and maintained KPI tracking dashboards for a global portfolio of 9 titles across 3 studios with over 100+ million installs using Redshift, S3, and Tableau● Created an automated advertising solution, "CashBot", which automatically reweighted and optimized the advertisements shown in Sega's titles and increased ad revenue across the company by ~$700K/yr. CashBot changed eCPM floors and turned off and on different partners to maximize revenue using Python, Selenium, SQL, and Cron.● Produced daily exploratory game and advertising analysis primarily using Redshift, SQL, and Python● Built a web crawler using Python, Selenium, and SQL that scraped AppAnnie to identify newly soft launched titles of competitors and sent an automated weekly email report to the Product Team● Developed a front-end web interface using Python, Flask, and HTML/CSS to allow the Advertising Team to monitor and manipulate eCPM values in real-time● Created a Spark/SparkSQL tool for the BI Team to convert raw JSON data to CSV format

● Primary business process consultant for the House of Representatives where I provided strategic and operations-based consultation services for proprietary CRM software.● Analyzed user data to identify key performance metrics for client success using Excel and SQL● Designed internal reporting system for our customer support team based on these metrics● Composed custom, complex SQL queries in order to pull data by client request● Monitored backlog of data imports into CRM products via MS SQL Server 2008