We provide IT Staff Augmentation Services!

Data Warehouse And Obiee Test Engineer Resume

San Diego, CA

SUMMARY OF QUALIFICATIONS:

  • 15 years of experience in client/server and server - side manual/automated software testing.
  • Validated OBIEE 11g front end reports and data in Oracle backed data warehouse.
  • Worked on several areas of software testing such as databases (SQL Server, Oracle, PL/SQL), user interfaces (web pages, forms, reports), ETL data, healthcare medical devices, mobile phones, Perl, C/C++, Java, XML, web services, VMware, Windows, Unix.
  • Developed and executed hundreds of test cases using HP Quality Center for Systems Manager web interface and the User Interface on the display panel for medical devices.
  • Wrote SQL queries for the backend SQL Server 2008 R2 database to verify the contents of database tables and the updates to those tables. Using SQL Server Management Studio, verified completion of database jobs such as backups, purges, integrity checks etc.
  • Developed and tested Forms and Reports using Oracle Developer 2000. Worked with Oracle Utilities such as Toad and SQL *Loader.
  • Tested applications using black box, gray box and white box testing methods.
  • Worked on setting up of work stations from scratch by installing all software components for testing GPS applications. Used and modified Perl scripts for running automated tests.
  • Worked with XML scripts, JUnit framework on Eclipse platform and web services custom actions for testing internet/web applications. Created ‘.properties’ files with input data for testing with XML files and web services.
  • Tested installation and configuration of many applications on Unix and Windows platforms.
  • Gathered and analyzed requirements, identified potential error points and created several test cases and execution scenarios as development/test team member for many projects. Used defect tracking tool Test Director. Familiar with Rational Tools and UML.
  • Performed functional and regression testing using Win Runner and performance testing using Load Runner. Developed Win Runner scripts for areas of automation. Automated part of the testing on Windows and Unix environments using batch files and shell scripts.

TECHNICAL SKILLS:

  • Oracle 11g/10g
  • OBIEE 11g
  • SQL
  • PL/SQL
  • SQL *Plus
  • SQL Navigator 5.5
  • SQL *Loader
  • TOAD
  • Oracle Developer 2000
  • SQL Server 2008 R2
  • SQL Server Management Studio
  • Java
  • Java Servlets
  • Java Server Pages
  • JUnit testing framework
  • Web Services
  • JIRA 6.0/5.0
  • XML
  • HTML
  • WebSphere Application Server 6.0
  • DB2 Universal Database 8.2
  • C/C++
  • Pro *C
  • Cobol
  • Perl
  • Rational Tools
  • UML
  • VMware vSphere 4.1
  • Win Runner 7.0
  • Load Runner 7.02
  • Test Director 7.0
  • HP Quality Center 11.0
  • Unix shell scripts
  • UNIX (HP-UX 11.0
  • Sun Solaris 9/10
  • Red Hat 3.0
  • SUSE 12
  • AIX 5.3)
  • Windows 7.0/2008 R2/2007/2003/XP/98/95.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Data warehouse and OBIEE Test Engineer

Responsibilities:

  • Created damage and total loss insurance claims for testing using Confidential estimating tools.
  • Created test cases in HP Quality Center with the expected values to be populated in the data warehouse for insurance claims to be tested.
  • Created various rules for validating the estimates. Ran estimate checks on claims created in test environments against the rules and generated estimate check data.
  • Validated estimate ETL data after it was populated in various tables in the data warehouse against manually entered values during claim creation process. Wrote several SQL queries and executed them in TOAD to verify data for existing and newly created insurance claims.
  • Verified the user interface layout and the fields for search criteria in OBIEE 11g front end reports. Validated the data displayed in the reports against data in the data warehouse.
  • Opened defects in JIRAs for data discrepancies found in data warehouse or in OBIEE reports. Verified and closed the JIRAs after the issues were fixed.

Confidential, San Diego, CA

Software QA Engineer

Responsibilities:

  • Tested backup and restore functionality of Confidential database backup applications.
  • Created and executed test cases for verifying the backup and restore of complete databases or specific contents of the databases such as selected tables.
  • Wrote SQL queries and executed them in Confidential BTEQ utility to verify that data integrity was correctly maintained in database tables after backup and restore operations.
  • Executed and verified backup and restore functionality from the web browser user interface and from the Unix command line interface.
  • Created databases of different sizes for backup and restore testing using utilities like Data Generator Tool. Populated the tables in databases with appropriate test data.
  • Reported issues found during testing in JIRA tracking tool.

Confidential, San Diego, CA

Software Verification and Validation Engineer

Responsibilities:

  • Gathered requirements from developers and created Test Scenarios indicating functional areas to be tested in ASM web page interface and in backend database. Identified various web page functions to be tested such as generate reports with device status, manage user permissions, add or delete users, import groups, add facilities and IP address ranges etc.
  • Developed test cases with detailed test steps in HP Quality Center 11.0. Each test scenario was translated into many test cases based on the test area and the level of detail.
  • Documented errors found during test case execution along with expected and actual results and failure details using the Serena Business Mashups 2009 issue tracking tool. Executed test cases again to verify that the issues were fixed and closed the trackers.
  • Simulated hospital client/server environments by creating several virtual machines from templates using VMware vSphere 4.1 tools on Windows Server 2008 R2. Deployed ASM builds to server virtual machine and accessed the server from web browsers on client virtual machines. Wrote SQL queries to confirm that the database tables were populated with correct data from predefined data specifications immediately after deploying the ASM sever.
  • Verified using Job Activity Monitor in SQL Server Management Studio that the database actions such as full or differential backups, database purges, old backup removals, integrity checks, email notifications etc were executed correctly.
  • Created several SQL queries joining multiple tables in SQL Server Management Studio to retrieve data from database. Verified that data in reports generated from the web pages matched with the data from corresponding SQL queries. Verified that changes made through the web interface update fields were correctly updated in backend database tables.
  • Developed test scenarios and test cases from requirements for functional testing of Mark IV Syringe Pumps. Tested error/warning messages at boundary conditions such as very high/low infusion rates, syringe level nearing empty, syringe pressure above limit etc.
  • Wrote and executed detailed test cases for testing of User Interface on the display panel for medical devices. Verified that the text on screen was displayed correctly in 20 languages by comparing with the corresponding contents in Language Master Excel file. Tested validation of user inputs to devices at limit conditions such as minimum or maximum values allowed.

Confidential, San Diego, CA

Software Quality Engineer

Responsibilities:

  • Installed all the necessary Perl, USB drivers and other software components on work stations to make them completely functional for running automated tests on GPS builds.
  • Added or modified Perl code as required for automated tests of various GPS modes.
  • Ran tests with simultaneous data or voice calls along with the running GPS applications.
  • Used Confidential eXtensible Diagnostic Monitor (QXDM) to verify that the phones were connected to the network with sufficiently strong GPS signal. Verified that the fixes were generated correctly by GPS applications by making use of Snapper, QPST and QDXM tools.
  • Post processed the results using Analysis and PostProcessing Expert (APEX), analyzed the location and time statistics and documented and reported all out of range results.

Confidential, San Diego, CA

Software Test/QA Engineer

Responsibilities:

  • Compared the timestamps in Star Team repository and in Unix environment and checked that latest versions of forms and reports were deployed in Unix.
  • Examined the code for forms and reports and verified that there was no hard-coding and that test code was removed or commented.
  • For forms and reports modified from previous versions, verified that the screens were appropriately modified and that correct changes were applied in the code.
  • For code changes with which outputs should not be different, ran old versions of programs in oracle 8i and ran new versions of programs in oracle 10g and compared the outputs.
  • Performed functional testing of forms and reports to verify that they were running correctly and were having necessary fields.
  • When hyperlinks were present in the forms, checked that they were working correctly by pressing F8 key from appropriate fields and inspecting the results.
  • Investigated the database tables and views into which data is updated from the forms and from which data is retrieved to the reports.
  • Added new data to database tables using SQL commands in TOAD for data validation tests.
  • Confirmed that the reports were correct reflection of the database by comparing data in reports with data queried from database tables using SQL.
  • Opened defects in Star Team, a defect tracking and code repository tool used by Confidential . Tracked the status of defects and verified them when they were fixed.

Confidential, San Diego, CA

Server-Side Software Test Engineer

Responsibilities:

  • Developed several XML scripts and Java custom actions for test automation of internet applications using web services by taking inputs from ‘.properties’ files.
  • Gathered requirement specifications from developers and managers. Developed user stories with acceptance criteria and side effects through discussion with team members.
  • Created test cases with test procedures based on user stories for assigned features in each release and uploaded them into Confidential Test Depot, a test case management tool.
  • Opened hundreds of defects in QIS Team Track, a defect tracking tool. Tracked the status of defects and verified them when they were fixed.
  • Performed manual testing in detail on Brew Management Server (BMC) web applications to verify that all the internet web pages functionality was working correctly.
  • Deployed new BDS build labels on Unix server and IBM WebSphere Application Server.
  • Verified the entries in database tables as part of test validations by writing SQL queries in SQL Navigator tool.
  • Developed XML scripts for automated read only checkouts of Internet applications and executed them after deployment of new builds.

Confidential, Durham, NC

Software Test/QA Engineer

Responsibilities:

  • Tested successful installation and configuration of DB2 Server 8.2, DB2 Client 8.2, IBM HTTP Server 6.0, IBM Tivoli Directory Server 6.0 and WebSphere Application Server 6.0 on single/multiple/remote (two, three and four) AIX, Linux and Windows platforms.
  • Investigated and analyzed all the potential failure points during installation/configuration/execution of above products and prepared test cases and detailed execution scenarios for capturing those failures.
  • Changed several input parameters (eg: operating system, port numbers) with custom installation and opened defects for the failures (eg: failure to detect and reuse already installed products).
  • Tested SI deployment of software onto several Unix (AIX 5.3, RedHat 3.0, Sun Solaris 9/10, HP Unix 11i, SUSE 8.0) and Windows (Windows XP/2000/2003) platforms.
  • Used JUnit Framework with Eclipse Platform extensively to write and execute the Java code for test scenarios. Validated correct implementation of dependencies and checks (capacity, version, consumption etc) defined on software resources.
  • Created XML Media descriptors that described location of files to be installed and verified their installation on local and remote locations and on removable media (network, DVD etc).
  • Tested the installation process as well as the execution of three types of installed middleware using Platform Installation and Configuration Service (PICS): DB2 Universal Database 8.2 client and server, WebSphere Application Server 5.1 with optional fixpack and IBM Tivoli Directory Server 5.2 (ITDS).
  • Opened installation defects like wrong default target directory specification on Linux, failure to install the products in the specified paths, failure of middleware installation from CD etc.
  • Identified errors in installed software like WebSphere Application Server failing to start on Linux after installation, DB2 instance creation failure after installation, exposed passwords for DB2 Administration Server in flat files etc.

Confidential, San Jose, CA.

Software QA Analyst

Responsibilities:

  • Studied business requirements and identified the links and page layouts to be created to meet these requirements.
  • Specified and tested Java Server Pages to enable implementation of different functionalities.
  • Wrote servlets for background processing for the Java server pages such as database access, discount calculations etc.
  • Tested handling of varying discount processing in the code based on the regions and countries selected. Performed GUI testing.
  • Created and executed automated test scripts using Win Runner for functional and regression testing. Tracked and managed defects using Test Director.
  • Analyzed performance and response times of business transactions in Deviation Authorization tool using Load Runner.
  • Verified security/access to the tool based on role of the user like Approver, Requester etc.
  • Tested the functionality to search for created deviations based on different criteria like Deviation ID, Approval status etc.

Confidential, Salt Lake City, UT

Reports Developer, QA Analyst

Responsibilities:

  • Interacted with clients to gather the requirements. Compiled extracts and feeds of customer transactions as per specifications to facilitate and assist business analysts in their analysis.
  • Created new database system for sales using star schema data models.
  • Extensively wrote Stored Procedures, Packages, Functions and Triggers for extracting data as part of system conversion effort to implement business rules on Sales Data.
  • Created the front-end web application using Java Technologies that accepts the inputs to be stored in the database and retrieves and displays generated reports based on the queries.
  • Used SQL*Loader to load data from flat files to the database tables. Performed backend testing by executing SQL queries to check data table updates after test execution.
  • Automated test scripts using Win Runner for functional and regression testing of the application. Tracked results with Test Director and reported defects.
  • Created Load Runner scripts using Virtual User generator for load performance testing.
  • Designed and maintained data entry screens using Oracle Forms 6i.

Confidential, Washington D.C.

Reports Developer, Systems Analyst

Responsibilities:

  • Was responsible for gathering business process information, reviewing functional requirements and creating technical design documents in a team of four programmers.
  • Developed technical specifications and data flow diagrams that would allow a generic but flexible implementation of the application.
  • Uploaded large, delimited files using SQL *Loader.
  • Was part of the team that developed and tested front-end web applications that accept input values and display generated reports in the browser.
  • Executed regression and data driven testing of the system using Win Runner.
  • Performed load and stress testing using Load Runner.
  • Created complex matrix, master detail, and drill-down reports using Oracle Reports 6/6i.
  • Generated several PL/SQL packages, procedures and standalone backend processes that were called by the front-end query applications developed in Oracle Forms 6i/Reports 6i.

Hire Now