Sql Server Project

Suchismita Dash

Email: **************@*****.***

Ph #: 513-***-****

Professional Summary:

• Over 7 years of work experience in IT industry with specialization in Software Quality Assurance and Testing,

extensive experience with web based applications, web logs, and web data analysis.

• Experience with multiple automation tools and web testing applications spanning Selenium, QTP, Link checker Pro,

Sawmill, etc.

• Experience with Selenium IDE, Selenium Grid, Web-Driver using Java.

• Exposure/experience with packaged solutions like Siebel CRM and desktop/thick client applications.

• Good experience with data driven testing using excels as the source of data. Experience with test data creation.

• Experience with web debugging tools like FireBug, HTTPFox to perform analysis of request, response and tags.

• Strong experience with creating test plans, writing test cases from requirements documents, functional specifications

and from discussions with Business Analysts, executing the tests and reporting results back.

• Exposure to UNIX scripting in shell, ftp, VI, running jobs in background.

• Extensive experience with bug tracking tools like Jira, Quality Center, and BugZilla.

• Experience with office applications like Word, PowerPoint, Excel, and Visio.

• Experience with Auto, Online Media, Media, Engineering domains.

• Experience with working in both Agile and Waterfall models of development/projects. Have experience with using

Jira in Agile environments.

• Good experience with backend testing, Data analysis / data validation experience with writing Structured Query

Language (SQL) with focus on SQL Server. Worked with Joins, Sub Queries, aggregations, case statements.

• Experience with loading and extracting data from SQL server using import export wizard and using excel

connectivity.

• Experience with working on multiple operating systems like Windows, Linux and Mac.

• Excellent Experience with source control system SVN (Subversion) used Tortoise SVN as client on windows and

command line interface on Linux.

• Have worked individually on projects as well as part of small and large teams.

• Ability to adopt to new methodologies, tools and technologies and domains depending on the job responsibilities.

Technical Skills:

Automation Tools Selenium IDE, Selenium RC, Selenium Grid, Web-Driver, QTP, Link Checker Pro,

SawMill, BrowserCam

Test Process and Other Test Director, Quality Center, ClearCase, ClearQuest, Requisite Pro

Databases SQL Server, Oracle, Netezza

Web Debugging Firebug, HTTPFox

Languages & Scripting Core Java, VBA, Python, Shell Scripting, SQL

Other Tools Jira, SVN, Visio, Microsoft Office, Aginity Netezza Workbench

Package Solutions Siebel

Operating Systems Windows, OSX, Linux

Professional Experience:

Client: Autotrader.com, Atlanta, GA. Dec 12 –

Till Date

AutoTrader.com, Inc. is an online marketplace for car shoppers and sellers. The sellers are predominantly Used and New

car dealers and also include individual private sellers. The numbers of listings are in millions combined together. The site

also provides users with automotive reviews, shopping advice, and comparison tools for car financing and insurance

information. The organization is owned by Cox enterprises, which also owns kbb.com, manheim.com (dealer to dealer

auction site)

Autotrader collects tags from the consumer site (autotrader.com) and analyses consumer behavior on the website to

understand make model preferences, frequently used search parameters, site redirects and behavior across devices. The

site is designed to fire tags that are collected as logs with useful information in well-formatted approach. The logs are then

loaded to the Netezza database, following which these logs are parsed and loaded to marts for reporting.

Role: QA Engineer

Responsibilities:

• Performed Business Requirement Analysis by thoroughly understanding Project Design Document and Business

Requirement Document.

• Created testing strategy keeping in mind project scope and timeline.

• Identified ambiguities and potential technical problems or design flaws so that preventive action can be taken.

• Designed and developed Automation framework both Data driven and Hybrid using Selenium WebDriver in

Java and performing unit testing by using TestNG.

• Developed test harnesses and automated tests in Selenium WebDriver.

• Wrote test plans, test objectives and detailed test cases for manual, regression and automated testing and ensure

that they are according to standards.

• Configured Selenium WebDriver, TestNG, Ant tool and created selenium automation scripts in java using

TestNG.

• Wrote and executed automated test cases using Selenium WebDriver to automate manual testing solutions.

• Converted all Record and play back selenese test cases into Selenium automated scripts.

• Developed Test Frameworks in Selenium for UI Regression Test Automation and when necessary, and potentially

execute Unit Test automation (Java/TestNG).

• Tested applications developed in Java with J2EE framework for Assessment division.

• Used Selenium WebDriver for writing test scripts for regression test coverage .

• Provided UAT testing support.

• Extended TestNG framework by adding some helper classes and methods.

• Performed web testing on Apple and Android devices, device emulators and simulators.

• Used Selenium WebDriver used to test search results of Meta search engine.

• Utilized HP Quality Center for test case management and IBM Rational ClearQuest for logging defects.

• Participated in bug walk meetings with development team, business team and project managers for defect triage

and provide analysis on the nature of the defect.

• Coordinated tasks with onshore/offshore resources.

• Developed user manuals and assist in training fellow employees to increase their knowledge of the system.

Environment: J2EE, Selenium WebDriver, TestNG, IBM Rational ClearQuest, HP Quality Center, Ant, MS Excel,

Mozilla Firefox and Windows.

Client: GE Energy, Concord, CA.

Sep 11 – Nov 12

The Generator Global Monitoring System (GMS) has been developed to provide improved maintenance, repair,

diagnostic, and prognostic solutions for generators. GE Energy Services has sponsored a program, Generator Outage

Extension Program to provide predictive diagnostics for the Generator.

The proposed M&D equipment houses data interface programs, data concentrator, rule execution environment, data

archiving and user interface. The system can integrate existing monitoring devices with it and provide diagnostics solution

on a common platform. The goal is to provide a low cost solution to the aged fleets so that they can extend the outage

interval and reduce the downtime.

Role: QA Engineer

Responsibilities:

• Elicited requirements from business to determine functional specifications leading to concrete implementation

requirements.

• Served as a liaison between business, application team and technical team.

• Reviewed the requirements and the Use Cases Diagrams to write Test Cases/ Test plan that would test various

Scenarios.

• Worked on Agile (Scrum) project methodology.

• Design and Developed automated functional Test suite using Selenium WebDriver.

• Design, develop and implement MVC Pattern based Keyword Driven automation testing framework utilizing

Java, Junit and Selenium WebDriver.

• Designed data-driven testing framework in Selenium and captured data dynamically from web controls.

• Used automated scripts and performed functionality testing during the various phases of the application

development using Selenium.

• Wrote scripts using WebDriver (script language -JAVA) and Junit framework.

• Executed manual and automated application testing for key product functionalities and developing new test plans

using tools such as Selenium and Junit.

• Served as a functional SME for high visibility projects providing recommendations for improvement and

technical expertise alongside project life cycle resulting in the delivery of projects on time.

• Performed Integration and Regression testing to check compatibility of new functionality with the existing

functionalities of the application using Selenium.

• Conducted stand up meetings to manage communications between multiple teams to ensure project success.

• Supported production install and served as a point person for project issues in the capacity of a Lead Analyst.

Environment: Java, Selenium WebDriver, Junit, JavaScript, HTML, CSS, XPath, Web Services, XML, Eclipse,

Windows, Oracle, Agile Methodology.

Client: GE Aviation, Cincinnati, OH. Oct 10 -

Aug 11

GE engine diagnostics is supplied by operational flight data that describe the performance of the engine and the aircraft as

well as the configuration information that characterizes the engine (thrust rating, engine type, etc.). Messages are received

in real-time as well as batch formats, parsed and analyzed to produce trends, alerts and customer notification reports, as

necessary, to recommend a course of action to the customer in the event that engines are in need of maintenance action.

The users of this information are external customers, carriers and other parties who contribute to the process of tracking

engines, as well as internal fleet managers, monitors, the customer support team and engineers who analyze and mine

diagnostics results to solve field issues, develop new analytic capabilities and provide increased understanding of product

performance. The data produced by diagnostics is also used to support Contract Margin Reviews for fleets under service

contracts, Engine Removal Forecasting, Work scope Planning and other business-critical analytical processes.

Role: QA Analyst

Responsibilities:

• Analyzed Business requirement (BRD's) functional design specifications (FDS) & use case Documents in order to

understand the application requirements, functionalities, scope and limitations.

• Divided tests into multiple actions to design more modular and efficient tests.

• Extensively used Quality Center for scheduling test and defect tracking.

• Developed Test Plans, Test Cases, Test Scripts, Test Strategy, Test Scenarios and Test Reports.

• Involved in Automation of realtime flight log data collection from outlook using VBA (Visual Basic for Applications).

• Performed Flight Log Data storage, archival and purging.

• Involved in Monitoring of missing flight log data and communicating problems/issues to the data collection team.

• Performed Functional test of the flight health check web application using QTP.

• Conducted Manual validation of the flight health metrics reported on the web application against the backend data.

• Created formulas in excel to replicate the basic forecasting and apply them to the flight specific data.

Environment:

• Website on Java platform; QTP for Automation

• SQL on SQL Server for data validation

• Excel, PowerPoint for reporting;

• Excel for adhoc analysis of data

• QC for bug tracking;

Client: NBC Universal (GE), New York, NY. Nov 09 –

Sep 10

STORM (Scheduling Technical Operations Resource Management) is a web-based solution designed to do scheduling for

personnel, facilities, equipment and materials. This solution is used by departments and shows to view estimated billing

and payroll costs. The workflow within STORM begins when a scheduler receives a request for a labor and the solution

utilizes existing workforce to assign based on cost and skill. Employees can then view their working schedules posted for

forthcoming days as well as daily work details such as hours worked, assignments, meal times, estimated penalties, etc.

Once the work has been completed and approved, labor information is sent to the payroll system.

Role: QA Analyst

Responsibilities:

• Performed tests on various sprints of Agile development process. Actively involved in Test Planning with manager &

team leads. Created Test scenarios and Test cases in Quality Center.

• Performed Smoke testing to determine if an application is healthy and stable before starting other major testing.

• Developed and maintained automated regression test cases in QTP.

• Performed Integration Testing as development team releases the product.

• Executed automated QTP scripts and reproduced failures manually.

• Tracked Defects/Bugs and logged those defects in Quality Center (QC) from Excel sheet matrix.

• Escalated defects to programmers/developers to resolve the issue in order to provide bug free product to the client.

• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the

testing environment using Selenium.

• Conducted End-to-End and Black box testing.

• Performed Security Test to determine if the system can protect itself from unauthorized internal & external users

• Conducted Data Validation Testing (back-end) using SQL queries.

• Performed Usability testing on all the GUI forms as an end user to make sure the application is user friendly and easy

to learn.

• Performed Acceptance Testing to evaluate the system compliance with the business requirements and ready for deliver

to the client.

• Tested Web page presentation manually for different Browser compatibility.

• Attended weekly defect report meetings and presented progress reports to senior management.

• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.

• Executed test cases before and after bug fixes for each build for User acceptance testing.

Environment:

• Website on Java platform; QTP for Automation

• SQL on SQL Server for data validation

• Excel, PowerPoint for reporting;

• Jira for task management

• BugZilla for bug tracking

Company: Moftware Infotech Pvt. Ltd, India

Sep 08 – Oct 09

Project: Web based application testing

Moftware started as a Virginia-based LLC, and is now a multi-national business and the owner of many internet

retailers offering mobile and MP3 enhancements. Moftware’s focuses on providing high quality products at

competitive prices to consumers so they don’t have to deal with the hassle of comparison shopping. Today

Moftware serves retail consumers worldwide and proudly serves over 85% of USA’s Fortune 500 companies.

Moftware also caters to the US Government, US Military, Educational institutions, and small businesses.

Role: QA Tester

Responsibilities:

• Prepared Test cases for Testing of applications with Web-based interfaces.

• Involved in Functional study of application.

• Involved in preparing Test cases.

• Design of ITP (Integrated Test Plan), Test Schedule and Test Matrix.

• Involved in execution of Test cases.

• Involved in Tracking of Bugs.

• Used Log files to find out details and Sawmill to Remove bugs in the application and conduct testing to

ensure application functionality as per client requirements / specifications.

• Response code analysis for websites with Log Analysis.

Environment: ASP, PHP, SQL Server 7.0

Testing Tools: Sawmill

Company: Segue Solutions, India. Jun 06 –

Aug 08

Project: Personal Assistance Software

Personal Assistance Software provides reminder to the registered user from various department like Credit

Card, Bank Information, Insurance, Loan, Utility Payment and Date to Remember. It gives reminder to the user

on his mail before three days of last billing date and through SMS on his mobile before one day of billing date.

It also maintains the personal information about the registered user and reminds him about its important date of

his life like family, relatives, friends and his own birthday, marriage ceremony etc. The product is developed

with .Net Technologies with SQL-Server 2000 as the back end database.

Role: QA Tester

Responsibilities:

• Writing Test Cases.

• Involved in GUI Testing.

• Involved in Functionality testing and Regression testing.

• Held weekly meeting with the Teammates and Team Lead and escalated the issues concerned.

• Prepared defect reports.

Environment: Asp.Net, Vb.Net, IIS Server, SQL-Server

Testing Tools: Manual

References: Will be provided on request.

Contact this candidate