QA Analyst

Prasanthi Mandava

*** * ******* ** *** ****, Chicago, IL 60661 +1-479-***-**** https://www.linkedin.com/in/prasanthimandava **********.*******@*****.***

SUMMARY

Senior quality analyst with 5 years of experience in both manual and automation testing in multiple domains like Media, Banking.

Innovative and self-directed individual with strong client interaction skills, written and verbal communication.

SKILLS

Languages: Java, SQL, PL/SQL

Big Data Ecosystems: Hadoop, MapReduce, HDFS, Pig, Hive

Data Analytics Tools: SAS, R, Tableau, MS Excel Pivot Tables

Operating Systems: Windows 7/8/10, OS X, Linux, Unix

Tools: NetBeans, Eclipse, HP Quick Test Pro, HP Quality Center, Bugzilla, Atlassian JIRA

Database: Oracle 9i/10g/12c, MS Access, Sybase, Microsoft SQL Server

EXPERIENCE

10/2010-07/2012 HCL TECHNOLOGIES Bangalore, Karnataka/India

Sr. Software Test Engineer

Clients – Yahoo

Created test cases and involved in testing (web, mobile based) various products of client (Lifestyles, OMG, Movies, and Sports etc.).

Led a team of 3, in maintaining various products of client during weekly releases.

Worked on Agile-Scrum methodology.

Tested client products in QA, Staging & Production environments.

Received 2011 Q3 Best Performance Award from client.

07/2007-09/2010 ATLAS SYSTEMS PVT LTD Bangalore, Karnataka/India

Software Test Engineer

Clients - Elynx, Euro VB and Trilogy

Played a major role in creating a replica of ‘Test Track Pro’ bug tracking tool in ‘Quality Center’ as per client requirement which increased client’s productivity, also improved their quality of automation by integration of ‘Quality Center’ and ‘Quick Test Pro’.

Developed automation scripts using VB Script, SQL to validate the data of client (Elynx) banking applications (Wells Fargo, Ally bank etc.).

Received commendation from client for quality work.

Created test data for webpages and database (SQL) for testing Euro Virtual Booth product. Also involved in preparing ‘Test Plan’ for Euro VB project.

Developed UI & database validation test cases, use cases for Trilogy client’s product Artemis and executed.

EDUCATION

ILLINOIS INSTITUTE OF TECHNOLOGY, Chicago, Illinois

Master of Science, Graduated in May 2016, GPA 4.0

INFORMATION TECHNOLOGY AND MANAGEMENT – SPECIALIZATION IN DATA MANAGEMENT

COURSEWORK: Advanced Data Management, Advanced Data Analytics (SAS, R & Tableau), Data Analytics (SAS & Excel), Data Warehousing, Hadoop, Java Application Development, Service Oriented Architecture, Database Security, Cyber Security and IT Management Frameworks.

PBR VISVODAYA INSTITUTE OF TECHNOLOGY AND SCIENCE, Kavali, India

Bachelor of Technology, Graduated in April 2007

ELECTRICAL AND ELECTRONICS ENGINEERING

ACADEMIC PROJECT WORK

Severe Weather Impact on Walmart Store Sales (Spring 2016)

SAS regression analysis on impact of severe weather on specific item sales in Walmart stores.

Cluster Analysis using SAS (Fall 2015)

K-means cluster analysis using SAS on Illinois state census data to formulate property tax increase strategy.

Pothole Repair – Case Study (Fall 2015)

The case study done in MS Excel (using PIVOT TABLES, VLOOKUPs, etc.) focuses on analysing the historic data related to pothole repair for 2011-2014 combined with weather forecast data (2011-2014) (data Source: http://www.data.gov/)

Hadoop Course Project (Fall 2015)

Wrote a MapReduce program to count, invert the count and to produce a citation histogram of patents citation data for different map and reduce tasks. Also plotted the time taken for each of the jobs using excel.

Presented a research paper on securing BigData with Hadoop.

Data Warehouse Project Case Study (Summer 2015)

Developed a data warehouse design by analyzing the main facts and dimensions (using Visio) to keep track of the computer lab usage statics of University students. Also created the lab usage reports in MS Access.

Developed a data warehouse application prototype (Star Schema) for Super market sales system to analyze the sales by year, region and salesperson and product.

Developed a star schema model to help analyze Charter data. Also generated different reports such as pilot, type of pilot and time periods etc. using MS Access.

Movie Production Database Application (Spring 2015)

Developed a Movie Production Database Application using Oracle in the following phases:

Conceptual Model: Created summary of the business requirements and conceptual model of it.

Logical Model: Designed an ER Diagram using Visio to show logical model of application.

Physical Model: Created physical model of the tables using SQL Developer.

Performed analytics, created charts to present scene budget, movie sales etc., created reports such as movie budget, crew etc.

Online Store (Spring 2015)

Created an online shopping store to display items available in the store using JavaFX user interface and MySQL database. Functionality included adding new items, removing items, inquiring current inventory of all items.

Contact this candidate