San Diego, California, United States
Senior Data Analyst focused on automation, SQL-based modeling, and data reliability. I build systems that make analytics faster and clearer—from attribution reconciliation and forecasting to partner dashboards and executive reporting. Experienced with SQL, Python, Tableau, and R, I emphasize clean data, reproducible logic, and effective collaboration between technical and business teams.
• Built reconciliation between Everflow postbacks and LOS loan records using SQL and Python—defined match logic, QA checks, and partner-ready files that standardized attribution review and accelerated discrepancy resolution. • Enhanced revenue-share invoicing workflow through improved SQL and QA logic, Tableau-based validation, and standardized partner reporting that reduced clarification requests. • Developed regression-based Halo Effect model quantifying incremental organic disbursements to guide marketing budget allocation. • Built flagship Tableau dashboards used by executives to monitor funnel KPIs and by Marketing to generate consistent, data-driven visuals for partner presentations.
• Designed Cost-of-Acquisition (COA) calculator integrating approval, disbursement, and attribution data; improving forecast accuracy to 80 %+. • Contributed to dashboard development and data hygiene improvements in SQL and Tableau. • Supported Marketing with partner performance analysis and ad hoc reporting requests.
• Automated exploratory data analysis and statistical testing of SAMHSA client data in R. • Created Python web-scraping script to collect and parse potential client data, accelerating outreach and saving manual research time. • Designed concise internal R tutorials to improve team familiarity with automated data analysis workflows.
• Built automated R Shiny and flexdashboards tracking key program KPIs and finances, improving visibility for leadership. • Led analytics project assessing the viability of remote service delivery; integrated findings across multiple analysts and presented results to executives. • Automated financial reporting in R using flexdashboard, consolidating disparate data sources into a single, consistent workflow. • Redesigned Program Analyst onboarding, reducing ramp-up time by ~75%.
Developed multi-source dataset on Middle East protests; refined data collection workflow and documentation practices.
Maintained SPSS and R code for data cleaning and dashboard reporting; improved accuracy of client deliverables.