Diana Lam Email & Phone Number

• As a Business Intelligence (BI) Analyst at Skånemejerier, I am responsible for data visualization and maintaining and creating new dashboards using Qlik applications, data modeling and SQL querying. My role focuses on.
• Qlik Report Development, Maintenance and Administration: I design, develop, and administer interactive dashboards and reports using Qlik Sense and QlikView. My focus is on creating intuitive visualizations that provide.
• Gathering of Business Requirements: Collaborating with cross-functional teams to identify and address business challenges, resulting in streamlined operations and cost savings. This process involves understanding.
• Data Modeling: I conduct data modeling to create robust data structures that support efficient reporting and analysis. This includes designing schemas, defining relationships, and ensuring that data is organized in a.
• Backend ETL with T-SQL and SQL: I oversee backend processes utilizing an ETL tool to effectively extract, transform, and load data into our data warehouse. Additionally, I leverage T-SQL to design and create tables and.

Lund, Skåne County, Sweden

• My responsibilities as a data analyst at Parlametric includes data collection, data cleaning, data analysis, data visualization and presentation. I have:
• Managed a 30+ client portfolio with businesses from multiple industries including telecom, energy, municipalities, sport clubs, tourism.
• Responsible for pilot projects demonstrating analysis capabilities resulting in 5+ multi-year deals increasing year-on-year revenue by 35%.
• Responsible for data storytelling and data visualization tailored to upper, middle and lower management in small to large sizes companies.
• Managed projects with more than 100,000 data points.
• Part of a team responsible for the launch of a new data collection chatbot used on websites to collect data and to streamline processes.

Malmö, Skåne, Sverige

• Responsible for building and establishing the company brand through different marketing channels.
• Used Google Analytics to track and follow up on KPIs to determine the success of different marketing initiatives.
• Carried out market analysis to understand the prospects of opportunities for the fill and finish injectable market.
• Created and had ownership of the company webpage in WordPress, where I had a customer centered focus. The focal point was on design, content, and useability of the website. This has led the company to receive +30%.
• Worked with SEO, which has resulted in a top page search ranking for specified key terms on Google search engine.
• Increased visitor traffic to the website with 50% every year.

Malmö, Skåne, Sverige

• I was responsible for coordinating tours with transport and guides, worked with inquiries from different stakeholders to ensure their concerns and questions were addressed. In addition, I was responsible for:
• Prepared invoice statements and calculated invoice prices.
• Created company webpage in WordPress.
• Contacted stakeholders to promote our services and to generate more revenue during low season.

London, England, United Kingdom

• 6 month internship as part of my BSc in Business Administration.My role as an Operations Assistant meant I had responsibility for the entire process of the contributor workflow.
• Finding contributors and managing the content on the Finance Gofer website.
• Researching potential companies and individuals.
• Contacting potential stakeholders.

London, England, United Kingdom

• 6 month internship as part of my BSc in Business Administration.I was working in the Client Services Team (Retail & Customer Insight Team). My main responsibilities included
• Helping out with project management tasks of mainly quantitative market research studies.
• Data checking and data analysis
• Created templates for PowerPoint presentations.
• Prepared Excel based reports and translation of questionnaires.

Bachelor'S Degree, System Science

Bachelor's degree in data and systems science with focus on databases. SQL, programming in Java, business intelligence (BI) and data mining.

Chinese Language And Literature

60 HP Chinese language with one semester abroad at Beijing Foreign Studies University.

Master'S Degree, Business Excellence

A one-year master's degree with courses in leadership and business management.

Bachelor'S Degree, Business Administration

Bachelor's degree with focus on marketing, statistics, finance and operations.