Business Intelligence Quality Assurance

Meghana P Mobile# +1-832-***-****

Senior QA Analyst ***********@*****.***

PROFESSIONAL PROFILE

Overall 8+ years of working experience in Software Quality Assurance with Manual, Web Application, ETL/Data warehouse, Database, Business Intelligence reports testing, User Acceptance testing.

Good knowledge and working experience in Data Warehousing, ETL process.

Expertise in different phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) including Agile Methodology/SCRUM and Waterfall methodologies.

Expertise in OBIEE, Tableau, Power BI report validation.

Extensive experience in Data Quality Management testing.

Extensive knowledge in data verification process, and sample comparisons based on transformation rules.

Extensive ETL testing experience using Oracle, Informatica, Netezza, iCEDQ, Azure Databricks, Storage containers.

Experience in validation of data transformation on Azure Cloud Platform.

Experience in ETL testing process consisting of data transformation, mapping, conversion.

Working experience on tables which contains huge data in different layers such as staging, dimensions, facts, and aggregates.

Experience in extraction of data from various data sources like databases, flat files.

Experience in validations of reports against table data and requirements.

Experience in System Upgrade testing, API Testing.

Worked on databases such as Oracle, MS SQL Server, Teradata and Netezza.

Hands on experience using HP Quality Centre/ALM, Jira, Azure DevOps.

Experience in testing Salesforce, Dynamic 365.

Experience in End-to-End Testing.

Ability to write and understand complex SQL queries.

Ability to understand complex Informatica mappings.

KEY SKILLS

ETL process, Data Warehouse, Data Analysis, Data integration, Data validation, Test Planning, Test design, Test review, Test execution, Test closure, Defect Analysis, Defect triage, Product testing, Business Intelligence testing, Report testing, Upgrade testing, Integration testing, Database testing, Data Migration testing, Performance testing, Web Application testing, Unit testing, Regression testing, User Acceptance testing.

TECHNICAL SKILLS

Tools: HP ALM, Informatica, Azure Databricks, Storage container, Azure DevOps, Postman, QuerySurge, iCEDQ, BI Validator, Jira, Salesforce, Dynamic 365

Programming Languages: C, C++, SQL

Operating Systems: Windows

Databases: Oracle, SQL Server, Teradata, Netezza

Reporting Tools: OBIEE, Tableau, Power BI

Methodologies: Agile and Waterfall

MS-Office: Outlook, Excel, Word, and Power Point

WORK EXPERIENCE

Client: ConocoPhillips, Houston, TX July 2023 – Present

Role: Senior QA Analyst

ConocoPhillips Company is an American multinational corporation engaged in hydrocarbon exploration and production. It is based in the Energy Corridor district of Houston, Texas.

Responsibilities:

●Working on Requirement Analysis and Review.

●Working on Test Planning, Test design, Test strategy, Test case preparation.

●Validating data migration to Azure Cloud using ETL process.

●Data Analysis using Power BI, OBIEE, Tableau reports.

●Validating Applications against requirement documents and source.

●Verifying data migration by automating test cases in iCEDQ.

●Analyzing transformation logics using Informatica.

●Validating data in Oracle, SQL Server databases.

●Web application testing based on requirement documents.

●API Testing using Postman.

●Validating data in Salesforce, Dynamic 365.

●Working on Change requests and Enhancements.

●Working on Test Data creation.

●Preparation, maintenance of test cases in Azure DevOps.

●Monitoring defect lifecycle and coordinating with development team on bug resolution.

●Working on Regression and User Acceptance testing.

●Coordinating with onsite, offshore, cross functional teams and stakeholders.

●Working in Agile methodologies and sending Daily status reports and weekly status reports to stakeholders.

Client: Canadian Imperial Bank of Commerce September 2021 – April 2023

IBM, Hyderabad, India

Role: QA Lead

Canadian Imperial Bank of Commerce is a Canadian multinational banking and financial services corporation headquartered at Toronto, Ontario.

Responsibilities:

●Worked on Test Planning, Test design, Test strategy, Test case preparation.

●Worked closely with development teams to make sure that required test environment and data is ready before commencement of testing phase.

●Tracked status of box jobs and reporting failures to development team.

●Verification of error files created in Virtual machines.

●Validation of data migration for large scale systems.

●Verification of data in Power BI, Tableau reports.

●Verification of data by automating test cases using iCEDQ, Query Surge.

●Validation of data during Informatica upgrade.

●Preparation of STTM, ETL specification documents using Informatica mappings.

●User Interface testing based on requirement documents.

●Prepared, maintained test cases in ALM, Jira.

●Prepared and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.

●Monitored resolution of defects, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.

●Completed pre-implementation testing for new system modifications to assess potential impacts.

●Collaborated with developers, and product owners to stay current on product features and intended functionality.

●Coordinated with offshore, onsite and making sure to deliver products on time.

●Gathered data on integration issues and vulnerabilities, reported findings and recommended improvements.

●Handled defect triage calls with developers and stake holders.

●Sent Daily status reports and weekly status reports to clients.

●Worked closely with business analysts to understand requirements.

●Prepared test closure documents for client review.

Client: Gilead Sciences Inc April 2018 – September 2021

Cognizant, Chennai, India

Role: ETL QA Analyst

Gilead Sciences, Inc is an American biopharmaceutical company headquartered in Foster City, California, that focuses on researching and developing antiviral drugs.

Responsibilities:

●Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.

●Extensively used SQL queries for data validation and backend testing.

●Validated claims, EMR data files from sources to make sure correct data has been captured and loaded to the target tables.

●Written and executed database queries.

●Created expected results by executing queries according to test conditions.

●Performed validation on data developed using Informatica and Teradata.

●Performed data validations on ETL, and BI systems.

●Validation of data transformation on Azure cloud Platform.

●Validation of Power BI Report data against table data.

●Worked on FDA Sentry workflow creation and analysis.

●Raised defects in HP ALM where discrepancy found in database and reporting it to onsite development team.

●Guided new resources to make them familiar with project work.

Client: Biocon, Bangalore, India April 2016 – March 2018

Role: ETL QA Analyst

Biocon Limited is an Indian biopharmaceutical company based in Bangalore. It manufactures generic active pharmaceutical ingredients that are sold in approximately 120 countries including the United States and Europe.

Responsibilities:

●Preparation of Test Cases based on Requirement Documents.

●Data and functionality comparison between base and upgraded applications.

●Data validation and backend testing using SQL.

●Validation data files from source to make sure correct data has been captured and loaded to the target tables.

●Written and executed database queries.

●Performed data validations on ETL and BI systems.

●Validation of data in OBIEE, Power BI and Tableau reports to make sure the reports are generated as per the requirements.

●Creation of OBIEE, Power BI and Tableau reports.

●Raised defects in HP ALM where discrepancy found in database.

●Tested defect fixes and performed regression testing.

EDUCATION

Bachelor of Technology in Electronics & Communication Engineering

Lovely Professional University, India

CERTIFICATIONS

Microsoft Certified Azure Fundamentals

Contact this candidate