Marek Cudny

Experience

• 

  Krajowa Agencja Poszanowania Energii S.A.

  Jul 2013 - Aug 2013

  Trainee

  -assessment of environmental and energy efficiency of buildings using the fallowing programs: CESBA, PHPP and ECOSOFT -reporting the results of the energy audit in English-translating documents within the PromoBio project – „Promotion of regional bioenergy initiatives” and ODYSSEE-MURE - "Monitoring of energy efficiency in the European Union"

• 

  Geotermia Mazowiecka S.A.

  Sept 2013 - Dec 2013

  Trainee

  -everyday tasks related to heating plants (coal, biomass and natural gas) maintenance and also the analysis of the technical documentation of these plants-monitoring heating plants operation in the range of: absorption heat pump and compression heat pump operation.

• 

  PSG sp. z o.o.

  Jun 2014 - Jul 2014

  Trainee

  -registration of gas connection applications-archiving documents-participation in the process of connecting customers to the gas grid

• 

  Sequence HC Partners

  Jul 2015 - Aug 2016

  Junior Analyst

  -analysis of market data (marketing research results, sales data etc.)˗participation in the development of new analytical service / methodology-designing and building analytical tools˗preparing reports and presentations for clients-data gathering, clean-up and preparation from various sources (NHF data, Eurostat, Gus, Who, etc.)-forecasting (eg. evolution of the pharmaceutical market)

• 

  Medtronic

  Aug 2016 - Oct 2018

  Business Analyst

  -Reporting of financial, labor and metrics data-Development of Tools and Dashboards to help Senior Management to assess performance of Clinical teams and highlight any potential risks-Ad Hoc Analytics & data mining from various databases to support management decision making-Analytical Support for Demand & Capacity Planning to optimize resource utilization-Data gathering, clean-up and consolidation in a database environment (MS SQL, Access)-Identifying, driving continuous improvements of Processes, Tools and Procedures-Developing dashboards in Spotfire-Coding in SQL and VBA (automated emails sending, custom report generation, developing interactive dashboards, building advance tools that utilize excel [+Power Query, +Power Pivot] and MS SQL/Access [ADO/DAO libraries]) -Designing basic ETL process (SSIS)-Providing Excel and Excel-VBA training for employees Show less

• 

  CBRE

  Nov 2018 - Jul 2019

  Business and Finance Analyst

  -Collecting, clarifying with Single Points of Contact (SPOC) for specific countries and standardizing set of financial and business information, -Leading creation of tools in order to calculate and monitor profitability, KPI and pricing models.-Supporting EMEA senior management through analytics and reporting projects-Data gathering, clean-up and consolidation in a database environment-Designing and creating databases-Developing dashboards in PowerBI-Coding in SQL and VBA-Designing and implementing ETL process-Basic SharePoint administration Show less

• 

  Warner Bros. Discovery

  Aug 2019 - now

  - Maintaining very wide portfolio of operational and finance reports. Power BI, CXO (BI/Finance tool) and Excel dashboards.- Supervision of the monthly commenting process in CXO (Financial performance, forecast vs actual vs plan etc.)- Performance optimization of existing reports (speed and efficiency). - Creating entire structures for new reports: 1. Starting from analyzing needs of higher management and teams from entire organization2. Researching what data is necessary and what is available in organization3. Designing and developing databases for new reports4. Creating ETL process feeding database. If necessary leading creation of new processes regarding data gathering and data quality. 5. Delivering insightful reports using PowerBI (with standard and custom visuals) and CXO.6. Continues improvement of reports by:a. Using gathered feedback from usersb. Collaboration with employees from entire organizationc. Keeping eye on latest trends in BI worldTools/Technology: PowerBI (Zebra BI, DAX studio, Tabular editor), CXO, SQL server, SSIS, SSAS, Excel, VBA, SharePoint, Power Automate Show less

  • Data & Analytics BI System Technical Lead

    Oct 2024 - now

  • Senior Ad Sales FP&A BI Systems Analyst

    Nov 2021 - Feb 2025

  • FP&A BI System Analyst

    Aug 2019 - Oct 2021