Qa Analyst Resume
Sunnyvale, CA
SUMMARY
- Over 7 Years of diverse experience in Quality Assurance (QA) with expertise in requirements gathering, analysis, design, application testing & Quality Assurance of Web based applications and expertise in developing Business Intelligence and Data Warehouse applications.
- Extensively involved in both Manual and Automated testing of Object Oriented, Client - Server, Web based and N-Tier complex large scale applications.
- Experienced in analyzing, attaining business requirements, system analysis, Use case studies, process flows, testable requirements, evaluating existing or proposed systems, including business requirements and test scripting
- Extensive experience in testing methods like Black box testing, Regression testing, Functional testing, Content testing, Ad-Hoc, Security testing, Boundary testing, Systems Integration testing, System testing, User acceptance testing, and Deployment testing
- Good work experience on Installation and configuration, Creation of repositories and security domain with user groups and security implementation.
- Experienced in Universe developing and testing the reports by performing Adhoc, User Acceptance Test and data accuracy test.
- Proven abilities in creating complex queries by linking data from multiple tables, using free hand SQL and functionalities like Combined Queries to verify the data pulled in reports.
- Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
- Comprehensively worked in testing complex Business Objects reports, ETL transformation testing, UNIX Scripting.
- Good Knowledge with Oracle applications.
- Good Knowledge in Configuration Management Tools like Clear Case, Quality Center.
- Experience in problem solving and tracking bugs using Bug Tracking Tools like Bugzilla, Test Director/ Quality Center and locally developed tools (Excel / MS Access).
- Strong in analyzing Business Requirements and specifications and development of Test Plans, Test Scripts, Test Cases and their execution.
- An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
- Experience working with the world renowned clients.
TECHNICAL SKILLS
Testing Tools: HP QTP 10.0, Mercury Interactive Test Director 8.0, Lotus Notes, Lotus 1-2-3, Selenium IDE1.6.0/WebDriver2.0/Grid2.0, Load Runner 9.0, Adobe Photoshop, Adobe Acrobat
Bug Tracking Tools: Quality center 10.0 and Bugzilla.
Framework: JUnit, TestNG
OLAP Tools: Business Objects 5.x/6.0/6.1/6.5/XIR2/XIR3.1, Micro Strategy 7i, Designer, Desktop Intelligence, Web Intelligence, Broad Cast Agent Server, Crystal Reports 2008, Xcelsius 2008/4.5, QaaWS, Cognos and Live Office
ETL Tools: Informatica Power Center
Databases: Oracle 10g/9i/8i, IBM DB2, MS Access
Programming Languages: COBOL, PL/SQL
Data Modeling: Erwin
GUI Tools: Crystal Reports2008, Xcelsius 2008,VisualBasic6.0, Oracle Toad, IBM DB2 AQT, Visio, Clear case.
Requirement Tools: MS Word, MS Project, MS Excel
Packages: MS Office - Excel, Word, PowerPoint, Access, Outlook
Operating Systems: Microsoft Windows 9.x, 2000, XP, Server 2003,unix
App/Web Servers: Web Logic, Web Spear, Tomcat, IIS, Apache
Network Protocols: FTP, HTTP/HTTPS, TCP/IP
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
Responsibilities:
- Participated in Requirement analysis, Peer reviews Defect analysis meetings.
- Performed Black box manual testing for the Everest project at Confidential .
- Responsible for executing Front end and back end Test Cases using HP Quality Center.
- Developed test scripts and executed Manual test cases for Functional testing of various modules of the application using HPQC.
- Responsible for detecting/tracking/validating defects through HP Quality Center.
- Involved in upstream and downstream Functional/Integration Testing with 4 different teams including test case, data setup, co-ordination and execution
- Wrote test cases and performed Manual Testing like Positive Testing and Negative Testing, Regression, Integration, End To End Testing.
- Used R12(Order management Console) OM console to accept the PO(Purchage order).
- Used R12 for order reviewing the transaction data process status.
- Executed Validation testing, Regression testing.
- Created test Scripts based on the MD50 and participated in SME event.
- Responsible for writing test scripts using the clients design documentation, executing scripts for HPQC, re-testing, and defect management.
- Tested connectivity between legacy 11.5.9 instance and R12 target instance.
- Created Test data for Order&invoice for US and EMEA.
- Used HP Quality Center to track open defects and to log new defects.
- Conducted review sessions on test case and regression test scripts in quality center.
- Used the QTP to develop the automation scripts including developing required Object Repositories, Function libraries adding checkpoints, synchronization points and add conditional statements, error handling, parameterization, call the functions, run batch tests, import and export data table sheets, insert start and end transactions to measure the response time for a particular business process .. etc., for various application scenarios and monitor System counters for various transactions.
- Developing QTP scripts for other competitor applications and third party applications and compare the results with HP application and preparing the performance benchmark matrix.
- Involved in validating both functional and automated business processes using HP Quality center.
- Responsible for Backend test validation using SQL Queries using SQL Developer for Functional/Integration/Regression Testing.
- Identify & record defects with required information for issue to be reproduced by development team.
- Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
Environment: HP Quality Center 10.0, Salesforce.com, Oracle R12, TIBCO, Oracle 11.9.5, SQL Developer, CMAT, Virtual Machine, Window 7, MS office 2007, QTP 10.0.
Confidential, Pittsburgh, PA
QA Analyst
Responsibilities:
- Participated in the requirements and design review sessions.
- Prepared estimations for the testing efforts based on the requirements.
- Prepared high level test strategy and plan documents based on requirements and timelines and estimations prepared.
- Prepared business scenarios and create test cases to test the solution to make sure it is as per the business requirements.
- Processed Batch files in Message Broker to validate the files against the HIPPA Validations.
- Responsible in processing claims and validating full payment cycle process until it generates 835 files.
- Responsible for preparing test data for 835 (Remittance), 837 (Claims), 270 (Eligibility Request) and 276 (Claim Status Request) transactions as per the Implementation Guide.
- Executed and validated test cases based on the system requirements and FDA standards. Developed and executed test scripts according to formal standards.
- Responsible for processing all 835, 837 (X12-Institutional, X12-Professional and Non X12 files), 270, 276 transaction files.
- Involved in validating both functional and automated business processes using HP Quality center.
- Performed Manual activities for testing the functionality of master data and transactional data extracts from various interfacing systems via flat files . Created Test cases and Test suite with Selenium IDE. Record the user actions, add Asserts, Verify, Accessors as per requirement and play back the tests and export them into Java language
- Used Selenium RC to enhance the tests by adding conditional statements, Control structure loops, Parameterization with multiple sets of data, wrote static/class level and object/instance level methods.
- Coordinate and participate in the defect review meetings with the development team.
- Involved in defect validation, review and defect life cycle management.
- Performed Functional testing, System Testing, Security testing and Regression testing.
- Created Web based automation scripts for all assigned scenarios using QTP. And performed regression testing on various application builds.
- Maintained the Defects database using Quality Center.
- Generated the issue reports from Quality Center and provide to project management team.
Environment: Quality Center 9.2, QTP 9.0, Selenium IDE 1.50/RC, Java spring, XML Web Sphere Message Broker (WMB), MS Access, Agile, Oracle 10g, SQL Developer and Windows xp.
Confidential, Redwood City, CA
QA Engineer
Responsibilities:
- Extensively involved in Software Development Life Cycle (SDLC) using Agile (scrum) Methodology.
- Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs.
- Designed, developed and executed Test Plans, Test Cases/Scripts for Credit Flow, Portals, Single Sign On links and Funds Flow Management applications in Quality Center.
- Documented Test cases, Test plans and Test strategy documents in MOSS (Share Point).
- Verified that all rules and regulations are adhered to in the test lab and performed Validation Documentation Review.
- Conducted functional testing and analyze technical testing results to verify compliance with functional and technical requirements.
- Used Quality center to manage the requirements, test cases and also log defects and generate defect reports and graphs.
- Used HP Quality Center to create manual test cases, track defects.
- Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
- Developed and maintained test cases and test scripts; provide daily status feedback to the team lead.
Environment: Oracle 10g, SQL, Clearcase, TOAD, XML, Java, Pentaho, Quality Center 9.2.Windows XP, IBM Db2, AQT.
Confidential, Detroit, MI
QA Engineer
Responsibilities:
- Involved in writing Test plan, Test Cases and in executing them to validate the system.
- Participated in Scrum Meeting as part of agile methodology.
- Executed and validated test cases based on the system requirements and FDA standards. Developed and executed test scripts according to formal standards.
- Actively participated in performing White box, UAT, ad-hoc and Regression testing the reports.
- Performed Regression testing as and when the bugs got fixed and checked whether the application is free from bugs.
- Assigned testers on test scripts applications in Quick Test Pro (QTP) and coordinated them by additions/modifications.
- Worked on synchronizing, build verification and functionality test in QTP.
- Defects found in the system were entered in QC.
- Involved in ETL Testing.
- Developing UNIX Shell Scripts to test various functionalities of the application and to authenticate and verify data stored in the Data Tables.
- Hands on expertise in designing, developing, enhancing automated test scripts for QTP using VBScript.
- Performed Regression testing using QTP scripts for the existing functionality.
- Involved in Production validation by generating ad-hoc reports and testing them.
- Involved in Unit Testing and Integration Testing.
- Participated in Scrum Meeting as part of agile methodology.
- Involved in various formatting types in Business objects.
- Involved in defect meetings and worked with developers to reproduce them.
- Executed test scripts to perform regression and functional testing.
- Executed test cases for manual testing and Execution of test scenarios and analyzing actual results against expected results.
Environment: HP Quality Center 9.0, Oracle 9i, QTP 9.0, Manual testing, IBM DB2, TOAD, MS office, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, XML,Informatica7.1 and Windows 2003.
Confidential, Chicago, IL
QA Tester
Responsibilities:
- Understanding the user requirements.
- Wrote test plan and test cases from requirements documents and functional specifications.
- Responsible for developing Manual test cases based on functional specifications and technical specifications of the application.
- Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems.
- Involved in the development of test plan and test strategy; performed functional and structural analysis for the same.
- Executed test cases using Test Director.
- Performed Black Box Test for functional testing to guarantee high quality software end products
- Installed Business Objects and created the repository.
- Used Test Director to execute the test plan, track execution against the plan during testing and manage defects from inception to resolution.
Environment: Oracle 8i, TOAD, PL/SQL Business Objects 6.1 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View) and Windows 2003.
Confidential, Santa Clara, CA
Business objects developer
Responsibilities:
- Developed a reports using Filters, prompts etc.
- Generated and implemented Business objects by creating Hierarchies, Prompts, Filters, Resolved loops by using Business objects Designer.
- Organized data with in reports by using Filter, Custom Groups, Drill and highlighted data with Alerts.
- Provided recommendations on technical issues.
- Involved in performance tuning by using various hints (parallel, combine index, full).
- Developed Universe using Designer module in Business Objects.
- Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
- Changed user permissions according to the requirement by using Supervisor.
- Analyzed performance tuning; send response time report to the performance team.
- Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula etc
- Involved in Multidimensional Data Modeling in Star and Snowflake Schemas.
- Designed the Screen, Report and Query layouts.
- Involved in Unit Testing and Integration Testing.
Environment: Business Objects 6.1 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), JCL, VSAM, CICS, MS Access, Oracle 8i, SQL, PL/SQL and Windows 2003.