220 likes | 237 Views
Atlanta OAUG Meeting. 5 out of 5 cows agree…. Agenda…. Who is ? Oracle Environment Web Payroll Demonstration. WHO IS ?. “ We didn’t invent the chicken…..We invented the Chicken Sandwich “. Based in Atlanta, GA 1st in the mall food courts
E N D
Atlanta OAUG Meeting 5 out of 5 cows agree….
Agenda… • Who is ? • Oracle Environment • Web Payroll • Demonstration
WHO IS ? “We didn’t invent the chicken…..We invented the Chicken Sandwich “ • Based in Atlanta, GA • 1st in the mall food courts • 35 states • Over 26,000 restaurant employees • Over $900 million in sales in 1999 • Over 900 stores
WHO IS ? Privately held, family-run business (not a traditional franchise) S. Truett Cathy Founder and Chairman Unique Business Approach = Operator Agreements
CORPORATE PURPOSE: • To glorify God by being a faithful steward of all that is entrusted to us • To have a positive influence on all who come in contact with Chick-fil-A WHO IS ? • EVIDENCE OF OUR CONVICTION: • Closed on Sundays • Foster home program • Over 12,000 scholarships awarded to team members • MISSION: • To be America’s best quick-service restaurant at satisfying every customer
WHO IS ? • Since opening 52 years ago, CFA has posted 30 consecutive annual sales increases • Greater than 10% average annual sales growth in the past 5 consecutive years • Sales in 1999 reached $912 million • Poised to reach $1 billion in sales and 1,000 restaurants during the year 2000
WHO IS I.T.? I.T. Mission Statement: To simplify business processes by applying information technology; To provide necessary support to maintain business operations.
Oracle Environment • Current Oracle Applications Installed • General Ledger January 1994 • Accounts Payable • Purchasing • Fixed Assets • Order Entry • Inventory • Fixed Assets • H/R Payroll January 1998 • Multi-org installation • Chick-fil-A, Inc. • Winshape, Inc. • STC Properties, Inc
Oracle Environment • Business Functions • We make use of Standard Oracle functionality for our Corporate General Ledger, Payables, Purchasing, and Fixed Assets. We use Order Entry and Inventory in our equipment warehouse. • We also serve as an Accounting, Payroll, and Tax Report bureau for our locations. Therefore, we often use Oracle Applications in a unique way. • We process … • 800+ Profit and Loss Statements per month • 25,000+ Payroll Checks every two weeks
Oracle Environment • Custom Extensions • We have about 900 modules that were written to extend the functionality of Oracle Applications. These are primarily related to our custom P&L processing applications and payroll web front end. • Guiding Principles for Customization • Use Oracle Applications as delivered. Do Not Customize Oracle Applications. • Match Oracle “look and feel” for custom development extensions. • Use APIs whenever possible.
Oracle Environment • Technical Specifications • Server : HP V-Class server with 16 440MHZ CPUs and 8GB of RAM • Storage : EMC Symmetrix with 1.5T of storage and 6GB of cache attached to the server with fibre channel and load balanced with PowerPath • Operating System : HP-UX 11.0 • Database : Oracle 8.0.5.1 64Bit • Oracle Applications : 10.7 Character/NCA (server partitioned mode)
Oracle Environment • Technical Specifications • MiddleTier : 2 NT Forms Servers with 1 400MHZ CPU and 500MB RAM each. Each server should handle around 20 NCA users. • Web Servers : 2 HP D370s with 500MB RAM and 1 130MHZ CPU each. They are running Oracle Application server 4.0.7.1. They are load balanced using RadWare's load balancing hardware.
Oracle Environment • Future Directions … • Upgrade to Oracle 11i in Fall 2000 (Assuming Oracle 11i is delivered by 3/31/2000). • Convert 150+ character forms from 2.4 to 6.0. • Prepare user community for conversion to GUI. • Re-evaluate and Re-engineer business processes to take advantage of new technology in Oracle 11i.
Web Payroll Oracle Application Example Location Web Payroll System
Old Payroll System - Overview Cons • PC application written in DBASE was over 12 years old. It had reached the physical limits of the amount of code that could be compiled. • Over 750 individual installations (one per store). Each install contained a set of tax parameters maintained at the discretion of the Operator. • Little or no data validation. • No history kept in the application. Pros • Operators liked the system. • Easy to use. • No reliance on Corporate HQ.
New Payroll System - Objectives • Allow the Operator to be in control of paying his/her people by initiating the payroll, printing & signing the payroll checks in the store. • Allow corporate staff to pay 25,000+ employees bi-weekly, interface general ledger information to over 750 cost centers, pay federal, state & local taxes for over 550 different tax entities & print over 50,000 W2s at year end.
New Payroll System - Options • Software Package (supported by someone else) • Custom System (to do exactly what the old system did) • Outsource payroll to third party (and take whatever service level they can give us) • Let Operators do it themselves (using a local accountant) • Develop a solution that combines the best of available alternatives - This is the system that we developed
Web Based Payroll System - Results Centralized Oracle Application: • Payroll Calculation • Tax Filing • Interface to P&L • History Distributed Access for: • Employee Maintenance • Time Entry • Check Printing
Web Based Payroll System - Results • Implemented Oracle Payroll package to provide “bureau” quality and scalability • Custom, dynamic HTML to provide simple, easy to use screens • Partnered with Oracle to write one of the APIs that was needed for the project. • World Wide Web attention for being the first company to do payroll across the web using Oracle products. • National attention in ‘Nations Restaurant News’ magazine for this payroll application.
Web Based Payroll System Demonstration
? Questions????