Responsibilities:
- Involve in the analysis, design, and development and testing phases of Software development life cycle (SDLC).
- Develop the data access layer in java involving complex SQL and stored procedures.
- Involved in Requirement Gatherings, Creating data model and design documents.
- Evaluate complex requirements and implement a reusable ‘Database+Java’ combined solution.
- Use the advanced database design techniques including query tuning and optimizations for the best performance of the application.
- Writing stored procedures in Oracle 11g, SQL Server 2005/2008 and PostgreSQL.
- Writing Unit test cases using JUNIT testing framework.
- Writing functional specifications and convey the concepts into detailed design documents.
- Hands on Experience on SQL Developer, SQL server management studio, pgAdmin.
- Developed the Model objects, hibernate mappings, DAO and controllers’ classes for all the relevant categories of input data displayed on the interface
- Use Apache Lucene, an information retrieval software library in Java for CAPPS search.
- Update the developer’s guide with all the work done for each version of CAPPS.
Environment: Java 1.6, Eclipse, Hibernate, Spring IOC, Web Services, HTML, Java Script, CSS, JQuery, XML, Log4j, Oracle 11g, SQL Server 2005, PostgreSQL, PL/ SQL, Junit, IBM Websphere.