Sql Server Developer/sql Server Dba Resume
Santa Clara, CA
SUMMARY
- I have over 8 years of experience in building implementing Java/J2EE projects, working through Analysis, Design, Development, Testing, Implementation in Client/Server and web based monolithic application and n - tier architecture systems.
- Experience in designing and developing web based enterprise applications using J2EE technologies like Servlets, JSP, EJB/JPA, JSF, Ajax, Hibernate, Spring, JDBC, JNDI, JMS, Java Beans, JAXB, SAX/DOM, Web services, XML, XMLBeans and UML.
- Proficient in Spring framework and hands on experience of implementing Spring MVC, Spring AOP, Spring web flow, Spring security.
- Proficient in ORM (Object Relational Mapping) Tools like Hibernate.
- Strong Experience working with Databases such as Oracle, MySQL, DB2, MongoDB.
- Developed stored procedures and queries using SQL.
- Good Familiar with Taglibs and other directives to provide functionality to the JSP pages.
- Experience in client side designing and validations using HTML, Java Script, jQuery, AngularJS.
- Extensive knowledge of all the Object-Oriented Programming concepts (Abstraction, Inheritance, Encapsulation and Polymorphism)
- Very good Knowledge of Agile Software Development Methodology.
- Very good Knowledge in design patterns including Front Controller, Data Access Object, Session Façade, Business Delegate, Service Locator, MVC, Data Transfer Object and Singleton.
- Expertise in Object Oriented Analysis and Design (OOAD) using Unified Modeling Language (UML) by using Rational Rose.
- Good knowledge on functional style of programming using Java 8 Lambda Expressions.
- Extensively worked with Web Services using SOAP, REST and also have good knowledge on OAuth.
- Experienced in the functional usage and deployment of web applications in JBoss, WebLogic, WebSphere and Apache Tomcat.
- Extensive experience in Eclipse IDE, NetBeans and also worked with Spring STS.
- Involved in all phases of Software Development Life Cycle (SDLC) including Requirements gathering, Analysis, Design, Reviews, Coding, Unit and Integration Testing.
- Used Log4J for enabling runtime logging.
- Good knowledge with versioning tools like CVS, SVM and GIT.
- I am a true polyglot with ability to learn and adapt quickly to new environments and emerging new technologies.
- Self-motivated and able to work in challenging environment. A team player with good communication and interpersonal skill
TECHNICAL SKILLS
Languages: Java, C, C++, SQL, PL/SQL, UML, XML.
Web Technologies: JSP, Servlets, JNDI, JDBC, JSTL, JMS, JPA, EJB, Web Services, SOAP, WSDL, JAX-RS, HTML, CSS, Java Beans, JavaScript, AngularJS, JQuery, Bootstrap, AJAX, Spark.
IDE & Editor: NetBeans IDE, Eclipse IDE, Spring STS, Sublime Text, Atom.
Application Servers: Apache Tomcat, WildFly, Glassfish.
Frameworks: Struts, Spring (Dependency Injection, Spring MVC, Spring Core, Spring Context, Spring AOP, Spring DAO, Spring IOC, Spring Security), Hibernate, Log4j, Activiti BPMN2.
Tools: Maven,Jenkins.
Database: Oracle, MySQL, SQL, DB2, HSQL.
Design Patterns: MVC, Singleton, Business Delegate, Service Locator, Session Facade, DTO, DAO, Factory Pattern etc…
Operating Systems: Windows 2000, XP, Windows7/8/10, Mac OS, Unix, Linux.
Version Controls: Liquibase, SVN, GIT, CVS.
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Java Developer
Responsibilities:
- Designed, developed, debugged and tested the web based application using the J2EE architecture.
- Implemented in Agile Scrum.
- Worked closely with the business team to get the clarification on requirements.
- Developed Restful Web Services as End point to share the data using JSON as messaging medium.
- Converted JSON to Java objects as part of consuming Restful Web services.
- Used Spring framework to implement MVC design pattern.
- Adapted various design patterns like Spring MVC, Data Transfer Object (DTO'S), Data Access Objects (DAO's)
- Developed SQL, PL/SQL and Stored Procedures on MySQL.
- Implemented a Test Management System using SQL Stored Procedures and Shell scripts to automatically create Test Data.
- Extensively used Hibernate in data access layer to access and update information in the database.
- Used Spring Framework for Dependency injection and integrated with the Hibernate.
- Used different web technologies like CSS 3, HTML 5 and Angular JS to create single page web Application.
- Implemented client side data validations using JavaScript, jQuery.
- Used Maven for the build scripts.
- Implemented Log4j for logging purpose in the application.
- Used GIT and Liquibase for version management.
- Developed & deployed the application in on Tomcat Application Server and Supported the Production Releases.
- Used Markdown for application documentation.
Environment: JAVA, JDK 1.8, J2EE, Hibernate 3.6, Spring MVC, Maven, JDBC, Restful, jQuery, Angular JS, JavaScript, GIT, Liquibase, JUnit, Tomcat Application Server, MySQL, Log4J.
Confidential, Phoenix, AZ
Java Developer
Responsibilities:
- Design modifications or code implementation and test criteria for the projects and releases.
- Implemented the application using Restful Web services, spring data rest, spring data JPA and Hibernate.
- Used the Restful Web services for all the business components to communicate with each other.
- Developed components of REST web services end to end, using different Annotations with clear understanding on PUT, GET, POST and DELETE operations.
- Used Rest Client Tool extensively to test the Web services with different possibilities of input parameters in the JSON Request and analyzed the JSON Responses.
- Developed Web services to allow communication between the applications using REST Web services
- Used Spring ORM to integrate Spring Framework with hibernate.
- Use spring repositories and implement Spring DTO to fetch the data from the database and represent on client-side.
- Used Spring AOP module to handle transaction management services for objects in Spring-based application.
- Used AngularJS as the development framework to build a single-page application
- Used Spring Web MVC framework for the applying MVC Implementation to the web application.
- Developing Hibernate Configuration files for Oracle 11g and MongoDB.
- Developed & deployed the application in on JBoss Application Server and Supported the Production Releases.
- Leveraged angular resources for all data access, encapsulating URLs and standardizing data access interfaces.
- Develop front end view using HTML5, JSP, JavaScript, AngularJS and CSS3.
Environment: HTML5, CSS3, Java 7, Spring Security 3.1, AngularJS, spring ORM, Spring Data JPA, Spring Rest, SVN, NetBeans, Oracle 11g, MongoDB.
Confidential, Santa Clara, CA
JAVA Developer
Responsibilities:
- Involved in writing the presentation layer in Java Server Pages (JSP), agile
- Strong understanding of the software development cycle, specifically Agile/SCRUM
- Responsible for coding SQL Statements Stored procedures for back end communication using JDBC.
- Developed an API to write XML documents from a database. Utilized XML and XSL
- Transformation for dynamic web-content and database connectivity.
- Coded different deployment descriptors using XML. Generated Jar files are deployed on Apache Tomcat Server.
- Involved in the development of presentation layer and GUI framework in JSP. Client Side validations were done using JavaScript.
- Used Eclipse Kepler as Integrated Development Environment (IDE).
- Involved in code reviews and mentored the team in resolving issues.
- Integrated the codes of neural network training for general use with annotation.
- Handled Java multi-threading part in back-end component, one thread will be running for each user, which serves that user.
- Implemented complex back-end component to get the count in no time against large size database using Java multi-threading.
- Participated in weekly design reviews and walkthroughs with project manager and development teams.
- Created weblog layout in HTML, CSS based on an original design according to client's branding needs.
- Used MyBatis 3.0 in data access layer to access, update and persist information in the database.
- Used MyBatis and worked extensively on Dynamic SQL to query from the database and also wrote MyBatis mapping definitions for the persistent layer.
- Developed the User Role Mapping Module using JQuery and REST.
- Provided technical guidance to business analysts, gather the requirements and convert them into technical specifications/artifacts for developers to start.
- Developed Schema & Catalog loading solutions for GSA Advantage Using Hibernate O/R Mapping
- Implemented data access tier using Spring DA
- Used Web services - WSDL and SOAP for getting required information from third party
- Developed Web Services using Restful with Spring MVC and developed DTDs, XSD schemas for XML (parsing, processing, and design) to communicate with Active Directory application using Restful API
- Designed & Developed intranet applications for catalog maintenance using EJB3, JPA, Servlets, AJAX technologies hosted on JBoss Application server.
- Develop aspect to modularize crosscutting concerns like caching, logging and performance monitoring Developed Order Processing using XML and OASIS UBL.
- Generate Excel Reports in Java using Open Source solutions like JXLS and JExcel API.
- Generate dynamic Purchase Order PDF using Adobe PDF templates and FDF API.
- Communicate effectively with executive stakeholders in gathering requirements and ensuring project success.
- Maintained versioning to merge code, check in and checkout the project code using GIT.
- Participate in Requirement, Design, Development and Deployment sessions.
Environment: Java, J2EE, Servlets, Spring DAO,MyBatis, JSP, JDBC, JNDI, XML, JQuery, RESTful, XSL,WSDL,SOAP, HTML/DHTML, JMS, AJAX, JPA, Eclipse, Unit and SQL.
Confidential
SQL Server Developer/SQL Server DBA
Responsibilities:
- Worked in Agile methodology environment including Test Driven Development with Continuous Integration/Delivery.
- Actively participated in the daily SCRUM meetings to produce quality deliverables within time.
- Implemented spring IOC to resolve dependency injection.
- Developed the entire application implementing MVC Architecture integrating Hibernate and spring frameworks.
- Involved in building service and repository layers
- Used Maven to build, run and create JARs and WAR files among other uses.
- Implemented Hibernate in the data access object(DAO) layer to access and update information in the Oracle11g Database
- Wrote test cases in JUnit for unit testing of classes.
- Implemented Service Oriented Architecture (SOA) using JMS for sending and receiving messages while creating web services.
- Created dynamic HTML page using AngularJS, and AJAX to create interactive front-end GUI.
- Consumed and leveraged SOAP over HTTP (XML Schema XSD) and Restful web services in Services layer.
- Involved in coding, maintaining, and administering Project artifact deployed on a JBoss Application Server.
- Used Eclipse IDE for developing code modules in the development environment
- Implemented the logging mechanism using log4j framework
- Used SVN version control to track and maintain the different version of the project.
- Worked on a variety of defects to stabilize application.
Environment: Java/J2EE 1.6, Spring 3.0, Hibernate 3.5.6-Final, JBoss Application Server, SOAP, Restful, Unix, SQL Server (R2 - Enterprise Edition), HTML, CSS, AJAX, AngularJS, Eclipse, Maven 3.0, JUnit 3.8, Log4j, SVN.
Confidential
J2EE Developer
Responsibilities:
- Interacted with the Business/Technical Architect to obtain the specific system requirements and in understanding the functional flow.
- Involved in Analysis & Design of the system and created use cases, wireframe diagrams, class diagrams & sequence diagrams.
- Used Spring Framework for Dependency Injection and integrated with Hibernate
- Involved in J2EE coding of functionalities (JSP as View and Servlets as Controller) based on MVC pattern using Spring Framework.
- Developed the in-house i18n/l10n i18n/l10n tools using Java, Perl and XML on Windows2000/NT and Unix platform, which efficient and effectively reduce the i18n/l10n processing life cycle;
- Developed Graphical User Interfaces by using JSP, HTML, JQuery, CSS, and JavaScript.
- Used spring Object relational mapping (ORM) and hibernate for persistence in Oracle.
- Wrote XML’s to define spring web flow and spring beans.
- Wrote SQL queries for Oracle database for creating new profiles and their functionalities to support the customer assist application.
- Involved in developing test cases using JUnit testing during development mode.
- Implemented log4j for application logging and to troubleshoot issues in debug mode.
- Agile development process has been followed. Experienced with stand-up, Retrospective, Demo, Planning and Code review meetings.
Environment: Java/J2EE, Spring MVC, Servlets, JSP, JDK 1.5, REST web service, Hibernate 3.0, JQuery, Eclipse IDE, WebSphere, JUnit, log4J, Oracle 10g, ANT, XML/XSLT