PROFESSIONAL SUMMARY

• Substantial expertise in integration, volume, system, regression, backend data warehousing and automated testing.
• Experienced in ETL and manual testing.
• In - depth knowledge of Enterprise Data warehousing, ETL and Data warehousing requirements.
• Experience 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.
• 15 plus years of experience in software testing and support.

TECHNICAL EXPERIENCE:

Software: ORACLE RDBMS (SQL * Plus), Teradata (12.0), TOAD, MS query analyzer, AQT (Advance query tool), 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, Westport, Connecticut

Sr. QA Engineer

• Involved in different functional areas like Accounting, Client Reporting and Insulation Layer
• Participated in Client Reporting 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 for ETL to compare Source and Target database systems
• Identified issues and logged defects and re-tested them when fixes were completed by development
• Compared data through BDQ (Bridgewater data query). BDQ interacted with oracle database and MS SQL server to collect current state data and future state data.
• Attended daily scrum meetings and provided statues on testing activities, obstacles and accomplished goals

Confidential, Marlborough, Massachusetts

Sr. QA Engineer/ ETL Tester

• Created test plan, test cases and test scripts for various tables for initial and incremental load in stage and target tables
• Reviewed functional requirements and technical design documents to write test case document
• Created SQL scripts and executed them in SQL assistance using Teradata
• Involved in ETL process testing using Informatica ETL tool
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
• Attended daily hurdle meetings with the project team to update status and discuss issues
• Reported bugs to developers through Zira and re-tested them when they were fixed

Confidential, Merrimack

Sr. ETL Tester

• 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 (ETL)

• 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
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• 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.
• Identified issues/bugs and communicated them with the APLF project team
• Attended all scrum meetings and provided daily status to the project manager and QA team.

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. 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

Confidential, Trumbull, Connecticut

QA Test Specialist

• Developed and documented SDLC compliant QA test plans for MedUnite (Member eligibility and claim status inquiry) and Electronic Pre-Certification (Notification of hospital admission) web based applications
• Created test scenarios and test cases for these applications using TMS (test management system)
• Executed QA test cycles, produced test results and documented summary of results for evaluations
• Executed UNIX shell scripts and verified data through SQLPLUS in different oracle tables for various data warehouse enhancement projects