Resume

Sign in

QA Tester

Location:
Edison, New Jersey, United States
Posted:
January 09, 2018

Contact this candidate

Resume:

CHETAN BRAHMBHATT

201-***-**** ©

ac3ywc@r.postjobfree.com

linkedin.com: /in/chetan-brahmbhatt-a839407/

SKILL SUMMARY:

** *****: Quality Assurance and Quality Control Manual and Automated testing of Client Server and Web Applications.

Mercury Automated Tools Quick Test Pro, WinRunner, LoadRunner, TestDirector, Quality Center, Selenium WebDriver.

Core Testing Skills- Test Planning Defect Categorization, Reporting Test coverage Pre-automation planning Regression decisions Defect-tracking to closure.

Performed Manual & Automated testing using test scripts and test cases.

Writing test Plans and strategies using test methodologies.

Excellent experience of Parameterization, adding checkpoint with functional and performance tools.

Performance testing results collation and feedback to developers.

Testing Web/Windows application.

File and record Extraction using FTP/Import/Export using UNIX Shell Scripts.

Extensively used Oracle utility such as SQL-Loader, Export/Import for loading/extracting data.

Used PL/SQL (stored procedures, triggers) for data validation.

TECHNICAL SKILLS:

Testing Tools: Selenium WebDriver, QuickTestPro 6.5/8.0.1/8.2, WinRunner 7.5/8.0

Defect Tracking Tools: Jira, Bugzilla, Test Director 7.6/8.0, Quality Center 9.0, PVCS, and Lotus notes,

Web Technologies: ASP.NET, VB.NET, ASP, VB Script, JavaScript, JSP, EJB, J2EE, Web Services, SOAP, REST, Ajax, CSS, Eclipse, Demandware 17.3

Languages: VB, ASP, Java, JavaScript, XML, HTML/DHTML, PL/SQL, C, C++

Databases: Oracle 8.0/7.x, SQL Developer, MySql, Mongo, MS SQL Server 2000 / 7.0, Informix, DB2, MS-Access

Operating System: Windows 2000, 2003, Advanced Server, NT, UNIX/Linux, Solaris 5.6

Networking/Web: TCP/IP, FTP/SFTP, Telnet, Cyberduck 5.1

Utilities: SQL Load, SQLPLUS

EXPERIENCE

Nine West Holdings Inc, NY May’ 12 – Present

Sr, QA Analyst

Nine West Holdings, Inc is a leading global designer, marketer and wholesaler of over 35 brands with product expertise in apparel, footwear, Jeanswear, jewelry and handbags. The Jones Group has a reputation for innovation, excellence in product quality and value, operational execution and talent. The Company also markets directly to consumers through branded specialty retail and outlet stores, through concessions at upscale department stores and through its e-commerce sites.

The Company's internationally recognized brands and licensing agreements (L) include: Nine West, Jones New York, Anne Klein, Kurt Geiger, Rachel Roy (L), Robert Rodriguez, Robbi & Nikki, Stuart Weitzman, Brian Atwood (L), Boutique 9, Easy Spirit, Carvela, Gloria Vanderbilt, l.e.i., Bandolino, Enzo Angiolini, Nine & Co., GLO, Joan & David, Miss KG, Kasper, Energie, Evan-Picone, Le Suit, Mootsies Tootsies, Grane, Erika, Napier, Jessica Simpson (L), Givenchy (L), Judith Jack, Albert Nipon, Pappagallo and Rafe (L).

Projects:

Paypal

Shoprunner

BorderFree Internationalization

Payrunner

Amazon Pay

Responsibilities:

Tested the application manually before automating the desired test cases

Developed and executed Selenium junit test on Selenium RC and WebDriver.

Modified the scripts in accordance with the testing needs and requirements.

Discussed automation strategy with fellow team members.

Discussed and resolved issues in the application with development team.

Prepared Test Cases and Test Scenarios for all the different Brands.

Tested the application as per the PCI Compliance requirements.

Tested different feeds and back-end functionality to ensure input and output adhere to

test specifications.

Tested the application on different Browsers, Operating systems and Mobile Devices.

Tested Application’s responsiveness for different Mobile Devices.

Validate the pre-production and post-production design and functionality for AB testing.

Help Marketers in testing promotion, discounts and daily production updates.

Testing all homepages and landing pages tags and tracking implementation across devices and browsers ensure all images, copy, CTAs and linking are accurate.

Helped Customer Service operational team to identify problems on Production issues.

Works with Customer Service to recreate customer issues, documents and submit to development team.

Used 3rd party API’s to ensure the application interacts and integrates correctly.

Testing the application on multiple environments for functionality, Regression, Usability, Security testing.

Responsible for Regression testing of all development releases.

Experience working in an agile development environment.

Conducted database testing, passing SQL queries to Oracle DB.

Use TOAD for running queries to check the data validation.

Ensured that Web Site content is user-centric, logical, and consistent in style, format, and quality.

Co-ordinate with developers/team members on different projects to set the priorities on testing.

Used Bugzilla, JIRA defect reporting tool

Environment: Java 1.8, Java Scripts, XML, HTML, Mac 10.5, Windows vista, Windows - 7 8 10, Eclipse 3.x, Selenium WebDriver 3.3.x, Mozilla Firefox 52.0.2, Safari 4.x, Chrome 5, IE 8,9, Oracle 10g, Winscp 4.1.8, Ecometry, Putty 0.60.0.0, Demandware v 17.3,, Citrix, Ecometry, Cyberduck 5.1, Bugzilla 4.4.6, JIRA v1000.870.4. Basecamp Project Mgmt Tool.

QCSA Holdings, Inc., PA Apr’ 11 – Feb’ 12

Sr, QA Analyst

QCSA Holdings, Inc. and its brands, Salvage Direct and Crashed Toys, remarket all types of vehicles including commercial and industrial, cars and trucks, motorcycles, ATVs, RVs, boats, personal watercraft and more! The company works with insurance, finance and rental companies and self-insured fleets.

Salvage Direct remarkets all kinds of vehicles including recovered, repossessed, damaged, non-damaged, salvage and non-salvage. Every seller can take advantage of a range of marketing services that target a worldwide bidding market.

Responsibilities:

Prepared the Test Cases based on Functional and Technical documents.

Developed and automated tests scripts using functional automated test tool AppPerfect

Web Test.

Used Object spy to recognize and verify the objects in the application.

Parameterized values in the scripts to validate the data.

Modified the scripts in accordance with the testing needs and requirements.

Discussed automation strategy with fellow team members.

Attended daily status meeting with the team members.

Discussed and resolved issues in the application with development team.

Co-ordinate with developers/team members on different projects to set the priorities on testing.

Environment: Windows 7, AppPerfect Web Test 12.0,Jira, IE 8, Chrome 11,PHP, ASP,HTML, MySQL, Apache

Cross Commerce Media, NY Apr’ 09 – Mar’ 11

Sr, QA Analyst

Cross Commerce Media, Inc. (CCM) operates the first cross media analytics network. Recognizing a shift in consumer behavior and the relationship between offline and online media, CCM technology allows companies to measure customer behavior across multiple forms of media in real time. The CCM solution is designed to improve advertising relevancy through proprietary analytics tools that deliver a single-source of measurement across ALL media channels.

For the first time, marketers can have a holistic view of their offline and online campaign performance. CCM has developed an analytics platform that unifies a company’s multiple data sources in real time – delivering a collective view of both offline and online metrics.

Projects:

Yinzo

Loci

Collective Intelligence

Responsibilities:

Involved in testing the application from planning to implement.

Testing the application on multiple environments for functionality, Regression, Usability, Security testing.

Prepared the Test Cases/Test Scenarios based on User stories, wireframes and html mockups.

Attending and participating in sprint planning, grooming and review meetings with fellow team members.

Involved in testing the application manually before automating the desired test cases.

Generated test data for Integration and QA environment.

Conducted database testing, passing SQL queries to the MySql database.

Performed Positive and Negative testing for system validations.

Execute and deploy builds on QA environment as and when needed.

Verify the QA logs to check the exception errors for the issues/bugs.

Co-ordinate with developers/team members on different projects to set the priorities on testing.

Worked under Agile methodology process.

Attending daily Scrum meeting with other team members for day to day progress.

Performed web-services testing using REST API.

Developed and executed Selenium junit test on Selenium RC.

Performed Front-end, Back-end, Blackbox, and Whitebox testing.

Used Jira as defect tracking tool to report defect/bugs, issues.

Tested the application on different browsers and operating systems.

Environment: Java 1.6, Java Scripts, XML, HTML, MySql 5.5, Mongo 1.6.5, Linux 2.6.9, Mac 10.5, Windows vista, Windows 7, Apache SVN, Eclipse 3.x, Jira, Selenium, Mozilla Firefox 3.x, Safari 4.x, Chrome 5, IE 6, 7

Wireless Generation, NY Jul’ 08 – Mar’ 09

Sr, QA Analyst

Wireless Generation offers consulting, design, and development services for state- and district-wide data systems that centralize student data from various sources. These systems continuously update data and give educators current and historical views of each child. Wireless Generation also integrates professional collaboration and knowledge management tools, making it possible for a teacher in one school to find and work with a colleague anywhere in the district who has a similar instructional challenge.

Project: - (ARIS) Achievement Reporting and Innovation System

The Achievement Reporting and Innovation System (ARIS) is a custom reporting application for the New York City Department of Education (NYCDOE). ARIS is a support system for teaching and learning in NYC schools. It is designed to enhance teachers’understanding of their students’ needs, help them to spot struggling students quickly, and problem solve with colleagues across classrooms, schools, and networks. ARIS brings data about New York City students (such as demographics, attendance, end of term grades, interim assessments, IEP status) into a single system to provide educators with a complete, regularly updated picture of students’ academic development. . ARIS saves teachers time, gives them access from any Internet-connected computer, and enable them to view student learning in a larger context of the school, network, or district. ARIS is also an online community for sharing professional knowledge and solutions to challenges. The ARIS online community gives teachers a place to pool their solutions, and find and develop new ones. ARIS also include a Family Portal. Parents can log on from any Internet-connected computer to view up-to-date information about their child with clear, easy-to-understand explanations of what they see and what the information means in terms of their child’s individual learning progress. The New York City Department of Education's Achievement Reporting and Innovation System (ARIS) provide a single place where educators can find important information to use to accelerate student learning.

The Data team runs tests on data before delivering it to other ARIS teams in order to verify that data quality expectations are satisfied. Expectations include what's commonly understood about ARIS data, especially what follows from desired ETL screens, design realities, and constraints.

Responsibilities:

Conducted database testing, passing SQL queries to the Oracle database

Performed Smoke, Integration, Regression, Functional testing.

Co-ordinate with developers and system administrator as and when required

Used Quality Center to develop Test Cases based on the functional requirement doc.

Prepared Test Cases and Test Scenarios.

Execute scripts developed in Python to perform ETL

Develop and execute Sql queries using Sql developer to verify the data validation as per the

Specification.

Verified the Tables are loaded with correct data.

Verified the Constrains are applied correctly and tested them developing Sql query.

Opened and logged the data issues in fogbugz.

Discussed and resolved the bugs/issues with Developers.

Involved in testing the application on Backend side.

Involved in testing the application manually before automating the desired test cases.

Attended Sprint review meeting with fellow team members.

Attended daily Scrum meeting for the daily progress and performance.

Environment: Oracle 10g, SQL Developer 1.5.1, Putty0.60, Winscp 4.1.6, SVN, Ascential Datastage, Python 2.5, Linux 2.6.9, Quality Center10.0,Subversion 1.5, FogBugz

Accoona Corp, NJ Mar’ 07 - Apr’ 08

Lead QA Analyst

Accoona is an eCommerce company engaged in three primary business lines - online-based lead generation, online search in the United States, Europe and China, and eCommerce consumer electronics retailing. Our services enable users to find the products, services and information they want, obtain competitive pricing and make informed buying decisions. We use our expertise in technology, marketing and management to support our business lines and create synergies and efficiencies across business lines.

They are organized primarily into the following sectors:

lead generation via our online-based Exchange Place business

search including both our Web, news and business information search engine and Buyer’s Edge, our shopping comparison search engine

eCommerce consumer retailing

Project: ExchangePlace

Accoona's Exchange Place (www.exchangeplace.com) is the first cross-industry online advertising platform and pay-per-lead bidding system. It's an interactive marketplace for a wide variety of products and services where pre-screened buyers and sellers are matched, often in real time, through online and offline direct response channels.

Responsibilities:

The application has been developed in HTML and Java script and Oracle Database on a Windows/XP environment.

Involved in testing the application manually.

Prepared the Test Cases based on FRD and BRD.

Prepared Test Scenarios for the application

Involved in testing the application for different vendors (TTC, AIS, Intelimedia)

Developed the Test procedure documents for Offline Lead Data Transmission.

Developed automated scripts for Consumer forms using QTP.

Used database checkpoints for data validation in QTP.

Used parameter value to parameterize a step in test.

Created Test Scripts using QTP and modified them in accordance with the testing needs.

Involved in UAT testing for Offline lead generation process.

Used FTP to verify the process for transfer of data

Performed Integration, Regression, Functional testing.

Co-ordinate with developers and system administrator as and when required

Attended periodical meeting with the team lead and team members as and when required

Involved in testing the application on Backend side.

Use TOAD for running queries to check the data validation.

Used Bugzilla and Jira as defect reporting tool.

Conducted database testing, passing SQL queries to the Oracle database.

Environment: Java Script, XML, HTML, QTP 9.0, Jira, Oracle, MS SQL Server 2000, IE ( 6.0, 7.0), Mozilla Firefox 4.0, TOAD, MS Office Tools

Dow Jones & Company, NJ Jul’ 05 – Dec’ 06

QA Analyst

Dow Jones & Company publishes the world's most vital business and financial news and information. The Wall Street Journal is the leading global newspaper of business.

Data warehouse Cleanup

The Data warehouse needed data from the different databases. Verified scripts to load the data files into CIDW db, verified and executed data cleansing programs to clean data retrieved from Customer transaction, Profile and Article database as per the business specification and requirements.

Responsibilities

Developed test cases in Test Director based on Business requirement document

Developed several Sql queries for database reliability and verification

Used FTP to verify the process for transfer of data

Tracked and reported bugs using Test Director as defect tracking tool

Attended the QA status and team meeting with fellow team members

Performed Functionality testing, Regression testing, Positive and Negative testing

Generated test data for testing data accuracy and reliability

Executed the shell scripts verified the logs and exceptions

Co-ordinate with the developer’s as and when required.

Environment: Sun Solaris 5.7, Oracle 8i, Toad, Test Director 7.2, CRT 3.4

Sears Roebuck & Co, IL Apr’ 04 – Jun’ 05

QA Analyst

Sears, Roebuck and Co. is a leading U.S. retailer of apparel, home and automotive products and services. The company serves families throughout the country with full-line department stores. To take advantage of the new Internet economy Sears is implementing a new direct marketing initiative to better understand the relationship between Sears and it’s Customers.

Projects:

Epiphany Campaign Management

LCI File Feed

Additional BV Data in Epiphany

LCI Ad - Hoc Analysis

Responsibilities

Developed and executed test cases

Developed requirement decomposition documents for testing based on BFS, FDS, DDS doc

Used FTP to transfer data from different servers

Used sqlldr to load the data into tables

Developed Sql queries for database reliability and validation

Prepared high level requirement matrix

Used Lotus Notes as a Problem and Discrepancies tool.

Presented walkthrough with the team lead for the requirement decomposition documents for the projects

Actively attended the QA status and team meeting with fellow team members

Performed Interface testing, Regression testing, Functionality testing, Positive and Negative testing

Used Epiphany CRM tool for creating different campaigns.

Developed test scenarios for test purpose.

Generated test data as per the business specifications

Involved in pilot test for the production environment

Executed the shell scripts for the Extraction /File records

Selected for the training of E.piphany

Developed test procedure documents for LCI File Feed and LCI Ad Hoc Analysis projects

Co-ordinate with the developer’s team members on the different projects as and when required.

Environment: Sun Solaris 5.7, Informix 7.23, Oracle 8i, Broadvision 4.1 and 5.5, Toad, Tera data, Queryman, TeraTerm Pro, Lotus Notes, MS Access, E.piphany E4, E5

Barnes&Noble.com, NY May’ 03 – Mar’ 04

QA Analyst

Fanfare and BN Explorer

New search functionality was enhanced on the BN.Com website. This search engine employs 3rd and 4th generation search technologies that give natural language search ability with a high rate of precision syntactical and semantic searching and browsing to the end customer. The purpose of replacing the search engine was to enhance the customer search and browse experience by enabling them to ask BN.Com a question, and return to the customer books that best match that question.

Responsibilities

Prepared test plan and test cases and stored in Test Director.

Did a baseline testing to get a proper environment for the website.

Prepared documents on environment issues and worked around with the developers to resolve the issues.

Involved in Server testing/Load test using Load Runner

Tested the application on Server using VU generator and creating VU in Load Runner Controller.

Tested the application on different browsers and operating systems.

Performed functionality, regression, screen navigation testing.

Attended periodical meeting with the team lead and team members as and when required.

Environment: Sun Solaris 5.7, WinRunner, IE (4.0, 4.5) Net Scape (4.7), Java, JSP, SQL Server,

Windows NT

CBS Inc, NJ May’ 02 – Mar’ 03

QA Analyst

Financial Information Exchange System (web based)

Money Tran is an internet based B2B mission critical, highly secure, extremely reliable, robust, per foment, scalable invoice and payments related financial information exchange with global customer base and connectivity, offering its services to corporate customers in several vertical markets.

Responsibilities:

Prepared and executed test cases and test scripts.

Prepared trouble reports for the discrepancies.

Developed test scripts on security of application.

Developed TSL Scripts for performance testing in Win runner

Performed regression and performance testing.

Used Test Director as defect tracking tool

Testing the proper Screen Navigation of the screens using Win runner.

Tested the validation in the backend for database reliability and transaction testing.

Participated in walkthrough and defect report meetings periodically.

Environment: Java, Java Script, VB script, Oracle 8i, Test Director, Windows NT, UNIX

Education

B. S. in Accounting and Finance.

Diploma in Computer Applications



Contact this candidate