Michael Sullivan Enterprise Application Integration Manager The Enterprise Application Integration Group phone:(781) 283-3276 msulliva@wellesley.edu

Job Responsibilities

1. Technical Liason to the Registrar's Office, the Admission Office, Housing and Student Life. In this capacity, with others, I resolve problems, including Oracle form problems, Pro*C program problems and PL/SQL program performance problems. With others, I have also been responsible for installing Oracle client desktop software, including Oracle Discoverer and Oracle Developer Suite. I interact with people ranging from staff at Sungard Higher Education(Wellesley College's ERP vendor), Wellesley College's Technology Infrastructure group, and Wellesley College's Help Desk so as to communicate and help coordinate system upgrades and testing. In addition, I work on special projects as required by the people I support.

2. Assistant Datamart Administrator. Responsible in the absence of the Datamart Administrator for migrating code to our production environment, for ensuring the nightly data mart refresh completes properly and for interacting with Technology Infrastructure staff vis-a-vis backups, tuning, sizing, operating systems upgrades, and hardware changes as they affect the datamart.

3. Participate in Wellesley College's Datamart project, specifically in its student, general, and institutional research components. I have written and continue to write, test and implement PL/SQL code responsible for the staging table and reporting table components of major parts of Wellesley College's data mart (really an Operational Data Store). In addition, as necessary, I assist the Datamart Admininistrator in facilitating the evolution of the datamart architecture.

4. Enterprise application integration work. A fairly large amount of my time is spent on connecting our BANNER ERP and our datamart ODS to other systems. An example is the automatic upload of BANNER/data mart data into our Health Services Medicat application. A second example is the investigation of imaging systems (hardware and software) that may streamline workflow at the college and permit data more readily to be entered and accessed in BANNER.

Experience

• Prior to Wellesley, I worked with ORACLE and SCT's BANNER software on UNIX platforms at North Shore Community College and Clark University.
• At Clark University, I was responsible for programming end-user reports and worked primarily in FOCUS and SQL*Plus.
• At North Shore Community College, my responsibilities were considerably more varied.

  I assisted with upgrades and with managing database security.

  I programmed end-user reports using C, SQL*Plus, SQR, COBOL and UNIX shell scripts.

  I assisted end-users in implementing and maintaining functionality such as National Student Loan Clearinghouse processing, telephone retrieval of grades, and satisfying the requirements of the Tax Relief Act of 1997.

Education

M.A., Philosophy, Vanderbilt University

B.A., Mathematics and Philosophy, Boston College

Contact

Michael Sullivan	Phone Number:
IS/EAI Group	(781) 283-3276
Wellesley College	Fax Number:
106 Central Street	(781) 283-3682
Wellesley, MA 02181-8201	msulliva@wellesley.edu

Back to EAI Group