Name: Raghuram

Mobile: 678-***-****

EMAIL: acy764@r.postjobfree.com

Professional Summary:

Around 6 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Quality Analysis/Data Mart Design, OLAP, Client/Server applications.

Solid Back End Testing experience by writing and executing SQL Queries.

Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software. Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.

Experience in Functional Testing, Integration Testing, System Testing and Regression Testing having executed on both Client/Server and web based applications.

Performance Testing on Hp Load Runner.

Expert in using the Bug tracking with Test Management Tools like Quality Center.

Experience in Quality Center / HP ALM Administration including hands on server deployment, Major version upgrades, Patch installations, Utilities using Site Admin API and Quality Center API.

Prepared QA status summary reports for each assignment and performed manual data testing.

Experience with Black box testing, white box testing, Unit, Integration, Regression, Sanity, System test, Functional testing, GUI applications testing and Database Testing.

Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies.

Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.

Expertise in designing the test scenarios and scripting the test cases in order to test the application.

Creation of test data and Automation of test cases for system and analyzing bug tracking reports.

Expertise Shell Scripting experience on UNIX, Linux and Windows environment.

Performed Data Centric testing to validate the data that is loaded in to the data warehouse is correct as per the defined business rules.

Expertise in developing, documenting, and executing test cases manually as well as generating automated scripts using Selenium.

Worked in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Extensively strong on databases including Oracle, MS SQL Server, and Teradata.

Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQ.

Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.

Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.

Technical Skills:

Testing Tools: Selenium RC, Silk Test, Firebug, XPath Checker.

Operating Systems: RHEL 5, Windows, UNIX, and MS-DOS.

Programming Languages: JAVA, HTML, C,C++,XML, PL/SQL, C#, VB Script.

Database: Oracle 8i, MS Access.

Office Applications: Open Office 2.x, MS Office, Adobe PageMaker.

Professional Experience:

Anthem, Wallingford, Connecticut Oct’2015 - Till date

QA Tester/ QA Automation Tester

Description: Worked as a Data warehouse Tester for Medicaid claims processing, Decision support and Business Intelligence, HIPAA transaction support, Provider Enrollment, and Prior Authorization, the application was developed in Java, JSP, HTML and Oracle. New applicants, providers, members and insurance companies can access the system for enrolment, submitting bills, accessing member information and tracking eligibility through Medicaid management information system. The Application was tested both manually and with Mercury Automation Tools.

Analyzed business requirements, Functional Specifications and Use Cases, prepared Test Strategy and Test plan.

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in HP Application Life Cycle Management (HP ALM)

Involved in developing detailed test plan, test cases and test scripts using HP Application Life Cycle Management (HP ALM) for Functional and Regression Testing.

Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Responsible for testing Business Reports developed by Business Objects XIR2

Was responsible for ensuring OLTP feeds to Enterprise wide data warehouse and other subscribers and maintaining its quality.

Studied the PL/SQL code developed to relate the source and target mappings for my testing needs.

Strong experience in testing HealthCare and Business Intelligence (BI) applications.

Developed test data in preparing the mapping document for source to target.

Used Autosys job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Establish and organize Offshore Development Teams.

Involved in automation of test cases using QTP.

Involved in Teradata SQL Development, Unit Testing and Performance Tuning

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Extraction of test data from tables and loading of data into SQL tables.

Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Being an OLTP database and high volume of data to be processed daily performance was a very strict success criterion we have to meet.

Tested several stored procedures.

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

Experience in creating UNIX scripts for file transfer and file manipulation.

Validating the data passed to downstream systems.

Worked with Data Extraction, Transformation and Loading (ETL).

Involved in testing data mapping and conversion in a server based data warehouse.

Used HP Application Life Cycle Management (HP ALM) too to track and report system defects

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: HP ALM, XPath, XQuery, SQL, PL/SQL, SQL Server 2008, XML, ALM/Quality Center 11, DTS, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2, Rational Quality Manager (RQM), MS Access

DIRECTV, El Segundo, CA Nov’2014-Aug’2015

SQL Tester / QA Tester

Responsibilities:

Served as a key member of Agile team as QA tester on development projects for web based point of sales application.

Facilitated requirement review with stakeholders and attended daily standups.

Decomposed user story, technical requirements, business rules and extracted positive and negative test scenarios to create test cases utilizing VersionOne tool.

Created end to end tests including but not limited to: shopping cart, inventory, agreements and transactions.

Responsible for creating regression test cases and scripts for Customer Core product.

Tested error/bug retests, usability and regression scripts.

Primary tester for reskinning of company website; tested with mobile device, tablet and using Device Anywhere emulator, Chrome.

Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.

Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.

Executed SQL Queries to check the data table updates after test execution.

Generated Install and Update documents for and Quality Center.

Created test data for testing specific Membership functionality.

Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.

Logged defects by following Bug Life Cycle (BLC) in HP Quality Center (QC) and Jira.

Performed Web Services testing and Validated XML request/response data using SOAP UI.

Extraction of test data from tables and loading of data into SQL tables.

Written several complex SQL queries for validating Cognos Reports.

Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.

Experience in creating UNIX scripts for file transfer and file manipulation.

Validating the data passed to downstream systems Involved in Teradata SQL Development, Unit Testing and Performance Tuning.

Executed multiple browser tests for various mobile and tablet operating systems versions.

Performed smoke, functional and regression testing.

Created and execute SQL to perform backend database validation for UI and inventory.

Responsible for defect tracking, defect reporting and defect reproducing using VersionOne tool.

Communicated with developer teams using VersionOne chat functionality for identified fails/ flaws of and recommended fixes.

Used SVN Tool (Version control Tool) for version control of automated scripts library and SharePoint for documentation.

Attend Sprint planning, Backlog grooming and Retrospective working with developers, product managers, and other testers, local and remote.

Provided weekly status report to team lead.

Environment: Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script

Softsol, Chennai, India Jan’2014-Aug’2014

Software QA Tester

Responsibilities:

Prepared Test plans and various Test Cases.

Utilized Agile and SCRUM methodology to test the project.

As a member of the Scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings.

Performed automation and manual testing.

Created test scenarios using Cucumber BDD.

Used Rally for writing test cases and defect logging.

Writing test automation scripts for regression testing using Selenium Webdriver.

Used Maven as the build tool.

Used Git and Source Tree for version controlling system.

Testing Digital Copy Plus CMS tool which is built with amazon AWS.

Testing apps with iOS and Android devices.

Performed mobile automation testing with SeeTest mobile automation tool and integrating Selenium Web driver code from See Test to IDE.

Used Firebug and Fire path chrome add-ons for locating elements.

Performed Geographical testing, connecting to VPN to different countries and testing the application.

Performed database testing, integration testing for the application.

Created User Acceptance Test (UAT) plan and executed the product test cases with customers in determining the functionality of the application and also performed production verification.

Updating QA activities frequently in Confluence.

Prepared weekly status reports.

Environment: Selenium Webdriver/IDE, Maven, TestNG, Java, MSWord, Git Hub, MS Excel.

Infrasoft Technologies, Chennai, India Feb’2011-Dec’2013

Software QA Tester (Web Application)

Responsibilities:

Involved in preparing High Level Test plans based on user requirement documents.

Involved in defining Test objectives for the applications and performed Manual Testing.

Involved in cross browser testing using Netscape Navigator and Internet Explorer.

Involved in developing Integration Test Plans, System Test Plans and Performance Test Plans

Developed Test Plan, Test Procedures and Process for UAT testing and involved in Installation

Responsibilities include acceptance testing, functional testing, Integration testing, System

testing, performance testing, stress testing and load testing the system

Used SQL Queries to verify the data from the Oracle database.

Conducted Regression Testing of the web-based application by using Win Runner

Developed Test Plans and Test Case design using Test Director.

Recommending continuous process improvement, maintain QA standards and artifacts

Defect and Change Tracking was done using Test Director.

Interacted with the developers for bug fixes and problem resolution

Involved in the UserAcceptanceTesting, Participated in various meetings and discussed Enhancement and Modification Request issues.

Participated in regular project status meetings related to testing.

Environment: Java2.0, Mercury Tools (QTP, Test Director and Load Runner), TOAD, SQL, MS-Office.

Contact this candidate