Data Analyst
Current• Developed a sales dashboard for potential clients that illustrated the quality and price information their members would see, with geocoded data, and market-specific or healthcare-network-specific models.• Rebuilt a legacy Python-based notebook into a direct SQL query to benchmark client performance over multiple years, analyzing ROI and the impact on healthcare quality outcomes for members.• Developed reporting for a new RX product that helps client members find quality prescription drug fills at lower costs by showing them alternative brands, generics options, or similar drugs.• Automated the primary product's engagement report--which was previously run ad-hoc on a client-by-client basis—to run within the web portal for all clients, enhancing efficiency and accessibility; removed a significant workload from the client-analytics team.• Migrated SMSS reporting code, ran ad-hoc, to new workspaces in Databricks and automated the processes, improving workflow and reducing manual intervention.• Responsible for bespoke, ad-hoc monthly reporting for my employer's largest client.• Developed and presented interactive dashboards to clients using Power BI and Tableau, aiding in cost transparency and decision-making.• Collaborated with cross-functional teams to identify client needs and deliver tailored analytical solutions.• Conducted data cleaning and transformation processes to ensure high-quality data analysis.
