Tek06772

SAP - 10 yrs


MBA

Highlights

  • Ashok has 9+ years of experience in SAC Stories, Reports and SAP Business Intelligence4.3/4.2/4.0 Dashboards,

  • Extensive experience in Creating Models, Data sets, Hierarchies, Calculations, Linked Analysis in SAC

  • Extensive experience in Combining, Loading, Transforming and Preparing the Data into SAC Models.

  • Experience in connecting OData service and creating import Quires under the Data management tab in model level

  • Extensive experience in Creating Planning models, Public Dimensions, Date and Versions Dimensions in SAC

  • Extensive experience in Calculated measures, Restricted measures, and Input controls, Story filters

  • Extensive experience in Creating Forecast Versions and uploading the data for forecasting Queries and Jobs

  • Extensive experience in Creating Data Actions and embedded them Into SAC stories by Planning trigger button

  • Extensive experience in Crating Public Dimensions and applying Data access control in Dimension level

  • Extensive experience in version management managing Actuals, Budget, forecast and publishing to Public Versions

  • Created Organization, Generic, Pubic, Date, Version Dimensions in Planning models

  • Involved in Data Distribution, Data locking, Value driver tree and Data Actions in Planning Models

  • Extensive experience in Data foundation, maintaining master data and transaction Data in model level

  • Experience in creation of Attributes, Properties, Hierarchies, Calculations, In SAP Analytics Cloud

  • Collaborating, Sharing and communicating with respective users and team members

  • Extensive experience in creating User guide Documents and giving training to end users on SAC Stories

  • Used Live & Import connections in SAC to extract the data from various source systems.

  • Developed hyperlinks, Linked Analysis, Cascading filters, Calculations, Input controls, Page filters, story filters.

  • Experience in Data blending between multiple data sources in SAP Analytics Cloud application

  • Created parent child hierarchy and level-based hierarchies, Calculated measures & Restricted measures

  • Experience in Creating Planning Budget overview reports and forecasting reports for Business users

  • Experience in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures

  • Experience in Smart insight, Augmented Analytics, Smart Discoveries, Smart Grouping and forecasting

  • Used Canvas, Responsive and Grid pages and Experience in predictive capabilities, Smart Assist, Smart Predict

  • Experience in configuring security and performing administration tasks such as defining users and teams and assigning roles and privileges in SAP Analytics Cloud.

  • Expertise in planning, designing, developing, distributing, and maintaining Universes from scratch, migrating to different environment

  • Have rich 2 years of onsite experience and have an excellent client facing


Skills
Primary Skills
  • SAP SAC

Secondary Skills
  • SAP
  • SAP BO
  • SAP BW
Other Skills
  • Reporting Tools:  SAP Analytics Cloud (SAC), SAP BI 4.2, Web I, Dashboards, Information Design Tool (IDT), Power BI
  • Databases:   SAP HANA, S/4 HANA, SAP BW, Oracle, MS SQL Server
  • Business Intelligence (BI) Tools:  SAP Analytics Cloud (SAC), SAP BI 4.2, SAP BO XI 3.1, BW 7.5
  • Platform: Windows 10
  • Reporting Tools: SAP Analytics Cloud (SAC), SAP Digital Boardrooms, BI Launch Pad, CMC, Web Intelligence 4.1& 4.0, Xcelsius 2008, SAP Dashboards, Power BI
Projects

Project 1. ST - micro - IT Industry (8 months)

    Description: STMicroelectronics is a multinational electronics and semiconductors manufacturer company headquartered in Geneva, Switzerland, the objective of this project is to develop the SAC Dashboards on funds management & Grant management, Procurement, Invoice, Payments, General ledger



    Roles and Responsibilities:




    • Collaborating, Sharing, and communicating with Business users and team members and attending SAC workshops

    • Created Models, Stories, Calculations, Dashboards, Reports, KPI’s in SAC with Canvas and Responsive pages

    • Worked with Import queries and Live queries and loaded the data into respective SAC models

    • Created Forecast Version and uploaded the data for forecasting Queries and displayed forecast versions in SAC.

    • Created Public Dimensions and added them into Planning models for the usage of master data

    • Created Attributes, Measures, Properties, Hierarchies, Calculations, In Planning model

    • Extensive experience in Combine, Blending and loading the data into SAC models

    • Creating & Connecting OData service and creating Quires under the Data management in model level



    Environment:




    • SAP Analytics Cloud, SAP HANA, S\4 HANA, SAP BTP


Project 2.Gavi Alliance - IT Industry (23 months)

    Description: GAVI Alliance is a public–private global health partnership company with the goal of increasing access to immune in poor countries, the objective of this project is to develop the SAC Dashboards on funds management & Grant management, Procurement, Invoice, Payments, General ledger



    Roles and Responsibilities:




    • Attending workshops and analyzing the data to meet the customer requirements.

    • Developing SAC Dashboards, (creating models, stories, KPI’s) by using SAP Analytics Cloud.

    • Used Calculated measure and Restricted measures in SAC

    • Creating SAC Stories, using SAP Analytics Cloud by connecting to different data sources like Excel, Hana views

    • Involved in Story design, formatting, and sharing and collaborating in SAP Analytics Cloud

    • Used live data connections for Hana Views.

    • Created custom hierarchies & Custom filters in SAC story level

    • Loading the S/4 Hana data into HANA studio and modeling the data through views and created Live connection to consume views in SAP Analytics Cloud (SAC),

    • Created Analytical models with geo dimension for using Geo Maps in stories, and used Hyperlinks, navigations, Drilldowns.

    • Created Agendas, Stories with different components like Geo maps, Forecast charts, VDTs, Planning Sheets, URLs, alerts, filters, Hierarchies, input controls, images, and Graphs.



    Environment:




    • SAP Analytics Cloud & SAP Digital Boardrooms, SAP HANA, S\4 HANA


Project 3. Government of Manitoba - IT Industry (4 months)

    Description:  Manitoba is a center of Canada. This is public budgeting project, the objective of this projects is to build SAC reports on HANA,



    Roles and Responsibilities:




    • Developing SAC Dashboards, Digital Boardrooms (creating models, stories, agendas, Digital Boardrooms) by using SAP Analytics Cloud.

    • Loading the S4 Hana data into HANA studio and modeling the data through views and created Live connection to consume views in SAP Analytics Cloud (SAC),

    • Created Linked Analysis and interaction between the charts

    • Created custom hierarchies & Custom filters in SAC story level

    • Created Analytical models with geo dimension for using Geo Maps in stories, and used Hyperlinks, navigations, Drilldowns.

    • Created Agendas, Stories with different components like Geo maps, Forecast charts, VDTs, Planning Sheets, URLs, alerts, filters, Hierarchies, input controls, images and Graphs.



    Environment:




    • SAP Analytics Cloud, SAP HANA


Project 4. NNPC - IT Industry (25 months)

    Description: The Nigerian National Petroleum Corporation (NNPC) is the state oil corporation the objective of this project is to create Dashboards and reports for each business areas like E&P, F&A, VENDOR ageing customer ageing reports



    Roles and Responsibilities:




    • Attending workshops and analyzing the data to meet the customer requirements

    • Developing SAC Dashboards, (creating models, stories, KPI’s) by using SAP Analytics Cloud

    • Involved in Story design, formatting, and sharing and collaborating in SAP Analytics Cloud

    • Crated calculated measure and Restricted measures in SAC

    • Creating SAC Stories, using SAP Analytics Cloud by connecting to different data sources like Excel ,Hana views

    • Involving UAT sessions with customers and validating the Stories \ Reports



    Environment  :




    • SAP Analytics Cloud, SAP BO, SAP BW


Project 5. Seagate - IT Industry (11 months)

    Description: Seagate Technology is an American data storage company the objective in the project is to show OTD (on Time Delivery) driver data and EOD (End of life) Driver data and Part Number Material number data.



    Roles and Responsibilities:




    • Developed Web I reports on multiple data providers by using merging option.

    • Developed Context Reports in web I

    • Used For each, For All and IN, function to Develop Reports

    • Generated and highlighted KPI’s as per customer requirement

    • Created various Charts, Graphs, Filters, Prompts, and Variables in Web i.

    • Worked with element link, Hyperlink functionalities to build Purchase order reports



    Environment  :




    • BO 4.0- Universe, Web, Dashboard, SQL Developer


Project 6. LLOYDS Banking Group (27 months)

    Description: Lloyds TSB Group plc was renamed Lloyds Banking Group plc. On 19 January 2009, following the acquisition of HBOS plc the objective in the project is they enhanced their existing business to other Groups they want to include new business fields to existing Business Reports



    Roles and Responsibilities:




    • Developed WEBI reports on SAP BW Queries using BICS

    • Worked with Input Controls, BREAKS, SORT, RANK functionality for finance reports

    • Used Scope of Analysis function to build a report

    • Used prompts and filters and Input controls in Report

    • Developed Reports using SAP Bex Quires

    • Creating users and groups and folders in SAP BO System

    • Developed the report on multiple data providers by merging common object

    • Created various Charts, Graphs, Filters, User requirement Variables and drill down reports in Webi.

    • Responsible for resolving all types of Incidents based on priority (P1, P2, P3 and P4)

    • Developed complex Executive Summary Management Monthly Dashboard



    Environment :




    • SAP BOBJ, IDT, Universe, sap dashboard design tool, SAP BW


Awards
N/A

Similar Talent

Key Skills - Self Rating
  • Basis
  • Basis

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View