SUMMARY:

• Proactive and self - directed Quality Assurance Analyst with comprehensive 20+ years of experience in major technology solutions with expertise in Data analysis both in Waterfall and Agile methodology along with onsite/offshore team management, hands-on E2E System and Integration testing.
• Elicit requirements using interviews, document analysis, requirements workshops, competitive product analysis, business process descriptions, storyboards, creation of Wire-frames, surveys, task and workflow analysis.
• Effectively communicate to the business customers and the technical team after analyzing existing anomalies in the current systems/process and recommends solutions.
• Responsible for all aspect of QA (Test plan, test case, test execution, project planning)
• Collaborated with cross-functional teams such as Developers, SMEs, QA team members and Business stakeholders.
• Liaison between business and technical teams to articulate needs, issues and concerns
• Solid cognition in creating business requirements from cross-organizational stakeholders to document project scope and functional needs, crafting User Stories, devising test plan and assembling training materials
• Excellent interpersonal and communication skills, technically competent and detail-oriented with problem solving skills and ability to work independently.
• Data Analysis/ Data Manipulation /Data Validation /Data mapping /Data Dictionary /Data Integration.
• Coordinated end-to-end testing with users to ensure accurate data flow and make sure test scripts were traceable to the requirements.
• Responsible for Smoke (Sanity) Testing, Functionality Testing, Ad Hoc Testing, Regression Testing and End-to-End System testing using SOUP-UI API and Selenium.
• Expert in preparing Test Strategy, Test Cases and its execution and the entire systems testing through various ETL tools, like, Informatica, DataStage, Ab-Initio etc. in addition to UAT (User Acceptance Test) and Production support.
• Adept Confidential preparing of Test Strategy, Test Cases, UAT support and test execution of ETL tools, like, Informatica, DataStage, Ab-Initio and BI Reporting applications, like, Business Objects, Cognos.
• Forecast and tracked test schedule, test lab environment configuration and Test execution.
• Test the whole application in a staging area which mimicked the production
• Organize and facilitate Agile and Scrum meetings that include Sprint Planning and Review, daily stand-ups with a team of business representatives, software developers, and testing team-member to create snapshots of project velocity.
• Update Test drive Client tool, QC and Metrics report.
• Test both primary application and Web base application.
• Ability to write / debug and execute PL/SQL queries for Oracle and SQL Server also running basic UNIX commands and writing shell scripts.
• Compare the Real time process flow between primary application and Web based application
• Generate business requirements through interviews, prepare Business case and Business Requirement Document (BRD) with the interaction of User Interface (UI) and User Experience (UX). Facilitates JAD sessions with System Architect, SMEs, Business stakeholders, Developers and QA team members to generate comprehensive requirement documents.
• Organize and facilitate Agile and Scrum meetings that include Sprint Planning and Review, daily stand-ups with a team of business representatives, software developers, and testing team-member to create snapshots of project velocity.
• Analyzed software anomalies, provide clear and concise defect reports and follow defect tracking practices based on internal QA standards and processes and circulates among all the Project members and higher management.

TECHNICAL SKILLS:

Applications: MS Visio, Excel, Power Point, Guidewire, SQL, TOAD, Rational Requisite Pro.

Databases: MS SQL Server, ORACLE 11g, DB2, SYBASE, MS Access

Data warehouse ETL Tools: Informatica, DataStage

Business Intelligence Tools: Business Objects, QlikView, Tableau, MicroStrategy, Cognos 9.5 and

Languages Acquainted: PL/SQL, XML, Java, ASP.NET, .Net Framework, C/C++, HTML, UNIX Shell

Error Tracking Systems: JIRA, Rally, HP ALM Quality Center, Team Track, Rational Quality Manager, Clear Quest

SOAP: UI API, Selenium, Load Runner, WinRunner, Test Director, QTP

PROFESSIONAL EXPERIENCE:

Lead Tester

Confidential, Teaneck, NJ

Responsibilities:

• Generated Test Plan, Test Scripts, Test Summary Report, Traceability Matrix as per the Customer Requirement document and thoroughly testing of the application in terms of functional, Load testing, Performance and Stress testing.
• Collaboratively exercised with developments team to ensure data specifications are understood, followed and supported.
• Quality Assurance and User Acceptance Testing (UAT) during design and implementation of major enhancements.
• Responsible for testing within the Quality Assurance testing cycle: Smoke (Sanity) Testing, Functionality Testing, Ad Hoc Testing, Regression Testing and End-to-End System testing on software applications.
• Generated business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.

Sr Quality Analyst and Business Analyst

Confidential, Piscataway, NJ

Responsibilities:

• Working on ordering workflow to provide End to End transparency to client and improve the functionality of system by introducing automation tasks in workflow in ticketing system.
• Assist in triage of application Incidents. Provide timely updates and feedback to incident originator. Manage inquiry/incident through life cycle of issue.
• Work with development team and vendors to implement fixes and software upgrades to the application platforms.
• Organized Scrum of scrums to scale the daily stand-up meeting with multiple teams to support various agile teams in collaborating and coordinating their activities with other teams
• Responsible for creating Test Plan, Test Cases, Traceability Matrix for the existing Business/Functional requirement docs.
• Perform ST/JST/UAT and support end-to-end testing.
• Perform complex SQL quires by joining many different tables with primary key fields to verify data and also verify new fields created in DB table and perform Manual execution on Stored Procedure to check data consistency in database.
• Solid cognition in creating business requirements from cross-organizational stakeholders to document project scope and functional needs, crafting User Stories, devising test plan and assembling training materials.
• Attended JAD session and wrote Business Requirement Document.
• Organized Scrum of scrums to scale the daily stand-up meeting with multiple teams to support various agile teams in collaborating and coordinating their activities with other teams
• Responsible for creating Test Plan, Test Cases, Traceability Matrix for the existing Business/Functional requirement docs.
• Perform ST/JST/UAT and support end-to-end testing.
• Executed and wrote SQL statements to make sure the successful transaction of data from front-end to back-end database.
• Created and delivered daily QA performance and defect reports to Senior Project Management.
• Inventory data creation for IST/UAT/ETE test teams. Using FMO/PMO/HALO flow to create quality data for test teams to execute change orders.
• Verify the sanity of inventory to make sure it is built according to the data requested by user and they are able to perform their testing.
• Developed detailed documentation, including test plans, test scripts, test summary report and traceability matrices and UAT Test Plan pertaining to the execution of testing methodologies.
• Responsible for Smoke (Sanity) Testing, Functionality Testing, Ad Hoc Testing, Regression Testing and End-to-End System testing using SOUP-UI API and Selenium.

System Tester / Production Support SME

Confidential, Middletown, NJ

Responsibilities:

• Wrote process documents for UAT/JST team to help them set up data in all related systems to mimic production
• Worked as Production Support Lead to train new members and also present daily and weekly production ticket status to upper management in project meetings
• Worked with the USRP/GIOM Production Support team to resolve production issues and tickets.
• Updated weekly project meeting with viewgraph the number of Production Ticket closed and pending.
• Trained new team members in production support, to understand the flow through and how to resolve issues and who to contact in Developer and Systems Engineering team.
• Perform end-to-end system software application testing, including software release schedule, management, testing, installation/ deployment, production support to the end user groups, distribution of work assignments to the team members, setting up System Test environment & sanity check, installation and configuration of system testing.
• Collaborated with Business Users, System Engineers, Business Analysts, Development and QA team along with Key stake holders for successful delivery of system enhancements, integration.
• Conducting pre and post release Reviews to ensure Total Quality Management.
• SME in end-to-end Networking Sales Order Management Systems, Service Automation, service feature interactions, customer configurations, load, performance, security and stability following structured software quality assurance processes.
• Contributed in firm wide One Process and One Platform initiative and its implementations.
• Performed Sanity testing once the code was received.
• Forecasted and tracked test schedule, test lab environment configuration and Test execution.
• Tested the whole application in a staging area which mimicked the production.
• Configure test environment including SUN/PC hardware, UNIX/NT software
• Set up a new regression test set out of the old one in the Test Director database.
• Creating defects and follow up by attending defect review board meeting with release coordinator and developer.
• Trained User on new release features and helped them get the correct test environment for UCT/UAT and Sanity testing.
• Trained new team member for End-to-End testing.
• Formulated Data Dictionary from the existing SQL Script through the process of reverse engineering, managing integration with existing systems, including Data mapping, data feed analysis and data schema changes.
• Performed data mapping among various source systems, transformation of data to meet internal system requirements.
• Developed complex SQL queries for querying data against different databases for data verification process.
• Engaged with developers to ensure data specifications are understood and followed and supporting quality assurance and user acceptance testing.
• Analyzed the data, understood the data, standardized the data and documented the lineage of data across the Enterprise.
• Generated Test Plan, Test Scripts, Test Summary Report, Traceability Matrix as per the Customer Requirement document and thoroughly testing of the application in terms of functional, Load testing, Performance and Stress testing.
• Collaboratively exercised with developments team to ensure data specifications are understood, followed and supported.
• Quality Assurance and User Acceptance Testing (UAT) during design and implementation of major enhancements.
• Performed all levels of Data Warehousing testing within an ETL Architecture/process: extraction and conversion of data from external sources and transformation of data to meet internal system requirements, and loading into EDW.
• Involved in defining source to target data mappings, matching of Custom to Standard field elements and data definitions.
• Used Load Testing software, Load Runner to Load testing, Performance and Stress testing.