We provide IT Staff Augmentation Services!

Data Quality Analyst Resume

5.00/5 (Submit Your Rating)

Washington, DC

SUMMARY:

  • Software Test Engineer with experience in testing web based and client server applications on various domains such as Financial and Health Care.
  • I have experience working on Windows, Unix and Linux platforms.
  • I am well versed in automating web applications using Selenium, Cucumber and UFT and creating test frameworks from scratch.
  • I also have extensive experience building API test suites.
  • In addition to that I have extensive experience in ETL/Data warehouse backend testing and Business Intelligence reports.
  • Extensive knowledge of Software Development Life Cycle (SDLC), Software Development Methodologies and Software Test Methodologies.
  • Excellent analytical skills for understanding the business requirements, and design of the application.
  • Experience in working with V - Model, Agile-Scrum, Agile-Kanban and Waterfall development methodologies.
  • Expertise in defining and developing quality assurance test plans and test cases by analyzing business/technical requirements, system design documents and use case documents.
  • Effective in using QA tools including bug/defect tracking.
  • Self-starter with strong work ethic and skills in client relationship, time management and ability to adapt and learn quickly.
  • Expertise in developing test scenarios, preparing test data, executing test scripts, linking requirements to test cases, creating bug documentation, and reporting test summary.
  • Expertise in testing and querying RDBMS such as Oracle, MS SQL server, using SQL, PL/SQL for data integrity.
  • Experience in building customized test frameworks to test Web Applications.
  • Develop Test Suites and integrating them into a DevOps pipeline
  • Expertise in unit test frameworks such as TestNG, NUnit and Junit.
  • Experience in Metadata and Star schema as well as Snowflake schema.
  • Expertise in creating scripts and stored procedures to test ETL data for ETL mapping rules and functionality of various transformations and data marts.
  • Experience in creating Data Driven, Keyword Driven and Hybrid Frameworks.
  • Capable of interpreting and transforming data models, business use case diagrams, environment and data needs into testing deliverables.
  • Solid Experience in Automation Testing using Selenium, Quick Test Pro, Cucumber and Quality Center.
  • Experienced in database testing using, Oracle, DataGrip, Squirrel, SQL Server.
  • Ability to work independently or as a member of a team successfully.

TECHNICAL SKILLS:

Software Testing tools: HP ALM, JIRA, Quality Center, Quick Test Pro, Selenium WebDriver and Grid, Junit, TestNG

Section 508 Compliance: Web Accessibility Tool, JAWS

Scripting Languages: VB script, JAVA, SQL, PL/SQL

Database: SQL Server, Oracle, Toad, PostgreSQL, MongoDB

Operating Systems: Window, Unix, Linux

Databases: MS SQL Server, Oracle, DB2, Squirrel, DataGrip

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Quality Analyst

Responsibilities:

  • Build a customized test framework to automate the front end using Selenium.
  • Used TestNG and JUnit to build a regression and an end to end test suite.
  • Integrate the test suites to a DevOps pipeline.
  • Create jobs to trigger the test suites in Jenkins.
  • Used Postman to create an API test suite.
  • Automated the API suite using REST Assured library.
  • Validate tables and ETL in data warehouse
  • Prepared and executed test cases to test Business Intelligence reports on dashboard.
  • Develop and execute automated test cases to validate HTML and CSV statements against database.
  • Involved in comprehensive Functional testing of systems in UAT environments.
  • Responsible for data integrity across data warehouse including Fact, Dimension and Staging tables.
  • Worked closely with developers and business analyst to analyze the business requirements and functional specifications.
  • Parsed HTML document and validated data displayed on statements with queried result from Database using Jsoup and stored test results in DB.
  • Performed system testing for the transactional system to insure integration between various application to process royalties.
  • Involved in developing and executing test cases for UAT to check validity of transactions in main application.
  • Documented queried test results along with all test variables and scenarios.
  • Validated Dashboard reports in BI to ensure they met business requirements and data quality.
  • Wrote complex SQL queries to test data integration and perform Database testing for the Application.
  • Used JIRA for Sprint planning, documenting test results and creating defects.
  • Perform System testing, Integration testing, and Regression testing.
  • Analyzed Source Systems, Staging Area, Fact and Dimension tables in target Data Warehouse.
  • Last point check for all developments to ensure quality of data, ETL, reports and tables prior to deployment to production.

Environment: JIRA, Toad, pgADMIN, SQL Server, JAVA, Oracle, Selenium, Java, Junit, TestNG, Postman HTML, XML, DataGrip, Pentaho

Confidential, Alexandria, VA

Software Test Engineer

Responsibilities:

  • Involve in Quality Assurance (QA) reviews, identify gaps and provide recommendations to ensure that software/system comply with quality and standards.
  • Apply strong organizational, time-management and planning skills to deliver the release on time despite intense pressure and aggressive timelines.
  • Used TestNG and JUnit to build a regression and an end to end test suite.
  • Integrate the test suites to a DevOps pipeline.
  • Create jobs to trigger the test suites in Jenkins.
  • Reporting of defects in Rational Manual Tester and representing defects in defect review meeting on daily basis.
  • Involved in comprehensive Functional testing of systems.
  • Prioritize the testing of critical test cases over others based on feedback from the requirements gathering meetings.
  • Interact with developers and business analyst to analyze the business requirements and functional specifications.
  • Extensively perform testing activities using HP ALM/Quality Center.
  • Perform functional decomposition of requirements for developing test cases.
  • Develop and execute automation Regression testing using Selenium.
  • Perform data driven testing to validate the components displayed on the website using Selenium.
  • Created Data Driven and Functional Driven Framework in Automation using Selenium.
  • Used Junit and TestNG testing Framework as a test runner with Selenium.
  • Write SQL queries to test data integration and performed Database testing for the Application.
  • Generate test cases and traced them to the relevant use cases.
  • Work with Users and Business Analysts to define and design test scenarios and test data.
  • Use JIRA for bug tracking and reporting, also followed up with the development team to verify bug fixes and update bug status.

Environment: HP ALM, Windows, JAWS,WAVE, SQL Server, JAVA, Oracle, QTP, Selenium

Confidential, Reston, VA

Quality Assurance Analyst

Responsibilities:

  • Coordinate and Facilitate software life cycle milestone reviews
  • Provide guidance to project managers, business owners, development team and subject matter experts to resolve the outstanding issue and action items are taken in the review meeting.
  • Worked closely with development team, testing team, 508 compliance team, IT project managers, business system owners to ensure successful high quality release.
  • Prepared approval certification and summary report for every release based on meeting discussion.
  • Involved in Section 508 Independent Verification and Validation (IV&V)
  • Participated in cross-functional design meetings with business units to ensure quality.
  • Conduct requirements walkthrough with the Users, Development and Project Management and Testing Team.
  • Work closely with business owners, development team, testing team to perform redlines of documentation, accuracy of technical content and test verification of technical processes.
  • Participate in various meetings and discussed Enhancement and Modification requests.
  • Use Quality Center to manage requirements and traceability matrix.
  • Performed data-driven tests by passing different sets of data and checked whether the information entered is updated into the database.
  • Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
  • Communicated with Application Developers, Project Managers and other Team Members on Application testing status on an ongoing basis when necessary.

Environment: HTML, XML, IE, MS office, Web Accessibility Tool, PDF Creator, JAWS

We'd love your feedback!