RUPALI DAS PARIMISETTY
QA Tester
**********@*****.***, 480-***-****
SUMMERY
I have worked as a QA Tester and responsible for applying the principles and practices of software quality assurance throughout the software development life cycle and writing SQL queries. Performed skilled Operational analyzer and determined the data conditions that led to operational issues, and identified/analyzed test data that may expose to those issues. I have hands-on experience in Testing of external facing portals for the company, UI testing with a lot of functional backend testing. I have very clear understanding of all the phases of the SDLC/STLC and has performed re testing, regression testing on UAT environments. I am good at automation test scripting using UFT tool. I am also very strong in designing, developing and deploying BI Solutions using SSIS, SSRS and SSAS. I am passionate about reporting tools and created personalized database solutions, which simplified routine processing and reporting for customers. I have excellent research and time management skills. I am highly organized with the ability to perform analytical design complementing my technical skills.
EDUCATION
University of Denver, MAS in Database Design and Administration (2015)
SKILLS
Applications: Microsoft Office, PL/SQL, ETL, MS Excel
Languages: SQL, HTML, JavaScript, VBScript, Java
Platform: Windows
Database: Oracle, SQL Server
Markup/Tools: XAMPP, HTML, XML, CSS
BI Tools: SSMS, SSIS, SSRS, SAP Predictive Analytics
Design Software: Corel Draw, Adobe Photoshop, Adobe in Design, Adobe premiere, Macromedia Flash.
PROFESSIONA EXPERIENCE
CloudSire, Parker, CO – Oct 2016 – Present – QA Testing
Humana Pharmacy, Glendale, AZ -- May 2015 – Aug 2016 -- QA Testing
University of Denver, Denver, CO-- October 2014 – March 2015 -- Technical Support on SQL Server Data Tools and ETL
PROJECT DESCRIPTION
CloudSire Oct 2016 – Present
Gathered Business Requirements, Functional Requirements and Technical Design Documents.
Performed Functional, Integration, Regression, End to End and User Acceptance Testing.
Analyze and Develop Test Plan, Test Scenarios, Test Conditions and Expected Test Results and Test Cases, Test Scripts from functional requirement Specifications and Technical Design Document to implement through testing process.
Involved in creating the Traceability matrix based on Functional requirement in each module.
Identified the Test Cases and documented them in ALM - Application Life Cycle Management / Quality Center.
Involved in preparation of Test plan and mapping test cases to requirements.
Created and maintained Regression and Sanity Test Suite using Selenium with Java.
Involved in setting up Automation frame using HP QTP, Selenium with Java.
Humana Pharmacy May 2015 – Aug 2016
Project on testing services and data Analysis. Verifying the quality of software and identifying complex data combinations used to test software and to manage work products created by a remote/offshore team.
ACCOMPLISHMENTS
Quality data analyst (mobile apps, citrix apps, and websites).
Responsible for data analysis and quality of software and identifying complex data combinations used to test software.
Resolved quality issues by using data combination testing, orthogonal array testing, risk based testing, test case creation and ad-hoc testing.
Prepared test design, test plan, test cases, and execution.
Provided data analysis in support of the pharmacy’s application defects raised on the enterprise pharmacy solution for Humana Pharmacy’s traditional Rx processing.
Determined that data conditions that led to the operational issues, and identified test data that exposed those issues.
Imported, exported and manipulated large data sets for rapid delivery to clients or loading onto internal databases.
Performed analysis and presented results using SQL, Excel, and MS Access.
Diagnosed and addressed operational test data issues.
Performed sophisticated ad-hoc or ongoing custom analyses against Humana Pharmacy’s traditional Rx processing to support internal analysis to diagnose performance issues.
Provided training for the specialty pharmacy solution (SMED) for processing specialty prescriptions.
Technologies: Microsoft SQL Server, Oracle Database 11g XE, Oracle SQL Developer.
University of Denver October 2014 – March 2015
Role: Technical Support
ACCOMPLISHMENTS
Incorporated various data sources such as Oracle, SQL Server, XML and Flat files into the staging area.
Worked in SQL Server 2012 Business Intelligence tools, Data Warehousing and ETL processes.
Efficiency in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS.
Efficiency in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse and Data marts.
Knowledge in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
Data Processing knowledge in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Data Stage.
Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema.
Proficient in Oracle SQL*Plus and writing SQL queries.
Excellent technical and analytical skills with clear understanding of design goals related to Entity Relationship model for OLTP and dimension model for OLAP.