Chris Bowman Union University 1987 Memphis Light Gas

Chris Bowman Union University - 1987 Memphis Light, Gas and Water Division Data Warehouse System – Team Lead

Agenda § § § § Introduction Union Days MLGW Work Experience Data Warehouse Job Search Contact Info Q & A

Introduction § § Married to Delaine Mc. Kee (Union 89) 4 children - homeschool § § § Steven – 17 (violin, MYS, Union 2006…) Sarah – 12 (violin, soccer…) Jonathan – 9 (violin, soccer…) David – 7 (soccer…) Atoka, TN Sam the dog & Cooper the cat Christian Music, Jam Sessions, Snow Skiing, Mountains, Coffee, Jogging, etc…

Union: Degree Earned § Bachelors of Science 1987 Major – Computer Science Minor – Accounting

Union: Personal Facts § Favorite Computer Class Data Structures – Mr. Jennings § Favorite Instructor Dr. Spohn - Biology § Favorite Class Chemistry – Dr. Davis § Worst Class Old Testament Survey § Worst Grade Federal Income Tax (B to D in 3. 8 seconds) § Greatest Success Story Arts in Western Civ – Dr. Mc. Clune

Union: Positive Influence § Christian Environment Jesus Christ 1 st § Caring Professors Available, Personal, Encouraging § Work Ethic Hard work, Much encouragement

Union: Lessons Learned § Save your work often! It can be gone in an instant. § It ain’t all fun! Grit your teeth and bear it. § Presumption can be dangerous! Get the facts. Consider the source.

MLGW: Overview § Memphis Light, Gas and Water Division Nation’s largest three-service public utility Over 400, 000 residential, commercial and industrial customers in Shelby County Over 2, 800 employees (111 in I. S. Division)

MLGW: IS Org Chart

Work Experience § MLGW – 16 years Contracted Programmer – 1 yr Programmer/Analyst - 2 yrs Senior Programmer/Analyst - 8 yrs Computer Software Specialist II & III - 5 yrs Business Systems Analyst IV - 1 yr § Data Warehouse System Lead last 3 yrs

(cont. ) Work Experience § BSA IV Key Responsibilities: Administration: § § § Project Management Business Continuity Cost Analysis Budgeting Promotion & Marketing Education Technical: § § Business Analysis Developer Report Writer Web Development

MLGW Data Warehouse Overview

MLGW DW: § § § § Introduction System Overview Access Requirements Keeping you Informed What Next? Contact Info Q & A Agenda

MLGW DW: Introduction § Information Services (VP-Linda Peppers) Information Technology (Mgr-Richard Bowker) § Office Automation (Supv-Torri Holliday) Data Warehouse System

MLGW DW: Introduction Heloise Simelton MLGW Computer Software Spec III Security Administration Training Coordinator Chris Bowman Web Master MLGW Business Systems Analyst IV Data Warehouse Team Lead Project Administration Business Analysis Bob Kessler Mike Marr Ciber, Inc. Database Developer Data Extraction Research Analysis Database Development MLGW Business Systems Analyst II Report Development Software Administration

MLGW DW: System Overview § What is the Data Warehouse? § § § § Technical Definition Why do we exist? Real Life Examples MLGW Data Warehouse Overview System Diagram Demonstration Usage Savings

MLGW DW: Technical Definition § A Data Warehouse is: “A database that consists of data extracted from operational databases over time and architected to provide business users with analytical access to business information in a timely and efficient manner. ” § Key Points: • • • Separate Database Operational System Source Historical Data Analytical Design & Focus Ad-hoc Reporting Capabilities

MLGW DW: Why do we exist? § Initial Estimated Savings - $4, 561, 913 1997 Aug - RIP Study § Savings Estimates HR - $38, 323 Fin - $517, 500 EM - $199, 000 WM - $1, 635, 000 MM - $1, 508, 757 CIS - $663, 553

MLGW DW: Real Life Examples § Equipment Replacement Candidates • What determines if a car or truck should be replaced? § Budget Tracking • How much money have I spent and how much is left?

MLGW DW: MLGW DW Overview § Began Oct 1999 § 10 Data Marts Human Resources Equipment Work Management General Ledger Budget Material Management Absence Time Reporting Payroll Safety Service Consumption § Oracle Database • • • (350 GIG) General Ledger – 190, 000+ Rows Consumption History – 85, 000+ Rows § Hardware • • Database Server - Linux/Dell Web Server - 2000/Dell § Software • • Business Objects – full client Web. Intelligence – thin client

MLGW DW: MLGW DW Overview § DW Support Staff • (Lead / Extract Spec / Business Analyst / Security-Training Coord / DBAs) § Data • • Near Real Time Retrieval Only § Use • • 500 Users 80% Ad-hoc 550+ Production Reports 3500 Reports Run/Month § Benefit • • $4, 500, 000+ Original Estimate $17, 000+ Savings to Date

MLGW DW: System Diagram

MLGW DW: Demonstration § Real Life Reports Equipment Replacement Report Remaining Actual vs Budget Report § Software Screen Shots Business Objects Designer Web Intelligence Create Document Web Intelligence Conditions Web Intelligence Result Document

MLGW DW: Usage § 2004 Averages • • 750 Events/Day 160 Reports/Day (2003 -660 / 2002 -360) (2003 -120 / 2002 -75) § Nbr Users up from 25/1999 to over 500/2004 § 60% Avg Annual Increase since 2000 § Approx 80% of all usage is AD-HOC

MLGW DW: Usage

MLGW DW: § 2004 Savings - $4, 239, 301 $2, 500 $1, 460, 570 $56, 920 $221, 311 -Annualized -Ad-hoc Annualized -Tangible -1 Time IS § 2005 Estimated Savings - $5, 173, 179 § Areas of Savings -Time -Dollar -IS Programming -Ad-hoc § Life to Date Savings: $17, 100, 701 Savings

MLGW DW: Savings

MLGW DW: Access Requirements § Security Approval § Training Class Both are required prior to being granted access to the Data Warehouse!

MLGW DW: Access Requirements § Security Approval: Supervisor’s approval (Immediate superior) Data Owner approval (Data Mart Security Owner) § Must be obtained prior to attending Training! § DW Security Website Security Forms Security Types Data Owners

MLGW DW: Access Requirements § Training Class: Full Day Web. Intelligence Training Class Data Mart specific Hands-On Security Approval required § Schedule: DW Website Call us !

MLGW DW: § Access Requirements Additional Training: Web. I Refresher classes are available on demand Users must attend Data Definition for additional data marts Business Objects users must attend Business Objects class § Training Options DW Overview – 2 hrs Web. I for each Data Mart – full day Web. I Refresher – half day Business Objects (5 i) – full day Data Definition for each Data Mart – 2 hrs Power User (5 i) – half day One on One / Small Group / Hackers Class § 219 Classes / 918 Students (As of Sept 2005)

MLGW DW: Keeping You Informed § Newsletter We produce a newsletter every other month with tips, updates and Data Warehouse news. This is distributed via email. § User Group Meetings We conduct user group meetings to keep you informed and give you a chance to ask questions in an interactive group setting. § Website contains information about team members, data marts, security, training schedule, etc § Corporate Documents DW 0001 – Load Summary DW 0002 – User Security DW 0004 – Meta. Data Object Source Data

MLGW DW: User Support § Training Most of our user’s attend multiple training sessions. Let us know what your needs are and we will help you meet them. § Help Desk Support Continued mentoring and training Troubleshooting reports Research and Analysis Contact Us § Call up directly § E-mail § Regular Help Desk § Change Request An automated process that makes it easy to submit and monitor user requests for Report and Data Mart changes.

MLGW DW: What Next? § Is the Data Warehouse for you? Obtain Required Security Approval Attend Required Training Class § Web. Intelligence Training Scheduled every 1 to 2 months (as needed) Full Day Hands-On Data Mart Specific Run lots of Reports and save lots of Money

Job Search § § § § Required Skills Computer Careers Job Market Salary Preparation Search Advice Job Advice References

Job Search: Required Skills § Responsibilities currently used to support the Data Warehouse • • Extraction Specialist Database Administrator Developer Business Analyst Report Writer Security Administrator Training Coordinator § Recommended Education • 4 Year College Degree in one of the following: § § § Computer Science Information Systems Engineering with I. S. minor Business with I. S. minor Math with I. S. minor Accounting with I. S. minor § Alternative Education • Additional opportunities exists with 2 year Associates Degree in I. S.

Job Search: Careers § Computer Programmer § Business/Systems Analyst § Analyze, design, test, and evaluate network systems Perform network modeling, analysis, and planning Hardware Engineer § Define and solve business problems using the internet or intranet Works with customers to update and maintain web site Network Analyst § Database installation, maintenance, sizing, performance, tuning, backup and recovery. Develops database design and enhancements and migrates from development to production system. Web Developer § Define and solve business, scientific, and engineering problems, using computers. Design and maintain computer systems (including hardware and software). Database Administrator § Specializes in application programs or maintaining system software Plan system concept and the hardware needs for computer systems Prepare detailed specifications and methods to interface computer products Computer Operator / Security Administrator / Training Coordinator / Report Writer

Job Search: Job Market § Any Location Small towns to large cities § Fast Moving Technology is changing § Diverse Environments Work alone, in groups, at home

Job Search: Salary § 2005 Average Starting Salaries: Computer Science – 52 k Computer Programming – 54 k Consulting – 49 k § MLGW Starting Salaries: With 4 year degree – 53 k With 2 year degree – 43 k With no degree – 0 k

Job Search: Preparation § § Personal Computer Publications Computer Books School Concentration: Math Statistics Logic § You will never stop learning!

Job Search: Search Advice § Pray, Pray God’s will is most important § Know More/Know Less Confidence – not Arrogance § People Skills More important than Technical § First Impression No second chances § “Inside Contact” Just gets you inside § Interview Performance It’s just you baby § No one owes you anything Jobs won’t hunt you down

Job Search: Job Advice § Pray, Pray God’s will is still most important § Integrity and Strong Ethical Conduct Character, not characters § Have fun Don’t take things too seriously § Work to live, not live to work Have right priorities § No job is perfect People, Politics, and Pettiness

Job Search: References § Job Descriptions www. collegeboard. com/html/careerbrouser. html § Salary Information Salary. com Jobsmart. org/tools/salary/ ww. salaryexpert. com www. payscale. com § Bureau of Labor Statistics www. bls. gov § Job Search www. monster. com www. careerbuilder. com

Contact Info § E-mail: cbowman@mlgw. org § Work: 901 -729 -8327 § Cell: 901 -833 -8016

Q & A § Questions?