Lucas Hadin Email & Phone Number

Gothenburg, Se

Gothenburg, Se

Gothenburg, Västra Götaland County, Sweden

Gothenburg, Vastra Gotaland County, Sweden

Ad Hoc Analysis and Insights:• Worked with team members to fine-tune their questions and truly understand requirements.• Dived deep into complex questions and learn the root cause of issues or behaviours.• Shared findings and made recommendations for ways to improve.• Did complex analysis and report creation in Excel or Jupyter. Dashboards and Reporting:• Identified and defined key metrics and KPIs. • Designed and built interactive and user-friendly dashboards with Power BI to give everyone real-time insights.• Used SQL, Python, and PowerQuery to wrangle and automate the data for visualisations.Data Science:• Created user segmentations based on behaviour using clustering algorithms like k-means.• Built models to predict engagement and churn, using methods like logistic regression and random forests.• Ran A/B tests to see how new features and changes performed.• Created personalised recommendation systems from scratch using collaborative filtering to improve user experience.• Forecasted KPIs with regression analysis and time-series models to help with planning.• Simulated different scenarios using methods like Monte Carlo to predict possible outcomes.• Deployed models on AWS using Serverless and Docker. Data Engineering:• Turned raw data into structured formats ready for analysis and reporting.• Combined data from various sources into a central data warehouse with clear schemas.• Set up automated data flows using SQL and Python. • Monitored data pipelines and set up alerts to catch and fix issues early.Data Collection:• Decided what data to track, when to send events, and what details to include.• Wrote technical documents outlining how data should be tracked for the engineers to implement.• QA’d the data output to ensure it was accurate and reliable.• Created new tracking events

Gothenburg, Vastra Gotaland County, Sweden

Statistics/Machine Learning• Regression/Classification: Linear regression, logistic regression, random forest • Clustering: hierarchical, k-means, archetypal• Association: Correlation, Pearson’s R• Descriptive Statistics: Measures of frequency, central tendency, variation, and position• Split testing: A/B, Multi-variate• Technologies/packages: Scikit-learn, Pandas, NumPy, Scipy, Seaborn, MatplotlibDashboards• Visual design and mock-ups• Data structure of underlying data• Automation of data flows• Dashboard creation and deployment• Technologies: Tableau, PowerBI, Dundas BI, ExcelForecasting• Key metrics (dependent on project)• Accounting metrics: Revenue/Costs/profit• Techniques: simple/multiple linear regression, seasonal, ARIMA, moving average, exponential smoothingAutomation• Daily/weekly ETLs • Excel + ODBC + VBA for ‘single click’ updating of reports • Web scraping• Technologies: Jenkins, Task Scheduler, SSIS, Python, VBAData Architecture (Collection/Management)• Designing data hooks and overseeing implementation• Contributing to database schema/structure• Contribute to ETL (Extract/Transform/Load) design• Technologies: Redshift, Hive, Snowflake, SQL Server, MySQLReporting and Ad hoc Analysis• Isolating underlying question• Selecting data and techniques to best answer the question• Analysing data and uncovering insights• Reporting to stakeholders and following up• Technologies: Excel, Python, PowerPointProblem Solving• Root cause thinking• Hypothesis testing• Working in a strategic and tactical setting Project Management• Agile/Scrum Methodology• Scoping and estimating projects• Delivering to scope and on time• Delegation and team direction on larger projectsSoft skills• Ability to communicate complex ideas simply• Relationship building and networking• Story-telling and presentation• Recognising opportunities and taking initiative for new projects/methodologies

Sydney

Senior Data Analyst at MercerBell - a digital marketing agency in Sydney with a focus on data-driven work. Clients include Toyota (automotive), MasterCard (financial services), Foxtel (TV), David Jones (retail), BT (finance) and Nestlé (food retail).Highlights:• Project management of jobs including estimating time and costs, meeting deadlines and ensuring jobs are profitable.• Written and verbal presentations to show results to existing clients or to showcase previous work and case studies to sell in ideas to prospective clients.• Trained, coached and managed one junior analyst and several freelancers. Responsible for managing resourcing and ensuring quality of work. • Analyst duties as below.

Sydney, Australia

Data Analyst responsible for a variety of analytical tasks (see professional skills below) by using programming and software tools. Using analysis to solve business problems. Highlights:• Working with very large data sets (100+ million rows) in SQL databases.• Using statistical methods such as linear regression, propensity modelling, clustering and correlation to help solve business questions.• Building custom reporting dashboard in Tableau and Excel. Automating flow of data from multiple sources into one single location and scheduling automatic updates.• Automating processes using SQL or Excel (VBA) to save time and money. • Taking data from it’s raw form, to summarised results, to data visualisation and finally to a presentation or report. • Very strong understanding of marketing and data analytics in that context. Experience with web and email analytics with platforms such as Google Analytics, Omniture, Marketo or Exact Target.

• Data Analysis and Forecasting- Market/Competitive analysis- Internal forecasting: • Preparation and manipulation of research data

• Ski instructor (all ages and all levels)• Building relationships with clients, enhancing their experience• Group handling, class management

Research and analysis for private consulting firm specialising in parking and traffic projects • Contracted work, ad hoc projects • Market research, interviewing, data analysis and modelling, economic research • Field research and on-site data collection at client sites • Data entry and manipulation for site studies and forecasting models

Lake Tahoe, California, Usa

B. Economics, Majors In Economics & Finance, Minor In Marketing

Activities and Societies: Sydney University Boarding and Skiing Club, Athletics Club

Higher School Certificate