Ramchandar Velivela

Senior QA Analyst / QA Lead

Professional Summary:

Work experience with major players in the fields of Insurance, Pension & Benefits, Finance, Re Insurance, Government, Healthcare, education, and e governance.

Over 16 years solid IT experience in Quality Assurance, Testing, Cloud Platform Certification, predictive analysis (SAS Enterprise Miner), process mapping, visual modeling and Systems Analysis of N-Tier applications spanning across web-based applications and Client-server applications in J2EE, SOA Integration and EAI Integration environments.

Extensive experience in Manual and automation testing, User Requirements analysis, Test case /Scenario development, Smoke Testing on Nightly Builds, Infrastructure Testing, Black-Box Testing, Regression Testing, Integration Testing, Systems Testing, Back-end Testing, User Acceptance Testing, End-2-End Business Flow Testing, Usability Testing, Application Performance testing, and Creating & Execution of Selenium/JMeter scripts.

Wide experience in Agile Testing Methodologies, SDLC Processes, Water Fall model, complete life cycle development of Client/Server, Internet, and Database Applications.

Knowledge of developing websites in HTML and PHP.

Extensive experience in Product Demo testing activities, Track/Sprint execution activities, Validation & Verification preparation & execution activities, Go-Live activities and Project Management activities.

Strong experience of testing applications in Server/desktop virtualization environments - Citrix/ VMWARE, Application Servers - IBM WebSphere/Oracle WebLogic, and Windows Server

Proficient in Issue/Defect Management, Deliverables Management, Work flow management, Document Management, Bug tracking tools, Deployment process, VSS, MS Visio, MS Project, MS Excel and Snag IT.

Extensive experience in testing applications with SQL Server 2005 / 2007, Oracle 9i, Java Script, HTML, Visual Basic, ASP environments.

Hands-on experience in developing technical/testing documents including QA Plans/Test Strategy /Test Schedules documents, Testing/Implementation Road Maps, Requirements Traceability Matrix, Release Notes, Business Case documents, Functional Specification documents, Test metrics preparation, system requirements, user manuals, UI Guidelines, Enhancement documents, FAB Analysis documents and standard operating procedures.

Extensive involvements in Test Case Reviews, Test Results Analysis, Development & Design sessions, scrum meetings, New hire trainings, Mentoring Team Members, Task Assignments, Status Reporting, Institutionalizing Quality, Improving ROI by Value Additions to the product, and Demo Readiness activities.

Experience in Effort Estimation (COCOMO, Function Point Analysis, Historical Performance), Cause and Effect Analysis, Pareto Charts, Critical Path Analysis, Basis Path Testing, Boundary values, Data Flow Testing, Branch Testing etc.

Providing online support (24*7) to development and testing teams (In-house and client teams). Able to work nights, weekends and schedules as necessary.

Strong collaboration with stakeholders, Dev Teams, Business Development Teams, SMEs to elicit requirements, to define acceptance tests, to uncover hidden assumptions, to formulate best practices etc.

Technical Skills:

Technical and Business Skills

Operating Systems

WINDOWS 95/NT/2000/XP/7/Vista/LINUX/UNIX

Functional Testing

Selenium, SoapUI, Silk Test, WinRunner

Database Technologies

Oracle Application Express 5.0

Performance Testing

Jmeter, WAS Tool

Bug Tracking/Management

Quality Center, Bug Zilla, Workflow, Track, JIRA, Test Link

RDBMS

SQL PL/SQL, Oracle

Development Processes & Methodologies

Agile Testing Methodology, Waterfall, SDLC, SCRUM, RAD, RUP Processes

Integration Technologies

SOA, EAI, J2EE

Predictive Modeling

SAS Enterprise Miner, Regression Modeling, Neural Networks Modeling

Business Processes

Business Process Management, Business Process

Modeling, IT Governance

ERP Tools

SAP NetWeaver Sales & Distribution & Materials

Management, Balance Scorecard, Workflow Builder

Web site Development

HTML, PHP

Mobile Development

Android Studio

Others

UML, MS Visio, MS Project 2013, Snag IT, Rational SoDA, Project Analyser

Education & Certifications:

Masters in Management Information Systems (MS in MIS), University of Illinois, USA

Master’s in Business Administration [MBA]

Bachelor of Commerce [B. COM]

PG Diploma in Computer Applications [PGDCA], ICSS, India -

Diploma in Software Technology & Systems Management, NIIT, India

IBM Mainframe S 390 Certification, India

Certification Course in E-Commerce (E-COM), India

Professional Experience:

Follett Corp, McHenry, IL

Senior QA & Web Developer May 2014 – February 2015

This Test Project supports the development of Destiny Resource Manager Solutions in an Agile way. DRM solutions are the automation tools schools trust to help manage everything from library books to laptops, textbooks to trombones and computers to curriculum kits. Having a complete picture of what you own, where it is, and knowing where it needs to be allows districts to maximize resources, minimize the cost of lost assets, more accurately forecast for future purchases and ensure students have access to the materials they need to succeed.

Responsibilities:

Managing day to day Test Activities in Agile development environment.

Creation of Test Strategies and Road maps.

Setting up Test Environments

Performing DB Upgrades and Java server’s initializations for every code changes.

Database and system analysis.

Involved in preparing of User Stories and subsequent Test Cases / Scenarios

Involved in strategizing of Test Plans and Test Strategies for end-to-end testing.

Testing the Applications in Seeded and Integrated modes including Development environment, Integration environment, UAT environment, DMO environment, and PROD environment.

Build and Deploying of Destiny applications.

Implementing Best Test Practices and improving Test Processes.

Project management using Version One tool

Creating Chump Tasks and tracking.

Managing Tests in Java XP Tool.

Actively involved in product customizations and feature enhancements.

Coordinating with Developers in implementing new features and fixing of issues/defects.

Coordinating Daily stand ups.

Test coordinating with off shore teams.

Test Results review and analysis.

Daily and weekly status reporting.

Managing releases.

Environment: Java XP Tool, Java, JBoss, Version One, MS SQL, Chrome, Safari, Firefox and IE.

Nokia – HERE Chicago, IL July 2013 – March 2014

Analysis - Senior QA Tester

This project helps to support by Nokia’s Here Location and Services solutions Monitoring, Alerting and Reporting of HD-RDS live data feeds. This technology of HERE is based on cloud computing ‘Thor’ in which location data and services are stored on remote servers so that users have access to it regardless which device they use.

Responsibilities:

Writing Test Plans and Test Scenarios in Agile development environment.

Creation of Test Strategies and Road maps.

Delivering quality products within Sprints.

Preparation of UAT Test cases, based on Acceptance Criteria.

Involved in Agile development process, SCRUM and Kanban.

Sprint Planning within SCRUM framework.

Project Management using JIRA.

Preparing & maintenance of Teams Agile Boards using JIRA.

Creation of Epics, User Stories, Tasks, Sub-Tasks, Defects in JIRA.

End-to-end testing of the products.

Back-end testing / validation (Oracle SQL) of live data feeds from the HD-RDS feeders.

Monitoring applications, Servers, hosts and services statuses by using Nagios IT Infrastructure monitoring tool.

Defining the logic for HD Importer’s up and down status.

Involved in defining applications functional specifications.

Creation and executing of Failover scenarios for HD-RDS statuses.

Testing the data quality for Incidents services.

Involved in database design and product designs.

Functional, Integration and system testing of Online applications (Live data / maps probes and incident data quality testing for Locations and Content mapping for Garmin)

Deployment of QA builds / environments in Unix/Linux environments.

Testing the products on VMs deployed on Thor (cloud platform).

Monitoring the error logs in Splunk.

Using Robot framework for automating the functionality testing.

Scripting test cases using Selenium RC.

Preparing Test Documentation using MS Office tools.

Improving the business value for the products.

Providing Value additions to the products.

Defining GUI standards for the products.

Environment: JIRA, Java, SOA, tcServer, Oracle SQL, Selenium RC, Robot IDE, Linux, Chrome, Safari, Firefox.

State Farm Insurance – Cloud Infrastructure/Platform Testing, IL Aug 2012 – June 2013

Role: Senior QA Consultant

Project: State Farm’s VMware Automation and Platform Certification.

This project helps to support provisioning and scenario-based testing of failover scenarios in Cloud and virtualization platforms. Tests POD Management servers by creating and maintaining VMs for GemFire, tcServers, vSplunk, Mule servers.

Responsibilities:

Infrastructure Testing in Cloud environment.

QA Test Automation for Platform-as-a-Service.

Created Provisioning Requirements.

Created Provisioning Test cases, including tcServer, Mule, PostgreSQL, Hperic, GemFire, Splunk.

Created Scenario-based test cases.

Created failover test scenarios.

Provisioning VMs in POD management server.

Created test cases from Requirements and Puppet manifests.

Designed and tested Test Management Console as part of test execution of TestLink Integration.

Created and analyzed WSRR test Cases.

Single point of failure testing in GemFire Data Fabric / Web Session.

Executing test runs of the Cucumber scripts for failover scenarios.

Executing and verifying Resource Checkers in Springsource Tool Suite.

Fully worked in Agile testing process.

Verifying and validating the tests through-out the Sprint Life Cycle.

Technical Environment: TestLink, Trac, Java Spring Framework, SOA, JPetStore. vBlock, vCenter, vSphere, GemFire, Hyperic, Mule, tcServer, PostgreSQL, vSplunk.

Metlife Insurance, NY January 2010 –August 2012

Role: QA Lead

Project: MetLife Insurance -Corporate Benefit Funding

Description:

This project helps to support group and individual insurance administration across an unlimited number of business lines, groups, employers, policy holders and participants in a single, fully integrated, extremely scalable solution. It supports enrollment, billing and administration of annuity, retirement, settlement, health, dental, life, disability and other products in a single system.

Responsibilities:

Created and derived Test Cases/Scenarios from Business Requirements/User Stories.

Implemented and followed Agile Testing Methodology and extensively involved in Portfolios/Tracks/Sprints/Validation/Verification/Go-Live phases.

Executed Functional, Smoke Testing on Nightly Builds, Integration, Back-End, Ad-hoc and Interface Testing.

Testing applications in distributed environments –WebSphere/Weblogic-Oracle/SQL.

Prepared and executed functional test scripts in Selenium.

Involved in Portfolio Planning, Implementation Road Map, Solution Design Document, Release Notes, UAT Test Plans, and Performance stats.

Responsible for testing various V3 modules -Workflow, Call Center, Enrollments & Demographics, Payment Processing, Service Credits Processing, Disbursements, Benefit Calculations, Claims, Loans, Contributions, Pension & Annuities, Imaging, Document, Bookmarks, Reports, Letters, Notifications, Carrier Elections, Eligibility, Self-Services, In-Bound/Out-Bound Documents, COBRA, Tax Reporting, Premium Billing, Structured Settlements, Payroll Deductions, Plan Sponsors, Health Insurers, Third Party Administrators and Network Maintenance modules.

Created and maintained Master Bug Sheets for defects traceability and made availability to Management teams.

Identifying performance bottlenecks by evaluating the current systems and functionalities, creating performance history, monitoring transactions by using log utilities, monitoring sessions (response times, load times) and reporting to Tech and Dev Leads/Managers by using explain Plan/Charts.

Setting up Ideal test environments and Creating & maintaining of Test Data.

Data Priming for application demo and making the application for Demo Readiness.

Mapping Business Requirements to Functional requirements and Functional Requirements to User Stories.

Documenting the Test Plans/Metrics and updating the wiki pages.

Providing Bug Resolutions and troubleshooting techniques to Dev teams.

Technical Environment: WebSphere, WebLogic, Oracle 11g, JAVA, J2EE, Firefox, IE, Chrome, Safari, VM-Ware, Selenium.

Iowa Public Retirement Systems, Des Moines, IA February 2008 - December 2009

Role: QA Lead

Project: Retirement Plans and Benefits Administration for

Iowa Public Retirement Systems,

Orange County Employee Retirement Systems,

Milwaukee County Retirement Systems,

State Teachers Retirement System of Ohio,

New York City Police Pension Fund,

National Electric Benefit Fund,

Hawaii Employee Retirement Systems,

Carpenters Fund Administration Office,

Screen Actors Guild Producers Pension Plans,

Directors Guild of America Pension Plans,

Massachusetts Teachers Retirement System,

The International Union of Painters & Allied Trades Pension Fund,

Steamfitters’ Industry Fund Office,

General Pensions & Social Security Authority of Abu Dhabi.

Description: The project involves Testing of Retirements and pension funds administration application-

Analysis, Functional & Performance Testing, Reviews, Tracking & Reporting of Defects, and Test

Documentation.

Responsibilities:

Creation of Test Scenarios/Test Cases and executing the same.

Performed Functional, Smoke, Integration, System, Adhoc Testing, Back-end and User Acceptance Testing.

Analyzed Business and User Requirements to identify and derive Test Scenarios/Test Cases.

Responsible for Functional & Integration testing various V3 modules -Workflow, Call Center, Enrollments & Demographics, Payment Processing, Service Credits Processing, Disbursements, Benefit Calculations, Claims, Loans, Contributions, Pension & Annuities, Imaging, Document, Bookmarks, Reports, Letters, Notifications, Carrier Elections, Eligibility, Self-Services, In-Bound/Out-Bound Documents, COBRA, Tax Reporting, Premium Billing, Structured Settlements, Payroll Deductions, Plan Sponsors, Health Insurers, Third Party Administrators and Network Maintenance modules.

Review of Test Cases to ensure the requirements are meted to their expectations.

Preparing and maintaining Requirements Traceability Matrix.

Task Prioritization, Task Assignments to the team and Status Reporting to Managers.

Preparing and Executing Selenium Test Scripts.

Prepared Release Notes, UAT Test Plans, Performance stats.

Created and maintained Master Bug Sheets for defects traceability.

Training the new hires on the functionality and business overview of the application.

Technical Environment: Oracle 9i, SQL, PL/SQL, SQL Server 2005/2007, JAVA, J2EE, Firefox, IE, Chrome, Safari, VM-Ware, Crystal Reports.

Department of Community Health, Atlanta, GA November 2006 - January 2008

Role: Senior QA Analyst & QA Lead

Project: Georgia State Health Plan Administration System (Department of Community Health, GA, USA)

Description: To develop a new membership eligibility, enrollment and billing system for the State Health Benefit Plan (SHBP). The SHBP provides health care coverage for state employees, teachers, retirees and their dependents. The new system, V3/HPAS (Health Plan Administration System), is a fully integrated web-based application that will transform the current manual and somewhat burdensome process to a more efficient and paperless environment.

Responsibilities:

Creation of Test Scenarios/Test Cases and executing the same.

Performed Functional, Integration, System, Testing and User Acceptance Testing.

Analyzed Business and User Requirements to identify and derive Test Scenarios/Test Cases.

Primary responsible for Functional and Integration Testing of Self-Service, Enrollments, Contributions, Pension and Loans modules.

Reviewing of Test Cases to ensure the complete test coverage of user requirements.

Preparing and maintaining Requirements Traceability Matrix.

Task Prioritization, Test Schedules, Task Assignments, and Status Reporting.

Analyzing Test Results and preparing Test Reports and Test Metrics.

Helped Developers/Business Analysts/Solution Analysts for clarifications on new enhancements/customizations.

Prepared QA Plans, Release Notes, UAT Test Plans, and Defect Metrics.

Created and maintained Master Bug Sheets for defects traceability.

Worked on multiple tasks in a team environment such as involving in preparation of User Manuals, Solution design documentation.

Coordinated with other departments, provided support to programmers as needed to help them resolve technical and business issues.

Primarily responsible for back-end support to business teams and validating complex scenarios from specifications and ensuring the correctness of the functionality to Business Analyst/Designer /Solution Analyst who works directly with the Business Users.

Technical Environment: SQL Server 2000, Oracle 8i, Oracle 9i, PL/SQL.

Munich Re America, Princeton, NJ January 2006 - November 2006

Role: Senior Test Engineer

Project: CLASIC/2 (Catastrophe Loss Analysis System for Insurance Companies)

Clients: Munich Re, Department of Homeland Security, AON, Guy Carpenter & Company.

Description: CLASIC/2™ is a Desktop application that enables insurance and facultative reinsurance underwriters, catastrophe risk managers, managing general agents, claims managers and others, to assess the catastrophe loss potential of individual risks, policies, and portfolios of policies. It estimates and reports full probabilistic loss distributions for individual or multiple risks within one policy. Evaluates loss mitigation strategies and enables "what-if" analyses for individual risks.

Responsibilities:

Preparing Test Plans, Test Cases and Test Scenarios.

Functional and Regression Testing of the application.

Automation testing of by Silk Test, Report Generations, deployment and kickoff process.

Analysis of Probabilistic Loss values.

Involved in Loss estimations and analytics with Analytics Teams.

Compare exposure data with AIR’s US Exposure Database.

Test Results analysis and Status Reporting.

Proficient in testing and understanding of various catastrophe models - Earthquakes, Extra Tropical Cyclones (Winter Storms), Severe Thunderstorms (Tornado, Hail, Straight-Line Winds), Tropical Cyclones (Hurricanes, Typhoons), Terrorism, Flood and Wildfire.

Technical Environment: VC++, .NET, SQL, IE 5.0 & above (Embedded Browsers)

ISO Inc, Jersey City, NJ March 2005 - December 2005

Role: Senior Test Engineer

Project: ISO Home Value

Description: HomeValue™ is an innovative property replacement valuation system that provides the reliable estimates. Based on advanced component technology, it utilizes tens of thousands of the latest individual component costs, organized into structural assemblies. With as little information as an address and a few specific property characteristics, it produces an initial estimate of replacement value.

Responsibilities:

Functional Testing of the Application.

Verifying and validating the replacement values.

Assessing and estimating the accuracy of the replacement costs for residential units and individual condominium units.

Testing the application with different building costs and codes and verifying the values.

Technical Environment: Web-Based Application, VC++, .NET, SQL, IE 5.0 & above.

Citibank, Warren, NJ August 2004 - January 2005

Senior QA Analyst

Citibank Retail Financial Services, concerns processing all documents for different LOB’s, such as Correspondent, Home Loan Direct, Business loans, Home Equity etc. Wealth management system (WMS), the project involved development of a web based application used to update the customer details. This system is highly secured and allows only authorized users to create new bank accounts and reconciles checks. Application has many reports like Stop/void checks Report, Re-printed checks report, Manual entries, user activity and many more.

Responsibilities:

Performed detailed study of user requirements to get a better understanding of the functionality and Determining test approaches and methods.

Involved and developed QTP-Automation frame work, Test Strategy, system test plan and Scripts.

Wrote/Recorded scripts when necessary and customizing the recorded scripts, running the scripts on a new build.

Developed custom QTP function libraries (like Object Oriented Functions, Database Functions, and Utilities etc).

Converted the Object Repository from local to shared Repository.

Created and maintained automated tests using QTP by coding in VB Script.

Created test data needed for testing.

Tested execution and scheduling from Quality Center. The test execution is unattended with no manual intervention.

Interacted with the team on a regular basis and attended meetings on a daily for status updates.

Developed and maintained automated test scripts to support regression testing.

Used Quality center to log defects, track and generate defect reports and graphs.

Performed Batch Run for every release of the Application.

Provided day to day support, bug fixes, training, documentation etc.

Involved in on-going maintenance and support of the existing automation scripts.

Provided functional support to user groups and created training material.

Environment: VB.net, Java Script, AJAX, MS Visio, Quick Test Professional 9.5/10, Quality Center 9/10, MS Team Foundation Server.

DSR Solutions Ltd., Hyderabad, India September 2000 - May 2004

Role: Senior QA Engineer & Team Lead

Project: Enterprise Optimus 1.0

Clients: Government of AP, National Informatics Center, India, Tata Tele Services.

Description: A web based Enterprise Process Management & Professional Services Automation product. It assists organizations to identify the processes that are most critical and validate the improvements that are necessary to reach the desired outcome resulting in and improving bottom line financial results.

Responsibilities:

Manual Testing: Functionality Testing, Regression Testing, System Testing,, Validation Testing, Integration Testing, Installation/Uninstallation Testing, User Acceptance Testing, Load & Stress Testing, Code Walkthroughs & Browser Compatibility Testing. To carry out the testing effectively the testing is carried out in Virtual Machines i.e., Virtual PC and VMWare by simulating the exact client environment.

Testing the tiers independently (Presentation tier, Business Logic tier and Data access classes) by writing the client stubs and retrieving the parameters dynamically from the test data.

Automated Testing: Created Test Scripts using WinRunner for processes where Regression testing is required, Generalized the test scripts by creating check points and synchronization points, Created database check points to check the updated data in the database, Created test scripts to check the various validations and conditions. Created Test cases and scenarios for exerting immense load and stress on the product and executed with the simulation of large number of Vusers. Identified bottlenecks and involved in performance tuning with developers.

Developed and Modeled: Test Plans, Test Strategies, Integration Test Plan, Acceptance Test Plans, Templates & Checklists, Standards, Test Cases, Functionality Test Procedures, Performance Test Procedures, Created ideal Test Environments, Defined User patterns, Defined Quality Process and Models, Prepared Product Manuals & Online helps.

Analysis Done: Defect Density Analysis, User Requirements Analysis, System Analysis, Process Analysis, FAB Analysis, Client Requirements Analysis, Feature Customization Analysis, Performance Analysis, Identified performance bottlenecks & functional gaps.

Reviews Done: User Requirements review, Analysis & Design reviews for System, Database & User Interface, Prototype design review, Process reviews &Integrated functionality review.

Implementation: System studies, Product Deployment at Clients places, Data migration, Training to end users, User acceptance testing, Implementation sign off & closure, Product support 24 * 7, Case studies & Online support through conference calls, NetMeeting, phone and email.

Additional Tasks: Preliminary discussions of the project with the core teams, Integrated with Developers/Process Analysts and discussed technical and functional problems, reported bugs and supported development team. Used Track Record for defect tracking and Test Director for defect management, and Regular/timely updates on progress.

Extensively involved in Complete Product Life Cycle Management with Rational Unified Process (RUP).

Technical Environment: VB, VC++, ASP, COM+, XML, XLST, MSMQ, IE 5.5 and above, SQL 7.0 & 2000, Windows Advanced Server, Win 2003 & Win XP, Windows Professional/Advanced Server, Back-End Testing, WinRunner 7.0 & LoadRunner 6.5.

Contact this candidate