PEN190 - Anaplan Consultant - Anaplan Model Builder Consultant

Summary

 

• Over 13 Years of Anaplan/IBM Planning Analytics & Financial analyst experience, which include financial planning solutions from requirements gathering to design and testing, implementation and production support.
• Expertise in Working with Anaplan Model (Budgeting Planning & Forecasting, Workforce Planning, Supply Chain)
• Certified level 3 Anaplan Model Builder
• Experience working within SDLC framework like waterfall and Agile
• Analyse existing business processes and explore system automation
• Design, develop and implement Anaplan applications for Financial Planning and Budgeting models with Complex rules
• Also experienced in Planning Analytic Workspace Models which includes Scorecard, Dashboards and adhoc Report
• Development of Turbo integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimension, hierarchies and cubes
• Converted business needs into comprehensive models and dashboards
• Used Anaplan OLAP technology to provide financial solutions
• Built and maintained Anaplan Cloud Enterprise software
• Collaborated with major Finance and procurement personnel
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule -mappings of relational data into dimensional model
• Deployed the TM1 data into production environment
• Documentation of multi-organizational planning and budgeting models

Technical Skills

Proficient in working with ANAPLAN tools:

• Anaplan Workspace
• Dynamic Scenario model Building
• Anaplan Administration
•  Dashboards & Reports
• Action & Business Rules
• Data Hub
• Score carding

Proficient in working with IBM tools:

• Cognos Planning analytics/TM1 9.5 – 10.2.2,PA 2.0.2
• Architect
• TM1 TurboIntegrator
• Contributor/PMPSVC, TM1 Web Application
• Planning analytics Excel
• Cognos Insight
• Planning analytics workspace
• Report building

Experience in handling IBM forecasting tool:

• SPSS (Statistical Package for Social Science) Proficient with Cognos series 10:
• Cognos server installation, Cognos TM1 Admin server
• Perspective
• Performance Modeller

Hands on IBM database connector:

• IBM Framework Manager
• Cognos Connection, Configuration Manager
• Query studio
• Package connector

Virtuoso in utilizing database management systems:

• Oracle, SQL server
• MS Access, DB2
• Essbase

Sound knowledge of programming languages:

• VB.Net, Java

Adept in using Microsoft programs:

•  MS Project, MS Office
• MS Access, MS Excel (certified)

Strong ability to:

• Apply OLAP concepts to real life problems
• Design and maintain complex models

Certification

• Certified Anaplan Solution Architect

Relevant Experience

 Project: Anaplan-Budgeting, Planning & Forecasting

 

Anaplan Lead Consultant                                                                                       Jan 2022- Till Present

Responsibilities:

• Design, develop and implement Anaplan models for different ministry specific logics (Eg-Health Ministry, Ministry of Education)
• Logical representation of combination of Responsibility Center & Planning Lines for Ministries
• Designed & developed different level of workflow approvals.

Dynamic relationship between financial transactions & Responsibility Center

• Integration between Anaplan & ORBIT(Financial data hub)
• Provided various financial reports with dynamic graphical representation
• Developed Anaplan application to gather and consolidate data in support of the footnotes in the annual report.

Anaplan Model Builder                                                                                         Dec 2020-Jan 2022

Responsibilities:

• Design, develop and implement Anaplan models for Financial Planning and Budgeting with Complex business logics.
• Developed Anaplan Workspace Models which includes Scorecard, Dashboards and Adhoc Report.
• Development of Actions & Processes to load and retrieve data from database tables and other data sources, for creating dimension, hierarchies and cubes.
• Converted business needs into comprehensive models and dashboards.
• Used Anaplan Hyper block architecture technology to provide financial solutions.
• Built and maintained Anaplan Data warehouse.
• Collaborated with major Finance and procurement personnel.
• To manage the entire project to ensure that milestone as well as clients expectation are met.
• Involved in model design (As per business aspect) and implementation (UAT and parallel run)
• Provided various financial reports with dynamic graphical representation
• Developed Anaplan application to gather and consolidate data in support of the footnotes in the annual report.

Anaplan Consultant                                                                                                  Aug 2019-Dec2020

Responsibilities:

• Designed In-house model for Budgeting Planning & Forecasting
• Integration Anaplan with 2 third party connectors-Dell Bhoomi & Snap Logic
• Build model for revenue analysis and cashflow report
• Converted excel based report in Anaplan logical analysis report

Dynamic relationship between financial transactions & Responsibility Center

• Integration between Anaplan & ORBIT(Financial data hub)
• Provided various financial reports with dynamic graphical representation
• Developed Anaplan application to gather and consolidate data in support of the footnotes in the annual report.

Anaplan Developer

June 2018-Aug 2019

Singapore based IT Company which is Consulting Partner for IBM , Anaplan ,Business Analytics & Intelligence, Cloud CRM, Enterprise Performance Management, Big Data and Data Warehousing.

Project: Anaplan & Planning Analytics- Budgeting, Planning & Forecasting

Responsibilities:

• Create POC on Anaplan Models for various Customer
• Identify key opportunities for business development on Anaplan
• Analyse existing business processes and explore system automation.
• Design, develop and implement Planning Analytics 2.0.2 applications for Financial Planning and Budgeting models with Complex rules.
• Developed Planning Analytic Workspace Models which includes Scorecard,

 Dashboards, Adhoc Report.

• Development of Turbo integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimension, hierarchies and cubes.
• Converted business needs into comprehensive models and dashboards.
• Used IBM Cognos OLAP technology to provide financial solutions.
• Built and maintained IBM TM1 Enterprise software.
• Collaborated with major Finance and procurement personnel.
• To manage the entire project to ensure that milestone as well as clients expectation are met.
• Involved in model design (As per business aspect) and implementation (UAT and parallel run)
• Provide professional consulting services to the clients on systems.
• Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.
• Created and arranged different TM1 rule statements and performed complex calculations for cubes at N & C levels
• Created ad-hoc queries from multidimensional views for analysis.
• Created Dynamic Reports from worksheets and Cube views using different perspective functions
• Create version transfer.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule -mappings of relational data into dimensional model.
• Deployed the TM1 data into production environment.
• Documentation of multi-organizational planning and budgeting models.
• End to end report on Planning analytics workspace
• Extracting contributor application in PAW.

Cognos TM1 Developer

November 2017-June 2018

 

Essel Propack is a Global Brand Manufacturing Aluminium & Plastic Laminated Tubes, Caps & Closures catering to the FMCG and Pharma space.

Project: Budgeting, Planning & Forecasting

Responsibilities:

• Designed and maintained TM1 hierarchical cubes and security procedures.
• Developed budgeting and forecasting cubes and designed standard operating manuals.
• Liaised with internal and external IBM/ Cognos teams to resolve tickets and troubleshoot errors.
• Integrated existing systems with latest technology utilizing Cognos tools.
• Collaborated with source system experts to design ETL routines.
• Executed complicated business transformations with help of TM1 processes.

Cognos TM1 Developer                                                               September 2015 – September 2017

Lupin Pharmaceuticals is among the top five pharmaceutical companies in India dedicated to delivering high-quality, branded and generic medications trusted by healthcare professionals and patients across geographies.

Project-1: TM1 Demand planning & forecasting-SPSS

Responsibilities:

• Actively participated in Demand planning forecasting model from initial information & data gathering phase to development phase.
• Managed complex development, solved technical bugs to stabilize the developed model.
• Designed and maintained TM1 hierarchical cubes and security procedures.
• Enhanced forecasting reports generated from SPSS & migrated to TM1 for users.
• Developed Perspective based Dashboard with multiple users.
• Usage of advanced scripting to avoid common mistakes done by users
• Prepared real time business requirement and integration with the use of efficient rule feeder combination
• Integrated existing systems with latest technology utilizing Cognos tools.
• Executed complicated business transformations with help of TM1 processes.

Project-2: TM1 Material Requirement Planning validation

Responsibilities:

• Involved in gathering business requirement, development, optimization and support phase
• Developed complex TI’s and rules used to streamline the business process
• Optimized TI performance to reduce end to end cycle time
• Updated dynamic masters, real time MRP validation reports
• Version transfer to get multiple cuts of separate month R validation reports
• Involved in downtime activities
• Created applications to manage business process
• TI’s uses dynamic views and subsets (MDX subsets) to avoid unnecessary calculations
• Logical approach while developing TIs to reduce data processing time
• Given Demo session to users with respect to how to use model, which data to be uploaded, whether model is meeting the end user needs.
• Regular follow up with users to check the accuracy of MRP generated by the model.

Project-3: TM1 LRP Project (Long Range Planning)

LRP is an integration of Demand planning, Supply planning & Capacity Planning Model.

 This model is comprising of 3 different department users which are interlinked. The Model development was challenging as the data source was dependent on different department and at different data product stage.

• Updating Master Data
• Interlinked between different cubes updated by different department
• Build what if analysis
• Loading other files like Requirement in Pack/SKU/Product Type/Discount/API

•