Burak Güzel-Jedox Developer
Check rate
Experience
BI Consultant TM1
Accantec GmbH
Project description: Design and step-by-step implementation of a central, multidimensional controlling platform based on IBM Planning Analytics to optimize and automate internal company planning and reporting.
Business & technical consulting: Analyzed the provided operational base data and proactively advised the controlling team on cube design best practices and optimal dimension structures.
Data integration & ETL: Designed and developed robust TurboIntegrator processes for automated data loading, transformation, and dimension maintenance.
Logic & business implementation: Implemented complex business logic and calculations with high performance using TM1 business rules (including efficient skipping/feeding).
Development of a Python HTTPS server to integrate an input widget in IBM PAW, enabling direct data write-back to TM1 cubes via the TM1 REST API.
Reporting & analytics: Created dynamic, user-friendly reports and dashboards for management and specialist departments.
BI Consultant TM1
RWG Rheinland eG
Project description: Optimized and further developed the existing IBM Planning Analytics (TM1) environment at RWG to improve reporting structures, correct cost hierarchies, and integrate cube restructurings into the current reporting system.
Tasks and achievements:
Reporting optimization: Optimized existing TM1 reports in PAW and Excel view to improve structure, performance, and user experience.
Parallel hierarchy & cost structure: Processed and corrected parallel hierarchies for precise and consistent representation of the company's internal cost structure.
Cube restructuring & integration: Performed cube restructurings and integrated the changes into the existing reporting environment.
BI Consultant Jedox
NVision Imaging Technologies GmbH
Project description: Introduced and implemented an integrated corporate planning and reporting platform based on Jedox to replace existing Excel-based internal reporting processes.
Tasks and achievements:
Jedox implementation & cube development: Supported and managed the company-wide rollout of Jedox, including building and configuring multidimensional cubes and implementing the related business rules to map financial calculation logic.
HR reporting: Designed and created analytical reports and dashboards for HR to support data-driven decision making for bonus distribution and salary increases.
Layout & UX optimization: Revised and standardized existing report layouts to improve user experience and visual consistency using widgets.
BI Consultant Jedox
Siemens Energy
Project description: Further developed and operationally supported a global corporate planning and reporting platform based on Jedox to consolidate and optimize company-wide planning and reporting processes.
Tasks and achievements:
Feature development & implementation: Developed and implemented new features according to C-level management requirements.
System stability & self-healing ETL: Designed and built a fault-tolerant, self-healing ETL framework that automatically detects errors in data sources and reloads affected sources.
Process migration & enhancement: Migrated existing planning processes to Jedox and continuously enhanced them during operation.
Bug fixing & quality assurance: Systematically analyzed and fixed bugs and quality issues from previous platform versions.
System integration & enablement: Integrated new departments and business units into the existing system landscape and conducted user training on the Jedox platform.
BI Consultant Jedox
MEILLER Kipper
Project description: Planned and executed the migration of an existing Jedox on-premises environment to the cloud and comprehensively optimized the existing reporting landscape.
Tasks and achievements:
Cloud migration: Planned and carried out the full migration of the Jedox environment from on-premises to the cloud, including a comprehensive overhaul and adjustment of existing reports.
Report optimization & quality assurance: Analyzed and precisely optimized existing reports for performance, structure, and user experience, and ensured data integrity through systematic testing and validations during and after the migration.
Requirements management & implementation: Worked closely with business units to systematically capture requirements for reporting solutions.
BI Consultant Jedox
Getränke Hoffmann
Project description: Replacing existing Excel-based planning and reporting processes and fully transferring the P&L structure to Jedox Cloud using dynamic Business Rules – to automate, standardize, and represent financial and controlling reporting.
Tasks and achievements: Excel migration & process replacement: Analyzed, migrated, and transferred existing Excel-based processes and P&L and year-end structures into the Jedox Cloud.
Financial reporting & cube development: Implemented dynamic P&L and year-end reports by developing Business Rules across multiple cubes.
Data integration & automation: Integrated and modeled financial data to ensure consistent, automated data loads and job control.
BI Consultant Jedox
Temedica
Project description: Implementation and roll-out of Jedox for structured mapping and automation of financial, HR, and balance sheet data as well as integration of external source systems for consolidating and optimizing internal reporting.
Tasks and achievements: Jedox implementation: Supported the company-wide roll-out of Jedox into the existing IT landscape to support and digitize P&L, HR, and balance sheet analyses.
Cube development & Business Rules: Designed and structured multidimensional cubes to fully map P&L, HR, and balance sheet data and developed dynamic Business Rules.
Data integration & system connectivity: Connected and integrated HR data from Personio and other source systems to ensure a consistent and automated data foundation.
BI Consultant Jedox
Axpo Holding
Project description: Extension and adaptation of the existing Jedox planning environment at Axpo Holding to integrate ESG standards into the current financial structure and restructuring the P&L and balance sheet models to meet sustainability-related reporting requirements.
Tasks and achievements: ESG integration: Integrated the ESG model into the existing system landscape, taking into account current structures and data models.
Cube & rules adjustments: Revised and optimized existing cubes and related Business Rules to support the new ESG requirements.
P&L & balance sheet restructuring: Restructured and expanded the existing P&L and balance sheet models to integrate and represent relevant ESG standards in financial reporting.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Energy, Food and Beverage, Retail, Agriculture, and Manufacturing.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Finance, Accounting, Human Resources, and Quality Assurance.
Skills
Core It Technical Skills (Overview)
- Operating Systems: Linux Server, Ubuntu, Windows
- Databases: Sap Hana, Snowflake
- High-Level Languages: Html, Java, Sql, Vba, Python
- Platforms: Jedox, Confluence, Jira, Sap, Visual Studio Code, Sap S/4hana, Sap Bw, Microsoft Power Bi Report Server
- Visualization Tools: Jedox, Excel, Ms Excel, Ms Power Bi
Core Professional Skills (Overview)
Expertise In Business Intelligence, Financial Analysis, And Auditing, Using Tools Like Jedox, Power Bi, And Excel Vba To Deliver Actionable Insights And Automate Data Processes. Experienced In Financial Planning, Budgeting, And Auditing Annual Financial Statements Under Hgb, Ifrs, And Us Gaap, Focusing On Compliance And Sound Strategic Decision-Making.
Languages
Education
University of Applied Sciences Munich
Bachelor of Arts · Business Administration Finance & Accounting · Munich, Germany
Bachelor of Arts · Business Administration · Hamburg, Germany
Certifications & licenses
Jedox 399 Online Certification - Professional Level
Jedox
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a BI Consultant TM1
Nearby freelancers
Professionals working in or nearby Munich, Germany
