Arjun Chindanoor

Project Name: IAG

• Team Size: 6
• Technologies used: SAP BTP Integration
• Company Overview: International consolidated Airlines Group S.A., trading as international Airlines Group and usually shortened to IAG, is an Anglo-Spanish multinational airlines holding company. It contains multiple Airlines like Iberia, BA, Aer Lingus etc.
• Client management and documentation
• Integration development and problem solving
• Multitasking across projects and team support.
• providing support to the BAU team

Project Name: Centrica

• Team Size: 6
• Technologies used: SAP CAPM, Native HANA (Views, Table function)
• Company Overview: Centrica is a British multinational energy and services company.
• As part of Centrica API strategy project, a number of cloud API delivered which provide access to various data stored in SAP Hana database(DB).
• These cloud API enable customers journey developed in external applications such as BG-Online, Microsoft dynamics, etc access to SAP data held in SAP Hana database. SAP data is replicated in near real-time from SAP ERP,JSU and CRM systems into SAP HANA database.

Project Name: SteriCycle.

• Team Size: 9
• Technologies used: Native HANA (Views,Table function,SAC,WEBI)
• Company Overview: Stericycle is a compliance company that specializes in collecting and disposing regulated substances, such as medical waste and sharps, pharmaceuticals, hazardous waste, and providing services for recalled and expired goods.
• It also provides related education and training services, and patient communication services. Stericycle Monarch Enterprise instance as part of the Enterprise Data Platform (EDP).
• The intent is not to define the low-level design and constrain the options at the project level but to provide high-level best practices for design and realization.
• This way, any divergence from the stated guidelines can be easily identified, deliberated and managed in the long-term. This document should be reviewed and revised on a regular basis.

Project Name: Coca- Cola Steady state

• Team Size: 9
• Technologies used: Native HANA (Views,Table function,WEBI)
• Company Overview: Extensively involved in requirement gathering, design, build of HANA Live models (calculation views) to meet Coca-Cola reporting needs. Developed attribute, analytic and calculation views in HANA Studio for consumption of these data models in Tableau. Worked on Modeler prospective for building calculation Views Created a Multi-layer data model using calculation Views to achieve report requirements. Worked with security team in defining the analytic privileges, HANA roles for securing the data models.

Project Name: AGCO

• Team Size: 10
• Technologies used: Native HANA (Views,Table function, XSJS, Procedure)
• Company Overview: Distributed and locked data in silo applications has impeded AGCO from implementing best in class programs for dealers and customers. The current situation of having very slow response time for data retrieval and manual aggregation has hindered the business from moving fast resulting in increased time to market and missed opportunities to grow topline sales. AGCO has envisaged on a Digital transformation journey with the objective to-manage a modern, fresh and consistent customer experience. Develop capabilities around analytics to drive more proactive sales. Data enablement platform will be pivotal for success of this digital transformation program. This platform will play a key role in enabling the digital applications, channel partners, Dealer/Customer portals to access data from a high performing and low latency data delivery framework powered by API’s and other data integration methodologies.
• Understand the Functionality and build the Modeling and Scripting based on the FS and generate XSJS for binding the services in the UI screen.
• Worked on GEO-Spatial in HANA calculation views.
• Dealer Locator is to Identify the nearest dealers within a user specified radius based on GEO-Coordinates
• Debug on the Models for Enhancements and Performance Tuning.
• In planning, implementation and development of SAP HANA stored procedure and dependent object like tables, types and integration with XSJS.
• Designing and preparing and calculated columns with proper expression editors, Syntax accordance with requirements
• Experience in handling planned and unplanned activity issue handling and providing the RCA’s
• User acceptance test and business

Project Name: Cisco Systems, Inc.

• Team Size: 10
• Technologies used: Native HANA (Procedures, XSJS, XSJOB, Views)
• Company Overview: BAAO is the implementation for the CISCO product suppliers and manufacturers were their underlying database is oracle and they are using HANA for Analytics and transaction data’s. Deriving Spend Analysis based on CPN (CISCO Part Number) and MPN (Manufacture Part Number).
• Understand the Functionality and build the Modeling and Scripting based on the FS and generate XSJS for binding the services in the UI screen.
• Debug on the Models for Enhancements and Performance Tuning.
• In planning, implementation and development of SAP HANA stored procedure and dependent object like tables, types and integration with XSJS.
• Evaluated, designed, configured, tested and arranged released of development for SAP HANA information Models accordance with Business requirement process.
• Execution of data modeling of attributes, analytic, calculation views, stored procedures and XSJS using HANA studio.
• Having hands on WEBI reports.
• Designing and preparing and calculated columns with proper expression editors, Syntax accordance with requirements
• Ensuring the smooth development of production, Release with authentication.
• Experience in handling planned and unplanned activity issue handling and providing the RCA’s
• User acceptance test and business

Project Name: Siemens Germany

• Team Size: 8
• Technologies used: Native HANA (Procedures, views)
• Company Overview: The project was about Purchase order data of Siemens with its vendors. Worked on SAP HANA mainly concentrating on developing enrichments (Data Transformation) through pl/sql stored procedure and Calculation views using SQL script, also handling other data modelling activities and part of transport activities.
• Experience in replicating the data from SAP / Non SAP sources to SAP HANA using SAP Landscape Transformation (SLT), BODS, Importing Flat Files into Database artifacts.
• Created multiple schemas and table definitions in HANA modeling.
• Analyze and Build the Scenarios as per Report requirement.
• Design and build SAP HANA Information Models (Attribute, Analytical and Calculation Views).
• Created Advanced Views like Graphical Calculated Views and Script Based Calculated Views.
• Developed HANA models using advanced modeling capabilities in Hana studio.
• Involved in creating Stored Procedures for user specific data.
• Involved in creating Analytical privileges both static and dynamic
• Creating, Importing, and Exporting SAP HANA Data Models
• Created Universes on top of HANA calculation views and developed the Web Intelligence reports using IDT (Information design tool).

Project Name: SanDisk.

• Team Size: 9
• Technologies used: Native HANA (Views,Table function,WEBI)
• Company Overview: SanDisk manufacture memory cards through its worldwide manufacture centers and through vendors. SCP is the tool which helps management to plan their supply chain. SCP is third party tool which takes data from oracle in specific formats and process it and give the reports to oracle in its format. Presently SanDisk preparing the plan on daily basis and preparing the data for SCP is taking a lot of time. SanDisk want to overcome this delay and targeting plan has to run daily 2 times. Previously they are preparing the data using shell scripts, PLSQL and informatica mapping’s which is taking more time. So they want more preparation of data for SCP using HANA SQL scripting for this our role is understanding the PLSQL and informatica mapping with business and concentrate them to HANA SQL scripting.
• Migrated ORACLE Database into SAP HANA.
• Involved in information gathering.
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Developed complex SQL scripts in Calculation views
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.

Project Name: SanDisk (POC-Proof of Concept)

• Team Size: 4
• Company Overview: SanDisk manufacture memory cards through its worldwide manufacture centers and through vendors.
• SQL/PLSQL scripts were migrated into HANA SQL scripts adhering to the existing functionalities as given by the customer.
• The existing scripts were rewritten using HANA SQL Script which in turn showcased the real power of SAP-HANA by reducing the processing times tremendously for complex business calculations and motivated the customer to switch to SAP-HANA.