Daryoosh Dehestani-Enterprise Data & AI Architect
Check rate
Experience
FP&A Data & AI Architect
Epta Group
Scope: Embedded as FP&A Data & AI Architect within the Finance function of a major European refrigeration manufacturer, leading the transformation of manual, fragmented financial reporting into an automated, governance-driven intelligence platform. Driving the shift from Excel-based controlling to structured data architecture, Power BI analytics, and AI-assisted financial operations.
Financial Data Integrity & ERP Governance
- Initiated and led GL vs. subledger reconciliation investigations, identifying and resolving structural mismatches between General Ledger and subledger data that had gone undetected prior to engagement
- Conducted asset analysis to identify items missing from General Ledger postings, surfacing gaps in fixed asset tracking and period-end completeness
- Validated SAP reports, establishing baseline data quality standards for Finance team consumption
- Established systematic SAP data validation framework ensuring ongoing integrity between ERP postings and downstream reporting outputs
Finance Reporting Transformation
- Designed and implemented a structured Transformation Project approach for converting manual Finance reports into fully automated processes
- Created and owns the Data Reporting Audit Log; a centralized tracking system capturing report owners, stakeholders, data sources, manual effort estimates, and automation opportunity scores across the Finance function
- Mapped the full reporting landscape identifying quick-win automation targets and strategic Power BI migration candidates
- Actively reducing manual Excel and PowerPoint dependency across FP&A workflows; replacing point-in-time snapshots with live, governed data models
Power BI & Analytics Enablement
- Introduced and presented Power BI as the strategic reporting platform to Finance leadership, building internal buy-in for the BI transformation roadmap
- Designed initial Power BI architecture aligned with SAP, Salesforce and Oracle data structures and FP&A reporting requirements
- Established report ownership, governance documentation, and data lineage standards enabling sustainable self-service analytics across the Finance team
Transformation Infrastructure & Collaboration
- Configured and deployed Jira as the transformation project management hub, establishing structured sprint workflows, backlog management, and progress visibility for Finance IT initiatives
- Proposed and initiated a dedicated FP&A Communication & Transformation Hub, a structured cross-functional forum aligning Finance, IT, and business stakeholders around the reporting transformation roadmap
- Positioned the Finance function as an active driver of data governance and digital transformation within the broader organization
Outcomes
- GL/subledger reconciliation gaps identified and investigation framework established within first two weeks of engagement
- Data Reporting Audit Log deployed; first structured inventory of Finance reporting landscape in company history
- Power BI transformation roadmap presented and approved by Finance leadership
- Jira-based project governance live; Finance transformation now tracked with full sprint visibility
Technologies: SAP FI/CO · Power BI · DAX · SQL · Excel (advanced) · Power Query (M) · Power Automate · VBA · Jira · Microsoft 365 · SharePoint · Salesforce (Sales Data) · Oracle HCM · Python
Senior HR Data & AI Architect
CEWE Group
Scope: End-to-end integration of SAP S/4HANA FI/CO, Workday HCM, and enterprise reporting to create a unified workforce and financial intelligence platform for one of Europe's largest photobook manufacturers.
Data Architecture & Integration
- Architected integrated data model connecting SAP S/4HANA FI/CO postings, cost center hierarchies, payroll structures, and Workday HCM workforce entities — eliminating cross-system data reconciliation effort
- Designed reusable SQL transformation layer establishing a harmonized enterprise reporting foundation across HR and Finance domains
- Implemented validation layers and reconciliation logic ensuring data integrity between ERP and HCM environments
FP&A & Financial Intelligence
- Designed automated personnel cost planning engine with scenario-based simulations covering hiring freezes, restructuring events, and compensation review cycles
- Built driver-based workforce forecasting models directly aligned with organizational financial planning cycles
- Developed variance analytics framework comparing budget, rolling forecast, and actual personnel cost developments — enabling real-time controlling insight
- Established working capital and liquidity monitoring structures linked to headcount movement
Workforce & People Analytics
- Implemented predictive attrition indicators using historical HR event data, compensation trends, and tenure signals
- Prepared ESG-aligned workforce analytics structures supporting CSRD regulatory readiness
- Established governance-aligned KPI definitions ensuring transparency for executive board and works council reporting
Outcomes
- Reduced manual reporting cycle time by over 40% through pipeline automation
- Delivered single source of truth for workforce and cost data — first time in company history
- CSRD-ready reporting architecture delivered ahead of regulatory deadline
Technologies: SAP S/4HANA FI/CO · Workday HCM · SQL Server · IBM Cognos · Power BI · DAX · Python · Azure
Founder & Principal Architect
RadarRoster
Scope: Founded RadarRoster, an AI & Data Intelligence consultancy designing modular, production-grade intelligence products for HR and Finance domains — built on modern Python stacks, cloud-native infrastructure, and AI automation frameworks. Products are deployed independently and delivered to enterprise clients across DACH.
SAP Journal Auditor
- Enterprise-grade audit automation tool for SAP FI/CO journal entries — automatically flags anomalies, duplicate postings, approval bypass indicators, round-amount irregularities, and period-end outliers
- Supports SAP exports from FAGLL03, KSB1, FB03, and S/4HANA ACDOCA (Universal Journal) in both German and English column formats, with European and US number format handling
- Deployed as an OpenClaw-powered AI agent on ClawHub — enabling conversational audit via Telegram, Slack, and WhatsApp: upload a journal export, receive a structured audit memo and flagged entries CSV instantly
- Published open source under CC BY 4.0 on GitHub — available for enterprise use, contribution, and extension
- Built with deep SAP FI/CO and S/4HANA controlling expertise; includes 34-test automated validation suite and zero-dependency fallback mode for air-gapped enterprise environments
HR Intelligence Hub
- ML-ready workforce analytics platform with extensible KPI ecosystem covering headcount, attrition, compensation, and organizational health metrics
- Early-warning retention dashboards surfacing flight-risk signals ahead of voluntary departures
- Designed for enterprise deployment with configurable data connectors for SAP, Workday, and SuccessFactors
Retention Guard
- Explainable retention risk scoring model using feature engineering based on engagement, tenure, compensation deltas, and structural factors
- Model outputs include SHAP-based feature attribution, enabling HR business partners to act on specific risk drivers rather than opaque scores
Financial Intelligence Engine
- Factor-based financial scoring models with automated data ingestion and signal generation pipelines
- Single source of truth financial analytics architectures with data quality validation and reconciliation frameworks
AI Automation Frameworks
- Conversational agents integrated with CRM systems for sales pipeline, HR case management, and self-service analytics workflows
- API-based orchestration workflows enabling cross-system process automation without manual intervention
ERP Data Integration Programs
- Modular connectors and transformation pipelines for SAP, Workday, and cloud data warehouses
- Reconciliation and data quality validation frameworks ensuring enterprise-grade data reliability
Technologies: Python · FastAPI · SQL · Docker · Airflow · Power BI · Streamlit · Azure · GCP · Scikit-learn · TensorFlow · Node.js · OpenClaw · GitHub Actions
Freelance Data & AI Architect
Multi-Client Engagements
Scope: Concurrent freelance projects across German mid-market and enterprise clients — migrating controlling, finance, and workforce operations from spreadsheet-driven processes into structured, automated analytics architectures.
Financial Controlling & FP&A
- Migrated spreadsheet-driven controlling processes into structured dimensional Power BI architectures with full audit traceability
- Designed cost center profitability models and revenue impact simulation frameworks for management reporting
- Developed rolling forecast automation reducing planning friction and eliminating manual consolidation effort
- Implemented working capital and liquidity monitoring dashboards aligned with CFO-level KPI requirements
- Built automated ETL pipelines integrating ERP exports, CRM systems, and financial data warehouses
Predictive Workforce & Capacity Modeling
- Built machine learning models forecasting capacity requirements and hiring demand based on revenue and project pipeline signals
- Implemented retention signal detection models incorporating compensation, tenure, and organizational factors
- Designed scenario-based headcount planning frameworks with sensitivity analysis across cost assumptions
- Delivered compensation benchmarking and sensitivity analysis models linked to market positioning data
AI-Driven Automation
- Developed workflow automation bots integrating CRM and messaging APIs, replacing manual process handoffs in HR and Sales operations
- Built scheduled reporting agents and anomaly detection alert systems with automated stakeholder notifications
- Reduced manual operational effort significantly across HR, Finance, and Sales operations through intelligent automation layers
Outcomes
- Delivered fully automated planning cycle for 3 clients — manual Excel consolidation eliminated
- ML capacity model achieved >85% demand forecast accuracy over 6-month evaluation window
- Automation bots reclaimed 15+ hours/week of manual effort per client on average
Technologies: Python · Pandas · Scikit-learn · SQL · Power BI · DAX · Docker · GCP · FastAPI · SAP Cloud Analytics (SAC)
Business Analytics Lead
GO ITC GmbH
Scope: Workforce analytics and financial impact modeling to support rapid international headcount scaling, nearshore/offshore expansion, and cross-jurisdictional contractor vs. employee cost optimization for a growing IT services company.
Workforce & Cost Analytics
- Designed contractor vs. employee cost optimization models across multiple European jurisdictions, enabling evidence-based engagement model decisions
- Built financial impact simulations for nearshore and offshore expansion strategies including fully loaded cost modeling and productivity-adjusted comparisons
- Developed automated payroll, headcount, and cost dashboards providing real-time visibility to leadership
- Supported leadership with workforce investment vs. productivity analytics directly influencing hiring and outsourcing decisions
Compliance & Operations
- Structured visa compliance and relocation tracking systems for international hires, reducing administrative overhead
- Established standardized KPI frameworks aligned with revenue growth targets and investor reporting requirements
Outcomes
- Cost optimization models identified 20%+ savings potential through contractor/employee mix rebalancing
- International KPI framework adopted as standard across all business units
Technologies: Power BI · SQL · Excel · Python · HR Information Systems, SAP SuccessFactors
Founder & People Analytics Consultant
HRStartup
Scope: Founded a boutique analytics consultancy serving SMEs: specializing in people analytics infrastructure, workforce data modeling, and evidence-based HR decision support for organizations building their first structured data capability.
People Analytics Architecture
- Designed end-to-end people analytics frameworks from scratch for clients with no existing HR data infrastructure — covering data collection, cleaning, modeling, and visualization layers
- Built workforce data models integrating HRIS exports, payroll data, and recruitment system outputs into unified, analysis-ready datasets
- Developed attrition analysis models identifying flight-risk patterns across tenure cohorts, compensation bands, and team structures — enabling proactive retention interventions
- Established people data governance principles including metric definitions, data ownership, refresh cadences, and reporting accountability structures
Workforce & Predictive Analytics
- Built predictive headcount demand models linking revenue forecasts, project pipelines, and historical hiring velocity to future FTE requirements
- Designed compensation analytics frameworks benchmarking internal pay distributions against external market data — surfacing pay equity risks and compression issues
- Delivered absenteeism and productivity pattern analysis identifying organizational health signals invisible in standard HR reporting
- Modeled the financial impact of turnover — calculating fully loaded replacement costs, productivity ramp curves, and retention ROI for leadership decision-making
Data Infrastructure & Reporting
- Migrated client HR reporting from manual Excel consolidation into structured, automated dashboard environments with scheduled data refreshes
- Designed KPI taxonomies covering the full employee lifecycle — from sourcing efficiency and offer acceptance rates through engagement, development, and voluntary turnover
- Built self-service reporting layers enabling HR business partners to answer workforce questions independently without analyst intervention
- Implemented data validation and reconciliation logic ensuring headcount figures were consistent across HR, Finance, and payroll systems
Technologies: Python · Pandas · SQL · Power BI · Excel (advanced) · HRIS Platforms · Survey Analytics Tools
Project Manager
TMCO
- Implemented performance management frameworks and structured workforce planning processes in project-driven environments
- Designed early workforce reporting structures, establishing the foundation for data-driven HR decision-making
- Managed recruitment scaling initiatives, delivering standardized hiring workflows and KPI tracking
Talent Specialist
Petropars Operation and Management Company
- Managed recruitment pipelines for engineering and technical project roles in an oil & gas operating environment
- Designed structured candidate evaluation frameworks and built early hiring KPI tracking systems
- Supported succession planning initiatives and maintained HR data integrity across workforce systems
HR Generalist
Tandis Brokerage
- Managed personnel administration, payroll coordination, and employee master data integrity
- Supported HR reporting, compliance documentation, and recruitment workflow structuring
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Information Technology, Professional Services, Energy, and Manufacturing.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Human Resources, Business Intelligence, Finance, Information Technology, Operations, and Project Management.
Summary
Enterprise Data and AI Architect with nearly two decades of experience at the intersection of Finance, FP&A, and intelligent systems, designing and delivering end-to-end data transformation programs across ERP, HCM, and cloud analytics environments in DACH enterprise contexts.
Specializes in translating fragmented financial and workforce landscapes into governed, automation-ready intelligence platforms: from SAP, controlling architecture and FP&A process transformation to predictive analytics, AI agent deployment, and cloud-native data engineering. Equally fluent in controlling logic and data pipeline design, bridging the CFO's office and the engineering team without translation loss.
Founder of RadarRoster, an AI & Data Intelligence consultancy producing modular, production-grade products for Finance and Workforce domains, including open-source SAP audit automation, explainable retention risk scoring, and LLM-powered enterprise agents. Operates at the architecture level across strategy, design, implementation, and enablement.
Communicates AI and data strategy at board level with equal effectiveness as at team level. Proven track record of building analytics functions, leading cross-functional transformation programs, and delivering measurable operational impact within the first weeks of engagement, across manufacturing, IT services, and professional services environments.
Skills
Erp & Enterprise Systems: Sap S/4hana Fi/Co · Sap Ecc · Sap Gui · Fiori Launchpad · Workday Hcm · Successfactors · Sap Analytics Cloud · Sap Bw/4hana · Acdoca / Universal Journal · S/4hana Finance Best Practices
Finance & Controlling (Sap): Cost Center Accounting (Cca) · Internal Orders · Profit Center Accounting · Product Costing · Profitability Analysis (Co-Pa) · Asset Accounting (Fi-Aa) · Bank Accounting · Accounts Payable/Receivable · Period-End Closing · Parallel Ledgers · Intercompany Reconciliation · General Ledger (G/L) · Segment Reporting
Data Engineering: Sql · Etl/Elt Architecture · Api Integration · Data Warehousing · Apache Airflow · Databricks · Data Pipeline Automation · Reconciliation Frameworks · Data Quality Validation · Schema Design · Dbt · Unity Catalog · Medallion Architecture · Data Governance
Analytics & Ai: Pandas · Scikit-Learn · Tensorflow · R · Dax · Shap · Feature Engineering · Predictive Modeling · Anomaly Detection · Nlp · Llm Integration · Prompt Engineering · Openclaw / Agent Frameworks · Multi-Agent Systems (Mas) · Agent-Based Modeling · Vector Search · Rag
Ai Automation & Agents: Conversational Agent Design · Openclaw / Clawhub Deployment · Crm & Erp Automation · Workflow Orchestration · N8n (Foundations) · Scheduled Reporting Agents · Anomaly Alert Systems · Databricks Ai Functions
Business Intelligence: Power Bi · Dax · Dimensional Modeling · Tableau · Streamlit · Sap Analytics For Office · Executive Dashboard Design · Self-Service Bi Enablement · Ai/Ml-Integrated Power Bi
Cloud & Devops: Azure · Gcp · Databricks · Docker · Fastapi · Airflow · Github Actions · Mlops Foundations · Rest Api Design · Node.Js · Streamlit Cloud
Methodologies & Frameworks: Lean Six Sigma Green Belt · Agile (Scrum/Kanban) · Change Management Frameworks · Strategic Workforce Planning · Strategic Negotiation
Finance & Fp&A Methods: Driver-Based Planning · Rolling Forecast Automation · Budget Vs. Actual Variance Analysis · Personnel Cost Simulation · Scenario & Sensitivity Modeling · Working Capital Monitoring · Liquidity Planning · Csrd Analytics · Management Reporting · Cost Center Profitability
Hr Domain Methods: Headcount Planning · Attrition Modeling · Retention Risk Scoring · Workforce Segmentation · Compensation Analytics · Hrbp Analytics · People Analytics · Csrd / Esg Workforce Reporting · Org Design Support
Languages
Education
University of Bayreuth
M.A. · Philosophy, Politics & Economics · Germany
Multimedia University
MBA · Business Administration · Malaysia
Aryamehr University of Industry
BBA · Business Administration · Thành phố Hồ Chí Minh, Viet Nam
Certifications & licenses
AWS Databricks Platform Architect
Databricks
AZ-305, AZ-104 & AZ-900
BWNW
Data Governance & Fundamentals
Databricks
Databricks AI Agent (GenAI & Multi-agent Systems)
Databricks
Google Cloud Data Analytics
SAP S/4HANA FI/CO
alfatraining
Data Science & AI Bootcamp
Le Wagon
Agile Methodologies & Project Foundations
PMI
Business Analysis Professional
Microsoft
Change Management & Leadership (Executive Suite)
PMI / NASBA
Data Analytics for Business Professionals
IIBA
Economic Analysis & Financial Forecasting
IIBA
Executive Decision-Making & Coaching
PMI
Managing Data & Projects with Microsoft 365
PMI
Master Power BI Specialist (Incl. AI, ML, & DAX)
Microsoft
Six Sigma Green Belt (Lean & Process Improvement)
PMI
Strategic Negotiation & Crisis Communication
Strategic Workforce Planning & People Analytics
SHRM / HRCI
Tableau
Data Analytics Professional Certificate
Statistics with Python Specialization
University of Michigan
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 FP&A Data & AI Architect
Nearby freelancers
Professionals working in or nearby Offenburg, Germany
