Sql Server Management

Soma

Phone: 281-***-****

Email ID: acoikh@r.postjobfree.com

Note : Available only for NJ / NY Location on Contract (C2C) jobs.

Please add my Email ID: acoikh@r.postjobfree.com in your distribution list.

Professional Summary:

. 7 years of strong expertise in the Information Technology Industry.

Sound experience in the Analysis, Design, Development, Coding and Testing

under Windows, Unix, Sun-Solaris, Client Server environment in various

domains like Pharmaceutical, Telecom and Insurance.

. Experienced in Java, Servlets, Spring, JSP, Log 4J, Ant, Web Services,

XML, XSLT, SOAP, REST, Java Beans, Apache Tomcat, Glassfish,

JBoss/WildFly, Eclipse, Dreamweaver, Oracle, SQL Server, MySQL, SQL,

PL/SQL, JDBC/ODBC, HTML, DHTML, Java Script.

. Hands on project management experience using the methodologies Scrum,

Sprint, Agile. Excellent Technical, Communication, Analytical.

. Software Life Cycle activities on Java, J2EE, Servlets, Spring,

Hibernate, XML, JSP applications.

. Develop applications on MVC, MVC2, Factory Pattern, Singleton and Meta

data driven architectures. Analyze system requirements to select design

patterns. Used Ant for Build Scripts.

. Extensively used the management techniques using methodologies Sprint,

Scrum, Agile to develop the project.

. Database development using Oracle, SQL Server, MySQL, JDBC, PL/SQL.

. Web Design using JSP, Ajax, HTML, CSS, Java Script.

. XML parsing using Apache distributions and XSLT. Point to point data

transfer using XML tree.

. Experience on Design Patterns, UML, Data modeling and schema diagrams.

. Experience on JUnit for unit testing, and implement code reviews.

. Deployment of applications on Unix Sun Solaris, Linux and Windows, and

Troubleshooting.

. Experience with servers such as Apache Tomcat, JBoss/WildFly, Glassfish.

. Migration of data between different databases Oracle, SQL Server.

. Experience in using tools such as Eclipse, Net Beans, IntellijIDEA,

Dreamweaver, MS SQL Server Management Studio, SQL Developer, Squirrel,

MySQLYog.

. Involved with teamwork to achieve the common goals, achieve project

milestones.

Education:

Bachelor of Engineering, CSVT, Bhilai

Technical Skills:

Languages & APIs Java, J2EE, JSP, Servlet, JDBC, JNDI

Web Technologies XML (JAXB,JAXP, Xerces, DOM/SAX, DTD/Schema),

XPATH, XQUERY, XSLT (Xalan), OFX, SGML, HTML.

XHTML, DHTML and IFrame, Java Script, AJAX, CSS

Web Services: Java WSDP, SOAP, WSDL and UDDI.

Frameworks Log4j, Hibernate, Spring, Maven.

Databases Oracle, MS SQL Server 2005/2008, MySQL, [PL/ SQL, SQL]

Application Servers Glassfish, JBoss

Web Servers Tomcat and Apache Web Servers

Source Code Control CVS, Tortoise-SVN

Operating System Windows NT/2000/XP, Sun Solaris, Unix

RDBMS & Tools: Oracle, DB2, Informix, MS SQL Server Management Studio,

SQL Developer, MySQL, Toad, Erwin and PL/SQL.

IDEs & Application Software: Eclipse, Net Beans, IntellijIDEA, Dreamweaver,

MS SQL Server Management Studio, WebSphere Studio

Application Developer (WSAD) 5.1, SQL Developer,

Squirrel, MySQLYog, Putty, FrontPage, Crystal Report

Writer and MS Project.

Methodologies: Sprint, Scrum, Agile project management methodologies

PROFESSIONAL EXPERIENCE

LABVANTAGE SOLUTIONS Inc, Somerset NJ Feb 2014 till

date

Sr. Java Developer

LABVANTAGE solutions offer a comprehensive portfolio of products and

services for the laboratory, including LIMS (Laboratory Information

Management), quality electronic laboratory notebook (ELN), and business

intelligence.

Responsibilities:

. Strong experience in using Java/J2EE Design Patterns, Struts and JSF

Framework.

. Experience in XML over HTTP Messaging using XML and J2EE technologies.

. Good experience with implementing multithreading socket servers.

. Expertise in RDBMS using Oracle, DB2, Informix, MS SQL Server, SQL,

PL/SQL, Database Objects and Hibernate.

. Experience in XML-based Web Services (JAX Pack, SOAP, UDDI, and WSDL).

. Proactive, independent, team player and hard working individual with

excellent communication skills.

. Create MVC architecture using Spring, JSP, Servlets and Java.

. Database connection pooling using JDBC.

. Written SQL, PL SQL, HQL queries, Implemented Transaction management.

. Deploy applications on Websphere and JBoss, Migrated from IBM Websphere

to JBoss.

. Developed Storage Location QC module, using JQuery for frontend, and AJAX

to services classes for data fetching.

. Developed Jasper Report to show QC result values using Crosstab and list.

. Implemented ANT script to build deliveries for Master data.

. Web pages are developed using JSP, HTML, and JavaScript.

. Used Oracle Procedures, Triggers, Functions, and Packages.

. Used Maven to build and unit test applications.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Tools Used: Eclipse, IntellijIDEA, SQL Developer, SQL Server Management

Studio, SQL Server Business Intelligence Development Studio, iReport.

BioM rieux, Durham, NC June 2013 to Jan

2014

Sr. Java developer

Responsibilities:

. Determine client needs, strategically provide solutions and enhance

identity development.

. Visiting client sides to provide support and solution during requirement

analysis, system designing and user acceptance testing.

. Involved in Design, Requirements, Development, Testing.

. Database connection pooling using JDBC.

. Written SQL, PL SQL, HQL queries, Implemented Transaction management.

. Deploy applications on Websphere and JBoss, Migrated from IBM Websphere

to JBoss.

. Developed Storage Location QC module, using JQuery for frontend, and ajax

to services classes for data fetching.

. Developed Jasper Report to show QC result values using Crosstab and list.

. Implemented ANT script to build deliveries for Master data.

. Web pages are developed using JSP, HTML, and JavaScript.

. Used Oracle Procedures, Triggers, Functions, and Packages.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Tools Used: Eclipse, IntellijIDEA, SQL Developer, SQL Server Management

Studio, SQL Server Business Intelligence Development Studio, iReport.

Response Genetics Inc., CA

Dec 2012 to June 2013

Java Developer

Responsibilities:

. Visiting client sides to provide support and solution during requirement

analysis, system designing and user acceptance testing.

. Designed and implemented UI layer using Struts MVC, Struts Forms, JSP,

Java Script, XML, XHTML, XSL, XSLT and business logic using Servlets,

JSP and J2EE framework.

. Prepared queries using DB2 control center and Toad.

. Involved in coding of JSP pages using CSS and HTML for the

presentation of data on the View layer in MVC architecture.

. Responsible for Websphere Installation, Database installation, and

software maintenance.

. Developed custom tags extended from struts tags to enable the

highlighting of all the invalid input fields if validation errors

occur.

. Developed various documents within the application using XML, and used

XSLT, JSTL for transformation.

. Integrated LOG4J framework into the Application.

. Design patterns like Bridge, Session Facade, Business Delegate, Value

Object etc were implemented.

. Involved in different applications testing including Unit testing,

integrated testing and production testing.

. Wrote DB2 SQL queries and Stored Procedure for accessing, manipulating

and updating DB2 database

. Used javascript libraries like JQuery and Prototype for creating

animation effects and making AJAX request for getting data and

updating database.

. Wrote Oracle SQL queries and Stored Procedure for accessing,

manipulating and updating Oracle 10g database.

. Deploy applications on Websphere and JBoss, Migrated from IBM Websphere

to JBoss.

. Developed Storage Location QC module, using JQuery for frontend, and ajax

to services classes for data fetching.

. Developed Jasper Report to show QC result values using Crosstab and list.

. Implemented ANT script to build deliveries for Master data.

. Web pages are developed using JSP, HTML, and JavaScript.

. Used Oracle Procedures, Triggers, Functions, and Packages.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Tools Used: Eclipse, IntellijIDEA, SQL Developer, SQL Server Management

Studio, SQL Server Business Intelligence Development Studio, iReport.

Horsehead Holding Corp., PA

Oct 2011 to Nov 2012

Java Developer

Responsibilities:

. Meetings with business teams to gather requirements and created software

design specification (SDS) for the project using UML diagrams.

. Developed file synchronization application in core java version 1.6 and

spring framework.

. Used MKS Toolkit to run shell scripts on windows systems for application

unit testing.

. Improved the message processing by generating alerts for the unsuccessful

processing of events from Queues defined in Weblogic.

. Design and created tables in DB2 for the application and used IBM Data

Studio for database access using DML statements.

. Used Windows, Linux and UNIX platform for application installation and

testing.

. Developed java based applications using IntellijIDEA IDE AND Eclipse.

. Developed Audit application backend using session beans, JAXB and JAXP.

. Developed .NET binary files reading and creation mechanism from HTTP

source with Web Authentication.

. Used XPATH, XQUERY and XSLT for XML document processing.

. Used Maven to build and unit test applications.

. Used Reflection to access Linux and UNIX platform.

. Used Mercury Test Director for defects accessing and creation.

. Used Clear Case for source control and managed defects by creating

branches.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Tools Used: Eclipse, IntellijIDEA, SQL Developer, SQL Server Management

Studio, SQL Server Business Intelligence Development Studio, iReport.

Indware Technologies, Kolkata, India

Jan 2011 to Sep 2011

Java developer

PayMan is a Payroll product made by Indware Technologies. It's a web based

portal service.

Responsibilities:

. Designed and Developed Permission and Employee Module using JSP, Servlets

and JDBC.

. Involved in screen designs, SRS (Software Requirement Specification) and

documentation of screens.

. Developed web pages using JSPs and JSTL to help end user make online

submission of rebates.

. Development of view through XML using XSL and DOM parser

. Performed Struts validation and JavaScript validation depending on

requirements.

. Implemented Tiles in Struts Framework in order to avoid code redundancy

for developing user screens that contain same Headers and Footers

. Used XML for several configuration tasks.

. Created Web Application using STRUTS framework, JSP, Servlets.

. Developed Stored Procedures, Triggers for larger transactions.

. Prepared ANT scripts to handle code Rolls to various environments.

. Prepared Test cases and Participated in Peer and System Testing.

. Coordinated User Acceptance Testing.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Technologies: Struts, MSSqlServer, XML, JavaScript, AJAX, jQuery, HTML,

CSS.

Tools Used: Eclipse, SQL Server Management Studio, Dreamweaver.

Indware Technologies, India Jan

2008- Dec 2010

Java Developer

Indware Technologies is asked to build a website and software for

swarthakrupayan Pvt. Ltd.

Responsibilities:

. Designed User Interfaces using JSP, Servlets, and HTML. Developed JSP

custom Tag Libraries.

. Implemented MVC Architecture using Struts Framework. Implemented

validations using Validation Framework in Struts.

. Used Data Access Object, Service Locator, Business Delegate and Session

Fa ade design patterns to simplify the interface to the subsystem.

. Implemented Business Logic using Stateless Session Beans.

. Implemented best practices of Java/J2EE to minimize the unnecessary

object creation, minimize database calls, and optimize queries to get

better performance of application.

. Responsible for Code Review and Testing.

. Worked for the web site and web user panel using PHP and the calculation

gateway was made in J2EE.

. Implemented the Master module login and new joining Dynamic tree.

. Tree manipulation and tree expansion. Report section: Tree view for

Binary income, royalty income, month bonus etc.

. Implemented the Pi charts.

Environment: Java 5/6, Spring, JSP, Servlets, XML, HTML, DHTML, CSS, Java

Script, AJAX, Oracle, SQL, PL/SQL, JDBC, Java Beans, JUnit, UML,

Subversion, Websphere 7, JBoss 5, Windows, Unix JAVA 6, Spring 3.0,

Hibernet 3.0, Maven 2, SVN, JBoss 5.1, Windows, Linux, MSSqlServer 2008.

Technologies: JSP, Servlet, MySQL 5, XML, JavaScript, AJAX, jQuery, HTML,

CSS.

Tools Used: Eclipse, MySQLyog, Dreamweaver.

Contact this candidate