Rajat Malik
Anaplan Solution Architect Finance Territory Quota Management
Habilidades
Conheça meus serviços

Portfólio
Experiência profissional
Anaplan Consultant
EY • Período integral
Feb 2023 - Jun 2025 • 2 yrs 4 mos
Process Design & Mapping – FP&A • Partnered directly with FP&A leadership to evaluate 'As-Is' financial processes, designing multiple hierarchy swimlanes and translating them into streamlined 'To-Be' technical architectures. • Authored comprehensive business design and technical solution documents to streamline To Be FP&A Process • Built solution design documents and multiple hierarchy Process Swim lanes. • Acted as SME during the entire project supported both Finance Team and Development Team. Designed & Overview Anaplan Model – FP&A Model • Configured central library models to automate the ingestion and synchronization of critical master data (Accounts, Distribution Channels, Geography) from disparate source systems. • Automated the ingestion of metadata and transactional data for 1,000+ European stores, eliminating manual data entry and reducing the FP&A consolidation cycle by 35%. • Maintain hygiene of hierarchy of more than 1000 stores across Europe and 200+ product group. • Engineered complex calculation modules for revenue and supply chain forecasting, improving cost allocation accuracy by 20% and providing leadership with actionable insights into regional profitability margins • Deployed 50+ customized UX dashboards (Boards, KPI Grids) for C-suite executives and regional heads, which decreased ad-hoc data requests by 17% and accelerated real-time visibility into regional P&L • Handled ALM – setting up Revision tag in Standard model and sync it to Prod model. User Acceptance Testing & User Training (UAT) • Guided cross-functional finance teams through rigorous UAT phases, resolving complex calculation discrepancies to ensure a seamless transition from legacy Excel models to the new FP&A platform. Developed comprehensive end-user playbooks.
Anaplan Consultant
Deloitte • Período integral
Jan 2020 - Dec 2023 • 3 yrs 11 mos
Netherland based Hypermarket– Anaplan Model Builder • Designed Data hub, automated import process and update of metadata and transactional data includes list such as Accounts, Distribution Channel, Geography, Region and Product. • Designed Sales Planning & Performance Management model central library and automated import of metadata and transactional data from Datahub, build system modules • Build complex calculation modules which include Volume and Revenue forecast by account, distributional channel, Geography and product, profit and loss by country & product group • Calculated sales commissions and incentives of sales reps and distribution channels by using complex formulas • Build 40+ UX pages for Product and Regional Managers to set stretch goals and track the performance of product/service by geography, account Other Projects– Anaplan Model Builder Supply chain model for RB to calculated Purchase Price Variance for all accounts, supplier, vendors, geography etc. FP&A Project for UK based Life Insurance Company (3 months project for UX pages) Support 15+ Anaplan POC for different clients across multiple Use cases such as Finance, Supply Chain,Workforce Planning, Capex Planning.