Quality Assurance Engineer
Resume:
Ramesh Koraprolu
206-***-**** ********.**@*****.***
Summary:
Over 10+ years of IT experience in System analysis, Design, Testing and Implementation, primarily includes Quality Assurance experience in Client/Server and Web based Applications. Good experience in industries like Banking, Financial, Healthcare, Telecom, Energy & Utilities and Insurance.
Expertise Includes:
Experienced in Functionality, Integration, Performance, ad hoc, Stress and Regression Testing on Web and Client/Server based applications.
Extensive experience in Black box/White box, manual and Automation (QTP) testing.
Professional experience in Integration testing, System Testing, Functional Testing, Regression Testing, Validation Testing and UAT ( User Acceptance Testing)
Extensive experience in preparing Test Cases, Test Scenarios, Test Scripts, Test Reports and Documentation for Automated Tests.
Experience in Manual and Automation Testing of Client/Server and Web-Based Applications and Agile methodologies.
Expertise in “Agile” (Scrum) Methodology
Extensive working knowledge in Disaster Recovery planning and testing methodologies
Good working experience in Traceability Matrix.
Good working experience in Automation keyword-driven Framework.
Good working knowledge on UNIX and Windows XP/NT/2000/98/95 Environments
Oracle table manipulation and back end testing using SQL, PL/SQL.
Knowledge of methods and tools to extract and analyze data (SQL, MS Access)
Good experience in HIPAA, Claim 4010 files and EDI (Electronic data Interchange)
Extensive experience in testing Banking, Telecom, Healthcare, Finance and Insurance applications developed in diversified technologies such as ASP.NET, VB.NET, C#, J2EE, Java, JCL, JSP
Good working experience in Business Intelligence.
Good experience in translating Use Cases into Test Cases.
Good experience in GUI application testing.
Good experience in SharePoint portal.
Good experience in Informatics and BO
Good experience in ecommerce applications like Supply chain management systems and EDI.
Good experience in Web security testing.
Good working experience in 4010 and 5010 Claim files.
Good Testing experience in 834 and 837 Transactions.
Involved in OSLO model.(Wipro V&V model)
Good testing experience in N-tier applications.
Knowledge in Selenium
Knowledge of various integration design patterns such as SOA Design Patterns and Principals.
Good experience in QC Administrator.
Good experience in API testing.
Extensive experience in product based applications.
Good working experience in scripting languages like VB Script, Java Script, Perl
Good experience in Process Flow Charting, Root Cause Analysis in UAT.
Good experience in Bug Tracking tools like Quality center, Test director, Clear Quest and Bugzilla.
Proficient with automated testing tools such as QTP, Compu ware (QA RUN) for testing client/server and web based applications.
Good Knowledge about the Software Quality Assurance, CMM levels, ISO 9001.
Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
Technical Skills:
Testing/Automation Tools : Quick Test Professional (QTP), QA Run,
Rational Performance tool, JUnit, SoapUI3.61
Bug Reporting Tools : Test Director, Quality Center10.0 Premier, Bugzilla, TFS,
Project by Net, JIRA, Product Studio, Bugzilla
Version Control Tools : Rational Manual Tester, Clear Quest
Operating System : Windows XP/Vista, Windows 95/98, Unix
Languages : C#3.0, COBOL, Pascal
Databases : Oracle10g, MS SQL Server, Ms – Access, DB2, Sql
Server2005/08, Toad for Data Analysts 2.6, Toad for Oracle
10.5
ETL Tools : Informatica
GUI Tools : Visual Basic 6.0, ASP, Visual studio, VTS
Web Service Tools : soapUI 3.61
Web Technologies : HTML, XML, SOAP, VB Script, Java Script, Unix Shell scripting
Web Servers : IIS, Apache Tomcat
Academic Qualifications:
• Master of Computer Application
Professional Experience: 2012 Jan to Till date
Client : AT&T, Redmond, WA
Role : Sr Software QA engineer
Project : Contact Service Address Book(CSAB)
Description:
The main aim of the project is migrate the data from AAB to CSAB. Migration is based on bulk provisioning of accounts and related (groups and contacts) data from AAB into CSAB. Data will be exported using the legacy SOAP APIs (getSubscriber, getMyInfo, getAllContacts, getAllGroups and getGroupContacts) then a java program running on CSAB side will be used to import the data within CSAB database.
Responsibilities:
• Prepared MTA (Master test approach) document based on project specification document.
• Create XML object from AAB system through “getallcontacts” API call by using soapui tool.
• Create XML object from CSAB system through “getallcontacts” API call by using soapui tool.
• Prepared test data from AAB(Nokia) system.
• Defects logged and verified in Qc.
• Run the migration engine in SDG.
• Backup the data from database tables. (job_mig and job_mig_history)
• Analyze the log files after migration completion.
• Generate migration engine status report.
• Attending Daily defects status calls and updates status for defects.
• Worked closely with Stakeholders and Product owner to get better understanding of the requirements.
• Prepared test data for MVT tool from the database.
• Analyze the MVT toll reports.
• Worked on multiple tasks in different schedules.
• Performed Data validations as a Back-End testing by developing several kinds of SQL queries.
• Coordination with QE and Dev team.
• Contribute to continuing process improvement of quality assurance standards and procedures.
Environment: Window NT/XP, MQ Server, UNIX, TOAD, Oracle10g, Migration engine
Professional Experience: 2010 Dec to 2011 Dec
Client : Regence BCBS, Portland, OR
Role : Sr Software QA engineer
Project : General Ledger Interface
Description:
This Project aims to migrate GLI functionality running on Mainframe to a new environment. Currently all the GLI processes are handled by COBOL batch jobs, which will be replaced by ETL (DataStage) and PL/SQL stored procedures. FDM will be established as the source of FACETS 4.61 data for GLI, Paid Claims Recon, Claims Refund Recon processes in the new environment. All the final User reports from GLI, Paid Claims Recon, Claims Refund Recon and processes will be converted into BOE reports.
Responsibilities:
• Prepared MTA (Master test approach) document based on GLI project vision document.
• Prepared EPD’s (Execution procedure document) for each bundle by using respective story cards.
• Prepared test scripts in the rational manual tester tool(RMT)
• Methods have been created based on UML, such as IBM Rational Unified Process (RUP).
• Defects logged and verified in Clear Quest Tool.
• Attending Daily defects status calls and updates status for defects.
• Prepared traceability matrix based on User story’s.
• Performed all phases of testing which includes Black box testing, Functionality testing, Regression Testing, GUI testing, negative testing, and system testing of the application.
• Used Rational Manual Tester toll for the execution of manual test scripts. While executing test scripts, results screen shots are attached in the scripts.
• Worked closely with Stakeholders and Product owner to get better understanding of the requirements.
• Worked on multiple projects in different schedules.
• Back end testing(Database) done in IBM DB2, Oracle 10.g
• Mapping solutions to user requirements by using BI.
• Performed Data validations as a Back-End testing by developing several kinds of SQL queries.
• Coordination with BA and Dev team.
• Prepared SQL queries and run the queries in Query Analyzer and Data Analyst 2.6.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Generating reports through Clear quest for presenting the defects status meeting.
• Mapping data with various systems and placed in the target system by using Informatics tool.
• Support to UAT team.
• Performed regression testing and update the test scripts in RMT.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Provided the management with test metrics, reports, and schedules as necessary and participated in the walkthroughs and meetings.
• Implemented agile methodologies and participate all scrum meetings.
• Contribute to continuing process improvement of quality assurance standards and procedures.
Environment: Window NT/XP, MQ Server, UNIX, TOAD, Oracle10g, Informatics, Toad for Data Analysts 2.6, Toad for Oracle 10.5
Client : Regence BCBS, Portland, OR
Role : Sr Software QA engineer
Project : RBM(Radiology Benefit Management & RBM Commercials )
Description:
This project is implementing Radiology Authorization, which will be required for certain radiology services in order for a claim to be paid. Providers will be required to contact a third party company: AIM, to request authorization for radiology services. AIM will either issue or deny the Provider's authorization request, based on evidence-based guidelines.
AIM will send Regence a file that will identify approved authorizations, which Regence will load to Facets for claims adjudication and payment. This latest phase of the project address Medicare Advantage and True Advantage (Asuris) membership in Facets only.
Responsibilities:
• Prepared MTA (Master test approach) document based on GLI project vision document.
• Prepared EPD’s (Execution procedure document) for each bundle by using respective story cards.
• After batch process, verified all the values in Facets 4.81 PPMO environment
• Prepared test scripts in the rational manual tester tool(RMT)
• Methods have been created based on UML, such as IBM Rational Unified Process (RUP).
• Defects logged and verified in Clear Quest Tool.
• Attending Daily defects status calls and updates status for defects.
• Prepared traceability matrix based on User story’s.
• Performed all phases of testing which includes Black box testing, Functionality testing, Regression Testing, GUI testing, negative testing, and system testing of the application.
• Used Rational Manual Tester toll for the execution of manual test scripts. While executing test scripts, results screen shots are attached in the scripts.
• Worked closely with Stakeholders and Product owner to get better understanding of the requirements.
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process.
• Worked on multiple projects in different schedules.
• Worked on soapUI 3.6.1 tool for web service testing.
• Back end testing(Database) done in IBM DB2, Oracle 10.g
• Performed Data validations as a Back-End testing by developing several kinds of SQL queries.
• Coordination with SA and Dev team.
• Prepared SQL queries and run the queries in Query Analyzer and Data analysts 2.6
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Generating reports through Clear quest for presenting the defects status meeting.
• Mapping data with various systems and placed in the target system by using Informatics tool.
• Performed regression testing and update the test scripts in RMT.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Provided the management with test metrics, reports, and schedules as necessary and participated in the walkthroughs and meetings.
• Trying to use Jmeter tool for web service testing.
• Implemented agile methodologies and participate all scrum meetings.
• Contribute to continuing process improvement of quality assurance standards and procedures.
Environment: Window NT/XP, MQ Server, UNIX, Facets 4.81, Ultra edit, Toad for Data Analysts 2.6,Toad for Oracle 10.5,soapUI3.6.1
Client : Emdeon, Nashville, TN. USA 2009 Oct to 2010 Nov
Role : Sr Software QA engineer
Project : Emdeon-Freedom-Phase IV
Description:
Batch Switch Tools project began as part of Emdeon’s “Freedom” initiative – an initiative to break free from the expense of running the NEIC switch on a mainframe platform hosted by Verizon. The Batch Switch Tools project will continue under the Batch Switch Consolidation (BSC) initiative to process all Batch Clearinghouse Claims processes to the in-house Unix-based OKC switch.
Batch Switch Tools are being designed to enable internal Operations users to serve our customers better and more easily. The first deliverables for the project are the EntryPoint! Menu and 10 tools prioritized by the Operations group’s priorities. In this project, we have followed HIPAA standards for all transactions (EDI).
Tools: Internal, Inbound, Outbound, Claim Correction, Remove than Reque, Reprocess 1500 tools.
Responsibilities:
• Prepared Test Plan and Test Cases based on the User story/Business requirements.
• Created and execute QTP scripts by using descriptive programming.
• Modify and debug the QTP scripts by using Vb script.
• Prepared test scripts by using rational tool.
• Prepared traceability matrix based on User story’s.
• Methods have been created based on UML, such as IBM Rational Unified Process (RUP).
• Performed all phases of testing which includes Black box testing, Functionality testing, Regression Testing, GUI testing, negative testing, and system testing of the application
• Unit testing was done in Claim Correction (.Net) tool by MbUnit
• Parameterizing was done in Unit testing using Mbunit
• Used Quality Center for the execution of manual test cases and to track the defects to maintain the quality of the product.
• Executed performance test cases.
• Support to UAT team.
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process
• Client side interfaces tested by using Visual studio team application (VST).
• Prepared traceability matrix for this Application.
• Bugs logged and status updated in Clear Quest
• Worked closely with Stakeholders and Product owner to get better understanding of the requirements.
• Worked on multiple projects in different schedules.
• Worked on SoapUI 3.6.1 tool for web service testing.
• Back end testing(Database) done in IBM DB2, Oracle 10.g
• Good testing experience in N-tier applications.
• Conduct performance and load test on the Web.
• Mapping solutions to user requirements by using BI.
• Performed Data validations as a Back-End testing by developing several kinds of SQL queries.
• Coordination with offshore team members.
• Prepared SQL queries and run the queries in Query Analyzer.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Generating reports through QC.
• Prepared and executed Unit test cases.
• Manage agile development and testing efforts within the same QC Project using the Agile Accelerator.
• Mapping data with various systems and placed in the target system by using Informatica tool.
• Performed regression testing and validated fixes to the system using QTP.
• Provided the management with test metrics, reports, and schedules as necessary and participated in the walkthroughs and meetings.
• Implemented agile methodologies and participate all scrum meetings.
• Tested this all Tools in different browsers like IE, Safari, Firefox, and Google Chrome.
• Analyzing Test Results and documented all the results.
• Maintain and improve the defect tracking system.(Bugzilla,QC)
• Maintain and improve the requirements management system.
• Interacted with developers and discussed technical problems, reported bugs and supported development team.
• Contribute to continuing process improvement of quality assurance standards and procedures.
Environment: QTP, HP Quality Center10.0, Bugzilla, BI, Facets, JUnit, Java, J2EE,.Net, MbUnit, XML, Window NT/XP, JSP, JDBC, HTML, JNDI, Java Script, AJAX, CSS, DTD, XSD, Web Services, LDAP, WSDL, JAXB, DOM, RAD 7.0.0.3, Web sphere 6.1.2,TFS, MQ Server,UNIX,TOAD,Oracle10g, Informatics, Teradata.
Client : KACE Systems Management, California, US 2008 Mar to 2009 Sep
Role : Senior QA engineer
Project : AppDeploy Repackager and WiMax service
Description:
The requirement is to build an installer MSI by observing an installation on a clean system. This tool, described as “AppDeploy Repackager with Shareable Project Format”, will provide users the ability to create a simple MSI setup based on the contents of a project file. The project file is created based on changes that take place on a computer before and after an application is installed to a clean system. The differences detected between these two snapshots will be exported to an XML based project file which may be used to create an MSI setup and which may also be shared with other users.
Responsibilities:
• Analyzed business needs user requirements and specifications.
• Prepared Test Plan and Test Cases based on the User story/Business requirements
• Prepared and executed performance test scripts by using Rational performance tool.
• Prepared test cases based on Design documents & Requirement documents.
• Install, configure application into different environments.
• Bugs reported in Clear Quest
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process
• Methods have been created based on UML, such as IBM Rational Unified Process (RUP).
• Writing and Executing Test Scripts for functional testing in Quality Center
• Involved in Regression, Functional, performance testing
• Worked on Sparx systems enterprise
• Defects are raised using Quality Center with Priority levels High – Medium - Low.
• Generate Script status reports from Quality Center
• Tested varies parameters of the API calls.
• Implemented SOA architecture.
• Support to UAT team
• Create and maintain performance environment.
• Developed some of the screens in this application by using Visual studio.
• Involved in unit testing by using JUnit.
• Discuss Reports with Testing Manager.
• Interacted with developers and discussed technical problems, reported bugs and Supported development team.
Environment: Rational Performance taster, Clear Quest, visual studio .NET 2003, Quality Center, Bugzilla, Vm Ware, C#, Window NT/XP, Vista, HTML, XML, DTD, XSD, Web Services, WSDL, JAXB, DOM, RAD.
Client : BP Oil International Limited, Chicago, IL 2007 June to 2008 Feb
Role : Sr. QA Engineer
Project : iSupply
Description:
The iSupply application helps to coordinate and manage effectively the supply chain. The iSupply application, based around the monthly Mass Balance Plan, the Daily Progression Plan and the Rolling Daily Progression, enables both the systematic planning of demand and supply and the maintenance of Mass Balance in accordance with target levels that are strategically determined - at all of BP's terminals across Europe.
It is important to stress the strategic nature of the planning exercise. The objective is not just to be able to meet demand (the "Neutral Stock Level"); but to ensure that the Closing Stock Balance at the end of each month meets the "Target Stock Level". Once the Mass Balance Plan is correct, it is "fixed" (so it cannot be changed) prior to the planned month becoming the current month. Reforecast can then be made to those planned quantities; then finally actual can be both recorded and measured against planned figures. Actual closing stock levels are then fed back into the planning process for the cycle to begin again.
Responsibilities:
• Analyzed system requirement and functional requirement documents.
• Prepared Test Plan and Test Cases based on the User story/Business requirements
• Sql server 2005 to 2008 migration testing.
• Methods have been created based on UML, such as IBM Rational Unified Process (RUP).
• Created and executed QTP scripts by using descriptive programming.
• Used QTP framework functionality in various phases.
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process
• Prepared SQL Queries to verify that the data is populated from the database matches with the front-end screens Using Query Analyzer.
• Prepared Test Cases based on functional requirements using Quality Center.
• Mapped Requirements to Test Cases for Requirements Traceability Matrix
• Manually executed the test cases for positive and negative scenarios.
• Responsible for entering, Tracking bugs in Quality Center to resolve bugs.
• Executed QTP Regression suite.
• Created SQL scripts to verify the integrity of the database.
• Enhanced code in the source code section.
• Reported the defects using the tool Quality Center.
• Preparing Test cases for BP Product application.
• Performed regression testing and validated fixes to the system using QTP.
• Work with developers, business and Release managers to discuss ways to fix the Defects.
Environment: QTP, HP Quality Center, Jira, Query Analyzer, BI, Java, J2EE,.Net, Winframes, visual studio .NET 2003, XML, Window NT/XP, JSP, JDBC, HTML, JNDI, Java Script, AJAX, CSS, DTD, XSD, Web Services, WSDL, JAXB, DOM, RAD 7.0.0.3, Windows server 2008,Informatics
Client : Morgan Stanley, 1585 Broadway, New York, USA 2005 June to 2007 May
Role : QA Engineer
Project : Model Ware (Profitability Maps, Custom Charts, Taxonomy)
Description:
The Following Applications are tested on Model Ware:
1) Profitability Maps:
The Profitability Analysis application provides a graphical presentation of the relative historical and forecast trends for a universe of companies, using recommended Model Ware Profitability Tree metric pairs, or custom metric pairs of your own choosing.
2) Custom Charts:
The charts application provides a graphical presentation of the relative historical and forecast trends for a universe of companies of groups of companies, using either Model Ware metrics or your own custom metrics.
3) Taxonomy:
Taxonomy is to define the business rules that determine what types of data are handled by the Model Ware system, and how this data is captured, processed and retrieved. Most of these rules are addressed by the Data service.
Responsibilities:
• Prepared Test Cases based on functional requirements using Quality Center.
• Prepared Test Plan and Test Cases based on the User story/Business requirements
• Used back-end database SQL queries to perform data testing
• Created and executed QTP scripts based on requirements.
• Evaluated QTP Results.
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process
• Manually executed the test cases for positive and negative scenarios.
• Testing SQL Server Reporting Services.
• Executed the Data Base SQL Scripts, created by the data Base team.
• Involved Data migrating testing.
• Analyzed system requirement and functional requirement documents.
• Created SQL queries to test the different scenarios in the application.
• Responsible for entering, Tracking bugs in Quality Center to resolve bugs.
• Performed regression testing and validated fixes to the system using QTP.
• Work with developers, business and Release managers to discuss ways to fix the Defects.
• Building and releasing changes into the QA, staging, and production environments.
Environment: QTP, Quality Center, Load Runner,.Net, XML, Window NT/XP, JSP, JDBC, HTML, JNDI, Java Script, AJAX, CSS, XML, visual studio .NET 2003, DTD, XSD, Web Services, LDAP, WSDL, JAXB, DOM, RAD, Web sphere, MQ Server
Client : ROCHDALE-NW BRAIN 2002 Mar to May 2005
Role : Qa Engineer
Project : ROCHDALE-NW BRAIN SPORTS EVALUATION APPLICATION
Description:
The aim of the project is to build an online application to gather and monitor information about sport in Rochdale, from a strategic, tactical and personal perspective. The project will allow the sports development agencies to manage the promotion of sport; the clubs, coaches and teachers involved in sport to manage their charges; and the individual participants to track their progress as they develop.
Responsibilities:
• Prepared Manual Test cases and Test procedures.
• Used back-end database SQL queries to perform data testing
• Prepared test cases for API.
• Interacted and coordinated with customer groups, Business analyst and technical stop involved in the testing process.
• Prepared Test Cases for Every task including Initial logins and logouts.
• Conducted Manual Testing.
• Performed black box, regression, functional and integration testing
• Analyzed Test Results.
• Interacted with developers and discussed technical problems, reported bugs and supported to development team.
Environment:.Net, XML, Window NT/XP, JSP, JDBC, HTML, JNDI, Java Script, AJAX, CSS, XML, DTD, XSD, Web Services, WSDL, JAXB, DOM, Apache, PBN
Contact this candidate