Barcelona, Catalonia, Spain
I have over 6 years of experience in data extract, transformation and analysis using SQL, Snowflake and with experience also in Python and R. - Create reports and share insights for business revenue, customer segment analysis, A/B testing. - Create and maintain dashboards (Tableau, Microsoft PowerBI, Microstrategy) for different business areas such as Strategy, Marketing/Sales, CRM (Email Campaign performance) and Online/Digital Marketing (Funnel analysis) working with various teams such as Product, CRM, Strategy, Marketing, Merchandise in various industries such as e-commerce, Consumer Packed Goods (CPG), HR Consulting (Rewards and Compensation), Supply Chain. - Experience in creating custom reports and analysis with Google Universal Analytics - Initiation to GA4 Learning: dbt Tech stack: MySQL, Snowflake, Tableau, Microsoft PowerBI, MicroStrategy; Coded in Python and R for Masters and internship stints Speak fluent English and Spanish (professional proficiency)
Stack/Tools: BigQuery, dbt, Tableau, Amplitude, Rudderstack, Split, Vscode, Git, Hightouch, Mage.ai, HubSpot
E-Commerce Fashion Industry Partner with cross functional teams in the e-commerce fashion industry in understanding and improving customer shopping behaviour using qualitative and quantitative data. Analyse and provide insights to inform business strategy and operations head in areas of improvement across functional areas in Marketing, CRM, Product, Merchandising and Operations teams. Reporting directly under Strategy and Operations head • Cohorts and LTV • Transform and manage datasets (SQL, Snowflake) • Data Analysis (Excel, Google Analytics) • Data Visualization (Tableau, Microstrategy) • A/B Test performance analysis with Customer Segmentations • Create, Design and Maintain Dashboards • Results and Insights sharing with business stakeholders Tech tools: SQL, Snowflake, Google Analytics 360, Tableau, Microstrategy
Demand Planning in Supply Chain and Logistics Industry • Modify existing codebases to measure model performance and accuracy for forecasting product demands. • Conducted analysis on product segmentation based on item description through tidying and text mining with R to test for better identification, segmentation that helps improve forecast demand accuracy. • Developed visualisations with Tableau • Created diagram flows to synthesise and document process flows • Modified and wrote SQL scripts to analyse and perform specific data queries
BTS Master's in Big Data is a full-time intensive on campus program co-organized with Eurecat,the largest Technology Centre of Catalonia leading the Big Data development in Barcelona. The program focused on: • Data-Driven Ecosystem • Data Science (Foundations, Algorithms, AI, Data Exploration, Preparation, Analytics and Visualisation), • Python, SQL • Statistics & Programming • Data Engineering (Big Data Ecosystem, Ingestion & Storage, Cluster Management, Infrastructure & Cloud) • Business (Entrepreneurship, Big Data Applications (customer analytics, logistics, Social Media), Digital Business / Online Marketing, Agile, User Experience, Legal & Security, Innovation) • Capstone Project - group of 3, developed Predictive Maintenance (PMQ) algorithm for diagnosing machine health
Marketing Research in Fast Moving Consumer Goods (FMCG) Industry As a Client Executive, I worked closely with a large multinational and local firms to measure overall sales performance and identify demand patterns and causes of decreased sales. • Perform and presented a detailed marketing sales analysis and recommendation for product sales strategy to reach company target of 10% sales increase within one month • Built a data flow to automated report production that result in 25% decreased time spent in manual reproduction weekly • Conduct competitor and brand analysis for new product launches • Design strategy to predict and reach target sales • Perform regular data validation, analysis and reporting • Extract and analyse trade and household sales data to derive industry patterns • Develop and deliver presentations on marketing trends and insights to clients • Led the renovation of a report generation tool to visualise product performances and KPIs by categories that provide quick and easy access to data that enabled fast data-driven decisions for the R&D, sales and marketing department