6 Calculation Views Jobs

Job Description : YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation. At YASH, we're a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth - bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future. We are looking forward to hireBW4HANA 1.0 or 2.0 Professionals in the following areas : . Hands-on experience with SAP BW4HANA, Native HANA implementation, and Support. . Build and Understand Standard and custom SAP BW Extractors functionality. . He should have at least 3 end to end implementation experiences in BW and good exposure to handling AMS projects. . Hand-on Experience in Understanding and Applying transformations using ABAP and AMDP, advanced DSOs, Composite Providers using LSA ++, and performance optimization concepts. . Hands-on experience on BW Queries. . Hands-on experience with SAP HANA data modeling views (Attribute, Analytics, Calculation views, and Analytics Privileges ) . Hands-on experience in the collection of Transport Requests through the landscape. . Hands-on Experience in fixing data load issues. . Experience in Performance tuning and troubleshooting /Monthly Release activities as necessary. . Knowledge of SAP S4HANA Business processes, and functional aspects in Sales, Billing, Finance, Controlling, Shipping, and Finance. . Having SQL scripting knowledge is an add-on. At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment.We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale. Our Hyperlearning workplace is grounded upon four principles Flexible work arrangements, Free spirit, and emotional positivity Agile self-determination, trust, transparency, and open collaboration All Support needed for the realization of business goals, Stable employment with a great atmosphere and ethical corporate culture

Develop a strong understand of business flows, processes and architecture and leverage that in designing and developing BI content. Translate business/functional requirements into technical specifications encompassing the ETL, Metadata layer and Reporting layer. Significant experience in the areas of HANA Modeling, HANA data provisioning, HANA Views and SQL Script, Stored procedures. Hands-on development within all layers of the SAP Datasphere environment. Data acquisition, modeling, transformation, and load to HANA Platform. Design, build and execute data conversions from legacy systems. Write and execute test plans (unit, regression and integration) Technical and user documentation and training. Provide production support and user support, including researching data questions. Provide technical guidance and oversee work completed by junior team members Required Experience: 6+ years of full life-cycle experience in Data Warehouse/Reporting projects, preferably in an SAP environment. Hands-on experience in all facets of EDW Architecture, Data flow strategy, Data modeling, Metadata & Master data management. Experience with SAP HANA architecture and HANA Modeling. Understanding of HANA data provisioning, HANA views and SQL Script. Experience in SAP Datasphere implementation project with different data source like ERP (SAP ECC on HANA), Oracle R-12 Knowledge on extracting data from various sources including SAP and non-SAP system to SAP DS is required. Knowledge on Advanced modeling concepts including Analytic Views, Attribute Views, Hierarchies, Creating Restricted & Calculated Columns, Filter Operations, Variables, Creating Calculation Views, SAP HANA SQL, SQL Script and Procedures.Understanding of BI and HANA security (users, roles, privileges, etc).Excellent written and verbal communication skills Strong technical documentation SAP Datasphere Knowledge Location : -Remote

Develop a strong understand of business flows, processes and architecture and leverage that in designing and developing BI content. Translate business/functional requirements into technical specifications encompassing the ETL, Metadata layer and Reporting layer. Significant experience in the areas of HANA Modeling, HANA data provisioning, HANA Views and SQL Script, Stored procedures. Hands-on development within all layers of the SAP Datasphere environment. Data acquisition, modeling, transformation, and load to HANA Platform. Design, build and execute data conversions from legacy systems. Write and execute test plans (unit, regression and integration) Technical and user documentation and training. Provide production support and user support, including researching data questions. Provide technical guidance and oversee work completed by junior team members Required Experience: 6+ years of full life-cycle experience in Data Warehouse/Reporting projects, preferably in an SAP environment. Hands-on experience in all facets of EDW Architecture, Data flow strategy, Data modeling, Metadata & Master data management. Experience with SAP HANA architecture and HANA Modeling. Understanding of HANA data provisioning, HANA views and SQL Script. Experience in SAP Datasphere implementation project with different data source like ERP (SAP ECC on HANA), Oracle R-12 Knowledge on extracting data from various sources including SAP and non-SAP system to SAP DS is required. Knowledge on Advanced modeling concepts including Analytic Views, Attribute Views, Hierarchies, Creating Restricted & Calculated Columns, Filter Operations, Variables, Creating Calculation Views, SAP HANA SQL, SQL Script and Procedures.Understanding of BI and HANA security (users, roles, privileges, etc).Excellent written and verbal communication skills Strong technical documentation SAP Datasphere Knowledge Location : -Remote

SAP HANA DB Modeler/Developer" is responsible for designing, developing, and maintaining data models within the SAP HANA database, utilizing advanced modeling techniques to optimize data access and analysis for reporting and applications, often collaborating with business analysts to translate requirements into efficient database structures while ensuring data integrity and performance within the HANA platform. Must have skills should include: Hana Views( Analytical, Calculation etc.) , SAP HANA XS JavaScript and XS OData services, Advanced DB Modelling for Hana, SAP HANA Data Services ETL based Replication amongst others. Minimum 2 3 end to end implementations. Key responsibilities may include: Data Modeling: Designing and creating complex data models in SAP HANA Studio using analytical views, attribute views, calculation views, and hierarchies to represent business data effectively. Implementing data transformations, calculations, and data cleansing logic within the HANA model. Optimizing data structures for fast query performance and efficient data access. Development: Writing SQL scripts and stored procedures to manipulate and retrieve data from the HANA database. Developing custom HANA functions (CE functions) for advanced data processing and calculations. Implementing data loading and ETL processes to populate the HANA database. Performance Tuning: Analyzing query performance and identifying bottlenecks to optimize data access and query execution. Implementing indexing strategies and data partitioning for improved query performance. Collaboration: Working closely with business analysts to understand data requirements and translate them into technical data models. Collaborating with application developers to integrate HANA data models into applications. Security and Governance: Implementing data security measures within the HANA database, defining user roles and permissions. Maintaining data quality and consistency by defining data validation rules. Required Skills: Technical Skills: Strong understanding of relational database concepts and data modeling principles. Expertise in SAP HANA modeling tools and features (HANA Studio, Calculation Views, Analytical Views) Proficiency in SQL and SQL optimization techniques Knowledge of data warehousing concepts and best practices Soft Skills: Excellent analytical and problem solving abilities Strong communication skills to collaborate with business users and technical teams Ability to work independently and as part of a team

SAP HANA Senior Developer should analyze, plan, design, develop, and implement the SAP HANA solutions to meet strategic, usability, performance, reliability, control, and security requirements of Analytics reporting processes. Requires good knowledge in areas of Analytics, Data warehouse and reporting applications. Must be innovative. Work you will do Should be able to understand the platform issue and troubleshoot the same and bring the DB back to working status, if required setup calls with Vendor for troubleshooting the issues. Should be able to understand the functional requirements from the client and appropriately convert them into Technical Design documents. Should be able to lead/assist the team with his/her technical skills whenever an issue is encountered. Should have good team leader skills to co-ordinate with team members. Should be able to assist the team with his/her technical skills whenever an issue is encountered. Build relationships with clients and keeping abreast of the various client developments. Excellent written, verbal, listening, analytical, and communication skills are required. Highly self-motivated and directed. Experience in working in team-oriented, collaborative environment. Key Responsibilities Performing troubleshooting and problem resolution of applications built and being supported. Performing effort estimation for various implementation and enhancement activities. Perform SAP HANA Data Modeling as required. Perform ETL (Extraction Transformation Load), preferably SAP Business Objects Data Services (BODS), as required. Support and coordinate the efforts of Subject Matter Experts, Development, Quality Assurance, Usability, Training, Transport Management, and other internal resources for the successful implementation of system enhancements and fixes. Participate in the continuous improvement processes as assigned. Work with team members to analyze, plan, design, develop, and implement solutions to meet strategic, usability, performance, reliability, control, and security requirements. Create and maintain internal documentation and end-user training materials as needed. Provide input to standards and guidelines and implement best practices to enable consistency across all projects. Education: Bachelors degree in Computer Science or Business Information Systems or MCA or equivalent degree. Qualifications: 6 to 8 years Advanced Level of experience in design & creation of Information Models in HANA using Table Functions, Procedures and Calculation Views. Good knowledge and experience in HANA SQL is must. Good knowledge and experience in at least ETL (Extraction Transformation Load), preferably SAP Business Objects Data Services (BODS), is needed. Advanced level of experience in using aggregate and Window functions is must. Foundational understanding of the Security concepts in HANA is a must. Experience in Crystal reports, Analysis for Office, Tableau and Qlik view is good to have. Working on Agile/scrum Methodology is good to have. Experience and good knowledge of Performance Tuning and Stress Testing are required. Strong analytical, problem solving and multi-tasking skills, as well as communication and interpersonal skills, is required. Strong verbal and written communication skills, with an ability to express complex business concepts in non-technical terms.

JD: HANA Modelling Overall Exp.: 8+ years Rel. Exp: 6+ years Work Location: Hyderabad Work Timing: General Shift Notice Period: 0-15 days Job Summary: We are looking for a skilled and experienced Senior HANA Information Modeler with 6 to 8 years of advanced experience in designing and creating information models in SAP HANA. The ideal candidate will have a strong background in HANA SQL, ETL processes, and the design and creation of complex data models. You will be responsible for translating business KPIs into actionable data models, optimizing performance, and ensuring that data structures are robust and efficient. Key Responsibilities: Design and create information models in SAP HANA using Attribute Views, Analytic Views, and Calculation Views (both script-based and graphical). Leverage advanced HANA SQL skills to design and implement efficient queries, stored procedures, functions, triggers, and views. Develop and optimize ETL processes, particularly using SAP Business Objects Data Services (BODS), for efficient data integration and transformation. Work extensively with aggregate and window functions to enhance data processing and performance. Design and maintain complex database schemas, ensuring effective normalization and table design. Define reusable components and frameworks, establish common schemas, and set standards and tools for HANA development. Translate business KPIs into HANA-based solutions and define reporting layouts to meet business needs. Collaborate with cross-functional teams to ensure that data models and solutions are aligned with business objectives. Apply best practices for performance tuning and stress testing to ensure that models perform optimally at scale. Utilize tools such as SAP BW, SAP BO, and third-party reporting tools like Tableau, QlikView, and Analysis for Office (AO) for reporting and analysis. Implement and manage SLT (SAP Landscape Transformation) and SDI (SAP Data Intelligence) for data integration. Work within Agile/Scrum methodology, contributing to iterative development and collaborative problem-solving. Provide strong leadership and mentoring within the team, promoting best practices in database design and HANA development. Required Skills and Experience: 6 to 8 years of advanced experience in designing and creating information models in SAP HANA, including experience with Attribute Views, Analytic Views, and Calculation Views (script-based and graphical). Expertise in advanced HANA SQL, including complex queries, stored procedures, triggers, functions, and views. Strong experience in ETL processes, especially with SAP Business Objects Data Services (BODS). Advanced knowledge of aggregate and window functions in HANA SQL. Expertise in Transact-SQL (DDL, DML, DCL) and database design, normalization, and table creation. Strong understanding of reusable components, frameworks, and standardization in HANA development. Proven experience in translating business KPIs into HANA-based solutions and reporting layouts. Experience with SAP BW (Business Warehouse) and SAP BO (BusinessObjects). Strong knowledge of SAP SLT (SAP Landscape Transformation) and SDI (SAP Data Intelligence). Familiarity with reporting tools like Tableau, QlikView, and Analysis for Office is desirable. Experience working in Agile/Scrum methodologies is preferred. Strong analytical, problem-solving, and multitasking abilities. Excellent verbal and written communication skills, with the ability to explain complex technical concepts in simple, business-friendly terms. Additional Skills (Desirable): Performance tuning and stress testing expertise to optimize data models and processes. Familiarity with database optimization techniques in large-scale environments. If you are a passionate and experienced HANA Information Modeler with the drive to solve complex data challenges, we encourage you to apply and join our team!