PROFESSIONAL SUMMARY:

• 10+ years of Experience in Software Testing and automation Testing and Functional Testing on Web based applications, Database, Banking, Financials, Payroll and Telecommunication domain.
• Involved in various testing phases like Functional testing, System Testing, End to
• End, Integration Testing, Regression Testing, Smoke Testing, UAT Support, Performance Testing and ETL testing on Big Data.
• Excellent understanding of the Software Development Lifecycle (SDLC) and Software Test Life Cycle.
• Good understanding and experience on Trading, derivatives, trade life cycle and Bloomberg.
• Performed analyses on Business Requirements and specifications, provided Estimation, developed Test strategy, Test plan, Test cases, Test execution, Test tracking, Review and Reporting on Complex projects.
• Skilled in gathering Requirements from End Users, Scope Documents, and Business Specifications.
• Good Expertise in writing Complex SQL queries to validate and analyze results of application functionality.
• Knowledge on automated testing using Selenium with Java and TestNG framework, Maven and Jenkins.
• Knowledge on Batch Testing, Data Driven Testing, Cross Browser Testing and Database Testing.
• Actively participated in strategic planning and process improvement initiatives.
• Co - ordination with delivery management and developers, UAT Support, Knowledge
• Sharing, Team building and mentor.
• Experienced in working on Data migrations and Data testing engagements.
• Bug reporting, creating and customizing, reporting, and Defect Tracking.
• Lead effectively in estimation, planning, cost of quality (ROM costs), and quality risk analysis and mitigations related to project scope and QA tasks.
• Worked under strict deadlines as an active team member, Team leader.
• Collaborated with Development and Operations team to successfully implement the applications up and running.
• Worked in Agile and Waterfall environment as Independent QA and Team player.
• Excellent communication, presentation, analytical, interpersonal capabilities and problem solving skills.
• Successful in delivering Project on time by fulfilling customer’s business expectations within the stipulated budget and timelines.
• Worked with Offshore and On-shore Teams, providing guidance, and conducting meetings.
• Participated in contributing to the systems by expanding domain knowledge on the job through courses.

TECHNICAL EXPERIENCE:

Operating System: Windows 2000/XP/7/10, UNIX, Linux

Database Systems: SQL Management server 2012, 2017, Hive

Testing Tools: HP Quality Center 11.0, HP-ALM, Selenium (IDE, Web driver)HUE Editor, Power-Pivot.

Build Tools: TestNG, ANT, Maven, Junit, Jenkins

Bug Reporting Tool: JIRA, Test Director 7.2, Team Foundation Server, IBM Rational

Clear Quest, Rally.:

Web Technologies: HTML, XML, JavaScript.

Documentation: MS-Office (Outlook, Word, Excel, PowerPoint), SharePointGoogle Drive.

PROFESSIONAL EXPERIENCE:

Confidential

Testing Consultant

Responsibilities:

• Tested data integration from various sources to create a flat wide deep Enterprise data lake.
• Validated data content and record count loading from various databases to AWS (Zone 2) and from AWS (Zone 2) to CIDM (Zone 3) (Canadian Integrated Data Model).
• Created Test plan and Test results.
• Built Data models for testing by leveraging Power-Pivot features in excel based on the Technical Data mapping and Detailed Level Design.
• Compared the data in the Source and Target tables and apply various aggregate measures (i.e. sum, average, count, distinct count, max, and min) on all the fields of the Source and Target tables.
• Querying Data Lake Database in Hive using Hue Editor Tool.

Environment: Data Lake, HIVE, AWS, EMR, GLUE

Confidential

Sr. QA Analyst / Lead

Responsibilities:

• Lead the team, performed End to End activities, provided and guidance to both off-shore and on-shore team.
• Participated in creating functional and technical requirements meetings, requirements gathering, analysis and design with the Product Owner, business analysts and developers.
• Created Test plan/Strategy, test scripts, test cases and Traceability matrix.
• Worked extensively with Line of Business and User Acceptance testing resources to cover total functionality for System Integration testing, including end to end and regression testing.
• Worked with Product Owner and Business analyst to understand the business domain, analyze business processes, procedures and to map them into requirements.
• Analyzed raw data, reports from Data processing team to convert them into requirements and test cases.
• Provided feedback on the design constraints during scrum meetings and worked with team to fix complex design issues.
• Tested and verified all Line of Business (DI, PA, PIA, FP) for Principal Protected notes.
• Performed backend Data testing in SQL DB by creating complex SQL query and executing stored procedures in SQL
• Performed testing on IBM bookkeeping H64 / T83.
• Created SQL automation scripts to extract Data and apply rules for regression testing.
• Tested SSIS packages to load data and SSRS for generating reports.
• Created Test plan, Scenarios and test data for User Acceptance testing environments.
• Provided metrics and measurements to the manager.
• Identified and documented defects/system issues using JIRA, and assisted of root cause analysis for timely resolution of defects.
• Involved during warranty period, provide support to Operations team, investigate into production issues, provide resolution and help in preparing documents to the End Users.
• Configured to Schedule and run Batch jobs in Autosys.
• Worked with Developers to perform API testing, with Operations and Business team in PAT environments.

Environment: Java 8, Java Batch, Linux RHEL, MS SQL Server 2012, 2017, Jenkins.

QA Test Lead

Confidential

Responsibilities:

• Provide Specialist advice, feedback and guidance with regards to Quality Assurance best practices and industry standards.
• Analyze and review system features and requirements (i.e. functional, integration, security, and performance)
• Identify testing Risks upfront and track them to closure.
• Develop Test Strategies, Test Plans, and Test scenarios, conduct review with Business and IT for completeness.
• Document Test cases with expected results.
• Planning for appropriate level of white box, black box and user based testing in order to ensure sufficient coverage.
• Coordinate and Setup test environment with Technical teams.
• Alignment of data and configuration between test elements.
• Coordinating refresh of data and configuration in order to have environment ready for all test phases.
• Coordinate Data migration meetings, planning and testing.
• Coordinate and execute integration, system and end user quality assurance testing to ensure projects meet organizational standards and end-user requirements.
• Follow up with developers across multiple teams to troubleshoot and resolve defects.
• Work with development teams to identify re-testing required for fix applied.
• Track number of bugs opened/resolved/closed and report to the Project manager.
• Planning Regression testing and execution appropriately.
• Track test execution and notify management in advance when milestone dates are in jeopardy.
• Identify ROM costs, Risks and mitigations.
• Responsible for UAT readiness, and support during execution.
• Support production rollout and Build verification Testing.

Environment: Asset Management System, Customer analysis and Reporting solution(CARS), Service management platform, APIT, CSIL, Oracle, RDBMS 10.2, Microsoft SQL Server 2008, IBM AIX 5L 5.3, Microsoft Windows server 2003, UNIX Sun Solaris, AJAX, Java, Java Servlet, XML-RPC, PHP, SOAP, Life Ray portal.

Confidential

Quality Assurance Engineer

Responsibilities:

• Worked as an independent QA and as a Team player in agile and waterfall environments.
• Managed complex end-to-end Data migration and Analysis.
• Lead the team by provided, direction, planning and guidance for 5 QAs.
• Prepared Test Strategy, test plan, test scenarios for integration, functional and end to end, test cases, PDV and Sign off documents.
• Created Selenium scripts for converting QTP automation scripts.
• Co-ordinate and communicate with different teams, understand the requirements, Identify gaps, prepare test data and process setup.
• Quickly mastered complex features, various new applications.
• Took Responsibility from beginning of the environment setup till delivery of the product to production on time.
• Worked on critical part of the project which involves payroll generation
• Facilitating meetings, taking ownership and responsibility to make sure we are on target and coordinating with other team members and lead.
• Worked with developers for the defects reported to be resolved and helping to understand the scenarios.
• Involved in testing Integration of applications, system testing, and verification in Pre-Production.
• During Year end process, worked with off shore team to have the fixes go on time before end of the year.
• Coordinated with Business analyst and developers to design scenarios.
• Provide QA estimation, planning the execution procedure.
• Work with Offshore and On-shore team.

Environment: Web based application, Windows 7, IE 11, C#, SQL, HP Quality Center, Rally, QTP, Agile, OD DB2, OD server, ODWEK, TSM, Xenon.

Confidential

QA Analyst

Responsibilities:

• Developed and executed test plans, test cases, and test scripts to ensure that software meets company standards and requirements
• Run regression tests on every build
• Developed test strategy document, which includes results summaries, known issues document, open defects, pending defects, fixed defects and closed defects.
• Assist other members of the QA team in testing new releases of the product as required and lead the team.
• Perform all aspects of verification, including functional, structural, regression, load, User interface and system testing
• Provide detailed reports on the results of test runs
• Collaborated with the development team to ensure that fixes for defects are included into product builds and releases
• Proposed innovative solutions to problems discovered during testing
• Maintenance and administration of production, office system environment, client surveys, reporting and ping scripts.
• Backend testing by running SQL queries.
• Conducted deploying, setting up the config files for QA environment, trained the team, providing reports on day to day basis as a team to the manager.
• Conducted Performance/Load testing, analyzed the results.

Environment: Web base application, Windows XP, C#, ASP .Net, SQL server, XML, JavaScript

Confidential

QA Analyst

Responsibilities:

• Maintaining and updating regression Test cases for enhancements
• Defect reporting, verifying the defects and reports generation.
• Tracking of defects and Defect management using Mercury Quality center.
• Communicating the testing status to peers and senior management.
• Performed integration and Regression testing.
• Preparing the daily status report