Blanca Castillo

• Developed reports to monitor supply quality, churn, net promoter score, and conversion rates across the booking funnel • Led the transition of scraping operations from an outsourced to an in-house solution • Automated reporting processes and implemented automated notifications • Investigated lead issues and measured the impact of strategic product changes and campaign investments on lead data quality • Collaborated with multiple teams to design systems that monitor key projects

• Optimized the lead generation pipeline by automating and designing new lead sourcing and cleaning strategies in Google Sheets, effectively lowering processing time for 300+ daily leads from 4h/day to 30min/day • Built dashboards in Freshworks Analytics, Google Sheets and Tableau to monitor sales manager performance, ensuring accurate sales commission calculations and objective performance reviews

• Facilitated the Allianz Customer Model (ACM) rollout and initiatives tracking across 15 global Allianz entities • Administered collaboration tools, i.e. Confluence and Jira, to maintain and organize all ACM information assets

• Controlled the traffic of TV spots to 250+ stations across 60+ designated market areas (DMAs) in the US • Created competitor analysis reports in Excel to assist with the buying process for all DMAs

• Forecasted call volume and calculated optimal staff allocation through Excel and VBA models • Monitored KPIs and workforce metrics to generate weekly reports for mid- and top-level management

• Handled 15+ calls per day to provide remote tele-health services to customers across 25 US States

• Generated weekly Excel reports on product returns and non-conforming raw materials, processes and products • Performed on-site quality control inspections to assess the effectiveness of action plan implementations

• Awarded Women in STEM Scholarship, GPA: 2.1/1 • Relevant Coursework: Data Science, Machine Learning, Predictive Analysis, Risk Modelling • Thesis: Investigated the impact of e-waste awareness on consumer perception towards the right to repair through A/B testing

• Awarded Academic Excellence, GPA: 93.84/100 • Thesis: Analyzed the reduction of caustic soda in the clean-in-place process at Compañía Cervecera de Nicaragua, leading to a projected annual saving of 57% in resource costs