Customer Service Sql Server

Rutvij Bhatt

Cell: 201-***-****

Email: *************@*****.***

Address: **** ******** ****, ***********, **

Professional Synopsis :

* ***** ** ** ********** in Full Development Life Cycle and maintenance projects using Java and J2EE technologies.

Excellent exposure in all the phases of the software development life cycle ranging from Requirement analysis, Design, Development and Deployment.

Expert in Agile Scrum methodology.

Involvement in UML design generation using Rational Rose.

Proficient with frameworks like Spring, Struts, Hibernate and iBATIS.

Knowledge of developing web based applications using web and application servers like Apache Tomcat, JBoss, Websphere and Weblogic.

Experience in working with IDEs such as Eclipse, NetBeans, Spring IDE and RAD

Skilled in Core Java, JNDI and XML.

Expertise on SOAP and RESTful Web Services using xml tools like Apache Axis, SOAP UI and JAX API.

Understanding in Spring MVC, MVC (Model View Controller) MODEL 2 architecture using Struts Framework and various J2EE Design patterns.

Good hands on with SQL, Oracle, SQL Server and MySQL.

Familiar with Savvion business process manager and capable to design and develop BPM process templates.

Quick to learn and possess excellent communication, interpersonal and analytical skills.

Technical Skills:

Languages & Scripting

: Java, JSP 2.0, JSTL, Servlets 2.4/2.5, Spring Framework, Struts 2, XML,

Apache Axis, Java Script, HTML, Java Script, Ant, Maven, XML, XSL, XSLT, CSS.

Technologies

: J2EE, OOAD, UML, SOAP & RESTful Web Services, Hibernate 3.x,

iBATIS, Savvion BPM

Databases

: Oracle 8i/9i/10g/11g, MySql, SQL Server

Server Technologies

: Apache Tomcat 6.x, JBoss, Websphere 4.0/5.5/7.0, Weblogic 9.x/10.x

GUI’s

: Spring IDE, eclipse 3.4/3.5/3.6, RAD 6.0, WSAD, Oracle JDeveloper, GWT,

Savvion Studio Designer

Tools

: Rational Rose, SQL Developer, TOAD, SOAP UI, CVS, RTC, Microsoft Visio,

Microsoft Project

Operating Systems

: Unix, Windows XP, Windows NT, Linux

Experience:

Bank of America, Newark, DE [Mar 2012 – Till Date]

Role: Technical lead

Description:

Integrated Common Decision Platform (ICDP) is an application to integrate different decision systems to single platform. It helps analyst to take various credit request decisions by integrating different existing systems and providing all needful information in same platform. It manages small business and consumer, existing and acquisition credit requests decisions. Project is divided in four generations; Gen-1 focuses on small business, Gen-2 focuses on consumer existing credit cards, Gen-3 focuses on consumer card acquisition and Gen-4 on consumer finance personal loan.

Environment: Java, Websphere 7.0.0.11, Oracle 11g, Savvion BPM, Savvion Studio Designer, Eclipse, RTC, Ibatis, javascript, AJAX, JSON, Axis2, Apache Log4j, Junit 4, Jenkins, JMockit, Code Collaborator, SonarQube.

Responsibilities:

Project develops under Agile Scrum methodology.

As a technical lead, involved in story grooming sessions to understand business requirements. Also Participated in sprint planning sessions to design and plan development work.

Creation of Class and Sequence Diagram using UML tool Rational Rose for the use cases.

Designed and developed business process templates using Studio Designer and Eclipse.

Used ORM tool iBatis to integrate database layer with DAO layer.

Worked on database Stored Procedures. Used Oracle object types and collection types for better performance.

Exposed and consumed SOAP and REST web Services using Apache Axis2 and JAX API.

Created customized exception handling and Log4j logging framework.

UI development using JSP, Javascript, JSON and AJAX.

Unit testing through local SBM and WAS servers and Junit test cases.

Used JMockit to develop Junit testing framework.

Established code quality standards through SonarQube and CodeCollaborator.

Used RTC and StarTeam as source control tools.

Tracfone Wireless, Miami, FL [Oct 2010 – Mar 2012]

Role: Software analyst

Description:

This application is mainly designed for Customer Service (Call Center) for Tracfone. It supports activation of new phone handsets, deactivation of phones, Case management or Tickets for customer problems and any other technical problems for customer. It also has administrator modules for ticket management and scripts. For tickets administrator can create templates by various combination of ticket types and titles. Escalation rules and priority can be defined using the same module.

Environment: Spring Framework, Java, Custom tag library, JSTL, JSP, JavaScript, HTML, Hibernate, Weblogic 8.1, JUnit, Rational Rose, Maven scripts, Oracle 9.i.

Responsibilities:

Involved in Requirement analysis and Use Case creation.

Architecture was based on Spring MVC.

Design Pattern Used : Command, Singleton, Value Object, Factory, Abstract Factory, DAO

Creation of Class and Sequence Diagram using UML tool Rational Rose.

Processing of data into Oracle database has been taken care by DAO.

Creation of common classes and components in Java (POJO), controllers, bean factories with IOC using Spring.

Creation of Custom tag libraries, JSP files using JSTL and custom tag library.

Unit testing has been done by JUnit test classes.

Used Hibernate ORM tool to integrate business layer with DAO layer and accessed the Oracle 9.i database using Criteria API.

Involved in writing SQL queries creation to access, insert and update data in database.

Oracle Reports Server has been used for generating various online reports for customer service.

Eclipse has been used for the development throughout entire project.

ICICI Online Banking, Gujarat (India) [Mar 2008 – Jul 2009]

Role: Jr Software Developer

Description: The Objective of the project is to enable the personal banking system available around the clock for the whole year. This system eases the maintenance of various accounts including credit-cards, loans, and fixed deposits. The system offers automatic bill payments, bill scheduling, fund transfers and automatic notifications through emails.

Environment: J2EE, Java, Struts, JSP, JNDI, Clear Case, SOAP, WSDL, UDDI, ANT, JavaScript, Rational Rose, WSAD, UNIX.

Responsibilities:

Involved in the Requirements collection & Analysis from the business team.

Created the design documents with use case diagram, class diagrams and sequence diagrams using Rational Rose.

Implemented the MVC architecture using Apache Struts Framework.

Implemented Action Classes and server side validations for account activity, payment history and Transactions.

Implemented views using Struts tags, JSTL and EL.

Implemented Tiles Framework for the views layout.

Worked with various java patterns such as Service Locater and Factory Pattern at the business layer for effective object behaviors.

Worked on the JAVA Collections API for handling the data objects between the business layers and the front end.

Developed Unit test cases using JUnit.

Developed ant scripts and developed builds using Apache ANT.

Used Clear Case for source code maintenance.

Education

Master of Science in Computer Science from Fairleigh Dickinson University, NJ

Bachelor of Engineering in IT from AD Patel Institute of Technology, Gujarat - India

Contact this candidate