Arteria Dashboards Advantage: Get Insight into your Business July 2014

Agenda Introduction to Arteria Business Needs

Solution Overview Customer Case Studies

Arteria Technologies Introduction • Arteria is a 7 year old organization and is located at the International Tech Park, Bangalore.

•

•

•

The management team comprises of former employees of SAP Labs India with several years of development, implementation and consulting experience. Arteria is exclusively focused on developing products and solution extensions on SAP technology platform, helping customers leverage the potential of Cloud (HANA Platform), Mobility (Sybase/SMP), BI (Business Objects) & On-Premise (NetWeaver) components. Our products have been implemented at industry leaders and we have a rich experience in executing projects at >100 customers in multiple verticals.

Quality Certifications

•

All SAP projects have ISO 9001:2008 certification.

•

All SAP projects have ISO 27001:2005 certification.

•

SEI CMMI DEV 1.2 Level 3 Certified.

•

SAP AQM Program Member.

Partnership with SAP

•

SAP PartnerEdge Application Development Partner.

•

SAP Co-Innovation Labs (COIL) partner

•

SAP Services Partner.

•

SAP Channel Partner (VAR).

Arteria Innovation Journey

PartnerPortal Advantage is SAP Certified

Founder Member @ SAP Co-Innovation Labs, Bangalore

Launch of Apps and Solution developed at Co-Innovation Labs

“ Source: Gartner, Inc., Cool Vendors in the SAP Ecosystem, 2013, Authors: Derek Prior | Thomas Otter | Gilbert van der Heiden | Sunil Padmanabh | Christian Hestermann, 18 April 2013

Arteria apps featured at the launch of SAP EcoHub and SAP Store

Arteria’s coinnovation journey on enterprise mobility is published

Invited to HANA Cloud Platform Early Adoption Program

We consider our inclusion in the Cool Vendor report by Gartner, a confirmation of our mission to enable customers to leverage the power of enterprise systems using mobility and portal technologies, thereby improving business performance. We continue to innovate with our product roadmap; the upcoming launch of cloud version of our products will further enhance our market position. Our strength is our capabilities to build solutions with quick ROI and help customers extend their SAP ERP processes to business partners and employees, while staying invested on the SAP technology platform. Sriram Kanuri, CEO – Arteria Technologies

Awards & Recognitions Successful Partnerships

• • •

SAP Pinnacle Awards 2014: Application Development Partner of the Year Open Text Partner of the year 2014 & SAP Competence Select partner Best SAP NetWeaver Process Integration Partner in APJ

Continuous Innovation with SAP and Customers

• •

SAP APJ Regional Partner Excellence Award 2014 for Software Innovation SAP ACE Award 2013 with Luminous Power Technologies for using SAP Solutions in an

Innovative Way

•

Mobility Recognition Award from SAP India Customer Recognition and Validation

• •

CIO Choice Award 2014 for “Secondary Sales” product portfolio SAP ACE Award for Public Services for “Best Run in Procurement” at Airports Authority of India

Arteria’s Product and Services Portfolio

Typical business process automation covering supply chain & distribution network Delayed Workflow approvals as executives on the move

Sub-Contractor

Internal Operations are integrated & configured in SAP ERP Limited integration to SAP ERP from remote depots

Supplier CO Warehouse

Manual processes for supplier & Sub contractor collaboration.

Manual interactions with the distributors for orders, dispatches and outstanding.

Manufacturing Operations

C&F

SAP

C&F

Z transactions for C&F to update material movement

Stockist/ Distributor

C&F Stockist/ Distributor Regional sales team usually has no access to SAP ERP

Stockist/ Distributor

“Excel” based secondary sales capture & analysis

No SAP system access to field force to check order status, inventory & outstanding's

Arteria Products Business Networks

• SupplierPortal Advantage • CFA Advantage • DealerConnect Advantage • SecondarySales Advantage Mobility

• mApprove Advantage • mSalesForceAutomation Advantage • mSecondarySales Advantage • mDepot Advantage • mInspection Advantage • mPlantMaintenance Advantage Business Analytics

•Dashboards Advantage

“

During the course of the project and the interactions held with your team members, we have found your team to be extremely professional and willing to take that extra effort for understanding the customer requirement and even challenging us when our thought process might have been unclear.

Arteria Products Business Networks

Mobility

Analytics

Arteria Productized Services and Expert Consulting Cloud

Analytics & Reporting

• • •

• •

HANA Cloud Platform HANA Cloud Integration

SAP congratulates Arteria Technologies for excelling in their partnership with SAP and winning the Best SAP NetWeaver Process Integration Partner Award.

BW on HANA BI & Analytics Implementation

SAP Mobile Platform Cloud Edition

OpenText Extensions for SAP Business Process Management

• •

SAP NetWeaver Process Orchestration & PI Financial Services Network / Bank Connectivity

• • • •

Extended Content Management (xECM) Portal Content Management (PCM) Data Archiving & Document Access Vendor Invoice Management (VIM)

User Productivity

• • • •

Screen Personas Fiori SAP NetWeaver Gateway & Mobile Platform SAP NetWeaver Portal

Rapid Deployment Solutions

• • •

Arteria RDS for Analytics Arteria RDS for Mobility Implementing standard SAP RDS

“

Arteria has extended the value of SAP NetWeaver to our customers and has empowered them with tools and methodologies for achieving business excellence. We look forward to working together further to continue to drive co-innovation and provide further value for our customer base. - SVP and CTO, SAP APJ

Arteria ILM Practice for OpenText Extensions Data & Document Archiving •

>20+ Implementations for ERP, BW and CRM

•

Integrating document / unstructured content for master data management and business processes (order-to-cash, procure-to-pay, hire-to-retire)

•

Industry specific document processes for Life Sciences and Process Industries

Content Management •

Implementations for xECM (Life Sciences) and PCM (Consumer Goods Manufacturer)

Vendor Invoice Management •

Shared Services Scenario

•

Integrated into Arteria SupplierPortal Advantage

As part of our service strategy to help Dr. Reddy’s manage and optimize their data growth, OpenText Archiving was a key component because it ensured regulatory compliance, SAP data consistency and zero down time

Arteria AMS Services Development support • ABAP • BW • EDI/EAI • Portal

Help Desk • Centralized Helpdesk • Level 1 Support • Knowledge Repository

DBA & OS • Database Installation • Preventive Maintenance • Tuning • Os installation • System backups

Functional Support • Monitoring • R/3 Modules • NDP (APO, CRM, SRM, SCM) • Configuration • Unit Testing, Integration testing and Regression testing • Documentation • Training

Application Management Support

Data Management • Assist Master data uploads

Problem Management

Basis • Monitoring • Client Management • System Tuning • New Version installation • New Client Creation • Transportation Management • Patch Applications

Security & Authorization • Global roles • Managing User profiles • Business Roles • Creating New Users

Archiving • Set-up Archival Strategy • Interface to 3rd party Archival system • Restore procedures

Release Management

Change Management

Incidence Management

Arteria Customers Automotive (OEM and Auto Components)

Consumer Products and Retail

Cement & Mill Industries

Arteria Customers Discrete Manufacturing Process Industries

Financial Services

Life Sciences

Diversified Groups

Key Productized Services and Expert Consulting Implementations • Process Orchestration

• • • • • • • • •

Large scale integration projects with SAP and non-SAP systems including EDI scenarios with large retailers like Walmart Development & consulting partner for Bank Business Networks with 100+ implementations Leader in ILM for SAP-OpenText Data Archiving & Document Access, Vendor Invoice Management and Portal Content Management >20+ implementations in various verticals Auto Industry focused packaged offering for Analytics Large media house implementation with BW, BO and HANA Transformation projects that help customers leverage their SAP technology investment with Arteria products, industry knowledge and design approach Agro – Use of Mobility to enable procurement process in villages Media – SAP ERP Integrated Ad-sales booking agency portal Cement – Process automation for order, dispatch and batching in RMC

AMS Models and Implementations • • • Applications

• • • • •

Arteria Product Support & Enhancement for >40 customers (business hours support) Integration to SAP Support Channel

Outsourced SAP and non-SAP AMS with a dedicated team, hotline and leased line to customer data center 24*7 technical support and business hours for applications Technical monitoring for key SAP instances like Portal, Data Warehouse, and Mobility servers Ad-hoc BASIS services for performance tuning, upgrades and support packs.

Ticket based expert consulting / projects / enhancements SAP Rollouts, technical enhancements, custom development projects

Key Greenfield SAP Implementations SAP ERP implementation & support for Bhilwara Milk Union covering FI, CO, MM, Milk Procurement, SD and Integration with Production Planning SAP SRM Public Sector Procurement implementation & support at Airports Authority of India for 170 locations. The implementation was adjudged as “Best Run in Procurement” as part of SAP ACE Awards for Public Services. SAP ERP & Warehouse Management Implementation at Maharashtra State Warehousing Corporation. The scope covers FI, CO, MM, HR, WM, Enterprise Portal, & Business Intelligence modules

SAP Loans, Collaterals, Treasury and SAP HR implementation at PTC Financial Services

SAP ERP Implementation at The Corps of EME, Indian Army. The scope covers plant maintenance (PM) and human resources (HR) modules at New Delhi location.

Business Needs & Arteria-SAP Co-Innovation Solutions for Dashboards Advantage

Business Problems Business Problems

Business Problems

• No

• Spreadsheet

centralized view of executive information from multiple transactional and manual systems.

• Manual

intervention and time required to collate and present accurate data in appropriate format.

• Drill

down to transactional data is not possible from Excel / PPT based EIS/Dashboards

based dashboard need dedicated resources with ability to program complex logic and data handling.

• Manual intervention / custom development to extract data from SAP ERP increases the TCO.

Solution: Dashboards Advantage

Technology

• Readymade 40 dashboards with BW data marts from six functional

• SAP

areas: Sales, Purchase, Production & Maintenance, Finance & Controlling, Quality Assurance, NPD and HR.

• Visually

rich dashboards that present aggregated data from SAP ERP and non-SAP systems like databases and spreadsheets.

• Standalone

capability (Flash / PDF format) to support offline

interaction.

• Drill down from aggregated information into transaction level data.

NetWeaver SoA Platform - Enterprise Portal, BW and Web Application Server

• SAP Business Objects • Pre-packaged SAP BW content • Support for SAP ERP and non-SAP flat files or database connectivity

systems using

Dashboards Advantage: Features DASHBOARD CONTENT Area

COMMON FEATURES # of Dashboards

Finance & Controlling

8

Sales

7

Business Dev

4

Production

7

Purchase

5

Quality

3

HR

4

DEPLOYMENT

• Generate Standalone dashboards as PDF / Flash File (swf)/ ppt for offline analysis.

• Enterprise portal to • view real time dashboards • drill down detailed analysis of granular data using BI Queries

• Selection

/ Filters – Select date range for analysis of

data

• Year filter within the dashboard • Charts – display trend for 12 months of data • Data displayed in the form of crosstabs • Zoom the charts to get the magnified visualization. • Drill down within dashboard • Print option to print current view. • Trend icons to display KPIs • Color Alerts on single bar charts against targets. • At-a-glance view of the organizations performance with gauges and chart

Dashboards Advantage: Benefits Summary Pre-packaged visually rich Dashboards for Sales, Purchase, Production & Maintenance, Finance & Controlling, Quality Assurance, Business Development and HR that enable executive insight into the organization with multiple data sources and

formats.

Industry Content • ~ 40 dashboards that covers all areas • SAP, non-SAP and flat file support; Easy to extend for own formats and data sources

Feature Rich • Support for standalone and portal based deployment • Filter and Drill down capabilities within the dashboard • Ad-hoc analysis using queries

Lower TCO • Single Platform: Runs on SAP NetWeaver • Leverage existing SAP ERP implementation. • Easy to deploy with rapid go-live

Thank you Arteria Technologies Pvt. Ltd. Level 1, Innovator, International Tech Park, Whitefield, Bangalore – 560066 India. Web: www.arteriatech.com Email: [email protected] Phone: +91 80 4242 3800

Appendix

Appendix: Technical Architecture & Implementation Details Dashboards

Universe

SAP ERP

Xcelsius

Non SAP – Flat Files

Enterprise Portal swf / pdf /ppt

WebI

SAP BW

Solution Details

• SAP ERP, Flat Files are used as data sources • SAP BW Cubes and Queries are used to analyze the raw data

•

BI Queries

Standalone Dashboards

Security

from OLTP systems SAP Business Objects is used to connect to BW cubes and present information through dashboards

• Object level/Data level restrictions in SAP BI • User based restrictions on Folder level/ Object level in

NetWeaver Enterprise Portal to display the dashboards and BI Queries

•

• SAP

Business Objects Role based access to objects in Enterprise Portal

Appendix: Finance and Controlling Dashboards Operating expenses

• Monitoring each expenses against budget • Profit center-wise view of each expenses • Can view 36 months expenses trend Receivables

• Collectable and All – both views available

• Collection information against receivables

• Receivables age-wise available • Region-wise information Value addition per employee cost

• Will provide value addition from all / direct employees

Interest Cost

Currency fluctuation

• Monitor

gain / loss due to exchange rate

variation with indicators

• Can view

up to month information along

• Interest cost percentage to sales • Interest amount accounted every month

with previous years comparison

Material Cost % to sales

Purchase price trend

• To monitor the material cost against the set targets

• Can be view plant, Material type & Base Material (Brass, Steel,

• Plant-wise and category-wise can be

Plastic, etc.)

• Can be compared with the total

view

purchase value

• Will

Loss making products

• Will

provide the product and

customer

details

to

trigger

action towards price revision

be helpful in fixing the

product price and target price for a component

Appendix: Sales Dashboards Sales Overall

• Actual

Plant & Region-wise sales

Sales - All plants at a glance

sales against annual target

• Plant-wise actual sales against annual

(Budget) and monthly target (Order

target (Budget) and monthly target

performance in a single screen

Board)

(Order Board)

along with company sales

• Plant-wise contribution to overall sales • Previous year same period sales comparison

• Annualized

• Region-wise

actual

sales

against

annual target (Budget) and monthly

budget

Premium freight

• Premium freight amount accounted under different categories (Air, Taxi, etc.,)

• Monitoring against target • Can view the trend for 36 months

• Current

year

cumulative

sales

targets

Finished Product Inventory

• Plant-wise and ware-house-wise inventory

• Coverage days • Monitor against targets

• Annualized sales view against budget

• Up to month sales view against

target (Order Board) (projected) sales against

• To view all plants sales

&

budget and order board

To-date gap

• To view the actual sales moving towards or away from, budget

Top 10 Customers sales

• Top 10 customers sales contribution • Individual customer sales, plantwise, cumulative, sales trend

Appendix: BD/PD Dashboards New Business

• New product sales turnover in comparison with total sales • New products list and its sales value can be viewed Number of New products

• Number of new products added a particular month • Estimated sales value and quantity on mass production Number of proposals & Samples

• Quote conversion can be reviewed • Samples submitted and order regularization status can be viewed VA/VE

• VA/VE achieved can be reviewed against targets • Sub-category-wise VA/VE monitoring like design, process, materials, etc.,

Appendix: Production & Maintenance Dashboards Plant-wise, Cell-wise Production

• Plant-wise •

& Cell-wise, Production value & Quantity can be viewed Production value can be monitored against production board value

Power Consumption

• Can be viewed plant-wise & Cell•

•

Capacity Utilization

• Capacity utilization can be monitored •

Plant-wise & Cell-wise Can view against production

Production Consumables

• Production consumables •

consumption can be reviewed against target Production consumables consumption against production

wise Can be reviewed against production value Can monitor the value under each category like EB, Generator, etc…

Machine down-time

• Can be reviewed on hours and value • Can be reviewed plant-wise, cell-wise •

& reason-wise Reason-wise analysis will enable to give focused attention to reduce the down time

MTBF - Mean Time Between Failure

• Can •

•

review in two categories, Plant & Cell-wise and Machine-wise Machine-wise can be reviewed for a given period Plant & Machine-wise can be reviewed for rolling 36 months

MTTR - Mean Time to Repair

• Can be viewed plant-wise and Cell-wise • Can be reviewed against target • Cumulative trend also can be viewed

Appendix: Purchasing Dashboards Inventory

• Inventory monitoring against targets • Overall, Plant-wise & Material group-wise inventory can be reviewed and controlled

Delivery Rating

• Delivery performance trend can be viewed • Overall, plant & vendor-wise delivery performance can be reviewed

Premium Freight

• Extra expenses made towards freight can be reviewed • Cause-wise premium can be monitored

Non-Moving Inventory

• Non-moving value can be reviewed and controlled against the targets • Can compare with the existing total stock

Key Materials Price trend

• Material price variation trend against the budgeted price can be viewed • It will enable to estimate the future price, in new product costing

Appendix: Quality Assurance Dashboards Cost of Quality

• Can view plant-wise and overall • Can view under four heads:

•

1. Prevention Cost 2. Appraisal Cost 3. Internal Failure 4. External Failure Can compare with previous years data

Quality PPM

• Can review under three categories viz., Customer, Vendor and Internal • Can view overall as well as for individual • Can view the trend to have better analysis

Number of customer complaints

• Complaint category-wise can be viewed like due to Materials, Operations, Packing, etc. • Can view number of complaints received & closed during the month • Can view number of complaints open as per the month

Appendix: HR Dashboards Number of Employees

• To know the number of employees at each period • Addition / Deletion during the period can be maintained

Employee Training

• Training hours for staff and operators can be viewed separately • Hours spent on training can be reviewed with the target

Absenteeism

• To minimize loss in production / sales & Machine idle time, one of the key factor to control is employee absenteeism, it can be •

monitored closely for a particular plant or Cell-wise. The trend can be seen to analyze the affectivity on the initiations taken towards eliminating absenteeism

Suggestions

• Employee suggestions are one of the important point to improve the process efficiency, number of suggestions generated during •

the month, closed and amount achieved. Pending suggestion can be monitored