Interim Manager/Business Analyst/Entwickler

Profil Foto
Verfügbarkeit einsehen
  Weltweit
en  |  de
  auf Anfrage
  10777 Berlin
 11.06.2018

Kurzvorstellung

Ich habe viele Erfhrung als Business Anaylst in verschiedenen Branchen (Pharm, e-Comerce, Tourismus etc) und viele Geschäfts-Berieche (Demand, Strategie, Sales, Marketing, Produktion). Ich interesse mich besonders für Prozessverbersserung/automation

Referenzen (4)

"Kane hat Berichtsprozesse optimiert (VBA/Cognos), Datenbank entwickelt, Excel Schulungen gegeben,Präsentationen und Auswertungen für den Sr mgt erstel"
Senior Wholesale Analyst
Francoise Rousseau
Tätigkeitszeitraum

7/2017 – 12/2017

Tätigkeitsbeschreibung

• Zusammenarbeit mit Senior Stakeholders, um Vertriebsberichte, Tools und Analyse bezüglich Forecast, Budget und aktuellen Stand zu liefern
• Entwicklung von strategische Präsentationen für Senior Management und Aufsichtsrat
• Neue Mitarbeiter anlernen und System Berechtigungen vereinbaren
• Mehrere wichtige strategische und technische Projekte führen: Erleichterungen der Zahlungsbedingungen, Orderbook Budgetierung bis zu gesamte Finanzjahr erweitern, Showroomplanungstoolprojekt Anforderungen fertig stellen, Abverkaufszahlen und Net Sales Datenbank entwickeln (Powerpivot/VBA)
Achievements
• Automatisiert verschiedene Berichte und Prozesse
• Arbeitserleichterungen im Beriech Wholesale Reporting – COGNOS, VBA, Powerpivot
• 20 Mitarbeiter (Kundenservice und Wholesale) in selbst geschrieben Excel Schulungen angelernt

Eingesetzte Qualifikationen

Microsoft Power BI, IBM Cognos, VBA (Visual Basic for Applications), Prozessoptimierung, Prozessmanagement, Analyse der Markt- / Wettbewerbsposition, Marktpotenzialanalyse


"[...] [...] erfüllte laut unserem Mandanten das Projekt zur vollsten Zufriedenheit. Zudem überzeugte er durch seine angenehme und zugleich hoch professionelle Art."
Senior Business Developer - Sports
Kundenname anonymisiert
Tätigkeitszeitraum

6/2016 – 11/2016

Tätigkeitsbeschreibung

• Set-up weekly and monthly performance reporting and drive review meetings with Sports leadership
• Identify and steer areas for deep dive analyses
• Drive key strategic and financial projects in Sports with key stakeholders
• Develop presentations and participate in meetings with key brands
• Act as a sparring partner for the Assortment Head of Sports
• Develop reporting landscape for team, provide assistance and deliver data solutions
Achievements
• Handled migration from SAP Business Objects to Micro Startegy, including report migration, training and issue elevation
• Developed framework for Sports meeting structure and timetable
• Solved external data alignment issue with key supplier
• Developed seasonal planning tool for Brand planning
• Conducted commercial analysis of Zalando sports campaign

Eingesetzte Qualifikationen

MicroStrategy, SAP BO-PC, VBA (Visual Basic for Applications), Projektmanagement, Projektsteuerung (Projektcontrolling), Business Analyse, Business Development, Kundenanalyse, Controlling


"[...] H. erfüllte laut unserem Mandanten das Projekt zur vollsten Zufriedenheit."
Commercial Analyst
Kundenname anonymisiert
Tätigkeitszeitraum

7/2015 – 3/2016

Tätigkeitsbeschreibung

• Close cooperation with and assume duties of Country management whilst absent.
• Updating weekly forecast used for Warehouse planning and monitoring financial performance.
• Commercial steering of performance levers (Discounts, performance marketing channels) to stay within agreed forecasting corridor and in line with Target Business Case.
• Help define and drive commercial strategy and lead weekly performance review and strategy planning meetings.
• Present monthly and quarterly P&L to the CEO and senior management team.
• Undertake various analytic, planning and strategy related projects.
Achievements
• Assisted in the definition of corporate strategy for 2016-2020 including expected P&L.
• Created detailed financial business case for 2016 target.
• Re-developed forecasting process; construction of database in Access including SQL queries and VBA code to automate data updates, implementation of Power Pivot model in forecasting and planning tools.
• Ran VBA training sessions for the commercial planning & strategy team.

Eingesetzte Qualifikationen

Microsoft Access, VBA (Visual Basic for Applications), Change Management, Demand Management, Interim Management, Business Analyse, Analyse der Markt- / Wettbewerbsposition, eBusiness-Strategie, Potenzial-Analyse, SWOT-Analyse, Kundenanalyse, Marketing- / Vertriebsanalyse, Controlling, E-Commerce


"[...] H. worked with BDA from March 2010 to April 2011. The role was strategic marketing analyst. He worked across a range of clients including Tourism Australia, Mazda Australia, Fairfax Media and Norske Skog. [...]'s contribution was very much valued at BDA Marketing Planning. He made a significant contribution to a number of major projects. In particular, [...] was a primary analyst working on a major forecasting project to provide the primary input for Tourism Australia to set their strategic goals to 2020. [...] also played a major role in a number of major market research projects including a major strategy development project for the design of the Saturday Age newspaper.
[...]'s technical skills are at a very high level. He was a major contributor in a range of demand forecasting projects, constructed detailed codes for market segmentations and significantly enhanced the internal capability at BDA Marketing Planning for the processing and analysis of large data sets. [...] also showed very strong interpretive abilities, enabling the company to derive valuable strategic insights for clients from large volumes of raw data from various sources. [...] always displayed a great work ethic and his ability to work with others was a major strength.
I would have no hesitation in recommending [...] for any strategic or analytical role and would be happy to provide any further information required."
Strategic Marketing Analyst
James Luddington, BDA Marketing Planning
Tätigkeitszeitraum

3/2010 – 4/2011

Tätigkeitsbeschreibung

• Build and provide economic and consumer demand forecasts for client’s business planning requirements.
• Build demand planning models to project anticipated revenue of client’s proposed/pre-launched products.
• Clients include: Taylors Wines, Fairfax, Mazda Australia, Norske Skog, Tourism Australia, Tourism South Australia, TT-Line etc.
• Interpret and present information attained through the analysis of qualitative and quantitative marketing research projects.
• Provide demand projections within market segments e.g. VFACTS data (Car sales): SUV, Medium, Large and consumer group segments (based on age, income and lifestyle interests).
• Contribute to the development and delivery of fundamental client strategy planning.
• Use a wide range of datasets to conduct analysis. Including ABS, NVS (National Visitor Survey), IVS (International Visitor Survey), Aztec, AC Nielson, Roy Morgan Research, Access Economics, Oxford Economics, Deutsche Stat, VFacts, and many others.
• Conduct marketing research workshops.
• Derivation and code construction of marketing segmentation profiles in order to more clearly define consumer groups.
Achievements
• Made large contribution to forecasting project for Tourism Australia that defined strategic marketing goal to 2020.
• Assisted in large marketing research project to transform the Saturday Age.
• Developed expert skills in various cross tabulated database programmes and Excel.

Eingesetzte Qualifikationen

Access, Hardware Entwicklung, Creo Elements/Pro (Pro/ENGINEER, Pro/E, ProE), Marketing (allg.), Strategisches Marketing, Forschung & Entwicklung (allg.)


Ich biete

Management, Unternehmen, Strategie
  • Business Analyse
    4 Jahre, 2 Monate Erfahrung

IT, Entwicklung
  • VBA (Visual Basic for Applications)
    3 Jahre, 7 Monate Erfahrung
  • Microsoft Access
    9 Monate Erfahrung
  • Microsoft Power BI
    6 Monate Erfahrung
  • Python
    5 Monate Erfahrung
  • SQL
    5 Monate Erfahrung
  • Datenbankentwicklung
    5 Monate Erfahrung
  • Business Intelligence and Reporting Tools (BIRT)
    5 Monate Erfahrung

Finanzen, Versicherung, Recht
  • Controlling
    2 Jahre, 1 Monat Erfahrung
  • Finanzanalyse
    9 Monate Erfahrung

Projekt‐ & Berufserfahrung

Berater (Corporate Controlling und Datenbank Entwicklung)
Median Kliniken, Berlin
4/2018 – 8/2018 (5 Monate)
Gesundheitswesen
Tätigkeitszeitraum

4/2018 – 8/2018

Tätigkeitsbeschreibung

• Aufbereiten und Analysieren von Daten
• Monatliches Reporting, Plan-/ Ist-Vergleich, Abweichungsanalysen (Working Capital, DPO, Beirat)
• Erstellung von Bankenreports und Bearbeitung der Konzern-Anfragen von Banken
• Mitwirken bei der Forecast-Erstellung, Budgetierung und Budgetüberwachung
• Ansprechpartner für betriebswirtschaftliche Fragestellungen
• Reporting Struktur erleichtern mit der Aufbau einer Datenbank und automatisch erstellte Berichte (SQLite, Python, Pandas)
Leistungen
• Python Skript geschrieben um die Kliniken-Forecasts zusammen zu bringen (früher 3 Tage Arbeit. Der Prozess dauert jetzt 2 Minuten)

Eingesetzte Qualifikationen

Finanzanalyse, Controlling, Business Intelligence and Reporting Tools (BIRT), Datenbankentwicklung, SQL, Python, VBA (Visual Basic for Applications)


Senior Wholesale Analyst
Escada SE, Aschheim
7/2017 – 12/2017 (6 Monate)
Mode
Tätigkeitszeitraum

7/2017 – 12/2017

Tätigkeitsbeschreibung

• Zusammenarbeit mit Senior Stakeholders, um Vertriebsberichte, Tools und Analyse bezüglich Forecast, Budget und aktuellen Stand zu liefern
• Entwicklung von strategische Präsentationen für Senior Management und Aufsichtsrat
• Neue Mitarbeiter anlernen und System Berechtigungen vereinbaren
• Mehrere wichtige strategische und technische Projekte führen: Erleichterungen der Zahlungsbedingungen, Orderbook Budgetierung bis zu gesamte Finanzjahr erweitern, Showroomplanungstoolprojekt Anforderungen fertig stellen, Abverkaufszahlen und Net Sales Datenbank entwickeln (Powerpivot/VBA)
Achievements
• Automatisiert verschiedene Berichte und Prozesse
• Arbeitserleichterungen im Beriech Wholesale Reporting – COGNOS, VBA, Powerpivot
• 20 Mitarbeiter (Kundenservice und Wholesale) in selbst geschrieben Excel Schulungen angelernt

Eingesetzte Qualifikationen

Microsoft Power BI, IBM Cognos, VBA (Visual Basic for Applications), Prozessoptimierung, Prozessmanagement, Analyse der Markt- / Wettbewerbsposition, Marktpotenzialanalyse


Controller - DACH/BENELUX
Sony Europe GmbH, Berlin
12/2016 – 4/2017 (5 Monate)
Handel
Tätigkeitszeitraum

12/2016 – 4/2017

Tätigkeitsbeschreibung

• Bereitstellung der Key Management Reportings, Analysen sowie des Finanzcontrollings
• Mitwirkung am Entscheidungsprozess für das Werbe- und Reklamebudget
• Operatives Kosten-/Marketingcontrolling
• Business Partnering auf Geschäftsführungsebene
• Enge Zusammenarbeit mit dem Fachbereich (Marketing) bezüglich des Budgets für Werbemaßnahmen
• Übernahme des Budget- und Forecast-Managements

Eingesetzte Qualifikationen

SAP CO, SAP FI, Projektsteuerung (Projektcontrolling), Business Analyse, Marketing- / Vertriebsanalyse, Controlling


Senior Business Developer - Sports
Zalando SE, Berlin
6/2016 – 11/2016 (6 Monate)
Handel
Tätigkeitszeitraum

6/2016 – 11/2016

Tätigkeitsbeschreibung

• Set-up weekly and monthly performance reporting and drive review meetings with Sports leadership
• Identify and steer areas for deep dive analyses
• Drive key strategic and financial projects in Sports with key stakeholders
• Develop presentations and participate in meetings with key brands
• Act as a sparring partner for the Assortment Head of Sports
• Develop reporting landscape for team, provide assistance and deliver data solutions
Achievements
• Handled migration from SAP Business Objects to Micro Startegy, including report migration, training and issue elevation
• Developed framework for Sports meeting structure and timetable
• Solved external data alignment issue with key supplier
• Developed seasonal planning tool for Brand planning
• Conducted commercial analysis of Zalando sports campaign

Eingesetzte Qualifikationen

MicroStrategy, SAP BO-PC, VBA (Visual Basic for Applications), Projektmanagement, Projektsteuerung (Projektcontrolling), Business Analyse, Business Development, Kundenanalyse, Controlling


Commercial Analyst
Zalando SE, Berlin
7/2015 – 3/2016 (9 Monate)
Handel
Tätigkeitszeitraum

7/2015 – 3/2016

Tätigkeitsbeschreibung

• Close cooperation with and assume duties of Country management whilst absent.
• Updating weekly forecast used for Warehouse planning and monitoring financial performance.
• Commercial steering of performance levers (Discounts, performance marketing channels) to stay within agreed forecasting corridor and in line with Target Business Case.
• Help define and drive commercial strategy and lead weekly performance review and strategy planning meetings.
• Present monthly and quarterly P&L to the CEO and senior management team.
• Undertake various analytic, planning and strategy related projects.
Achievements
• Assisted in the definition of corporate strategy for 2016-2020 including expected P&L.
• Created detailed financial business case for 2016 target.
• Re-developed forecasting process; construction of database in Access including SQL queries and VBA code to automate data updates, implementation of Power Pivot model in forecasting and planning tools.
• Ran VBA training sessions for the commercial planning & strategy team.

Eingesetzte Qualifikationen

Microsoft Access, VBA (Visual Basic for Applications), Change Management, Demand Management, Interim Management, Business Analyse, Analyse der Markt- / Wettbewerbsposition, eBusiness-Strategie, Potenzial-Analyse, SWOT-Analyse, Kundenanalyse, Marketing- / Vertriebsanalyse, Controlling, E-Commerce


Demand Analyst
Ego Pharmaceuticals, Melbourne
5/2013 – 5/2014 (1 Jahr, 1 Monat)
Chemieindustrie
Tätigkeitszeitraum

5/2013 – 5/2014

Tätigkeitsbeschreibung

• Upload and maintain domestic and international forecasts in SAP, Demand Solutions and external reports – includes supersessions, new and outgoing product maintenance, statistical forecasting, forecast reviews for international & domestic markets.
• Conduct in depth analysis of data services and other sources to enrich quality of forecasting and provide ad-hoc analysis as required.
• Improve processes through alternative procedural design and by writing VBA code to automate and streamline demand planning requirements.
• Contribute to a range of relevant meetings: S&OP, supply/demand etc.
• Update domestic pharmacy wholesaler and consumer sales data services (Nielsen/IMS) and provide analysis from these tools.
• Update various reports from prior mentioned sources and Business Objects (BObj).
Achievements
• Wrote a script in Python to cleanse SAP forecast data for use in Demand Solutions forecasting tool whilst accessing OS features to backup data.
• Wrote numerous VBA macros to automate weekly and monthly updating of files and reports.
• Wrote custom built forecast templates for international markets that encompass containerisation formulae to optimise shipping costs and allow for the live update of forecast figures to be reflected in a Graphical interface.
• Developed similar tools for Middle Eastern markets based on In-The-Market (ITM) data and statistical forecasts from Demand Solutions.
• Developed complex Middle East Forecast Tool to generate Ex-Factory Forecast from ITM forecasts.
• Used Google Flu trends to analyse Australian hand sanitiser market.
• Further enhanced an Excel workbook (VBA) to allow for the visualisation of Ego's promotional activity, in order to further optimise forecasts and objectively analyse the success of sales and marketing promotions/campaigns.
• Instrumental in the testing and validation processes in the system forecasts migration to SAP.

Eingesetzte Qualifikationen

VBA (Visual Basic for Applications), Change Management, Demand Management, Projektmanagement, Business Analyse, Analyse der Markt- / Wettbewerbsposition, Strategische Unternehmensplanung, Marktpotenzialanalyse


VBA Developer/ Financial Analyst
Telstra South East Business Centre, Melbourne
6/2012 – 9/2012 (4 Monate)
Telekommunikation
Tätigkeitszeitraum

6/2012 – 9/2012

Tätigkeitsbeschreibung

VBA code development for the Accounting department in preparation for the business to be sold
Project specifics:
• Investigation of potential outstanding invoices with claims sent to parent company
• Conduct stocktakes
• Create a VBA tool to automate the reconcilliation process of outstanding payments
• Ad-hoc analysis

Eingesetzte Qualifikationen

VBA (Visual Basic for Applications), Business Analyse, Finanzanalyse


National Sales Manager / Business Analyst
Maravending, Melbourne
5/2011 – 5/2012 (1 Jahr, 1 Monat)
Handel
Tätigkeitszeitraum

5/2011 – 5/2012

Tätigkeitsbeschreibung

• Plan, implement and conduct national business development strategy and operations.
• Inventory control and management of 200 SKU’s in 1600 vending machines and distribution to large customer base.
• Monitor and analyse all aspects of national operation including but not limited to targets, costs and budgets associated with; sales, vending & distribution operations, administrative processes and communication channels.
• Design systems, programmes and processes that increase profitability.
• Liaise with suppliers to formulate marketing strategies. Inclusive are targeted product promotions, business development assistance and mutually beneficial project development.
Achievements
• Designed, produced and implemented the use of a programme that eliminated repetitive
administrative duties associated with the sales process.
• Organised, managed and assisted in the (a) successful transition of business operations into new states (WA, QLD) and (b) 20% overall growth of the company.

Eingesetzte Qualifikationen

Management (allg.), Demand Management, Business Analyse, Analyse der Markt- / Wettbewerbsposition, Marktpotenzialanalyse, Verkaufsförderungskonzept, Kundenanalyse, Marketing- / Vertriebsanalyse


Strategic Marketing Analyst
BDA Marketing Planning, Melbourne
3/2010 – 4/2011 (1 Jahr, 2 Monate)
Consulting
Tätigkeitszeitraum

3/2010 – 4/2011

Tätigkeitsbeschreibung

• Build and provide economic and consumer demand forecasts for client’s business planning requirements.
• Build demand planning models to project anticipated revenue of client’s proposed/pre-launched products.
• Clients include: Taylors Wines, Fairfax, Mazda Australia, Norske Skog, Tourism Australia, Tourism South Australia, TT-Line etc.
• Interpret and present information attained through the analysis of qualitative and quantitative marketing research projects.
• Provide demand projections within market segments e.g. VFACTS data (Car sales): SUV, Medium, Large and consumer group segments (based on age, income and lifestyle interests).
• Contribute to the development and delivery of fundamental client strategy planning.
• Use a wide range of datasets to conduct analysis. Including ABS, NVS (National Visitor Survey), IVS (International Visitor Survey), Aztec, AC Nielson, Roy Morgan Research, Access Economics, Oxford Economics, Deutsche Stat, VFacts, and many others.
• Conduct marketing research workshops.
• Derivation and code construction of marketing segmentation profiles in order to more clearly define consumer groups.
Achievements
• Made large contribution to forecasting project for Tourism Australia that defined strategic marketing goal to 2020.
• Assisted in large marketing research project to transform the Saturday Age.
• Developed expert skills in various cross tabulated database programmes and Excel.

Eingesetzte Qualifikationen

Access, Hardware Entwicklung, Creo Elements/Pro (Pro/ENGINEER, Pro/E, ProE), Marketing (allg.), Strategisches Marketing, Forschung & Entwicklung (allg.)


Zertifikate

Golden Key Honours Society
November 2005

Ausbildung

Physik
(Bachelor of Science (Hons))
Jahr: 2007
Ort: Canberra, ACT, Australien

Physik & Mathematik
(Bachelor of Applied Science with major Studies in Physics with Distinction)
Jahr: 2006
Ort: Melbourne, VIC, Australien

Qualifikationen

VBA, Python, MS Office in besonders Excel, SAP, Business Objects, sqLite3, Power Pivot

Über mich

I am a Business Analyst with a wealth of experience in various industries from e-Commerce, consultancy to pharmaceutical and across the the breadth of business divisions. This experience ranges in scope from technical, managerial, analytic and strategic. A positive and lively personality coupled with a passion for automation in business and driving significant change in my roles allows me to quickly and effectively slot into any team and perform from day one. I am comfortable dealing with a broad range of internal and external stakeholders and thrive on a results driven approach.

Persönliche Daten

Sprache
  • Englisch (Muttersprache)
  • Deutsch (Fließend)
Reisebereitschaft
Weltweit
Arbeitserlaubnis
  • Europäische Union
  • Schweiz
  • Vereinigte Staaten von Amerika
Profilaufrufe
1351
Alter
33
Berufserfahrung
10 Jahre und 4 Monate (seit 02/2008)
Projektleitung
2 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden »