Obiee Data & Reporting Qa Analyst Resume
San Ramon, CA
SUMMARY:
- 13 Plus years of IT experience as QA, which includes Manual Testing, Automation for Functional Testing, Regression Testing in diverse.
- Through understanding of software quality activities throughout the software development life cycle (SDLC) and software testing life cycle (STLC) and knowledge of Testing Methodology.
- Extensive system development lifecycle experience, including designing, developing and implementing test plans, test cases and test processes
- Experience in executing test scripts for Functional with automated HP tools Quick Test Professional (QTP), Win Runner (Record and Playback method).
- Experience in Dataware housing concepts and tools. Involved in the ETL processes where in the organizations were using Informatica tools.
- Executing SQL queries to validate the Data using TOAD, SQL - Developer.
- In HP ALM we create new defect, easy to track the defects by follow bug reports and add your comments after retest and close the defects.
- Defect Management in HP Quality Center 11.0.
- As we do a data set up in the source based on the requirements by using SQL Queries from the logic provided and validating the testing by RDBMS such as Oracle, Teradata
- Involved with the initial phase of writing Technical documentation for the new or enhanced requirements and performing Black box testing, Functionality Testing, Integration Testing, System Testing, Regression Testing, and Database Testing.
- Writing Test Plan, Test Cases by decomposing Business Requirements and developing Test Scenarios to support quality deliverables.
- For a web based testing upon finalizing the requirement and once the build is provided to the testing team we start to executed Test Cases Scenarios, test GUI, System test, Functionality testing for that particular function, Integration testing when multiple modules are joined in one build, Performance testing by validating the run time of the job to capture the data in CDW, Regression testing is carried out when a defect is fixed, Negative and Positive testing created per the requirements, Cross Browser Testing to check the compatibility of the application.
- Using VI Editor in UNIX to a file based on the requirement and executing them using basic commands in UNIX during testing Windows and web based environment.
- Cooperative and understanding in all work based environment even if I have the ability to work independently or as a team Member.
- For any clarification or issues related to the project or personal we have the right to approach the manager or supervisors to resolve them.
- Interact with the team members to discuss the functionality of the requirement and learn new technologies.
- For creating Test Plan, Test Script interacted with the testing team for documenting the system requirements and testing system development.
- ISTQB Certified Tester
TECHNICAL SKILLS:
Operating System: Windows 7, XP, UNIX, MS-DOS, 4690 IBM Ver 6.
Programming Languages: SQL, PERL, PL/SQL.
ETL: Informatica 9.1
Databases: Oracle 11g, Informix, MS SQL Server 2008, SQL Developer 4.0TOAD 12.1, TOAD Data Point 3.4, Teradata SQL Assistant 14.0.1
MSPackages: MS-Word, MS-Excel and MS-Power point.
Automated Testing Tools: QuickTestPro 9.2 Load Runner, Win Runner 7.0.
Defect Tracking & Test: Remedy, HP Quality Center 11.0 (ALM).
PROFESSIONAL EXPERIENCE:
Confidential, San Ramon, CA
OBIEE Data & Reporting QA Analyst
Responsibilities:
- The CCAR project identifies the source systems, and data elements required to move data from source to destination. Involves validation and testing of the Enterprise Data Warehouse in the staging and load for various schedules and source systems of BOW and FHB.
- Interacted with the Business Analysts, developers and OBIE team to gather and understand the requirement for each release.
- Interacted with managers and involved in analyzing system specifications, design, development and execution of test plans and test cases for manual testing.
- As the requirements are finalized we reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.
- Understood the Requirement to prepare the Test Plan.
- As the Test plan is approved we proceed with to prepare the Test Script in ALM.
- Involved in writing SQL Queries using Oracle in validating data into the OBIEE Reporting Dashboard with the Database.
- Reporting Defects as Appropriate.
- Keep a track for executing the test cases and the defects.
- As the project progresses we give status reports to the manager and the stakeholders.
- We need to ensure that the RCA and defect closure process is as rigorous on these items as it is for the main releases.
- Coordinating with Team & developers for defect analysis and their fixes.
Environment: HP Quality Center 11 (Application Lifecycle Management), TOAD Data point 3.4, SQL Developer 4.0, MS Project 2010, MS Visio 2010, Oracle OBIEE 11.1
Confidential, San Ramon, CA
QA Engineer
Responsibilities:
- Involved in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
- Experience with working tools like TOAD, MS SQL Server 2008, SQL Developer, Teradata for creating and executing SQL Queries.
- Coordinating with the Testing team members in preparing the Test cases using excel.
- As a Quality Assurance resource I am involved in Black Box Testing for Functionality testing for that particular function, Integration testing when multiple modules are joined in one build, Performance testing by validating the run time of the job to capture the data in CDW, Regression testing is carried out when a defect is fixed, Negative and Positive testing created per the requirements, to ensure all aspects of the system are functionally correct.
- Writing Test Plans, Test Cases in ALM and gathering requirements and prepared scenarios according to the Functional requirement.
- Backend Testing using TOAD, MS SQL Server 2008, SQL Developer, Teradata to validate the Data.
- As a QA Tester involved in documenting defects, Reporting Defects by communicating with the development team.
- Opened new defects based on the bugs found in the application, Classified them based on the priority and severity in QC.
- Coordinating with the Tester, Developer to review the status of the defect.
- Defect tracking before closure.
- HP ALM we create new defect, easy to track the defects by follow bug reports and add your comments after retest and close the defects and provide the status reports for the test cases and the defects.
Environment: HP Quality Center 11 (Application Lifecycle Management), Informatica 9.1, TOAD 12.1, SQL Developer 3.2, MS SQL Server 2008, Teradata SQL Assistant 14.0.1
Confidential, Bentonville, AR
QA Lead
Responsibilities:
- Interacted with the managers and involved in analyzing system specifications, design, development and execution of test plans and test cases for manual testing.
- As the requirements are finalized we reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.
- Understood the Requirement to prepare the Test Plan.
- As a Quality Analyst the requirement is analyzed to understand the functionality and also the root cause of the defect raised for the functionality of that particular requirement.
- Mapping the requirements with the CCCQ number to track the status of the Requirements.
- Coordinating with the Testing team members in preparing the Test cases.
- Executing Test Cases.
- Involved in Black Box Testing for Functional Testing, Regression Testing.
- As a QA Tester involved in documenting defects, Reporting Defects by communicating with the development team.
- On a daily routine coordinating with the Tester, Developer, Defect Review Board to review the status of the defect.
- Defect analysis and tracking the defect before closing in Quality Center.
- As the project progress providing status reports for the test cases and the defects.
- Report Generation for the Defects in Project and Regression for different Cycles.
- Data transfer through UNIX servers.
Environment: Java J2EE, .Net, C++, UNIX, Linux, 4690 IBM, HP Quality Center, Agile Methodology, Informatica, Black Box Testing.
Confidential, Sacramento, CA
Software Tester
Responsibilities:
- Interact to gathering requirements for each Quality Build
- Writing of the Test Scripts in Quality Center
- Based on the requirement the data set up for the Test Scripts in MS SQL Server 2008
- Once the development is complete we start of testing by executing Test Cases written in HP ALM and raised defect for the failed test accordingly or pass the test.
- Involved in Black Box Testing for Functional testing
- Reporting Defects as Appropriate.
- If there are two resources involved in one project and for some requirement if each of the finds the same issues and discuss before completing initial analysis and avoiding duplicate defects.
- Once the defect is fixed and retested the Defect is analyzed before closing the defect in Quality Center.
- Till the defect is fixed by the development team we do the tracking of the Defects until closure.
- As the project progresses we give the status reports for the test cases and the defects.
- Once the defects are raised in ALM and the defect logging, tracking, and status maintenance are properly carried out with the Deliverables and Report generation.
- Interacted with the team to give status reports to the manager on a daily and weekly basis.
- As the project progresses we do provide Testing Status Reports for the test cases executed, defects raised for the failed test case to the lead and the test manager.
Environment: ASP.Net, Windows XP, Quality Center, MS SQL Server 2008, Black Box Testing
Confidential
Test Lead
Responsibilities:
- Interacted and Gathered requirements updated in the SharePoint Production Issue List before proceeding with the Test plan.
- Preparation of the Test Plan, which specify testing overview, testing approach, testing strategy, roles & responsibilities and scope of testing.
- Preparation & Review of Test Cases for all phases of testing to meet client required functionality.
- Backend Database testing by writing SQL queries in SQL Server to retrieve the required data which displays in the application from the required table by creating the data set up in the source to be captured in the CDW database.
- Involved in Black Box Testing for Functional Testing and Regression Testing
- Selenium IDE is used for the web based testing.
- Documented all related testing documents in the SharePoint to be referred by other members.
- Reporting Defects as Appropriate.
- HP ALM we create new defect, easy to track the defects by follow bug reports and add your comments after retest and close the defects and provide the status reports for the test cases and the defects.
- As the project progresses we provide status reports to the manager on a daily and weekly basis for the test case executed, test cases passed or defects raised for the failed defects.
Environment: Java J2EE, Windows, Quality Center, MS SQL Server 2008, Selenium IDE, Black Box Testing
Confidential
Senior Software Engineer
Responsibilities:
- Reporting Defects as Appropriate.
- If there are two resources involved in one project and for some requirement if each of the finds the same issues and discuss before completing initial analysis and avoiding duplicate defects.
- Defect analysis before closing the defect in QC.
- Keep a track for executing the test cases and the defects.
- Reports are generated by the reporting team as you complete the execution of the Test Cases.
- As the project progresses we give status reports to the manager and the stakeholders.
- We need to ensure that the RCA and defect closure process is as rigorous on these items as it is for the main releases. For instance, there are closed defects assigned to E2E test, there are defects with no RCA or system component, etc.
- Coordinating with Team & developers for defect analysis and their fixes.
Environment: Siebel, Windows, Quality Center
Confidential
Senior Software Test Engineer
Responsibilities:
- Reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the Telecom Application.
- Understanding of software quality activities throughout the software development life cycle (SDLC) and software testing life cycle (STLC) and knowledge of Testing Methodology.
- Have lead team to have a good result for the project and personally.
- With the given requirements in scenarios where we have not the right understanding of the functionality of the requirement have troubleshooted to understand it and test case design skills.
- Ensuring compliance and monitoring quality.
- For the new resource provided training, assistance and guidance to other team members.
- For the new resource and delegating and assigning work as applicable for the bigger projects.
- Regression testing is carried out when the raised defect is fixed and sends to retest to the testing team.
- As the project progress we provide daily project status and report issues to QA Manager.
- Have the knowledge in defect life cycle as we create a new defect and follow the life cycle till the end.
- Designing the test cases for different workflows.
- Scripting in Perl to execute automated test cases in Inbound tool MATE.
- Executing the test cases for each Build using UNIX shell scripting.
- Once the requirement is given to us we do a data set up preparation of test data to test the system from the source to the target database.
- Responsible for ensuring all related activities are performed as required.
- Black Box Testing with System Testing for each new build.
- Involved in Database Backend Testing using SQL queries in Informix as RDBMS.
- As the requirements are finalized we are Involved in Preparation of Traceability Matrix to ensure that all the test cases are Mapped to all the Requirements.
- Load testing was done by giving N number of users to be created overnight and check the status the next day.
- As the testing starts we maintain documentation of test results to assist in debugging and modification of software.
- Analyze test results to ensure existing functionality and recommends corrective action.
- Inbound tool is used to Scripting for Automation and executing through MATE.
- Based on the requirements helped the testing team documenting the system requirements and testing system development.
- As the requirements are properly understood we possess strong analytical and problem solving skills with the ability to move easily between various tasks.
- Don’t have to depend on others to start my work as I am a Self-starter and can work independently to get the job done efficiently in the least possible time
- Various work culture are not comfortable for a human mind but have Detailed and focus oriented with good organizational skills.
- Possess the ability to multi-task in a fast pace environment.
- If the requirements keep changing after the writing of test scripts and has no issues in ability to handle repetitive tasks.
- Have the mind set to learn Quick and able to follow instructions.
- Long or overtime or working additional hours when required.
Environment: C++, HP-UNIX, Remedy, Black Box Testing
Confidential
Senior Test Lead Engineer
Responsibilities:
- Agile methodology is used for this Credit Card Application to do the Testing. working in agile testing environment with frequently changing requirements
- Interaction with the BA, developers in requirement analysis, testing and documentation for application developed in agile environment
- With the involvement of Business, test managers and developers we are involved in analyzing system specifications, design, development and execution of test plans and test cases for manual testing.
- As the requirements are finalized we reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.
- As the Test plan are completed, reviewed and approved by the Managers we are Responsible to write Test Cases and Test Procedures based on the Test Plan
- Designing the test cases for different workflows.
- As the build comes to test we are executing the test cases for each Build.
- Black Box Testing performed business Functional testing and GUI testing.
- If there a defect fixed by the development team and ready to test status we do Regression Testing for each new Build.
- As the project progresses we keep a Tracking defects and reporting bugs using Quality Center.
- In the given SharePoint as we Identify and documented all the defects to ensure application software functionality for present as well as future builds.
- If there is any clarification as we start of testing we are working closely with system analysts and developers.
Environment: ASP.NET, Windows, Quick Test Pro 9.2, Quality Center, Agile Method, Black Box Testing
Confidential
Software Test Engineer
Responsibilities:
- As the requirement is finalized for a project with the help of Business Analyst, Test Managers, Developers we share the Prepared and executed Test Cases for Sales and Distribution module according to the BRD, Technical Specification, Functional Design and Use Case documents, identifying applications functionality, test requirements and coverage.
- Once the requirement is confirmed we start to write the test plan, test scripts and as the developers complete their development, as they give to the test team we start to manually tested the application executing test cases in the Quality center.
- Per the requirements we prepared RTM Document to ensure that all the requirements to the test case are related and had sufficient coverage for through testing and identified the requirements and test cases to be automated.
- Involved in Black Box Testing for Functional Testing
- Keeping a track of the test execution and the defects by being Responsible for reporting, researching and debugging problems found as a result of testing.
- Responsible for ensuring all related activities are performed as required.
- By using multiple browsers to conducted Browser compatibility testing.
Environment: ASP.net, Windows, Visual Safe Source, Black Box Testing