Khristian Alvarez

– Worked on an intensive, project-based data analytics programme developed by LSE Methodology and Statistics faculty, integrating business strategy with advanced analytical practice. Gained proficiency in Excel, PostgreSQL/SQL, Python (Pandas, Matplotlib, Seaborn), R, Tableau, Git/GitHub, Jupyter, and Anaconda, applying these tools to real-world data challenges. – Queried a large PostgreSQL sales database to uncover trends and customer segments, identifying the most effective advertising channels by demographic. – Designed interactive Tableau dashboards to guide marketing and sales strategies. – Processed and analysed 27M NHS appointment records, visualising operational patterns with Matplotlib and Seaborn. – Modelled staffing optimisation and developed strategies to reduce waiting times; conducted Twitter data scraping to enhance engagement insights. – Applied k-means clustering to segment client groups and explored global sales data using R visualisations. – Built multi-linear regression models to analyse sales-marketing relationships. – Performed sentiment analysis on online reviews, providing actionable recommendations to improve satisfaction and brand loyalty.

– Worked as the Lead Data Analyst for Skeletal Support Incorporated, an orthopedic medical sales company based in Manila, Philippines. – Analyzed sales performance across orthopedic product lines (implants, braces, surgical instruments, rehabilitation devices). – Tracked monthly, quarterly, and annual sales trends by region, hospital, and sales representative. – Identified high-performing products and underperforming SKUs to support strategic sales decisions. – Monitored sales pipeline metrics, including order volume, conversion rates, and revenue growth.

– Executive leader in tourism governance, data-driven policy, and sustainable destination management led Pampanga's transformation into a model for evidence-based tourism planning and post-pandemic recovery. – Directed Pampanga's provincial tourism strategy, integrating analytics into planning, marketing, and performance evaluation. – Spearheaded the Tourism Development Plan, driving data-informed decision-making and stakeholder coordination. – Established the province's first digital tourism database, improving accuracy and accountability in tourism statistics. – Strengthened Pampanga's position as the Culinary Capital of the Philippines, boosting visitor arrivals and local enterprise growth. – Championed partnerships between government, industry, and communities to advance sustainable and inclusive tourism development.

– Supported the Chief of Staff in the Vice Governor's Office in legal research, policy documentation, and governance coordination. Contributed to institutional efficiency and compliance through data-informed legal analysis and streamlined administrative processes. – Conducted legal and policy research to inform executive and administrative decisions. – Assisted in drafting and reviewing contracts, memoranda, and provincial issuances for compliance. – Developed document tracking systems that improved transparency and reduced processing times. – Coordinated with provincial departments and external agencies to support policy implementation. – Prepared legal reports and summaries supporting evidence-based governance initiatives.