Microsoft e-Commerce Solutions

Microsoft e-Commerce Solutions

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.

Recently Viewed Presentations

  • Security and identity (Network Access Protection, Parental ...

    Security and identity (Network Access Protection, Parental ...

    Network Access Protection. Network Access Protection (NAP) is a set of operating system components that provide a platform for protected access to private networks. The NAP platform provides an integrated way of evaluating the system health state of a network...
  • AN INVESTIGATION OF THE ENERGY CONSUMPTION-GROWTH NEXUS IN

    AN INVESTIGATION OF THE ENERGY CONSUMPTION-GROWTH NEXUS IN

    hypothesis as Holtz-Eakin, Newey and Rosen (1988), which, as previously discussed, is a strong assumption. Holtz-Eakin, Newey and Rosen (1988), who assume the homogeneity of cross-section units,
  • New Chapter Leaders Orientation Welcome to New Chapter

    New Chapter Leaders Orientation Welcome to New Chapter

    Hover over the bottom of your screen and click on the chat icon to access the chat box. ... Megan Murray CusickManager, State Advocacy312-280-2423. [email protected] Kathi Kromer Associate Executive Director 202-628-8410 [email protected]
  • Graphs of Motion: P-T and V-T - Uplift Education

    Graphs of Motion: P-T and V-T - Uplift Education

    You Do: Interpreting V-T Graphs. Use the graph of the motion of a toy train, below, to answer the questions. When is the train's speed constant?
  • Poetry - Mesa Public Schools

    Poetry - Mesa Public Schools

    Poetry is usually arranged in lines. It often has a regular pattern of rhythm and may have a regular rhyme scheme. Free verse is poetry that has no regular pattern of rhythm or rhyme, though it is generally arranged in...
  • American Independent Cinema - mikail does blog

    American Independent Cinema - mikail does blog

    A Brief History of American Independent Cinema 1910-1954: the beginnings At one extreme was United Artists formed in 1919 as an independent by Fairbanks, Chaplin, Pickford and Griffith. At the other extreme was Oscar Micheaux(1884-1951) who made and distributed his...
  • Benefits of Early Nutrition Intervention with a TBI

    Benefits of Early Nutrition Intervention with a TBI

    Positively correlated to high blood pressure, HTN, metabolic syndrome, inflammation. Swiss Mammography Cohort study: a high processed meat consumption was associated with statistically significant increased risk of stroke and cardiovascular disease. Vitamin A . The Kuopio Heart Disease Factor Study
  • CS267: Introduction

    CS267: Introduction

    b. Given examples we have seen of control flow in GPU kernels, describe ONE way to reduce divergent branches for ONE of the following: consider tree-structured reductions, even-odd computations, or boundary conditions. c. Regarding floating point support in GPUs, how...