Java Developer Sql Server

SANTHI MUVVA

****, ******** **, ******* *****-*0089; Phone – 847-***-****; ac3qny@r.postjobfree.com

Status: US Citizen

Objective

Seeking a challenging position in Software Quality Assurance as QA Engineer

Summary

8+ years of diversified experience in Quality Assurance testing (5 years)

Experience in requirements analysis, development, integration,

Documenting, testing, support and maintenance of highly sophisticated old centralized systems to

Current n-tier component based systems.

Experience in automation using Selenium WebDriver

Experience in SOA/Web Services testing using SOAP UI (SOAP, REST), JMeter

Experience in Manual Testing of applications on Windows, Unix and Mac environments

Experience in Web Application and Database Testing

Experience in QA Methodology and QA validations to ensure the Quality Assurance control

Experience in integrating four Quality management modules – Requirements Management, Test Plan, Test Lab and Defects Management using HP ALM – to allow for a smooth information flow between various testing stages

Experience in several defect tracking tools such as JIRA, Bugzilla

Extensive experience in Relational Databases (Oracle, MySQL)

Expertise in Software Development Life Cycle and Test Methodologies

Experience in Agile/Scrum and Water Fall Methodologies and testing Mobile apps

Primarily specialized on development in JAVA, XML (SAX and DOM parsers) and J2EE

technologies Spring Framework, Struts/MVC Framework,Hibernate, AJAX and understanding of JSF on UNIX, Solaris, Linux and Windows platforms.

Excellent communication (both written and oral) and collaborative skills

Detail oriented, highly organized and team player

Education

Master's degree in Mathematics, Sri Padmavathi Mahila University, India.

Certifications

CSM certified.

Skills

Testing Tools

HP Quality Center-ALM, Test Director, SOAP UI, SoapUI Pro Selenium2.x, TestNG, JMeter, Cucumber tool, Protractor tool

Defect Tracking Tools

Quality Center, Test Director, Microsoft Test Manager,

Microsoft visual studio 2010, Clear Quest

Languages/Tools

JAVA, JavaScript and HTML, DHTML, UML, SQL Server, PL/SQL, Splunk, HQL, TOAD, RAD, Eclipse., Clear case, TFS

Operating Systems

Windows Vista/XP/NT/2000/98, and Unix (Sun solaris2.6/2,8) and Microsoft technologies, Mac, Linux

Databases:

Oracle, SQL Server 2000, MS Access, My SQL, DB2, Developer 2000 (Forms 3.0/6i, Reports 3.0/6i)

Servers

Java Web Server, Apache, IBM Web Sphere server, Tomcat,

Office Products

MS Words, MS Excel, MS Projects, MS Power Points, Visio etc,

Open Office tools

Experience:

Company: Allstate Insurance Co., Northbrook, Chicago, IL (Aug 2012 – Till date)

Role: QA senior analyst

Summary: House and Homes Insurance Product

Allstate Insurance is a leading Insurance company. It has worldwide presence with the offices located in all over United States, Northern Ireland and India. Allstate offers insurance for various products for e.g. Auto, Home, Renters, Condo, Motorcycle, Business and Life (Alliance applications).

Responsibilities: Worked as a developer and tech lead in Alliance first year and moved to ETRM team working as a QC analyst & test lead and was given responsibility to lead Enterprise Testing Team (ETRM) working on home insurance called “House and Home”. This team includes functional, regression and automation testing teams. Though I was part of Functional team but responsible for additional activities looking after regression and automation. I have leading experience of working on offshore and on site model.

Follow Gate requirements and deliverable for different SDLC phases and provide approvals/Sign off on behalf of ETRM team.

Prepare and review Test Plans and test strategy.

Leading and running the status calls for projects - Participate and drive conversations in overall project/program status meetings.

From PMO prospective, work with ‘Test Delivery Managers’ in estimation, resource allocation, and tracking project hours.

Conducted Functional, Integration, System and Regression testing of the application.

Worked with users to complete UAT and prepared test data for their testing.

Interacted with business users, downstream application teams during project life cycle

Performed extensive Database Testing to ensure that data is persisted correctly in Oracle Database.

Developed selenium scripts for automation using cucumber tool.

Executed Automation tests for H&H using Selenium for each sprint.

Performed Web service testing (SOAP) for H&H applications using Soap UI (ACS, LTS, SE services).

Created and executed SOAP requests for all test cases in Soap UI.

Work involved testing and reporting bugs using bug-tracking system Clear Quest (CQ), Bug verification/review with development team

Create test cases in JIRA as part of agile projects implementation.

Created several reports for higher management about outstanding bugs and bugs fixed for FT

Responsible for managing updates to different testing metrics i.e. HPQC,

Executed SQL queries for data validation in database using SQL server.

Effectively interacted with different business units like Development team, Business Analysts, Product/Project management

Coordinated with offshore team members and development team to resolve problems

Environment: Soap UI Pro 5.0, JIRA, Unix (HP-UX), MS SQL Server, Windows, HP Quality center10, Clear quest, Support util, RAD8.5, Eclipse4.5.2, Clear case, WAS8.5, Selenium.

Company: Gogo air - Chicago, IL (Feb2012 – August 2012)

Role: Java developer and QA analyst

Project: Videos

Gogo provides WIFI connections and entertainment products business for customers on Flights.

Video application is one of the most famous on-demand Internet streaming media available to rent videos on different airplanes. Provides customers to rent movies in air with Wi-Fi connection.

Responsibilities:

Involved in gathering business requirements.

Developed applications using spring MVC.

Maintenance of front end screens.

Involved in application deployments on Linux environment.

Tested different video movies on MAC and windows platforms, Androids and used different browsers like Internet explorer, Chrome, Firefox and Safari.

Created UTPs, ITPs for unit and integration testing

used Quality Center for bugs tracking.

Worked with offshore team members to resolve problems during functional testing.

Worked with users to complete UAT and prepared test data for their testing.

Performed SoapuI testing for webservice tests.

Agile methodology

Environment: Quality Center9.0, SQL server2008, Linux, windows6, SoapUI, Eclipse, Tomcat server.

Blue Cross Blue Shield Association - Chicago, IL (Mar 2010 – Feb2012)

Role: J2EE Developer

Project6: Non Blue Administration

Blue personnel users can update their information in LDAP using Contact Directory, but non-Blue personnel are not authorized to access Contact Directory, and therefore have no way to update their information. Currently, the only way to add or update a non-Blue user in LDAP is by direct manipulation of the database.

This new solution will allow a predefined group of users to add organizations and individuals to LDAP using a user-friendly interface. All data entered via this interface will be validated prior to submission to ensure data consistency.

Responsibilities:

Involved in gathering business requirements..

Designed and Developed the JSPs.

Developed Struts MVC framework..

Developed action classes and struts config files.

Performed unit testing and SIT.

Environment: Windows NT/2000/XP, RAD 7.0.1, IBM Web Sphere Application Server 6.1, Java Script, CSS, Html, JSP, Clear case, Struts1.1. LDAP.

Project5: Blueweb-Liferay migration

The decade old customized BlueWeb presentation system in Java/J2EE was replaced with LifeRay application. We rewrote the end to end presentation system in LifeRay including all home pages and work areas. The application server was changed from Web Sphere to TC Server (extended version of Tomcat).

The web server was changed from IIS to Apache

Responsibilities:

Involved with Business Users in requirements gathering for Blueweb enhancements.

Designed and developed in Liferay portlets.

Created Themes and layouts for presentation layer.

Developed free marker templates.

Created CSS files for the screens look and feel.

Performed unit testing and SIT.

Environment: Windows NT/2000/XP, Liferay-Spring Source tool 2.5, Tomcat Server 6.0, Java Script, CSS, Html, FTL, Clear case, Spring MVC, Hibernate3.0..

Project4: Professional Development Process (PDP)

PDP application is a process of submitting employee training applications and approval process of the application. Training and development will manage the vendors, programs and certifications. Different levels of management will process the applications for approvals.

Responsibilities:

Involved with Business Users in requirements gathering for PDP enhancements.

Designed and Developed the JSPs.

Developed Spring MVC framework..

Created Batch process for daily and weekly e-mail notifications.

Developed queries in hibernate.

Performed unit testing and SIT.

Environment: Windows NT/2000/XP, RAD 7.0.1, IBM Web Sphere Application Server 6.1, Java Script, CSS, Html, JSP, Clear case, Spring MVC, J-Query, JSTL, SQL server 2005.

Project3: Medical Policy Router

MPR is a process of a Provider (from a Local Plan) requesting Medical Policy and/or general Pre-Certification/Pre-Authorization Information from a Member's Home Plan.

The process is to allow the provider Read-only access to the Medical Policy and/or general pre-certification/pre-authorization information from a member’s home plan that is requesting services.

Responsibilities:

Involved with Business Users in laying out the requirements for MPR enhancements.

Designed and Developed the HTML screen

Developed Java script validations.

Developed CGI/Perl scripts to route the BCBS Plan’s URLs.

Performed unit testing and SIT.

Environment: Windows 2000/XP, RAD 7.0.1, IBM Web Sphere Application Server 6.1, Java Script, JSP, Html, Clear case, CGI/Perl scripts.

Project2: Contact Directory

Contact Directory will provide the Committees and Sub Committees for the users. I was involved in creating new sub committees and deleting subcommittees which are using by the users.

Created sql queries on the server side and the subcommittee’s data will be populated in Contact Directory jsp screen. Used html conversion tags in the query descriptions.

Project1: Resource Allocation

RAM (Resource Allocation Management) Tool allows the users to enter data manually for projects and resources information available in PeopleSoft and Deltek. The new enhancements will eliminate manual entry and will be augment the Resource plan process with actual Deltek Timesheet data and capture in a repository to be used in Finance’s PeopleSoft Cognos reporting.

I have created extraction process for Projects and Resources. And Deltek timesheets for working projections.

Responsibilities:

Involved with Business Users in laying out the requirements for RA enhancements.

Involved in server side extraction process.

Used java interfaces to extract the data.

Developed Hibernate mapping files for configuring Hibernate POJO’s for relational mapping.

Developed HQL queries in Hibernate.

Performed unit testing and SIT.

Environment: Java1.5, Windows 2000/XP, RAD 7.0.1, IBM Web Sphere Application Server 6.1, Java Script, CSS, JSP, Log4j, Clear case, Hibernate3.0, SQL client, SQL Server2005, HQL.

WALGREENS - Lincolnshire, IL (May 2009 – Feb2010)

Role: JAVA Developer

Project2: Contact Point

The Contact Point Admin module will be used for back office support for all existing and future components like Universal Agent Directory (UAD), Log4j, Search Settings. UAD module exists as part of Contact Point web tier.

I have developed Audit Trail service as generic interface for these modules to archive the data.

Developed a new screen for user interface to generate reports on Audit Trail for different search criteria.

Responsibilities:

Involved with Business Users in laying out the requirements for Audit Trail Service.

Used Agile methodologies and SDLC for the application.

Implemented both server side and client side validations.

Implemented Contact Point MVC framework for Audit Trail application.

Used IBATIS to access data objects. Used Object Relational Mapping.

Deigned and created tables for Audit Trail.

Developed SQL queries in IBATIS.

Performed unit testing and SIT.

Environment: Java1.6, Windows 2000/XP and Sun Solaris, RAD 7.0, IBM Web Sphere Application Server 6.1, Servlets, DHTMLX, Java Script, CSS, JSP, Log4j, CVS, IBATIS2.0, Toad7.1, SQL Server2005, SQL.

Project1: Store Audit

The Store Audit System will help Walgreens to audit the stores and grade the store/pharmacy manager according to the audit result for a budget period and audit period. The Store Audit Web application allows the front end users to create Audit Forms during Store Audit. This application provides the Reports information for the Audits.

Responsibilities:

Involved with Business Users in laying out the requirements for new enhancements.

Involved in the application development and enhancement for various modules of the system store audit.

Implemented both server side and client side validations using Java script in JSP.

Implemented Servlet framework for the Compliance day audit application.

Performed unit testing, functional SIT for various modules Maintenance screens and reports.

Used JDBC to access data objects.

Modified and developed SQL queries.

Involved in the regular build activities and deployment of the application onto web sphere application server WAS 6.0.

Environment: Java1.5, Windows 2000/XP and Sun Solaris, RAD 7.0, IBM Web Sphere Application Server 6.0, Servlets, DHTML, Java Script, CSS, JSP, CVS, Java Mail, JDBC2.0, Toad7.1, Oracle9i, SQL.

Contact this candidate