UNICOM Application Development

1
UNICOM Application Development

• Scott Cornell
• Application Developer
• 5/26/05

2
Technology

• Web development
• ASP.NET
• JSP/Java (Apache, WebSphere)
• ColdFusion
• Classical ASP (VB6)
• Client server apps
• VB.NET, C

• Database
• SQL Server
• Microsoft Access
• Oracle

3
Technology

• Mobility Apps
• WinCE
• PocketPC
• SharePoint
• WSS
• SPS

• BizTalk
• Cisco Telephony

4
Front-end services

• Analysis
• Project Management

5
Data Management

• Data Migration
• Access to SQL
• Access to Oracle
• Customized Apps
• Web-based
• Windows-based

• Report Generation
• .NET custom reports
• Crystal Reports
• WebFocus
• Report Services for SQL
• Network Tools
• Active Directory

6
Follow-on services

• Database consulting
• Performance tuning
• troubleshooting
• Training
• Custom app (specific)
• Technical Hands on Training (generic)
• 1-on-1 Support

• As-built Documentation
• Support Contract

7
Collaboration packages

• Mobility Apps
• WinCE
• PocketPC
• Portals
• WSS
• SPS

• EIA
• BizTalk
• Workflow automation
• StaffWare

8
Staff Augmentation

• Web development
• Client server apps
• Project Management
• DBA

9
Q A
10
Data Collection Reporting problemsTaunton
Public Schools
11
Background

• Taunton Public Schools needed to track data on
  its staff members to meet the requirements for
  No Child Left Behind and to provide EEO and
  other state-mandated reports.
• Data collected on staff members
• Contact information
• Retirement
• Certification
• Degrees

12
Issue

• The data is located in several different
  locations
• Pen Paper
• Excel Spreadsheets
• Access databases

13
Issue
14
Pain

• Difficult to find the right staff information
  quickly (wasted time).
• Delay in providing Required reports to the state
  (wasted time).

15
Pain
16
Requirements

• Provide an easier way to access all staff
  information through a single interface.
• Provide expandability for future reporting needs.
• Utilize existing staff MS Access skills.

17
Solution

• Consolidate all the Access databases and Excel
  Spreadsheets into one Microsoft SQL Server
  database.
• Provide a single Graphical User Interface via
  Microsoft Access forms.

18
Solution
19
Benefit

• Central location of all data.
• Easier access to data.
• Can utilize existing Microsoft Access skills for
  creating additional reports.

20
Benefit

• Save time in inputting and retrieving data.
• Able to provide the needed state reports for
  NCLB, EEO, and so forth.

21
Q A
22
Active Directory UpdaterProvidence School System
23
Background

• Each student in the Providence School system has
  their own Active Directory account and home
  directory.
• The students home directory is stored on the
  schools file server.
• The student account is stored in an Active
  Directory Organizational Unit (OU) for the School
  the student is attending.
• The student account belongs to certain groups
  that are specific to each school.
• The student information is maintained in a
  separate registration system.

24
Background
25
Issue

• As students move into or out of the school
  district
• Their account needs to be created or disabled.
• Their home directory needs to be created or
  removed.
• Security needs to be setup or removed on their
  home directory.
• The account needs to be added or removed from the
  security groups.

26
Issue Cont.

• When students moved up a grade and into a new
  school
• Their account needs to be moved into the new
  schools OU in Active Directory.
• Their home directory needs to be moved to the new
  schools file server.
• Security needs to be setup on the home directory.
• Their account needs to be removed from the old
  groups and added to the groups in the new school.

27
Move the Student
28
Pain

• It was taking hours each week to move accounts
  around.
• It was taking a months worth of time to setup
  and move the accounts during the summer recess.

29
Requirement

• Limit the manual labor require to update the
  student information in Active Directory.
• Provide reporting and error notification.

30
Solution

• UNICOM developed a program to automate the
  process of setting up, disabling or transferring
  of student accounts and home directories.
• The program reads changes from the registration
  system and implements the changes in Active
  Directory.
• The program automatically create new Active
  Directory structures as needed.

31
Solution
32
Benefit

• The program saves the Providence School System
  hundreds of hours of labor each year.
• The program frees up the Providence Schools IT
  staff to handle more important problems.

33
Q A