Chris Bowman Union University - 1987

1
Chris BowmanUnion University - 1987

• Memphis Light, Gas and Water Division
• Data Warehouse System Team Lead

2
Agenda

• Introduction
• Union Days
• MLGW
• Work Experience
• Data Warehouse
• Job Search
• Contact Info
• Q A

3
Introduction

• Married to Delaine McKee (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

4
Union Degree Earned

• Bachelors of Science 1987
• Major Computer Science
• Minor Accounting

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

6
Union Positive Influence

• Christian Environment
• Jesus Christ 1st
• Caring Professors
• Available, Personal, Encouraging
• Work Ethic
• Hard work, Much encouragement

7
Union Lessons Learned

• Save your work often!
• It can be gone in an instant.
• It aint all fun!
• Grit your teeth and bear it.
• Presumption can be dangerous!
• Get the facts.
• Consider the source.

8
MLGW Overview

• Memphis Light, Gas and Water Division
• Nations 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)

9
MLGW IS Org Chart
10
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

11
(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

12
MLGWData Warehouse

• Overview

13
MLGW DW Agenda

• Introduction
• System Overview
• Access Requirements
• Keeping you Informed
• What Next?
• Contact Info
• Q A

14
MLGW DW Introduction

• Information Services (VP-Linda Peppers)
• Information Technology (Mgr-Richard Bowker)
• Office Automation (Supv-Torri Holliday)
• Data Warehouse System

15
MLGW DW Introduction
Heloise Simelton MLGW Computer Software Spec
III Security Administration Training
Coordinator Web Master
Chris Bowman MLGW Business Systems Analyst
IV Data Warehouse Team Lead Project
Administration Business Analysis
Bob Kessler Ciber, Inc. Database Developer Data
Extraction Research Analysis Database Development
Mike Marr MLGW Business Systems Analyst II Report
Development Software Administration
16
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

17
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

18
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

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

20
MLGW DW MLGW DW Overview

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

21
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,000 Savings to Date

22
MLGW DW System Diagram
23
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

24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
MLGW DW Usage

• 2004 Averages
• 750 Events/Day (2003-660 / 2002-360)
• 160 Reports/Day (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

31
MLGW DW Usage
32
MLGW DW Savings

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

33
MLGW DW Savings
34
MLGW DW Access Requirements

• Security Approval
• Training Class
• Both are required prior to being granted access
• to the Data Warehouse!

35
MLGW DW Access Requirements

• Security Approval
• Supervisors 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

36
MLGW DW Access Requirements

• Training Class
• Full Day WebIntelligence Training Class
• Data Mart specific
• Hands-On
• Security Approval required
• Schedule
• DW Website
• Call us !

37
MLGW DW Access Requirements

• Additional Training
• WebI 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
• WebI for each Data Mart full day
• WebI Refresher half day
• Business Objects (5i) full day
• Data Definition for each Data Mart 2 hrs
• Power User (5i) half day
• One on One / Small Group / Hackers Class
• 219 Classes / 918 Students (As of Sept 2005)

38
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
• Website contains information about team members,
  data marts, security, training schedule, etc
• Corporate Documents
• DW0001 Load Summary
• DW0002 User Security
• DW0004 MetaData Object Source Data

39
MLGW DW User Support

• Training
• Most of our users 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.

40
MLGW DW What Next?

• Is the Data Warehouse for you?
• Obtain Required Security Approval
• Attend Required Training Class
• WebIntelligence 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

41
Job Search

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

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

43
Job Search Careers

• Computer Programmer
• Specializes in application programs or
  maintaining system software
• Business/Systems Analyst
• Define and solve business, scientific, and
  engineering problems, using computers.
• Design and maintain computer systems (including
  hardware and software).
• Database Administrator
• 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 problems using the
  internet or intranet
• Works with customers to update and maintain web
  site
• Network Analyst
• Analyze, design, test, and evaluate network
  systems
• Perform network modeling, analysis, and planning

44
Job Search Job Market

• Any Location
• Small towns to large cities
• Fast Moving
• Technology is changing
• Diverse Environments
• Work alone, in groups, at home

45
Job Search Salary

• 2005 Average Starting Salaries
• Computer Science 52k
• Computer Programming 54k
• Consulting 49k
• MLGW Starting Salaries
• With 4 year degree 53k
• With 2 year degree 43k
• With no degree 0k

46
Job Search Preparation

• Personal Computer
• Computer Publications
• Computer Books
• School Concentration
• Math
• Statistics
• Logic
• You will never stop learning!

47
Job Search Search Advice

• Pray, Pray, Pray
• Gods 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
• Its just you baby
• No one owes you anything
• Jobs wont hunt you down

48
Job Search Job Advice

• Pray, Pray, Pray
• Gods will is still most important
• Integrity and Strong Ethical Conduct
• Character, not characters
• Have fun
• Dont take things too seriously
• Work to live, not live to work
• Have right priorities
• No job is perfect
• People, Politics, and Pettiness

49
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

50
Contact Info

• E-mail cbowman_at_mlgw.org
• Work 901-729-8327
• Cell 901-833-8016

51
Q A

• Questions?

52
(No Transcript)