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

  • Bringing the Risk Based Approach to the eTMF

    Bringing the Risk Based Approach to the eTMF

    Many people consider that the only area to impact the TMF is section 8 of ICH E6 R2, but it is important to look holistically at all the changes as well as the impending changes to ICH E8 (draft May2019)....
  • Data and Computer Communications

    Data and Computer Communications

    "Data and Computer Communications", 10/e, by William Stallings, Chapter 16 "Advanced Data Communications Topics". Advanced Data Communications Topics. ... in the parity-check matrix H , the first . k. columns correspond to data bits and the.
  • American Gothic Romance - Burlington County Institute of ...

    American Gothic Romance - Burlington County Institute of ...

    American Gothic Romance ... American Gothic: The Brooding Romantics Theirs is a complex philosophy, filled with dark currents and a deep awareness of the human capacity for evil. Their stories are characterized by a probing of the inner life of...
  • Chapter 8 The Hip Joint and Pelvic Girdle

    Chapter 8 The Hip Joint and Pelvic Girdle

    Anterior compartment . Rectus femoris. Vastusmedialis. Vastusintermedius. Vastuslateralis. Sartorius. Posterior compartment - Hamstring group. Biceps femoris. Semitendinosus. Semimembranosus. The Hip Joint and Pelvic Girdle - Skeletal Muscle Compartments in Thigh. Medial compartment - Adductor brevis. Adductor longus. Adductor magnus. Pectineus...
  • ROSWELL CITY COUNCIL MEETING December 11, 2017 NFCTP

    ROSWELL CITY COUNCIL MEETING December 11, 2017 NFCTP

    Atlanta Region's Plan is informed primarily by CTPs. ARC provides financial assistance to counties (80:20 split) CTPs help the region to fill federally required plan elements indicated in Code of Federal Regulations* Participation not required but is an accepted practice...
  • 19.2 Animal-like Protists KEY CONCEPT Animal-like protists are

    19.2 Animal-like Protists KEY CONCEPT Animal-like protists are

    flagella help zooflagellates swim May have 1 or more flagella more than 2000 zooflagellates Some protists move with pseudopods. change shape as they move Use pseudopodia for moving and feeding amoebas foraminifera Some protists move with pseudopods. change shape as...
  • Weathering and Erosion

    Weathering and Erosion

    Erosion. Acid precipitation. Water. Mechanical/Physical weathering. Chemical weathering. Ice wedging. Chemical weathering. Weathering. ... Look at each picture and decide if it is an example or chemical weathering or mechanical weathering. Chemical . Weathering. Mechanical.
  • Kalām Cosmological Argument

    Kalām Cosmological Argument

    Is it true that causal reality began? If not, then the second argument clearly fails. But since the Naturalist thinks that causal reality = natural reality, it is clear that the Naturalist is also entitled to think that the first...