Testing Customer Service
Resume:
PURNIMA MUSKULA
E-mail: ***************@*****.***
Summary:
. Over 9 years of experience in testing of web based, mainframe and
client /server applications
. Worked in Finance, Investments, Banking and pharmaceuticals.
. Lead the testing effort for a particular release by creating an
overall testing strategy plan, estimating testing effort, scheduling
lab resources, and resolving conflicts.
. Proficient in both Manual Testing and Automated testing with Mercury
interactive tools like QTP, Load Runner, Win Runner, Selenium and Test
Director.
. Provide leadership role in analyzing - Business requirements and
testing.
. Expertise in writing test cases, executing of test cases, creating
business requirement specification, functional specifications and
design documentation with better understanding of Software Development
Life Cycle (SDLC), Waterfall & Agile.
. Proficient in GUI, functionality testing, black box testing, Build
verification testing, Regression testing, Integration testing, System
testing, and UAT.
. Execute regression suites to ensure integrity of previous feature
sets.
. Identify product defects, write associated Team Tracks, and verify
that the issues are resolved.
. Manage the weekly test status meetings and reporting to the management
. Excellent communication, interpersonal skills and team player
. Expertise in running the ETL programs, analyze and coordinate
resolution of program flaws during testing.
. Executed Informatica Workflows, to load data from the interim Oracle
database, onto the ETL target Flat Files from various Sources to Stage
. Participate in the maintenance of test process documentation and test
plans
. Responsible for the ETL build validation process on an ongoing basis
. Identify and log defects if/when a test fails, if necessary, using SQL
to narrow down the root cause of the problem for efficient
investigation by the development team and log accordingly
. Participate in stress testing activities, in collaboration with the
development and production teams, to ensure satisfactory performance
of both ETL processing and end-user reporting
. Document test results and defects in Quality center
. Possess Strong analytical skills and work independently as well as in
a team.
Education:
MS in Computer Applications from Kakatiya University, India
BS in Mathematics, Statistics and Computer Science from Kakatiya
University, India
Technical skills:
Operating Ms-Dos, UNIX, Windows 95/98/2000/XP/NT and MVS
Systems:
Ms Tools: Word, Excel, PowerPoint, Access, Visio, Project
Languages: COBOL/370, MS COBOL-II, JCL, JAVA, PL/SQL, C, C++, HTML
and DHTML
RDBMS Packages: Oracle 9i, Oracle 8i, Oracle 7.X, Oracle 6.0, DB2.
GUI's Tools: Developer 2000 Suite, Visual Basic 6.0.
Reporting Tools: Oracle Reports
Testing Tools: Win runner, Load runner, Test Director, Quality Center,
QTP & Selenium
Professional Experience:
State Teacher's Retirement Systems Columbus, OH
January 2007 - March 2010
V3 Benefits Administration System: The V3 Benefits Administration System is
a solution designed specifically for the needs of Public, Taft-Hartley and
Multi-Employer benefit organizations. It is a proven, browser-based
application that employs contemporary Oracle/Java technology and includes
native Imaging, Workflow, CRM/Call-Center and Self-Service capabilities. V3
addresses core business requirements including enrollment and demographic
administration, payroll reporting, contributions processing, service credit
purchases, refunds, buy-backs, pension calculations, eligibility
calculations, health claims adjudication, benefits disbursements,
participant communications and much more.
. Responsible for gathering testing requirements as well as to
articulate current testing issues to the concerned developers
. Write detailed test cases and test scripts to test conditions for
various front and back-end functionalities.
. Identify and prepare test data necessary for the test cases and
scripts
. Validating the staged and converted data using SQL.
. Responsible for systems, integration and regression testing by
executing test scripts and test cases testing in all the environments.
. Responsible for conducting weekly meetings with the client and off
shore team.
. Responsible for providing daily status of issues and progress made
during test execution and general application testing.
. Responsible for leading the testing of Data conversion from legacy to
V3.
. Training and mentoring the new hires.
. Automation using Selenium
. Performed manual regression testing ensuring proper functionality
after ever deployment.
. Gained knowledge in the applications involved in Pension.
. Ensured the standards and procedures are established and adhered to
SDLC for planned software changes.
. Performed User acceptance testing in conjunction with the users.
. Extensively worked on handling the application response for Positive
and Negative testing.
. Involved mentoring for the new associates in the applications and
follow the life cycle, helped to catch up to the pace.
Environment: Oracle, Java, Mainframe, Share point, Win XP, Selenium.
Nationwide, Columbus, OH
April 2006 - December 2006
Prosper: Improve efficiencies by establishing and automating business
processes between the front, middle and back offices, as well as between
the Office of Investments and other Nationwide business partners by
creating data centric foundation and establish strict data management
practices to ensure clean and consistent data which will increase
analytical and reporting capabilities, and reduce operational risk.
. Responsible for leading the effort of testing data extracted from
various Sources to Stage using Informatica, Validating staged data for
processing/converting/lookup using SQL, generate text files and upload
the transformed data into Eagle Data Hub a vendor specific data
centric running Manual and Maestro process.
. Review technical design, help define functional requirements, provide
end-to-end test solution, feedbacks to Analysts, management
. Define entrance exit criteria of a test plan execution.
. Responsible for writing & executing test plans and having it sign off
for acceptance by end users, stake holders.
. Use Quality Center to write/update test cases, tracking defects and
executing test cases.
. Generating the Test Data for positive /negative testing.
. Involved with all aspects of testing like regression testing, system
testing, Integration and end-to-end testing.
. Responsible for white box, black box, system and regression testing.
. Communicate/Set expectations to Test Team members and provide
performance feedback to upper management.
. Tested the Applications using Agile Methodologies
. Interacted with Developers on Defect Analysis.
. Extensively used SQL Queries for Database Testing.
. Adhoc queries to perform data reconciliation from source to target.
. Ran ETL flows in System Testing, Pre Prod to perform End 2 End
testing.
. Performed Regression testing to make sure changes have to affect the
existing application.
. Executed test plans for manual and automated testing and managed
document and track bug report.
. Extensively used SQL Queries for Database Testing
Environment: Oracle, Informatica, Teradata, vendor specific Eagle
DataHub, Mercury Interactive - QuickTest Pro, Quality Center, Harvest,
Maestro
Key Bank, Cleveland, OH
November 2005 - April 2006
Anti Money Laundering: This project is been developed to detect the fraud
in the Bank transactions as per the FBI regulations. Key Bank has been
partnered with Mantas Corporation to detect the scenarios of such behavior.
MANTAS is the money laundering application that is used by the Bank to
monitor money laundering as a part of the Bank's compliance program
. Developing Test scripts for validations.
. Involved in Unit, System and Integration, and User Acceptance Testing
. Used Quality Center for Coding, testing, debugging, documenting,
recording
Tests and reporting bugs in the modules
. Developing SQL queries to retrieve data from the tables
. Used File aid to retrieve particular records.
. Used JCL to extract the data by submitting the jobs.
. Used Change man to retrieve previous generations of module.
. Developing DB2/SQL queries to compare expected results in Mantas Data
against Hogan data and CPCS data
. Coordinated the testing efforts with UAT (User Acceptance Testing)
team and resolved their findings on the application.
. Automating the test scripts using Quick Test Pro and terminal
emulator.
. Maintaining the documents in PVCS
. Assessing testing processes, creating, implementing testing
strategies and SQA strategies using Agile-testing methodology.
. Interacted with developers at all stages of the testing life cycle.
. Extensively worked on handling the application response for Positive
and Negative set of data using Data Driven Testing.
. Researched the Test Cases in the Application before posting the
Defect.
. Played a critical role in the Planning, Coordination and
Implementation of QA Methodology for the Investment Projects.
Environment: IBM Mainframe, Hogan, CPCS, SPUFI, Quality center, QTP, Web
sphere, PVCS
Nationwide, Columbus, OH
July 2005 - October 2005
Finance Focus: This project is been developed to bring the entire data
structures and the flows for Nationwide and its affiliates. The goal of
FOCUS testing is to ensure that the business Process, and the technology
that supports them, work from end-to-end. Various Tests are used to
demonstrate that Focus Components and processes are capable of producing
required finance deliverables on a timely and reliable basis.
. Developing Test scripts in the quality center for system test
. Executing validations of every logical step within their integrated
back office
. Oracle ERP validations.
. Developing test cases to support functional and nonfunctional
process requirements
. Automating tests for verification of data propagation with QTP
. Scheduling jobs with Maestro.
. Execution of UNIX Shell Scripts and Informatica jobs.
. Work with the development team to create a suite of test data (both
input files and expected results) that fully exercises data
validation and actual ETL functionality
. Testing data generation with Kalido.
. Wrote PL/SQL statements to check the validity of database and to do
backend testing.
. Used Quality Center for Coding, testing, debugging, documenting,
recording
The tests and reporting bugs in the modules
Environment: Quality center, UNIX, QTP, ERP, Teradata, Kalido, Informatica,
Hyperion, Maestro.
PharmaCare, Chicago
January 2003 - June 2005
PharmaCare is a Pharmaceutical Benefits Manager or PBM who has many members
and various facilities for members. Currently Pharma Care's operations are
backed by legacy system running on AS/400, which is mostly operated by
Pharma Care customer service representatives, clients etc. This new Web
Site will provide various information and facilities to the members and
clients including the functions that are supported by the host systems.
. Automating testing for verification customer information with Win
runner.
. Keeping track of errors using Test Director.
. Categorized bugs based on the severity and interfaced with
developers to resolve them.
. Wrote PL/SQL statements to check the validity of database and to do
backend testing.
. Writing Test Plans, Test Scenarios and Test Cases for both Manual
and Automated testing.
. Performed GUI and functional testing.
. Added user defined functions to the test scripts.
. Developed test scripts for performance and data driven tests
manually.
. Performed Regression testing.
. Performed User Acceptance testing (UAT) in conjunction with users.
. Entered errors in the Test Director
. Interacted with developers, users and various members of my team to
discuss and to resolve defects and their priorities.
Environment: Test Director, Load Runner, Win Runner and WinNT
Dana Commercial Credit Corporation, Toledo
Dec 2001 - Dec 2002
This project is a commercial lease/loan management product. This product is
intended to meet the needs of broad segment of equipment leasing industry
-small, middle, large, independent, captive lesser.
. Created and loaded the test data for the various test-case
scenarios.
. Carried out GUI, Functionality and Integration testing manually.
. Wrote PL/SQL statements to check the validity of database and to do
backend testing.
. Conducted weekly walkthroughs on the application progress for
meeting schedules and provided the QA standing periodically to the
higher management.
. Organized daily defect meetings with developers and other team
members to resolve the explored defects and to update the
application status.
. Coordinated the testing efforts with UAT (User Acceptance Testing)
team and resolved their findings on the application.
. Used Test Director for reporting bugs in the modules
. Executed Test Cases and verified Actual Results against Expected
Results using PVCS Tracker and PVCS Version Manager.
. Performed Regression Testing to assure fixes are working fine and
not creating another issues.
. Used Test Director for Running and creating tests
. Responsible in providing regular test reports to the management.
Environment: Test Director, Load Runner, Java, Oracle, and WinNT
Contact this candidate