PEN188 -  Anaplan Solution Architecture

• Over 20+ years of ERP experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementation, Upgrade and Production Support across various Industries.
• 6 Years working experience as an integration manager & lead on 4 Projects – Anaplan handled the Boomi Integration business process in SCM -IBP (MM, PP, LE, WM,& eWM) and FP&A .
• Working closely and contributes to Architecture community of practice , guiding and helping agile teams, product owners, and application architects to align with the overall enterprise architecture governance and assurance.
• Ability to work across multiple teams within business and IT organization including IT BP (IT Business Partners), Integration (CPI), Infrastructure, Anaplan ,SAP SCM-IBP. Oracle HFM/HCM, and project managers.
• Independently lead large implementation projects with Consulting focus on Application areas of SAP s Digital Supply Chain Planning solutions of SAP IBP - Sales and Operation Planning (S&OP) Build the System Landscape cross functional architectural designs to guide and contextualize solution development across products, services, projects, and systems .
• Built the Anaplan IBP as a Data Hub between corporate strategic/annual operating plans and division/functional operating monthly plans to Aligning revenue, product and market strategy with S&OP and Sales & Operations Execution (S&OE) to key customers and suppliers .
• Worked with Anaplan SCM implementation as lead in design, architecting solutions – Built the S&OP, Demand Planning, Response & Supply Planning modules and Integrate the data with SAP IBP by using the RESTful API.
• Craft projects and programs ensuring proper involvement of different Data and Analytics competencies such as MDM,Data Modelling & Engineering, SAP BOBJ/HANA, Power BI,Looker, Tableau ,Snowflake ,Visualization, Data Governance, Data Science, Data Analytics, and Service Delivery , AWS, Microsoft Azure ,GCP ,Python .
• Manages the Anaplan Team in project/performance management, scheduling, support, execution, strategy, and SOPs and Coaches, develops, mentors, and trains team members to establish a consistent level of quality, accuracy, accountability, and compliance of business Value Creation

Anaplan Solution Architecture, Modeling and Data Integration and Reporting UX

• Certified Anaplan Solution Architect - Led 6+ Anaplan engagements with solution architect role. Responsibilities include current state analysis, business requirement gathering, discovery workshops, business requirements to user story conversion, interface with Model Builders, data integration architecture including data automation, adherence of model development to Anaplan leading best practices.
• Certified Anaplan Model Builder – Highly proficient in Anaplan Model Building. Worked extensively with all advanced features of building models in Anaplan including lists, modules, line items, actions, filters, processes, snapshots, line-item subsets, security (selective access, DCA), new User Experience (worksheets, boards, and reports). Followed DISCO and SIPOC Framework.
• Data Integration Specialist – Built and automated data pipelines and data integration from external sources to Anaplan. Leveraged Anaplan Hyper Connect (Informatica), Anaplan Connect and Cloud works to build data integration as key technology components. Some of the complex transformations included encryption, decryption, developing API based calls.
• Key contributor to build and document Center of Excellence under federated model – governance, data hub strategy, user access management, model building guidelines, security, process and controls, data import and export considerations, to ensure standardization and consistency (Amazon AWS)
• Multiple Business Use Cases – IT Portfolio Management, Financial Planning and Analysis, Demand Planning, Sales Planning and Operations, IT Asset Management, Incentive and Compensation Planning.
• Led, delivered, and managed 15+ BI/EPM/MDM engagements in different technical and managerial capacities working with Big 4, multiple clients across multiple industries. The end goal is to ensure that successful delivery of the project across different solution architect role.
• Training: Train the 90 Users and 7 Customers across the US Region in Anaplan as well BI/ EPM 10 Customers, 60 Users in North America & EU Regions.

 

Industry :                                                                                                                                              ( Nov 2022 –Current ) 

Role. : Sr Anaplan Solution Architecture

• Coordinate and manage delivery of Anaplan for FP&A and Demand Planning in partnership with Globe life

Business & IT team and build architectural SME for large-scale connected planning solutions .

• Working with system implementation methodology Agile – requirements gathering, design, build/test and deploy with Jira and Sprint model (by weekly ) with FP &A ,Cash Flow Planning implementation, from scoping and requirements to design and build and on to testing and training end users .
• Worked on translating the existing solutions, spreadsheets, and business problems into sophisticated Anaplan multi-dimensional models (Sparsity) through data integration between internal data sources and Anaplan.
• Worked on building the prototypes with subject matter experts/end users and translates them into detailed design blueprints after approval Anaplan reports -Cashflow, Revenue, Demand, Workforce Business users .
• Designed and optimize end-to-end (E2E) Anaplan processes across all models/functions.
• Worked on monitoring and validating data flows/Performance in Models from the Anaplan platform .
• Working in the Python, Informatica, AWS Cloud data import through the Anaplan REST API Connector’s.
• Configured and maintained Anaplan dashboards, lists, actions, and models.
• Automated Imports and Exports using Anaplan Connector and REST API to connect Anaplan Data Hub
• Building the reporting packages by using Power BI/Tableau and working with reconciliation of the data in databases MySQL and Restful API integration with Python data at Anaplan Data Hub.
• Defined Modules, Lists, Subsets, Actions, Process based on Business requirements.
• Worked on Anaplan utilization, in collaboration with Operational Effectiveness and each function, and Build the Sparsity of the Business Model for the Performance of System

Environment : Anaplan , Oracle HFM, Yoda, SAP BPC , MuleSoft ,Agile , ,MySQL, Power BI ,Oracle HCM, Azure BI

, ServiceNow ,Coupa ,Agile ,SAP IBP , Java, Python, and SQL, Azure ,Alternatively, AWS, GCP

 

Industry                                                                                                                              ( May 2022 –Oct 2022 ) 

Role.       : Anaplan Solution Lead

 

• Serve as the in-house resident Anaplan Architecture expert to support a fast-paced and dynamic project execution with FP&A , SO&P (IBP),PPM, WFM ,Finance Models ,ICM Process.
• Worked as an Anaplan subject matter expertise (SME) in evaluation, design, and analysis for the implementation of a solutions architecture across a GTN, FP&A , Work Force group business applications and Involved the Oracle, Python, SAP IBP, Oracle HFM technologies for data integrations on enterprise business strategy, business capabilities, value-streams, business requirements and enterprise standards.
• Provide end-to-end technical expertise and knowledge in support of architecture, UI and data model design, security, and created the lists, modules, build dashboards supporting business processes deployment .
• Design the platform Operation owners on auditing the performances of the overall platform and suggest optimization on the configuration of the platform Centralize and optimize period-end closing activities. Allows soft closes during the monthly ,Demand and Supply Planning, and S&OP/IBP processes.
• Worked with integrating an SAP, Adaptive Insights, OneStream, Planful, Hyperion application FP&A application in Anaplan Platfrom for business reports.
• Worked with SQL to create, manipulate and concatenate large datasets and Google Analytics ,Tableau, Python and integrated the data Anaplan datahub by using the RESTFul API’S and MuleSoft
• Worked with all features of BI Data Sources, Extracts, Data Visualizations with Anaplan API Connect.
• Independently lead large implementation projects with Consulting focus on following Application areas of Anaplan Digital Supply Chain Planning solutions IBP -Sales and Operation Planning (S&OP)
• Build the Anaplan Data Hub and Import the Data from Python ,SAP SCM/IBP by using the RESTful API design to adopt machine learning ,through pre-built solutions for forecasting and custom build solutions in Anaplan Data Hub Sales and Operation Planning (S&OP) as well as Supply Chain Planning Data (Spoke Models).
• Working in Tableau server best practices: including administration, security & clustering.
• Configure and maintain Anaplan lists, modules, dashboards, actions, and other model settings to meet business needs.

Environment : Work Day , Sale Force ,Salesforce ,SAP S4HAN ,SAP S CM-FI,SAP BPC ,SAP HANA  TABLEAU

,JAVA, Oracle HFM,HP ALM , MuleSoft, Looker ,Oracle HFM ,Agile ,Coupa, Python, My SQL ,XML, Postman

 

Industry:                                                                                                                                  ( Mar 2021 To April 2022)

Role: Sr Anaplan - Lead

• Work closely with business members of SCM business functions to facilitate effective solution implementations and provide knowledge transfer of system functionality to Super Users, Subject Matter Experts, and end users
• Design effectively & efficiently to cover processes & requirements into detailed blueprint: enterprise models with associated modules, lists / line items, and calculations as supported by multi-dimensional Anaplan .
• Build the Anaplan Data Hub and Dashboards for key planning function in SCM-IBP process including multiple forecast methods, ability to segment demand and supply, optimization capabilities for capacity and inventory, generation of material and capacity requirements and production schedules .
• Import the Data from Python by using the RESTful API design to adopt machine learning ,through pre-built solutions for forecasting and custom build solutions in Anaplan Data Hub
• Configured and maintain Anaplan lists, modules, dashboards, actions, and other model settings to meet business needs and Monitor the Data loads daily/Weekly/Monthly and Tune the Performance Issues.
• Designed the Anaplan IBP Models for key planning function and multiple forecast methods, optimization capabilities for capacity and inventory, generation of material and capacity requirements, and production schedules modules/List /Dashboards .
• Perform data validation between organization's internal systems and Anaplan and Monitor data flows to ensure all data is up-to-date and accurate and Anaplan best practices for model design and agile /Jira.
• Import the Data into Data hub and performance issues Support Solution (associated modules, lists / line items, calculations) and build the saved views in Demand and Supply Planning Model, and S&OP/IBP processes.
• Work closely with members of Sales Operations, Finance and IT to drive cross-functional alignment and process improvements for Anaplan IBP models reflecting organizational design and supply chain network structure and collaboration, and visibility across within business .
•    Translate existing solutions, spreadsheets, and business problems into sophisticated Anaplan multi- dimensional models with Design Anaplan data architecture and work with Finance Systems / Technology

Client :                                                                                                                          (May 2019 to Feb 2021) 

Role: Anaplan Lead

• Leads organization wide team of Anaplan data engineers for all stages of design and development for complex,

secure and performant data solutions and models, including design, analysis, coding, testing, and integration of structured/unstructured data and translate the business to Technical Cloud connect -Anaplan Architecure.

• Interface with both internal/external technical experts to drive system solutions and Map dataflows across many systems with clarity and accuracy with Data Hub .
• Worked with (IBP) demand, supply and business partners within the organization that support the demand and S&OP functions to support planning visibility to the S&OP process targeting inventory reporting, variance to Finished Goods and Raw material plans data integrated from SAP IBP System to Anaplan Data Hub and deliver the Anaplan Dashboards by import the data Tableau, Power BI, SAP HANA, Azure data Systems,
• Worked with enhancement of Anaplan models for new features and worked on conceptual functional designs relating to business needs and create the solution designs to improve architecture review board and Design Architecture existing system and assessing impact of new and ongoing Anaplan dashboards /Model to the business and IT and Review and evaluate Anaplan objects against user stories, requirements and design
• Design and Develop the Data ware housing and Data modelling business segments with Oracle HFM GL Data.
• Build & design the Anaplan Models based on the Business Processes Budgeting & Planning, Rolling Forecast, overhead, Supply and Sales , Purchasing, Sales & Operations Planning, and Capacity Planning processes and configuration Models and Import the Data from Oracle GL Account and Coupa Systems
• Integration in S4 Hana implementations including all SCM replacement modules such as Integrated Business Planning SAP BPC with Anaplan Models through integration of Dell Boomi .
• Build the Business Process in Anaplan Model performance and work with best practice to improve the Finance, Work Force, Demand and Supply Planning, and S&OP/IBP processes Management business users
• Integrate the data with SAP and Oracle HFM GL(AP/AR) Data with Anaplan Models and generate the Dash boards in Google Looker /Power BI and automated the publish reports .

Functions : Oracle HCM, Work Day ,Anaplan ,SAP ,Tableau , Agile , CRM ,AWS ,Mule Soft ,Java ,Informatica

.Oracle HFM ,Coupa , MuleSoft , SOAP UI. Postman ,Java, XML , Tableau, Power BI, SAP HANA, Azure data

 

Client :                                                                                                                                        (Sep 2017 to April 2019)

Role: Anaplan Lead

• Leads organization wide team of Anaplan data engineers for all stages of design and development for complex, secure and performant data solutions and models, including design, analysis, coding, testing, and integration of structured/unstructured data.
• Designing the Anaplan Solution based on functional requirements and validation requirement and Design in a scalable, less maintenance way Demand and Supply Planning, and S&OP/IBP processes.
• Developed the Agile project methodology, deliver projects from the development of project plans, running workshops with clients, requirements gathering, sprint planning, user training, UAT, and solution implementation
• Deliver Anaplan Model and system build along with existing system enhancements FP&A ,SCM, WFM
• Review and evaluate Anaplan objects against user stories, requirements and design dash boards
• Work with Anaplan Models based on the Business Processes Budgeting & Planning, Rolling Forecast, overhead, Supply and Sales , Purchasing, Sales & Operations Planning, and Capacity Planning processes and configuration Models and work with Anaplan Connector and REST API to connect Anaplan Data Hub to import the data Tableau, Oracle HFM/HCM ,Power BI, SAP HANA, Azure data
• Created the Anaplan Dashboards with drivers (KPI’S) of change and react within planning lead times, such as plan to actual performance and Automation of business processes IBP cycle and decision
• Maintaining shared services, metadata, security, artifact objects (task lists, rules, data forms )
• Worked Anaplan design ,List, Actions, create Dashboards and financial reports using SmartView
• Designed and creation of backup and recovery operations of the Planning application DEV/QA/PRD.
• Design and creation of automation batch Scripting for data loads Data Hub to data Spoke models.
• Developed the model/calculations to business logic customer requirement and building Reports/templates for plan data entry. Creating calculation logics, Integration flows and Security for Users DCALevel.
• Build the Business Process in Anaplan Model performance and work with best practice to improve the Finance/Sale/Work Force Management business users .
• Integrate the data with SAP and Non-SAP Data with Anaplan Models and generate the Dash boards in Tableau

.

Functions : Oracle HCM, Work Day ,Anaplan ,SAP SCM ,Lumria,Tableau , Agile ALM , Siebel CRM ,AWS ,Mule Soft

,Java ,Informatica .Salesforce ,Power BI

 

                                                                                                                                                                     (March 2016 –Aug 2017 ) 

Role: Sr SAP BPC /BI/HANA Lead

 

• Contribute thought leadership to the development and evolution of our Enterprise Performance Management (EPM) methodologies SAP BPC With SAP BW ,SAP HANA ,Power BI development.
• Serving as a subject matter expert for Strategic Planning, Demand Planning, Inventory Planning and Replenishment systems that include SAP SCM- (IBP)/Customer Activity Repository (CAR )
• Communicate key business benefits and implications of technology decisions and outcomes to business portfolio leaders and senior executive management and Works with business and technology delivery leaders to align architecture roadmaps with business strategy and technology delivery plans
• Build the SAP SCM-IBP Dash boards in SAP BI-BEX for key planning functionality including multiple forecast methods, ability to segment demand and supply, optimization capabilities for capacity and inventory, generation of material and capacity requirements and production schedules
• Developed the SAP BPC 10.1 Planning Models and integrated the SAP HANA by ABAP and SQL Scripting and executed the SAP embedded BW for planning, with in BOBJ – Analysis for Office (AO).
• Designed the SAP BPC Input templates end to end security and meeting BCF/Intercompany eliminations.
• The Complex consolidation hierarchy with time depended complex ownership and define the Consolidation at subgroup level with cash flow.
• Built the business process design, system configuration, Master Data Management and Controls, integration of SAP ECC, formal application testing and incident handling procedures.

                                                                                                                                                                             ( No 2014 – Feb 2016 ) 

Role: Sr SAP BPC/BI/ HANA Lead

 

• Prepares, reviews, and develop the BPC actual, forecasted, and budgeted financial results utilized by regional and global business management in decision-making processes for the business areas.
• Worked with different planning inputs templates B&S, P&L, Sales, Cost center, HR.
• Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management working on through BPC Dashboards
• Designed interfaces to extract actual data from ECC/BW cube to BPC model which is required for various reporting and developed security profiles, roles and teams.
• Worked with Finance users and provided training and support in creating EPM 10.0 reports and input schedules, Maintenance of master data, loading actual, coping data from one category to another, setting environments.

                                                                                                                                                                 (April 2014 – Oct 2014) 

Role: Sr. SAP BPC -BI/HANA Consultant

• Worked Strategy of Master Data, Data Governance/Standardization, Master Data Process Design, High Level

SAP BPC Architecture and the Implementation Roadmap defined by the business case.

• Independently lead large implementation projects with Consulting focus on following Application areas of SAP s Digital Supply Chain Planning solutions of: SAP SCM IBP - Sales and Operation Planning (S&OP)
• Created a New Application Set and applied associated dimensions, defined its properties and managed dimension members in SAP BPC and Import the Data from SAP BI
• Extensively Provided the SAP BPC NW Conceptual, Logical and Physical Data Model and Relational and Master Data Model and Create the EPM reports Sale,Demand,FP&A ,OPEX ,HCM .
• Created SAP BPC NW Data Models, Application Set Dimensions, Properties and Application

 

                                                                                                                                                                   (April 2012 – Mar 2014)

Role: Sr. SAP BI/HANA & BPC Consultant

• Experience with hands-on SAP (Native) HANA development, with a solid understanding of all aspects of the

HANA platform and solution and the ability to define best practices in the deployment of reporting/analytical solutions.

• Worked with various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical and Calculation Views.
• Designed and developed of conceptual, logical, and physical data models for OLTP, EDW (enterprise data warehouse) and OLAP database solutions.
• Data modelling (Designing and building Attribute views, analytical views and calculation views) for COPA and TMA area on SAP HANA.
• Handled the complete master data and transaction data movement from BI to BPC

Industry:                                                                                                                                              (June 2011 –Mar 2012 )

Role: SAP BI/BW Architect

• Conducted Workshops for end user groups and gathered Inventory reporting requirements from Service depot Business users .
• Gathered requirements and performed gap analysis for the areas of Inventory Material(IM) moments and stocks valuation for the Supply Chain (SCM) Process .
• Data integration and extraction with SAP ECC modules (OTC, SD, APO, EWM, TM) with data extraction from SAP BI and SAP BO
• Designed and implement best practices for the architecture, development, and configuration of BW objects including Cubes, DSOs, Transformations, Extractors
• Worked in Visualization & Reporting in BO Webi, and Power BI by connect the BEX Queries
• Configured and designed BW reporting solution on Inventory module ,Warehouse ,Material ,Production Data .
• Implemented Service planning and logistics planning for service depot by using BW/BI inventory .
• Enhanced BW extractors by adding additional fields related to Material doc level like Document header text, bill of landing and performance improvement of reports/extractors .

 

                                                                                                                                                       (July 2010- May 2011 )

Role: SAP BI -BPC Architect

• Designed SAP BPC/BW reporting solution on Demand and Supply Planning, and S&OP/IBP processes.
• Work with Business & IT Teams (ERP, Security, Portal ) on data design, interfaces, extracts and reporting .
• Developed performance reports on Existing Architecture and guiding the client on performance improvements and data storage.
• BW Data Modelling objects Process Chains Transformation DTP etc. # Planning, Functions, filters, sequences, Variables and Analysis for Office Workbooks / BW Queries Using HANA Studio in BW-Bex Reporting
• Extracted High volume of Historical data from Legacy system and ECC system to BW system.
• Performed performance tuning on critical and complex queries and achieved improvement.
• Developed Open Hubs to transfer finance data to the BPC system.

                                                                                                                                                         (Sep 2009 –June 2010) 

Role: SAP BI Architect

• Configured and designed solution by using best practices for supply chain management’s APO demand planning

as per AFS standards and functionality for Sales Analysis and Plan/Actual Comparison of Sales Quantities

• Working with SAP BPC Planning process in SAP BPC, manage process flows, ensure forecast submission and Data loading controls, identification & resolution of data load issues and Management of forecast Input Templates (EPM)
• Lead the design, development and implementation of SAP BI data and Built the Bex-Reports/analytics, and business intelligence solutions in support of the data strategy and roadmap, leveraging cloud-native technology, in order to enable data and insights self-service and agile data management across the Business Units
• Extracted transactional data from ECC and planning data from S to the BW.
• Worked on system performance tuning on existing landscape data loads (millions of records) and reports and automated the system process in BI and APO systems.
• Designed a BW/SCM Solution on demand planning in BW and SCM systems
• Designed best practices for AFS master data material grid with 0material, style and size.
• Worked on performance tuning of queries and data loading in BI and SCM and automated the BI /SCM Process.

 

 ( Oct 2007 – Aug 2009 ) Role: SAP BW –BCS Consultant

Functions : SAP BI 7.0 ,SAP ABAP, SAP SD,SAP MM, SAP APO ,SAP SEM, SAP BO ,SAP FICO ,SAP BCS

Responsibilities:

• Modelled BI data source for BCS, Configuring BCS data stream with required data conversion logic. Creating updating time, version dependent hierarchy in BCS.
• Currency translation task to link company and currency translation methods.
• Configure consolidation of investment functionality, Create, generate BCS data basis, consolidation area. Leverage special version for BCS configuration, Configure/ load Consolidation Master Data for company, consolidation group, and FS item.
• Balance carry forward, Copy data, BCS –BW reporting for consolidated financial statements such as balance sheet, Income /Expense Statement.
• Customizing all measures including e.g.: Consolidation of Investments.
• Designed a BW solution for the Sales Operations users, in a BI system with CRM system as source system.
• Worked on performance tuning of queries and data loading in BI and Automated the BI process.
• Worked extensively on the trouble tickets issues Pre & post live in BI solution.
• Responsible for Leading the Designing Business warehouse using SAP BW, To meet the Daily operational and analytical reporting demands of the business

Project :                                                                                                                     ( Jan 2005 – Sep 2007 ) Role: Sr. SAP BW Consultant

Responsibilities  :

• Worked implementation SAP BW for three full global project lifecycles
• Analyze and interpret existing reporting systems With Supply ,Demand, Finance Report by Bex Reports

 

• Perform business requirement analysis, data model design, map standard business content to business requirement and develop in BW for flexible reporting
• Participate in BW Blue-print design, realization, final preparation, go-live and support
• Involve in creating and maintaining comprehensive documentation on current SAP BW system
• Designed a BW solution for the Sales Operations users, in a BI system with CRM system as source system.
• Worked on performance tuning of queries and data loading in BI and Automated the BI process.
• Worked extensively on the trouble tickets issues Pre & post live in BI solution.
• Responsible for Leading the Designing Business warehouse using SAP BW, To meet the Daily operational and analytical reporting demands of the business
• Assisted in Go-Live implementation simultaneously while working on other projects.

Functions : SAP BW 3.5 ,SAP ABAP, SAP SD,SAP MM, SAP APO ,SAP SEM, SAP BO .