Sql Server Project
Resume:
Kavitha Edula
Email: *********@*****.***
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