Jana C.
Freelance Business Intelligence Consultant
Experience
Jul 2024 - Present
1 year 3 monthsFrankfurt, Germany
Freelance Business Intelligence Consultant
Superprof Germany & Upwork
- Design an interactive Tableau dashboard to analyze historical aviation accidents, using data from the Federal Bureau of Aircraft Accident Investigation
- Develop visualizations to provide actionable insights to improve aviation safety measures, employing data modeling and transformation techniques
- Develop a Power BI dashboard to monitor sales KPIs and product performance, integrating data from multiple sources
- Design a star schema data model and implement advanced DAX measures for high-performance and dynamic reporting
- Design a comprehensive BI architecture solution, focusing on ETL pipelines, data integration, and data governance
- Recommend Power BI as the central tool and create a security-compliant implementation roadmap
Feb 2024 - Jun 2024
5 monthsFrankfurt, Germany
Business Intelligence Developer
Computop Paygate GmbH
- Build and maintain dashboards in Qlik Sense, using Visual Studio Code for scripting and customizations
- Handle development requests through JIRA tickets, ensuring timely delivery of BI solutions within an Agile framework
- Collaborate with teams, documenting project requirements and workflows in Confluence as part of the Agile methodology
- Design and optimize KPIs to improve data visualization and provide actionable insights for stakeholders
- Maintain the BI system, offering ongoing support and ensuring smooth operations
Oct 2020 - Feb 2023
2 years 5 monthsBeirut, Lebanon
Senior Business Intelligence Analyst
CMA CGM - Levant Regional Office SAL - Digital Center - The Hub
- Develop and optimize Qlik Sense dashboards using Visual Studio Code for scripting, tracking real-time vessel schedules, and shipping lane performance, enabling real-time operational adjustments
- Design and implement ETL workflows to extract, transform, and load data from logistics databases ensuring accurate, high-quality insights for logistics teams
- Execute SQL queries for on-demand analytics providing actionable insights to improve cost efficiency and resource allocation
- Deliver advanced data visualizations on inventory turnover, demurrage, and vessel performance, supporting operational and strategic decision-making across commercial and supply chain teams
- Collaborate with the Data & Digital Factory in Marseille to enhance BI solutions in an Agile environment, delivering tools that optimize shipping routes, fuel usage, and supply chain visibility
- Create scalable, intuitive dashboards that automate reporting for cross-functional teams, cutting reporting time and improving the speed of logistics and fleet performance decisions
Aug 2017 - Sep 2020
3 years 2 monthsBeirut, Lebanon
Junior Business Intelligence Analyst - Financial Analysis & Planning
Bank Audi S.A.R.L
- Develop and deploy interactive reports and dashboards using Oracle Business Intelligence (OBIEE) and QlikView for financial analysis and planning
- Analyze financial data and create advanced reports in Excel, including pivot tables, data modeling, and complex formulas
- Collaborate with product managers to align data analytics strategies with the Retail Department's objectives
- Analyze customer data to generate insights and support strategic decision-making
Aug 2015 - Nov 2015
4 monthsBeirut, Lebanon
Intern
United Nations Development Programme
- Contribute to the production of Lebanon's Monthly Economic Brief, conducting analysis on key economic indicators
- Assist students with academic research papers, providing guidance on methodology, data analysis, and writing
- Co-instruct graduate-level courses, including Macroeconomics and Financial Economics, supporting faculty in teaching and curriculum development
Jun 2015 - Jun 2017
2 years 1 monthBeirut, Lebanon
Research Assistant
American University of Beirut
- Conduct research on various economic and financial topics, contributing to academic and policy-focused studies
- Assist students with academic research papers, providing guidance on methodology, data analysis, and writing
- Co-instruct graduate-level courses, including Macroeconomics and Financial Economics, supporting faculty in teaching and curriculum development
Summary
Business Intelligence Analyst with over 7 years of experience in translating business requirements into clear data stories and impactful BI dashboards.
Experienced in requirement gathering, data analysis, dashboard development, and reporting across finance, supply chain & logistics, and tech sectors.
Proficient in Power BI, Qlik Sense, Tableau, and SQL for transforming complex data into actionable insights.
Skilled in designing ETL workflows, building interactive dashboards, and optimizing KPIs to support data-driven decision-making.
Experienced in working in Agile environments, collaborating with crossfunctional teams, and delivering scalable BI solutions aligned with strategic business goals.
Languages
Arabic
NativeEnglish
NativeGerman
IntermediateFrench
ElementaryEducation
Sep 2014 - May 2016
American University of Beirut
Master's Degree · Financial Economics · Beirut, Lebanon
Sep 2011 - Jul 2014
University of Balamand
Bachelor's Degree · Economics · Lebanon
Certifications & licenses
Elements of AI
University of Helsinki
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.