Daniel Mason Email & Phone Number

Responsibilities include creating ETL, models, and APIs to support production at scale data science for Ampersand using Python, Argo, Athena, Clickhouse, and FastAPI.

Bloomfield, NJ

Created a Predictive Analysis to preemptively address audience fulfillment. Lamda architecture design. Data warehouse built in Greenplum. Statistical work done in R and has the capability of accepting new order attributes through command line.Created algorithms to provide new ways to combine audience to better reach the targets desired by customers

Bloomfield, NJ

Deployed an end to end process to give users across the company drag and drop access to our internal Sales data. This involved Syncsort as an ETL tool, multiple sources of TV programming data, required Greenplum to tag attributes to internal business data, and finally culminated in a Microsoft SSAS tabular model.Created fuzzy matching functions that could.

Greater New York City Area

Deployed a process to determine Cable TV ratings for high profile programming for all sellable geographies at NCC Media. Use Microsoft SQL server. First time programming schedule data had been successfully matched to ratings data. Output is viewable for all of sales through an SQL Server Reporting Services Reports (SSRS) web report with dynamic parameters.

Wrote VBA code to update monthly reserve file. Processing time decreased from half a day to 4minutes.Designed SAS and SQL queries to provide data for analysis

Developed pricing for new products and annual benefit changes for the states of Maine and New YorkProvided an analysis that was incorporated into the company pricing model for 4th Tier RxAnalyzed Health Care Reform impacts for preventive care in Maine, New Hampshire, and ConnecticutAnalyzed Health Care Reform impacts in Maine for dollar limit removal and.

Prepared STAAD structural models for a Carnival Cruise Terminal in Belize to analyze the structure for earthquake, mooring, berthing, wind, and wave forces.Provided inspection management support for the documentation of condition, severe maintenance requirements, needed repairs, and capital planning needs of 3,500 buildings belonging to the New York City.