
Fabian
Business Analyst Marketing / Social Media Expert
Male29 y/oMarketing/Sales business analysisLive in GermanyNationality Germany
Share
Summary
Results-driven Business Analyst with over 4 years of experience in leveraging data analytics to drive marketing strategies and business growth. Proven track record in data visualization, data analysis, and data modeling. Adept at using tools like SQL, PowerBI, and Excel to deliver actionable insights. Passionate about using data to solve complex business problems and optimize marketing performance.
As a Social Media Expert with over 200,000 followers across multiple platforms, I am skilled in developing and executing data-driven social media strategies that increase engagement, grow audiences, and drive brand success. With a strong foundation in content creation, analytics, and community building on Instagram, TikTok, and other platforms.
I am excited to apply my expertise to opportunities in the Greater Bay Area, where I studied before and am eager to contribute to the region's dynamic business landscape.
Work experience
Business Analyst Marketing & Pricing
OTTO GmbH & Co. KG2021.08-Current(4 years)• Comprehensive data collection and analysis of pricing and marketing activities, identifying causal relationships and optimizing campaign management. e.g. assortment evaluation recurring campaigns vs. decimation campaigns, KPI based product selection for campaigns • Data Modelling & visualisation: Created and refined data models using Power BI to integrate and visualize data from various sources, ensuring accurate and actionable insights for 250+ users while reducing their reporting time by 20%. • Stakeholder Management: Managed effective stakeholder relationships, providing proactive support, iteratively refining requirements, and establishing feedback loops to ensure alignment and satisfaction.Social Media Manager
foreignfootprints2023.06-Current(2 years)Instagram: 127K Followers | TikTok: 73K Followers | 100M+ Views Successfully grew Instagram and TikTok followings to 127K and 73K, respectively, through targeted content creation, audience engagement, and trend adaptation. Generated over 100 million total views across both platforms by leveraging video content, strategic posting, and user-generated content campaigns. Developed and executed comprehensive social media strategies that boosted brand awareness, audience engagement Managed influencer collaborations and brand partnerships Utilized analytics tools (Instagram Insights, TikTok Analytics, etc.) to track performance and optimize content for maximum reach and interaction. Expertise in using creative, data-driven approaches to achieve high engagement rates, with an average engagement rate of X% on both platforms.Digital Analyst Marketing
OTTO GmbH & Co. KG2020.10-2022.02(a year)• Master Thesis: Development of a Customer Cohort-Based Decision Support System in E-Commerce (SQL and Microsoft Power BI) • Cohort Formation & KPI Assessment: Conducted an in-depth assessment of potential customer cohorts and key performance indicators (KPIs) within the e-commerce environment, laying the foundation for data-driven decision-making. • Retention, Churn, and RFM Analyses: Performed comprehensive Retention, Churn, and Recency- Frequency-Monetary (RFM) analyses, providing actionable insights to improve customer retention strategies and reduce churn rates. • Behavioural Trend Analysis: Conducted year-over-year and month-over-month evaluations of changing customer cohort behaviour, identifying trends and patterns to inform strategic planning. • Cohort Evaluation & Characterization: Analyzed customer cohorts to identify characteristics of high-value cohorts, such as demographics, product preferences, purchase timing, and coupon usage, enabling targeted marketing efforts. • Customer Quality Assessment: Analyzed the usage behaviour of coupon codes by customers, assessing customer quality and determining if OTTO customers primarily generate sales through promotions or coupon codes, providing insights for promotional strategy optimization. • Comprehensive Reporting: Generated and analyzed reports using Adobe Analytics, covering over 400 brands, 50+ customer insights, 50+ product detail and theme pages, and 30+ search terms/keywords, delivering detailed insights to drive business decisions across various business units. • Report Process Automation: Automated the report request process, standardizing the distribution and storage of reports, significantly improving efficiency and reducing manual workload.Procurement Controlling
Siemens Healthcare GmbH2019.02-2021.01(2 years)(Healthineers) Forchheim, Germany • Reporting & Presentations: Managed monthly and quarterly reporting, created management presentations, and conducted ad-hoc analyses on procurement-specific KPIs. • Supplier Ratings & Risk Assessment: Developed supplier ratings and assisted in assessing supplier default risk during the pandemic. • Cost Analysis & Optimization: Performed cost analysis to identify savings opportunities and optimize procurement processes. • Supplier Performance Monitoring: Monitored supplier performance and compliance with contract terms, ensuring quality and reliability.Dual Study Program
Kramp GmbH2016.02-2019.09(4 years)Export Sales: • International Sales: Managed orders, quotations, customer service, and pricing for diverse cultural backgrounds. • Market Analysis: Analyzed emerging markets (e.g., Egypt, Japan) to drive growth. • Webshop Optimization: Enhanced the Kramp export webshop, boosting user experience and sales. Finance & Controlling: • Financial Reporting: Month-end and year-end closings for the DACH region. • Budgeting & Forecasting: Assist in budgeting and forecasting processes. • Accounts Receivable: Managed AR, optimizing cash flow. • Scenario Analysis: Conducted sales and logistics cost analyses. Logistics: • KPI Management: Optimized KPIs for inbound and outbound logistics. • Project Management: Planned and executed warehouse expansion milestones. • Post-Sales Support: Managed guarantees and returns to ensure customer satisfaction. • Tech Integration: Evaluation of wearable technologies to enhance logistics. • Talent Acquisition: Managed job postings, interviews, and post-interview processes. • Employer Branding: Represented Kramp at job fairs, promoting dual study and apprenticeship programs. • Training Coordination: Organized job training programs. • Performance Documentation: Created performance certificates for departing employees.Apprenticeship Governmental Administration Officer
Bamberg2011.01-2014.08(4 years)Administrative tasks for the goverment
Educational experience
Nuremberg University of Applied Science Georg Simon Ohm
Business2019.01-2022.04(3 years)Focus on Business Informatics and Data Analysis. A level degree grade 1.4Baden-Württemberg Cooperative State University
Business2016.02-2019.09(4 years)Trading and RetailLingnan University
Business2017.12-2018.12(a year)Exchange Semester in Hongkong with scholarship
Languages
German
Native
English
Proficient
Spanish
A little
Certificates
Resume Search
Nationality
Job category
City or country
Sort by
Contact way
49****5603
fa**@**om
Membership will unlock the resume
Also view