2006 - Senior Software Engineer

Senior Software Engineer at Sogeti USA (Procter & Gamble)

Procter & Gamble (Material Classification)

Project Description Worked as a key developer for Material Classification tool. Material Classification is an award winning cost innovation tool developed at P&G. I am one of the key developers in realizing this goal. As a member of the team I participated in the complete life cycle of project from project analysis, design, implementation, unit/integration testing, deployment and maintaining current version.

Accomplishments (MC 1.0) Developed key JSP pages with underlying functionalities which included Data retrieved from DAO. Implemented brand new technology called AJAX (Asynchronous XML http request using JavaScript) for converting a huge data driven page that needed to be edited like a simple excel sheet. Implemented Ajax for “auto fill” of search page input items based on the user roles. (Avoiding page refresh). Consistent look and feel was included to all the tables by using CSS, HTML and also column span. Created and used application layer hash maps whenever necessary to improve the performance and reduce the unnecessary database access. I implemented more than 50 functions which performed different unique tasks keeping a close watch on the connection management, and other performance improvements. Active involvement in Oracle Database development for the project by adding and configuring new tables, indexes, sequences, procedures, triggers and views.

Accomplishments (MC 1.1)

Implemented Ajax for “auto complete” of the text field input in the reports page. Incorporated pagination using JSP tag library for large data driven pages. A new PL/SQL procedure was written to automate the picklist update process. Window freeze on certain columns was added to prevent them from scrolling outside the focus of user view. Created Data Export functionality to save the data collected to an excel file using POI library.

Project Technologies

AJAX – XMLHttpRequest using JavaScript, DAO, JSP, Servlets, JRun4, Oracle, CVS, XML, XSU (XML Query Language), JavaScript, MySQL.