Padmavathi Makkena

acn9pu@r.postjobfree.com 214-***-**** ©

Summary

• Over 7 years of diversified experience in the IT industry in the areas of Software

Quality Assurance Testing.

• Good understanding of Software Development Life Cycle (SDLC), CMM Level 5,

Methodologies and Validations to ensure complete Quality Assurance

• Excellent in creating/executing Test Plans, Test Cases, Test Scenarios, Test

Scripts, Test Reports and documentation for various types of testing like -

Functional, Integration, GUI, Usability, Database, Security, User Acceptance,

Regression and others

• Experience in Manual and Automated testing. Extensively used automated test tools

like QTP and Quality Center.

• Experience in reviewing and analyzing the Business requirements and functional

specifications

• Experience in Business Requirement Specification Analysis, Preparing System

Test Plans, Test Cases, Test Scripts and Execution

• Excellent in Test data preparation, User Acceptance Test Plan.

• Experience in complete Testing Cycle of waterfall and V-Model

• Experience in Setting up Defect Life cycle Management processes to ensure

compliance with internal and external audit requirements

• Excellent communication skills, self-motivated, detail oriented, time bound,

responsible team player and ability to coordinate in a team environment

• Very good domain expertise in Finance, Banking and Healthcare domains

• Experience in ETL validation, Data Model Validation.

• Extensive experience in Data Migration

• Extensive experience with Data warehouse applications.

• Strong Problem Analysis and Resolution skills and ability to work in Multi-Platform

Environments like Windows, Mainframe and UNIX

• Strong skills in back-end testing using SQL Queries on SQL SERVER, Oracle, DB2,

MS Access

EDUCATION:

Colleges Attended:

• Bachelors of Science in Electronics and Communication Engineering, Bharathiyar

University, 2001

PRESENT POSITION:

Verizon, Richardson, TX Nov 2013 – Till Now

Quality Assurance Tester

Description:

MASTARS: The Verizon Change Management Application. The Maintenance Activity Scheduling

Tracking and Reporting System. The MASTARS application is designed to accept schedule maintenance

information for equipment from authorized users of Verizon Business organization, validate the

information entered, save the information to database, and pull customer impact for the equipment

entered. This process is supported through both user-to-system interfaces and system-to-system

interfaces. Therefore maintenance requests may be received by the system from either human beings or

through automation.

This project permits OASIS-NM to make use of MASTARS customer impact pulling process as well as

GNS notifications by using different MASTARS interfaces (Web Services) to support multiple operations

such as request creation, request query, customer impact information, etc. as requested by OASIS-NM.

Responsibilities:

• Reviewed requirements documented by Business Analyst for thorough understanding of the

application.

• Experience with Software Development Lifecycle (SDLC) and processes for software testing /

quality assurance guidelines.

• Reviewing of business requirement, design documentation for completeness and testability

• Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary

Reports and Test Execution Metrics.

• Testing included Environment, System, Function, Regression, Performance, User

Acceptance testing.

• Experience in document traceability of requirements to tests and capture evidence of test

pass/fail.

• Effectively communicated testing activities and findings in oral and written formats.

• Extensively used Oracle SQL Server for data integrity testing at the backend.

• Created Test Cases using the SDLC procedures and reviewed them with the Test Lead.

• Executed all the Test Cases in the Test Environment and maintained them and documenting the

test queries and result for future references.

• Using web services validated the output XML files.

• Retested the modifications, once bugs are fixed after reinstalling the application.

• Performed test execution for End-to-End Business Process Testing.

• Identify/debug, troubleshoot, modify, document, test the production issues and create

production support schedule.

• Executed the regression suite using QTP.

• Reported the bugs through email notifications to developers using ALM.

• Direct hands-on experience with and automated testing tools.

• Extensive Experience in working with ALM.

Skills Utilized:

• JAVA, J2EE, Share Point, Oracle SQL Server, HP-UNIX .

• HP ALM- Quality center 11.2

• MS Access, Windows 7, Web Services, Soap UI 4.6.3, Web logic, Windows XP.

PRECEDING POSITION 1:

JC Penney, Plano, TX Apr 2011 – Sep 2013

Sr. ETL Tester

Description:

Item Setup (ITSA) is to create a new item setup application (front-end), database (back-end) and data

services to support enterprise item management. ITSA will become the Enterprise Item Master, replacing

the Legacy Item Masters (PDB, MIDB, and CMS). Stand up data base converting all data from

PDB/MIDB/CMS including an ongoing sync process. Application available for Item and Reference Data

Maintenance. Rollout will be by MAT. This will introduce a backfill to Legacy Item Masters. Sync from

Legacy Item Masters will continue for MATs using PDB

Responsibilities:

• Reviewed requirements documented by Business Analyst for thorough understanding of the

application.

• Experience with Software Development Lifecycle (SDLC) and processes for software testing /

quality assurance guidelines.

• Developed Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test

Execution Metrics.

• Involved in writing Complex queries using SQL for Data Integrity checks.

• Participation in Requirement / Use Case analysis, Risk analysis and configuration

management.

• Experience in Test Informatica ETL processes by confirming data integrity between data sources

utilizing Informatica Power Center.

• Created Test Cases using the SDLC procedures and reviewed them with the Test Lead.

• Executed all the Test Cases in the Test Environment and maintained them and documenting the

test queries and result for future references.

• Retested the modifications, once bugs are fixed after reinstalling the application.

• Developed presentation and testing implementation learning to other testing resources for cross

functional training.

• Validating the Data files from source to make sure correct data has been captured to be loaded

to target tables.

• Validating the load process of ETL to make sure the target tables are populated according the

data mapping provided that satisfies the transformation rules.

• Validating Informatica mappings, workflows, sessions and Jobs.

• Validate the XML files and accurate the Data.

• Actively participating in project specification reviews, writing and maintaining QA technical

documentation.

• Execute Business process tests and report results in Quality Center.

• Performed test execution for End-to-End Business Process Testing.

• Identify/debug, troubleshoot, modify, document, test the production issues and create

production support schedule.

• Participated in reviews of code walkthroughs, data models, and design documents.

• Reviewing of business requirement, design documentation for completeness and testability

• Effectively communicated testing activities and findings in oral and written formats.

• Testing included Unit, System, Function, Regression, Performance, User Acceptance and

Business Objects reports testing.

• Experience in document traceability of requirements to tests and capture evidence of test

pass/fail.

• Reported the bugs through email notifications to developers using Quality Center.

• Very good Experience in Agile methodology, Sprints and Iteration process.

• Extensive Experience in working with Quality Center.

Skills Utilized:

• Informatica 8.6, JAVA, J2EE, Share Point, HP-UNIX, TIBCO, Micro strategy.

• DB2, TOAD, Oracle.

• Mercury Quality Center 10.0.

• MS Access, Windows 7, Web Services, Soap, Web logic, Windows XP.

PRECEDING POSITION 2:

Buccaneer, Owing Mills, MD Jan 2009 – Mar 2011

Client: Centers for Medicaid and Medicare Services (CMS)

Software QA Tester

Description: Marx is an application that validates beneficiary requests and, if the requests are valid,

enrolls (and disenroll) beneficiaries in managed care plans and prescription drug plans offered by

Medicare-approved contractors (“Plans”) throughout the country. Each month, Marx calculates Medicare

payments for each contractor, summarizing the enrollment and adjusting payments for changes in

membership and beneficiary status. Marx also exchanges information about enrollees, contracts and

payments with Medicare beneficiary Database (MBD), FACS etc. for controlling the payments made by

Centers for Medicare & Medicaid Services (CMS). The User Interface (UI), or online portion of the Marx

application, is available to plans for viewing data, submitting batch transactions and researching

problems.

Responsibilities:

• Involved in preparing the detailed Test Plan based on the User Requirements Document.

• Analyzes business and technical requirements, developing strategic Test Plans, Test Cases and

Test Procedures and responsible for executing the Test Cases.

• Identify additional test cases required to cover existing functionality.

• Performed Functionality Testing via in batch and online processing.

• Verified enrollments services and payment services after transactions were submitted via

batch/UI

• Submitted batch jobs (TSO, JCL’s) to generate daily, weekly and month end reports.

• Verified data integrity in various reports among various systems.

• Performed SQL querying to validate the data in the back end DB2 data base, and also to check

the data flow between different Systems

• Extensively used DB2 tools – QMF, SPUFI and BMC to execute queries and data manipulation if

required.

• Preparing test data files using File –aid.

• Created, modified the Data in the Data Sets (Sequential Files) in order to create test data for

batch jobs.

• Used CICS (Customer Information and Control Systems) for online transactions.

• Conducted Regression testing as and when new builds were coming.

• Performed Regression Testing of the web-based application.

• Created a TIR in QC when defect found in testing.

• Participate in weekly meeting with the management team and walkthroughs.

• Responsibilities include meeting with Requirements Analysts (RA), developers and client groups

to determine performance requirements and goals, determine test strategies based on

requirements and architecture.

• Supported various releases with tight schedules and worked on weekends and nights to support

deployment verification.

• Handled the defect resolution calls between testing and development teams

• Coordinating with the development teams to enhance the scalability, performance and tuning of

the application.

Skills Utilized:

• Java, J2EE, XML & JMS, MQ Series, COBOL, JCL, File –AID, IOF, ISPF, CICS, SPUFI, QMF,

BMC, VSAM, MVS, QC10.

• DB2, Oracle 9i

• Windows XP

PRECEDING POSITION 3:

Care First (FEP OC) Blue Cross Blue Shield, Washington, DC Oct 2007 – Dec 2008

Software QA Tester

Description: The Basic Consumer Option is a High Deductible Health Plan (HDHP) with a tax-favored

Health Savings Account (HSA) or Health Reimbursement Arrangement (HRA). It offers the affordable

premium as the Basic Option Product, while providing members with more control over how they spend

their health care dollars, as well as an opportunity to save for further health care expenses with a tax –

free HSA or HRA.

Responsibilities:

• Involved in preparing the detailed Test Plan based on the System Requirements Specification

(SRS) Document

• Involved in Business Requirement analysis meetings with BAs, Plans and Users

• Performed Functionality Testing via in batch and Online-UI processing

• Extensively used QMF or SPUFI to write queries to verify the population and validation of the

data in the backend

• Run Batch JCLs for Enrollments.

• Involved as part of automation team using QTP, executed test scripts.

• Co-ordination with test team for data modification requests made by plans

• Created Team Tracks using Serena Team Track for all the issues sent by the plans through Test

inbox, Outlook and Fax.

• Generate the Defect Report for Basic Consumer Option and send it to every day to Test Engineer

Group and The Directors Office.

• Participated in weekly Pilot Plan Conference meeting with the management team.

• Prepared the Test Certification Close out Document at the end of each release for Auditing

Purpose.

• Developed Reports for the defects found in testing for various plans

• Created flat files in the required format using File-Aid for various applications.

• Supported various releases with tight schedules and provided support deployment verification.

Skills Utilized:

• Java, HTML, MVS, TSO/ISPF (Reflection Client), COBOL, JCL, CICS, File-Aid, FILE-AID,

QMF, FTP/IP, BMC, SPUFI

• DB2, Oracle 9i

• QTP, Quality Center

Contact this candidate