Mahalakshmi Tamilselvan
Bengaluru
Summary
Highly skilled and results-driven Senior Anaplan Model Builder with over 3 years of experience in designing, developing, and optimizing complex Anaplan models across multiple business functions, including finance, Budgeting, and Forecasting. Expertise in collaborating with cross-functional teams to gather requirements, transform business processes into actionable Anaplan solutions, and deliver high-performance models that drive business efficiency and decision-making. Proven ability to mentor junior model builders, deliver comprehensive training, and lead client-facing projects to successful implementation.
Overview
3
3
years of professional experience
1
1
Certification
Work History
FP&A and Forecasting
Global Certification Service Company
03.2024 - 11.2024
- Decoded 250+ modules, lists, line items, UX pages, and Management reports
- Implemented granular hierarchies (Subsidiary - Location) over 35+ PL report modules and UX pages
- Prepared user manual for the forecast cost adjustments application with detailed functionalities
- Built finance control tower with actual and forecast for monthly business performance control tower
- Implemented Currency Conversions and Impact Analysis for 8+ Currencies: INR, CAD, USD, EUR
- Created Monthly Performance reports with insightful visuals: Column Graphs and waterfall Analysis
- Implemented forecasting process in revenue and costs with relevant drivers based on the budget and revenue
- Implemented Disaggregation logic in two different levels of hierarchies: [Geo to Product, Product to Account]
- Implemented Statistical Forecasting based on Forecast Drivers with insightful Trend analysis
- Built Indirect Cash Flow report using Cash impacts mapping techniques
- Incorporated Balance Sheet Actuals with Imports and automated integrations
- Created Financial Liabilities Schedule for Internal and External Loans with Elimination logics
- Built Direct Cash flow based on working capital summary using DSO and DPO inputs and logics
Business Planning [Budgeting]
Global Certification Service Company
10.2023 - 02.2024
- Executed Capex planning, Revenue, Cost of Sales, and Payroll budgeting, including other operating costs
- Automated FTE Employee creation using Input details from End users through logic and imports
- Executed Intercompany Business transactions with Elimination processes
- Created user manuals and demonstrated the entire process flow to customers and managed the queries
- Created 60+ intuitive user experience (UX) pages with (KPI) cards, grids, and streamlined submission processes
- Implemented features such as snapshots, process workflows, security measures, and variance analysis into the process.
Strategic Planning and Financial Performance
Global Certification Service Company
03.2023 - 09.2023
- Built strategic planning for Revenue, OP Margin, and Capex using Top-Down and Bottom-Up Strategies
- Implemented what-if scenario analysis for strategic planning model: Pessimistic, Realistic, and optimistic
- Implemented consensus planning for strategic top-down and Bottom-up with Review rejection provisions
- Built 20+ customer dashboards with insightful input grids, charts, KPIs, and graphs
- Implemented Snapshot Modules, Security Mechanisms, and Variance Analysis
- Documented 4+ user manuals for Strategic Planning application with detailed functionalities
Sales & Operations Planning
Global Product Manufacturing Company
09.2022 - 02.2023
- Decoded 300+ UX pages: Demand Rolling Plan, Production Indent, RCCP, and Sales Planning & Logistics
- 25% Reduction in the overall model size (Dev and Prod): Proprietary approach for model optimization exercise
- Implemented Snapshots, Security Mechanisms, Disaggregation Round Offs, and Variances
- Resolved 20+ Problems of different varieties: Data Mismatch, List Items Mismatch, Import errors, Export Errors
- Implemented User Onboarding Model: UX page and Actions to manage user additions and access update
- Prepared user manual documents with process maps for 65+ dashboards
Incentive Compensation Management
Global Product Company
05.2022 - 08.2022
- Created Lists, Modules, Line items, Actions, and Functional areas to get into the model design
- Implemented ICM Module: Plans, Components, Data loading, ICM Calculations, Payout process & Compensation Summaries
- Built 45+ Dashboards: Executives to review the Financial Performance, KPIs, and Attrition, Managers to Approve Incentives, and Sales Reps to Review Sales performance and Incentives
ICM Model
Global Optics Manufacturer
02.2022 - 04.2022
- Analyzed customer Excel models and built Anaplan ICM model: Lists, Modules, and UX pages
- Created time scales, concatenated lists, conditional formatting, Incentive curves, formulae, and actions
- Built 5+ UX pages, Load Sales, Earnings Summary, Rep Summary, and Incentive Summary
Senior Anaplan Model Builder/BA
Matasma Digital Technologies
11.2021 - 11.2024
- Certified in Anaplan Level 3 Model Building from Anaplan, 90% Score, Territory & Supply Planning
- Expertise in Financial Statement Analysis: Income Statement, Balance Sheet and Cash Flow Report
- Anaplan Optimizer by implementing a PoC on Territory Assignment and Replenishment
- Expertise in ALM Tasks: Development and Production Environment updates using Revision Tags
- Prepared Problem Statements on Anaplan Functions: Numerical, Logical, and Text Functions
- Implemented Demand Sensing in Anaplan: Data Collection, Statistical Forecasting, and Promotion Module
- Expertise in the snapshot process, a place for storing past data for future reference and analytics purposes
- Expertise in Disaggregation Logic to account for round error, and Error Creation to stop the process
- Expertise in solving import issues by analyzing the data flow and mapping with the appropriate source
- Created 100+ Anaplan problem statements to Excel the Anaplan formulas: Text functions, Compare functions
- Expertise in Optimizing modules by analyzing for redundant non-active line items, saved views, UX pages, and modules
- Built Dynamic time filter using line-item subset for an end user to use different periods across years
- Certified in Power BI Implementation: Power Query, Power Pivot, and Power View Visualizations
- Built suppression for end users to hide the zero columns in the UX page by an input grid
- Expertise in master data validation and testing with test scripts and demonstrations.
Education
MBA - HR And Marketing
Bishop Heber College
Trichy04-2022
BBA - Management Studies
Bishop Heber College
Trichy04-2020
Class XII -
St. John's Girls Hr Sec School
Devakottai04-2017
Class X -
St. John's Girls Hr Sec School
Devakottai04-2015
Skills
Model Building
User Experience
Agile Methodology
Design Thinking
Financial Planning & Analysis
MS Office
Testing Skills
Data Validation
Work Experience
SENIOR ANAPLAN MODEL BUILDER/BA, 11/2021 - 11/2024
Matasma Digital Technologies, Bengaluru
- Certified in Anaplan Level 3 Model Building from Anaplan, 90% Score, Territory & Supply Planning
- Expertise in Financial Statement Analysis: Income Statement, Balance Sheet and Cash Flow Report
- Anaplan Optimizer by implementing a PoC on Territory Assignment and Replenishment
- Expertise in ALM Tasks: Development and Production Environment updates using Revision Tags
- Prepared Problem Statements on Anaplan Functions: Numerical, Logical, and Text Functions
- Implemented Demand Sensing in Anaplan: Data Collection, Statistical Forecasting, and Promotion Module
- Expertise in the snapshot process, a place for storing past data for future reference and analytics purposes
- Expertise in Disaggregation Logic to account for round error, and Error Creation to stop the process
- Expertise in solving import issues by analyzing the data flow and mapping with the appropriate source
- Created 100+ Anaplan problem statements to Excel the Anaplan formulas: Text functions, Compare functions
- Expertise in Optimizing modules by analyzing for redundant non-active line items, saved views, UX pages, and modules
- Built Dynamic time filter using line-item subset for an end user to use different periods across years
- Certified in Power BI Implementation: Power Query, Power Pivot, and Power View Visualizations
- Built suppression for end users to hide the zero columns in the UX page by an input grid
- Expertise in master data validation and testing with test scripts and demonstrations.
Certification
- Anaplan Level 2 Model Building, Anaplan, 90%, Demand & Supply Planning
- Anaplan Level 3 Model Building, Anaplan, 90%, Territory & Supply Planning
- Design Thinking Workshop, Empathizing and Solving Commuters Problem
- Anaplan Optimizer Course, Linear Programming: Objectives, Variables, and Constraints
- IBM SPSS (Statistical Software), Used advanced analytics for Research papers
Timeline
FP&A and Forecasting
Global Certification Service Company
03.2024 - 11.2024
Business Planning [Budgeting]
Global Certification Service Company
10.2023 - 02.2024
Strategic Planning and Financial Performance
Global Certification Service Company
03.2023 - 09.2023
Sales & Operations Planning
Global Product Manufacturing Company
09.2022 - 02.2023
Incentive Compensation Management
Global Product Company
05.2022 - 08.2022
ICM Model
Global Optics Manufacturer
02.2022 - 04.2022
Senior Anaplan Model Builder/BA
Matasma Digital Technologies
11.2021 - 11.2024
- Anaplan Level 2 Model Building, Anaplan, 90%, Demand & Supply Planning
- Anaplan Level 3 Model Building, Anaplan, 90%, Territory & Supply Planning
- Design Thinking Workshop, Empathizing and Solving Commuters Problem
- Anaplan Optimizer Course, Linear Programming: Objectives, Variables, and Constraints
- IBM SPSS (Statistical Software), Used advanced analytics for Research papers
MBA - HR And Marketing
Bishop Heber College
BBA - Management Studies
Bishop Heber College
Class XII -
St. John's Girls Hr Sec School
Class X -
St. John's Girls Hr Sec School
Similar Profiles
Balkrishna DhakarBalkrishna Dhakar
Assistant Manager - Audit & Review at Global Sustainability Certification & Inspection Services (GSCI)Assistant Manager - Audit & Review at Global Sustainability Certification & Inspection Services (GSCI)
Ankur MaheswaryAnkur Maheswary
Global Manager-Procurement & Cost Control -(FSPM) at TOTAL IT GLOBAL- IT Managed Service CompanyGlobal Manager-Procurement & Cost Control -(FSPM) at TOTAL IT GLOBAL- IT Managed Service Company
Kellie EschenbachKellie Eschenbach
Commercial Account Manager at Global Industrial Company fka Global Equipment SupplyCommercial Account Manager at Global Industrial Company fka Global Equipment Supply