Adam Sullivan Email & Phone Number

Chicago, Il, Us

Austin, Texas, Us

Austin, Texas, Us

- A founding members of the Data Science and Analytics Team at LP- Started LP’s Analytics dbt project - Stood up Fivetran for data integrations to our data lake- Built a dataset to train and run a customer churn prediction model- Built a data model to track LPs customer ARR changes

Chicago, Il, Us

• Built and maintained a dbt project that has grown to over 2000 models, from 50+ sources• Ran A/B experiments with the product team, running pre-analysis to determine how long the experiment must run to produce a meaningful result, and post experiment analysis to quantify the effect of the experiment• Developed a framework to easily setup and run experiments with the necessary data tracking, with marketing and servicing, using email, sms, and in app actions, attempting to get customers to return to the application funnel, purchase policies, download the app, and utilize self service features in the app• Analyzed our customer churn and drafted a write-up recommending a change in our product and renewal process, with estimated improvements to KPIs, which led to a 3% improvement in retention• Joined discrete datasets from multiple sources and developed a data funnel to provide metrics on all aspects of our application process• Developed a data model in our data warehouse to serve as the source for a reverse ETL process sending data back into our CRM• Review github PRs for the dbt project to maintain internal standards for the organization and structure of the project, design principles, and coding style• Parsed JSON data sources to feed into the data warehouse• Developed dbt tests to ensure data quality in our project• Developed data models and analytics for different areas of the business - payments, premium, application flow, cac, call center, servicing tickets, renewal flow, direct mail, email marketing, nps surveys• Migrated dashboards from Tableau to Looker• Mentored junior Analytics Engineers and Data Analysts• Ran morning scrum and assisted with prioritization of work for the team each sprint• Provided support to stakeholders in all areas of the business

Chicago, Illinois, Us

• Developed a Datamart hosted in AWS to house data from operations systems and spreadsheets, providing a more flexible space to build datasets for quick and accurate reporting, and detailed analysis• Created workflows in Dell Boomi to be ran nightly to pull data out of Salesforce, OpenAir, and Netsuite systems, load into a PostgreSQL database, and then trigger stored procedures on the database • Developed stored procedures to execute various tasks, including the logic to capture historical information that the source system does not capture natively, in the form of slowly changing dimensions• Wrote python scripts to automate processes for data flow in and out of a PostgreSQL database and google sheet files to support data sharing, analysis, or chart and slide creation• Created dashboards in Google Data Studio for operational metrics and reports, and executive level reporting• Developed transactional data feeds to be loaded into our new commissions tool on a nightly basis

Us

Actuarial/Data Science • Lead development of an ‘exposure file’ in SQL to improve actuarial analysis, comprised of all risk bearing premiums, attributes of the policies and coverages, along with any claims on the specific policies • Work directly with the VP of Claims on a project to improve MedPro’s large loss protocol by performing descriptive analysis of current claims, identifying various discrepancies in the process, and identifying additional variables that predict large losses using Python and predictive modelingData Warehouse and Reporting • Support data requests of all areas of the business • Develop ETL scripts in SQL to move data into the new policy data warehouse • Support finance teams to reconcile data on premium numbers to be used for internal and external reporting • Develop result data sets used for core metrics reports • Create data visualizations in Business Objects and Tableau for all divisions of the business for quarterly operating reviews • Develop and provide production support for Business Object reports, and Tableau dashboards • Administer the SAP Business Objects and Tableau systems used for enterprise wide reportingEnterprise Infrastructure Overhaul • Run workshops with business users of all departments to create use cases and develop process maps for the new CRM implementation • Work with internal team and outside vendor to profile data from all systems and build a data model accordingly, to implement a new MDM solution

Master'S Degree, Data Science

Bachelor Of Science (Bs), Informatics