OnBenchMark Logo

Kapil (RID : pp3lo5xlfgw)

designation   SAP BO Developer

location   Location : Noida, India

experience   Experience : 11 Year

rate   Rate: $17 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 73
Key Skills
SAP BO SQL Server Sap Native
Discription
  • Project Title

    Supply Chain Reporting

    Period

    From Dec’20 to Till Date

    Team Size

    15

    Role

    Hana Technical Lead

    Designation

    Associate Manager

    Project Synopsis

    Working as Hana Ninja with Supply Chain & Logistics team. Involved in Hana related development and support.

    Responsibilities

  • Getting requirements from business users.
  • Used Hana 2.0 with Xsa & WebIDE to create Hana objects.
  • Migration of Hana object changes using GitHub integration with WebIDE & Xsa.
  • Created Information Models (Attribute Views, Analytic views, Calculation Views, Sql Script based Calculation views, Hierarchies, Decision Tables) to satisfy the reporting requirements in WebIDE.
  • Designed\Developed and maintenance of persistent models(Schemas, Tables, Views) in WebIDE.
  • Migration of objects within different Hana systems using delivery units and schema mapping using CTS transport.
  • Used advanced data modelling techniques, including currency conversion, variables & input parameters.
  • Extensively worked on different node of calculation views (Union, Join, Aggregation, Rank, Projection etc.).
  • Created stored procedures, Table Functions & Scalar Table Function to accommodate complex business requirements using HanaSql.
  • Worked on creation of Scalar\Table use defined function in Hana.
  • Created trigger on Hana tables for different DML operations.
  • Administer data models in SAP Hana, including setting information validation rules, managing Schemas, the importing / exporting and transporting of data models.
  • Implement decision automation using business rules using decision tables.
  • Apply Sql Script to enhance the data models.
  • Implemented analytical privileges (Sql & Classical) to restrict data based on different user groups.
  • Loading data into table definitions, suspending data loads, resuming data loads.
  • Managed Users, Schemas and roles in Hana.
  • Query optimization using Hana Visualization Plan.

 

Database

SAP Native Hana 2.0

Reporting Tools

SAP Business Objects 4.2

Database

SAP Native Hana 2.0

Reporting Tools

SAP Business Objects 4.2

 

Employer

 

Client Name

 

Project Title

APAC DMS Reporting System

Period

From Sep’19 to Nov’21

Team Size

6

Role

SAP Hana Consultant

Designation

SAP Senior Consultant L2

Project Synopsis

U.S. Kimberly-Clark Corporation is an American multinational personal care corporation that produces mostly paper-based consumer products,

Responsibilities

Used Hana 2.0 with Xsa & WebIDE to create Hana objects. Migration of Hana object changes using GitHub integration with WebIDE & Xsa. Created Information Models (Attribute Views, Analytic views, Calculation Views, Sql Script based Calculation views, Hierarchies, Decision Tables) to satisfy the reporting requirements in WebIDE. Designed\Developed and maintenance of persistent models(Schemas, Tables, Views) in WebIDE. Migration of objects within different Hana systems using delivery units and schema mapping using CTS transport. Used advanced data modelling techniques, including currency conversion, variables & input parameters. Extensively worked on different node of calculation views (Union, Join, Aggregation, Rank, Projection etc.). Created Stored procedures, Table Functions & Scalar Table Function to accommodate complex business requirements using HanaSql. Worked on creation of Scalar\Table use defined function in Hana. Created trigger on Hana tables for different DML operations. Administer data models in SAP Hana, including setting information validation rules, managing Schemas, the importing / exporting and transporting of data models. Implement decision automation using business rules using decision tables. Apply Sql Script to enhance the data models. Implemented analytical privileges (Sql & Classical) to restrict data based on different user groups. Loading data into table definitions, suspending data loads, resuming data loads. Managed Users, Schemas and roles in Hana. Query optimization using Hana Visualization Plan.

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!