QA Tester
Resume:
CHETAN BRAHMBHATT
********@*******.***
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