SUMMARY

• Senior Software Quality Assurance Engineer wif 8+ years of Software testing and Quality assurance (QA) as QA which includes Manual and ETL testing wif hands on experience in all phases of Software Development Life Cycle (SDLC).
• Intensive experience in process improvement and in designing, building, validating, maintaining and troubleshooting.
• Expertise in domain technology like Mobile, IT and Banking Industry.
• Experience on all phases of Software Development Life Cycle (SDLC), its methodologies and process.
• Extensive work experience in all stages of STLC & expertise in Functional & Regression Testing methods for Mainframe & Web based applications in SIT and UAT phases.
• Extensive experience in testing ETL mappings developed using Informatica 8.6/9.1.
• Expertise in Change Data Capture (CDC), ODS (real - time data), Master Data Management (MDM), Incremental Extracts, Slowly Growing Targets.
• Experience wif slowly changing dimensions (SCD1, SCD2).
• Proficient wif RDBMS and Data Warehousing concepts.
• Experience working on ETL transformations like filter, sorter, Aggregator, joiner, lookup, rank and expression
• Experience in writing complex SQL queries and working wif huge volumes of data, analyzing record sets
• Proficient in QA Testing Methodologies and Agile Software Development
• Proficient in documentation of deliverables in testing process (Test Plan, Test Scripts, Test Summary, Defects in HP Quality Center/ALM & JIRA, Status Reports, and Best practices in Testing)
• Extensive experience in functional testing, integration testing, regression testing, black box testing, white box testing, GUI testing, system testing, security testing, browser compatibility testing, cross browser compatibility testing.
• Experience in core Java, Hands-on in creating/debugging/enhancing different automation frameworks.
• Experience in writing SQL queries for database transactions.
• Excellence in preparing test scripts, test plans functionality testing, security, regression, back end, and configuration testing, parameterization, multiple actions.
• Have involved in preparing Requirement Traceability matrix to ensure each of teh requirement is covered in testing.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.0/11.0, HP ALM 12

Database: Oracle 9i/10g/11g, SQL Server 2005/2008

Utility Tools: SQL plus

ETL Tool: Informatica 8.6/9.1

Languages: SQL, C++

MS Skills: Word, Excel, Power-point.

Operating Systems: Windows XP/2007, Linux and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Sr. ETL Analyst

Responsibilities:

• Extensively interacted wif developers, business& management teams to understand teh project business requirements and ETL design document specifications
• Test case design for businesses based on ETL Informatica mapping document.
• Performed Comparison of Source to Target, Verification of row counts, and Validation of data format.
• Test moves of data from IDS to Dimensions and Fact Tables.
• Involved in Smoke, System Integration, Regression Testing.
• Logged teh defects and track them to closure using QC.
• Prepared extensive set of validation test cases to verify teh data.
• Prepared Test Cases for teh mappings developed through teh ETL Informatica tool and executed those tests
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Actively participated in various meetings like defect resolution meeting, QA status, Knowledge transfer meeting.
• Involved in ETL testing on various sources (Teradata, Oracle and DB2).
• Extracted and transferred source data from SQL Server and Teradata.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying teh tables and columns from which data was extracted
• Tested Various Change requests, which includes loading of data from various Flat Files to EDW
• Execute SQL Queries to validate teh data loaded in to teh EDW, ADW Data Warehouses as per teh mappings
• Summarizing teh test status reports from teh team members and submitting it to teh project manager.
• Onsite offshore coordination
• Conducted Regression testing after teh bugs have been fixed by teh development team
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Actively participated in various meetings like defect resolution meeting, QA status, Knowledge transfer Meeting

Environment: Oracle, Informatica9.1, SQL plus, Teradata, Excel 2013, Windows7, HP Quality center11.0/ALM12.

Confidential, Minneapolis, MN

ETL Analyst

Responsibilities:

• Analyzed teh Business Requirements document and have written Test Cases.
• Preparation of Functional test Plan
• Involved in Functional, Regression, Performance and User Acceptance Testing.
• Prepared Regression Suite.
• Performed Database validation using SQL queries in Toad
• Driving teh Offshore team.
• Identified, analyzed and reported bugs found during various phases of testing.
• Discussed defect resolutions wif developers and business analysts.
• Participated in teh weekly team meeting to discuss teh upcoming work, schedules and status. involved in preparing Requirement Traceability matrix to ensure each of teh requirement is covered in testing
• Prepared Test Summary Report
• Performed User Acceptance Test on teh application by interacting wif teh end-users.
• Provide a weekly project report dat includes testing metrics and status reports.

Environment: ALM 11.0, QC 9.2, Oracle 10g, SQL, Toad, Excel, HTML

Confidential, Los Angeles, CA

QA Analyst

Responsibilities:

• Understanding teh requirements and developed test cases to test teh functionality of teh application
• Allocation of work and coordinating wif teh Team members
• Design and Execution of System test cases
• Review and rework of teh test cases
• Uploaded teh test cases in QC (ALM) and executed those test cases in ALM
• Coordinated wif Onsite Coordinators
• Performed different types of Testing like Sanity testing, Functional Testing, Regression Testing, Cross browser testing, System testing and Ad-hoc testing.
• Performed Mobile testing
• Reporting teh issues in Atlas Sian JIRA and follow up on bug fixes.
• Performed teh compatibility testing on different mobile devices.
• Reporting Defects though ALM/Jira and Tracking teh Status of teh Bugs
• Discussed defect resolutions wif developers and business analysts.
• Participated in teh weekly team meeting to discuss teh upcoming work, schedules and status.

Environment: ALM 11.0, Oracle 10g, Windows 7, Mac, JIRA Drupal, iPhone 4S, iPhone 5, iPad mini, Samsung S4, SQL, Excel, HTML

Confidential, Moline, IL

QA Analyst

Responsibilities:

• Understanding teh requirements and identified teh test scenarios
• Prepared Test plan wif Test cases.
• Design and Execution of System test cases
• Review and rework of teh test cases
• Uploaded teh test cases in QC and executed
• Performed testing on different radio models.
• Performed Smoke testing, Functional Testing, Ad-hoc testing for each Sprint.
• Attended weekly status calls wif client.
• Attended Scrum meetings wif Scrum master.
• Discussed defect resolutions wif developers and business analysts.
• Participated in teh weekly team meeting to discuss teh upcoming work, schedules and status.

Environment: QC 9.2, Windows 7, 8, Clear Quest, Harris Radios

Confidential, Las Vegas, NV

QA Analyst

Responsibilities:

• Preparation of Functional Test Plan.
• Providing inputs to Master Test Plan.
• Test Scenarios preparation as per teh requirements.
• Analyze teh design documents (functional specifications) for new requirements.
• Involved in running batches for migrations of data from Legacy system to new system
• Updating daily defect reports and status reports to lead platform.
• Involved in preparing test cases as per teh test scenarios.
• Involved in test execution.
• Involved in Data base testing
• Performed batch testing.
• Involved in validations.
• Involved in solving problems of team members while testing.
• Involved in preparing Test Closure.

Environment: Clear Quest, Quality Center 9.2, Mainframes, Db2, Excel

Confidential

QA Analyst

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• Preparing Test plan and Test cases.
• Execute and evaluate manual or automated test cases and report test results.
• Prior to each software deployment, executed test cases to establish a result metrics of Pass/Fail tests.
• Ensure dat validated deliverables meet functional and design specifications and requirements.
• Browser compatibility testing using IE, Firefox etc.
• Excelled in finding, documenting and reporting bugs, interoperability flaws and other issues wifin proprietary software applications developed for clients.
• Performed Regression testing on a large amount of test cases at teh end of every sprint to ensure software release meets requirements.
• Participated in scrum meetings to discuss progression during each sprint.
• Modbus protocol testing using Modbus Poll tool.
• Verified all teh possible permutation and combination using Data Driven testing manually.
• Verified teh bugs fixes, Document teh bug history and root cause analysis once teh defect is fixed.

Environment: Java, Web services, Modbus Poll Tool, HP Quality Center.