Data Test Cases

SIDDHARTHA NULI

**************@*****.*** +1-980-***-**** Charlotte, NC

SUMMARY:

* ***** ** ************ **** experience in Data Analyst, Software testing(Automation and manual) and Sql developer. Good understanding of SDLC such as agile and waterfall models.

Experience in delivering solutions to clients using advanced analytics for data driven decision making.

Experience in working with large data sets using Excel, SAS.

Experience in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.

Good hands on experience writing SQL queries.

Good experience in Sanity testing, Functional testing, Performance testing, Integration testing and Regression testing.

Analyzed requirements, business requirement documents, functional specifications and use cases in preparing and executing the Test Plans, Test Scenarios and Test Cases and creating daily status reports for the client.

Highly skilled and experienced in Agile Development process for diverse requirements.

Primary skills include Automation testing of web applications using Selenium WebDriver, QTP, HP Quality Center, Manual Testing, Java developer and knowledge on load runner.

Proficient in Agile methodologies and implementing Data Driven Automation framework using Selenium.

GITHUB: https://github.com/siddharthanuli

EDUCATION:

Masters University of North Carolina, Charlotte

Computer Science, May 2016, CGPA – 3.5/4.0

Bachelors SRM University

Electronics & Communication Engineering, May 2012, CGPA - 3.66/4.0

TECHNICAL SKILLS:

SAS Tools : SAS V9.1 (BASE, MACROS, SQL, ODS, GRAPH).

Programming : Shell Scripting, Python, C

Web Technologies : HTML, Java Script,

Big Data Technologies : Hadoop, Map reduce

Databases : MySQL, Oracle 11.g,SQL Server 2005

Testing Tools : Quality Center(9.0),Selenium

Operating Systems : Windows XP/7/8/10, UNIX, MAC OS

IDE : Eclipse

Professional Certification:

SAS Certified Base Programmer for SAS 9.0

EXPERIENCE

Company : Accenture Service Pvt LTD October 2013-Dec2014

Role: Data Analyst : Data Management, SAS, Data Analysis

As a Data Analyst I was responsible for extracting the data from the Databases and analyzing the data using various procedures in the SAS. I was responsible for analyzing DNA micro array data for toxicity prediction. Project was to analyze data for prominent genes and their effects for various chemical compositions on rat liver.I was involved in Primarily developing efficient SAS code to extract and translate the data while performing data cleansing to eliminate unimportant readings .Predictive modelling was applied to identify most prominent genes and elements in the micro array and presented so that results could be used for successive drug development activities

Contribution:

Challenge was to build the process that takes the raw micro array data and process huge volumes of information in a 5000 instances X 300 variable data set.

Identified and Extracted the responders and non responders to the specific elements.

Performed analysis on huge data set after eliminating un usable information and loaded the data sets with the correlated and the variant data into the excel and used for the further analysis..

Transformed the filtered data sets and created new data sets with the most variant variables and correlation values .

Manipulating, cleansing & processing data using Excel, Access and SQL.

Manipulated and transferred data using SAS Procedures such as SUMMARY, MEANS, UNIVARIATE, FREQ, SORT, PRINT, TABULATE, PLOT, CHART and REPORT to compute elementary statistical measures and produce data listings, tabulations and graphical display.

Retrieved ASCII datasets, used INFILE and INPUT statements to read ASCII files.

Project: UBS Bank September 2012- Oct-2013

Role: Manual and Automation Tester

Tools Used: Quality Centre, Selenium,MS Office.

Project Description: This project is a web based application. It is a centralized banking solution covering all the payment functions of a bank. Application provides online personal banking services like bill pay registration, payments, loans. It supports multi currency transactions and all types of delivery channels. This application is highly parameterized to support constantly changing customer and regulatory requirements. There are four main modules what I have worked in this project. (i.e.)My Account module, Payment module

Contributions:

•Created Test plans, Scenario, Test cases, and Test scripts both Manually and Automated using HP Quick Test Pro tool .

•implemented agile development practices according to the application requirements for every project.

•Developed Test plan and test cases for all the user stories which has been discussed during the design reviews.

•Prepared Test requirements and Test Cases using Quality Center .

• Involved in Smoke Testing, Functional testing, System testing, Integration testing, Regression testing.

•Involved in the test design for developing the end user requirements. Coordinated UAT with the end user with all the requirements discussed in the test design phase

•Worked closely with Development as well as Requirement teams to ensure testing issues are resolved.

•Developed Selenium WebDriver Java scripts for Integration Testing and System Testing of Functional requirements

•Developed Frame works as part of cross browser testing for the login pages to validate the credentials on selenium web driver.

•Actively Involved in Software Development Life Cycle and Test Life Cycle, Test strategies, Methodologies and processes.

•Used Quality Center to prepare Test cases, procedures, Requirements Traceability Matrix and managing the Defects as per the Business requirements.

•Developed and executed SQL queries for back-end testing in Sql Server.

•Designed and developed automation test scripts and managed testing activities using Mercury Quality Center.

•Executed automated test scripts, analyzed the results and reported bugs in Quality center.

•Involved in maintaining and uploading the Scripts to Quality Center.

Project : British Telecom March2012- October 2012

Tools Used: Java / J2EE, MYSQL

Role :Intern as SQL developer

I Worked with website development team with good emphasis on Database Concepts and Quality Assurance testing. Worked extensively for the database design for extracting the required data and organizing in ordered way.

•Worked on database installation, design and development. Applied Normalization rules in designing the database.

•Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.

•Developed database objects like Tables, views, stored procedures, indexes etc.

• Designed Database objects including tables, procedures, views. Rewrite and review SQL queries for a better performance (removing unnecessary JOINS and adding filtering criteria in the necessary fields).

•Wrote various stored procedures for the purpose of application development.

• Gained knowledge on Object Oriented Programming concepts, Java Exception handling and Java Collection API.

ACADEMIC PROJECTS:

Patent Data Analysis Using MapReduce:

Patent data collected for the Procter & Gamble company and sorted using the Mapper functions . Proposed Innovation Strategy recommendations for Procter & Gamble by performing data analysis on company’s patent data spanning over 15 years. Data analysis include evaluation of linear and logistic regression models after performing sentimental analysis on the data. Used SAS for the Data extraction and conducted regression model analysis for the Procter –

Tools Used : Python, MapReduce,Mallet, SAS, Tableau

Data Mining – Shark Attacks Prediction

In Knowledge Discovery in Databases course, worked as an equal member of five person team to predict the expectation of shark attack based on analysis of past 100 years un-provoked shark attack data set.

Tools Used : Weka, Tableau, Java

Key Features:

Analyzed major factors that provoke shark attacks using linear regression

Implemented Decision Tree and Naïve Bayes algorithms for data analysis using Weka

Student Information System:

In Database systems course, our team designed and developed a Normalized database for student information system. Students and recruiters use this to apply and accept the college admission respectively.

Live Application URL: http://futureniner-sampathsree.rhcloud.com/

Features:

Used PHP and MySQL to access and store data respectively

Use of Triggers, Normalization to maintain database transactions

HTML, Twitter Bootstrap CSS, Ajax are used to build website along with PHP for Data access.

Patent Data Comparison Of Ford and Texas Instruments:

In this Project I have compared the similar patent which has been filed by the Ford and texas instrument regarding the Microchip design .

Key Features:

Worked on Hadoop cluster and Map reduce to extract the raw data

Used topic Modelling and Mallet to generate the similar topics

Results were displayed using python regarding the distribution of patents.

Contact this candidate