Results-driven Data Analyst with 5 years of experience turning complex data into clear insights to support business decisions. Skilled in SQL, Excel, Power BI, and Python for data analysis, reporting, and dashboard creation. Strong background in data cleaning, visualization, and stakeholder communication. Proven track record of driving efficiency, improving reporting processes, and delivering data-backed solutions across e-commerce industries.
In this role, I:
1. Launch strategic initiatives that generate €300K in revenue within 6 months, with zero capital investment.
2. Generate €100K in incremental revenue in 2 months through dormant client reactivation, contributing to an expected €500K+ annual uplift.
3. Support B2C business operations by proactively taking on additional responsibilities as a Product and Web Analyst, driving data-informed decision-making and contributing to product performance optimization.
4. Collaborate with leadership to share key performance insights and work with Finance to support budget forecasting and profit & loss management.
5. Collaborate on projects led by external consultants to enhance B2B client segmentation and improve sales strategies.
6. Perform cohort analysis to assess client retention patterns and improve customer engagement strategies.
7. Develop and maintain interactive dashboards and reports using Amazon QuickSight to provide real-time, accurate data for monitoring key performance metrics.
8. Streamline weekly reporting by automating processes, saving 4+ hours of manual work per week (Tools used: Salesforce, QuickSight, Redshift).
9. Collaborate with data engineers to optimize ETL pipelines, data warehouses, and database structures, ensuring clean, accurate, and well-structured data for analysis.
10. Establish and maintain SOPs to improve data governance, streamline workflows, and enhance efficiency in data-related processes.
11. Conduct training sessions and workshops to help teams interpret and utilize data effectively in their decision-making.
In this role, I:
· Delivered data insights to support client projects around hotel sourcing and dynamic program management, using tools like Excel, Power BI, and SQL.
· Cleaned and validated large datasets, filled data gaps, and turned raw data into clear, useful insights.
· Built dashboards and reports with key metrics to help clients make informed decisions faster.
· Created and maintained documentation, SOPs, and test plans to support automation and improve team efficiency.
· Mentored junior data specialists and led training sessions, including a workshop for 150+ attendees.
· Drove tangible results—saved clients $1.2M through advanced SQL reporting, improved templates to save 3+ hours weekly, and built a sourcing workbook that boosted client retention by 22% during COVID.
In this role, I:
• Prepared specifications logs and assisted project consultants/developers with essential backup.
• Analyzed e-streaming data, offering detailed client insights on bookings and desired market segments.
• Built a performance dashboard for program managers, facilitating strategic partnerships with clients and service providers.
• Identified non-compliant travels, achieving an 89% compliance rate increase from 76% through pre-post analysis.
• Created custom reports and presentations, incorporating robust data visualization and storytelling techniques.
Data Analysis & Visualization: Excel, Power BI, Amazon QuickSight & Looker
Databases and Querying: SQL, Relational Databases (MySQL, Redshift)
Programming and automation: Python (Pandas, NumPy, Matplotlib, Seaborn), VBA, or basic scripting for process automation
Data cleaning and transformation: ETL processes, data wrangling and validation, handling missing or inconsistent data
Statistical Analysis & Forecasting: A/B testing, regression, correlation, distributions, trend analysis, predictive modelling
Analytical and soft skills: stakeholder management, project governance, trend analysis, predictive modelling, collaboration with cross-functional teams