Sr.qa Analyst Resume
Albany, NY
SUMMARY
- Around 8 Years of experience in Quality Assurance and Testing specializing in Content management Work Flows,, Client/Server, Database, ETL/Data Warehouse and Web based applications on Windows and Unix/Solaris/Linux Platforms.
- Complete understanding of QA methodologies and strong experience with Waterfall, Agile and RUP methodologies.
- Strong Experience in Inventory Management.
- Strong experience in performing different kinds of testing like black box testing, white box testing, functionality testing,GUI testing, unit testing, integration testing, backend testing, performance testing, load testing, stress testing, regression testing.
- Strong experience in working with enterprise content management Platforms.
- Extensively worked on Workflow Management Implementations
- Experience managing large projects involving solutions developed in EMC Documentum.
- Ability to recognize and manage performance and tuning requirements within workflow projects of 10 Million Records or more.
- Strong experience working with ETL Data warehouse applications.
- Experience in managing large projects involving large data migration moves.
- Strong experience in writing complex SQL queries.
- Strong experience with HP/Mercury tools Test Director, Quality Center, Win Runner and QTP,Selenium.
- Strong Experience in writing traceability matrixes, test scenarios and test cases.
- Experience in working with end users in developing various test scenarios and test cases for UAT.
- Experience with all phases of Project Life Cycle including requirement gathering, analysis, design, development, implementation, testing.
- Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems
- Effective leadership skills with good written, verbal communication and presentation skills.
TECHNICAL SKILLS
Operating Systems: Windows (XP/2000/NT/98/95), UNIX (Solaris2.8, Linux7.2/8.0).
RDBMS: Oracle, Sybase, PLSQL, SQL Server, DB2, TOAD
Testing Tools: Quality Center, Test Director, Win Runner, QTP,Selenium,Python, NetworkX
Languages: C, C++, SQL, PL/SQL
Server - Side Technology: VB.Net, ASP.Net,Java
GUI: Visual Basic 6.0, Developer 2000
Web Technologies: HTML, DHTML, XML, ASP
Packages: MS Office 2000, 2003
EMC Tools: Task Space, Webtop 6.6
ETL Tools: Informatica, Crystal Reports
Hardware: HP 9000, Intel, IBM, Sun compatible PC platforms
PROFESSIONAL EXPERIENCE
Confidential, Albany, NY
Sr.QA Analyst
Environment: EMC Documentum, Task space, Web top, Oracle 10g, SQL Server, Asp.net,Java,python,NetworkX Toad, MS- Word, XML, Quality center,.
Responsibilities:
- Reviewed Business Requirement Documents, technical design documents and functional flows of the application.
- Analyzed use case with reference to Business Requirements.
- Gathered requirements coverage on test cases development.
- Requirement Traceability Matrix is created in Quality Center 10.0
- Responsible for testing Documentum work flow, which was fed to the automated system.
- Tested Ascent capture software( Kofax) to Scan, Index, and release of the electronic images to web.
- Accept or refuse New Software Build by verifying the release notes and build verification tests.
- Created Re-usable actions to test the different applications functionalities..
- Involved various meetings with development team and discuss Enhancements and Modifications of the application
- Developed support of business reporting and basic analysis of application performance from large oracle database utilizing SQL queries.
- Report test results to the stake holders and management.
- Tested the new data base changes and functions and performed data quality studies on data in the AIS database.
- Coordinate testing schedules with QA Manager.
- Schedule, manage, and facilitate Defect Triage meetings with dev team and business users.
- Responsible for Training the users to perform UAT testing
- Worked with developers and Business analysts to resolve production issues incurred by clients.
Confidential, New York City
Sr.QA Analyst
Environment: Oracle 10g,DB2,Java, Toad, MS-Word, Ms-Excel, MS-Project, QualityCenter, ETL, Informatica
Responsibilities:
- Analyzed software and business requirements documents and created traceability matrix and high level test scenarios.
- Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
- Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
- Crated test plans for data extraction feeds from KBS, CRM, ESS, SO, Billing
- Load the staging tables with no transformation
- Load Raw Data Vault (RDV) with transformation.
- Load Business Data Vault (BDV) with Transformation.
- Load Datamart staging tables for the given Fact staging tables.
- Load Datamart for the Fact and Dimension tables.
- Validation & Verification of Data against the transformation rule.
- Wrote complex SQL queries and validated data.
- Performed Backend Testing, by executing complex SQL queries in Oracle and DB2 databases.
- Lead daily defect meetings and assigned the defects to the developers.
- Used QC for Test Plan creation, execution and defect tracking.
Confidential, Springfield, MA
Sr.QA Analyst
Environment: Java, Load Runner, Oracle 10g,DB2,Java,python,NetworkX, Toad, XML,MS-Word, Ms-Excel, MS-Project, Quality Center 9.2, QTP 9.5.
Responsibilities:
- Analyzed software and business requirements documents and created traceability matrix and high level test scenarios.
- Conducted Manual Testing and documentation in the initial phase of the project and later stage automated manual scripts using automation tool QTP.
- Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
- Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
- Extensively used Load Runner tool for performance testing.
- Prepared test plan for performance testing based on system requirement specification and project delivery plan.
- Responsible for deploying web applications in QA environment including the deployment of war files in web logic, deploying the static content and loading the data into the database using shell scripts.
- Performed functional and regression testing by developing and executing automated test scripts using QTP
- Performed Backend Testing, by executing complex SQL queries in Oracle and DB2 databases.
- Responsible for testing XML work flow, which was fed to the automated system.
- Responsible for creating test data for various applications.
- Involved in thorough compatibility testing of the site on different browsers and different operating systems.
- Interacted with developers, business analysts and the project manager.
- Actively participated in daily defects scrubs, reviews and walkthroughs.
- Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
- Provided time and resources estimation to the QA manager regarding new and existing projects.
- Responsible for creating release notes for production.
- Used QC for Test Plan creation, execution and defect tracking.
Confidential, Wilmington, Delaware
Sr. QA Analyst
Environment: Visual Basic, Oracle 10g,DB2,Java, Toad, MS-Word, Ms-Excel, MS-Project, Quality Center 9.2, QTP 9.5, ETL, Informatica
Responsibilities:
- Performed system, integration, functional and user acceptance testing.
- Prepared test plans and test cases based on requirements.
- Prepared requirements traceability matrix.
- Debugged problems to determine root cause analysis and provided development team sufficient details to understand, replicate and resolve the issue.
- Used QTP to write test scripts for regression testing
- Performed analysis of software quality and testing progress to provide status to project team.
- Participated in change request meetings to document changes and implemented procedures for test changes.
- Supported UAT with users to receive customer approval and sign off.
- Performed both Manual/Automated Testing.
- Responsible for QA server setup after development code drop.
- Modified the generated test scripts for data driving testing using QTP
- Used Test Director and Quality Center to write and execute test cases.
- Recorded GUI test scripts for functional testing using QTP.
- Extensively wrote SQL and Unix Shell scripts, to minimize manual and data validations.
- Tested Informatica mapping by writing complex SQL queries
- Wrote source to target SQL queries and validated Informatica mappings.
- Lead daily defect meetings and assigned the defects to developers and testers.
- Created defect reports out of QC and distributed to the team on a daily basis.
Confidential, CA
QA Tester
Environment: Java, JSP, DB2,Web Sphere Application Server, Oracle,DB2,TOAD,MS-Office,Test Director, Win Runner
Responsibilities:
- Attended the review meetings of functional and technical specs with developers and business analysts.
- Involved in the development of test plans, test cases and test data preparation as per the testing requirements (for both Positive and Negative scenarios).
- Conducted 'Walkthrough’s' of the test plans and test cases for coverage of testing with technical and business teams.
- Formulated test plans that contains test scenarios for testing the functional, system, integration and regression testing.
- Involved in implementing test methodology and full Software Testing Life Cycle/
- Responsible for creating and executing test plans, test cases.
- Automated the test cases and testing process for regression testing using Win Runner
- Wrote SQL and PL/SQL scripts for database testing
- Performed data driven tests (Parameterization) that deal with different sets of data.
- Generated the detailed reports of the defects and comparison charts for management meetings.
- Wrote source to target SQL queries and validated data flow mappings.
- Lead daily defect meetings and assigned the defects to developers and testers.
- Created defect reports out of QC and distributed to the team on a daily basis.
Confidential
Test Coordinator / QA Analyst
Environment: Mainframes, VB 6.0, Test Director, SQL, DB2, Java, J2EE
Responsibilities:
- Responsible for functional, system, integration, database, regression, load and performance testing.
- Developed test cases to cover various testing scenarios,
- Logged defects and generated reports using Test Director.
- Reported QA defects to QA Manager/Technical Lead/Developers on a daily basis
- Extensively involved in testing source to target validations and performed database testing by executing SQL queries
- Lead daily defect meetings and assigned the defects to developers and testers.
- Created defect reports out of QC and distributed to the team on a daily basis.
