We provide IT Staff Augmentation Services!

Bi Quality Engineer Resume

Cambridge, MA

SUMMARY:

  • A well - versed ETL & Big Data Quality Analyst with 14 years of experience in Banking, Finance, HealthCare Insurance, e-Governance, and Pharma projects
  • Hands-on experience in Data Warehouse, ODS, Data Migration and Data Lake (HDFS) Testing with expertise in troubleshooting SSIS packages, DataStage and AutoSys Jobs
  • Developed complex SQL queries as part of data validations like Daily/Delta loads, transformation logic, and duplicate/null/truncation checks
  • Hands-on experience in SSIS, SSMS, TOAD for Oracle, SQL-Developer, Visual Studio and Big Data Cloudera (HUE) tools like HIVE, and Impala
  • Knowledgeable in troubleshooting Autosys jobs that call HIVE queries and Spark actions using Oozie
  • Experience in Cognos & Sisense based BI testing and have exposure to Tableau & MicroStrategy Reporting tools
  • Adhered to Data Governance and Data Quality metrics throughout the EDW and in source systems & downstream APIs
  • Proficient in Agile methodologies and experience in DevOps and CI/CD models leveraging tools like GitHub, Jenkins, JIRA, & Confluence
  • Experience in Sprint backlog management, grooming user stories, & Retrospective sessions
  • Profound knowledge in STLC and defect life cycle. Designed Test Plans, Test Strategies, & Test Cases, and Summarized Test Coverage and Defect Summary Reports.
  • Knowledge in test automation tools like Selenium & UFT and experience in test management tools like ALM, and Rally
  • Well-versed in effort estimation and process documentation like IQ/OQ, Risk Assessment plan, Artifact Generator report, DRE, and Traceability Matrix
  • Self-motivated and quick learner of new concepts and techniques with effective communication

TECHNICAL KNOWLEDGE:

Cloud Integration: Microsoft Azure, AWS & Bigdata HDFS

ETL Tools: SSIS, DataStage8.0, and IDQ

Testing Tools: HP ALM 11, QuickBase, and Rally

Automation tools: HP UFT11.5, & Selenium 3.9

Scripting/Programming: PL/SQL, VB script, Apex, & Linux commands

Utility Tools: TOAD, SSMS, Visual Studio, HUE (Hive/Impala/Oozie), Tectia & Putty

RDBMS: MS SQL Server and Oracle 11g

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

BI Quality Engineer

Responsibilities:

  • Developed SQL scripts using SQL Developer, and Management Studio tools to validate the data flows among source (LIMS1.0), staging (SQL Server) and target (LIMS2.0) databases.
  • Executed and troubleshooted SSIS packages using Microsoft Visual Studio
  • Evaluate SPROCS those generate and process XML files to be loaded into LIMS2 server.
  • Validating transformation logic, performing row-count/ duplicate /null checks, and comparing schemas & data across source, staging & target servers as per business rules and entity mapping docs
  • Performed SQL query tuning by reviewing SPROCs and views for ‘NO LOCK’ hints and checking Indexing needs
  • Prepared test data in source systems (F1Cdx/FACT/F1H) to evaluate In-flight scenarios and First/Regular Delta scenarios in QA and Staging environments.
  • Authoring EPIC Stories and Test Cases using qTest, JIRA and GitHub tools and there by preparing Artifact Generator report and Traceability Matrix.
  • Addressed several (QAgile process) audit non-compliances in executing Installation Qualification, Operational Qualification, Data Migration & Risk Assessment Plans
  • Work towards maintaining test Automation Pyramid and at the same time ensuring Test automation coverage.
  • Identify and report non-compliant stories/defects and ensure all issues are addressed complying with the project plan.
  • Be the Quality Advocate and participate actively in technical and process discussions like Definition of Done (DoD), Architecture, Automation, and DevOps strategies.

Confidential, Boston, MA

ETL QA Lead

Responsibilities:

  • Testing data flows using querying tools like TOAD, SQL Developer, & HUE and evaluating corresponding Bigdata HDFS files using Hive, Impala, & Putty scripts
  • Triggering Autosys and DataStage Jobs and monitoring logs, workflows, & Sqoop/Shell actions using Oozie Editor (/workflow dashboard)
  • Reviewed Sqoop & Spark actions to ensure proper sourcing of data into Data Lake as part of test execution
  • Involved in reviewing Test Plans which included test deliverables, features to be tested/not tested based on BRD & Acceptance Criteria
  • Involved in Creating the Business Assurance Strategy, Test Strategy & Test Completion Documents
  • Created Test Cases according to the Business requirements and ensured that all the positive and negative scenarios are covered

Confidential, Fort Worth, TX

QA Lead

Responsibilities:

  • Single point contact as Quality Analyst for Measure Builder, ETL and Sisense Reporting projects
  • Designed and successfully executed Test Plan, Test scenarios, and Test Cases for Measure Builder ETL scenarios
  • Extensively worked on Sisense Reports using SQL queries, and visualization techniques
  • Validated and troubleshooted SSIS packages and Stored Procedures as part of ETL testing
  • Performed data validations like record count / Schema comparison / Null & Duplicate checks on all ETL/SSIS packages that deal with the data flows among source, staging and downstream APIs
  • Performed end-to-end testing on MDS package by validating transformation logics and daily/delta loads
  • Performed cloud (Azure) compatibility testing for MDS and Measure Builder whenever there is a patch or upgrade in Microsoft Azure platform
  • Extensively coordinated with Developers, Business Analysts and managed offshore team
  • Groomed user stories and managed sprints with the help of Rally tool
  • Involved in Impact analysis, effort estimation and managed sprint burndown chart
  • Prepared Traceability Matrix and updating the metrics dashboard at the end of each sprint

Confidential

ETL Test Lead & Scrum Master

Responsibilities:

  • Throughout the project in various iterations & Sprints I conducted System Integration Testing
  • Built complex SQL queries to validate transformation logic, & aggregations
  • Prepared Test Plan and Testing Strategies for Data Warehousing system Confidential
  • Extensively interacted with developers, & Business Analysts to understand requirements
  • Involved in writing test cases in Quality Center 9.0 and 11.0(ALM)
  • Validated complex ETL mappings, metadata and reusable transformations for daily & delta loads.
  • Extracted data from various sources like Oracle, flat files, iSeries and DB2 servers using DataStage / SQL jobs and written SQL queries for the same as part of validations.
  • Involved in validation of upstream applications like Dashboards and Cognos Reports
  • Participated in Story grooming & Retrospective sessions, and in project status meetings
  • Prepared QA Sign-off Reports with details of test execution, test coverage and defect summary.

Confidential

Sr.QA Analyst & Salesforce Admin/QA

Responsibilities:

  • Worked on Security settings like Profiles, Permission Sets, OWD, Sharing rules
  • Validated Workflow Rules, Upload Process, Process Builder, and Assignment & Escalation rules
  • Reviewed Test Case documents designed by test analysts
  • Coordinated with Developers, Business Analysts and offshore testing team
  • Authored SQL scripts to validate transformation logics & aggregations and to cover the scenarios like checking duplicates, null values, truncated values
  • Involved in Test Environment setup with all hardware and software needs
  • Validated data loaded by Data Loader jobs in Salesforce
  • Prepared Test Data using SQL scripts based on Metadata & design docs

Confidential

QA Analyst

Responsibilities:

  • Developed test cases based on test matrix including test data preparation for Data Transformations, Data quality, Performance and scalability.
  • Developed SQL queries /scripts to validate duplicates, null values, truncated values and ensuring correct data aggregations.
  • Performed Count Validation, Schema and Transactional Data Quality Validation with extensive SQL querying on Staging, Data warehouse and Data Marts.
  • Ensured Error logs and audit tables are generated and populated properly
  • Executed regression test suites using UFT's Keyword driven and Data driven frameworks
  • Extensively worked on UFT Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.)
  • Acted as single point contact for migration of Cognos reports to MicroStrategy reports
  • Executed and troubleshooted SSIS packages and reported datatype & casting related issues as part of batch loading of data

Confidential

Sr. QA Analyst

Responsibilities:

  • Developed SQL Queries/Scripts to validate Data migration scenarios (from MS Access and flat files to SQL Server 2005)
  • Developed Test Cases and SQL Queries to perform Data upgradation scenarios (from SQL Server 2005 to SQL Server 2008)
  • Authored and reviewed Test Cases based on the Use Case documents
  • Involved in Test estimation and impact analysis; Managed Defect Reporting & Status
  • Attended HLD/LLD walkthroughs for thorough understanding of business requirements

Confidential

QA Analyst

Responsibilities:

  • Authored and reviewed Test Plan and Test Cases
  • Involved in writing complex SQL scripts to validate various stages and sub reports of Funnel
  • Defect Management - Reporting bugs and tracking till its closure
  • Attending HLD/LLD walkthroughs for thorough understanding of business requirements

Hire Now