Senior CCH Tagetik Consultant | EPM Architect & Technical Lead

CCH Tagetik Architecture & Implementation
Expert-level design and implementation of CCH Tagetik solutions covering Planning, Consolidation, and Cash Flow Forecasting. Mastery of AIH integration patterns, DTP ingestion flows, MDX calculation layers, and stored-procedure logic across complex enterprise environments.

SQL / T-SQL / PostgreSQL & Data Engineering
Advanced SQL engineering for Tagetik and data warehouse environments, including recursive-CTE hierarchy explosion, cross-dimensional queries, performance-tuned data flows in PostgreSQL, and multi-source ETL architecture covering extraction, profiling, transformation, loading, and reconciliation.

ETL Architecture & Data Integration
End-to-end ownership of data warehouse integration layers using tools such as Talend. Design of Full and Delta extraction patterns, business-rule pushdown, control-table validation frameworks, and environment-promotion models across DEV, TEST, and PROD environments.

Dimensional Modeling
Design of dimensional model architectures underpinning complex financial systems, including logical and physical data-model validation against source-system reality prior to build.

Financial Planning & Analysis (FP&A)
Deep expertise in Financial Planning and Analysis, including Budgeting, Consolidation, Cash Flow Forecasting, Profitability Analysis, Staff Cost, Non-Staff Cost, and ESG module strategy within the Tagetik platform.

Technical Governance & Documentation
Definition of technical governance standards covering AIH design patterns, DTP conventions, MDX standards, hierarchy governance, and dimensional-model documentation. Authoring of operational guides, use-case documentation, and maintenance playbooks.

MDX Calculation Logic
Engineering of calculation and KPI architecture using MDX and stored procedures, defining reusable patterns across modules for complex financial calculation engines.

Recursive CTEs & Hierarchy Explosion
Specialized application of recursive Common Table Expressions for entity and account hierarchy explosion, enabling complex multi-level reporting structures in enterprise financial systems.

SAP Financial Systems
Experience with SAP COMPASS for month-end close, project financial tracking, revenue recognition, cost accounting, accruals and deferrals, voucher posting, and multi-country project portfolio reconciliation.

ADP HCM & Payroll Integration
Configuration of ADP HCM solution designs for enterprise clients, including discovery, gap analysis, solution architecture, configuration, and UAT. Design of payroll data integration architecture across EMEA acquisitions.

Pigment EPM Platform
Training and advisory capability on the Pigment EPM platform to support multi-platform advisory conversations within the broader F&A planning landscape.