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 be used in Greenplumn using PLR and PGPSQL.Deployed a Tabular Model to give drag and drop access to audience Fulfillment data for Sales. This included complex DAX calculations to correctly depict various business rules for audience measurement.

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 and drill down capability to see episodic rating detail; 5.5 billion rows of possible output.Wrote SQL code to determine the company’s total inventory (ratings multiplied by commercial spots across all major Cable and Satellite companies who contribute commercial spots to be bundled).Created SQL SSRS report to track Subscriber and Universe estimates across all major Cable carriers.Used MLB schedule data and games out of first place to determine how time and a team’s competitive standing impact television ratings. Order data – Analyzed NCCs order data to pull out duplicate orders for overlapping flight dates. Also determined orders that were being undersold for high profile events.

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 visit limit equivalenceAssisted in the pricing of new mandates in Maine and New York; Calculated non-standard benefit relativities for Maine and New YorkProduced Serff filings for state review of new products and annual benefit changes for New YorkAnalyzed and calculated quarterly rate actions for MaineReceived an Impact Award for Maine rate action workCalculated competitor analysis for MaineValuation DepartmentAnalyzed actuarial lag models to determine monthly reserves.Automated reports from actuarial models in excel using VBA programmingPerformed edits to actuarial models using VBA programmingProduced Quarterly, semi-annual, and yearly Statutory Reports (HMO Products)Produced shock claims report using AccessPrepared data for multiple audits (Reg. 146 – new small group/large group controls were added as a result of the preliminary data findings)Analyzed and determined reserves for Aggregate and Individual Stop Loss (created model using company guidelines)Was responsible for preparing the monthly reserve booking sheet and coordinated with accounting for General Ledger entryParticipated in the complete remapping of all data elements used to produce lag triangles (Empire acquisition)

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 Housing Authority. Specific responsibilities included leading a team of interns to produce quantity estimates and a geographical information system (GIS). Also responsible for the development and coordination of the project website, QAQC scheduling of over 50 inspectors, excel and VBA spread sheet support.