Principal Consultant

Daniel J. Molitor San Diego, CA +1-317-***-**** ******.*.*******@*****.***

Professional Experience

Analytica Consulting, LLC San Diego, CA

Principal Consultant May 2020 – Present

• State of California, Dept. of Public Health/Dept. of Technology: Led design and development of data dashboards published on CA.gov, including engineering and automating underlying data pipelines for highly visible public pages such as Respiratory Virus Dashboard, COVID State Dashboard, Blueprint for a Safer Economy (aka County Tiers Dashboard), COVID Vaccine Progress Dashboard, and Shots for School Dashboard

• San Diego Citizens’ Law Enforcement Review Board: Coauthored study on deaths in custody, using econometric analysis to estimate the death rate disparity in San Diego County’s jail system unexplainable by demographics

• California Community College Chancellor’s Office, Policy Comparison tool: Defined tables and crafted dashboards to quantify and break down hypothetical and/or actual payments to the state’s Community College Districts under various policies as stipulated in historic, current, and/or proposed state legislation

• Edwards Lifesciences: Developed a suite of visualizations integrating data from Salesforce and proprietary systems, equipped with role-based security, enabling reps to see their performance by territory and product SmartDrive Systems, Inc. San Diego, CA

Senior Business Analyst Aug 2018 – May 2020

• Defined, scoped, and executed custom analytical projects for our management and internal partners

• Transformed, analyzed, and visualized data into actionable insights, predictive analysis and policy prescriptions

• Engineered and automated workflows using SQL, Python, and Alteryx in conjunction with AWS, SSMS, Postgres and MySQL databases to draw from and post to local and cloud-based locations Fitbit, Inc. San Francisco, CA

Senior Business Intelligence Analyst Jul 2016 – Aug 2018

• Established rigorous tables with Snowflake/SQL to transform and algorithmically model device event data

• Engineered ML forecasts using Scikit-Learn to improve staffing fit, generating substantial labor savings

• Designed Tableau Server dashboards for various audiences spanning the COO and VP to thousands of agents Federal Reserve Bank of San Francisco San Francisco, CA Research Associate Jan 2014 – Jul 2016

• Engineered Python, Stata, VBA and Matlab programs to assemble databases of economic variables, develop econometric models, test hypotheses, fit regressions, forecast projections, and automate dashboards

• Crafted data visualizations with tools such as twoway, ggplot, and seaborn

• Coauthored written and visual reports for audiences ranging from FOMC members to the public

• Wrote SQL queries, Spark scripts, and web scraping tools in pandas to quickly and reliably pull data Education

University of California; Berkeley, CA Jan – Aug 2015 Advanced Mathematics Coursework: Real Analysis, Linear Algebra (taken while working for FRBSF) Purdue University; West Lafayette, IN; Graduated with Distinction Aug 2008 – Dec 2011 Dual BS: Honors Economics, Behavioral Neuroscience Skills & Tools

Technical Specialties: A/B testing, Automated alerting, LTV Modeling, Financial analysis, Visualization, ETL/ELT, Forecasting, Machine Learning, Pricing models, Recommender systems, Regression analysis Technological Skills: Python, R, SQL, PySpark, SparkSQL, DAX, Alteryx, APIs, VBA/Excel, Azure Databricks, Snowflake, DBT, AWS, Tableau Server, D3, Git, Jira, Confluence, SSIS, SSAS, Jenkins, HTML Microsoft Power Platform: Power BI (PL-300 Certified), DAX, Power Automate, Power Apps Desktop Software: MS Office expert (incl. Access and Excel), Tableau, Windows, Linux, & Mac OS, command line Languages: English, French, German, Portuguese, Spanish

Contact this candidate