NYU IT Projects Course, Demo Show Fall 2005, Tuesday, December 13, 5-8 PM
Food and drinks will be served.
My students have produced great results this semester. To display their accomplishments they will demo their work. Therefore, I invite you to attend the NYU Information Technology Projects DemoShow. Students will present their work at 'trade show' style booths. Come and go as you wish. Meet NYU faculty, other NYU students, and former Projects students.
I invite corporations, government agencies and non-profits to discuss proposals for projects in future offerings of this course. The next offering will be Spring 2006, starting in the third week of January. Please view a description of the course and a list of our projects over the last 6 years.
Sponsor: Susan E. Green
Open source software is code that is designed and built and built by the community and distributed with source code free-of-charge. Many open source programs have become widely used. These include Linux, OpenOffice, Mozilla, the Apache Web server, Java and MySQL and many others.
Large firms, like the Bank of America, should carefully evaluate and compare the benefits with the costs and risks before deploying any software, especially for 'mission-critical' applications. With respect to Linux they've already made this evaluation, and decided to use it.
Evaluating open source software presents a very different set of issues than commercial software. This project aims began that investigation for the architecture team within Bank of America's Corporate and Institutional unit.
First, we analyzed open source's potential financial benefit by classifying a handful of top commercial applications and platforms in use by the bank which could be replaced by open source products and quantifying the potential savings of such a replacement, when possible.
Because the risks associated with open source software differ greatly from those of commercial software they warrant significant investigation. Methods for mitigating the risks also require research. In this area we've investigated the following.
the legal risks of using open source technologies, and their mitigations and management
the use of outside services for quality assurance certification
code and infrastructure management techniques
vendor and 3rd party technical support
Second, anonymous surveys were conducted targeting IT architects, managers, and developers at eleven large Wall Street firms. The survey's goal was to provide both quantitative and qualitative data analysis of open source usage, practices, issues, and trends within “Wall Street IT”. Working from the following seven high-level objectives with respect to open source,
internal marketing and education
automatic identification tools
a questionnaire was developed, tested and administered. The resulting data have been summarized and categorized and will be presented at the demo show and the survey team will be available for questions.
Sponsors: William Starita, and Javed Ahmed, Controlling IT, and Chris Hayward, Controlling IT Global Head
Inter-Unit clearing is the process of identifying breaks between the inter-company transactions booked in the ledgers. A break is “a discrepancy on the books of a brokerage firm” For example, consider a stock or bond trade. A break can occur because both the selling and purchasing firms submit a description of the transaction. If the two descriptions do not match, the result is a break.
The Inter-Unit clearing output is used by the bank's accountants to reconcile any inter-company differences to prepare a report on the overall financial position(s) of a group of companies for internal and external reporting purposes.
We helped convert an existing application from MS Access to an Oracle-based system with a web interface for reporting. This change has made the application more stable, scalable, and easier to maintain.
In the previous application, data feeds were manually refreshed by users, which often resulted in failures within the custom MS Access application. In the new system, the process to load feed-data has been automated. The system is now remotely accessible via a browser. Security is provided via password protection using an existing Oracle authentication login mechanism which many Deutsche Bank applications utilize.
The scope of the project is the following:
Developed a solution for implementing a web-based ColdFusion reporting application for the NY Inter-Unit Clearing (IUC) Submission.
The solution was based on existing technology used by other areas in Controlling for reporting. Specifically, we enhanced an existing website in the following manner:
Connected to a new Oracle database schema for IUC within the Regulatory Tactical BAC (Business Area Controlling) Systems database
Provided menus for accessing inquiries
Provided reference tables for maintaining business rules
Reference tables can be maintained by a reference maintenance application or directly in Calico. Due to time constraints, implementation of maintenance screens was not completed in this project.
Provided download or save mechanism for the inquires
The application was designed so that the manual intensive month-end initialization process was eliminated. Instead, feeds are automatically loaded and no interference from IT is required.
The application was designed in a way as to minimize codified business rules thereby making maintenance of these rules under the domain of the business instead of technology.
The main benefits of the project are the following:
Improved Inter-Unit Clearing Submission process – reduction of system crashes and elimination of manual refresh process that is prone to delays and errors.
Reduced IT support cost for NY IUC submission
Provided the capability of adding additional rules dynamically using SQL statements without having the need to do any programmatic changes.
Converted a legacy ‘Access’ reporting system into a world wide web friendly application interface which provides instant access for authorized users.
We helped design, implement and test the new system. The new system passed user-acceptance testing, and was placed into production on Dec. 5.
Sponsor: Dave Ditillo, AVP - Corporate eBusiness IT
As MetLife expands its international services, it seeks to push content to various populations that speak different languages. Their units want to enable their applications to effectively and efficiently support internationalized content. We architect this in two steps: web application internationalization builds a framework that generalizes a web application so the app can handle multiple languages, regions, currencies, time, and cultural conventions, and web application localization takes an internationalized Web application and makes it linguistically and culturally appropriate for the target locale(s) (country/region and language) where it will be used.
To support an internationalized MetLife Portal, the following high-level requirements have been defined for the portal application:
Capability of rendering portal content in multiple languages
Ability to serve locale specific content
Potential for supporting different U/I (site themes, layout, etc.)
Extensible architecture to allow for the support of mobile devices
Provide application-level support for the different variants (i.e. language, locale, and device type)
The goal of this project was to research the topic of internalization within the context of portal applications, and to provide MetLife with a framework upon which to enhance existing or build new applications. To this end, we have designed and developed a sample product catalog portal application that has been deployed to IBM’s WebSphere Portal v5.1, and can consume dynamic content from a multitude of data sources. For the purposes of the demonstration, the application will retrieve information from a DB2 DBMS and an Ariba System. Given the locale (based on a registered user’s preferences or O/S settings) and device type information from the HTTP request header, the portal application renders the content in the appropriate language (US English, Spanish, or Chinese) and markup (html or wml). A BlackBerry simulator has been installed to demonstrate the rendering of the WML content.
One of the challenges in Internationalization is language translation. Automatic translation of content from one language to another is appropriate only to certain kinds of data. For most data that is tone/context sensitive, manual translation of data will be required until automatic translation technology improves. Therefore, we have proposed the use of multiple database instances that are pre-populated to store the content in the languages that MetLife will support for the particular portal application, and have used this same approach during the development of the prototype application.