Daniel Molitor Email & Phone Number

San Diego, California, United States

-State of California, COVID-19 Data Task Force: Led design and development of COVID-19 data pipelines and dashboards published on CA.gov, including data and graphics for such highly visible public pages as the Respiratory Virus Dashboard, the COVID-19 State Data Dashboard, the Blueprint for a Safer Economy (aka County Tiers dashboard), and the Vaccine Progress Dashboard.-Community College League of California, CEO Tenure Dashboard: Upgraded table and dashboard designs for performance and UI factors; presented demo and report for large audience of Community College executives-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 sales operations analytics solution integrating data from Salesforce and proprietary data systems for a suite of visualizations equipped with role-based security, enabling both internal and external sales reps to see their performance by client, territory and product

San Diego, Ca

-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-Designed, automated and streamlined aggregation and analytical workflows using SQL, Python, and Alteryx-Developed interactive Tableau reports presenting analytic results in intuitive and engaging visualizations-Maintained multiple Tableau Servers, serving various audiences including hundreds of client companies

San Diego, Ca

-Established rigorous datasets with SQL, drawing from raw event data to aggregate, transform, and summarize-Engineered ML forecasts from scratch with Python and Stata, improving staffing fit and generating substantial labor savings-Developed extensive and flexible Tableau reports, providing management comprehensive visibility into data-Designed dashboards on Tableau Server for various audiences including thousands of external agents-Coded Python, Stata, and VBA programs to produce insights, advise corporate policy, and automate alerts

San Francisco, Ca

-Engineered Python, Stata, Matlab, and R programs to assemble databases of economic variables, develop econometric models, test hypotheses, fit regressions, forecast projections, and estimate impulse responses-Crafted beautiful and enlightening data visualizations and tabular reports of analysis by self-taught use of tools such as twoway, esttab, pandas, and seaborn, as well as from within Tableau, eViews, and Excel-Tailored written and graphical reports for audiences ranging from academic economists to the general public, including a housing market report which ranked among the Bank’s Top Ten Economic Letters of 2015-Composed SQL queries, Spark scripts, and webscraping tools in pandas to quickly and reliably pull data-Used VBA to automate tables and charts for Bank's submissions to the Federal Open Market Committee-Provided editorial and research support for the speeches of Bank President John Williams

San Diego, Ca

-Wrote predictive algorithms to interpret and categorize open-ended user input across over 50,000 records-Designed and maintained department's Access database; wrote VBA macros to clean and merge datasheets -Generated data visualizations and dashboards reporting department performance for executive team-Connected mortgage loan officers with best-effort (live market) pricing from investors in mortgage-backed securities-Locked interest rates and pricing for mortgage borrowers on a scale of over $25 million in principal per month

Indianapolis, Indiana Area

-Conducted audits of wholesale mortgage submissions for compliance with industry regulations and internal standards-Rejected noncompliant loan submissions; approved and distributed compliant loan disclosures to borrowers-Maintained corporate database; checked others’ entries for accuracy and compliance-Liaised with loan brokers to address discrepancies and collect missing documentation

Washington, Dc

-Researched and wrote policy memos for various audiences specializing in mortgage finance and housing policy-Supported Congressional testimony with data collection, data visualization, and policy research-Created Excel PivotTables to analyze performance of Federal Credit and Loan Guarantee Programs-Collected, summarized, and distributed news items in daily digests

Coursework In Mathematics

Dual B.S., Economics, Behavioral Neuroscience

Education record

Academic Honors Diploma