PROFESSIONAL SUMMARY:

• Experience in Quality assurance, Data analysis within fortune 100 companies in domains ranging financial, insurance, healthcare, airlines and IT consulting.
• Substantial expertise in quality assurance and data analysis with testing background in integration, volume, system, regression, backend data warehousing, ETL, functional/manual testing. +
• Experienced in preparing Test Strategy , developing Test Plan, Detailed Test Cases , writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Proven records of working collaboratively across all organizational levels for deliverables and solve problems effectively. Strong hands - on experience in Agile, Iterative, Waterfall and RUP methodologies. Seeking a Quality Assurance Analyst position within a challenging environment.

TECHNICAL SKILLS:

Software: ORACLE RDBMS (SQL * Plus), Teradata (12.0), TOAD, MS query analyzer, AQT (Advance query tool), RALLY, SharePoint, MS Office 2013 (Word, Excel, Access, Power Point), MS Outlook.

Automated Testing Tool: SQA Suite Team Test Edition, Mercury Win Runner (8.0), Test Director, HP Quality Center (10.0) and ALM 12.01

Testing Methodologies Used: Agile Methodology, Data Warehouse testing, GUI Functionality Testing, Integration testing, Transaction testing and Regression testing

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Quality Assurance Consultant

• Conducted team meetings related to test strategy execution methods, wrote test plans, test scenarios and scripts per use-case or user-stories.
• Reviewed test plan and test inventories with the business and BA/QA team for approval
• Performed hands-on system, functional, GUI testing, log defects as identified and regression test
• Lead projects to provide estimation of the assigned requirements
• Worked with change management to add or remove requirements scope as needed
• Provided test execution reports to the key stakeholders and update repository frequently
• Attend all meetings with the client and update them on all BA/QA activities

Confidential, Westport, Connecticut

Sr. Data Analyst

• Involved in different functional areas like Accounting, Client Reporting and Insulation Layer
• Participated in Client Reporting business requirements and perform end to end testing
• Validated data from Eagle future state reports to BPAS current state reports
• Written SQL queries to validate reports against the database
• Verified Eagle reports are following the Style Sheet guidelines approved by Bridgewater
• Wrote test cases and executed them from ALM (application life cycle) tool
• Used SQL query to validate backend data from stage to target database
• Written Test Cases to compare Source and Target database systems
• Identified issues and logged defects and re-tested them when fixes were completed
• Mentored and trained junior testers and worked with offshore/onshore team

Confidential, Marlborough, Massachusetts

Sr. Quality Assurance Analyst

• Reviewed functional requirements and technical design documents with the business analysts, developers and Project leads; collaborated in revising requirements and technical specifications.
• Created test plan, test cases and test scripts for various tables for initial and incremental load in stage and target tables. These are all marketing related data coming as flat files to the source
• Reviewed functional requirements and technical design documents to write test case document
• Created SQL scripts and executed them in SQL assistance using Teradata
• Developed test scripts based on technical specifications/Data design documents
• Reported bugs to developers through Zira and re-tested them when they were fixed

Confidential, New Hampshire/Smithfield Rhode Island

Sr. QA Engineer

• Verified data movement from source to stage and stage to target tables using TOAD and AQT (Advance Query Tool) for various data warehousing projects
• Created test cases from business requirement, technical design document and data mapping. Reported issues to the project team and re-tested them after the bug fix
• Attended daily scrum meetings and provided status (Agile)
• Participated in walkthroughs for design document and business requirement
• Participated in various change control process and tested them in QA environment when code was migrated
• Consistently worked and communicated issues with off-shore development team on a daily basis
• Verified ETL process worked from beginning to end. By running the extract scripts (KSH) verified data migrated from different source systems to staging tables
• Developed complex SQL queries for querying data against different data bases for data verification process
• Verified the dimension and fact tables are populated correctly by running the load scripts and utilizing the staging tables
• Verified the transformation logic (based on requirement) worked correctly from data mapping document using stage and target tables
• Used HP quality center for test case execution, log defects and re-test when bug fixes are done

Confidential, Dallas, Texas

Sr. QA Analyst

• Created test cases for baseline test environment
• Performed load test and provided reports to the project team for various transactions with HP load runner tool
• Identified performance issues on different portals/contents and generated statistical data for the application team

Confidential, Hartford, Connecticut

Sr. Data warehouse QA Consultant

• Participated in test case creation, execution and defect resolution for the loss project. Jointly shared responsibility of the claim subject area to build SME knowledge
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
• Attended all daily and weekly meetings with team members and escalated issues to manager when needed
• Created test plan and test strategy.
• Created test cases/scripts/SQL’s in MQC and executed them in all 3 environments including production. Created test cases utilizing data mapping, design document and functional requirement for (APLF) actuarial premium and loss facility application.
• Executed test cases for the same application for different releases.

Confidential, Hartford, Connecticut

Sr. QA Analyst

• Wrote test plan and test cases for Attorney and Clerk’s e-filing application
• Performed end-to-end testing for e-filing application (web based application used by court attorneys and clerks for civil and family cases)
• Communicated all defects with appropriate developers and QA team
• Provided test assistance in production support for hot fixes on a need basis
• Attended all weekly meetings to discuss various issues, resolutions and status

Confidential, Hartford, Connecticut

Sr. BA/QA Analyst

• Provided application support for performance test initiative for Aetna’s RX home delivery system
• Worked closely with DBA’s, performance team and application developers to analyze data requirements for test execution
• Conducted application walkthroughs with performance team for Load Runner scripting activity. Documented testing approach

Confidential, Hartford, Connecticut

QA Test Engineer

• Completed test plans and test effort for various components of Property business
• Developed WinRunner scripts for performance team for Property release into claim application. Developed number of Win Runner test scripts for Claim application
• These scripts were used for regression test on every weekly build
• Provided support and mentored entire team to learn the product (WinRunner) for their automation need. Performed back end data testing for ORS (operational reporting system) application.
• Created test plan, executed test cases and delivered a detail test report at the end of project
• Used SQL Plus, TOAD and WinDDI tools for different data verification