• Worked as HANA Modeler in a new project.
• Involved in project Modeling, Data Replication and Development from the Scratch.
• Responsible for creating views using HANA Studio and Replication of tables to hana data base using SLT techniques.
• Support for creating reports on Analytic Views and Calculation views of Sales Data.
• Created Input parameters, Variables, Calculated columns, restricted columns (KPIs) according to the business requirement.
• Imported data through flat files into SAP HANA and created schema and required tables.
• Created procedures and used them in table functions and calculation views.
• 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 Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data.
• Involved in design and development of Advanced DSOs and Composite providers.
• Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
• Imported data through flat files into SAP HANA and created schema and required tables.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Involved in creating and maintaining Info Cubes, Data Store Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process and Info Packages.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of DTP and these Process chains are scheduled for periodic loads.
• Customized the InfoCubes (Basic Cube, MultiCube), Info Source and InfoObjects.
• Involved in creation of Transformations and Data transfer process to load data from PSA to data targets.
• Involved in Monitoring the Process Chains like daily, weekly and monthly loads.
• Monitoring of Process Chains and analyzing the reasons for frequent failures of Process Chains.
• Involved in the requirement gathering phase.
• Worked in transforming Business Requirements into detailed Technical Specifications and Data Models related to the requirements.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Maintaining the queue – related to the system-generated tickets and customer-generated tickets.
• Maintaining Work History for all the tickets until it is closed down.