Senior Qa Analyst Resume
EXPERIENCE SUMMARY:
- 10 years of total experience in Manual, Database,UI and ETL testing.
- Expertise in Web testing, Functional testing, Integration testing, Regression testing, Performance testing and End - to-End testing.
- Strong knowledge in design methodologies and good knowledge on software life cycle.
- Have full system development life cycle experience, including designing, developing and implementing Test strategy, Test plans, Test cases, Traceability matrix, Test processes and Test Results.
- Exposure to water fall and scrum development models.
- Strong understanding of testing concepts with expertise in requirement analysis, test case development, black box and white box testing.
- Expertise in creating, executing the test cases and log the bugs in bug tracking tools and report the bugs to respective teams and triage them on time.
- Interacts with development team and Business Analyst to understand the requirement and design documents to map the test cases with requirement and design.
- Highly efficient with building domain and functional knowledge.
- Expertise in Database Testing with good knowledge of SQL LOADER, PLSQL Procedures, Functions, Packages and Triggers.
- Expertise in writing complex data base queries.
- Exposure to PL/SQL development using Oracle.
- Possess good knowledge in Data Warehousing concepts.
- Well versed with data warehouse architecture, data modelling and ETL process.
AREAS/APPLICATIONS:
- Global Remote Services
- Marketing and Sales
- Confidential
- Confidential
COMPUTERS WORKED ON:
- UNIX,LINUX,Windows 7, XP - Professional, 2000 Professional.
- SQL,PLSQL,Unix Shell Scripting.
- SQL Developer, PL/SQL Developer, Toad, ETL,VSS,SVN,Putty, HP-QC, Visual Studio 2008.
PROFESSIONAL EXPERIENCE:
Confidential
Senior QA Analyst
Responsibilities:
- Analysis and validation of business/functional requirement documents.
- Designing the Test plan and Test cases.
- Peer Review of test cases, Traceability matrix.
- Verification and Validation of test results.
- Preparation of SQL scripts for metadata and data validation.
- UAT and Production parallel testing support to sustain team.
- Responsible for the overall quality and timeliness of the deliverable.
- Preparation of status summary reports with details of executed, passed and failed test cases.
- Performing the Back-End testing to ensure data consistency by writing and executing SQL queries on the Oracle database.
- Gathering Reports for tracking the defects and maintenance of the project in HP-ALM.
Confidential
Senior QA AnalystResponsibilities:
- Designing the Test plan and Test cases
- Responsible for the overall quality and timeliness of the deliverable.
- Understanding/Discussing requirements with Business Team and Development team.
- Designing and execution of test cases.
- Performing the End-End testing to ensure data consistency by writing and executing SQL queries on the Oracle database.
- Preparation and execution of Test scripts.
- Verification and Validation of test results.
Hardware: PC
Operating System: Windows 7
Languages: PLSQL,SQL,ETL, Unix Shell Scripting
Special Software: SVN, PL/SQL Developer, Caliber,HP-ALM
Confidential, Detroit, MI
QA Analyst
Responsibilities:
- Interacting with Business, System Analysts, Designers and Developers in requirement gathering meetings and during all phases of the project life cycle.
- Designing the test cases.
- Preparation of status summary reports with details of executed, passed and failed test cases.
- Involvement in taking Reports for tracking the defects and maintenance of the project.
- Monitoring Test execution and Test Reports.
- Understanding/Discussing requirements with Business Team and Development team.
- Designing and execution of test cases.
- Performing the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.
- Participated rigorously in end to end testing with various front end clients.
- Preparation and execution of Test scripts.
- Verification and Validation of test results.
Hardware: PC
Operating System: Windows 7
Languages: PL/SQL, SQL, ETL, VB.Net
Special Software: SVN, PL/SQL Developer, Visual Studio 2008, Informatica
Confidential, Minneapolis, MN
Senior QA Engineer
Responsibilities:
- Interacted with Business, System Analysts, Designers and Developers during all phases of the project life cycle.
- Prepared status summary reports with details of executed, passed and failed test cases.
- Involved in taking Reports for tracking the defects and maintenance of the project.
- Monitoring Test execution and Test Reports.
- Prepared and reviewed Test scripts.
- Establishments data maintenance.
- Open Coverage Reserved Account Rules Maintenance.
- Temporary Assignment of Sales Territories
- Upload Account Rules
- Account Data Maintenance
- Understanding/Discussing requirements with Business Team.
- Analyzed and Evaluated the Business Requirement Documents, Functional/System Requirement Documents and Use Cases for the application to verify the testability and verifiability of the requirements
- Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database
- Participated rigorously in end to end testing with various front end clients.
- Raised defects and tracked them using “Share point” Bug tracker.
Hardware: PC
Operating System: Windows XP, Unix
Languages: PL/SQL, SQL, Unix shell scripting, ASP.Net, VB.Net
Special Software: SVN, PL/SQL Developer, Putty, MKS Integrity, Visual Studio 2008
Confidential
QA Engineer
Responsibilities:
- Involved in Business Requirement and Functional Requirement discussions.
- Functional Analysis and preparation of test scenarios.
- Executing the Regression Suite and analyzing the test results.
- Creating the bug report summary distinguishing the critical and non-critical bugs.
- Monitoring Test execution and Test Reports.
- Prepared status summary reports with details of executed, passed and failed test cases.
- End to End testing of the application from user’s perspective.
- Designing and execution of test cases.
Hardware: PC
Operating System: Windows XP, Unix
Languages: ASP.Net, C#, PLSQL,SQL
Special Software: PL/SQL Developer, Putty, SVN,Visual Studio 2008
Confidential
QA Engineer
Responsibilities:
- Liaise with the Development team to understand the Business Requirement Documents.
- Participated in regular project status meetings related to testing.
- Taking ownership of deployments into UAT environment and supported to pair wise testing team.
- Managed and conducted System testing, Integration testing and Functional testing.
- Reported and documented all defects and test results.
- Developed SQL scripts to load data into the tables.
- Created Test Cases and developed Tractability Matrix and Test Coverage reports.
- Prepared & reviewed test cases and worked on the test plan to cover overall functionality of the application for Functional testing, GUI testing and System testing.
- Monitored & tracked bugs through "Share point" and categorized them based on severity and reported the same to Developers for prompt resolution.
Hardware: PC
Operating System: Windows XP, Unix
Languages: PL/SQL, SQL and Unix shell scripting
Special Software: PL/SQL Developer, Putty, VSS
Confidential
QA Engineer
Responsibilities:
- Created Test Cases and developed Tractability Matrix and Test Coverage reports.
- Managed and conducted System testing, Integration testing and Functional testing.
- Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
- Developed SQL scripts to load data into the tables.
- Created Test Cases and developed Tractability Matrix and Test Coverage reports.
- Extensively used the AutoSys jobs for the entire project.
Hardware: PC
Operating System: Windows XP, Unix
Languages: PL/SQL, SQL and ETL
Special Software: PL/SQL Developer, Informatica
Confidential
Programmer
Responsibilities:
- Implementation of the code as per the design document and unit testing.
- Resolving MKS tickets
- Implementing change requests/enhancements in PL/SQL and Unix
- Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
- Written complex sqls using joins, sub queries and correlated sub queries.
- Involved in database programming and developed Stored Procedures.
- Developed PRO*C programs in Unix environment.
Hardware: PC
Operating System: Windows XP, Sun Solaris
Languages: Pro*C, SQL, PL/SQL
Special Software: VSS, PL/SQL Developer, Putty
Confidential
Tester
Responsibilities:
- Prepared and executed Test suites (Functional, Integration and Regression).
- Designed and execution of test cases.
- Reported and documented all defects and test results.
- Prepared and executed Test suites (Functional, Integration and Regression).
- Designed and execution of test cases.
- Reported and documented all defects and test results.
Hardware: PC
Operating System: Windows XP, Sun Solaris
Languages: Pro*C, SQL, PL/SQL
Special Software: VSS, PL/SQL Developer, Putty