MALLIKARJUNA VALLUR

858-***-****

acce9s@r.postjobfree.com

Extensive 12 years of work experience in the design, development, analysis and Testing/Quality

assurance of Mainframes, web and client/server based applications. Proficient in testing

applications manually and using automated test tools LOTUS NOTES, IBM RATIONAL

ROBOT, HP-QUALITY CENTER10.x, WINRUNNER, LOADRUNNER, TEST DIRECTOR,

and QUICK TEST PRO9.x. Possesses excellent technical knowledge and strong interpersonal

communication skills.

As a Sr. Tester providing extensive support in Designing Business Requirements, designed

•

Use Cases and Use Case Diagrams using VISIO, Test Matrices, Test Designing, Test

Development, Test Enhancement and Test Execution of applications using WinRunner, Test

Director, Quality Center, and Lotus Notes.

• Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software

Development Life Cycle (SDLC).

• Experience in Insurance Domain and Mainframe testing.

• Involved in meetings to review the requirements as a Test Lead.

• Hands on experience on technologies such as IBM Mainframes, COBOL, JCL, DB2,

VSAM, CICS, PL/1, File-Aid, VSS, CICS, DB2 WORK BENCH, SPUFI, MS-Project, Lotus

Notes, SharePoint, STE and Crystal Reports skills.

• Proficient in obtaining project requirements from user and manager, formulating the

requirements into design specs, preparing system specifications, assigning tasks to team

members, and tracking project progress.

• Good experience in project planning, scheduling, estimation, resource and work allocation,

risk identification and mitigation plan, product delivery and communication.

• Excellent Client Management, Experienced in building effective winning/successful

relationships with both customers and development/testing/support teams.

Efficient in liaising issues with Line Mangers and Project management teams.

•

• Working closely with support teams and deployment of the applications and providing

necessary handover to support teams during pre-post production implementations.

• Excellent Client Management, Experienced in building effective winning/successful

relationships with both customers and development/testing/support teams.

• Efficient in liaising issues with Line Mangers and Project management teams.

• Working closely with support teams and deployment of the applications and providing

necessary handover to support teams during pre-post production

Extensive experience in the Manual/Automated testing and Quality assurance of Mainframes,

•

Web based Client/Server applications on Windows, Mac and UNIX environments.

• Specialized in CRM application Testing, Validation experience including Complete Life

Cycles of new implementations and up gradations

Specialized in development functional Section and plans for Business and Technical

•

Speculation.

Involved extensively in Functional, System, Performance, Integration and Regression

•

testing, both Manually as well as using Automated testing tools including WinRunner,

LoadRunner, HP-Mercury Quality Center, Test Director, IBM Rational Robot, and Lotus

Notes.

Experienced in Designing, Writing and executing different Test Plans, Test Cases, Test Scripts,

•

Test Criteria and Scenarios from basic or high-level business requirements.

Well-versed and strong skills in performing Business Acceptance Testing, User Acceptance

•

Testing (UAT), Database Testing, Content and functional testing of method tools and

associated web sites.

Experienced in Black box and White box testing techniques.

•

Involved in Planning and Translation of Software Business Requirements into test conditions;

•

execution of all types of tests; and identified as well as logged application defects into

Etracker, PVCS, HP-Mercury Quality Center9.x, Lotus Notes and IBM Clear Quest.

Possesses excellent inter personal and communication skills.

•

Education: - Bachelor Of Technology in Electronics and Communications.

TECHNICAL SKILLS

Testing Tools WinRunner8.x, LoadRunner7.x, Test Director7.x, Quality Center10.x, Clear

Case, Clear Quest, Quick Test Professional 8.x /7.x, Silk, Test Quest, PVC

Tracker, Soffront defect Database, IBM Rational Robot, IBM Clear Quest,

Lotus Notes, JIRA,TFS, Microsoft Test Manager

Languages Visual Basic, SQL, PL/SQL, HTML, COBOL, JCL, IMS, C, C++, PL/SQL,

J2EE, Java, UNIX Scripting, XML Scripting, Perl

GUI Tools Visual Basic 4/5/6, Developer 2000

Database Oracle 7.x/8i/9i, DB2, MS Access, TOAD, MS T-SQL 7.0, MS SQL Server

2002, MS Office Professional Suite, MS Project; Microsoft Sharepoint

Reporting Tool Informatica7.x, Cognos Reporting Tool

CRM Siebel Sales, Siebel Communications, Siebel Finance, Siebel Field Service,

Siebel Callcenter7.5, Siebel Tools, EIM, EAI

Operating MS DOS, Windows 95/98/2000, Windows NT 4.0, Windows XP, UNIX

Systems

PROFESSIONAL EXPERIENCE:

Ambit Energy, Dallas, TX

May’13-Till Date

Sr. Software QA

Working as Sr.Software QA on multiple projects like CSystem, BlueNet, Ambit 2013, PowerZone

and Simulcast 2014. As a Consultant, they are able to Sign into CSystem and make necessary

updates as per the requirements. If it is a Customer, they are able to do make necessary updates and

the assigned consultant is able to see the notes in Account History of CSytem. Here we are

following 2 weeks sprint in this Agile environment.

Responsibilities:-

• Attended the business requirements gathering and understand the business flow.

• Designed the test cases using Test Manager of TFS (Team Foundation Server) as per the

approved business requirements.

• Designed the test cases for PowerZone dashboard which is having multiple widgets like My

Dashboard, My Business, Business Tools, Events, Business Presentations and Success Showcase.

• Designed necessary SQL using MS SQL Server 2012 for the necessary test cases.

• Entered the necessary test data on PowerZone and make sure it generated necessary output

and verified them in the backend.

• Made necessary updates on PZ of the necessary consultant and make sure that correct notes are

generated on CSystem.

• Made necessary registration on Ambit registration for Ambit 2013 and Simulcast 2014, make

sure that proper data is generated.

• Tested the applications in each 2 weeks sprint and entered the defects in TFS and assigned to

necessary developers.

• Attended every day scrum meetings and gave updates.

• If the defect fix is immediate, it is pushed to HOT environment and tested. If it passed then

pushed to Production.

• Once application is pushed to production, tested sanity check of Post-Production and gave updates

to QA Manager.

Environment: - VB.Net, C#, ASP.net, HTML, Web forms, MS SQL Server2012, Java Script,

TFS, Microsoft Test Manager

MedAssets Inc., Plano, TX

Jun’12-Apr’2013

Sr. Software QA

Worked as a Sr. Software QA in BI (Business Intelligent) apps Revenue Cycle Analytics (RCA),

SSO (Single Sign Off) and Population Health. RCA is consisting of dashboards which are going to

show to required Hospitals for business analysis purpose for them. Single Sign Off is having

multiple applications so that it is giving required access to the business for analytical purpose. And

Population Health is giving access to the doctors or hospital staff with the existing information of

the patients and their appointments of that hospital. These projects are using by big hospitals with

huge database like Teradata

Responsibilities:-

Interacted with Business Leads, SME’s and business analytics while designing the test

•

requirements.

Designed test requirements, test cases and necessary SQL queries.

•

RCA is having multiple drill downs for each Dashboards (Access, Billing, Account

•

Receivable, Financial and Denials) and designed SQL queries for each drill down.

Designed test cases for both UI and backend testing.

•

Reviewed SQL queries and UI test cases with Business Analytics and Development team.

•

Used Microsoft SharePoint to store the test requirements, test cases and SQL Queries.

•

These projects used by Hospitals with Teradata databse.

•

Here we are using Agile Methodology to test the applications.

•

Population Health application is consisting of Readmissions, Care Management, Transition

•

Planning and Care Management Mobile.

This application is showing the progress of the Patient admission to discharge and

•

Readmission also.

Care Management application is giving access to Physicians who are going to travel to the

•

patients place for treatment.

Care Management Mobile is having road map to the patient location.

•

Population Health is giving easy access to the Physicians and Hospital Staff.

•

Single Sign Off (SSO) is giving access to the required applications necessary for the

•

facilities, which are acquired by the client and includes all the applications which are

developed by MedAssets for use.

Coordinating with the development team in explaining the defects in detail.

•

This application is developed in Agile methodology of 4 weeks iteration, tested the

•

application and tested the defects which are fixed in that release.

Environment:- Java,J2EE, Cold Fusion, MS SQL Server 2008, MS SharePoint, Rally.

JC Penney, Plano, TX

Jun’11-May’12

Sr. QA Analyst

Worked as Sr. Software QA in JC Penney in Digital Platform International Expansion eCommerce

project which is biggest retail business expansion. This project has nearly 11 systems which are

incorporate this project. Currently this project is going internationally around 120 countries. The

customer can buy JC Penney products which are available for sale, with the eligible discounts for

products which are available.

Responsibilities:-

• Discussed with the business leads & business analyst while designing high level business

requirements.

• Attended the meetings while designing low level requirements.

• Designed Master Test Plan as per the approved business requirements and presented to the

respective teams for approval.

• Designed Test Requirements in HP-Quality Center v10.0 as per the approved business

requirements.

• Designed Test Cases as per the approved Test Requirements for both System Test for all the

modules & End-End Testing.

• Lead a team of 5 testers and coordinated with them at the time of testing.

• Executed the test cases when the application is released for testing.

• Entered the defects in HP-Quality Center, assigned to the respective team member to fix and

used Microsoft SharePoint to store Master Test Plan, Business Requirements and respective

wireframes.

Coordinated in everyday meeting with the offshore team regarding the System & End to

•

End testing.

• Explained the defects to the developers if they need clarification.

• Coordinated with test leads of all modules which involved in this project.

Environment:- Java, J2EE, Oracle10g,Endeaca, Mainframe, Microsoft SharePoint, HP-

Quality Center v10.0, SAS

State Farm Insurance Company, Bloomington, IL, USA

Sr. QA Analyst

Jan’10 – May’11

Data Warehouse in the State Farm Insurance one of the Biggest Insurance provider implemented

by providing the data from different domains and this is referred as Source and Federated Data

Warehouse (FDW). Worked on different projects like Driver Assignment, Risk Chaining & Driver

Assignment Refresh, Monthly Balancing Reports, Auto NECHO Enhancement II, UAX/Internet

Auto Rate Quote. The current environment is combination of Legacy sourced and Domain sourced

methods of providing data to FDW. The Source and FDW use the same Business Architecture in

following the Insurance Application Architecture (IAA) model, where as each Legacy system

defined its own model and definitions. FDW provides huge amount of data within State Farm for

different Marketing activities along with facilities like planning of resources for better results. FDW

is one of the biggest Data Warehouse ever constructed in any company worldwide. The Enterprise

Accountability Data Mart facilitates the proper management and planning efforts in maintaining the

Policies in Force and its expenses for underwriting purposes of the State Farm organizations. This

application is built using ETL product of GENEVA/SAFR & Informatics.

Responsibilities:

As a Sr. QA for Testing, responsible for:

• Distribution of the tasks to the team on priority base.

• Participate in customer meeting on different requirement baseline.

• Worked with Business Users and UAT team during various phases of the project

• Interacted with the Business Users for clarifications and requirements.

• Regression test suite preparation for regression testing of the application. Developed

the product using the Software Development Life Cycle methodology.

• Here we used both Agile and Waterfall methodologies.

• Involving every Scrum meetings for the various projects.

• Responsible for develop Test Estimations, Test Strategy, Test Plans, Test Cases and

involvement in peer reviews of documents.

• Responsible for testing the application developed using JAVA, J2EE, COBOL, CICS, JCL,

DB2, PL/I, VSAM, GENEVA/SAFR.

• Logged the bugs; preparing the bug cards and tracking the bugs in the application.

• Establish Quality Procedure for the team and continuously monitor and audit to

ensure team meets quality goals.

• Responsible for Knowledge Transfer to the team.

• Finding the Root Cause Analysis based on the defects logged during testing the

applications and providing Permanent Solutions.

Coordinating with the Implementation team and Release team before pushing the project to

•

Production.

Supported the Service team. Helping this team if any defects are there in Production.

•

• Pre & Post implementation testing support for new/enhancements of the software products.

Environment: JAVA, J2EE, JRF,COBOL, CICS, JCL, DB2, Assembler, PL/I, VSAM,

ENEVA/SAFR, File-Aid, Platinum, SPUFI, Control-M, Control-D, STE, SAS, Z/OS, Clear

Quest, SharePoint and Lotus Notes.

Merck, West Point, PA Oct’07 – Dec’09

Sr. QA Analyst

Worked as Sr. Software QA Analyst for testing the multiple applications belongs to Consumer

Database. In this the two main projects are Januvia Harte Hanks, and Singuliar RMI project. Here

Lead team of 5 testers. These projects are based on ECMP (Email Campaign). Here the customers

enters into these products through different sources and as tester it is our responsibility to test that

the application generates correct email and correct Fulfillment Package Codes and sent them to the

right customers in timed emails. Here involved in testing the other projects like Vytorin, Gardasil 3

Is Key (English), Gardasil 3 Is key (Spanish), Januvia Cookbook Offer, and Cordaptive etc.

Responsibilities:

Involved in SDLC (Software Development Life Cycle) process.

•

• Designed the Use Cases as per the approved business requirements by interacting with the

Business Users, SMEs and Project Holders.

Designed the test requirements as per the approved specifications.

•

Designed the test plans for major projects as per the approved functional requirements.

•

Maintain them as per the approved test standards.

•

• Designed the test case documents in MS Excel and Mercury Quality Center for Integration

and System Testing.

Designed the Test Data document as per the requirements.

•

Designed the XML file as per the XML requirements.

•

Tested the data validation for the files of Januvia Harte Hanks and other projects.

•

• Independently involved in writing the test plans, test requirements and test cases & executed

them.

Involved in writing the reports and informed the development to the Project Manager.

•

Developed the necessary SQL for testing purpose.

•

Generated the test reports once the testing phase is completed.

•

In this project there are major files to test the data validation.

•

• At first when customer enters into the Januvia site and enter their required information.

• This is the file HH01 generated by the Merck and Harte Hanks picks up this file from the

Merck FTP server everyday and segmented them using their logic and send the email

records in HH02 file to Merck, then Merck blast emails to those customers as per the

required Fulfillment Package Codes and acknowledgements to Harte Hanks in HH01 file.

• The Direct Mails are going to send by the Harte Hanks and then they will send the direct

mail acknowledgements file to Merck.

In other project Singulair RM Program as a Test Lead, designed the XML files and Test Data

•

files.

As per the functional requirements designed the test requirements and test cases.

•

Designed the test cases as per the Q&A, Source Codes, and Fulfillment Package Codes for

•

the required Timed Emails.

Tested the application and verified that whether it generated the correct Source Codes and

•

Fulfillment Package Codes for the required Timed Emails in the back end (Oracle Data Base) as per

the requirements.

Wrote the defects in the defect tracking system and informed to the respective developer.

•

Involved in the regression testing and verified the application in the production also.

•

Environment:- Java, J2EE, VB, Oracle9i, Toad, XML, Perl, IBM Clear Quest, MS Excel, MS

Project, Mercury Quality Center8.x.

Merrill Lynch, New Hopewell, NJ Mar’07 – Sep’07

Sr. QA Analyst

Worked as Sr. QA analyst for testing the application Client Data Governance. In this application

there are two Pre-landing sources, two Target sources and one hub. One is Account Level Data

reports and Profile Level Data Reports. This application is having around 300,000 records and

merged the records with the same entities and eliminated the duplicates. In this application involved

in testing the complete ETL processes for all the modules.

Responsibilities:-

• Interacted with the FA’s, SME’s and Business Users.

• Involved in SDLC process, designing the Business Requirements and Functional Requirements

by interacting with the business users.

• Designed the Traceability Matrix, Test Plans, and Test Cases for different modules.

• Wrote the test cases to two areas of this application for Integration and System Testing.

• One is with verifying the counts of the required records and its translation and the other one is

Sample Data Inspection (SDI).

• Wrote the test requirements and test cases for both Straight Move and Derived fields in ETL

process.

• Ran the necessary SQL queries using MS SQL Server.

• Executed Reporting MS Access and verified the Reports.

• Participated in test planning, test requirements, and test case design walkthroughs with QA

Manager. Participated and contributed to the QA Design.

• Involved in project schedule and test execution.

• This is Front end application testing.

• Using Cognos Reports tested the application for different entities.

• Using IBM Rational Robot Wrote the Test Cases and IBM Clear Quest to write the defects.

• Captured the necessary screen shots for the defects and explained to the developers and

Reporting team.

• Tested the fixed defects and informed to the responsible developer.

Environment: - Java, Web Sphere, XML, Informatica, Cognos, MS SQL Server 2003, MS Project,

VISIO, IBM Rational Robot 2003, IBM Clear Quest, MS Excel 2003.

JP Morgan Chase Systems & Services Technology, St. Joseph, MO Mar’06- Feb’07

Sr. QA Analyst

As Sr. QA Analyst involved in gathering the functional requirements, by interacting with the SME’s,

and Business Owners. Developed the Business Requirements, Use Cases, Use Case Diagrams, Test

Plans, and Test Scripts as per the approved requirements. Here we used the tool Mercury Quality

Center 8.3. This project is CUNA (Credit Union of North America). Most of the credit unions will

give the auto loan cases to this organization for the Claims, Repossession, Remarketing, Bankrupt,

Collections etc.

Responsibilities:

• Interact with the Business Users and SMEs and developed the Business Requirements using

Quality Center.

• Involved in Software development Life Cycle in designing the business requirements.

• Developed the Use Case Diagrams, Activity Diagrams using VISIO.

• Designed the Testing Project Plan using MS Project.

• Developed the test requirements, test plans and test cases as per the approved business

requirements.

• Developed test cases for the Claims, Repossession, Remarketing, and Borrower & Co-

borrower.

Involved in developing the Functional test cases and Regression test cases.

•

Involved in developing Schema test cases for the backend testing using MS SQL server.

•

Ran the necessary MS SQL queries and verified the data.

•

• Tested the application and informed the developers, if there are any show stopper defects

and entered the defects in the testing tool Quality Center and informed to the respective

developers.

Captured the screen shots of major defects and lake sure that the respective developer

•

understands the severity of the defect.

Coordinating with the UAT team and helped them in testing the application.

•

Gave the demo of the application to the users.

•

Involved in the best interest of the user and also the CLIENT.

•

Involved in Sign-Off of the application before going to Production.

•

Environment: - Delphi5.0, C++, Informatica, MS SQL 2003, Crystal Reports, MS Project,

Mercury Quality Center 8.3, and Visual Source Safe.

Home Depot, Austin, TX Apr’05 – Feb’06

Senior QA Consultant

Worked as a Sr. QA Analyst for the web based Homedepot.com project. Responsible for developing

the test requirements, test plans and Test Cases using the Mercury Tool Test Director 8.0.Here lead

a team of size 5 testers. Responsible for developing the test scripts for the modules Member, Gift

Center, Order, Catalog and Merchandise & Promotions. This site is very useful for the user to

purchase the required item(s) and ship them to the required address and this site provides the Home

Depot Gift Cards also, so that the registered member can send to the required people.

Responsibilities:

• Interact with the business analysts and respective developers, wrote the test requirements for

all the modules from the approved business requirements.

• Used Microsoft Excel to write the Test Plans and Test Cases.

• Designed the XML document as per the approved specifications and executed them.

• Wrote the necessary SQL Queries for the required test cases to test the backend SQL server.

• Ran the necessary SQL queries and verified the data verification.

• Used the Test Director to enter the defects and assigned to the responsible developer.

• Captured the screen shot for the defects which not reproducible immediately, so that the

developer understand the defect.

• Attended the weekly meeting with the developers and coordinated with them, explained

them and take priorities from the leads, coordinated with our team to prioritize them.

• This application is developed using Web Services.

• Wrote the test plans and test cases for UAT also.

Environment: - JAVA, ENDECA, XML, UNIX, SQL Server 2003, J2EE, Web Services, MS Excel,

Microsoft Project and Test Director 8.0

Merck & Co., Inc., West Point, PA May’04 – Mar’05

Senior QA Consultant

As a Sr. Software Quality Assurance /Tester is responsible for developing test plans, test scripts

using the testing tool Test Director 7.6. Interact with the developers to understand the flow of the

application. Involved in developing test plans for two projects, (1) MV.com and (2) Consolidated

Telephony System. Tested the applications and informed the defects to developers.

Project 1: MV.COM

Responsibilities:

Involved in SDLC process by interacting with the business people.

•

Developed the test plans and test cases to test the complete application.

•

Involved in developing the automated test scripts for functional testing and UAT.

•

• Ran the necessary SQL queries and verify that proper data is displayed in the backend

testing.

• All manual test plans; test cases are developed in the testing tool Test Director and in MS

Excel.

•Inform the development of the test plans as per the schedule to the project lead in the weekly

meeting and reach the target as per the schedule.

• Run the required test scripts as per the new release and inform the defects to Project Lead.

• Enter the defects in Clear Quest tool and assign to the specific developer.

•Rerun the test scripts again in the specified release version and enter the comments in the

defect database.

Environment: Project 1: - JAVA, J2EE, MS SQL Server 2000, Test Director 7.6, MS Excel, Clear

Quest and Clear Case.

Project 2: Consolidated Telephony System.

Responsibilities:

Interact with the Business Analysts and Developers to understand the flow of the

•

business and finalize the test requirements and wrote the test requirements matrix, from the

approved software business requirements.

Designed the test plans document, discussed with the other testers and

•

finalized the test plans document.

Whenever there are any modifications or approved addendums for any area

•

of requirements, wrote the test requirements, test plans and test cases as per the approved

specifications.

Wrote the test plans and test cases for Smoke Testing.

•

Whenever the new version of Software is released, ran the Smoke Testing

•

(Build Verification Testing).

If there are no critical defects, that software version is released for

•

Functional Testing and System Testing.

Enter the defects in the defect tracking tool Clear Quest and assigned to the

•

responsible developer.

Attended the weekly team meetings and discuss with the test team members,

•

the progress of the testing. Co-ordinate with them to complete the testing in stipulated time and

submits the report to the Team Lead.

Involved in User Acceptance Testing (UAT) and informed the progress of

•

the testing to the team lead.

Rerun the defects in the mentioned software release, close the defects and if

•

necessary make the necessary comments in the defect tracking system.

Environment: Siebel 7.5.3, SQL Server 2000, MS Excel, Microsoft Project, Test Director 7.6,

Clear Quest and Clear Case.

AT&T, NJ Jan ’02 to April ‘04

Software Quality Assurance Tester

As a Software Quality Assurance/Tester (AT&T Billing)) is responsible for System, Pair,

Integration, Volume and CBFIT (IFT) Testing working for the CDMS, O&P & Workflow Testing

District. Also, worked with the Production support group, created numerous documents, analysis

and reporting of daily Production.

Responsibilities:

• Prepared Data Conversion Quality Approach Document for all KDE’s.

• Prepared test plans for all the key data elements in CIM (Customer Information

management) Module.

• Written automated test scripts for all the modules in the Application, and used these scripts

for testing database-using WinRunner. Given certain checkpoints and Synchronization points to

see how the application is reacting. Performed Functional and Regression Testing utilizing

WinRunner Test Scripts.

• Wrote SQL, PL/SQL queries to access the data from the database tables and crosscheck the

results.

• Made decisions being a part of the Data Quality Task Force regarding the Conversion (QA)

for records with data problems by plugging values for the data load Review Change Control,

Review bug fix requests/status.

• Involved in maintaining the WinRunner test environment, Test script, GUI map files and

wrun.ini files

• Generated automated test scripts using TSL of WinRunner based on the functionality

requirements for each module for testing the site.

• Executed the test scripts on different releases and validated the actual results against the

expected results. Debug the Test Scripts, created Batch tests, verifying the Test results and

reporting the defects to Test Director.

• Created scenarios for Load Testing and setting up the Test Environment & creation of Test

Data.

• Developed scripts in Load Runner to generate Vusers.

• Conducted Performance, Volume and Stress testing using Load Runner.

• Conducted tests to Identify bottlenecks using Load Runner.

• Scripted and executed the Test Cases for the Application using WinRunner.

Environment: SQL, PL/SQL, WinRunner 7.5, Load Runner 7.5, PVCS Defect Tracking System,

Windows NT/2000

Contact this candidate