Test Cases Data

Ramesh Cherukuru

Tel: 310-***-****, Email: ***********@*****.***

Professional Summary:

Over 7 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals

Extensive experience in Software Testing and Quality Assurance of Web-based applications in Media and Entertainment Security Services and Ecommerce, Health Care Insurance, Health Care Provider and DIRECTV, ATT Services Inc. Domains

Experience in Automation Testing using Selenium WebDriver, GitHub, Maven, TestNG framework

Experience in interacting with Onshore-offshore management for the Project Updates

Good Understanding of Testing Processes, Quality Assurance Methodology, Software Development Life Cycle and Testing Life Cycle

Extensively used Selenium WebDriver for functional testing and built regression suites

Expertise in Test Planning, Test Cases Designing, Test Environment Setup, Test Data Setup, Test Execution, Defect Management, Analysis and Reporting

Experience in Sanity Testing, Data Driven Testing, System Integration Testing (SIT), Functional Testing and Regression Testing

2 year of experience in Big Data / Hadoop which includes HDFS, Map Reduce, Hive, Pig, Kafka, HBase,

ZooKeeper, Flume, Sqoop, Spark, Oozie, Java/J2EE.

Good Experience in SAS and SAS/SQL, Oracle RDBMS, Oracle 11i.

Expertise in documenting defects with high level of detail, accuracy, and informative recreation steps

Experience in testing the Java, .Net, Sales CRM, OMS Sales Force, WebServices, Database and Siebel applications

Expertise in lifecycle methodologies like Waterfall, V-model, Agile Models and TDD (Test Driven Development) methodology

Experience in handling Merger Projects, successfully managed Application and Data migration

Experience in leading and managing teams. Handled multiple roles - E2E Test Architect, Project Test Coordinator, Test Analyst, Test Specialist, Subject Mater Expert (SME),, Software Tester

Aptitude and willingness to learn and implement unknown technologies, always thrive to smarten the tedious methodical work using Innovative Ideas

Good communication skills, interpersonal skills, self-motivated, quick learner, team player and ability to work independently with minimal supervision

Strong Ability to handle multiple assignments at the same time

Technical Skills:

Tools:

Selenium WebDriver 2/3, HP QC 11, HP ALM 11, HP QTP, HP UFT 12, TDP 6, Reflection, IBM Rational Team Concert (RTC) 5, SoapUI 5, SQL Developer 4, Eclipse 4, Oracle 11g, Fiddler 4, IBM Functional Coverage Unified Solution (FoCus) 2

Operating Systems

Windows 98/XP/Vista/7/8/10, Linux, Unix

Languages:

VBA, Java, Oracle SQL

Professional Experience:

DirecTV/AT&T, El Segundo, CA

All DTV Accounts will be Converting into ATT Billing System (Enabler). Convert the set of accounts into the Target System in Different Mocks. For Hadoop Project Supplier Management System (SMS) is a financial system, which calculates all the financial agreements between content supplier and content provider, based on customer transactions with data size of 80GB to 90 GB for each period/Day, using Hadoop and DataTorrent (Streaming application).

Roles and Responsibilities:

Sr. QA Analyst (Billing Conversion) Nov 12 – Present

Responsible for leading a project team in delivering solution to our customer

Managing End To End Test Team and Billing team

Understand project requirements, coordinate with resources and direct the projects in the right direction in a timely manner.

Involved in all phases of Application & Data migration to AT&T systems, starting from planning till operations phase.

Evaluated problems, identified root causes and outlined resolution options

Provide technical advice to project teams and client on Billing and billing data conversion.

Requirement Analysis, Design, Test Preparation, Test Execution, Report Defects, peer review of Test Scenarios

Working experience with JIRA (defect management and test management)

Responsible for managing and reviewing Combinatorial Test Design Attributes

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Work with Test Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals

Present and define product designs and architecture to clients

Coordinate and communicate tasks with developers

Create test scripts and scenarios for enhancements and customizations to the core product

Ensure that developed code is working as per requirements

Communicate activities/progress to project managers, business development, business analysts and clients

Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: Siebel/ALM/OMS/SQL Developer/Billing(STMS), JIRA

Hadoop Tester Aug 13 – Oct 15

Worked on Data Migration application from Oracle to Hadoop

Write scripts using HiveSQL, and Unix

Write and execute SQL queries to work with structured data available in relational databases and to validate the transformation/ business logic

Organize feature demos for the Product and Engineering leadership team.

Maintained and deployed builds to the QA environment.

Understand data mapping from Source to Target tables and the business logic used to populate target table

Verify and validate missing, duplicates, null, and default records as per the design specifications

Assist in preparing weekly status, test execution, and test metrics reports

Responsible for review of all test reports and provide the QA sign off for all the staging deployments

Verify the Data flow ( Data mapping, Counts) from source to target

Verify the data Transformation logic from source to target works as expected

Verify the Database structural changes if any, DB fields and field data is loaded without any truncation

Perform Data validation like - Valid values, null value check, duplicate check, blank record check, and ? checks

Verify and Validate the data integrity

Importing and exporting data from different databases like Oracle, SQL server into HDFS and vice versa using Sqoop.

Hands on experience in testing and comparing with large data bases and files.

Tested the data in various upstream, downstream system files that were critical for business operations

Prepare regression framework to re-use and improve the turn-around time of testing

Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDV

reference tables and historical metrics

Created Sqoop reusable frameworks for data Import and Export and tables creation in both Hive and Oracle

Automated the scripts for production/SQA environment using Autosys and Linux Cron jobs.

Created the test scripts and test plans for the project and also documented the test procedures and issues.

Used to Automate the test process with Cucumber and selenium, by writing the functional method for each step in Eclipse IDE.

Helping Admin team to setup all environment and clusters and Helped the team to understand the functionality of each concept.

Used to schedule the calls to Development and Operations teams to discuss the functionalities and also with the business team to give the UAT.

Environment: HADOOP 2.0, CDH5.4, Beeline, Hue, Hive, Pig, HBase, Sqoop, Oozie, DataTorrent, Eclipse, Java, Oracle10g,11g, Autosys, Unix shell Scripts, REST, HP-ALM (Application lifecycle management).

McKesson Corp Spring Field MO Jun 13 – July 13

QA Analyst

McKesson Provider Technologies is committed to the success of your healthcare organization. McKesson deliver comprehensive solutions that enable hospitals, health systems and other providers to use IT more strategically for better business, better care and better connectivity.

Responsibilities:

Analysed the Business requirements and the specifications and Developed Testing Strategy for entire application and developed various Test Cases.

Tested extensive backend testing by using database query tools SQL Server, SQL Queries to retrieve the data from the database and checked data integrity and Data Validation.

Involved in Identify process improvements via version upgrades, new tools or reengineering of existing solutions Analysed the Business requirements and the specifications and Developed Testing Strategy for entire application and developed various Test Cases.

Executed Test Cases with a set of test data to verify the data validations.

Analysing Test Results & Identify bugs and reporting to the developers using Quality Center.

Involved in testing to run SQL scripts and check the records from the main table in the server.

Tested extensive backend testing by using database query tools SQL Server, SQL Queries to retrieve the data from the database and checked data integrity and Data Validation.

Involved in Patient Data, Data distribution, Configuration Utilities and Installation process.

Involved in testing Stored procedures, Triggers and Functions for the DB Validation

Involved in Functional testing to run the scripts from SQL server databases service packs / patches, applications and hot fixes

Involved in Transferring the Data process from customers to work flow server and run the scripts to check for the data Validation

Involved in Tuning the scripts (Calculate and implement optimal values for physical database parameters)

Involved testing to ensure the periodic backups on production / QA servers on both local and networking storage.

Involved in Identify process improvements via version upgrades, new tools or reengineering of existing solutions

Environment: Quality Center 10.0, QTP, TFS, .Net, Java, UNIX, J2EE, .Net, Oracle, XML, MS Excel, MS Word, TFS, SQL Server 2005/2008 Management Studio,

Human Health Care Insurance KY Apr 12- Oct 12

IVR is a tool used by Humana to log and resolve all inquiries raised by the customers. This tool is mostly used by Humana-Customer Service Representative (CSR) who is responsible for providing service to the inquiries raised by the customers. All details about an inquiry are stored. Inquiry comes through IVR.

Roles and Responsibilities:

UAT Coordinator (QA)

Involved in System testing, Integration testing, End-End testing, User Acceptance testing

Conducted Manual Test meticulously and exhaustively for IVR application using manual scripts, which are designed specifically for this purpose.

Worked Extensively on Humana IVR Modules like Medical Benefits, Claims, Dental, Metavance, ID Cards and Others.

Develops and executes test cases based on user stories contained within an Agile Sprint and have experience in SCRUM testing.

Expert in manual testing on DTMF, Speech Recognition IVRs (received Appreciation Emails from Client for my good Work)

Performed Functionality Testing for Medicare, USAA, Coalition, Commercial and Commonwealth of KY.

Facilitates test case review sessions with other agile team members.

Tracks test execution results with Humana Test Management tool SQUIDS.

Opened defects and track the defect status until its get closed.

Involved in Testing the various exit points in the IVR such as call routing according to Visio

Involved UAT touch points for IVR conversion Production Support

Environment: Squids, QTP 10.0, VBScript, .Net, Java, UNIX, J2EE, Oracle, XML, MS Excel, MS Word, SQL Server

QA/UAT Coordinator (QA) Oct 11 – Dec 11

Involved in testing the data capture to make sure the right data is being captured in the IVR at the relevant points.

Designing UAT Test Cases, to help of the use cases diagrams as inputs for creating the Test Cases.

Involved in Production Support for different Phases

Validated the call routing and logging fixes in log files fixes when call center is open.

After the turn complete then it validates the call routing and logging fixes in log files. Business will have to validate the loggings and routing fixes when call center is open

Analysing Test Results & Identify bugs and reporting to the developers using Squids.

Used Squids to prepare Test Cases, Procedures and Requirements Traceability Matrix.

Worked hand to hand with Business Analysts to prepare use cases.

Consolidate the weekly status of issues and report them to the lead and the manager.

Environment: Squids, QTP 10.0, VBScript, .Net, Java, UNIX, J2EE, Oracle, XML, MS Excel, MS Word, UML, SQL Server

ADT Security Services Irving TX Jul 11 – Sep 11

QA Analyst

ADT is the security products and services provider for residential and commercial customers. I was involved software called MASterMind which provides a fully integrated, enterprise solution for monitored security service providers and proprietary central stations. I was involved in testing the integrated back office Business package for A/R which includes features of billing and cash receipts/collections.

Roles and Responsibilities

Analysed the Business requirements and the specifications and Developed Testing Strategy for entire application and developed various Test Cases.

Performed Smoke Testing on new builds of application

Created detailed Test Scenarios, Test Cases and Test Plans using standard Templates. And involved in System Development Life cycle (SDLC) using Agile Methodology.

Involved in System testing, Integration testing, Functionality testing, Regression, End-End testing, User Acceptance testing

Managed testing in distributed UNIX Environment and Oracle databases as back end

Tested extensive backend testing using SQL, SQL Queries to retrieve the data from the database and checked data integrity and Data Validation.

Involved in creating the test scenarios, test plans and test cases for retail (residential and small business) Lock box Checks, commercial (Large commercial and Builder) Lockbox checks and Lockbox Adjustments (NSF).

Executed Test Cases with a set of test data to verify the data validations.

Involved in cash processing, cash receipt batches into Mastermind application maintained the Billing/Accounts receivables through the Lock box file.

Analysing Test Results & Identify bugs and reporting to the developers using Quality Center.

Used Quality Center to prepare Test Cases, Procedures and Requirements Traceability Matrix.

Parameterize the scripts to run the scripts using varying form data. Generalizing the scripts using regular expressions and handling unexpected errors using exception handing mechanism of QuickTest Pro.

Develop automation scripts in Quick Test Professional (QTP) to automate smoke and regression testing. Automate test data load for every build cycle.

Generated Test Analysis Reports and graphs using Quality Center.

Worked hand to hand with Business Analysts to prepare use cases.

Consolidate the weekly status of issues and report them to the lead and the manager.

Participated in all phases of Software Testing Life Cycle (STLC)

Conducted extensive Smoke Testing, Regression Testing, Adhoc Testing, Integration Testing and Database Testing on the application.

Extensively used Quality Center as a Defect Tracking and Defect Management tool

Environment: Quality Center 10.0, QTP 10.0, VBScript, Java, J2EE, Oracle, SQL Server 2008, XML, T-SQL, UNIX, MS Excel, MS Word

Education Qualification: M.Sc. (Masters in Mathematics)

Certification: Scrum Master (CSM) Certified

Awards:

SIMPLIFIED BILLING AWARD 2015 (DIRECTV)

Received Appreciation Emails from Client for my good Work (HUMANA)

Contact this candidate