1. Lead a team of five to design, develop and verify the functionality of a subsystem. This was a part of a large project with 4 subsystems interacting with each other. The purpose of this subsystem was to accept insert/update requests from one client, validate and process them. Query requests from another client were also validated and processed. The client software was written in PRO*C and Oracle 8i was the database. The functionality of this subsystem also comprised of communication between 2 remote databases.
2. Logical and Physical Data modeling on a project. This involved analysing the requirements, designing the logical model, normalizing it and arriving at the physical model. ErWin was used for Data modeling.
3. Performance tuning of existing software to greatly improve performance. This involved analysing existing code and making changes to it, datamodel changes and database tuning to achieve the desired results.
4. GUI application to simulate a Turing Machine