...

HeadTrax - Microsoft

by user

on
75

views

Report

Comments

Transcript

HeadTrax - Microsoft
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
Cleansing
Data
Warehouse
Business
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.
Fly UP