1 / 22

Atlanta OAUG Meeting

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

millhouse
Download Presentation

Atlanta OAUG Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Atlanta OAUG Meeting 5 out of 5 cows agree….

  2. Agenda… • Who is ? • Oracle Environment • Web Payroll • Demonstration

  3. 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

  4. WHO IS ? Privately held, family-run business (not a traditional franchise) S. Truett Cathy Founder and Chairman Unique Business Approach = Operator Agreements

  5. 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

  6. 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

  7. WHO IS I.T.? I.T. Mission Statement: To simplify business processes by applying information technology; To provide necessary support to maintain business operations.

  8. 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

  9. 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

  10. 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.

  11. 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)

  12. 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.

  13. 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.

  14. Web Payroll Oracle Application Example Location Web Payroll System

  15. 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.

  16. 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.

  17. 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

  18. 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

  19. 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.

  20. Web Based Payroll System Demonstration

  21. ? Questions????

More Related