· C++ Project for CIS 4100, Fall 1999:
Applied the concepts of encapsulation, inheritance and polymorphism to implement a solution to a VendingMachine class whose responsibility was to use a CreditCard object to pay for a WebCard object. To finance the time that consumers used computers for browsing the web, companies charged for computer usage with a reusable web browser card. A consumer used a vending machine by inserting a credit card in order to purchase a web card for browsing the Internet. Since the number of web cards sold was not pre-determined, I had to design a VendingMachine class that created WebCard objects dynamically. In addition to buying web cards, the consumer also used the vending machine to add additional funds to previously purchased web card. Later on, I expanded the functionality of the classes so that a vending machine could sell different kinds of electronic cards in addition to a web card. To accomplish this I used an inheritance hierarchy for different types of electronic cards.
· Database Management Systems Project for CIS 4400, Spring 2000:
Designed an Oracle database for a large cooperative apartment house, Chatham Towers. Chatham Towers, consisting of two 25-floor buildings, was interested in computerizing its systems for handling work orders. I constructed an Entity Relationship Diagram that captured the business model. I converted the E-R Diagram into a relational model and normalized the relations to BCNF (Boyce-Codd Normal Form). I implemented the relations and constraints using Oracle SQL*Plus. I also created insertion triggers and used Oracle Developer/2000 to create a menu driven application consisting of menus, forms, reports and queries.
· Client/Server Project for CIS 4670, Fall 2000:
I worked as a member of a team to design a networked trading system, which allows brokers
to place orders over the Internet and trade with each other. We used PowerBuilder 7.0 to
implement a number of classes to fulfill these responsibilities, based on the concept of
distributed computing and client/server architecture. The designed system shared a centralized
Oracle database, which resided on a remote database server. Some of the classes were integrated
into an end-user application that could place orders on the network and view reports of
any resultant trades. The application also had a report screen to display the trading
activities, such as registering orders and bids, matching and making a trade, and updating
the database. Other classes encapsulated some of the non-visual business logic such as
making trades. These classes were executed on an application server and provided a middle
tier of processing between the end-user and the database server.
· Financial Information Systems Intern, New York Stock Exchange, Fall 2000:
During the four months of my internship at the New York Stock Exchange, I had the
opportunity to work with distinguished professionals who are leaders in their fields.
One of my responsibilities was to perform daily backups of all transactions using a
powerful Unix-based Hewlett Packard workstation. I also installed RedHat Linux 6.2Pro
on several workstations and performed software upgrades, like Windows NT Service Pack
4.0 to Windows NT Service Pack 6a. I assisted the Systems Administrator in maintaining
and adding new workstations to the Local Area Network, as well as providing troubleshooting
and support to the users. I also had the opportunity to work with SAP (Systems,
Applications and Products in Data Processing) R/3, the world's largest enterprise
software company. Using the SAPGUI client, I updated the profiles of a number of
NYSE employees in the SAP database. Although updating the employee profiles was not
as challenging, getting a better understanding of the whole concept of distributed
computing and client/server architecture and most important seeing it in action,
was certainly an invaluable experience.