Objective

• Versatile and quality - minded QA lead with Over 11 Years of IT experience, primarily focused on Data Migration / DW Migration & total quality management for a dynamic organization in helping to streamline its business processes and realize growth objectives and thereby providing significant cost benefits.

SUMMARY

• Proficient and technical expertise in quality assurance software testing through architecture analysis, process management, root cause and risk analysis, post - production testing, and assuring quality services to achieve efficiency and maximum customer satisfaction.
• Distinct consulting skills in Business Analysis, Requirement and Gap Analysis, Risk Analysis, Quality Assurance, Quality Control, QA Guidelines and QA Processes which are in line with the Industry Standard Best Practices.
• Proficient in Data Integration, Data Migration, ETL, Data Cleansing, Data Quality, software testing.
• Experienced in gathering business requirements under the umbrella of Data Integration, Data Migration, ETL, Data Cleansing, Data Governance and Multi-System Data Source Integration.
• Experienced in all phases of software development life cycle (SDLC), including requirements gathering and documentation, use casing, functional specification, business case analysis, Data warehouse, Quality Assurance and testing.
• Proficient in all aspects of the Software testing Full Life Cycle (reviews, inspections, System Test, User Acceptance Test, Interface Testing, Usability Testing etc.
• Proficient in Data Analysis, Database Testing, Data Manipulation, Data Mapping and Data Integrity
• Distinct consulting skills in Business Analysis, Requirement and Gap Analysis, Risk Analysis, Quality Assurance, Quality Control, QA Guidelines and QA Processes which are in line with the Industry standard Best Practices.
• Experienced in interacting with business users and executives to identify information needs, gather requirements, and reviewing and authorizing Business Requirement Documents (BRD)
• Good knowledge and experience in Stored Procedures, Functions, Cursors, triggers and Dynamic SQL

Core Competencies

• UI/Web based application testing
• Data warehouse testing/reporting
• Application management/solution architecture
• SDLC & STLC Lifecycle management
• Defect Management
• Team Management
• Project Management & Execution

TECHNICAL SKILLS

Methodologies: Rational Unified Process (RUP), Waterfall, Agile, Scrum, FDD

Platforms: UNIX (Sun/HP/AIX), Windows (7/XP/NT/2000)

Database: Oracle, DB2, Teradata

Reporting / Scheduling Tools: Cognos, Microstrategy, Control M

ETL / Testing Tools: Informatica, ALM, WinRunner, OpenSTA

PROFESSIONAL EXPERIENCE

Confidential, Smithfield, RI

QA Lead (Rx Pharmacy Data warehouse)

Responsibilities:

• Project Planning activities, Resource Planning, estimating level of effort (LOE) and communicate with the Business User, PM’s, Offshore Manager, Onsite Managers and Stakeholders in the project
• Hands on experience in Data warehouse Migration project (Teradata to Hadoop (Bigdata))
• Actively engaged and led QA Activity for Target to CVS migration (over 30 new feeds migrated from Target to CVS DW)
• Actively engaged and led QA activity for Omnicare to CVS migration (Over 1200 Tables, 8 Schema, 49 Application migrated from Omnicare to CVS DW)
• Leading all QA activities in ADS to Exadata migration project (Oracle to Exadata)
• Onsite execution lead coordinating test execution activities for SIT, UAT, E2E testing, P2P Testing.
• Analyzed the requirement and proposed the test strategy.
• Responsible for the quality center workflows changes and communicate to all participants
• Utilizes analysis to collaborate with team of users, analysts and consultants to determine solutions and required configurations to meet program requirements
• Directs the activities of the QA team members to ensure quality and timeliness of QA project completion
• Actively participated and coordinated Disaster recovery validation.
• Product DW testing of inbound and outbound interfaces between Heritage systems and Core RxDW interfaces (including System Testing, Integration Testing, Regression Testing, Micro Strategy Testing, User Acceptance Testing support).
• Enhanced/Assistant Project process & QA process (Defect management & Prevention, static testing, etc.).
• Provided the high quality Assurant during the whole software life cycle

Confidential, BOSTON, MA

Lead QA Analyst

Responsibilities:

• Complete ownership and responsibility for the maintenance and improvement of existing product test suites and monitoring day to day functions of the testing activities of Warehouse Management Systems (WMS), mobile applications/devices, and website
• Analyze, design, and document accurate test plans, traceability matrix, test tracking documentation and deliver well-tested, high quality production applications
• Estimate the testing effort by analyzing the requirements of project and obtain management support for the time, resources and budget required to perform the testing
• Review all requirements and specifications documentation for clarity, completeness and testability
• Prepare / update the metrics dashboard at the end of a phase or at the completion of project using HP Quality Center
• Led as primary POC for UAT testing on SR1,SR2 and SR3 projects
• Worked with BA's, PM's and QA contacts and coordinated all UAT testing tasks
• Sent Daily Status Reports, coordinated environment/data set up
• As a Defect manager, monitored and managed all defect logging, defect assignment, status appropriations including resolution and release timelines
• Created UAT test plans and test schedules after inputs from the team. Presented the same to the management and followed up until approval
• Managed and moved resources accordingly to handle any slippages to meet release timelines
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization
• Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the stakeholders
• Attend the regular status call and discuss the weekly status with the stakeholders
• Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc
• Defining and implementing the role testing plays within the organizational structure.
• Defining the scope of testing within the context of each release / delivery.
• Deploying and managing the appropriate testing framework to meet the testing mandate
• Performed manual testing of backend GENESYS (Warehouse Management System - WMS) to condition the test data for (Inventory/Product Swatch/Shipping Details/Promo Information)
• Validate the inventory availability details in the backend GENESYS screens and compare the product availability on the UI on the webpage
• Manipulate data in the GENSYS screens to validate the orders fulfillment process and validate trigger emails
• Create and baseline test sets for execution before testing cycle in Quality Center(V10)
• Align test sets and folders to release cycle and monitor and report the status to the project management Quality Center
• Review test cases in HP QC 10 for completeness, requirement traceability and test case standards
• Coordinate testing activities including the creation and/or use of test scripts and testing environments and execution of scripts
• Provided QA Support (Baseline, Regression and Integration Testing) for daily site enhancements and promotional campaigning
• Provide Testing Status on a daily basis while testing is underway and gather metrics and report to the appropriate audience/level
• Validate the Lowes website functionality on the mobile devices

Confidential

QA Analyst

Responsibilities:

• Develop, implement, communicate and maintain a quality plan to bring the Company’s Quality Systems and Policies into compliance with quality system requirements
• Oversee QA workload, assigning projects and tasks to team to meet the needs of product schedules
• Analyze current project standards, to research external methods and combine them with the experience of QA standards to further the PMO’s role as guardian of client interests.
• Conducting Risk Analysis, Regression Analysis, Impact Analysis and Implementing mitigation techniques
• Preparing Status Reports and participating weekly Triage and Review meetings for understanding the complexity of the application modules
• Create and baseline test sets for execution before testing cycle in HP Quality Center(V9, V10 & ALM)
• Align test sets and folders to release cycle and monitor and report the status to the project management Quality Center (V9,V10 & ALM)
• Prepare customized excel or dashboard reports in ALM showing the Execution progress or defects trend
• Assigned tasks, monitored progress and collected reports for offshore/onsite associates
• Provide overall test plan, tasks, schedules for UAT team
• Acted as a SME / POC on multiple projects providing updates and clarifications
• Gathered inputs from QA team regarding test data requirements and provided test data or assigned resources to do so

Confidential

Senior QA

Responsibilities:

• Involved in Creation of Test Scripts analyzing Requirements Documents.
• Responsible for writing test cases as per the test plan
• Involved in functional and regression Testing
• Experience in testing sample record sets for consistency, data corruption and over all data quality
• Experience in agile environment and familiarized with the AGILE terminology such as Iterations, Sprint Review, Backlog (User Stories), Acceptance Criteria, Story Check-ins.
• Implemented Automation framework for both the products and automated a regression test cases.
• Experience in performance testing using open source tool OpenSTA

Environment: HP Quality Center 13.0, Control M, Oracle 11g, Exadata, Micro strategy, UNIX, Microsoft Office, Windows 7, Informatica 9.5.2.1, Teradata 15, Hadoop