Post Job Free

Resume

Sign in

QA ANALYST

Location:
Union, NJ
Posted:
April 06, 2017

Contact this candidate

Resume:

SANDEEP SHARMA

aczoo3@r.postjobfree.com

Phone:- 862-***-****

SUMMARY

Over 8 years of experience in Information Technology in analysis, design, manual and automated testing of Client/Server, and Web-Based business applications in Healthcare, Retail, Financial domains using Agile methodologies.

Extensive background in QA methodologies – Agile Software Development Methodology, Waterfall Methodology.

Good understanding of Database Design and experience in writing SQL queries

Expertise in verifying program logic by using QTP, preparing test data for trial runs, tests and debugs programs

Experience in developing Test Plans, Test Approach, Validation Plans, Test Cases, Test scripts and Test Environments.

Extensive experience on Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, Client/Server applications

Experience in tools such as Load Runner, Quick Test Professional (QTP), Test Director, Quality Center and defect Tracking Tools such as PVCS Tracker and Bugzilla

Experience in conducting System, Integration, Functional, User-Acceptance Testing (UAT), Database, Performance Testing, Web Based Applications Testing, Regression Testing and improvement of QA Process.

Good understanding of standardized testing process and extensive experience in creating project environment in Test Director or Quality Center which includes Requirement Management, Test Cases, Creating Test Sets, uploading automation scripts, Defect Management and Test Reporting.

Experienced in Functional Specification Document (FSD) and business requirement documents (BRD)

Extensive testing and validation of different aspects of ETL testing such as data source, data type, data mapping, and data transformation.

Collaborated with developers, quality assurance, production support, and end users to provide business direction on system analysis, design, development, testing and deployment.

Experience in Testing Database Applications of RDBMS in DB2, SQL Server, Oracle Skilled with SQL Queries.

Demonstrated strengths in communicating with all levels within an organization, and possesses excellent interpersonal, written and oral communication skills.

Experience working in Offshore/Onshore model.

TECHNICAL SKILLS

Automated

Testing Tools

QTP 9.0,9.2,10.0,11.0, Load Runner

9.5,11.04,11.05, Selenium, TFS

Bug Tracking Tools

Quality Center/Test Director, PVCS Tracker, Lotus Notes, Test Track, I Track, JIRA, RM Track

DB Query Tools

SQL,PL/SQL, Advance SQL, Oracle Developer

Programming Languages

VB.NET, Visual Basic, MS Access, SSRS, Java

Database

MS SQL Server, Oracle 9i-10g,11, Sybase, MS-Access

Designing Tools

Word, Excel, Power Point, MS Office, Visual Studio

Mobile Platforms

iPhone OS(5, 5s, 6, 6s and 6Plus), Android OS(Galaxy, Note 3, Note 4, s4, s5,Nexus S, Samsung)

Operating Systems

Windows 97/XP/2000/NT

Web Server

Internet Information Server (IIS), Web logic, TCP/IP

WORK EXPERIENCE

Bed bath & Beyond, Union, NJ April 2015 – Till Date

Sr. QA Tester / Analyst

The company Bed Bath & Beyond Inc. and subsidiaries is a retailer selling a wide assortment of domestics merchandise and home furnishings which operates under the names Bed Bath & Beyond, Christmas Tree Shops, Harmon Face Values, buy buy BABY and World Market, Cost Plus

Responsibilities:

Analyzed the Business Requirement docs,functional specs,user stories and developed test cases and test scripts

Prepared the manual test cases and prioritized the test cases

Interacted with developers and customer support to analyze client specific customizations.

Executed test cases to compare the actual result with expected results in accordance with business, technical and functional specs of the applications

Performed Functional Regression and System testing of the different versions of BBB's application.

Execute Browser Compatibility Testing(IE,Firefox,Chrome,Safari) of Web based applications .

Created and executed End to End Use Cases for User Acceptance Testing

Created test cases for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.

Ensure test data is properly identified, setup and availability of stub before execution of a test.

Designed the test case descriptions and designed the steps for expected Vs Actual results

Verified the database tables of sources, targets, mappings and SQL queries in the

transformations

Extensively used the SQL queries to validate the backend database

Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in SQL Server Database.

Testing the ETL data movement from Oracle Data mart to ATG Data mart on an Incremental and full load basis.

Extracted data from Oracle and upload to ATG tables

Involved in developing test cases to test ATG

Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Responsible to report on Error Exceptions, Health Checks including performance and availability, report on Production Support Issues, Document Process for monitoring and report out to DBO Data Quality

Involved in document Process for monitoring Error Exceptions and document Process for Production Support

Provided daily status updates in standups.

Performed data requirement analysis, ETL methodology for Data Extraction, Transforming and Loading with ATG Tool

Active participation in Agile Meetings: Sprint Planning, Daily Stand-up, Sprint Review and the Sprint Retrospective.

Reported defects using JIRA and RM Track

Worked on Omniture tech specs to check if the applications are triggering the right events.

Run the demos to business after the completion of every feature/stories

Performed Sanity testing after every deployment to make sure the application is strong enough to start the testing efforts.

Actively participating in production support to validate critical defects

Provided daily status updates in standups.

Involved in testing activities using iOS and Android devices

Reviewed the COS (Condition of Satisfaction) from Agile to create the test scenarios.

Prepared test data for various levels of testing including environments and services

Performed Sanity testing after every deployment to make sure the application is strong enough to start the testing efforts.

Validated web service calls using Putty, Postman and chrome poster.

Executed automated test scripts to perform the sanity using Selenium and UFT

Participated in the Readout Meetings to escalate the issues before time.

Environment:, Windows XP,AJAX, ASP.Net,Java,SQLServer2008,.Oralce 11.2.Rational 5.0.2, JIRA 5.2, RM Track 4.0

Tiffany & Co Parsippany,NJ June 2014 – March 2015

Sr. QA Tester / Analyst

Tiffany & Co. is a holding company that operates through its subsidiary companies. Tiffany and Company is a jeweler and specialty retailer, whose merchandise offerings include an extensive selection of jewelry as well as timepieces, sterling silverware, china, crystal, stationery, fragrances and accessories. Through Tiffany and Company and other subsidiaries, the Company is engaged in product design, manufacturing and retailing activities.

Responsibilities:

Analyzed the Business Requirement docs and functional specs, developed test Plans, test cases

and test scripts

Prepared the manual test cases and prioritized the test cases

Interacted with developers and customer support to analyse client specific customizations.

Executed test cases to compare the actual result with expected results in accordance with business, technical and functional specs of the applications Performed GUI functional and sanity testing manually for each new build of the application

Experience in Unit, Integration, System Testing using different devices(Iphone,Ipad,Web based applications)

Execute Browser Compatibility Testing(IE,Firefox,Chrome,Safari) of a Web based application

Created and executed End to End Use Cases for User Acceptance Testing

Created test cases in for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.

Ensure test data is properly identified, setup and availability of stub before execution of a test. Designed the test case descriptions and designed the steps for expected Vs Actual results

Verified the database tables of sources, targets, mappings and SQL queries in the

transformations

Active participation in Agile Meetings: Sprint Planning, Daily Stand-up, Sprint Review and the Sprint Retrospective.

Actively participating in team meeting and status meetings

Test GUI and functionality on Android and iOS

Extensively used the SQL queries to validate the backend database

Report defects using Itrack

Environment:, AJAX, ASP.Net, SQL Server 2008, .Net 4.0,Soap UI 4.0, Itrack, Windows XP

DDNJ Parsippany,NJ August 2013 – May 2014 Date

Sr. QA Tester / Analyst

Delta Dental of New Jersey provides or administers dental coverage to more than 1.5 million people in New Jersey and Connecticut. DDNJ is a member of the national Delta Dental Plans Association, which serves more than one-third of the estimated 166 million Americans with dental benefits, providing national dental coverage to more than 60 million people in more than 111,000 groups

Responsibilities:

Conducted configuration and integration testing to ensure that developed systems satisfied the needs of business clients as specified in the requirements

Analyzed the Business Requirement docs and functional specs, developed test Plans, test cases

and test scripts

Communicated frequently with Business Analyst to obtain and clarify application configuration requirements.

Prepared and reviewed UAT test artifacts (Test Scripts, Test Result Summary, etc.) related to Client Implementation Identify application modules (Benefit connection)

Prepared the manual test cases and prioritized the test cases

Interacted with developers and customer support to analyse client specific customizations.

Modified the script for user defined functions

Created test cases in for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.

Managed the defects, executed automated scripts and manual test cases.

Designed the test case descriptions and designed the steps for expected Vs Actual results

Verified the database tables of sources, targets, mappings and SQL queries in the

transformations

Actively participating in team meeting and status meetings

Extensively used the SQL queries to validate the backend database

Verifying that Claims are validated as per Business Rules and good claims are successfully loaded for the adjudication.

Performed functionality testing on Web and MC applications.

Performed complete end-to-end System, Functional and Integration testing

Development and executed Automated Test Scripts for Regression testing using QTP.

Contributed extensively with UAT team as a subject matter expert to clarify enquiries, and business requirements

Created and managed tracking of all defects in Visual Studio 2013, escalated issues and reported status to management and project team.

Responsible for testing sign-off, production business validation efforts to ensure the connectivity and Data Configurations mimics production

Performed Count Validation, and Data Quality Validation with respect to Source (Single Tenant) and Target (Multitenant)database tables

Developed SQL scripts for querying data against Source and Target Reference and Transactional databases tables for Count and Data verification process

Extracted the Source and Target tables data to excel sheet, used Data Validation macro in excel and validated the data to ensure the correctness of the data in the Migrated Multitenant database

Environment: QTP, QC, Microsoft .Net Framework, ASP.NET, ADO.NET, Visual Basis 6.0, Oracle, SQL Server 2005. Soap UI 4.0

Tiffany & Co Parsippany,NJ April 2013 – July 2013

Sr. QA Tester / Analyst

Tiffany & Co. is a holding company that operates through its subsidiary companies. Tiffany and Company is a jeweler and specialty retailer, whose merchandise offerings include an extensive selection of jewelry as well as timepieces, sterling silverware, china, crystal, stationery, fragrances and accessories. Through Tiffany and Company and other subsidiaries, the Company is engaged in product design, manufacturing and retailing activities.

Tiffany & Co. is a holding company that operates through its subsidiary companies. Tiffany and Company is a jeweler and specialty retailer, whose merchandise offerings include an extensive selection of jewelry as well as timepieces, sterling silverware, china, crystal, stationery, fragrances and accessories. Through Tiffany and Company and other subsidiaries, the Company is engaged in product design, manufacturing and retailing activities.

Responsibilities:

Analyzed the Business Requirement docs and functional specs, developed test Plans, test cases

and test scripts

Prepared the manual test cases and prioritized the test cases

Interacted with developers and customer support to analyse client specific customizations.

Executed test cases to compare the actual result with expected results in accordance with business, technical and functional specs of the applications Performed GUI functional and sanity testing manually for each new build of the application

Experience in Unit, Integration, System Testing using different devices(Iphone,Ipad,Web based applications)

Execute Browser Compatibility Testing(IE,Firefox,Chrome,Safari) of a Web based application

Created and executed End to End Use Cases for User Acceptance Testing

Created test cases in for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.

Ensure test data is properly identified, setup and availability of stub before execution of a test. Designed the test case descriptions and designed the steps for expected Vs Actual results

Verified the database tables of sources, targets, mappings and SQL queries in the

transformations

Actively participating in team meeting and status meetings

Test GUI and functionality on Android and iOS

Extensively used the SQL queries to validate the backend database

Report defects using Itrack

Environment:, AJAX, ASP.Net, SQL Server 2008, .Net 4.0,Soap UI 4.0, Itrack,Windows XP

COT(Frankfort, KY) June 2012 – April 2013

Sr. QA Tester / Analyst

The Commonwealth Office of Technology provides technology enabled business results for 21st century government. COT attempts to set the Commonwealth’s standard in transferring of information resources, technology products, and services. COT provides high quality, cost effective, timely, innovative, secure and reliable information management and technological solutions that focus on supporting the business strategies and operations of the Commonwealth.

Responsibilities:

Analyzed the Business Requirement docs and functional specs, developed test Plans, test cases

and test scripts

Prepared the manual test cases and prioritized the automation test cases

Interacted with developers and customer support to analyze client specific customizations.

Modified the script for user defined functions

Created test cases in Quality Center for various levels of test such as Integration test, Regression test, System test, End to End test and User Acceptance test for different modules.

Created the performance test scripts as per the requirements.

Created the Performance Test Plan.

Created the performance scripts to load all the Test Data.

Created Database Vuser scripts by recording the activity between the client and the server

Designed scenarios for Performance Testing, Generating scripts and handling Correlation as well as parameterization using Load runner Vugen, executed scenarios using Controller and analyzed the results using Load runner Analyzer.

Managed the defects, executed automated scripts and manual test cases through the Quality

Center

Designed the test case descriptions and designed the steps for expected Vs Actual results

Developed automated test scripts using QTP 10.0 for functional and regression testing

Verified the database tables of sources, targets, mappings and SQL queries in the

transformations

Actively participated in team meeting and status meetings

Extensively used the SQL queries to validate the backend database

Environment: QTP 10.0, Load Runner 11.05, Quality Center 9.2, SQL Server, Oracle, VB.Net, VC++,VB Script, Java, SAP, Web Services, Windows-NT

Fiserv (Morris Plain NJ) March 2004 – Aug 2011

QA /.Net Developer

Advantage Fee System is used by large banks and investment advisors for complete automation of the billing process for both industries, it provides both invoicing and direct debit with unequalled accuracy on the most complex fee schedules. The application is designed and developed for automated billing, payments and direct debit processing. The application receives transactional and account data through imports or user interface, processes it based upon the specified billing rules and generates bills/invoices. These invoices can then be paid using either Advantage Account receivable or exported for direct debit processing.

Responsibilities:

Was responsible to understand the business needs and preparing Business, Functional, Non Functional and Technical System documents.

Designed mock-ups based on the client specific business rules and practices and presented to the team.

Participates in technical reviews and inspections to verify 'intent of change' is carried through the entire project.

Created Unit-Integration and System-Functional Test Plans and Test Cases.

Helped in creating Performance & User acceptance Test Plans and Test.

Performed Unit and System/Functional testing for all applications.

Participated in daily/weekly status meeting w/ different level of groups. Attended the brain-wash/review sessions w/ the team/Business.

Used Quality Center for defects/bug tracking, detailed analysis & various metrics.

Along w/ the defined testing process, I performed the testing to accomplish the user requirement. Performed the testing as an when code is available fully or module wise, kind of increment testing which helped to expedite the testing process.

Worked as a part of a team in developing a web based application using Microsoft ASP.NET/VB.NET technologies.

Developed various classes, functions and web services for the application.

Used SQL Server in designing database, tables, Queries and procedures.

Worked on each release and implemented new challenges/changes within the timeline.

Functioned as the Onsite / Offshore coordinator.

Environment: - QTP 10.0, Quality Center 8.0, SQL Server, Oracle, VB.Net, VC++,VB Script, MS Access, SSRS, Web Services, Windows-NT

EDUCATION

Certificate Course in VB 6.0

Bachelor in Information Technology, Indira Gandhi Polytechnic, Delhi.

PGDCA in Information Technology, Indira Gandhi Polytechnic, Delhi



Contact this candidate