Post Job Free

Resume

Sign in

Sql Server Design

Location:
Columbus, OH
Posted:
September 21, 2015

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

*+ years of experience in the design and development of software Web-based applications.

Extensive experience in design and development of multi-tier applications using Java, J2EE, Servlets, Spring, Hibernate, JDBC, HTML, JSP, JSP Custom tag libraries and Junit.

Expertise in SDLC model and Developing Java Applications using Object Oriented Programming (OOP) concepts and MVC architecture.

Experience in working with software processes like Agile and Waterfall process.

Experience in using various design patterns such as MVC (Model-View-Controller), Singleton, Session Facade, Factory Method, Business delegate in the development of Multi-Tier distributed Enterprise Applications.

Experience in deploying the application using Apache Tomcat.

Used testing tool Selenium Web driver for testing the application.

Configured XML files in Spring and Hibernate frameworks.

Experience in building and deploying applications using Maven and Ant-scripts.

Experience in writing PLSQL / SQL and complex SQL queries.

Used Spring JDBC (TEMPLATE) as a data access technology to interact with the database.

Proficient in using RDBMS concepts with Oracle 9i/10g, DB2 and MySQL.

Worked on the Spring Framework in integration with Hibernate ORM framework.

TECHNICAL SKILLS:

Web Technologies

JBoss, HTTPS, JSP, Servlets, JavaScript.

Documentation

MS Word, MS Excel, PowerPoint, MS Visio.

Languages/Packages

C, C++, Java/ J2EE, JDBC, XML Deployment Descriptors, PL/SQL

Frameworks

Spring framework, Hibernate.

IDE

Eclipse.

Tools

JUnit, Maven, Selenium

Operating Systems

Windows 2003/XP/Vista/ NT/XP, UNIX, Linux,

Web/App Servers

IBM WebSphere 7.0/6.0, Apache Tomcat.

RDBMS

Oracle, IBM DB2, MySQL, SQL Server 2005, MS Access.

EDUCATION: Masters of Computer Science & Bachelor of Electronics & Communication Engineering

PROFESSIONAL EXPERIENCE:

JPMorganChase, Columbus, Ohio Jan 2015 – Sep 2015

JPMorgan Chase & Co. is one of the oldest and largest financial services firm in the world. JP Morgan has global presence in Investment Banking, Asset Management, Private Banking, Private Wealth Management, and Treasury & Securities Services.

Responsibilities:

Involved in writing the Hibernate mapping configuration files for POJO’s.

Used Hibernate for Object/Relational persistence mechanism.

Involved in Configuring web.xml and spring-config.xml according to the spring framework.

Worked on the Spring Framework in integration with Hibernate ORM framework.

Designed and developed the End Points (Controllers), Business Layer, DAO Layer using Hibernate/JDBC template, using Spring IoC (Dependency Injection).

Implemented business logic in service layer as per the required functionality.

Involved in writing SQL Queries to get the data from the database.

Wrote queries for CRUD operations to update, delete, insert and remove data from the database.

Developed front – end screen using ExtJS to get and display dynamic data.

Involved in writing the JUnit test cases using Mockito framework for server side layers to test the functionality.

PROFESSIONAL EXPERIENCE:

Medical Clinic Tracking System, Jan 2014 – Dec 2014

Texas A & M University.

Responsibilities:

Maintained a record of the patient analysis.

Involved in the analysis specification, design, implementation and testing phases for the project and project was developed using JDBC.

Implemented Singleton to access DAO, DTO design pattern.

Reviewed code and used OO design concepts, also handled exception handling.

Developed user interfaces using servlets, JSP Tag Libraries and HTML.

Involved in the analysis specification, design, implementation and testing phases of Software Development Life Cycle (SDLC).

Implemented several design patterns such as Singleton to access DAO, Business Delegate and Session Façade.

Developed Code based on incremental iterative releases using an Agile process (Scrum).

Implemented Model View Controller (MVC) architecture using Spring framework at the Web tier level to isolate each layer of the application to avoid the complexity of integration and ease of maintenance.

Also used Spring Framework for Dependency injection and integrated with Hibernate.

Developed user interfaces using JSP, JSP Tag Libraries and HTML.

Implemented server-side business components using Session Beans.

SQL Server 2005 database was used for Stored Procedures in the application.

Environment:

Java 1.6, Agile Methodology, Servlet, JSP, Spring framework, Web Service, SOAP, WSDL, XML, Hibernate, PL/SQL, SQL Server 2005.

HCL Technologies, Chennai May 2012 – Aug 2013

Java/JEE Developer

Responsibilities:

Implemented several design patterns such as Singleton to access DAO, Business Delegate and Session Façade.

Analyzed "What if" scenarios and exceptional conditions and made recommendations to fill the gaps identified in the functional specs and detailed design.

Reviewed code and encouraged developers to use OO design concepts, best practices, exception handling.

Developed Code based on incremental iterative releases using an Agile process (Scrum).

Implemented Struts Model View Controller (MVC) architecture to isolate each layer.

Created Action Classes which route submittals to appropriate components and render retrieved information.

Implemented server-side business components using Session Beans.

SQL Server 2005 database was used for Stored Procedures in the application.

Implemented Persistence layer using Hibernate to interact with the Oracle 10g database.

Used IBM Websphere Application Server 7 for deploying various components of application.

Increased the number of JUnit tests to improve the overall quality of the Java/J2EE based applications.

Environment:

Java 1.6, Agile Methodology, Servlet, JSP, Spring framework, XML, Hibernate, PL/SQL, SQL Server 2005, IBM WebSphere Application Server 7.



Contact this candidate