Chicago, Illinois, United States
I love digging into complex problems and solving them. I research, design and build products that answer questions by telling stories. Fueled by data and an endless curiosity, I make information both beautiful and insightful to communicate the truth behind the trends. My passion lies at the intersection of form and function - between numbers in a spreadsheet and the many beautiful ways they can be brought to life.
-Lead analytics strategy for the Commercial Brand team, synthesizing multi-source data into concise, executive-level presentations that guide cross-functional decision-making and operational prioritization. -Manage external data vendors supporting specialty pharmacy and HUB reporting, ensuring accurate data feeds, timely issue resolution, and reliable performance insights. -Direct offshore analytics resources across multiple workstreams, prioritizing deliverables aligned to patient support objectives while partnering with cross-functional stakeholders to translate business needs into reporting solutions.
-Partner with Patient Access and Market Access teams to analyze patient journeys and provider access points, identifying network gaps and site of care opportunities using advanced segmentation and claims data analysis. -Develop interactive dashboards to monitor key treatment access metrics, enabling field and marketing leadership to refine infusion support strategies. -Build strong relationships with external vendors and internal cross-functional partners to ensure integrated patient support analytics and SOC optimization.
- Utilized SQL and PowerBI to develop dashboards aimed at enhancing copay support and overall patient experience metrics that communicated key findings to non-technical stakeholders. - Conducted detailed analyses on pharmaceutical data sources such as IQVIA, claims data, and specialty pharmacy data to extract insights related to patient behavior and copay support effectiveness. - Led proactive monitoring of Copay Assistance program performance from various angles to identify opportunities for improvement and optimization of patient experiences.
• Synthesize data and effectively communicate the performance of key metrics and initiatives to field employees and executive leadership using relevant visualizations. • Lead analytics efforts to measure goals and to keep a pulse on business operations initiatives. • Own the end-to-end design and implementation of PowerBI dashboards from database management to visual design.
• Responsible for the design, development and delivery of ad hoc and scheduled business intelligence reports to executive leadership and salesforce stakeholders utilizing SAS, SQL and VBA. • Performed weekly quality checks on database ecosystem; Identified, investigated and corrected data where quality was lacking. • Led organized team-wide initiatives to improve and automate existing reporting processes to increase efficiency and streamline delivery.
Data Analyst, Analytical Services Report to the Director of Analytical Services for one of the world’s largest coupon clearing houses that is responsible for over $4 Billion of client allocated funds annually. Develop reports based on coupon distribution and redemption data for clients that span some of the world’s largest beverage and food manufacturers. Responsible for report development and delivery on a scheduled and ad hoc basis, offer forecasting, and generating insights based on industry research. • Responsible for the development of custom internal and external client deliverables using SAS, SQL, and VBA from the initial data request and client interaction to the first and ongoing deliveries. • Design and implement dashboards that build a visual narrative with data. • Perform forecasts and customized offer analyses to help clients optimize the allocation of their marketing budgets. • Conduct industry research combining coupon offer redemption and distribution data as well as consumer survey information to generate industry trends and recommend best practices. • Validate the integrity and accuracy of proprietary forecast models through scenario testing.
Managed five projects spanning two engagements in the Marketing Analytics and Business Insights wing of AbbVie which deliver data, insights, and reports on pharmaceutical drug marketing and consumption. Responsible for report delivery, software development, data organization, and HR and infrastructure management. • Developed and maintained nine deliverables that spanned three drug franchises which were used for corporate reporting and analysis. • Oversaw end-to-end design, development, and implementation of a python-script data querying tool used to streamline the data pull process; significant effort coordinating with IT and business stakeholders to ensure functional requirements were met. • Successfully on-boarded over 40 new employees for the Mu Sigma AbbVie account while serving as the HR and infrastructure manager. • Maintained a high level of organization and communication while managing two offshore teams based in Bangalore, India.