SAP BI BO Presentation Torrent

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

BO XI R3 Implementation proposal : 

BO XI R3 Implementation proposal Torrent Pharma

Agenda: 

About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences Agenda

Intelligroup Corporate Overview: 

End to End Services in the ERP & Surround ERP space Staff Augmentation as well as Fixed Bid deliverable based projects based on customer preference 24 x 7 Application Support from offshore including Functional support Industry experience on business processes : Onsite resources with industry experience before moving to IT Services/ERP Industry verticals matrixed with business processes: Delivery models: Flexible resourcing enabling optimized cost Investment in IP: Significantly invested in Tools & accelerators Revenue: $157 Mil (2008) Global Presence: Operations in Europe, US, Asia-Pac & Mid- East Large Customer Base: 400+ First in Offshore: Pioneered ERP offshore in 1995 Quality Journey: ISO-9001, CMMi Level 5, P-CMM Level 4 Premier Partnerships: SAP, Oracle, Microsoft Fast Facts Unique Positioning Service Offerings Intelligroup Corporate Overview

Agenda: 

Agenda About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences

Slide 5: 

Scope Items – SAP BI Installation of the BW system version 7.1 & Business Content Add-on 4 SP4 Preparation of the Landscape Defining the Transport Strategy Preparation of the Architecture Identifying the KPI’s required to fulfill the reporting requirement Implementation of the SCM, SD and Marketing modules Customization of Data-flow as per the reporting needs Report Creation for KPI’s Data Validation, Report Testing & Performance Tuning Training the Core/Super Users 1-week Post Production Support Technical/Project Documentation

Slide 6: 

Scope Items - SAP BO XI Training Torrent Technical team, Business End Users on BO XI Installation & Development of BO XI 3.1 on 2 Instances Installation & Development of BO Xcelsius BO XI & Xcelsius Integration with SAP BI Design & Development of SAP BO Universes, Webi Canned Reports (40) & BO Xcelsius Dashboards (8) Schedule Reports Provide Adhoc Reporting Capability Implementation of BO Auditor Universe 1 Week Post-Production Support Technical/Project Documentation

Agenda: 

Agenda About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences

Slide 8: 

Solution Approach – Solution Architecture SAP BI Portal / SAP Business Objects Webi SAP BusinessObjects Enterprise Web Intelligence Xcelsius SAP BEx Information Access SAP NetWeaver Business Warehouse Data Foundation S&M SCM SAP Business Suite

Bringing SAP & BO Together: 

Bringing SAP & BO Together BO Universe SAP Integration Kit BO XI SAP BW SCM S&M Demand Planning & Forecast Procurement & Suppliers Warehouse Performance Inventory Analysis Sales Performance Manpower Analysis Field Activity Budget Vs Actual

Slide 10: 

Solution Approach – SAP BI TBD - Ravinder Installation of Business Content pertaining to SCM, SD and Marketing GAP Analysis and Customization/Development of Existing/Data Flow Performance Tuning in terms of automation of loads, reporting settings, OLAP Cache and aggregates Load Data, Create reports and validate Preparing the queries for Universe Development and BO Integration

Slide 11: 

Solution Approach – SAP BO XI Standard Performance Oriented Approach – Universe creation based on BEx query of SAP BI Canned Reports developed on Universe & scheduled to auto-refresh based on SAP data load process Reports published on Infoview of BO XI – Users across the organization can access the same using SAP logon End Users equipped with Adhoc reporting – Create reports on the fly Deploy BO XI Reports to SAP BI Portal or any other portal Save reports to Excel, PDF, send reports to BO Inbox/office mail SCM /ECC/SM BEX Designer

Slide 12: 

Solution Approach – BO Xcelsius BO Xcelsius Live- Dashboards Integrated with SAP BI Xcelsius Live-Dashboards based on BEx query Dashboards based on real-time data of SAP BI Cubes Consume existing BO Universes & create dashboards using QAAWS Publish to SAP BI Portal, BO Infoview Access Dashboards across the organization Intuitive design environment enabling to easily and quickly create professional-looking models thanks to predefined charts, gauges, selectors, and maps

Agenda: 

Agenda About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences

Slide 14: 

Project Schedule & Cost TBD - Mehul

Agenda: 

Agenda About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences

Slide 16: 

Resources staffing plan Sl. No Resources Proposed Skill Set Onsite/ Offshore Total Man Months 1. Tejeswara Rao Badugu BI Onsite 5.5 2. Samarasimha Reddy BI Onsite 5.0 3. Madhav Chitineni Basis Onsite 5.5 4. Chaitanya Mudike BO XI Lead Onsite 4.5 5. Vishal Sarathi BO XI Admin Onsite 4.75 6. Anirudh Sinha BO XI Developer Onsite 3.0

Agenda: 

Agenda About Intelligroup Scope Items Solution Approach Schedule & Cost Resources staffing plan and ramp up Experiences

Slide 18: 

Experiences – SAP BI CLIENT Vertical Effort* Products PROJECT SAP BO Godrej PoC Sales 4 BO XI 3.1, BO Xcelsius Development of Live Dashboards & Webi Reports on SAP BI 7.0 Data Adani PoC Sales, P&L 2 BO Xcelsius Development of Live Dashboards on SAP BI 7.0 Data HUL PoC Finance 4 BO Xcelsius, Crystal Reports Development - Live Dashboards, canned Crystal Reports on SAP BI 7.0 Data Meda Pharma 0.5 BO Xcelsius What-If Analysis Static Dashboard SAP BI + SAP BO Bristol Myers Squib Pharma XX SAP BI SAP BW Migration – 3.5 Queries, 7.0 Security – to latest version Varian Pharma XX SAP BI xxxxxxxxxxxxxxxxxxxxx Hubble Manufacturing XX BO XI 3.0, BO Xcelsius Development of Live Dashboards & Webi Reports on SAP BI 7.0 Data Fender Manufacturing XX BO Xcelsius Development of Live Dashboards on SAP BI 7.0 Data

MEDA Pharmaceuticals Inc.: 

19 MEDA Pharmaceuticals Inc. Project Objective Design, Develop and Deploy high-fidelity formatted Financial Reports based on customized SAP BI content using Crystal Reports Distribution of reports by connecting Crystal Enterprise to SAP Enterprise Portal Key Challenges Support of SAP BI 7.0 query features in Crystal Enterprise 10 Enhanced SAP Edition platform Availability of reports on time Optimized report printing over the Web Implementation Highlights High-fidelity formatted reports Scheduling and distribution of reports through a managed web environment Multiple output formats like Adobe PDF, MS WORD, Excel etc. Seamless integration into SAP Enterprise Portal and with SAP BI security model covering authentication, single sign-on, roles and multi-language capability Business Benefits Presentation–quality, easy to print and use hi-fi formatted reports Improved Financial Reporting with the capability of displaying Month vs. YTD, Quarter vs. YTD, Actual vs. Plan comparisons of data on a single report. Increased user confidence as end-users are empowered with the ability to access, run and schedule their own reports

Bristol-Myers Squibb: 

Bristol-Myers Squibb Project Objective Migrate SAP BW 3.5 Queries and Workbooks to the latest version of NW2004s Migrate BI 7.0 Security Challenges : Unexpected system issues due to the inconsistency of the Service Pack Levels in the system. Unpredictable issues with the formats of work books due to inconsistency of the front end Patch Levels Implementation Highlights Migration completion on time and within budget Strong user support Global delivery model Business Benefits Benefit from new advanced and powerful features of BI 7.0 User friendly BEx Designer for query creation Increased user confidence by Ad hoc reporting Project Objective Migration of Customer Financial Services (CFS) from legacy to SAP Analysis of purchase orders per 4D compliance Implementation Highlights Aging Reports with Trends - AGING Summary and Detail Report, Summary of Aged Trial Balance by Customer, AGING Alert Report (Daily/Monthly) List of Open Invoices by Payment Term (current month or for a given time period) (Daily) Integration of Purchase order data from non-SAP and SAP PO KPIs - Purchase Order Compliance Details, Purchase Order Reason Code Metrics, Ship to Promise and Receipt to Promise metrics Business Benefits Reports delivered per SOX Compliance Right platform for Technical Operations wing to analyze the "Purchase Order Compliance" and to "Perform the root cause analysis". AR Financials Reporting & Purchase Order Compliance Report Migration from BW 3.5 to BI 7.0

Varian: 

Varian Project Objective AMS BI application support is responsible for ensuring responsive, acceptable resolution to production issues and providing application enhancements. Design HR Cockpit, Product Line Dashboards Key challenges Embedding the different HR Reports in to single Cockpit. Product Line reporting Dashboards To interact with the user’s and resolve error’s and issues faced by the User. Implementation Highlights Design of HR Cockpit and Product Line Dashboard. HR Cockpit is designed to deliver the reports related mainly to Personnel Administration and Compensation management. Implementing the Business Planning for Cost Center Accounting (CCA). Business Benefits Stable BI system Improved HR Reporting by Head count Reports, Hires and Re Hires, Salary, PPL & ECAPS and Miscellaneous Reports Improved customer service through in time resolution to the error’s and issues faced by the User .

Slide 22: 

Hindustan Unilever Limited Project Objective To provide complete visibility on Outlet/Brand/Salesman level sales across India to the Customer development team for better planning and supply chain execution To support operational and strategic level of reporting by providing various time slices of data Key challenges Data Volume Report performance Constantly evolving designs to suit business needs Implementation Highlights Huge data volume processing (about 25 million records per day) Huge report base (around 400 reports on portal, including similar reports for different business areas) Rolled out BI Accelerator for large Info cubes Functional migration from BW 3.5 to BI 7.0 Mass report generation program (MOC Docket) Strategic reports for upper management : Known as CD Docket ( total 6 reports) Widgets implementation with SAP data Data mining – Association analysis, Cluster analysis, ABC analysis. Business Benefits Improved operational performance due to ready availability of data Informed campaign planning and execution supported by data Improved visibility of performance trends (Monthly, Quarterly, Yearly) for Outlet/Brand/Salesman

MEDA Pharmaceuticals Inc.: 

23 MEDA Pharmaceuticals Inc. Project Objective Design, Develop and Deploy high-fidelity formatted Financial Reports based on customized SAP BI content using Crystal Reports Distribution of reports by connecting Crystal Enterprise to SAP Enterprise Portal Key Challenges Support of SAP BI 7.0 query features in Crystal Enterprise 10 Enhanced SAP Edition platform Availability of reports on time Optimized report printing over the Web Implementation Highlights High-fidelity formatted reports Scheduling and distribution of reports through a managed web environment Multiple output formats like Adobe PDF, MS WORD, Excel etc. Seamless integration into SAP Enterprise Portal and with SAP BI security model covering authentication, single sign-on, roles and multi-language capability Business Benefits Presentation–quality, easy to print and use hi-fi formatted reports Improved Financial Reporting with the capability of displaying Month vs. YTD, Quarter vs. YTD, Actual vs. Plan comparisons of data on a single report. Increased user confidence as end-users are empowered with the ability to access, run and schedule their own reports

Bristol-Myers Squibb: 

Bristol-Myers Squibb Project Objective Migrate SAP BW 3.5 Queries and Workbooks to the latest version of NW2004s Migrate BI 7.0 Security Challenges : Unexpected system issues due to the inconsistency of the Service Pack Levels in the system. Unpredictable issues with the formats of work books due to inconsistency of the front end Patch Levels Implementation Highlights Migration completion on time and within budget Strong user support Global delivery model Business Benefits Benefit from new advanced and powerful features of BI 7.0 User friendly BEx Designer for query creation Increased user confidence by Ad hoc reporting Project Objective Migration of Customer Financial Services (CFS) from legacy to SAP Analysis of purchase orders per 4D compliance Implementation Highlights Aging Reports with Trends - AGING Summary and Detail Report, Summary of Aged Trial Balance by Customer, AGING Alert Report (Daily/Monthly) List of Open Invoices by Payment Term (current month or for a given time period) (Daily) Integration of Purchase order data from non-SAP and SAP PO KPIs - Purchase Order Compliance Details, Purchase Order Reason Code Metrics, Ship to Promise and Receipt to Promise metrics Business Benefits Reports delivered per SOX Compliance Right platform for Technical Operations wing to analyze the "Purchase Order Compliance" and to "Perform the root cause analysis". AR Financials Reporting & Purchase Order Compliance Report Migration from BW 3.5 to BI 7.0

Slide 25: 

Hindustan Unilever Limited Project Objective To provide complete visibility on Outlet/Brand/Salesman level sales across India to the Customer development team for better planning and supply chain execution To support operational and strategic level of reporting by providing various time slices of data Key challenges Data Volume Report performance Constantly evolving designs to suit business needs Implementation Highlights Huge data volume processing (about 25 million records per day) Huge report base (around 400 reports on portal, including similar reports for different business areas) Rolled out BI Accelerator for large Info cubes Functional migration from BW 3.5 to BI 7.0 Mass report generation program (MOC Docket) Strategic reports for upper management : Known as CD Docket ( total 6 reports) Widgets implementation with SAP data Data mining – Association analysis, Cluster analysis, ABC analysis. Business Benefits Improved operational performance due to ready availability of data Informed campaign planning and execution supported by data Improved visibility of performance trends (Monthly, Quarterly, Yearly) for Outlet/Brand/Salesman

Godrej Sara Lee – SAP BO Sales Reporting: 

11/1/2011 © 2008 Intelligroup, Inc. Confidential & proprietary Godrej Sara Lee – SAP BO Sales Reporting Key Challenges SAP Integration Security settings for Flash Player to pass the WSDL url Generating WSDL url with Query as Web Service Implementing parameters/prompts with Query As Web Service About the Customer Godrej Sara Lee is a joint venture company between the Godrej Group, India and Sara Lee Corporation, USA. It is one of the world's largest manufacturers of home insecticides. They holds a substantial market share in the domestic market in India. Before How Intelligroup helped After Absence of good Reporting tool mechanism for Sales Data. Need for: Interactive dashboards for executive management team Customized/complex, scalable/ feature rich business reports/dashboards for business users Integration of reports/dashboards with SAP Info Cubes Web based reports for easy access and distribution Analyzed/gathered business requirements of various teams to develop dashboards/reports Created LIVE interactive dashboard using Xcelsius 2008 with extensive look and feel. Created universes on SAP BW info cube Dynamic Dashboards & Reports using WSDL URL for retrieval of data from the SAP BW Created BO webi report with primary and secondary sales data. Top 10 SKU’s and Products against different parameters Users able to make better and more informed decisions. Users able to do Sales analysis on the basis of WTD, MTD, and YTD. Region/Sub region and category/ brands wise performance analysis Comparative analysis on Traditional Trade, Modern Trade, Canteen Store, Institutional sales Reports which provide well formatted hierarchical data which is ready for further analysis. Rapid and consistent access to enterprise wide sales data. Universes built on SAP BW provide adhoc reporting capability to end users Technology SAP BI 7.0 BO XI 3.0 Xcelsius 2008 Effort Resources – 2 Duration – 30 Man Days

Adani Group – SAP BO PoC: 

11/1/2011 © 2008 Intelligroup, Inc. Confidential & proprietary Adani Group – SAP BO PoC Key Challenge Passing parameters dynamically to the dashboards Analyzing the existing data and proposing the functionality of the dashboard Using Multi cubes in Query As a Web Service About the Customer Adani Group is into international trading and infrastructure development to FMCGs. Adani has made foray into high growth sector like Power, Infrastructure, Global Trading, Logistics, Energy and various other sectors. Before How Intelligroup helped After Scenario 1 Unable to Analyze Revenue earned, expense occurred against Quantity (in Tons), expense rate (per metric ton) & best Rate per metric against competitor across commodities with complete year trend. No Visibility on forecast of sales and Revenue across all the commodities. Scenario 2 Business is spread across different Business Areas in Gujarat and unable to capture Gross Sales ,Purchasing Cost , Net Sales, Expenditure, and profit earned across there Business Area and Profit Center Groups Scenario1: Developed Dashboard with complete Data Analysis of Commodities, projected Contribution of income by Forecasting the Revenue and expense. Developed What If Scenarios dashboards which projected the contribution across the rate and quantity Optimization of Activities which save costs & save material on quantity to meet the planned Contribution. Scenario2 Developed Dashboard with Geographical Sales to capture Gross Sales, Purchasing Cost, Net Sales, Expenditure, and profit earned with what if analysis. Scenario1 They were able to analyze contribution of each commodity and help them concentrate on those commodities to generate more revenue The new Dashboards provided complete visibility of quantity and amount handled of Commodities across various regions and month wise. Ability to decide price of commodity quantity per ton to generate more revenue Scenario2 They were able to analyze PNG Sales across Gujarat Dashboards are integrated with Google Map providing location level drill down. Technology SAP R/3, BW SAP Business Objects 3.0 SAP BO Xcelsius 2008 Google Maps Effort Resources – 2 Duration – 21 Days

Slide 28: 

Experiences – SAP BO XI CLIENT Vertical Effort* Products PROJECT GE C&I Manufacturing 12 BO XI R2, Crystal Reports Report development for Answer Center DWH GE Motors Manufacturing 72 BO Report Migration - BO 5.x to BO XI R2 GE IIC Manufacturing 12 BO Crystal Reports VCR Dashboard Implementation using Crystal Reports GE Fanuc Manufacturing 20 BO BO DI & BO 5.x Migration GE Equipment Services Manufacturing 12 BO BO 6.x Environment Support GE C&I Manufacturing 4 BO BO XI Environment Maintenance & Support *** Effort is in man months

Bringing SAP & BO Together: 

11/1/2011 Bringing SAP & BO Together SAP FI SAP BW SAP SD BO Universe SAP Integration Kit CRYSTAL REPORTS BO DESKI XCELSIUS Payment Analysis Sales Analysis Finance Analysis Production Analysis SAP PP © 2008 Intelligroup, Inc. Confidential & proprietary

Bringing SAP & BO Together – Payment LIVE: 

Bringing SAP & BO Together – Payment LIVE © 2008 Intelligroup, Inc. Confidential & proprietary 11/1/2011

Bringing SAP & BO Together – Finance LIVE: 

Bringing SAP & BO Together – Finance LIVE © 2008 Intelligroup, Inc. Confidential & proprietary 11/1/2011

Bringing SAP & BO Together – Sales LIVE: 

Bringing SAP & BO Together – Sales LIVE © 2008 Intelligroup, Inc. Confidential & proprietary 11/1/2011

Slide 33: 

Bringing SAP & BO Together - Sales LIVE © 2008 Intelligroup, Inc. Confidential & proprietary 11/1/2011

Slide 34: 

Product Manufacturing Cost Analyzer © 2008 Intelligroup, Inc. Confidential & proprietary 11/1/2011

Slide 35: 

11/1/2011 © 2008 Intelligroup, Inc. Confidential & proprietary Manufacturing Cost/Spend Analytics Dashboard LIVE

Slide 36: 

THANK YOU