School of Business Administration

1

• School of Business Administration
• Oakland University
• Rochester, Michigan
• Interim Director Prof. Mark Isken

Current 2001 and 2002 ATiB students at DCX museum
as part of our ATiB Fall Conference
2
Program Goal

• Promote partnerships between Oakland
  University and the business community that
  enhances learning opportunities for students
  while providing benefits to corporate sponsors.

The basic theme of the program is to bring
industry, students and faculty together to learn,
share knowledge and feel like they were part of a
team or community. -Mohan Tanniru ATiB
Program Director 1997-2002
3
What is ATiB?

• Unique corporate sponsored undergraduate business
  program its a minor that goes along with any
  SBA major
• junior and senior years
• Combines a rigorous education with hands-on
  training in the application of information
  technology in business
• take one additional ATB course per semester
• work on corporate sponsored projects during
  semesters 2,3,4
• More than a co-op program or an internship. It
  exposes student teams to multiple companies and
  real world business problems.
• First of its kind in Michigan and we have been in
  existence for five years at OU.
• Educational Program of the Year, Automation
  Alley, 2002 Technology Awards

4
A Quick Summary of the ATiB Program
Fall
Winter
Spring/Summer
Fall
Winter
J1
J2
S1
S2
ATB 407
ATB 406
ATB 306
ATB 307
2 students work as a team on 2 company projects
learn VBasic, HTML/Javascript, ASP skills
and project management concepts
Student works full-time as a summer intern
2 students work as a team on 2 company projects,
and learn skills such as data mining, XML and
OLAP
1 Student works as an intern in one
company Works on an innovative
(self-defined) project and mentors a junior
student
Students work on in-class projects as teams and
learn problem solving, business process redesign
and data modeling skills using MS Office
16 hours/week as a team on a project
16 hours/week as a team on a project
20 hours/week as a team on a project
Program Sponsorship covers
Firm pays for the student separately
Summer continuation
One student is kept on the project from semester
to semester to support continuity, if needed and
to provide transition. A mix of MIS and non-MIS
students are used to support inter-disciplinary
flavor. Wednesday evening workshops and fall
conference are used to enhance the students
breadth of knowledge and practice their listening
skills.
5
Why ATiB?

• Three semesters of real business projects.
• Work with several different corporate sponsors
• Work with cutting edge technologies.
• Great networking opportunities.
• Full two year tuition scholarship
• A minor in ATiB
• Use of a private 24hour computer lab.
• Work in teams with other outstanding business
  students

6
Why ATiB?

• Projects coordinated by faculty, seniors and
  sponsors (not left alone)
• Learn
• Problem solving
• Application development
• Project management
• Strengthen your IT skills
• Expand your employment opportunities
• A chance to do something extraordinary

7
A Timely Testimonial

• Michelle Hekkanen
• Acct major, Innovation Challenge winner, now at
  PricewaterhouseCoopers
• Well I definately feel as though ATiB has helped
  me in my current position so far.  We are
  constantly looking at business processes in order
  to understand the detail that surrounds
  everything.  The process analysis that we do in
  ATiB really has helped me.  Also the interaction
  with businesses I had helps as well-some of the
  sponsors are PwC clients.  I worked most of busy
  season on TriMas which is a company that spun off
  of Metaldyne last summer.  I feel like I have a
  much better understanding of what goes on
  companies both in terms of their computer
  processes and their businesses functions, because
  of ATiB.

8
Magical things can happen when...
Functional area business knowledge (finance,
acctng, marketing, HR, operations)
Information technology and information systems
Quantitative analysis and modeling (QMM, Econ)
9
Project Scope

• The project scope spans all the way from
  general business/information technology research
  and analysis/feasibility studies to system
  design, implementation and enhancements.
• Projects cover a broad array of business
  problems (accounting, finance, marketing, human
  resources, MIS, POM, etc.) and their resolution
  using various IT such as Internet and Intranet,
  Database, ERP, GUI, groupware, electronic
  commerce, and other types of special software.

10
Chrysler Services
Comerica
Analyze, document, and rewrite processes used by
Information Services
11
Compuware
Reverse engineer and redesign the check writing
software as the firm migrates from Access 2.0 to
Access 97 environment
Credit Acceptance Corp
Make various financial reports available to
managers on the web using various search
criteria Perform Financial Statement Integration
12
DaimlerChrysler
Develop a customized Visio Application to manage
supply chain information
Develop a database to assist in the
reconciliation of transfer prices on transactions
overseas
Develop a new pricing form to streamline
capturing pricing related data of various models
across continents
13
Deloitte and Touche
Document the internal processes used by a brewery
to assess the sources where there is lost
efficiency or control
Milliken Millwork
Analyze Report Quality and Generate Reports
using Crystal Reports
ALPS Automotive
Analyze sales forecasting activities and develop
Strategies for system integration
14
EDS
Develop a graphical user interface to present
appropriate data from a spreadsheet based on user
defined criteria
Visual Basic Front-End for Executive Reporting
based on Pre-defined Thresholds
Migrate metrics information from Excel to Access
and make it available to multiple users via Web
(using ASP) for access/update
Capture information on various issues related to
managing global contracts
15
Who can apply?

• SBA students (all majors).
• Students with junior standing by the start of the
  program
• Anyone with a willingness to commit to a two year
  program
• Students with a minimum 3.0 GPA (at least 3.0 in
  MIS200 or CSE125)
• Be prepared to spend at least 15 hours a week in
  intense technology training/practice

16
How do I apply?

• Applications available in
• 337 EH (ATiB Office)
• http//atib.sba.oakland.edu and then follow the
  Program link and then the link to Application for
  Admission
• Applications due by May 31, 2003
• Decisions made in June for Fall 2003
• Class size depends on the number of corporate
  sponsors but is typically, 15-20

17
Corporate Sponsors

• ALPS Automotive, Inc.
• ANCOR
• ArvinMeritor, Inc.
• Avaya Communications
• BarronCast, Inc.
• BorgWarner Automotive
• Champion Enterprises, Inc.
• Comerica Incorporated
• Compuware Corporation
• Core (United Dominon Ind)
• Credit Acceptance Corporation
• Crittenton Hospital
• DaimlerChrysler Corporation
• DaimlerChrysler Services
• Deloitte Touche
• DTE Energy
• Durakon Industries, Inc.
• Eaton Corporation
• EDS

• Hubert Distributors
• IBM
• Katke Cousins Golf Course
• Kelly Services
• Kmart Corporation
• Lear Corporation
• Market Probe Milwaukee
• Metaldyne Inc.
• Milliken Millwork, Inc.
• MSX International
• National TechTeam, Inc.
• Oxford Automotive
• Providence Hospital
• Provost Office, Oakland University
• RGIS Inventory Specialists
• Selectcare
• Sequoia NET.Com
• St. John Health Systems
• St. Joseph Mercy Oakland

18
ATiBers out in the World
19
Where Can I Get More Info?

• Stop by the ATiB office in 337 Elliot Hall
• pick up literature, look around, meet Prof. Isken
• Check out the web site http//atib.sba.oakland.ed
  u
• Send an email to atib_at_oakland.edu and tell us
  your interested
• Attend the Final Student Presentations on Friday,
  April 18th from 200pm -500 in 242 Elliott Hall.
  
• Ask any ATiB Student.

20
A Shameless Advertisement

• MIS 446 Business analysis and modeling
• Im teaching most every FallWinter
• Spreadsheet based modeling course
• An über business analysis course
• ExcelAccessVBAmodeling solve tough business
  problems
• Applications in Finance, Marketing, MIS, POM

21
Spreadsheet Decision Support System Example -
Portfolio Optimization

• Given a set of investments, how do we find the
  portfolio that has the lowest risk and yields an
  acceptable expected return?
• The single period mean-variance Markowitz model
  (1991 Nobel Prize)
• You saw this in your Intro Finance course

Stocks
Bonds
Gold/silver
x1
x2
x3
x4
x5
x6
22
The End Product
23
Value of Putting it all Together

• Portfolio optimization example underscores value
  of combining
• Domain knowledge (e.g. finance)
• Mathematical modeling skills (e.g. probability,
  statistics, optimization)
• Information systems skills (e.g. VBA, application
  development)
• Financial Engineering at graduate programs
  throughout the country