Vemula
***** ****** ***** ***, ******* VA *****
Email: acebxi@r.postjobfree.com
Phone: 240-***-**** & 703-***-****
Status: Green Card
Career Objective:
To acquire a position in the field of Software Quality Assurance and Software Testing where I can
contribute for the benefit of the organization through my knowledge and experience and at the same time,
get the opportunity to enhance my technical and interpersonal skills.
Professional Summary:
• Quality Assurance Engineer with Seven years of experience in Testing Web applications and
Client/Server applications both manually and using Automation tools.
• Extensive experience in working on various test strategies and preparing Test Plans, Test Cases and
Analyzing Test Results based on business requirements.
• Expertise in automation testing using Quick Test Pro, Quality Center, ALM QC Test Director.
• Testing of Web Services using SOAP UI, XPath and XQuery.
• Experienced in Integration Testing, System Testing, Regression Testing, Web Testing, GUI
Testing, Functionality Testing and Database Testing.
• Well versed with Software Development Life Cycle (SDLC) models like Waterfall and Agile
Models.
• Developed Test Strategy, Test Plan, Test Cases (Functional and Non-Functional), Test Scenarios
from System Requirement Specifications and Business requirements.
• Good exposure to .Net, Visual Basic, JAVA, ASP, HTML, Shell Scripts, Oracle, SQL Server
development environments.
• Solid understanding of Oracle and SQL Server databases and Windows/UNIX operating systems.
• Communicated with support, business and development teams to resolve issues during test
execution.
• Self-Starter and ability to adapt to any industry and learn any new technology and trends.
• Highly motivated worthy team player with ability to work in all environments to meet target lines.
Technical Skills:
Operating System Windows 7/XP /2000 /NT /98, UNIX
Test Management Quality Center (QC) 9.0/10, Quick Test Pro (QTP) 9.2, SOAP UI, Test
Tools Director (TD), Win Runner
Rational Tools Requisite Pro, Clear Quest 7.0.1.5
Programming JAVA, .Net, SQL, VB Script, C, TSL (Test Script Language), HTML,
Languages XML, UML
Database Oracle 8i/9i, SQL Server 2008, MS Access
Web Server Web Logic, Web Sphere,IIS (Internet Information Services)Server
Office Tools MS-Word, MS-Excel, MS-Power Point
Education: Master’s in Science, India
Status: Permanent Resident (Green Card)
Page 1 of 6
Professional Experience:
Client: Ginnie Mae (Government National Mortgage Association) Chantilly June 2013 to
Present
QA Tester
IPMS Modernization Project: Modernization of Integrated pool management system with Service
Oriented Architecture (SOA) is the significant initiative undertaken to accommodate Ginnie Mae’s
needs to meet current and future business demands. The Ginnie Mae guarantee allows mortgage lenders
to obtain a better price for their loans in the capital markets that creates opportunities for sustainable,
affordable housing for families seeking home ownership. The application built in Java Technology.
Responsibilities:
• Worked as QA Tester on Request pool number, Commitment Management, Master agreements
modules and developed high level test scenarios and presented to the management for review and
approval.
• Involved in Defining, and Analyzing the Testing Requirements based on the Application
Functionality.
• Involved in peroration of Test Data for different modules.
• Created and executed test cases and scripts in Quality Center to cover all scenarios of stakeholder
requirements, data requirements, technical specifications, business requirements, user interface
requirements, system interface requirements and usability requirements.
• Analyzed business requirements and technical specifications of application in development and
produced test cases for functional testing, integration testing and regression testing.
• Used Quality Center (ALM 11) as test reporting tool to maintain and execute test cases.
• Involved in the meetings continuously with users and modifying the test cases accordingly to test the
new features developed in the application as per the user requirements as part of UAT.
• Worked closely with developers to communicate QA issues and testing status.
Identified and documented the defects in ALM and Celoxis.
• Verified the bugs fixed by developers during each phase of Black Box Testing
• Verified and retested the bugs fixed by developers during each phase of Black Box Testing
• Involved in Regression Testing for better performance of with the new enhancements
Environment: HP ALM 11, Java, Oracle 11G, HTML, XML, Web Logic, Windows NT, Celoxis, SAP
Business Objects.
Client: IRS (Deloitte), Lanham MD July 2012 to June 2013
Project: ACA 3.0 Implementation and Testing
QA Tester
Description:
Patient Protection and Affordable Care Act of 2010 and Health Care and Education Reconciliation Act of
2010 (hereafter referred to as ACA).The IRS have a critical role to play in the implementation of the
ACA. The ACA calls for the IRS to implement and administer a large number of tax provisions, including
Status: Permanent Resident (Green Card)
Page 2 of 6
support for American Health Benefit Exchanges, flexible spending arrangements and small-business
health care tax credits.
I am worked on CDR (Coverage Data Repository), which is a sub project in ACA. The Information
Sharing & Reporting project will facilitate the exchange of ACA data between the CDR and
CMS/Exchange systems. In addition, the CDR project will also facilitate and meet IRS ACA reporting
needs.
I am worked on ISR (Information Sharing and Reporting), which is a sub project in ACA. The
Information Sharing & Reporting project will facilitate the exchange of ACA data between the IRS and
CMS/Exchange systems. In addition, the ISR project will also facilitate and meet IRS ACA reporting
needs
Responsibilities:
• Created and executed detail function test script and test cases based on the business Requirements
• Performed Positive/Negative testing to check the functionality
• Developed Test Cases, and Test Scripts for Implementation testing
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing and Functional testing and Unit testing.
• Organized the tune systems and ensured its optimal performances on multiple platforms for Verification,
Validation, and Transformations on the Input data (Text files, XML files) before loading into target
database
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of
aborted/failed sessions
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading
data into data warehouse database.
• Worked with development teams to understand application requirements and designs
• Worked on SOAP UI
• Worked on SQL scripts to load data in the tables
• Tracked the defects using Sprint Reporting tool and generated defect summary reports
• Experience testing on XML documents
• Responsible for all new and existing ETL data ware house components
• Experienced at testing ETL s’ and flat file data transfer without relying on GUI layers
• Used INFORMATICA tool for ETL jobs
• Attended meetings along with the developers for DML and DDL’s
• Ran ETL jobs to extract the data transfer the data and load the data from source to target data
base tables
• Verified logs after running ETL jobs
• Tested the Informatics mapping and other ETL processes (Data Warehouse testing)
• Expertise in creating test data for data warehouse applications including web services testing
Status: Permanent Resident (Green Card)
Page 3 of 6
• Validating and debugging its components, and monitoring the resulting executable versions.
• Prepared status summary reports with details of executed, passed and failed test cases
• Created traceability relationship between requirements in the same module and also between
different modules
• Peer reviewed the Test Cases and made recommendations.
• Verified the quality of the requirements, including testability, requirement definition, test
design, test-script and test-data development, test-environment configuration; test-script
configuration management, and test execution.
• Primarily responsible for creating test strategy documents, reviewing
the testing environment/platform, planning and creating test cases.
• Participated peer reviews, daily status meetings, scrum conferences to optimize the test
documents
• Conducted test-design and test-procedure walk troughs and inspections.
• Ensuring that test-product documentation is complete
Environment: Rational Requisite Reqpro, Rational Team Concert, Soap UI, SAP Business Objects Info
view Tool, Web methods, XML, XQuery, XPath, XML SPY tool for XML, PL/SQL, Rapid SQL
Navigator, Windows XP, Data Stage 7.5.3
GEICO, Bethesda, MD QA Tester Aug 2011 to June 2012
FNOL (First Notice of Loss)
GEICO, Government Employees Insurance Company, has been providing affordable auto insurance
since 1936, First Notice of Loss is a web based auto accident claim reporting and claim handling
application for GEICO policy holders, claims customer service representative and adjusters. The
application checks duplicate claim, records the loss, assigns auto damage adjuster for loss estimates, and
makes an appointment for repair
Responsibilities:-
• Written functional test Conditions and test cases in ALM 11.0 Quality Center
• Performed Smoke, Navigational, Integration, Functional and GUI testing of the application
• Involved in back end, End-to-End testing phases and corresponding process of migration
• Worked closely with developers to communicate QA issues, testing status and with the testing team
• Identified and documented the defects in Mercury Quality Center
• Verified the bugs fixed by developers during each phase of Black Box Testing
• Communicated defects encountered during regression test and followed-up with developers until all the issue
were resolved
• Contributed overall testing efforts for performing smoke, functional, back end and regression testing
• Test procedure and test case preparation, defect tracking and monitoring using HP Quality Center.
• Test planning, designing test cases, test execution, error reporting, analysis and error
• Verification. Coordination test cycles with client
• We follow –Agile methodology on daily bases, to get the sates of the work.
• Performed Regression testing using QTP
Status: Permanent Resident (Green Card)
Page 4 of 6
• Worked with development, Marketing teams to release quality product
• Analyzed the outcome of results and reported to QA manager
• Performed cross browser testing
• Implemented the SDLC for testing life cycle and followed the RUP in the application, which meet SEI
standards.
Environment: - Mercury Quality Center, JIRA, Oracle, SQL, Java Weblogic, Unit and Windows XP
U.S. Department of Education (Federal Student Aid) Fairfax Mar 2010 to July 2011
QA Analyst/Functional Tester
U.S. Department of Education, Office of Federal Student Aid (FSA) Integrated partner Management
(IPM) Development Solutions project. The IPM team is focused integrating FSA’s four major legacy
systems into one system with front end as IPM Web Portal. The IPM system is a web-based electronic
and Case Management System for Eligibility, financial & compliance audit, and Oversight business
tprocess that allow the receipt, scoring and workflow management of the FSA Eligibility, audit and
compliance reporting and analysis functions.
Responsibilities:
• Involved in functionality testing of IPM Web Portal.
• Used Rational Clear Case and Clear Quest for managing Test Cases.
• Extensively tested the reports for Data Consistency and validated data with the database.
• Created complex SQL queries for back-end database testing & reports testing
• Performed Positive and Negative tests to check the functionality
• Involved in Requirement Analysis
• Responsible for creating and refreshing test data.
• Documented test scenarios, detailed test conditions, and expected results based on business
• Documented test execution & validation results in Rational Clear Quest defect tracking tool
• Used VSS, Rational Clear Case for checking in and Checking out of artifacts
• Reported the applications defects and worked closely with the development Team to drive defect
resolution.
• Responsible for creating the QA sign-off check list.
• Performed cross browser testing to ensure compatibility of the application on IE and Firefox.
• Participated in client meetings.
Environment: - Manual and Automated testing, Windows 2000, Portal, Seibel, Rational Clear Quest,
Quality Center
ADP (Small Business Services, NJ) Sep 2008 to Mar 2010
QA Tester
ADP, with over $7 billion in revenues and more than 570,000 clients worldwide, is one of the largest
providers of a broad range of premier, mission-critical, cost-effective transaction processing and
information-based business solutions.
ADP Small Business Services provides payroll and business solutions for businesses
Responsibilities:
Status: Permanent Resident (Green Card)
Page 5 of 6
• Working on couple of projects (QRR: - Quarterly Report Reformat testing on IT5 and Quarterly
Print Strategy Reports)
• Review and create test plans and test cases for iSeries
• Responsible for creating and refreshing test data for iSeries environment
• Created complex SQL queries for back-end database testing & reports testing
• Developed and maintained SQL Scripts to extract data from the database
• Involved in writing SQL Scripts to Parameterize the Actions to test Different screens of the whole
Application
• Generating reports to ensure data integrity and validate business rules.
• Performing Manual Testing to test the usability of the application.
• Performing Positive/Negative testing to check the functionality.
• Extensively Using Quality Center for defect tracking and reporting (logged defects, change
Requests, recorded defect details, assigned severity and reported defect status).
Participating in project design meetings to understand the impact of the changes being developed
Environment: Quality Center 10, SQL Server, Rational Reqisit Pro Doors 9.2, Clear Quest 7.0.1.5, MS-
Excel, MS-Word,
Capital One, VA Apr 2007 – Aug 2008
Quality Assurance Analyst
Capital One is a diversified bank that offers a broad array of financial products and services to consumers,
small businesses and commercial clients. Capital One, a fortune 500 company is one of top 10 largest
banks in USA based on deposits. The Bank Data Warehouse (BDW) involves the integration of financial
data of the different banks (Chevy Chase, North Fork banks) acquired by Capital One.
Responsibilities:
• Participated in JAD sessions to collect Business requirements.
• Created Test plan and Test Cases based on functional requirements specification documents.
• Conducted Backend Testing using to ensure valid data is loaded into the database.
• Developed database test scripts using database checkpoints and TSL statements.
• Created validation scripts and perform Regression testing of the web service.
• Enhanced the QTP scripts using data table parameterization, various check points etc.
• Tested web applications developed in JAVA, JavaScript and HTML.
• Involved in Black box testing of Application Functionality as per the Business requirements.
• Perform the Gap-Analysis of the Capital One Data Warehouse with the new acquired Banks
Chevy Chase Bank data warehouse during the integration of the former.
• Uploaded the Test cases, Test Results and the Approvals to the Share-point.
• Logged and tracked the defects using Quality Center.
Environment: Quality Center 9.0, Oracle, JAVA, QTP 9.2, SOAP UI, XPath, XQuery, Business Objects
XI R3/R2, TOAD, UNIX, JAVA, XML, MS-Excel, MS-Word, MS Power point, Web Sphere.
Status: Permanent Resident (Green Card)
Page 6 of 6