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.
• 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

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.
• 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

Master'S Degree, Data Science

Bachelor Of Science (Bs), Informatics