Collin Ross Email & Phone Number

Seattle, Wa, Us

San Francisco, Ca, Us

Cupertino, California, Us

San Jose, California, Us

- ROI Forecasting with non-linear regression with R and SQL.- Post purchase analysis to determine if retailer created a net benefit on the Roku platformusing SQL, Python, and population variance testing.- Analyzed lift in marketing campaign for TV brand activation rate and communicated results to marketing team.- Created ETL for ARPU and ARPD using SQL and Airflow.- Created and compiled ARPU analysis to present to management to better understand Roku device demographics.- The "go-to" person for quick questions all things data related (includes Looker and Tableau).

Sunnyvale, Ca, Us

- Setup ETL with Python, Bash, MySQL for third party reporting for revenue recognition - Supported MBRs using Looker and Tableau- Created and maintained Looker Dashboards.

New York, Ny, Us

- Regression Analysis to determine incremental spend on MediaMath platform for mid-tier agency.- Led and implmeneted application id reporting to determine week over week change of iOS and android applications using python.- Conducted CPM analysis with HIVE/Hadoop to calculate highest impacting CPM.

New York, Ny, Us

- Created programmatic display and video campaigns for large B2C and B2B clients. - Created reporting template used by solutions analyst team that showed campaign results to clients.- Automated report workflow with VBA.

Chicago, Illinois, Us

Assisted with building new search analytical practices within the VivaKi Search HubVisual Basic Application for excel

Chicago, Illinois, Us

• Managed and updated daily accounts for reporting and optimizations for 8 – 15 lines of business. • Full level account analysis to create actionable insights and unique reporting. • Contributed to bid strategy innovations and solutions including automated bid strategies from DoubleClick Search. • Collaborated with account managers to discuss optimizations, tactics, and strategies moving forward. Assisted launching new accounts, campaigns, and keywords.

Philadelphia, Pa, Us

• Assisted Finance Department with billing and receiving.• Used IBS Database for reconciling account questions and Oracle for day to day tasks. • Data entry, memo billing, credit card processing, audited promotional folders, handled incoming checks, and creation of TREX expense reports.• Managed, entered, and processed invoices into Oracle.

• Responsible for improving the workflow of Educational Partnership Center by reviewing budgets, transferring expenses, and using investigative accounting techniques. •Updated hundred thousand dollar budgets and grants with UCSC's financial information system FIS BANNER and InfoView. • Led and implemented investigative accounting with AT&T by reviewing contracts, past bills, and checks/warrants. • Used forensic accounting to reduce royalty payment made by EPC of $50,000.