Sql Server Development
Resume:
SUBHASHINI MURUGAPPAN
********@*****.***
EXPERIENCE SUMMARY
. Around Seven years of experience in design, development and
implementation of Java and J2EE applications working as Software
Developer and Programmer.
. Worked in software projects and involved in all phases of SDLC lifecycle.
. Worked in SCRUM & AGILE method of software development
. Worked in the Graphical User Interface (UI) and Web Based applications.
. Experienced in System Analysis, Design & Development, Documenting and
Testing.
. Strong in Object Oriented Design and Programming.
. Experienced in Java1.5 and J2EE and Web technologies like Hibernate, JSP,
Servlets, JDBC, WebServices, HTML, CSS, JavaScript, JSF, Freemarker,
Velocity, DynamicJasper, EXTJS, REST, Dreamweaver and XML.
. Experienced working in Struts, Spring framework and MVC architecture.
. Worked with integrated development environments like Eclipse, Intellij.
. Worked with SQL Server (2000, and 2005), MySQL, DB2 database.
. Experienced working in Application and Web Servers like Tomcat and
Apache, Weblogic on Windows & Linux platforms.
. Worked in XML technologies like XSL, XSLT, XPATH, JDOM, JAXB and SAX.
. Worked with version control tools like SVN.
. Worked with bug tracking systems like Bugzilla, Jira.
. Excellent analytical and communication skills and team spirit.
. Worked in Internet & Web Based Systems, Web Site Development, Online
Marketing and Advertising Systems.
. Good experience in doing code assessments, manual & unit testing,
optimization of code & SQL queries.
LEGAL STATUS: Permanent Resident (GreenCard Holder)
EDUCATION: Bachelor of Engineering, Electrical and Electronics
Engineering, Anna University, India
Year Completed: 2005
COMPUTER KNOWLEDGE:
Web Technologies: J2EE, Hibernate, Freemarker, GWT, REST, JSTL,
Servlets, JSP, JDBC, EXTJS, JMS, DynamicJasper,
Dreamweaver and WebServices, JSF
Languages: Java 1.5, SQL, JavaScript, HTML, XML, CSS
Application Servers: J2EE application server
Modeling tools: Microsoft Visio
Tracking tools: JIRA, Confluence, Bugzilla
Web Servers: Apache Tomcat 5.5.25, Weblogic Server
IDE: Eclipse 6.0, IntelliJ IDEA 8
Database Tools: SQL Server (2000 and 2005), MySQL 5.5, DB2
Operating Systems: MS Windows XP/2000/NT/9x, Linux
Architecture/Frameworks: Spring, Hibernate, Struts,
Client/Server, MVC architecture, J2EE
Continuous Integration: Cruise Control, Hudson
Versioning Tools: Tortoise SVN subversion 1.5.4
WORK EXPERIENCE:
Solution Architect December 2012 - Present
Woodcliff Lake, NJ, USA
Online Logistics Solution:
Inland Transport logistic service provides an extra-ordinary flexible
Factory to Dealer Solution. This solution is used in different Terminals,
Vehicle processing centers & distribution centers to receive vehicle,
perform technical services, allocate dealers and do Rail/Truck delivery to
respective dealers. Solution can be used either through online web
application or by RF scanner device.
Technologies used: JDK 1.5, J2EE, Spring-MVC, Spring-ORM, Hibernate, JBDC,
JSF, JMS, SVN, DB2, Weblogic, JIRA, Rich Faces and Eclipse.
. As a member of Systems Solution team, supported IS&T functions &
Systems.
. Enhanced systems Architecture to improve usability and performance.
. Responsible for development, Maintenance and Production support for
the Inland Based application.
. Worked as Development Manager in projects to plan development
activities; provided needed guidance and assistance to onsite/offshore
team during development process.
. Designed Dashboard solution to easily view data after processing
customer's EDI files.
. Designed Email scheduler solution to schedule various reports in
Microsoft Access.
. Delivered assigned projects in timely manner and performed code review
to avoid duplication, improve performance and user experience.
. Mentored team members by contributing and sharing
technical/architectural knowledge within the team and provide guidance
in planned SDLC life cycle.
. Communicated closely and effectively with business community to ensure
that technical information, application, integration and technical
development are in agreement with the architectural model.
. Provided adequate training to Users using the application as per
technical solutions.
. Coordinated with external customers like Subaru and vendor to support
IS&T solutions & systems.
. Interacted with product owner & business team to ensure accurate
requirements are collected.
. Created requirements document, test plans, and verified
results/solutions. Helped in smoke testing the entire web platform.
. Involved in tracking all the bugs in Jira (Bug tracking system) and
SCRUM method of development.
. Involved in Integration Testing after each development Life cycle.
. Used Weblogic as web server & DB2 Server as database.
. Used Eclipse as the development tool. SVN was used as source control
tool.
Java Software Developer July 2011 - November
2012 Advertise.com CA, USA
Advertiser/Publisher Management server:
Internet facing web application with rich user interface written on
ExtJS framework and running on form of Apache Tomcat servers which allows
Advertisers to manage their online advertisements, campaigns and track
their performance through the variety of reports, allows Publishers to
integrate with provided XML feed and track their traffic and revenue
through the extensive reporting functionality, implemented as a multilayer
web application by using Spring framework best practices.
XML API:
This interface is used by the account users to access and retrieve the
required data from our system using various services. The XML API service
consists of a URL string with a set of parameters. The account users can
manage different entities such as campaigns, adgroups, advertisements,
keywords, and negative keywords by sending a request in the API service
URL. This light-weight webservice converts incoming HTTP request to XML
response using Spring-JAXB annotation that helps advertisers and publishers
to access their account data.
Bulk Upload Process:
This Bulk Upload system is designed to allow an advertiser to make a large
number of changes to a campaign via an excel file. This is primarily used
to do repetitive updates such as updating bid prices for all keywords in a
campaign, when trying to do so in the User Interface would be time
consuming. The uploaded excel file is parsed using Apache POI, then do
required validation and convert it to hibernate based objects to
create/update/delete different entities in database.
Report Generator:
This Scheduled process generates various report using DynamicJasper
reports. Jobs are scheduled to run daily/weekly/monthly to generate reports
for Internal Client Services, Advertisers which fetch data from database
and convert it to Excel/CSV format using DynamicJasper reports.
Technologies used: JDK 1.5, J2EE, Spring-MVC, Spring-ORM, Hibernate, JBDC,
JSP, JSON, EXTJS, HornetQ (JMS), SVN, MySQL, Apache Tomcat Server,
DynamicJasper, Bugzilla, Velocity, Apache POI, Spring-JAXB and Eclipse.
. Worked in the design and implementation of a creating internet based
web application system that connects advertisers and publishers to the
online advertising system.
. Developed software components using spring framework, Java & MySQL.
. Worked on performance improvement areas to improve application
response and MySQL query performance.
. Wrote generic helper classes and methods using APIs.
. Used Velocity templates to send email with different template
versions.
. Used Apache POI to parse Excel files and insert/update/delete database
records.
. Created scheduled quartz job to run different stand-alone processes in
different servers.
. Worked in implementing a Scheduled CRON job that generates different
reports across our system daily/weekly/monthly using DynamicJasper
reports.
. Wrote helper classes to monitor process list, database server
connections, slave database status as a stand-alone job.
. Worked on creating light-weight web service which takes http request
from the browser or script and convert it to XML response using JAXB
annotation based classes.
. Assisted in creating helpful QA regression test plans, and verifying
results. Helped in smoke testing the entire web platform.
. Involved in tracking all the bugs in Bugzilla (Bug tracking system)
and SCRUM method of development.
. Involved in JUnit and Integration Testing after each development Life
cycle.
. Converted detailed requirements into java processes and leveraged
industry usability standards.
. Built and Deployed Web based application, Standalone processes in
different Linux servers.
. Used Apache tomcat 5.5.25 as web server & MySQL Server as database.
. Used Eclipse as the development tool. SVN was used as source control
tool.
Software Engineer/Programmer Jan 2009 - Jan 2011 Jaz'd Markets,
Andover, MA, USA
Jaz'd B2B online platform
JAZD Markets is a comprehensive marketing as a service (MaaS) platform
company built by online marketers and B2B publishers to deliver the highest
tangible return from online marketing investment available today. As the
leading online directory driven marketing solution for B2B, JAZD is
changing the way online marketing works by aligning buyers and sellers
together in highly informative, measurable and easy to navigate
environments. JAZD partners with leading B2B publishers, industry
associations and social networks to deliver Web 2.0 enabled vertical
marketplaces.
Technologies used: JDK 1.5, J2EE, Spring, Hibernate, Freemarker, GWT, JSP,
JSTL, SVN, MySQL, HTML, Apache Tomcat Server, CSS, JavaScript, JIRA,
Confluence and IntelliJ.
Live B2B directories: http://www.jazdlifesciences.com,
http://www.jazdprocessing.com
. As Software Engineer, contributed to development of Jaz'd markets
online platform, built for online marketers and B2B publishers.
. Developed software components in Java, Freemarker, JSP, JSTL,
JavaScript, and HTML, and developed database scripts using MySQL.
. Designed and built Jaz'd core technology from the ground up. Worked in
Start-Up Environment.
. Designed and implemented a REST-ful Spring framework for all J2EE
components and web applications.
. Developed web-service API for populating Jaz'd meta-data using core
services and Hibernate persistence.
. Involved in tracking all the bugs in JIRA (Bug tracking system) and
documenting the SCRUM method of development in Confluence.
. Involved in creating the front end GUI with Freemarker templating
system & SEO friendly code.
. Involved in exposing Videos in the platform using embed code.
. Converted detailed requirements into UIs and leveraged industry
usability standards.
. Provided support to Jaz'd engineering team in production release &
monitoring logs in SSH secure shell.
. Interacted with the Sales & Marketing team and implemented their new
needs in the web platform.
. Assisted in creating helpful QA regression test plans, and verifying
results. Helped in smoke testing the entire web platform.
. Tracked click events on advertising & other links using Google
Analytics.
. Involved in JUnit and Integration Testing after each development Life
cycle.
. Worked quite a bit on Apache Lucene Solr & GWT.
. Used Apache tomcat 5.5.25 as web server.
. Used MySQL Server as database.
. Used IntelliJ IDEA as the development tool. SVN was used as source
control tool.
Software Developer Feb 2007 - November 2008 xFact Inc ., North
Andover, MA, USA
[pic][pic] xFact is a professional services firm that helps clients
define and extend their vision of progress in the Internet economy. xFact
collaborates with clients to achieve this vision through our Transparent
Technology Solutions.
SWISS IM
The Statewide Information Sharing System (SWISS) is a project designed to
electronically exchange, store and facilitate the analysis of data
maintained by public safety and law enforcement agencies throughout the
Commonwealth. Phase I of the SWISS project focuses on the exchange of
incident report data maintained in the records management systems of local,
regional and state law enforcement agencies.
Technologies used: JDK 1.5, J2EE, Tooltips, Servlets, JSP, SVN, SQL Server
2005, HTML, Apache Tomcat Server, CSS, JavaScript, Struts and Eclipse.
. Designed and implemented a web-based GUI SWISS add/edit application.
The application helps users to add, edit, view, and delete incident
report related information such as property, drugs, vehicle, address,
organization, etc.
. Designed to do a search in the application to find the incidents
reported statewide.
. Worked on performance improvement areas to improve application
response time.
. Struts framework was used to for all front-end activities.
. Defined and implemented error codes and custom exceptions.
. Defined tooltips for user based control tools like textbox, dropdowns,
etc.
. Deployed Web based application in different servers.
. Worked on user Interface design and web navigation design.
. Converted detailed requirements into UIs and leveraged industry
usability standards.
. Assisted in creating helpful test plans, and verifying results.
. Involved in Unit and Integration Testing after each development Life
cycle.
. Used Apache tomcat 5.5.25 as web server.
. Used SQL Server as database.
. Used Eclipse as the development tool. SVN was used as source control
tool.
MassGangs
The MassGangs system is a centralized repository of gang-related data that
is collected from law enforcement and criminal justice agencies throughout
the Commonwealth. MassGangs is available to over 350 agencies statewide
and serves as a centralized intelligence resource for gang information.
Members of the gang intelligence community can use MassGangs to exchange
the critical gang data necessary to fight the street gangs and criminal
organizations threatening many Massachusetts communities.
Technologies used: JDK 1.5, J2EE, YUI Library (Autocomplete), SQL Server
2005, HTML, Struts, Servlets, SVN, CSS, Apache Tomcat Server, JSP and
Eclipse
. Worked in the design and implementation of a statewide web-based gang
data management system for use by authorized local, county, state, and
federal law enforcement and criminal justice officials within the
Commonwealth.
. Developed UI & web based application to search and modify the Gang
chapter, Subject and Note related information.
. Used Yahoo User Interface Library 2.6.0 to develop autocomplete feature
in the application which provides the front-end logic for text-entry
suggestion and completion functionality.
. Defined and implemented error codes and custom exceptions.
. Developed Action, Form and Validator classes for Struts.
. Wrote generic helper classes and methods using APIs.
. Assisted in creating helpful test plans, and verifying results.
. Involved in Unit and Integration Testing after each development Life
cycle.
. Worked on user Interface design and web navigation design.
. Assisted in designing User Help Documentation.
. Deployed Web based application in different servers.
. Converted detailed requirements into UIs and leveraged industry usability
standards.
. Used Apache tomcat 5.5.25 as web server & SQL Server as database.
. Used Eclipse as the development tool. SVN was used as source control
tool.
SORIS
Sex Offender Registration and Inquiry System (SORIS) is part of the latest
technology used by police and the Massachusetts Sex Offender Registry to
both keep track of registered offenders and identify possible suspects when
a sex crime or attempted abduction of a child occurs. Its User-friendly web
application designed for the Criminal History Systems Board. The purpose of
the Sex Offender Registration and Inquiry System (SORIS) Project was to
enhance the accuracy, availability and usability of information pertaining
to sex offenders in Massachusetts.
Technologies used: JDK 1.5, J2EE, Servlets, JSP, SVN, SQL Server 2005, CSS,
HTML, Apache Tomcat Server, JavaScript, Struts and Eclipse.
. Worked in the design and implementation of a web-based system that
provides Massachusetts State Police users with the ability to search
and identify sex offenders, add and edit their demographic, contact,
registration, vehicle, and photo information in a highly efficient
manner.
. Struts framework was used to for all front-end activities.
. Developed UI application for State to search sex offenders and their
other details to view, edit, add and delete.
. Worked on performance improvement areas to improve application
response time.
. Wrote generic helper classes and methods using APIs.
. Worked on user Interface design and web navigation design.
. Converted detailed requirements into UIs and leveraged industry
usability standards.
. Deployed Web based application in different servers.
. Used Apache tomcat 5.5.25 as web server & SQL Server as database.
. Used Eclipse as the development tool. SVN was used as source control
tool.
. Involved in Unit and Integration Testing after each development Life
cycle.
MassGangs WebService DOC & MSP
MassGangs Webservice for Department of Corrections (DOC) and Massachusetts
State Police (MSP) involves creating XML Schema from and processing XML
through WebService. Processed DOC & MSP data, Status Code, Status error and
message are loaded into the database.
Technologies used: JDK 1.5, HTML, SQL Server 2005, XML, XPATH, WebService,
Microsoft Visio 7.0 and Eclipse.
. Created XML schema with user defined tags based on the data provided
by DOC & MSP.
. Developed XML document using the schema and processed XML using
webservice client.
. Worked in loading the XML processed data into SQL gang database for
particular Agency.
. Processed data from SQL database are loaded into the Massgangs system
for these two different agencies.
. Used XPATH to define the parts of the processed XML document.
. Used Microsoft Visio to explore and communicate complex business
information.
. Defined User guide Documentation for easy understanding of the whole
process.
. Used SQL Server 2005 as database.
. Used Eclipse as the development tool.
AOTCWarrant Client
Administrative Office of the Trial Court (AOTC) Warrant Client involves
creating XML Schema for AOTC Warrant and processing XML through WebService.
Processed AOTC data, Status Code, Status error and message are loaded into
the Warrant database.
Technologies used: JDK 1.5, HTML, SQL Server 2005, XML, XPATH, WebService,
Microsoft Visio 7.0 and Eclipse.
. Created XML schema with user defined tags based on the data provided
by AOTC.
. Developed XML document using the schema and processed whole XML using
webservice client.
. Worked in loading the XML processed data into SQL gang database for
particular Agency.
. Used XPATH to define the parts of the processed XML document.
. Used Microsoft Visio to explore and communicate complex business
information.
. Defined User guide Documentation for easy understanding of the whole
process.
. Used SQL Server 2005 as database.
. Used Eclipse as the development tool.
.
WDS Screen Design
Workforce Development Service (WDS) involves coming up with a basic page
design in HTML that will accommodate the elements listed in the WDS
Microsoft Visio diagram.
Technologies used: HTML and Dreamweaver
. Created screens for workforce development services using Dreamweaver.
. Developed HTML code for the screens and loaded it in Internet
Explorer.
. Interpreted Microsoft Visio diagram to develop web based standalone
screen.
. Defined User guide Documentation for easy understanding of the whole
process.
. Used Dreamweaver as a tool to develop HTML code.
Programmer Analyst June 2005 - Dec 2006 Hewitt
Associates, Chennai, India
CRM
The Customer Relationship Management application manages accounts,
contacts, leads, opportunities and cases and their relationships. Also
this module is provisioned to create suspects, nothing but a lead. The
created lead could be converted into a company, opportunity or to a
contact. The user can create and manage the set of activities such as
Appointments, Calls, Fax, Letter, and Email. These activities could be
assigned to other users as well could be shared among users. The CRM also
has rich security features that enable to assign security property for all
fields in a page. It has customization feature which enable the user to
create custom controls such as text field, text area, radio box, etc in all
the modules.
Technologies used: JDK 1.4, J2EE, JSP, Servlet, YUI Library, JDBC, Struts,
HTML, CSS, JavaScript, WebServices, SQL Server 2005, Apache Tomcat, SVN,
log4j and Eclipse
. Responsible for designing and developing a risk management enterprise
software application.
. Helped, created and validated business requirements prior to
development of new functionality.
. Implemented front-end views of the application using a combination of
JSP, Tag Libraries, Struts, HTML, JavaScript technologies.
. Developed Action, Form and Validator classes for Struts.
. Developed the customization feature that enables adding up custom
fields to web pages.
. Implementation of Filters based on conditions and the user can
edit/update filters and can be used at a later time.
. Involved in the import/export functionality of various
accounts/contact information from Ms-Word/Excel formats.
. Using mail API, developed the mail sending functionality in the email
module.
. Implemented the auto completion functionality (similar to Google
Search) using YUI library in the Activities module.
. Involved extensively in writing SQL Queries.
. Involved in Code Refactoring for better performance of application.
. Involved in Unit and Integration Testing after each development Life
cycle.
. Involved in performing code reviews before delivering to QA.
. Worked closely with Testing Team during Pre-Live of the applications.
Contact this candidate