Qa Analyst Resume
Foster City, CA
SUMMARY:
- Over Five years of experience as QA Analyst in testing GUI/Web based and client/server applications using manual and automated testing procedures.
- Expert in TLC (Testing Life Cycle) and Complete SDLC (Software Development Life Cycle).
- Extensive experience in functional testing, integration testing, regression testing, black box testing, GUI/Web testing, back - end testing, data validations, cross browser compatibility testing.
- Proficient in working wif - Test Director, Quality Center, QTP, Load Runner, Rational Clear Quest, Clear Case, TOAD, MS Office tools.
- Extensive experience in using Quick Test Pro for functional and regression testing.
- Proficient in writing complex Quick test Pro VB Scripts.
- Experienced in testing Web, Client Server, and Web Service applications using J2EE, JSP’s, Servlets, EJB’s, JavaScript, DHTML and HTML.
- Expertise in working wif Web Services & SOA Architecture.
- Proficient in working wif XML, XSD and WSDL.
- Proficiency in testing Web Services using SoapUI.
- Experience in EAI/Integration tools like Tibco Business Works (Mappings, Transformations, Derivations), EMS, Hawk and TIBCO suite of products.
- Well versed in ETL processes,performancebased systems, and ETL process flow and standards
- Knowledge of Enterprise Data warehousing ETL, Data warehousing requirements, and Enterprise level data warehousing.
- Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
- Extensive experience in backend testing using SQL Queries.
- Expertise in data testing to create valid test cases based on real time data.
- Experience in writing Test Plans, defining Test Cases, developing and maintaining test scripts, analyzing bugs, interacting wif team members in fixing the errors.
- Strong skills in backend testing using SQL queries on Oracle, DB2 UDB, SQL server databases.
- Extensive experience in interacting wif Business Analysts, Technical Architects, Subject Matter Experts, Developers, DBA and System Analysts.
- Experience working in UNIX/Linux Environment.
- Good understanding of waterfall and Agile methodologies for application development.
- Experience in using Version Control tools (Clear Case, CVS, VSS, PVCS, Dimensions)
- Result oriented, committed and hard working wif a quest to learn new technologies and undertake challenging tasks.
- Good team player wif excellent communication, interpersonal and writing skills.
- Ability to handle multiple tasks and work independently as well as in a team.
TECHNICAL SKILLS:
Testing Tools: Load Runner, QTP, Test Director, Quality Center 10.0, Test Manager, Clear Quest 7.0, SoapUI.
Languages: C, C++, Java, C#, VB.NET, VB, PL/SQL
Web Technologies: Java, J2EE, JSP, Servlets, EJB, XML, XSL, HTML, VBScript, JavaScript, VB Script, SOAP, WSDL, XSD(Schema), SoapUI.
EAI: TIBCO Business Works, EMS, Hawk.
ETL: Informatica, Datastage.
Databases: SQL Server 2008, MySQL, Oracle 11g, DB2 UDB
Web Servers: Tomcat
Platforms: Linux, Unix, Windows 9x/NT/2000/XP
Methodology: Waterfall, Agile
Life Cycle: Software Development Life Cycle (SDLC), Testing Life Cycle (TLC)
Version Control: VSS, PVCS Dimensions, Clear Case, CVS
Reporting Tools: Microsoft Reporting Services, Crystal Reports 12, Micro Strategy
PROFESSIONAL EXPERIENCE:
Confidential, Foster City, CA
QA Analyst
Responsibility:
- Analyzed business requirements, technical requirements and developed Test Plans, Test Cases and Test Scripts for alerts, notifications and spending reports modules.
- Performed different types of testing which include - Functional testing, Integration testing, Database testing, Security testing and Regression Testing.
- Prepared Test Cases and performed extensive backend testing for reporting module.
- Involved in ETL process testing usingInformaticaETL tool.
- Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems usingInformatica.
- Wrotecomplex queriesto compare the counts and data from source to target.
- Executed tests for stored procedures that contained a lot of the business logic about the application, including security levels, error handling, valid and invalid data.
- Performed extensive frontend testing for alerts & notifications module.
- Created Test Cases and Test Data wif comprehensive test coverage.
- Extensively performed manual testing to ensure the quality delivery of the application.
- Escalated new change requests for the requirements to the change management team.
- Extensively used Quality Center for Test Planning, Defect Tracking and Reporting.
- Manually executed smoke test cases after each build.
- Created the checklists (Test Scenarios) according to the application, executed and compared the actual versus expected results, logged the test results in QC.
- Developed and executed SQL queries to extract data from the tables and to verify the output data of the reports.
- Interacted wif developers and subject matter experts to narrow down the cause of the defects.
- Developed procedures to test data for reports using scripts wif validations and integrity checks.
- Participated in all phases of the test life cycle.
- Attended change request meetings to document changes and implemented procedures to test changes.
- Coordinated wif development, design, business and QA groups in executing UAT and testing efforts.
- Provided support to UAT and Production issues.
- Assisted team lead wif daily QA tasks, attend project meetings, release meetings and QA status meetings.
Environment: Quality Center 10.0, QTP, Informatica8.6, Java, J2EE, JSP, Crystal Reports 2008, Weblogic 10, UNIX, Autosys, Oracle 11g, Windows XP, Toad, MS Word, MS Excel.
Confidential
QA Analyst
Responsibility:
- Conducted a wide range of quality tests to ensure that application meets specified standards and end-user requirements for Manage Polices module and performed integration testing wif pricing application.
- Performed Smoke, Functionality, Regression, Integration and System testing during various phases of the application.
- Developed detailed Test Plans, Test Cases and Test Scripts.
- Developed Test Data, documented test results and analyzed test results.
- Extensively worked wif Business Analysts and Developers in testing data for validations and to ensure quality of the reports.
- Validated the web services functionality and integration wif pricing application using SOAP UI.
- Developed XML documents based on XSD defined in the web service end points exposed by TIBCO Middleware.
- Performed the front end and backend queries in order to view successful transactions to validate the data using SQL
- Generated automated test scripts (VB Scripts) using Quick Test Pro for Regression testing.
- Developed SQL queries to test and validate data.
- Involved in execution of load simulation testing using Load Runner for various Load varying Scenarios through controller for web-based screens.
- Was responsible in preparing Test Plan, Test Cases, Test Summary, defect report and RTM.
- Documented, executed manual test cases and automated test scripts.
- Interacted wif developers and subject matter experts to narrow down the cause of the defects.
- Worked wif developers to communicate regarding issues in the application.
- Recommended and implemented changes to enhance the effectiveness of QA strategies.
- Defects were tracked and reported using Clear Quest Reporting tool making sure that all high and medium priority bugs are fixed prior to deployment.
Environment: Load Runner, QTP, Clear Quest 7.0, TIBCO Business Works, EMS, Hawk, SQL server 2008, SQL, Toad, Windows XP, MS Word, MS Excel, Java, J2EE, JSP, XML, XSD, WSDL, Web Services, SOAP UI, Web Logic, UNIX
Confidential
QA analyst
Responsibility:
- Responsible for development of Test plans for key features and functions of Build & Price, Schedule a Test Drive modules.
- Involved in testing application enhancements for data testing, integration and functional testing using manual test cases during each phase of the application development.
- Performed defect tracking and management using Quality Center.
- Used Quality Center for preparing and executing test cases.
- Involved in preparing Requirement Traceability Matrix (RTM).
- Responsible for Smoke testing of new builds in Test environment.
- Responsible for Bug count, tracking till closure which involved interacting wif various people in the process.
- Developed SQL queries to test the validity, security and quality of the data.
- Performed manual QA testing, Integration, backend data testing and end-to-end testing activities for new releases.
- Extensively worked wif Business Analysts and Developers in testing data for validations and to ensure quality of the reports.
- Attended change request meetings to document changes and implemented procedures to test changes.
- Involved in tracking, reporting and analyzing system defects and interacting wif business users and developers to resolve the technical issues.
- Performed End-to-End testing manually and Assist developers wif reproducing defects and providing additional information as needed.
- Ensured Version Control of all work items using Clear Case till final release.
Environment: Quality Center, Clear Case, MS Excel, MS Word, Windows 2000, SQL, Java, J2EE, Websphere, DB2 UDB, UDB Client, Unix.
