Post Job Free

Resume

Sign in

Sql Server Test Cases

Location:
Morrisville, NC
Posted:
October 12, 2015

Contact this candidate

Resume:

Ashwini Wani

*

Ashwini Wani

Email: acr13z@r.postjobfree.com

Cell # 702-***-****

Morrisville, NC -27560

OBJECTIVE

To involve in a team-work utilizing my experience and knowledge of Information Technology & Management to achieve organizational goals while making professional advancements. EDUCATION

Masters in IT Management, The University of NC at Greensboro. GPA: 3.71/4.0, Fall 2012 – Fall 2014

Masters in Personnel Management, University of Pune, 2007-2009

Bachelor of Science, University of Pune, 2003-2006 PROFESSIONAL SUMMARY:

Experience in QA processes and standards, Software Testing Methodologies, Development of Test Cases, Design and Execution of strategic Test Plans and Test Scenarios

Documentation experience creating Technical Reviews, Reports and Strategy

Experience in PL/SQL, MS SQL server, Oracle and SQL Server Reporting Services (SSRS).

Experience in implementing Waterfall and Agile Methodologies.

Experienced in Quality Assurance Testing, Business Analysis, Data Analysis, Complex Report Development, Web Development, Technical Support.

Experience in Requirements gathering, Modeling/Design (OOAD/UML), Development

Experienced in predictive analytics, pattern discovery, and segmentation using SAS Enterprise Miner.

Experienced in SSRS, OBIEE and other report development tools.

Useful knowledge of Computer Systems, Distributed and Telecommunication Networks.

Strong analytical & communication skills and a good team player.

Quick learner and flexible to perform different job duties as the situation demands. Proactive in finding efficient solutions and system improvements. Requires minimal supervision and works well under pressure.

TECHNICAL SKILLS

Languages : PHP, MySQL, HTML, PL/SQL, VB.net, Java, Perl

Operating System : Windows, Macintosh, Unix, IBM AIX, Linux, Solaris, VMware

Database : Oracle, MS-Access, MySQL

Tools : SQL Server Reporting Services (SSRS), SAS Enterprise Miner, Wordpress, UML, Microsoft Visio, Microsoft Office, MS Project, Adobe captivate & Camtasia studio, Quick Test Professional, Quality centre, Tortoise SVN, JIRA, Sahi, Selenium, Oracle E-Business, Load Runner, IBM Monitoring Tools, Rational Requisite Pro, Rational Rose, Rational Clear Quest, Team Foundation Server

Methodology : Agile Development, Software Development Life Cycle (SDLC), Object Oriented Modeling and Design (OOMD), Rational Unified Process

Ashwini Wani

2

PROFESSIONAL EXPERIENCE

1) IPREO, Raleigh June 2015 – Aug 2015

Position: Business Intelligence Report Analyst

Environment: SQL Server Reporting Services (SSRS), Nevron, Visual studio, MS office, MS Excel Responsibilities:

Create complex reports using SQL Server Reporting Services (SSRS)

Create documentation of report logic and processes

Work with QA teams to ensure accurate and complete testing

Proficient in use of query and reporting analysis tools

Develop and design web-based dash-boarding

Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.

2) Organization: Raffaldini Vineyards, NC June 2014 – Dec 2014 Position: Quality Assurance Engineer & Developer

Environment : PHP, HTML, Microsoft Visio, UML, Oracle, SQL, Quick Test Professional, Quality Centre, MS office, Wordpress, Tortoise SVN

Responsibilities :

Gathered functional, technical and visual requirements of the website

Conducted walk through meetings to refine and finalize the requirements

Wrote Functional and Technical Specifications for the website

Proposed and reviewed business processes and recommendations related to proposed solution

Developed the website using Wordpress, HTML and PHP

Technical setup and configuration, thorough documentation.

Involved in entire QA life cycle including test designing and execution of the entire QA process and documentation of test plans, test cases, test procedures and test scripts.

Manual and automated test scenarios for GUI functionality, regression testing using Quick Test Professional.

Performed GUI testing by creating GUI checkpoints to verify the functionality of the GUI objects using Quick Test Professional.

Used actions and re-usable actions in Quick Test Pro for designing the automation test scripts.

Used Quality Centre for the bug fixing and tracking. 3) University of North Carolina, Greensboro Jan 2014 – June 2014 Position: Graduation Assistant

Environment: SAS Enterprise Miner, Oracle, SQL, MS office, Adobe captivate & Camtasia studio Responsibilities:

A) Research with advisor on Smart Grid, Smart Meters and Efficient Energy distribution

Gathered large chunks of energy data using various Data Gathering techniques

Discuss intelligence and information requirements with data analysts

Conducting statistical analysis with SQL queries and procedures

Use SAS Enterprise Miner for building analytical models/charts B) Research on optimized and efficient methods for content delivery 4) Organization: Global Software Solutions June 2010-June 2012 Position : Quality Assurance Analyst

Environment : Windows 7/2008, HTML, Firefox, Chrome, IE, Oracle, MS office, SVN, JIRA, Sahi, Selenium, Java

Responsibilities:

Involved in developing Requirements Traceability Matrix (RTM), Test Scenarios and Test Cases according to the business and system requirements Ashwini Wani

3

Developed test cases for cross-browser (MSIE, Firefox, Chrome, Safari) and cross-platform

(Windows 7, MAC OS X) testing in virtual machine (VMWare) environment

Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language

Tested web sites for functionality, GUI, usability, navigation, browser and OS compatibility

Performed black box, grey box manual and automated testing with an access to the web source code

Identified and isolated software defects and reported them via JIRA

Participated in reviews and weekly defect report meetings

Documented test procedures for release acceptance and regression testing of new builds

Interacted with developers and Managers to identify and resolve technical issues with the application website.

5) Organization: P & J Associates

Position: Business Analyst June 2008 – May 2010

Environment: Quick Test Professional, Quality Centre, MS office, Rational Requisite Pro, Rational Rose, Rational Clear Quest, MS Visio, Project Life Cycle, SDLC, Cost-benefit Analysis, Business systems analysis Responsibilities:

Gathered requirements interviewing SME's, stakeholders, business partners, and end users and prepared high level Business Requirement Document (BRD)

Responsible for translating BRD into Functional and Non Functional Specifications

Prepared comprehensive Use Case Specifications document by identifying the use cases from the collected business gathering document

Created UML Diagrams including Use Cases Diagrams, Activity Diagrams using Rational Rose and MS Visio

Reviewed and processed Test Plans, Test Cases, Test Case Execution and performed data validation using specification documents and Quality Centre.

Managed the change request in Clear Quest and analyzed the impact of the change request on the application in regards to Project Plan, Project Scope and Project Schedule.

Worked with development and testing teams to accomplish timely release

Extensively used SQL for data extraction and took part in User acceptance Testing (UAT).

Involved in User Manual designing, knowledge transition seminars, and conducted benchmarking activities to identify best practices in the industry ACADEMIC PROJECTS /PAPERS/WORK

1. Finalist for poster presentation at ‘TERADATA 2014 Partners’ and ‘SHARP CONF, 2014’

“Smart Grid & Utilities Analytics: Using Public Data to investigate Energy Resources & Energy Efficiency”

The project uses advanced pattern discovery and segmentation techniques to determine effective locations for producing photovoltaic power and determining efficient areas for high power transmission lines. It carried out analysis on the collected data and built analytical models using SAS Enterprise Miner to

2. Development of E-commerce Website

The project was developed for a business selling the office products online. It was developed using PHP, HTML and MySQL Database Server. The product has Admin and Customer Interfaces to the Ecommerce site to authenticate users to make products purchases, search inventory and display reports of the sold items, etc.

Design RDBMS System for the website

Providing high level security for the database by creating proper primary keys and secondary keys

Write triggers, procedures and functions for the system Ashwini Wani

4

COURSEWORK

Business Analytics, Web Programming, Database Management, System Analysis and Design (OOMD), Telecommunication & Distributed Networks, Information Systems Management, Information Security and Privacy, Project Management, Integrative Business, Projects in Information Technology, Organization Development & Quality Management, Human Resource Management.



Contact this candidate