Venkat M

Analyze client’s business requirements and processes through workshops, interviews, document analysis & Design workflow. • Implemented Anaplan for FP&A models. • Involved in design workshops, provided input/feedback in integration design and designed datahub and spoke models build. • Designed and built staging module for the Transaction data and master data loads in Data hub model • Automated intermodal data transfers using Cloud works. • Built custom integration from SAP BPC to Anaplan via Hadoop & Web methods. • Excellent knowledge in building, Anaplan Lists, Modules, Actions, Processes & Dashboards as per Anaplan best practices. • Have excellent knowledge in building Apps & Pages (New UX) and Classic dashboards. • Responsible for production deployment across environments using Application Life Cycle Management (ALM) Process. • Adequate Knowledge of Data Loading & Data Integration. • Part of Multiple Full life cycles end-to-end implementation in Anaplan. • Helping FP&A users to reconcile numbers with source systems during month-end and quarter-end close. • Migrated BPC reports and Input forms to Pages and Classic dashboards as per user requirement. • Familiar with Agile framework, Sprint planning, writing Anaplan User stories, Solution Design Document & Test cases.

Partnered with FP&A teams and business stakeholders to gather planning requirements for expense modeling, revenue forecasting, and workforce planning across departments. • Designed and deployed scalable Anaplan models supporting OPEX planning, financial consolidation, and • rolling forecasts using best practices in modular design and sparsity reduction. • Built UX dashboards for real-time reporting, enabling variance analysis, budget tracking, and KPI monitoring. • Developed advanced time-based reporting, version control, and what-if scenario planning logic across models. • Integrated data from ERP systems (SAP, Workday) using Anaplan Connect and automated daily refreshes using Cloud Works and scheduled actions. • Maintained and enhanced data hubs, improving model integration and governance across multiple workspaces. Supported ongoing model maintenance, including Resolving user issues and data load failures. Managing user access, roles, and selective access Performing monthly/quarterly model refreshes and backups • Applied ALM (Application Lifecycle Management) for structured development and deployment across dev, test, and production. • Led UAT cycles, incorporating end-user feedback to continuously improve model usability and accuracy. • Delivered end-user support and training, created documentation and SOPs, and encouraged self-service adoption among planners and business users. • Conducted performance tuning by reducing sparsity, optimizing list hierarchies, and re-structuring heavy Formulas.

Worked closely with SAP BW, COPA, ECC, BCS and MDG team for BPC /Hyperion reconciliation issues. • Created Custom EPM/ Essbase/Smart view reports as per the user requirement. • Worked on data/user related issues and fix within SLA periods for smooth Budgeting process. • Worked closely with GFP&A and helped in planning related issues within time and supporting month end and quarter end budgeting process. • Trained the users on Smart view, Function builder in large groups. • Prepared BPC/ Hyperion systems for next Actual/ Fcst cycles as aligned with the users. • Involved in BI jobs scheduling, mapping (Hyperion to SAP), maintaining tables, job extraction in SAP • Experienced in writing Rule files for loading data from different source systems relational and flat files. • Having experience in interacting with source system and downstream system teams to maintain data consistency across the environments. • Experienced in converting existing Excel Addin Templates to Smart view Templates and reports. • Handling data load failures happening through EIS from Relational database to Essbase databases. • Moving Essbase outlines and data from one environment to other environments. • Creating users, groups in Shared Services and assigning users access to Essbase and clarity applications and handling User Security related issues. • Coordinating with Server Team for maintaining Essbase servers on Dev/QA/UAT/Production environments. • Involved in Disaster recovery supporting and month end supporting process for the Budgeting and forecasting process. • Interacting with Oracle Support to work relate to product related issues. • Managing metadata add/delete/move in Hyperion Planning manually. • Building Dimensions in Hyperion Planning Outline Load Utility. • Created complex planning web forms and supporting details. • Creating Planning Task Lists and Smart Lists and Menus as part of Budgeting process.

Developed the requirement document and technical design document for the implementation. • Analyzed all the dimensions and members in the Essbase database using Essbase Administration Services. • Decided upon the design of data forms and developed the form as per the final design • Specific role as Essbase Administrator involved Shared Services security development for Essbase and Planning. • Closely worked with System Administrator to resolve server related issue. • Developed business rules allocation rules, Aggregation rules, driver-based calculation & member formulas • Set up group security using shared services and cluster in EAS • Created Maxel to automate cube build process for the existing Planning application • Worked extensively on optimization of the Essbase cube and the query performance for the reports • Created rule file to upload data using flat files and automate the process via MAXL • Automated and set up transparent & replicated partitioning to transfer data from the global application to reporting cubes • Helped the users during UAT and fixed the technical issues during UAT • Used Financial Reporting studio to develop monthly P&L, budget & balance sheet reports • Used Web analysis to develop monthly P&L, budget & balance sheet reports • Migrated the planning application from Dev to QA to production using LCM • Developed the ASO application used by the end users for reporting • Trained users to understand planning web client, Smart View, Workspace, Web analysis & Excel add in functionality • Responsible for migration of the planning application from one environment to other • Support & troubleshoot day to day issues for the developed application.