Testing Test
Resume:
Prasad Sakala
***********@*****.***
Visa Status : Green Card
SUMMARY
• Software Quality Assurance Analyst/Tester or similar role with 10-years of extensive experience in
testing of Web, Client/Server and N-tier applications in diversified industry sectors including Mortgage,
Healthcare, Entertainment/Media, Financial, Pharma and Telecom.
• Work collaboratively with business analysts, project/program managers and developers to share ideas
and provide critical feedback at all levels.
• Good understanding of QA Methodologies relative to the Software Development Life Cycle (SDLC).
• Extensive experience in Quality Assurance Life Cycle (QALC) aspects such as developing Test
Strategies, Test Plans, Test Cases (Manual/Automated), Defect Reports and developing Test Scripts,
Traceability Matrices and Test Environments.
• Expertise in writing Technical Documentation and performing Analysis, Functionality testing, GUI
testing, UAT, Integration testing, System testing, End to End testing, Back-end testing, Smoke testing,
Sanity testing, Data-Driven testing, Regression testing, Performance testing, Web services testing, Stress
testing, and Soak testing.
• Good in developing, publishing and excute Test plans, Test procedures, Test Results.
• Skilled in understanding the business process, analyzing and optimizing the process, defining scope
of the project and user requirements and converting user requirements into business requirements and
Technical Specification.
• Extensive experience in quality assurance testing by manually and using Automation testing tools
(WinRunner/Quick Test Pro, Quality Center, LoadRunner) and methods, OpenSpan and soapUI.
• Work experience in data warehousing projects dealing with ETL (extraction, transformation, and
load) using Oracle and Informatica, Ab- Initio, Data Stage and SAS.
• Work experience in OLAP Tools using Crystal Reports XI, Business Objects, Microstrategy,Cognos
• Work experience in data modeling concepts (dimension and fact tables, star and snow flake
schema’s)
• Good experience in AGILE delivery process of software using SCRUM.
• Expertise in HIPAA, HL7, EDI transactions and Claims processing.
• Good experience in testing Web services and implementing Service Oriented Architecture (SOA).
• Good experience in working closely with Business analysts for reviewing business requirements,
functional requirements, documenting test scenarios and writing test cases accordingly.
• Experience in defining use-cases, creating test scenarios and test scripts using requirement
documents.
• Proficient in writing system test plans, defining test cases, developing and maintaining test scripts.
• Expertise in testing methodology, test planning, test execution, defect-management and results
reporting.
• Proficient in GUI testing by inserting various verifications and Data Driven Testing (DDT) for
functionalities that requiring input dynamic data.
• Proficiency in Defect management, including Defect creation, modification, tracking, reporting using
industry standard tools like Rational ClearQuest and Quality Center/TestDirector.
• Experience in database testing using SQL queries on RDBMS databases like Oracle, SQL Server
• Good working knowledge of MS-Office (Outlook, Outlook express, Word, Excel and Power point).
• \Have excellent analytical, problem solving, communication and interpersonal skills with good work
ethics and ability to interact with individuals at all levels of the organization.
SKILLS
Testing Tools: QTP 10.0/9.2/9.0, WinRunner 8.2/8.0/7.6, Quality Center 9.2/9.0/8.2,
TestDirector 8.0/7.6/7.5, LoadRunner, JMeter)
RDBMS: Oracle 10g/9i/8i, SQL Server 2005/2000, MS Access 2003/2000.
Languages: SQL, PL/SQL, T-SQL, C#, VB.Net, ASP, ASP.Net, Java, J2EE, XML.
SAS: SAS V9.1.2/9.1.3, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS,
SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/QC and SAS/ETS
Scripting languages: VB Script
Middleware: IBM MQ Series, Biztalk Server.
Operating systems: Windows Vista/XP/NT/2000, Windows 2003 server, Linux and UNIX.
Web technologies: HTML, DHTML and MS Front Page.
Durga Prasad Sakala
Page 2 of 8
Open source tools: soapUI 2.0/2.5/3.0/3.5, Selenium 0.8, 1.0, 1.2
Web/Application servers: IIS, Weblogic 9.2/9.1/9.0, WebSphere 7.0/6.0 and Apache Tomcat.
Version control: MS Team Foundation Server (TFS), JIRA, VSS, CVS, PVCS, ClearCase
MS-Office: Word, Excel, Access, Outlook, Outlook Express and Power Point
ETL/OLAP Informatica/Datastage/Ab initio/SAS, Crystal Reports XI/Cognos
EXPERIENCE
January 2011 American Red Cross (ARC), Ashburn
To Till Date QA Analyst/Data Tester (Team size: 1)
Project 1: eProgesa (MAK-SYSTEM APPLICATION)
• Worked on agile methodology using Scrum.
• Performed manual testing for the entire application by executing the test scripts.
• Performed regression testing of the application manually.
• Performed end to end testing with help of MQ for message transport.
• Created test plan, test cases and test condition matrix for feature testing.
• Developed and executed manual test scripts using test plan and test lab sections of Quality Center for
System testing, Integration testing and Regression testing of the application.
• Used Quality Center for test plan execution and defect tracking.
• Data validation from end to end.
• Created SQL scripts to change data and validate service response.
• Manually performed back-end testing by executing SQL queries to validate the data in the back-end
Oracle database.
• Used soapUI to validate that each Web Service operation functions as stated.
• Created and maintained Object Repository in QTP.
• Maintained versions for System testing, data driven and Regression testing.
• Created test Status report and Test Completion Report for feature testing.
• Performed backend testing on Oracle.
• Validate the sequence of web service invocations to fulfill a required business process using soapUI.
• Performed System testing by executing the Test scripts.
• Interacted with the UAT team to solve issues related to the defects.
• Involved in developing functional test scripts using QTP as a part of automated testing.
• Developed test automation scripts using QTP for Regression, Functionality, and GUI testing.
• Responsible for coordinating the User Acceptance testing (UAT).
• Involved in test case review meeting to update test cases based upon new functions that are being
added during new cycle and the old test cases are being modified.
• Responsible for preparing the user documentation and helping the users in UAT.
• Test results are documented using MS word.
• Maintained Excel sheets for personal tracking of the defects.
• Participated in weekly status meetings.
Environment: Informatica,Manual testing, QTP 9.2, Quality Center 9.2, Agile, Java, Web services, soapUI,
JBoss Server, Eclipse, Oracle 10g, SQL, PL/SQL, TOAD, XML,UNIX,Load Tester
November 2009 FreddiMac, VA
To Dec 2010 Sr. QA Tester/Data Tester
Project 1: FAS 140
Project 2: MISMO - CDC
• Reviewed business requirement documents and technical specifications.
• Worked on use cases based on the Business requirements.
• Documented Test Plans, Test Cases corresponding to business rules and other operating conditions.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Performed Positive and negative testing for the Input and Output Attestation functionalities.
• Tested application integrity after running data Extraction, Transformation and Loading programs.
• Executed test scripts and verified the results. Reported Bugs to developers through the Test director.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and
business requirements using RUP methodology.
Durga Prasad Sakala
Page 3 of 8
• Validate Micro strategy reports
• Performed Load testing for validate the web reports
• Create Test Scripts and Test data
• Create Test cases and in Quality Center
• Write SQL queries to validate that actual test results match with expected results
• Write SQL queries using PL/SQL
• Involved in requirements reviews, design reviews, and change control activities
• Tested the Data load process by running the UNIX scripts and Autosys job.
• Imported requirements into Quality Center and Created RTM to know the coverage of requirements
by Test Cases
• Tested the UNIX scripts, which are responsible for the data loads of all MPS tables to history tables.
• Responsible for testing the Autosys functionality which loads the destination tables from source
tables.
• Participated in meetings like Daily Status Review and Test Metrics Review.
• Create daily Test report
Environment: Micro Strategy, Datastage, QUALITY CENTER, TEST MANAGER, CDC, CLEAR QUEST,
DOORS, COBOL, JCL, CICS, DB2, SQL, XML, SAS, VSAM, FILE-AID, IMS, JSUB, SPUFI, DFSORT,
TSO/ISPF, MCM, MQ SERIES, MS VISIO, RAPID SQL, COMMAND CENTER
January 2009 BCBS (Blue Cross Blue Shield), IL
To October 2009 Lead QA Analyst (Team Size : 2)
Project 1: RTA/MLE (Real Time Adjudication and Member Liability Estimation)
Project 2: Inter-plan Teleprocessing system (ITS/Host and Home Claims)
Project 3: PRAP (Pre Adjudication)
Project 4: Blue-Chip (Rbis, Rbos, DDE Claims)
• Analyzed Business Rules, Data Specs, Flow Diagrams, and Use Cases, Test Data and Test Cases.
• Performed Functional, Black Box, System and Regression testing.
• Prepared Test data to enable the software to be quality checked.
• Executed and updated with the test results for the Test cases in Quality Center under the Test lab
• Involved with ETL test data creation for all the ETL mapping rules.
• Developed test scripts based upon business requirements and processes, in line with defined
workflows and use cases. Processed transactions from system entry to exit. Tested functionality across
applications and workflows.
• Involved in testing the designing and development of data warehouse environment.
• Tested the ETL process for both before data validation and after data validation process. Tested the
messages published by ETL tool and data loaded into various databases
• Experienced in testing different stages of data warehouse like Source to Stage and Stage to Target.
• Worked on ETL to load data using Power Center from source system into staging tables and to load
the data into the target database
• Good knowledge on Source Analyzer, Data warehousing designer and Mapping Designer and
Transformations.
• Worked on profiling the data for understanding the data and mapping document
• Written multiple Test Cases (Unit, System, Integration) for multiple transactions include 270 / 271,
276/ 277, 834, 837 / 835, (both inbound and outbound) transactions
• Used Faciledi tool to verify mapping to X12 format
• Reported software defects in Quality Center and interacted with the developers to resolve technical
issues.
• Generated SQL queries to validate various reports, loads and extract processes.
• Verify nightly batch ( Batch Input System) for claim process
• Support BIS (Batch Input System) : Send BIS reports to Business Users based on the User Requests
• Involved in Parallel and performance Testing
• Verify status (finalized, pended, dups) for claim process and DF
• Involved test data (Home :IL, TX, Host : OK,NM) based on the Groups
• Writing SQL queries and compare the cognos report
• Store the SQL and Cognos compare results in Version Control
Durga Prasad Sakala
Page 4 of 8
• Interacted with the vendor resolving issues regarding requirements and business scenarios
• Analyze and report results of COTS testing.
Environment: Informatica,ODS, Batch Input System (BIS), Mainframes,JCL, Rational Clear Case, Rational
Clear Quest, Manager Mercury Quality Center, IBM DB2, Autosys,Crystal Reports XI, Remedy, COBOL,
CICS, load(Batch/JCL), Java,WebServices, Facets,Fileaid,MVS,.Net,SQL,Web 2.0, File aid for VSAM and
SPUFI, PVCS Tracker,Control-M,QTP,Teradata, peoplesoft
April 2006 FannieMae, VA
To December 2008 Lead QA Tester/Data Tester/Data Analyst ( Team size : 1)
Project 1: FRCO (Financial Reporting Control and Operations
Project 2: GAGO/FIN46 (Restatement Project/Catch-up/Get Current Accounting)
Project 3: Commitment Reporting
Project 4: LCT (Lender Capitol Tool), MSFMS, CT, FMIS, DEALSNAP
Project 5: HCD Core - Property Id and Slice and Dice
• Interacted with business analysts and to understand the requirements for scripting the test cases.
• Analyzed System requirements and developed Test Strategy and detailed Test Plan for System
testing.
• Ensured that the System Testing and Test Plan were compliant with the Test Services Department
Standard Operating Procedures and Test Strategy.
• Performed Security testing for various user roles.
• Worked with project teams for SOX Compliance Review and performed Information Technology
General Controls SOX testing.
• Helped meet Phase Gate requirements by conducting tasks and actions in a timely fashion.
• Performed Positive and negative testing for the Input and Output Attestation functionalities.
• Tested application integrity after running data Extraction, Transformation and Loading programs.
• Executed test scripts and verified the results. Reported Bugs to developers through the Test director.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business
and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and
business requirements using RUP methodology.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process.
• Conducted interviews and facilitate requirements gathering, process analysis, and application design
sessions with company staff across all levels and functions
• Produced documents for business requirements (requirements matrix), design requirements, gap
analysis, solution recommendations, test cases, test plans and reference guides
• Extensively used SQL programming in backend and front-end functions, procedures, packages to
implement business rules and security
• Created and executed SQL queries for checking the flow of data from front end to back end in
Embarcadero Rapid SQL.
• Wrote and executed SQL queries to validate the entire data mapping for all the fields based on the
BRS (Business Rules Spreadsheet) document provided by the Business Users.
• Involved in testing of Insert, and Update triggers for all the tables as well as the Replication
mechanism for the replication of data from Sybase to UDB.
• Responsible for testing the Adjust Data functionality, which involved Front-end GUI and Back-end
validation.
• Tested the Import Data functionality, which involved importing the data from CSV files and
validating the correctness of the data in the back-end.
• Tested the Data load process by running the UNIX scripts and Autosys job.
• Tested the UNIX scripts, which are responsible for the data loads of all MPS tables to history tables.
• Responsible for testing the Autosys functionality which loads the destination tables from source
tables.
Durga Prasad Sakala
Page 5 of 8
• Participated in meetings like Daily Status Review, Lessons Learned, and Test Metrics Review.
• Participated in Team meetings and interacted with Business Users and Analysts in understanding the
requirements for writing the Test Cases.
• Conducted Test Plan Reviews, Test Case Peer Review, Test Suite Reviews, and System Test
Acceptance Reviews.
• Developed RTM (Requirements Traceability Matrix) to match requirements with test cases.
• Interacted with the business and development teams for the Modifications Request (MR) and
Enhancement Requests (ER).
• Performed the Integration testing with the Phoenix system for sending the Journal Entries and the
Valuation system for sending and receiving the XML file transfer and performed an overall end to end
testing.
• Supported the Pre-Production and Production deployment issues by conducting Sanity, functional
and performance testing.
• Created requirements mapping documents and prepared test plan and Test summary report and RTM
based on the functional requirements.
• Validated results based on the mapping document and requirement document
• Worked with business users and developers
• created test data sets, wrote sql scripts to test backend validation
• Reviewed Databases tables and executed jobs.
• Verified bugs/defects/errors
• Interact with business users and internal customers and review business requirement
• Helped Business Users in performing the UAT
• Performed system administration using deployment and configuration management
• Participated in Agile Model and daily scrum meetings to discuss the status updates
Environment: ETL-SAS, AB Initio, Rational ClearQuest,J2EE, C#, IIS, Eclipse 3.1, Java, Web Logic 8.1,
DB2/6000 8.1.6, Sybase 12.5.3, UNIX, Autosys, Remedy, MS Office, Mercury Quality Center, Mainframe,
AS400, COBOL,CICS,JCL,IMS,DB2, TSO, QMF, Crystal Reports XI, Bugzilla,QTP,XML,Teradata,Load
Testing
November 2005 Target, MN
To March 2006
This application Transfer Direct Premiums/Claims data from Excel files to Oracle and prorate it down to
Participant/Re-insurer Level. This Project was developed in 3-Tier Architecture.
• Participated in system specification meetings, analyzed user requirements, coordinated with team
members.
• Analyze the Business requirement documents, Functional specification documents to prepare Test
cases and effort estimation.
• Involved development of test plan of the testing process and determine the test environment
requirements for the application.
• Developed test scripts for manual/automation tests using QTP.
• Performed Black Box testing of the entire application using QTP.
• Prepared Test cases depending up on Boundaries and test conditions.
• Created GUI map file (checked Frames, cell and Table content), synchronized objects, customized
objects and written library functions using QTP.
• Developed scripts for testing the test cases and made enhancements for previous scripts using QTP.
• Developed several SQL queries to perform backend testing of the database.
• Performed Regression, Smoke testing, compatibility testing and ad-hoc testing.
• Developed QTP script for Data Driven Testing (DDT).
• Reported defects using Quality Center.
• Defects were identified, provided documentation to the development team for debugging.
• Document test results and provide status updates to the QA Team Manager, and Test Coordinator.
• Conducted User Acceptance Testing (UAT) to validate that developed system, meets the required
design.
Environment: Datastage,Manual testing, QTP, Quality Center, VB Script, Java, J2EE, HTML, XML, IBM
WebSphere, ClearQuest, Oracle 9i, SQL, TOAD, UNIX and Windows XP.
Durga Prasad Sakala
Page 6 of 8
January 2005 Great West Health & Life Insurance Company, Atlanta, GA
To October 2005 QA Tester/UAT Tester
Project: CHAMPS (Community Health Automated Medicaid Processing System)
CHAMPS is web based application. It is a Medicaid management system for the state of Michigan from
CNSI. The system has Medicaid processing modules like single sign-on (SSO), Claims submission, Prior
Authorization, Document management system. This system is developed in three tier architecture and also
implemented agile methodology. User interface for the project is a reusable custom frame work. HIPAA rules
were strictly adhered to design the system.
• Involved in developing the CHAMPS test approach document.
• Acted as Scrum team member for the agile core process team applying Scrum principles.
• Perform Data Validation of the data flow from the end-to-end.
• Interacted with developers and users to analyze the user requirements and functional specifications.
• Responsible for testing Web application used by state and providers for Claims Maintenance.
• Facets tool is used for Claims processing.
• Performed Manual Testing for the entire application by executing the test scripts.
• Performed regression testing of the application manually.
• Created Test Plan, Test Cases and Test Condition Matrix for feature testing.
• Developed and executed manual test scripts using test plan and test lab sections of TestDirector for
System testing, Integration testing and Regression testing of the application.
• Facilitated requirements gathering with Business Analysts in group and individual settings.
• Utilized EDI translation software to convert the files into a format that could be imported into the
company's ERP.
• Responsible for maintaining Health Insurance Portability and Accountability Act (HIPAA)
compliance.
• Created transaction sets and mappings in various ANSI X12 EDI formats like X12 837, X12 835,
X12 270/271, X12 276, X12 277/275 and X12 278.
• Performed manual testing to verify look and feel, GUI, navigation and code verification.
• Participated in peer reviews with team and developers to review the test cases.
• Executed feature test cases to verify the functionality of the respective features of the application.
• Executed regression test cases using WinRunner for each release to make sure that total functionality
of the application is not broken.
• Responsible for writing test scenarios, test plans and review of those.
• Analyzed test results and logging defects in TestDirector.
• Created SQL Scripts in query analyser to validate data.
• Responsible for debugging the application and made changes to the values according to Test Cases
such as test condition.
• Created GUI files using WinRunner & performed Data Driven Testing (DDT).
• Used TestDirector to report the defects found during regression testing and followed up until it
resolves.
• Responsible for test planning, test creation, test setup & test mapping and exporting them into
TestDirector.
• Involved in test cases review to analyze the functional coverage and reviewed defects status in JAD
sessions.
• Interacted with users by conducting User Acceptance Testing (UAT) to ensure that the total
functionality of the application was met by complying with all the business requirements.
Environment: Informatica,Manual testing, Agile (Scrum), WinRunner7.6, TestDirector7.6, Oracle 9i, SQL,
TOAD, Java, J2EE, Java Script, HTML, XML, WebSphere5.1, EDI, HIPAA, MS Office and Windows XP.
January 2004 HCL TECHNOLOGIES, Apria Healthcare, AZ
To December 2004 QA Tester
• Coordinated the meetings with Business Analysts, Team Lead, and Developers & Project Manager.
• Written test cases and performed manual testing like positive testing and negative testing.
• Designed and developed test scripts for manual and automated testing of the application.
• Involved in writing Test Plan Strategy, Test Plan, Test Cases and Test Result Matrix.
• Coordinated with BAs for loosely designed requirements.
Durga Prasad Sakala
Page 7 of 8
• Performed Regression Testing, GUI Testing & Functionality Testing for Online forms, Tasks and
Reports of web based application.
• Involved in preparing Test case data for both positive and negative test cases.
• Written and developed TSL scripts for functionality testing using WinRunner and TestDirector.
• Written and executed WinRunner Test Scripts.
• Performed Regression Testing using WinRunner and TestDirector.
• Wrote and executed test cases.
• Worked extensively with harvest as version control as well as bug (DCR) reporting tool.
• Manually performed Back-end testing by executing queries to validate the data in the back-end SQL
Server database.
• Performed regression testing using WinRunner for each release and new build to make sure that there
won’t be any broken functionality.
• Created GUI files using WinRunner.
• Responsible defects tracking and generated reports by using the defect tracking system in
TestDirector.
• Compared actual & expected results using multiple checkpoints like GUI, text, bitmap & database.
• Rapid Test Script Wizard of WinRunner was used to learn the properties of all GUI Objects existed
in the application.
• Performed Data Driven Testing (DDT) to test the application with different sets of data from the test
database.
• Tested the various functionalities of the application viz., Hyperlinks, frames, static and dynamic text
in all the Html pages.
Environment: Informatica, Business Objects,Manual testing, WinRunner, TestDirector, ASP.Net, C#.Net,
ADO.Net, XML, SQL Server 2000, T-SQL, IIS and Windows Server 2003.
September 2002 Wipro HealthCare IT, Kaiser Permanent, CA
To December 2003 Sr. QA Tester
Torrent Pharmaceuticals is one of the reputed referral companies in India and is involved in the research and
treatment of cancerous disorders.
• Created and executed manual test scripts.
• Transaction verified through data verification of backend database using SQL Queries.
• Performed Regression testing and Ad-Hoc testing.
• Database integrity testing by executing SQL statements.
• Presented project status to upper management.
• Tracked the progress of test case planning, implementation and execution results.
• Created survival graphs in MS-Excel by transporting SAS data sets into Excel spreadsheets.
• Performed the testing and defect tracking and documentation of test scripts, test output in electronic
and printed format as per system validated environment.
Environment: Informatica,Manual testing, informatica, BASE SAS, SAS Macro, PL/SQL, Oracle8i, MS
Excel 2000 and Windows NT,UNIX
August 2000 CITADEL Health LTD, Manipal Hospital
To August 2002 VB Developer
• Responsible for testing the entire application manually.
• Responsible for test design, test planning and test development.
• Responsible for testing the application at Unit level, Module level and System level for quality of the
software.
• Conducted GUI, Functional, Integration and System testing.
• Responsible for Black box testing for functional flow of the applications.
• Performed Positive and Negative testing for system validations.
• Responsible for testing the reports generated with the actual data in the database using SQL.
• Analyzing and checking all test plans and test cases, documenting the test failures and provide the
bug report to the development team using MS-Excel.
• Performed execution of test cases to verify the expected results.
• Modified the test cases and re-ran them for the purpose of regression testing.
• Performed end-to-end testing on the entire system.
• Performed database testing by passing SQL queries to retrieve data.
Durga Prasad Sakala
Page 8 of 8
• Documented every stage of testing for historical purpose.
Environment: Manual testing, VB6.0, MS Excel 2000, Oracle 8i, SQL and Windows NT, Visual Basic
EDUCATION
University of Bharthidasan, India
• Master of Computer Applications (1996-1999)
Contact this candidate