Allocation Rules & Rule Sets: Mastery in designing, building, and sequencing allocation rules. This includes defining source and destination intersections, allocation methods (e.g., proportional, even split), and driver-based allocations.
Custom Calculations: Proficiency in writing custom MDX-based formulas or calculation logic when standard point-and-click allocation rules are insufficient.
Dimension Management: Deep understanding of PCM/EPCM dimension types, specifically system-defined dimensions like Rule, Balance, and Point of View (POV), alongside standard business dimensions (Product, Customer, Department).
Model Validation & Execution: Ability to run and optimize multi-step calculation jobs, analyze execution statistics, and troubleshoot performance bottlenecks or circular references.
Reporting & Data Analysis
Smart View Mastery: Advanced skills in using Oracle Smart View for Excel to extract, manipulate, and analyze complex multi-dimensional datasets.
Allocation Tracing & Balancing: Expertise in using Rule Balancing reports and the visual Allocation Trace tool to audit and verify that costs map accurately from source to target without "leakage."
Native Analytics: Experience building Profit Curves, Scatter Analyses, Dashboards, and Reports to visually present profitability segments (e.g., Whale Curves for customer profitability).
Data Integration & Automation
Data Management / Data Integration: Strong knowledge of loading metadata and financial data from ERPs or General Ledgers into PCM, including configuring import formats, location mappings, and data load rules.
EPM Automate & REST APIs: Ability to write scripts to automate monthly data loads, POV copies, model calculations, and application backups.
Enterprise Data Management (EDM): Familiarity with how corporate governance tools sync dimensions across the wider EPM suite downstream into PCM/EPCM.
Functional & Domain Knowledge
Cost Accounting Frameworks: Strong foundational knowledge of Activity-Based Costing (ABC), shared services chargebacks, IT financial management (ITFM), and corporate overhead allocations.
Transfer Pricing & Regulatory Compliance: Understanding of how tax transfer pricing or regulatory cost justifications (e.g., in utilities or insurance) translate into allocation rules.
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
Founded in 2000
2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.
Skills
Activity-Based Costing (ABC)unmatched
Analysis Skillsunmatched
Application Programming Interface (API)unmatched
Automationunmatched
Chargebacksunmatched
Corporate Governanceunmatched
Cost Accountingunmatched
Data Analysisunmatched
Data Managementunmatched
Data Setsunmatched
Engineering Procurement and Construction (EPC/EPCC/EPCM)unmatched