SUMMARY:

• Software QA/UAT experience in Digital marketing web UI/Content testing, Functional testing, Performance, Security, Accessibility testing, Internationalization testing, Data visualization, ETL - Data Warehousing, Client/Server, and Web-based technologies.

QA / Testing and Operational:

• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Good knowledge of Data Warehousing concepts, Software Development Life Cycle (SDLC), and QA Methodologies like Agile-Scrum, Waterfall, and Iterative process.
• Good knowledge in various types of testing like Website testing, Devices (Mobile & Tablets) testing, Accessibility, Security, Performance, Functional testing.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases / Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Effective in Leading and Multi-Tasking in various modules across Product/Service based projects.
• Experienced in Onsite-Offshore model, delegating tasks, verification of the deliverables etc.
• Proficiency in effective and comprehensive test execution, reviewing, reporting and test closer.
• Hands on experience in QA Estimates, QA Metrics, and QA Task inclusion in the Confidential Project Plan.
• Excellent team player with good communication skills and mostly interact with multiple teams at the client place.

QA Technical Experience:

• Experience on Functional testing, System Testing, Regression Testing, GUI Testing, Smoke testing, System Integration Testing (SIT), Software Validation testing & UAT.
• Experience in Automation testing like running regression suites using Selenium (C# scripting) and reporting the failures.
• Strong knowledge web page built and to test them, validating cache, images, links, query params, HTML, CSS, JS, AJAX calls, cookies, content, Redlines, Mock-ups and design document.
• Experience of working in Content management system tool Compass.
• Digital marketing website E2E testing, A/B tests, Content publishing verification.
• Creating Report in Confidential Power BI tool with retrieving data from SQL server.
• Expertise in querying and testing RDBMS such as Oracle, SQL server using SQL for data integrity.
• Proficient in SQL -DDL and DML statements, Joins, CASE statements for data querying, analysis and validation.
• Have good experience in Data Migration testing and Web Interface testing.
• Working with Developers, Designers, producers to identify Stories / Features and executes the test cases against them.
• Expertise in test management using HP Quality Center and Confidential Test Manager.
• Experience in working with Software Development team in resolving defects and documenting complete analysis in Defect Status reports, resolving requirement and design inconsistencies.
• Experience in Kernel mode Debugging using KD connections at remote server and WinDbg.
• Worked in Confidential Windows testing technologies tool (WTT) for automation testing of XboxOne Console build verification.
• Extensively used Test Foundation Server (TFS) like creating TFS Bug, Task & User Story workflow templates.
• Used Apache JMeter for Load/Stress testing of the web application.
• Used different tools and Plugins to perform Accessibility testing based on the Confidential Accessibility standards and WCAG 2.0.
• Performed Security testing using HP WebInspect 5.0 to identify Security Vulnerabilities / threats in the website.
• Testing web applications work uniformly across multiple regions and cultures as part of Internationalization testing.
• Extensively experienced in Banking, Health Care, CMS domain based testing. Worked in both service and product based projects.
• Very good knowledge of overall mortgage lending processes and experience in HAMP program.
• Involved in preparation of Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.

TECHNICAL SKILLS:

Database & Language: SQL, Oracle 9i, 10g, SQL Server 2014

Test management: HP QC 10.0, Confidential Test Manager, Visual Studio TFS, JIRA

Operating System: Windows

Web Testing: HTML, CSS, Developer tools

Performance & Security: JMeter, Confidential WAS, FireBug, Chrome Page Load, HttpWatch, Fiddler, IE developer tool, HP WebInspect 5.0, SOAP UI

Accessibility: WAT, MAS, Narrator, WCAG 2.0 testing, GAT, KEROS, Contrast Analyzer

Domain: Banking and Financial Services, Healthcare Insurance, Confidential Xbox, Communications, Web Development

Concepts: Manual/Automation Testing, ETL / DW, Accessibility, Security, Performance testing

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QA Consultant

Roles & Responsibilities:

• Involved in requirement gathering, understanding the designs / wireframes / mock-ups with both Business and Design team. Closely work with Dev and production team to understand the web implementation and content publishing.
• Creating Test Plan for the project and getting sign off from the Business and Design team before sprint starts.
• Involved in creating test data and environment setup for testing the module in different phases.
• Forecasting/Estimation/ResourceManagement-Allocation/Onshore-Offshore Team management on a daily basis for the project.
• Creating Monthly Report on Bug trend using Power BI Dashboard for better visualization and Corrective/Preventive actions.
• Data retrieve and analyze from the TFS warehouse using SQL and creating reports using Confidential Power BI.
• Responsible for triaging with proper root cause and assigned to Dev team for fixing.
• Experience in prioritizing automating regression scripts and execution in the SIT phase.
• Prioritizing testing efforts for the team and working on test deliverables for each sprint release. Tracking test results and testing progress in Confidential Test Manager Tool (MTM).
• Security testing for devices sites using HP WebInspect tool to make sure there are no possible threats or leaks to the site.
• UI testing with CSS, HTML5, Java script and Angular.js frameworks.
• Creating TFS Bug, Task, User story workflow template and implement the process in the project.
• Load/Stress and Performance testing of the web application using Apache JMeter.
• As per Confidential accessibility Standards, involved doing accessibility testing for all the devices sites using various accessibility tools and Browser plugins.
• Involved in the website testing in multiple browsers, Devices including Mobiles and Tablets for Windows/Andriod / iOS.
• Content Publishing and managing for Website using CMS tool Compass.
• Testing to check if the site is locale aware (globalization) and testing the localized versions of the site to satisfy Internationalization testing.
• Tagging Keywords, Meta description in the HTML page and A/B testing.
• Identified risks and called out the same on the daily stand up meeting
• Working with Offshore team, assigning testing responsibilities and follow-up till test competition. Also reporting the status to Project Manager and updating the weekly reports.

Senior quality Assurance Engineer

Roles & Responsibilities:

• Interacted with Business System Analysts and SMEs to understand the requirement and business flows. Analyzed the Gaps between requirement document detail technical design documents.
• Involved in reviewing test scenarios, test cases and test results for the vended application.
• Handled end to end test process to deliver first release through various DW provision points and performed high Quality Analysis in design/Code/Tracking.
• Took ownership in building process/methodology for Test data creation which was well accepted by client.
• Experience of file level validation with Flat/COBOL/CSV files.
• Considered all the requirements & creation test data all relationship tables for data marts which are resulted high complex data structure for testing process.
• Executed automate test scripts to validate integrated data, to validate the legacy data in created ETL applications, to validate data reconciliation in integrated ETL applications and ETL data in an end to end DWH systems
• Writing Unix commands for Batch file processing in the Linux servers.
• Involved in all SIT activities, played a key role in the team in handling critical issues
• Delivered the test cases & automate test scripts to customer which are used for all conversions.
• Worked with automate test case & test scripts to validate Error handling & transaction data from various source systems transformed to DW applications.
• Handled data quality check as part of business requirement for all DW provision points.
• Implemented DW test methodology & test techniques to ensure all the source systems data flow is as per model.
• Responsible for Creation and maintenance of HP Quality Center 11.0 repository, Creation and Customization of QC Projects.
• Responsible for all test deliveries to the customer.
• Identified risks and called out the same on the daily stand up meeting.
• Preparing Weekly status report to keep track on the present/Future task items.

Sr. Test Analyst

Roles & Responsibilities:

• Involved in reviewing BRD/FSD specs, preparing Test scenarios/test cases, executing Tests and Preparing Test results for Xbox One console Project.
• Used to work with both Business and Development team on review of Functional Specs. Make sure all the Priority issues has been reported, accepted and fixed by Dev team.
• Automation test execution and failure analysis using Xbox Test Pass tool.
• Have responsibility to triage all most all the failures with proper root cause and assigned to Dev team for fixing. Used to provide Debug sessions to Dev team to avoid No Repro situation.
• Experience in automating regression scripts and execution in the SIT phase.
• Prioritizing testing efforts for the team and working on test deliverables for each sprint release.
• Used to monitor all Boot/BVT/IVT/RBVT and FVTs test Pass, Re-run the tests and reporting each failure to triage team.
• Identified risks and called out the same on the daily stand up meeting
• Working with Offshore team, assigning testing responsibilities and follow-up till test competition. Also reporting the status to Project Manager and updating the weekly reports.
• Tracking all Xbox bugs using TFS. Maintains Proper Bug Life cycle for each sprint released.
• Helping team by providing Automation testing solution during test case preparation or execution in WTT.
• Validating/Reviewing Power shell Scripts for creating workflow.
• Reviewing and maintaining SQL queries for database testing work items.
• BVT testing for all the development branches and finally RI to main branch.
• Patch update for all Kernel debugger and XTP server on monthly basis.
• Maintaining all the documents and test procedures in OneNote.
• Prepare two reports every day. Morning AM report used to have all the bugs created for RI branches. Final report used to have bugs for all the branches identified for the day.

Sr. Test Analyst

Roles & Responsibilities:

• Analyze the Mortgage Loan modification flow from Fannie and Freddie mac quarterly basis and prepare the test cases to accommodate the loan modification required for Chase HAMP .
• Testing CHAMP workflow to adjust the default Loan modification.
• Working on implementation of automation testing approach with SQL queries to complete the QA phase in time.
• Created and executed SQL queries to perform source to target testing on Oracle database.
• Compare data for all columns between source and target to report mismatch data.
• Created positive & negative test scenarios for each module.
• Verify ETL application correctly rejects and substitutes default values.
• Data completeness test to verify all expected data loads into data warehouse.
• Used JIRA for issue management and Features tracking.
• Performed testing for the business rules thus generated through Informatica tool in an AGILE environment.
• Reviewed the Application Profile Document with the business and development team to understand the architecture and functionality of the application.
• Actively involved in the Direct Capture of Objective (DCO) meetings where I had interacted with the Application development team and Business analysts for requirement understanding.
• Synthesized the Visio-business workflows into different test scenarios and confirmed the same with the BA for maximum requirement coverage.
• Executed the test scripts on different releases and validated the actual results against the expected results.
• Responsible for Creation and maintenance of HP Quality Center 10.0 repository, Creation and Customization of QC Projects.
• Extensively used TOAD - database tool for the Data Validation.
• Working and communicating with programmers, project managers, and application rollout groups in order to set and meet quality standards and deadlines.

Test Analyst

Roles & Responsibilities:

• Involved in Test Plan development and review for Informa S&M project.
• Created test scenarios from the use cases and functional requirement specifications.
• Involved in preparing Regression test cases based on the tickets raised in Quality Center for Health Care integration modules.
• Worked in Java based J2EE applications testing.
• Involved in detecting bugs in the system and creating the Defects in Bugzilla and Quality Center.
• Testing of a system to verify that modifications have not caused unintended effects by implementing Regression Tests for every modified build.
• Used SQL query to validate data is correctly appearing in both Front-end and back-end.
• XML validation and worked through WINSCP interface.
• Checking the logs in Omniture for page navigation in the application.
• Managing the users as IP authenticated or Non-IP using AMS site for all the Pharma publications.
• Involved in browser compatibility testing of the application in different versions of I.E. & Mozilla Firefox.
• Leading the team and interacting with the client through Email and Con-call.
• Tracking the test result and submitting to client at the end of each release.

Test Analyst

Roles & Responsibilities:

• Creating test scenarios from product backlog items and Functional requirement spec.
• Involved in preparing Regression and System test cases and executing them manually.
• Involved in detecting bugs in the system and creating the Defects in TFS (Team Foundation Server).
• Have done Smoke testing of the build to accept for further testing.
• Testing of a system to verify that modifications have not caused unintended effects by implementing Regression Tests for every modified build.
• Involved in End to end/System testing which includes generating events through Camera and verifying generated events in the web application and Database.
• Participating SCRUM meetings and updating testing development status in daily basis.
• Involved in Database testing using SQL queries for backend checking of the application.
• Involved in browser compatibility testing of the application in different versions of I.E. using IE tester.
• Involved in Performance testing of the application using WAS (Web Application Stress tool).
• Used Fiddler to inspect all HTTP(S) traffic for the application.
• Tracking the test result and submitting to client at the end of each release.
• Preparing weekly status report to keep track on the working action items.