SIKANDAR

SAP BW/BO, HANA, SAC Consultant

                            

Professional Summary

 

Having 10+ years of total experience including 9+ years of IT experience in SAP BW/BI,

 

HANA, SAC, and expertise in the technical areas of SAP BW, HANA, BO, and SAC with full cycle implementations and good experience in Webi Reports, Dashboard Reports and Universe Design, IDT in BO 4.2, SAP Analytics Cloud, Power BI and good knowledge on Tableau 10.0

 

A highly challenging role in Business Intelligence where I can apply my creative, analytical development skills and experience to the Organization. To always strive hard and thrive on challenging situations and do better than the best.

 

 

BW on HANA/ BW4HANA Expertise:

 

• SAP HANA data modelling using Calculation Views and SAP System Landscape transformation (SLT).
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Understanding of SAP In-Memory Computing Architecture, Column store, Row store Tables in SAP HANA studio.
• Migrating standard Info cubes to in memory optimized Info cubes using migration Tool.
• Importing the BW Models into HANA using HANA Studio.
• Worked on Advance DSO, Composite Provider and Open ODS View for development.
• Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
• Created Input parameters, Variables, calculated columns, restricted columns (KPI’s) according to the business requirement.
• Created Calculated Measures and Restricted Measures in Aggregation node to serve different business requirements.
• Experience in native HANA modelling - CDS, SQL Scripting, Graphical view-modelling, SDA extraction
• Experience in BW4HANA and S4HANA.

• Good Experience on working with SAP Data Integration tools like SDA, SDI and SLT
• Experience and well versed in BW and Native HANA Transports.

• Worked on performance tuning the HANA models using Explain plan and Visualize plan.
• Worked on Analytic privileges and assigning them to HANA models

 

 

SAP BW EXPERTISE:

 

• Attended Business meetings and assisted Business Analysts in gathering requirements.

 

• Experience in working with SAP BW applications like SD, MM and FI, HR & FSCD

 

• Worked on SAP BW 7.5 on HANA.

 

• Experience in working with standard and custom Info Objects, Info Area, DSO, Info Cubes and Multi-provider.

 

• Experienced in installing BI content, FI extraction, LO Cock-Pit, generic extractors.

 

• Activating and Replicating Standard Data source including Transaction and Master Data. Generic Data source using Table, View and Function Module.

 

• Handled Start routines, field routine and End routine at transformations level.

 

• Performed Performance Tuning in BI/BW by creating indexes for frequently used queries, Partitioning, Compression and Aggregates on Info Cubes.

 

• Experience in End-to-end testing of an application and designing of test cases.

 

• Extensively worked on Query Designer and created Restricted Key Figures, Calculated Key Figures, Characteristic Restrictions, Variables, filters, Conditions, and exceptions.

 

• Expertise in transportation of objects in different systems.

 

• Prepared a technical spec’s document according to what I have designed and developed.

 

• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.

• Experience in Delta Upload and Full Upload using Process Chains and Info Packages to automate data loads into BW. Also created alerts in process chains.

 

• Attended meetings and assisted Business Analysts in gathering requirements.

 

• Developed RRI Jump queries to drill down from summary