RAJASEKHAR REDDY CHELIKAM
SUMMARY
9 yearsof professional experience in Information Technology with extensive experiencein leading and managingManual and Automated Testing in projects dealing with Web, GUI, Web services, and Mainframe related applications.
5+ years of experience in leading the Software Quality assurance teams through the manual and automation frameworks.
Extensive experience in Functional, Integration, System (End-to-End), UAT and Regression testing.
Expertise in performance testing of web applications using HP Performance center and experience in load testing.
Experience in both Front end and Back endtesting.
Expertise in Insurance, Health Care, HR and Financial domain projects.
Technically very strong in Analysis, New Programs Development, Problem analysis and Bug Fixing - on day to day basis.
Strong knowledge and experience of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle and QA Methodologies like Waterfall, V model and Agile.
Expertise with the projects aligning with the HIPAA, Health Care Reform (HCR), ICD10 compliance projects.
Expertise in working onagile software methodology and participated in SCRUM meetings for sprint planning and reviews.
Prepared Training Materials, Quick guides and Job Aids for the end users.
Participated in internal and external reviews in required phases.
Planned Knowledge transfer to the new members of the team.
Managed teams both in offshore and onshore. Team size extending from 20-45 members.
Experience with Data Warehouse testing and reporting after performing data validations using Informatica.
Weekly status meeting with Development and management teams to discuss bugs and other issues
Experience in facilitating the JAD sessions and also participated in the JAD sessions as Scribe, Subject Matter Expert.
Worked in Static testing of all the available requirement documents and design documents.
Working experience in Requirement traceability Matrix (RTM) document preparation and maintenance.
Expertise in Test planning and Risk analysis.
Experience in test management and automation tools like Selenium IDE, HP ALM.
Experience in the testing of API’s for the web testing projects using SOAP UI.
Good Exposure in Using of QTP Integrated Environment (Working with object repositories, Actions, Check points, Output values, Parameterization, Synchronization, Recovery Scenarios etc.)
Proficient with the Microsoft office applications and other test management tools like HP Quality center, IBM Clear Quest, HP Quick Test Pro, IBM Clear Case.
Experience in deriving Test scenarios, designing Test procedures, writing Test cases using Black box testing techniques and preparing the Test data.
Good understanding of the web technologiesdealing with the HTML, HTTP/HTTPS, TCP-IP and XML protocol.
Experience in Preparation of Automated Tests within the Keyword driven and Data driven frame work.
Worked with Application Delivery team, other resources, development vendors and other third parties as appropriate to obtain approval for test scripts prior to the start date for test execution.
Extensively worked with varioustools SPUFI, INSYNC, XPEDITER, IBM DEBUG, FILE-AID/RDX, FILE-AID/DS, EXSTRAM DIALOUGE, Endeavor and Dump Master.
Involved in performance tuning of application side the SQL s can be tuned to make them more efficient and avoid redundancy.
Expertise in Defect logging, tracking and management in Clear Quest, JIRA. Uploading Defects into Quality Center and mapping the related scripts to the defects.
Expertise in MS excel and pivot tables to generate the defect analysis report over a period of the quarter to analyze the defects.
Expertise in organizing the triage calls to go over the defects
Involved in Verifying readiness of the product for release through release review, obtain customer acceptance on the deliverables, work Allocation to the team, authorize intermediate deliverables and patch release to customer.
Good understanding of Relational Database Management Systems. Proficient in writing SQL queries using Query Analyzer, Toad for Backend testing.
Experienced in working with MS Excel, MS Word, MS Outlook, MS Access, MS Project, and MS Visio
Excellent analytical, problem solving, and interpersonal skills.
Ability to quickly understand complex business application and program functionality.
Ability to handle multiple tasks with aggressive approach to meet deadlines and deliverables.
TECHNICAL SKILLS
Operating Systems / UNIX, WINDOWSLanguages / C, VB Script, PL/SQL, XML, HTML
Servers / Transaction servers- CICS and TSO/ISPF, WebSphere Application Server
Testing Tools / HP QTP, HP Quality Center, HP ALM, RFT, Selenium, IBM Clear Quest, HP Performance Center.
Database / Oracle 10g/9i/8i, SQL Server 2005/2003/2000, DB2, MySQL, Microsoft Access.
Office Tools / Lotus Notes, MS Outlook, Jira, Clear Quest, Symphony, MS Excel, MS Power Point
Version Control / VSS,IBM Clear Case
Knowledge in / SOAP UI, HP Load Runner, Informatica 8.x/7.x/6.x, Toad 9.0/8.5.1,SQL Loader, SQL *PLUS, SQL Navigator 4.4,Query Analyzer
PROFESSIONAL EXPERIENCE
CLIENT/PROJECTDURATION
ORGANIZATION
ROLE
SELECTIVE INSURANCE MAR 2016–Till Date
COGNIZANT TECHNOLOGY SOLUTIONS
GLASTONBURY, CONNECTICUT
Sr. Associate - Projects
Selective Insurance Group, Inc., is a regional insurance company based out of Branchville, NJ. The company provides Property and Casualty insurance services to customers in the united states. It is the 41st Largest U.S Property and Casualty group. There a network of distribution partners, working and procuring business with various products and services. It is also the 6thLargest “Write your Own” carrier in the National Flood Insurance Program.
Project details:The current claims system is close to 20 years old which is becoming slowly redundant and with the volume of claims increasing, an initiative was started by Selective to upgrade the claims system. The new claims system is a web based client server application, which processes the claims at a faster pace by allowing the claims engine to integrate with various numbers of interfaces which will help the claim examiner to guide the claim in the right path and pay the insured according the norms and coverage.
Responsibilities:
Involved in design discussions of interfaces that will enable the claims system to co-ordinate with the third party interfaces.
Planning, monitoring, and control of the Project testing activities and tasks.
Estimate the testing to be done and work with management to acquire the necessary resources to fulfil the requirement.
Analyse the requirements identifying any foreseen risks and brings it to the project management team, thereby mitigating any potential risks that will jeopardize the project.
Create test approach for the testing team to ascertain that the entire development changes are evaluated to capture all the bugs within the project.
Responsible for auditing development team design documents to capture any potential issues very early giving the architect and the development team to resolve the potential issues.
Review the test plans, test design documents with the stake holders to ensure that all the possible and accurate test scenarios are captured.
Conduct project triage calls to discuss on the project status, defects captured during the test execution phase with the Project management and the development leads.
Responsible to create and document all the required documentation for the project audits ensuring that the team is following the accurate process.
Assisting the project manager in providing POC’s for new projects coming into testing space.
Responsible for developing and maintaining testing frameworks, solutions and create Business test scripts for the automation team to create automation test scripts using HP’s Unified Functional Testing (UFT), HP Application Life Cycle Management (HP ALM),SOAP UI/READY API, Microsoft SQL Server Management Studio etc.
Responsible for using established test methodologies and using HP ALM for defect tracking, requirement gathering, planning, analyzing results, storing and executing automation scripts for any regression or smoke testing.
Evaluate test processes and procedures and makes recommendations for improvement. Provide timely status to the stakeholders and management and instils confidence about the work being done.
Managing the data masking and data management activities across the test environments.
Executed SQL queries to fetch data fromSQL database to perform backend database testing, validate and compare expected results with those actually obtained.
AETNA STUDENT HEALTH/ASH MIGRATION OCT 2013– MAR 2016
INFOSYS LTD
BEDFORD, NEW HAMPSHIRE
SQA LEAD
Aetna Student Health is a national leader of health and related benefits offering health insurance, pharmacy, dental, life, products for college students. It is a subsidiary unit of Aetna Inc. dealing with student health insurance plans. Aetna Student Health serves health insurance benefits to over 500,000 medical plan students and their dependents in over 200 colleges and universities. The various products they offer are from medical, sports, international plans.
Project details: The current system which is being used to manage the day to day activities is becoming redundant. With the ICD10 project changes and the security impact, the Aetna team decided that the application should be moved to much safer and robust system which can be easily updated to all the mandatory CMS requirements. The migration included to create a replica of the existing system using the Java interface and HTML pages. The system is also used to contact some downstream applications to re-use the existing system within Aetna Inc. Team size of 25 members.
Responsibilities:
Involved in different modules of FACES system like Protocols, Investigation and Assessment, Case management, Eligibility, Resource and Financial Management.
Analysing the programs and corresponding screens, carrying out the impact analysis
Involved in analysis, design, coding and unit testing of several screens in different function areas like Protocols, Investigation and Assessment, Eligibility, Case Management, Resource and Financial Management and General.
Gathering the requirements and analysing the existing system.
Review of Test Plan, Test Strategy, Test Case design, Test case execution and Test summary.
Peer review of the Code, design documents, test plans and test results.
Involved in performance tuning of application
Organizing meeting with the department heads when changes are recommended for the existing system for performance improvement.
Performed Functional (User Interface), Backend, Performance testingusing HP load runnerand Regression testing using the Web browser and mobile application(IOS and Android)
Prepared Training Materials, Quick guides and Job Aids for the end users.
Participated in internal and external reviews in required phases.
Knowledge transfer to the new members of the team.
Participated in Release and Production Support.
Weekly status meeting with Development and management teams to discuss bugs and other issues
Coordinating execution of Manual installations followed by the smoke and sanity testing.
Created the automation test suite for the regression testing using the Quick Test pro.
Managing the data masking and data management activities across the test environments.
Executed SQL queries to fetch data from SQL database to perform backend database testing, validate and compare expected results with those actually obtained.
Worked in Agile ( Scrum) Environment using the HP ALM Agile manager
Performed front end cross browser compatibility testing.
Working with UI and Mid-Tier Business teams for any technical or business related queries
Performing other functions such as systems analysis and design, user coordination, and systems documentation and technical research.
Responsible for performing Functional testing on the application and involved in Quick Analysis of Production Bugs.
Verifying program logic by overseeing the preparation of test data, testing and debugging of programs.
Developing new documentation, departmental technical procedures and user guides.
AETNA INC/HMO CLAIMS SYSTEM FEB2010–OCT 2013
INFOSYS LTD
BLUEBELL, PENNSYLVANIA
SQA LEAD/ ONSITE CO-ORDINATOR
Aetna, Inc. is an American health insurance company, providing a range of traditional and consumer direct health care insurance products and services, including medical, pharmaceutical, dental, behavioral health, group life, long-term care, and disability plans, and medical management capabilities. Aetna is a member of the Fortune 100.
Health Maintenance Organization (HMO) is a type of managed care organization that provides a form of health care coverage in the United States that is fulfilled through hospitals, doctors, and other providers with which the HMO has a contract. Members enrolled in Aetna’s healthcare programs visit health services providers such as primary physician, specialist, hospital or pharmacy to receive healthcare. After rendering services the provider or member needs to file a claim with Aetna in order to be reimbursed for the service. HMO claims processing system adjudicates the claims. The claim adjudication process is based on the business rules and the policies of Aetna. The adjudication process determines whether the claim should be paid or denied, and also the payment amount.
Worked in a total of 45 projects and 78 change requests during my which included compliance projects, HCR projects, ICD10 remediation projects, End to End Projects. Team size of 45 members
Responsibilities:-
Performed Functional (User Interface), Backend, Performance testing and Regression testing.
Participated in Requirement Analysis and Requirement ambiguity review meetings to normalize the requirements with clients.
Worked in Agile( Scrum) Environment.
Communicating with the onsite and offshore team and reviewed the work done by them.
Prepared Traceability Matrix, Test Plans, Test Scenarios, Test Cases and Test Data.
Expertise with the projects aligning with the HIPAA, Health Care Reform (HCR), ICD10 compliance projects
Establish test data for testing the application.
Worked with QTP to automate sanity testing.
Executed SQL queries to fetch data from SQL database to perform backend database testing, validate and compare expected results with those actually obtained.
Used concepts of Parameterization, Check points, Output values, Synchronization, Recovery Scenarios.
Developed test scripts using VB Script in QTP.
Performed System testing by executing Positive and Negative test cases using QTP.
Configured, monitored and analyzed the performance of the server by generating various reports for CPU utilization, Memory usage, load average
Worked in keyword and data driven frame work.
Performed Report and data validation testing.
Created and maintained RTM, Test logs, defect logs and test summary reports.
Performed integration testing with the database team.
Exported Test cases and Requirements from Excel sheet to Quality center.
Defect logging in Quality Center and preparing reports and graphs in requirements, Test plan and Defects modules.
Worked on the Black Box testing using QuickTest Pro.
Reportrisks and all the issues, prioritized them and assigned the issues to the development team.
Participated in peer reviews.
BANK OFAMERICA JUN 2009–FEB 2010
INFOSYS LTD
ORISSA, INDIA
QA ANALYST
Project: GMI Trade Surveillance
Trade Surveillance is a vital process for bank application. Share market trading has some pre-defined rules which are not to be violated. Any person/ institution violating any rule will be generated an alert with their trading details. Actimize case Manager closely monitors trading and generates alert to concerned trader in case of any violation.
Responsibilities:
Involved in functional testing of alerts, database testing of complex stored procedures, triggers and Analysis of data.
Worked on Test scenarios based on credit card testing.
Prepared test plans and test data setup to test different models.
Worked as defect anchor and maintained defect life cycle.
Worked as test lead for sub modules (rules).
Generated graphs and reports in Quality Centre.
Analyzed Stored procedures to understand the core logic implemented.
Scheduled daily triage meetings.
Automated Sanity check and Regression testing.
Involved in Requirement elicitation process along with a Business Analyst and a developer.
Involved in Globalization testing as the product runs across the continents.
AEPPAYS NOV2008–JUN 2009
INFOSYS LTD
ORISSA, INDIA
TEST ENGINEER
Project Details: Aetna, Inc. is an American health insurance company, providing a range of traditional and consumer direct health care insurance products. AEPPAYS application is used for processing Payments for different AETNA Claims. The data processed from different claims are processed and the payments are made to respective provider. Different types of products are created and sent to respective provider and members based on the subscriptions.
Responsibilities:-
Developed Manual Test Cases and Automation Test Scripts based on Test Plan after analyzing Functional Requirements Documents and Design Documents.
Worked in static testing of available requirement and Design documents.
Prepared and executed SQL queries in IBM DB2 QMF for Data Validation, Data Verification, Data Conditioning and Data Integrity of claims from multiple databases.
Expertise in File-Aid in storing and retrieving data from mainframe files.
Expertise in Primary and In-Line commands in TSO/ISPF and analyzing the jobs submitted in spool based on JESMSGLG, JESYSMSG, Input Queues, Output Queues and SYSOUT.
Covered all the logical flows and wrote all the basic functionality and error handling test cases for each scenario.
Thoroughly tested the various modules of the application manually before going into the automated testing.
Exported requirements and test cases into the Quality Center.
Tracked the bugs and reported them using Quality Center as a defect tracking tool and performed regression testing.
Automated Sanity check and Regression testing.