Data Quality Analyst Resume
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