Santosh Pallai

• Experience in SAC, SAP BPC (BPC 10.0, BPC 10.1), SAP BW 7.5/7.4/7.3, SAP BW4HANA and S4HANA consulting for around 10+years in Implementation, development, and support projects.

• SAC Consultant with knowledge of solution delivery, integration, data modelling and reporting.
• Experience in SAC-Data wrangling, Model config, Story development, Security development
• SAP Analytics cloud – Analytics, Planning and Data visualization.
• Managed all phases of project from Requirements gathering, blueprinting, configuration, Integration testing, Training to Go live, documentation, Post Go live support and end user training.
• Delivered projects by following agile process and part of UT, SIT, Hypercare and KT.

SAP Analytics Cloud

• SAC Consultant with knowledge of solution delivery, integration, data modelling and reporting.
• Experience in SAC-Data wrangling, Model config, Story development, Security development
• SAP Analytics cloud – Analytics, Planning and Data visualization.
• Managed all phases of project from Requirements gathering, blueprinting, configuration, Integration testing, Training to Go live, documentation, Post Go live support and end user training.
• Delivered projects by following agile process and part of UT, SIT, Hypercare and KT.

• Creating AFO (Analysis for Office) Input Template /Reports using Input ready Bex Query.
• Extensive work experience on developing SAP EPM Reports/Input Templates.
• Designing BPC solution structure i.e., Model, Dimensions based on the requirement.
• Experience in creating BPF, Transformation and Conversion Files for MD and TD Loads.
• Experience in fixing the issues related to Data Manager Packages, Logic Scripts.
• Experience in Debugging Data Manager Packages & Logic Scripts.
• Work status and Security configuration (Users, Teams, Task profiles, Data Access Profiles).
• Writing VBA –Macros required for EPM Reports/Excel sheets.
• Exposure in writing and executing test cases, UAT support, Knowledge Transfer.

• Modeling the objects with SAP HANA Studio like (Advanced DSOs, Composite Providers, Aggregation levels, Open ODS views, ODP/ODQs, Bex Queries etc..).
• Exposure in SAP BW Modelling, Extraction, Retraction & Reporting.
• Data reconciliation, Process chain build and monitoring

• Responsible for efficiently delivering the project and supervising the implementation team.
• Exposing Data Models into SAC using acquired connection.
• Creation of Bex queries through Hana Studio 2.0 in SAP BW/4HANA system.
• Leveraged Bex queries in SAC to create planning and Analytic models.
• Designed and developed complete flow to do the reporting in SAC.
• Created data locks, multiples data action, and multi action through script to deliver complex requirements.
• Worked on data movement (like Balance sheet and P&L accounts to Cash flow) between models through data action.
• Created complex Stories such as Forecast, KPI and P&L using acquired connection in SAC.
• Created reports using excel add-in for SAC to do the mass entry in planning reports.
• Designed and developed more than 30 stories and Digital Boardroom in SAC.
• Created calendar event to run the multi action automatically in SAC.
• Created technical specification for all the flow developed in SAC.
• Worked on import-export of models, stories, and object from one environ to other in SAC.
• Prepared Transport Management from dev tenant to prod SAC tenant.
• Manage User creation in SAC and SAML mapping.
• Manage SSO from SAC, security restriction and email in SAML mapping in SAC.
• Tested and resolved data issues in SAC Dashboard stories.
• Created Planning model to Create finance input templates.
• Created Private and Public Dimensions and scheduled data loads.
• Created Data actions to move data from model to another model.
• Created Securities in SAC based on User security matrix.
• Used advanced SAC planning features like: Calendar, Data Action, Currency Conversion & Data locks.