Quality Analyst

Location:

Reston, VA

Posted:

February 09, 2012

Contact this candidate

Resume:

PRASAD SAKALA

Phone: 727-***-****

Email: ***********@*****.***

Visa Status: Green Card

EXPERIENCE SUMMARY:

Software Quality Assurance Analyst/Tester with 10 years of extensive experience in testing of Web, Client/Server and N-tier applications in diversified industry sectors including Mortgage, Healthcare, Financial, Pharma. Experience in developing Test plans, defining Test Cases, designing Test Strategies, developing and maintaining automated test scripts, analyzing errors and applications. Strong Experience in Quality Assurance, Automated testing using HP Quick Test Pro, Back End Testing (Database Testing) using TOAD, Oracle and SQL-Developer by using SQL.

• Experience in preparing Test Plans, Test Scripts, Test Reports and test documentation and can comply with your established processes, can maintain strict adherence to your guidelines, policies and procedures.

• Involved in Complete Software Development Lifecycle (SDLC) from Business Analysis to Design, Development, Testing, Deployment and Documentation.

• Experience in different verification processes like walkthrough’s, check lists, meetings and different validation techniques and SQA processes.

• Expertise in Agile methodology with Scrum Process for the product development.

• Strong hands on testing experience with JAVA, J2EE, .NET, C#, ASP, HTML, XML, JSP and VB Script applications.

• Good at Unix Shell scripting and Automation of ETL process.

• Proficient in Data Warehouse testing like Control Mechanism of batch loads, Error/ rejected records processing, testing of SCD implementations and process dependencies.

• Proficient in Data warehouse and Backend application Testing Life cycle.

• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica

• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.

• Experience in testing Business Intelligence generated by various BI Tools like MicroStrategy and Business Objects

• Expertise and experience in performing different kinds of testing like Functional Testing, GUI Testing, Backend Testing, Regression Testing, User Acceptance Testing, Black-box testing and Compatibility testing.

• Extensive experience in Heavy Data Base testing using TOAD and SQL-Developer for Oracle and DB2.

• Excellent experience in backend testing on Oracle and written SQL/PL SQL queries.

• Experience in testing Web Services using SOAP UI tool.

• Good experience with version controls such as VSS (Visual Source Safe) and Clear Case.

• Good experience of working with various bug tracking tools like HP/ Mercury Quality Center, Rational Clear Quest and JIRA and a very good understanding of the Defect Life Cycle.

• Expertise in Defect Tracking, Report generation and requirement tracking through out the test life cycle using HP Quality Center and Rational Clear Quest.

• Excellent working knowledge of UNIX and Shell Scripts.

• Proficient in working with UNIX shell scripts using puTTY Environment.

• Experienced in working with business analysts, development groups in analyzing business specifications and in Working with other testers to resolve technical and end-user issues.

• Good Communication, Interpersonal skills and strong Team player with proficiency at time management, multitasking, able to meet deadlines and handle changing priorities.

SOFTWARE SKILLS:

Testing Tools : HP QTP, HP Quality Center, Test Director, Rational Clear quest, Load Runner and SOAP UI

ETL/BI Tools : Informatica, Data stage, SAS/Crystal Reports XI, Micro strategy

Programming Languages : C, C++, Java, XML, Shell Scripts, SQL, PL/SQL.

Web Technologies : JSP, Flex, .Net, C#, ASP, VB Script, Java Script, JDBC, Servlets

Databases and Tools : Oracle, MS SQL Server, TOAD, SQL Navigator and SQL-Developer.

Application and Web Servers : IBM Web Sphere, BEA Web Logic, Apache Tomcat, SharePoint

Operating Systems : WINDOWS, UNIX

Configuration Mgmt tools : VSS and Rational Clear Case

PROFESSIONAL SUMMARY:

American Red Cross, Ashburn, VA

Sr. QA Engineer Dec 2010 – Till Date

Application: eProgesa (MAK-SYSTEM APPLICATION)

eProgesa is a regulated application and it deals with Donor Management Information System (DMIS) and Component Distribution Information System (CDIS), and also the Donor Recruitment System (InTouch). Donor Management Information System deals with Donor Registration, Donor Core, Deferral Management and Assertions etc. Component Distribution Information System deals with Component Preparation, Distribution and Administration etc. In Touch application handles with Donor Recruitment with the help of TeleRecruiter

Responsibilities:

• Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

• Prepared Test Strategy Document, detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements.

• Prepared the Test Bed whenever a new release comes from the development team

• Prepared and provided test status reports to the management on system status, system changes, problems and potential impacts.

• Involved in the test enhancements, issues tracking and issues resolution fixes in the production environment.

• Preparing and reviewing the Test cases for all functional Requirements in HP Quality Center.

• Conducted meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.

• Expertise in Agile methodology with Scrum Process for the product development.

• Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.

• Proficient in performing of Functional Testing, Regression Testing, System Testing, Sanity Testing, Database Testing/Back-end testing, Black-box testing, UI Testing, Cross Browser testing and User Acceptance Testing.

• Performed Database testing by executing SQL queries using TOAD tool.

• Extensively used SQL, PL/SQL to do Database testing, Migration Testing and validating the front-end values with back end of application.

• Preparation of data matrix for execution of test cases.

• Conducted Data Driven testing by passing parameter from excel file.

• Created SQL scripts in Query analyzer to validate data.

• Expertise in defect tracking system and bug life cycle using HP Quality Center and Rational Clear Quest.

• Worked with developers by updating the defects and resolving them and tracking the status.

• Expertise in Defect Tracking, Report generation and requirement tracking through out the test life cycle using HP Quality Center.

• Involved in Production Planning and Implementation check list meetings / reviews.

Environment: HP Quality Center 10.0, Rational Clear Quest, QTP, Load Runner, .Net, XML, Informatica, Crystal Reports XI, Oracle10g, TOAD, SharePoint, Web Services, XML, Visual Studio

Freddie Mac, McLean, VA

Sr. QA Tester/Database Tester Nov 2009 – Dec 2010

Application: FAS 140, MISMO - CDC (Change Data Capture – COTS Application)

Freddie Mac is a home mortgage company charted by congress to keep money flowing to mortgage lenders in support of homeownership and rental housing.

Advantage MISMO (The Mortgage Industry Standards Maintenance Organization): This initiative is adding new attributes to the loan products on the Selling system. These new loan attributes would add the flexibility and more stability to the Selling and Servicing data. This project develops a staging database to support the existing downstream applications.

Responsibilities:

• Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.

• Conducted and involved in meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.

• Prepared Test Strategy Document, detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements.

• Prepared the Test Bed whenever a new release comes from the development team

• Created and executed the Test plan, Test Cases, Automation Test Scripts, and Test Steps for all the modules and stored in HP Quality Center.

• Expertise in Defect Tracking, Report generation and requirement tracking through out the test life cycle using HP Quality Center.

• Have good working experience with Quality Center on Customizing the User privileges and various module labels.

• Expertise in defect tracking system and bug life cycle using HP Quality Center (Test Director).

• Prepared and provided test status reports to the management on system status, system changes, problems and potential impacts.

• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.

• Involved in the test enhancements, issues tracking and issues resolution fixes in the production environment.

• Involved and trained offshore team to improve QA process and establish strong QA Team.

• Took part in the creation of QA metrics and Graphs to help the top management to keep update with the QA Team progress.

• Performed Integration Testing using Stub’s and Drivers.

• Performed Database testing by executing SQL queries/Procedures using SQL Developer interface.

• Extensively used SQL, PL/SQL to do Database testing, Migration Testing and validating the front-end functionality with back end of application.

• As a part of transaction testing, extensively used SQL queries to verify database table in the backend using SQL Developer.

• Worked with XML data setup and DB2 XML columns

• Good in using DOORS for requirements tracking and changes

• Design and development of automation test scripts by VB Scripts to the identified Regression Test Cases in HP Quick Test Pro (QTP) tool and executed the scripts in Regression phase.

• Used Descriptive Programming to write scripts without using Object Repository.

• Identified defects, bottlenecks, data errors and integration problems and have done regression testing using QTP to enhance the performance before application launch.

• Tested the reports execution, which are generated from UNIX Shell scripts and verified the Daily and Monthly Billing feeds during Cron jobs execution in UNIX boxes.

• Involved in Production Planning and Implementation check list meetings / reviews.

• Involved in GO-NO-GO meetings and presented the Issues/Defects list to management.

Environment: HP Quality Center 10, Clear Case, Share Point, .Net, J2EE, Web Services, SharePoint, XML, Oracle10g, UNIX, Micro Strategy, SQL Developer, Data Stage, Quick Test Pro, Remedy

BCBS (Blue Cross Blue Shield), IL

Sr. QA Tester/ETL Tester Jan 2009 – Oct 2009

Application:

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)

Responsibilities:

• 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 Cogon’s compare results in Version Control

• Interacted with the vendor resolving issues regarding requirements and business scenarios

• Analyze and report results of COTS testing.

Environment: Mercury Quality Center, QTP, Informatica, ODS, Batch Input System (BIS), Mainframes, JCL, Rational Clear Case, Rational Clear Quest, IBM DB2, Autosys, Crystal Reports XI, Remedy, COBOL, CICS, load(Batch/JCL), Java,WebServices, Facets,Fileaid,MVS,SQL,Web 2.0, File aid for VSAM and SPUFI, Teradata

FannieMae, VA

QA Analyst/Business Analyst April 2006 – Dec 2008

Application:

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

Responsibilities:

• 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.

• 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, C#,.Net, J2EE, IIS, Eclipse 3.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

Target, MN

Database Tester Nov 2005 –March 2006

Application: TSYS is dos based system and will be launched through Mervyn’s host; there are many options within the Mervyns host that support target business, the option that is used to support the target visa portfolios is TSYS which is called as total systems. Target (Red and Check) Credit Card developed a web site for online banking, whereby bank account holders or credit card holders can access and do transactions online. The application had various modules for cardholders like online bill pay, automated transaction reporting, credit card applications etc. Earlier the transactions were conducted using the third party processor FDR and was converted to TSYS.

Responsibilities:

• Review the Functional Requirement Specification (FRS), Product Design Document (PDD). Analyze the requirement and design documents for creating the Test Strategy.

• Analyzed business requirements and developed Test cases based on Use cases to evaluate the functionalities.

• Manually executed Test cases after reviewing the business requirement document and technical specifications and responsible for updating existing test cases against the requirements.

• Proficient in performing of Functional Testing, Sanity Testing, Regression Testing, Integration Testing and User Acceptance Testing.

• Prepared the Test Bed whenever a new release comes from the development team

• Performed Manual testing extensively using Positive and as well as negative scenarios.

• Involved in Back-End testing for Oracle as a part of Parallel Test and written SQL queries to extract and validate the data.

• Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.

• Design and development of automation test scripts by VB Scripts to the identified Regression Test Cases in Quick Test Pro (QTP) tool and executed the scripts in Regression phase.

• Automated the test scripts for the GUI, Functional and Regression testing using Quick Test Professional.

• Plan and Execution of Test Cases, Automated test scripts, Test Metrics and reporting bugs.

• Utilized process-based test management system Quality Center for organizing test requirement's documents, test plans and test lab.

• Expertise in Defect Tracking, Report generation and requirement tracking throughout the test life cycle using Mercury Quality Center.

• Used Mercury Quality Center to analyze and maintain test cases, Automation Scripts, which satisfy both Verification & Validation and Track bugs.

Environment: Quick test Pro, Mercury Quality Center, Data Stage, Java, Web Services, Oracle, PL/SQL, HTML, XML, TOAD, VSS, Clear Case, Clear Quest, windows XP, UNIX and other office tools.

Fisher International, Naples, FL

QA Engineer Jan 2005 – Oct 2005

Responsibilities:

• Designed the efficient manual test cases based on analysis of Business Requirement documents, SRS, Functional Specs, Technical design documents, Use Cases, supporting documents.

• Writing test cases for testing the functionality of various modules (Olympia, CCC eBilling -Temporary Password Reminder, eBilling Admin Tool and eBilling Paper free Opt out).

• Performing Regression testing for various modules of Billing (F&F (Friends and Family), VMB (View my bill), PMB (Pay my bill), Agent Admin, CCRA (continuous card recurring authority), BTBA (BT Business analyst), OBP (One Bill Plus), PAB (Personal address book)) all releases in each environment (FT, Reference and Live).

• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.

• Involved in writing of Complex SQL and PL/SQL queries in DB Tool TOAD.

• Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.

• Involved in Functional testing, Regression Testing, Data base testing, Sanity testing, DR testing, Post live testing, Compatibility testing.

• Expertise in Agile methodology with Scrum Process for the product development.

• Responsible for the execution of manual test cases.

• Performed Manual testing extensively using Positive and as well as negative scenarios.

• Involved in test data setup preparation for testing purpose as BT.com database is migrated from CSS to one view.

• Responsible for maintain System Test Cases from System Test Scenario Matrix and incorporated by using Test Director.

• Responsible for defect management using Test Director (defect logging, defect tracking, defect triaging, status updating and defect reports).

Environment: QTP, Quality Center, DB2, TOAD, C++, CVS, java, J-unit, J2EE, Windows NT/XP, IE, SQL Server, SQL, Web logic 7.x, XML, PL/SQL and UNIX.

HCL TECHNOLOGIES, Kaiser Permanent, CA (Off shore from India)

ETL Developer/QA Analyst Jan 2004 – Dec 2004

Responsibilities:

• Designed the efficient manual test cases based on analysis of Business Requirement documents, SRS, Functional Specs, Technical design documents, Use Cases, supporting documents.

• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.

• Involved in writing of Complex SQL and PL/SQL queries in DB Tool TOAD.

• Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.

• Involved in Functional testing, Regression Testing, Data base testing, Sanity testing, DR testing, Post live testing, Compatibility testing.

• Responsible for the execution of manual test cases.

• Performed Manual testing extensively using Positive and as well as negative scenarios.

• Involved in test data setup preparation for testing purpose as BT.com database is migrated from CSS to one view.

• Responsible for maintain System Test Cases from System Test Scenario Matrix and incorporated by using Test Director.

• Responsible for defect management using Test Director (defect logging, defect tracking, defect triaging, status updating and defect reports).

Environment: Informatica, Oracle, TOAD, Test Director, Windows 2000, VSS.

Wipro HealthCare IT - India

VB Developer/Test Engineer Sep 2002 – Dec 2003

Responsibilities:

• Designed the efficient manual test cases based on analysis of Business Requirement documents, SRS, Functional Specs, Technical design documents, Use Cases, supporting documents.

• Understanding the business requirements and developed test cases to test the complete functionality of the application.

• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.

• Executed test cases and analyzed the test results.

• Responsible for performing Functional testing, Regression testing and sanity testing.

• Coordinating with on site persons regarding documents, requirements, and discussions about the functionality.

• Executed test cases before and after bug fixes for each build for User acceptance testing.

• Used Test Director to analyze and maintain test cases, which satisfy both Verification & Validation and Track bugs.

Environment: Visual Basic, Oracle, VSS (Visual Source Safe), Java

CITADEL HEALTH LTD - India

VB Developer/Test Engineer Sep 2001 – Aug 2002

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