Microsoft e-Commerce Solutions Overview of

Microsoft e-Commerce Solutions Overview of Microsoft e-Commerce-related systems Published: January 2003

MS Expense: U.S.-Based Employees Enabling Microsoft Employees to Submit Expense Reports from any Location at Any Time

Solution Overview Situation The paper-based expense-reporting system at Microsoft was labor intensive for Accounts Payable, slow to reimburse employees, and vulnerable to data entry errors; Microsoft needed an application that would allow employees to submit expense reports easily online and that would reimburse employees quickly Solution MS Expense is an intranet-based expense-reporting application that enables employees to submit expense reports over the Web from anywhere at any time; The latest version is integrated with American Express for direct payment of credit-card charges Benefits Streamlines transactions, saving costs, paperwork, and time Reduced the cost of processing expense reports from 21 to 8, saving 4.3 million per year Has shortened employee reimbursement turnaround from three weeks to three days Automatic population of credit-card data in expense reports and direct payment to American Express saves time, reduces errors, and reduces the headcount involved in processing paper-based information Integration with American Express saves 1 million per year in incentives and enables Microsoft to negotiate additional savings, such as airline discounts

Products And Technology Microsoft Visual Studio .NET Microsoft SQL Server 2000 Microsoft Windows 2000 Advanced Server Microsoft .NET Framework Microsoft .NET Compact Framework

Architecture Creates EDI File of MS employee purchases Translates EDI file into XML - Encrypts credit card number Web Service imports data into database Creates XML file with MCS employees and projects Sends details of offline expenses using .NET Compact Framework American Express Employees accounts are credited e*BIS Translate flat file into EDI SAP Remittance program generates a flat file MS Expense MCS expenses exported MCS Imports data into Changepoint system for customer billing Pocket PC Expense is posted to SAP

Business Benefits Improved employee satisfaction with the expense reimbursement process Employees reimbursed for business expenses in just three days, not three weeks Reduced transaction costs per expense report from 21 to 8, saving Microsoft 4.3 million each year” Compliance with Microsoft policies regarding the appropriate use of credit cards more easily enforced Information collected about how much money Microsoft is spending on vendors’ services

HeadTrax A Centralized, Intranet-Based HR Information Application

Solution Overview Situation HeadTrax is an internally developed solution introduced in 1997 by Microsoft IT that provides users a centralized source for accessing and modifying HR information. In an effort to reduce costs and enhance usability, HeadTrax was completely rearchitected in 2002 and is enhanced on a quarterly basis. Solution HeadTrax 5.11 represents a redesign of the application architecture that takes advantage of several Microsoft technologies, including the .NET Framework, BizTalk Server 2002, SQL Server 2000, and Message Queuing. Benefits Enables integration of standalone tools at a 25 percent savings over an ActiveX environment. Supports retirement of the standalone tools for a 365,000 annual savings in training and support. Enables process automation and workflow for a savings of 10 million annually. Improves client satisfaction through streamlined recruiting and faster fulfillment of open positions.

Products and Technology Microsoft .NET Framework, XML Web services Microsoft Visual Studio.NET Microsoft BizTalk Server 2002 Microsoft Internet Information Services (IIS) version 6.0 Microsoft SQL Server 2000 Microsoft Internet Explorer 6.0 Microsoft Windows XP Professional Microsoft Windows Server 2003 Microsoft Visual Basic .NET The Active Directory directory service

Architecture High Level Transaction Architecture Win Forms / Web Forms Clients Clustered Web Servers HeadTrax DB Server ASP.NET HeadTrax Web services SQL Server Downstream Reporting and Data Distribution Data Warehouses Ops BizTalk Server MSMQ ADO.NET MSMQ HeadTrax DB Server SAP IDOC Batch Interface Finance HR SAP HeadTrax SQL Server BizTalk Server MSMQ SAP Enterprise Database Feed Repository MS Corporate Feed Repository

Business Benefits An estimated 10 million annual savings in development and operational costs. Improved auditing and workflow, more accurate data stores. Expedited processes for internal and external recruiting and staffing. An estimated 365,000 annual savings in training and support costs

HRWeb Maximizing Employee Productivity and the Effectiveness of the HR Organization

Solution Overview Situation Microsoft employees were spending too much time and effort searching for HR information, data, tools, and forms Solution HRWeb is an integrated suite of portal products that, through utilizing the .NET Framework and XML, provides HR information to all Microsoft employees, managers, and HR professionals worldwide Benefits Streamlines processes, information, and transactions for the Microsoft HR department Reduces postal and material costs by 75-90% Reduces time employees spend searching for HR information or forms Streamlines workflow through direct interaction with SAP R/3 Saves employees an average of 5 minutes per month at a savings of over three million dollars per year to Microsoft

Products And Technology Microsoft ActiveX controls Microsoft Internet Explorer 6 Microsoft FrontPage 2002 Microsoft SQL Server 2000 Microsoft Visual InterDev Microsoft Visual Studio .NET Windows 2000 Advanced Server Windows Server 2003 Microsoft Internet Information Services (IIS) 6.0

Architecture Corporate IIS Servers Exposing Data via XML Web Services Stock SQL Server HR Intranet HRWeb IIS 6.0 XML over SSL Stock IIS Server Earnings SQL Server HTTPS Earnings IIS Server Client Computer Internet Explorer 5.5 (or later) Earnings SQL Server HRWeb DB SQL 2000 Earnings IIS Server

Business Benefits 92% of Microsoft employees go to HRWeb first for HR information 78% of employees use the Microsoft intranet more than any other HR resource Average site visit of 5 minutes

MS Sales Microsoft Revenue and Inventory Data Warehousing Solution

Solution Overview Situation There were multiple systems collecting sales data, which resulted in inconsistent data quality and outdated reporting schemes; There were significant operational costs to maintain 18 legacy systems, a lack of timely, accurate, and up-to-date sell-in and sellout data, and different decision makers were often viewing different information Solution MS Sales is a Data warehouse that consolidates worldwide customer, sales, and inventory data; It is consistent, flexible, interactive reporting environment through MS Reports, it uses Microsoft Excel PivotTable dynamic views, there are 600 standard reports available each month, and multiple queries provide in-depth information Benefits Single, enterprise-wide decision support system promotes consistent, sound business strategies and tactics Flexible, interactive reporting environment provides comprehensive up-to-date information within 24 hours Improved data accuracy and reliability by consolidating 18 different systems Manages 21,000 queries per month and 150 concurrent queries with 12 concurrent reports

Products And Technology Microsoft Excel 2000 Microsoft Access 2000 Microsoft Windows 2000 Server Microsoft SQL Server 2000 Microsoft Visual Basic Development System

Sales Information Management For The Global Enterprise Microsoft Distributors Resellers Sales and Inventory Data Large Customer Accounts MS Sales Sales Marketing Inventory Management Finance

MS Sales Data Warehousing Engine Microsoft Data Distributor Data Data Data Cleansing Cleansing Data Warehouse Business Business Calculations Calculations Reseller Data Business Data Marts MS Reports User Interface Standard Reports Ad Hoc Queries Users

Business Benefits Single, enterprise-wide decision support system promotes consistent, sound business strategies and tactics Flexible, interactive reporting environment provides comprehensive up-to-date information within 24 hours Improved data accuracy and reliability by consolidating 18 different systems Manages 21,000 queries per month and 150 concurrent queries with 12 concurrent reports

For More Information Additional content on Microsoft IT deployments and best practices can be found on http://www.microsoft.com Microsoft TechNet http://www.microsoft.com/technet/itshowcase Microsoft Case Study Resources http://www.microsoft.com/resources/casestudies E-mail IT Showcase [email protected]

This document is provided for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT. 2004 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY. Microsoft, Microsoft Press, Visual Studio, Visual SourceSafe, Windows and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.