We provide IT Staff Augmentation Services!

Etl/qa/ Bi Tester Resume

Denver, CO

SUMMARY

  • Around 9 years of experience in the IT industry as Software Test Engineer & Quality Analyst.
  • 7 Years of IT experience in Business Intelligence, UI & Automation Testing, with 1 year of lead role.
  • Experienced in various aspects of Quality Assurance like Manual Testing, Quality Checks, Test Plan and Test Case preparation.
  • Highly Experienced in automation testing using Selenium, Protractor & TestNG & Cucumber.
  • Highly Experienced in Rest API testing using SOA Test, REST - assured & Postman.
  • Experienced in testing Angular applications using Protractor.
  • Created reusable automation frameworks using Appium for mobile automation.
  • Proven ability to independently drive projects & work collaboratively across teams.
  • Experienced on working with small to large sized projects from requirements gathering to product release, including well rounded testing skills with a firm understanding of Functional, System, User Acceptance and Regression Testing.
  • Experienced in creating detailed test scope, test plan and test cases/scripts utilizing functional and technical documentation.
  • Excellent working knowledge of System Development Life Cycle SDLC, Software Testing Life Cycle STLC and Defect Life Cycle.
  • Experienced in Functional testing, System testing, Application testing, Performance testing, Load testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
  • Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports, Test Summary report.
  • Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and Rational Clear Quest.
  • Expert in writing complex SQL queries for back-end and Reports data validations.
  • Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus and SQL Developer.
  • Have tested several complex Reports generated by IBM Cognos, Business Objects, including Dashboards, Summary reports, Master detailed, Drill down and Score cards.
  • Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents.
  • Experience on UNIX commands for file validation.
  • Experience in Data Analysis, Data Cleansing Scrubbing, Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
  • Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools.
  • Have experience in testing reconcile initial and delta daily loads.
  • Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
  • Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
  • Knowledge on the phases of agile methodology and scrum Methodology.
  • Excellent interpersonal, communication, documentation and presentation skills.
  • Develop testing solution that focuses on automated testing and integrates with the CI environment. Work in conjunction with the Business Analysis and Development teams to ensure that applications meet requirements and are of high quality.
  • Experienced in working with epics, user stories, defects & test cases in JIRA in various Agile projects.
  • Ability to map test cases to business requirements and ensure software quality and usability requirements
  • Worked on collaboration within multi-cultural team dynamics across multiple time zones for support of global initiatives.
  • Experienced in working with waterfall & agile teams.
  • Strong influence and leadership skills.
  • BI experience in various roles such as admin, designer, programmer for SAP Business Objects suite.
  • Experience in Business Objects XI R2, R3.1 and XI 4.0 Administration, Migration and Development
  • Familiar with data visualization and data analytics tool like Tableau.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall

QA Tools: Selenium Web Driver, TestNG, TFS Team, Foundation Server

BI/Reporting Tools: Business Objects, MicroStartegy, Crystal Reports, SSRS.

SAP tools: SAP Business Objects Business Intelligence XI 4.0, SAP Business Objects Business Intelligence 3.1

Defect Management Tools: Microsoft Test Manager (MTM), HP ALM 9.1/10.0/11.

Test Management Tools: Microsoft Test Manager, HP ALM 9.1/10.0/11

Languages: C, C++, Java, HTML, SQL, Visual Basic.

Databases: Oracle, SQL Server 2005, MYSQL, MSSQL, Teradata

Web Technologies: HTML, DHTML, Java Script.

Operating System: WIN 98/NT/2000/XP/7/10.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

ETL/QA/ BI Tester

Responsibilities:

  • Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
  • Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
  • Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
  • Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
  • Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
  • Experience in manual testing which involves web-based application testing for provider and claims system.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Tested the ETL mappings from Source to Target.
  • Written test cases for checking the populated data correctly into fact and dimension tables.
  • Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
  • Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
  • Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
  • Coordinated with development team in system integration test and services level unit testing.
  • Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
  • Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
  • Extensively used SQL Queries to verify and validate the Database Updates.
  • Actively participated in creating requirements Traceability matrices and Test plans
  • Prepared test requirements, test plan approach document and test cases.
  • Performed Unit and functional testing for all the Mappings and Sessions.
  • Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: Informatica 9.1, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008)SQL server SSRS (2008), PL/SQL, Toad, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, AutosysUNIX, IBM AIX 6.1, Shell Scripting, Windows server

Confidential, Denver, CO

BI Quality Engineer

Responsibilities:

  • Involved to create Business Risk Levels to determine Test Priorities.
  • Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, involved in both Manual and Automation Testing.
  • Performed Regression testing using Test Director.
  • Extensively used SQL Queries to verify and validate the Database Updates.
  • Used Test Director a workflow automation tool for defect tracking and product automation.
  • Created User Defined Functions and procedures in Test Director Library to re-use them in different tests.
  • Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
  • Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
  • Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
  • Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
  • Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
  • Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
  • Responsible for Reviews and documentation for reporting the status to the project manager.
  • Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
  • Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment: Informatica 8.1, Test Director 8.0, Win Runner 5.0, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Confidential, Denver, CO

QA Tester/Backend Tester/Automation Tester

Responsibilities:

  • Interacting with Business Analysts for Business Requirements, testing scope reviews, inspections and test planning.
  • Designed DVO informatica test cases for source and target Database validation.
  • Prepared Tractability matrix and prioritized test cases.
  • Involved in creating Test Plans, Test Scenarios, Test Scripts based on business Requirements, Use cases and Functional Specifications in Test plan tab of Quality Center tool
  • Create and maintain a Requirements Traceability Matrix
  • Performed extensive Data Integrity testing by executing SQL Statements on Oracle SQL database
  • Coordinated with the Developers regarding the Defects raised and Retested them against the application.
  • Developed and executed automated test scripts in Informatica DVO
  • Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
  • Wrote and executed complex SQL queries including JOINS to validate Back-end data.
  • Tested reports developed by Business Objects Universes for both Adhoc Canned Reporting users of Business Objects XI R3.1
  • Experience in Testing data conversions and transformations.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Prepared extensive set of validation test cases to verify the data
  • Performed Defect Management by prioritizing the issues and communicated the issues to the developer.
  • Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project
  • Checking the integrity of UI data with the database using SQL queries, checking executing of stored procedures with the input values taken from the database.
  • Executed the Test cases, Test Scenarios in Test lab tab of Quality Center.
  • Worked with data reconciliation for the entire data migration project for both target system and rejected re-cords.
  • Created Test metrics and participated in status meetings and reported the progress to the manager.

Environment: Informatica DVO, Oracle 10g, SOAP, SOAPUI, Web Services, Business Objects, fToad,DB2, Mainframe, AS/400, MS OfficeSQL Query Analyzer, UNIX, Clear Quest, UNIX Scripting.

Confidential

Test Lead

Responsibilities:

  • Involved in test plan, test strategy preparation, test scenarios & test summary review.
  • Participated & conducted project planning, product demo/reviews, bug triage and walk-through meetings.
  • Experienced in working with epics, user stories, defects & test cases in JIRA
  • Develop UI Automation Test Suites using Selenium, Protractor, TestNG & Cucumber.
  • Worked on REST API test automation using SOATest, REST-assured & Postman.
  • Worked on integrating automation test suites with Git & Jenkins for CICD implementation.
  • Created reusable automation framework using Appium for mobile automation.
  • Provide daily updates on standup calls.
  • Manage user stories, defects & tests cases in JIRA.

Confidential

Business Objects Developer / QA Lead

Responsibilities:

  • Involved in test plan, test strategy preparation, test scenarios & test summary review.
  • Participated & conducted project planning, product demo/reviews, bug triage and walk-through meetings.
  • Experienced in working with epics, user stories, defects & test cases in JIRA
  • Contributed actively in all Agile ceremonies
  • Closely worked with business teams on User Acceptance testing (UAT)
  • Good Understanding of SOAP and Restful Web Service/Web API testing
  • Have been a part of universe merging (Included joins, created contexts and aliases to resolve loop
  • Created reports and tested for universe merging.
  • Created BO reports based on new universe created after universe merging.
  • Analyzed queries in Teradata.
  • Prepared inventory and necessary documents for the project
  • Involved in testing various reports.
  • Prepared test cases for various applications, universes and reports.
  • Involved in Assessment, Planning, Migration, Validation
  • Finding the Gap/Impact analysis in the existing system
  • Testing & validating the migrated contents
  • Server setup, Administrating BO XI servers, Securities setup & content management plan.
  • Done quality assurance tests on the SIT environments for the connected systems in scope
  • To advise on test environments ‘setup
  • Reviewed the SIT test cases for GRP related to the connected systems to confirm that ownership of text execution is assigned correctly
  • Carrying out file loading in relevant systems, checking whether the files have loaded correctly and then feeding the results and test execution evidence back to GRP Project Team, along with any errors and record counts or other file statistics that were available as part of the load.
  • Monitoring the ETL Jobs and documenting their details on a daily basis.

Confidential

Business Objects Data Service Admin

Responsibilities:

  • Analyze business requirements and functional specifications, and develop test plan according to the functional specifications.
  • Monitoring the ETL jobs and documenting their details on a daily basis.
  • Contacting team members or other teams in case of issues in the jobs like incorrect file, database issues, server issues.
  • Worked on the change requests like adding new columns, its mappings in the ETL job.

Hire Now