Systems Analyst/tester Resume
Irvine, CA
SUMMARY
- Six Years of IT experience as a Systems Analyst/Tester in Manual and Automation testing applications developed in .NET, Java, SAP BW and Oracle, SQL Server on Windows
- Involved in identifying test strategies and writing the test scripts.
- Performed various types of testing that include Integration, Regression, Functional, System and User Acceptance Testing.
- Good IT experience in Quality Assurance and Software Testing of various business applications inClient/Server environments, Web based applications, Data Warehousing and Business Intelligence solutions.
- Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
- Involved in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, Defect status reports, and Test Summary report.
- Have good experience on database query tools such as TOAD, SQL Navigator, SQL Plus and PL/SQL
- Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations
- Well versed in Black box and White box testing.
- Experience in testing Entertainment, Financial and Insurance Applications.
- Experience in Integration, UAT, System, Navigational and Unit testing.
- Specialized in testing of both WEB applications and Client/Server applications.
- Specialized in automating test scenarios using Selenium tool.
- Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking, versatile team player and capable of working independently.
- Exposure to various defect tracking systems.
TECHNICAL SKILLS
QA Tools: QTP,Selenium Web Driver, Manual Testing
Defect Tracking Tools: HP Quality Center, Remedy, JIRA, Rally
Languages: HTML, DHTML, Java, Java Script, SQL, PL/SQL
Database: Oracle, MS Access, and MS SQL 7.0/2000, SAP, SAP BW 7.x/7.3, INFORMATICA 8.x/9.x, ETL
Documentation: MS Word, MS Excel, MS PowerPoint, MS Projects, Visio, Share Point
Business Intelligence: Web Analyzer ( WebI), BEx Analyzer, Query Designer
Operating Systems: UNIX, Microsoft Windows Operating System
PROFESSIONAL EXPERIENCE
Confidential, Irvine, CA
Systems Analyst/TesterRESPONSIBILITIES:
- Reviewed and analyzed business requirement documents, technical requirements and functional specification of various functionalities.
- Created Test cases for full requirement and executed the test cases for validating functionality of the application.
- Documented functional requirements and loaded them into the Quality Center.
- ConductedUI testingon different modules includingdata validationin text fields,negative and positive data, data type, boundary value, validationof optional and required fields.
- Performedmanual testingof the functionality of the applicationby inserting dataon different test runs.
- Identified and documented Test Cases to automate.
- Converted Manual Test cases into automated regression test scripts based on the importance and the frequency of the test case.
- Created Selenium Automation Scripts in Java, automated those test cases using Selenium Web Driver and Test NG.
- Added annotations to the test. (Selenium).
- Developed automation scripts using selenium and cucumber framework.
- Extensively used Rally for defect tracking and prioritizing defects.
- Created and maintained the traceability Matrix to determine the test coverage.
- Created and executed SQL statements to retrieve data for testing analysis and test case validations.
- Thoroughly used Joins and Sub - Queries to simplify complex queries involving multiple tables.
- Participated in daily Status meetings.
ENVIRONMENT: JAVA, J2EE, JUNIT, Java Script, Eclipse IDE, Firebug, Rally, Selenium and SQL Server 2008
Confidential
RESPONSIBILITIES:
- Performed requirement analysis and apply technical knowledge to design, write, execute, and debug test cases using HP Quality Center and Automation Testing using Selenium
- Developed test plan and test cases by analyzing requirements, design documents and use cases diagrams.
- Verified the dynamic web contents, HTML pages and compatibility with multiple browser versions.
- Prepared test data for testing the application in various test phases.
- Involved in Regression, Functional, Integration, System, Sanity and Database Testing.
- Identified test cases to be automated and executed them in Selenium.
- Created scripts in JavaScript for automation testing in Selenium.
- Performed GUI, Regression, Functionality, positive-negative, data driven testing using Selenium.
- Used HP QC for reporting and tracking defects.
- Wrote and executed complex SQL queries to validate back-end data.
- Generated Testing and Defect Status report using HP QC and communicated to the Project Management Teams.
ENVIRONMENT: Selenium (Selenium webDriver TestNG, JAVA Script), Oracle 10g, Windows Vista, HP QC, XML, Java/J2EE,UNIX.
Confidential, Louisvellie,KY
RESPONSIBILITIES:
- Analyzing Requirements and Test plans for the Project.
- Preparation of Test Cases based on Functional Specifications.
- Setting up Test Data for Test Execution.
- Executed Test Cases and tracked defects using Quality Center.
- Performed Black Box, Functional, System, End to End, Positive / Negative, Boundary Value Analysis, ECP, Regression and GUI Testing of web applications on different browsers (Cross Browser Testing).
- Identified the test cases to be automated and performed data driven testing and GUI Check Points usingQTPand enhanced the overall functionality of the application.
- Checked for navigational flow and broken links using Automatic check points in QTP
- Created Object Repositories.
- Involved in preparation of Traceability Matrix.
- Used Traceability matrix to check all test cases covered as per the business requirement.
- Conducted Regression testing on various builds of the application.
- Coordinated with UAT team by providing them with test cases and test data.
- Prepared Daily Status reports, Weekly Status Reports for clients
ENVIRONMENT: .Net, MS SQL Server 2005, Quality Center, MS-Excel, QTP
Confidential
RESPONSIBILITIES:
- Participated in integration, GUI, System and Functional testing.
- Used TFS (Team Foundation Server) to create new items on Project Basis.
- Used TFS to manage the Business requirement documents for each project.
- Managed different Test documents using TFS.
- Participated extensively in Database testing.
- Tested the ETL extract against the Source and the Target Database.
- Tested the ETL extract against the business merge rules.
- Validated the data merge from the source to the ETL extract.
- Validate the Data transformation from ETL to XML output file and to the Target systems.
- Used SQL navigator for the Data validations.
- Used SQL queries to validate the Data bases.
- After running the ETL scheduler validated the Data properly updated into target tables.
- Participated in functional testing of web enrollment and check those are properly updated in database.
ENVIRONMENT: Informatica Power center, Oracle10g, HP QC, SQL server.
Confidential
RESPONSIBILITIES:
- Involved in identifying Test Scenarios while preparation of detailed Test Cases.
- Manual test cases were created to validate the functionality.
- Documented test cases corresponding to business rules and other operating conditions.
- Involved in executing Test Cases manually & tracking Defects.
- Involved in Regression testing on each build during the various phases of the application.
- Performed Sanity Testing, Functional Testing and Regression Testing.
- Review and execution of test Cases to check the functionality of the application against the user requirements manually.
- Created the Test Data for UAT testing.
- Logged the bugs using BugZilla.
- Updating Weekly status reports.
ENVIRONMENT: .Net, silver light, Share point, Oracle, HP Quality Center, BugZilla