Principal Data Consultant

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

Summary

Meticulous and results-oriented Data Analyst with 10+ years of experience driving data-informed decisions. Proven ability to build robust data pipelines, develop insightful dashboards, and apply advanced analytical techniques to Professional simplify complex Experience problems, optimize organization performance, and drive business success. Analytica Consulting, LLC San Diego, CA

Principal Consultant May 2020 – Present

• Led the development and deployment of SQL procedures, views, and ETL pipelines in Snowflake using the package Python schemachange, bringing together tens of millions of records of infectious disease data for statewide analytics for the California Department of Public Health (CDPH)

• Led the design and programming of public and internal dashboards for CDPH, complete with automated data update solutions, bot-enabled instant message update notifications, and Selenium-enabled custom file uploads

• Coauthored a study for the San Diego Citizens’ Law Enforcement Review Board on deaths in custody, utilizing econometric analysis to identify disparities in the jail system unexplainable by demographics

• Developed a Policy Comparison tool for the California Community College Chancellor’s Office, providing an app UI to analyze payments under historic, current, and/or proposed legislative policy scenarios

• Created a suite of visualizations for Edwards Lifesciences, integrating data from Salesforce and proprietary systems, empowering representatives to assess their performance by territory and product SmartDrive Systems, Inc. San Diego, CA

Senior Business Analyst Aug 2018 – May 2020

• Spearheaded custom analytical projects, defining, scoping, and executing initiatives that drove strategic insights for management and enhanced and streamlined operations and processes for internal partners and their clients

• Created dashboards to visualize insights and yield recommendations, informing decision-making processes

• Engineered and automated workflows using SQL, Python, and Alteryx in conjunction with AWS, SSMS, Postgres and MySQL databases to efficiently 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 diverse audiences, from executive leadership to thousands of agents Federal Reserve Bank of San Francisco San Francisco, CA Research Associate Jan 2014 – Jul 2016

• Engineered Python, R, Stata, and Matlab programs to assemble databases of economic variables, visualize data, develop econometric models, fit regressions, forecast projections, and automate dashboards Education • Coauthored written and visual reports for audiences ranging from FOMC members to the public UC Berkeley; Advanced Mathematics Coursework taken while working for FRBSF Jan 2015 – Aug 2015 Skills Purdue & Tools University; Dual B.S., Economics and Neuroscience; graduated with Distinction Aug 2008 – Dec 2011 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, 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