Business Transformation Consultant - Finance Analytics

Location-Pan India

Notice Period-Immediate-10 days

The role focuses on designing, building, and optimizing IBM Cognos TM1/Planning Analytics solutions for enterprise finance use cases such as budgeting, forecasting, and Actuals MIS reporting. You will develop TM1 artefacts including cubes, dimensions, rules, feeders, MDX-based subsets/views, and TurboIntegrator (TI) processes. A key part of the role is ensuring secure, performant, and reliable data flows via ETL and robust security administration across clients, groups, cubes, and dimensions. The consultant partners with finance stakeholders to translate requirements into scalable Planning Analytics models and user-facing web sheets. Ongoing responsibilities include performance tuning, data integration, and continuous enhancement of financial planning applications.

Required Qualifications

• Hands-on expertise with IBM Cognos TM1 / Planning Analytics (PA)
• Strong proficiency writing TM1 Rules and Feeders (SKIPCHECK/FEEDERS best practices)
• Experience designing cubes, dimensions, hierarchies, views, and subsets
• Ability to write MDX expressions for dynamic subsets and reporting views
• TurboIntegrator (TI) processes for ETL, scheduling (Chores), and automation
• Performance optimization of cubes, rules, feeders, and data loads
• Security administration across clients, groups, cubes, dimensions, and elements
• Experience delivering budgeting, forecasting, and Actuals MIS reporting models
• Data integration from relational/flat file sources; logging and error handling
• Cognos Analytics integration/reporting (good to have)
• SQL querying for data extraction/validation (good to have)
• Development of TM1 Web/Web Sheets or Excel-based templates (Perspectives/PAX)

Responsibilities

• Design, build, maintain, and enhance Planning Analytics applications for budgeting, forecasting, and Actuals MIS reporting.
• Develop TM1 artefacts: cubes, dimensions, hierarchies, rules, feeders, MDX-based subsets/views, and TI processes.
• Create and administer security at all levels: clients, groups, cubes, dimensions, and element security.
• Implement robust ETL using TI, including scheduling (Chores), data validations, and error handling.
• Optimize model performance (rule design, feeder tuning, consolidation strategy, process optimization).
• Develop user-facing web sheets/templates and ensure usability and adoption by finance users.
• Integrate data from multiple sources and validate results against source systems using SQL where applicable.
• Troubleshoot issues, monitor logs, and support deployments/migrations across environments with documentation.