Resume

Sign in

Sql Server Project

Location:
Overland Park, Kansas, 66213, United States
Posted:
May 27, 2010

Contact this candidate

Kavitha Edula

Email: abl4qg@r.postjobfree.com

Web Application Developer (JAVA/J2EE) Ph no: 913 *** ****

. Experienced software professional having 7+ years of experience in the

activities of analysis, design, development and maintenance of

Software in web based, networking systems and N-Tier architecture

applications using Java, J2EE, JSP, Servlets, EJB, JMS, JDBC, Struts,Spring, Hibernate,JASPER Report(IReport),JavaScript Framework(DOJO, JQuery ),AJAX and multithreading with using RDBMS Oracle, SQL Server

on Unix and Windows environment. Industry experience includes

Insurance, Finance, Banking, Telecommunications,

Medical/Pharmaceutical, Bioinformatics and HR Information Systems.

. Experienced in RDBMS SQL, PL/SQL in retrieving and manipulating data

from backend DB2, Oracle & SQL Server

. Excellent understanding of Software Development Life Cycle process

which includes Designing, Developing and Testing and Implementation.

Strong analytical, design and troubleshooting skills, also involved in

unit testing, user acceptance test, maintenance and production support

phases by following AGILE/ SCRUM methodology

. Six years of hard core experience in server side J2EE programming,

developing medium to large scale web applications, and enterprise

applications using Java Beans, EJB, Servlets, JMS, Spring, XML Beans,

JDBC, JavaMail, STRUTS, Hibernate, iBATIS, Web services, SOAP, JSF,

XML, XSD, XST, Swing, AJAX and JavaScript(DOJO and JQuery)

. Expertise in the development of web applications adopting MVC

frameworks (Jakarta Struts, Spring).

. Experience in the development of Jasper Reports using IReport2.0.5

. Experience in implementing Object/relational mapping Using Hibernate

. Extensive experience in implementing XML technologies - XML, Schema,

XSLT, XPath.

. Experienced in IBM Websphere5.x/6.0 (WSAD, RAD), JBoss 4.2.X GA,

IntelliJ 7.0.3, BEA Weblogic 5.x/6.x, JRUN Application Server,Apache

Tomcat 3.0/4.0/5.x and Rational ClearCase, Subversion (SVN).

. Highly proficient in developing Object Oriented Design, Methodologies

and applications in client/server and distributed environments using

J2EE architecture & other basic design patterns.

. Experience in implementation of GO4 design patterns and refactoring

the code.

. Expertise in integration of existing applications with Enterprise Java

Beans using Websphere, IntelliJ 7.0.3, Weblogic & Apache Tomcat

3.0/4.0/5.0 application server.

. Experience in programming languages C, C++.

. Performed troubleshooting of the problems originating in the

production environment and resolved the production problems. Exposure

to all aspects of Software development, Troubleshooting, Testing,

Maintenance and Production Support.

. Calculated LOEs for new projects, Involved in project implementation

phases, closely monitored and interacted with clients production

testing. High proficiency in Scheduling and Managing resources and

activities in Teams.

. Expertise in offshore - onsite coordination .Helped new team members

to understand the Business requirements & system flow.

. Versatile Team Player and Team Lead with good communication & problem

solving skills with all management levels. Good rapport with managers

leads team members and works independently as well as in a team.

. Strong written and verbal communication skills and strong

collaboration skills

Technical Summary

Operating Systems HP, AIX & SUN Solaris Unix, Windows 95/NT/2000/XP &

MS-DOS

J2EE /Frameworks Servlets2.4,JDBC2.x/3.0,JSP2.0,Taglibs,EJB3.0, JMS,

JNDI, RMI,Struts1.1/1.X, Swing,Hibernate 3.x&

Spring2.0(DAO,MVC,AOP etc.), iBATIS1.X

WEB & XML HTML, CSS & Java Script1.x, XML, XSLT/FO, AJAX,

Technologies JavaScript Framework(DOJO, JQuery ),XPath & XML

Beans,PHP

Application Servers Websphere 5.x/6.0, JBoss 4.2.X GA,IntelliJ

7.0.3,Weblogic 7.0/8.x & Apache Tomcat 3.0/4.0/5.x

Programming SQL, PL/SQL, C/C++, Java1.3/1.4, Java Script & Unix

Languages Shell Scripts

Databases/RDBMS Oracle 8/9i, SQL Server 2000/2005, DB2 & MS-Access

SOA & Allied Web Services (Apache Axis 1.2), WSDL, SOAP

Technologies

Utilities Ant 1.x, Maven2.0.8,JUnit 4.1, TOAD, Eclipse

2.x/3.x, WSAD 5.1, RAD 6.0/8.x, JBuilder, XMLSpy,

Rational ClearCase,SVN, Test Director, Change

Synergy, Rational Clear Case, Subversion (SVN)

,Quality Center, Rational ClearQuest Web,WinSql 4.1,

Log4j & MQSeries5.2, IReport 2.0.5

Education/Certifications

M.S in Computer Science, India.

B.S in Computer Science, India.

LOMA 280 (Insurance, Life, Health and Annuities) Certified Professional.

Professional Experience:

USDA - Kansas city, MO

April2009 - till date

IT Specialist (Analyst/ Programmer)

USDA-United States Department of Agriculture :USDA Farm Service Agency's

(FSA) Tree Assistance Program (TAP) provides financial assistance to

qualifying orchardists to replace eligible trees, bushes, and vines damaged

by natural disasters. TAP was authorized by the 2008 Farm Bill.

Project -TAP Admin, Sign up and ECPR:

TAP Admin manages master data like create, update and delete Program year,

Disaster types, Practices, Crops and Practices. TAP Sign up manages

Applications like create, update and delete

Application, Stand. Applicants will be able to initiate an application on

their behalf. Applicants can enter and modify their application data until

the application is approved, once the application is approved, the county

office must make any required changes .Applicants will not have approval

authority Applicants will be able to sign electronically according to e-

Authentication rules.

. Developed TAP Application using Spring framework, Struts framework,

and jboss-4.2.3.GA. And maven.

. Implemented DAO, MVC design pattern using STRUTS frame work.

. Implemented JavaScript Framework(JQuery)

. Written Persistence layer DAO s injected these DAO into Business Layer

that is into Services. written services in service layer, business

contracts and it's validations

. Written action classes,jsps,CSS,properties files and all application

layer related files

. Written client side and server side (contract and business logic)

validations

. Written SQL queries for create,update,delete and display

applications,stands and all

. Prepared the used test cases based on the specification provided by

the users & Developed Test Cases using Junit

. Written in the Jasper Reports using IReport2.0.5

. Written end user documents and development guide

. Participated in knowledge transfer sessions to train new team members

& testers

. Interacted with Business Team to support (technical advice) and gather

the requirements.

. Experienced in QA Testing side using Quality Center, Rational

ClearQuest Web. Well experienced in Manual, and implementing different

testing methods including White Box, Black Box and Back End testing.

. Demonstrated complete application to end user

. Followed AGILE/ SCRUM methodology.

Environment: JBoss 4.2.X GA, Eclipse-3.4.0, (JSP, Servlets, JSTL, Spring

and Struts Framework, JavaScript Framework(JQuery),Microsoft SQL server

2005, SQL, PL/SQL, Microsoft SQL Server Management Studio, log4j, Java,

J2EE (JNDI, LDAP) and XML, Maven2.0.8, Rational ClearCase, Subversion

(SVN), Sun Solaris UNIX & Windows XP and ClearQuest.

Monsanto - Stlouis, MO

July2008 - Feb2009

Programmer/Lead

Monsanto is a multinational Agricultural Bioinformatics corporation. It is

the world's leading producer of genetically engineered seeds. It helps

farmers grow yield sustainably so they can be successful, produce healthier

foods, better animal feeds and more fiber, while also reducing

agriculture's impact on our environment.

Project - Customer Operations:

Monsanto uses Lyceum 2.0 portal .It`s Us market`s business intelligence

system. Lyceum is used for faster and timely access to products, customer

operations, marketing and field information.

It`s a individual module under Content Management and UI

Project - Program Operations:

Maintaining the documents. Adding new documents, deleting, updating

existing ones,

Displaying important bioinformatics documents as per the priority prepared

by scientist

Project -MSIS: Monsanto Sales Information Systems

Complete sales information related Seeds, Chemicals and their related sales

planning information

. Participated Design, Analysis, Development, Test, Implementation,

Maintenance and Production Support of the system

. Designed and Developed Data Model and View Layer using JSP, HTML &

Java Script (DOJO).

. Developed Entity and Session beans using Websphere in the server side

for the business logic processing.

. Developed Entity beans which are responsible for retrieving and

manipulating data from Oracle database

. Implemented GO4 design patterns .

. Designed and Developed Data Model and View Layer using JSP, AJAX,HTML

& Java Script (DOJO).

. Developed Entity and Session beans using Websphere in the server side

for the business logic processing.

. Implemented Command, Fast Lane Reader, Business Delegate, Service

Locator, DAO design patterns.

. Implemented JavaScript Framework(DOJO)

. Participated in knowledge transfer sessions to train new team members

& testers.

. Prepared the used test cases based on the specification provided by

the users & Developed Test Cases using Junit

. Interacted with Business Team to support (technical advice) and gather

the requirements.

. Implemented the Ant,Maven build scripts to deploy the .war files on

the Apps Server

. Followed AGILE development methodology.

Environment: Web Sphere server 6.0(RAD), IntelliJ 7.0.3, Tomcat 5.5.20,

EJBs(Entity,Session ) JSP, AJAX (DOJO),Servlets, JSTL,Spring, iBATIS

1.X,Oracle9i, SQL, PL/SQL, TOAD, log4j, Java, J2EE (JNDI, LDAP, JDBC Type

4 Driver) and XML, Ant, Maven2.0.8, Rational ClearCase, Sun Solaris Unix

& Windows XP and TeamTrack.

Coventry Health Care - Glen Allen, VA

Novmber 2007 - June 2008 Programmer/Analyst

Coventry Health Care ensures that every person and organization they serve

received the greatest possible value for their health care investment. It

does this by bringing together members, employers, and providers, making

available the best possible information, and together devising solutions

that help people enjoy optimal health .It provides a full range of

products and services, including group and individual health insurance,

Medicare and Medicaid programs, and coverage for specialty services such as

workers' compensation.

. Migrated Application to Struts2.0 Frame Work.

. Implementation of Object/relational mapping Using Hibernate.

. Involved in implementation of MVC design pattern using STRUTS 2.0frame

work.

. Designed and Developed View Layer using JSP, AJAX (DOJO, JSON), HTML &

Java Script.

. Modified XSL and transforming that XSL locally by using XML Spy for

testing and development purposes.

. Developed Entity beans which are responsible for retrieving and

manipulating data from Oracle database.

. Designed and Developed the Customs Tags to implement Sorting.

. Prepared the used test cases based on the specification provided by

the users & Developed Test Cases using Junit.

. Interacted with End Users and Business Team to support (technical

advice) and gather the requirements.

. Implemented the Ant build scripts to deploy the .war files on the Apps

Server

. Involved in knowledge transfer sessions to train new team members &

testers.

Environment: Websphere server 6.0(RAD), Apache Struts 2.0, Hibernate 3.1,JSP, Servlets, JSTL, Rational Clear Case, clear Qest,Oracle9i, SQL,

PL/SQL, TOAD, Change Synergy, log4j, Java, J2EE (JNDI, LDAP, JDBC Type 4

Driver) and XML, AJAX (DOJO),JSON, Rational ClearCase, Sun Solaris Unix &

Windows XP.

Principal Financial Group - Des Moines, IOWA, USA July 2006 -

October 2007

Associate Consultant/ Lead

The Principal Financial Group is a leading global financial company

offering businesses, individuals and institutional clients a wide range of

financial products and services like banking, health insurance, retirement

(401K) & college savings (529) plan & investment.

Project - TAS - Treasury Administration System: TAS is used to report,

track and manage cash transactions across the organization. The information

entered and stored in TAS is considered Company Confidential and is subject

to all information sharing guidelines. Consolidation of cash transactions

between TAS, PACT & EFT Advice for purposes of cash management,

reconciliation & automated initiation of internal transfers generated via

the TAS Client and Business Unit interfaces

Project - WIDE - Web Iterative Design Enhancements: Create accessible Web

content that involves coding towards Web standards as defined by the World

Wide Web Consortium, the governing organization that creates

specifications, guidelines, software, and tools for the Internet.

Project - EER - Employer Electronic Reporting: Financial Group offers the

opportunity to establish Health Savings Accounts through Principal Bank.

While acceptance of this offering is at the employee level, the offering is

primarily done via the employer.

Responsibilities:

. Participated in the Design, Analysis, Development, Test,

Implementation, Maintenance and Production Support of the system

. Oracle database administrator for production and development databases

for various releases of Oracle (Oracle 9i and Oracle 10g) on HP-Unix,

Red Hat Linux, Solaris and Windows 2000/2003/NT OS

. Involved in Upgrade all Web site domain pages with new Corporate Web

Style.

. Removed all RIS specific styling and use new Corporate Web Style.

. Application developed using JSP, Struts, SERVLETS, XML, XML Beans &

WebSphere6.0 (RAD).

. Implemented MVC design pattern using STRUTS frame work.

. Implemented JSF frame work

. Modified XSL and transforming that XSL locally by using XML Spy for

testing and development purposes.

. Involved in implementation of Spring frame work, also used Hibernate.

. Reviewed code and remove deprecated elements/attributes using new

styles

. Validated HTML code using the W3C validator.

. Responsible for development and enhancements of Batch Upload Process

in EER.

. Responsible for developing new features while maintaining the existing

functionality.

. Involved in version control through Clear case & Involved in Unit Test

Cases.

. Involved in knowledge transfer sessions to train new team members.

Environment: Java 1.4, J2EE1.3, Servlets, JSP, XMLBeans, Struts

framework1.1/1.X,JSF, XSLT, XML, XML Spy, Rational ClearCase, Spring,

Hibernate, Webshere6.0, RAD, ClearCase, Sun Solries Unix & WindowsXP.

Qwest Communications - Denver, CO March 2005 - June 2006

Programmer/Analyst

Qwest is a leading telecommunication service provider and provides services

in both wired and mobile telecommunication. Worked as web-based application

and accessed by potential customers. Customer has to register with

Qwest.com using with a UserID and Password. A secure site processed the

login information. Billing, new features, company information, minutes used

and payment information was provided to each customer.

Responsibilities:

. Developed the Login Servlet and related session beans which is

responsible for initial authentication of the users coming from

different systems. Developed the JSP's, which contains the logic and

presentation part.

. Involved in implementation of MVC design pattern using STRUTS frame

work.

. Developed Entity beans which are responsible for retrieving and

manipulating data from Oracle database.

. Involved in design and development of GUI for configuring,

provisioning, monitoring, and maintaining high-speed optical switches

using JSP for Web.

0. Developed Entity and Session beans using Websphere in the server side

for the business logic processing.

1. Implementing Web Services using Apache Axis and writing the clients

for Web services

2. Used Java Server Pages server-side mail object to send mails to the

Trading Partners

. Developed shell scripts required for bean deployments and executing

certain custom jobs from command center.

. Involved in Implementation and production support of the application.

Environment: J2EE1.3, Sun Solaris UNIX, Windows2000, JDBC2.0, Jbuilder4.0,

XML, SAX, DB2, SQL, TOAD, C, Rational ClearCase, Test Director,

Servlets1.2, JavaScript, JSP1.1, Apache Axis (SOAP), Java Beans1.2/2.0 &

Websphere4.

Comerica Bank - Detroit, MI January 2004 -

February 2005

Programmer/Analyst

The System is a web-based application, which deals with tracking and

research of a particular Fraud check. The system deals with the 'positive

pay' and 'image positive pay' methodology of fraud check. The system deals

with re-imbursement of money due to fraud checks by tracing the details in

a fraud case.

Responsibilities:

. Analyzed the project requirements. Suggested and demonstrated some of

the technical solutions for accomplishment of project requirements.

. Responsible for design and development of front-end screens using

HTML, JavaScript and JSP & designed XSLT style sheets for transforming

XML data to HTML.

. Involved in Analysis and Designing using UML and Rational Rose.

. Written various JSP's to handle request and response to and from

clients.

. Design and Development of Entity Beans, which interact with Oracle

Database.

. Used Session beans to implement business logic/rules and the standard

GUI interface using JSP and written various JSP's to handle request

and response to and from clients.

. Developed Server Side Components (EJB) for holding business logic such

as manipulating data and for various calculations using Session beans.

. Executed the SQL Queries, Stored Procedures and Functions against the

Database.

. Responsible for writing enterprise build scripts using Ant Build Tool.

. Responsible for preparing UNIX shell scripts for batch process.

. Responsible for application Unit Testing (Functional/GUI) and Cross-

browser testing on Netscape and I.E navigation through the site with

hyperlinks.

. Involved in unit testing, user acceptance test, maintenance and

production support.

Environment: JDK 1.3, IBM Websphere 5.0(WSAD 5.0), Rational Rose Tool,

Rational ClearCase,Oracle9i, SQL, PL/SQL, TOAD, JSP, Servlets, XML, C,

Ant, JNDI, JDBC, HTML, AIX UNIX, Windows 2000.

Sparsh Communications Ltd. - India April 2003 - December 2003

Programmer/Analyst

This System is an E-Business Integration Application developed using MVC

architecture, which involves user-interface, application, data, and inter

business integration of the Distribution Channel. The system helps the

dealer to place the order on the web and automatically checks with the

warehouse application. The system then generates the order and updates the

ERP and informs the dealer the order status and tracking number that is

generated by the system. The dealer finds the status of the order up to

shipping information that is been updated by the warehouse application.

Responsibilities:

. Involved in development of case diagrams, interaction and class

diagram using Rational Rose using design pattern approach &

implemented MVC architecture.

. Coded EJB's for product information, pricing and stock levels and

transaction handling using JTA.

. Coded Entity Beans and Session Beans for tracking information,

creation of business objects.

. Developed/Tuned Stored Procedures/Functions in MS SQL Server.

. Coded JSP's and java beans for invoking EJB's and managing sessions.

. Coded HTML user interfaces and coded XSL sheets for XSLT.

. Implementation of JAVA Mailing API for the mailing service of the

system.

. Generation of XML Documents for report purposes and for messaging

system.

. Coded Servlets, API's for MVC Pattern and connectivity using JDBC.

. Developed back end procedures, functions, triggers and java objects on

Oracle8i.

. Responsible for Security implementation and integration testing of the

system.

Environment: J2EE1.2, EJB1.1, MS SQL Server,Weblogic5.1, Java mail, JDBC,

JSP, SAX, DOM, Servlets, ANT, PVCS, JavaScript, HTML, XSLT, JBuilder, JDK,

JNDI, Junit, UML, Rational Rose, Change Synergy, HP Unix, Windows95.

Navodaya institute - India May 2002 -

March 2003

Programmer/Analyst

The project is aimed at the development of a full feature Intranet set up

for the organization based on the following modules have been identify for

content development: Personal and Human Resources Management, Skill Set

Management, Leave Management and Timesheet Maintenance system.

Responsibilities:

. Designed of client/server and the adapter (JDBC) layers; design the

database tables.

. Involved in data transmission between server and Client is done

through JDBC Application which connects backend Oracle database.

. Prepared the user entry forms and front-end screens using HTML and

DHTML

. Involved in Testing, production support and Implementation phases.

Environment: JAVA, JAVA SCRIPT, JDK, HTML, JDBC, SERVLETS, C, Weblogic5.1,

Applets, Oracle8i, SQL, PL/SQL, CVS, HP-Unix & Windows NT.



Contact this candidate