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 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. Seeking a technically challenging position where I can utilize my skills and expertise and be a part of a successful team.
• Extensive knowledge of Software Development Life Cycle (SDLC) and Software Test Methodologies.
• Excellent analytical skills for understanding business requirements and applicationdesign.
• 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.
• Expertise in testing and querying RDBMS such as Oracle, MS SQL server,PostgreSQL, MySQL, Redshift using SQL, PL/SQL for data integrity.
• Experience in building customized test frameworks to test Web Applications.
• Developing and integrating Test Suites into a DevOps pipeline.
• Expertise in unit test frameworks such as TestNG and Junit.
• Expertise in creating scripts and stored procedures to test 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 setup and test data requirementsinto testing deliverables.
• Solid Experience in Automation Testing using Selenium and Cucumber.
• Experienced in database testing using Oracle, DataGrip, Squirrel, SQL Server, Informatica DVO.
• Ability to work independently or as a member of a team successfully.

TECHNICALSKILLS:

Software Testing tools: JIRA, Selenium, Junit,Browserstack,TestNG, Informatica DVO

Section 508 Compliance: Web Accessibility Tool, JAWS

Scripting Languages: JAVA, SQL, PL/SQL, Spark

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

Operating Systems: Window, Unix, Linux

Cloud Computing: AWS services (EC2, S3, EMR, RDS), Microsoft Azure

PROFESSIONALEXPERIENCES:

Confidential, Washington, DC

Responsibilities:

• Worked with AWS services including Redshift database, S3 buckets and EC2 instances
• Experience working with Spark, Hive data warehouse.
• Worked on end-to-end QA for data warehouse and data mart.
• Created jobs to trigger test suites in Jenkins.
• Experience working with Zeppelin notebook, PL SQL, Spark, Java and Scala.
• Was responsible for masking production data and deploying it in working environment.
• Experience working with multiple databases including SQL server, MYSQL, Redshift, Oracle.
• Created an automated QA framework to validate reports against database using Selenium and Java.
• Generated test data for report development and data requirements.

Environment: JIRA, SQL Server, Selenium, Java, Junit, Postman, HTML, Json, PostgreSQL, Amazon Redshift, Spark, Zeppelin notebook, Bitbucket, AWS, BrowserStack.

Confidential, Washington, DC

Responsibilities:

• Built 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.
• Created an API test suite using Postman and REST Assured library.
• Validated tables and ETL in data warehouse.
• Prepared and executed test cases to test Business Intelligence reports and dashboard.
• Developed and executed automated test cases to validate HTML and CSV statements against queried database result sets.
• Involved in comprehensive Functional testing of systems in UAT environments.
• Responsible for data integrity across data warehouse including Fact, Dimension and Staging tables.
• Developed and executed automated test cases to validate HTML and CSV statements against queried database result sets using jsoup and stored procedures.
• Documented queried test results along with all test variables and scenarios.
• Used JIRA for Sprint planning, documenting test results and bug tracking.
• Analyzed Source Systems, Staging, Fact and Dimension tables in Data Warehouse.
• Responsible for ensuring integrity of data, ETL, reports and tables on each release prior to deployment to production.

Environment: JIRA, Toad, pgADMIN, SQL Server, Oracle, Selenium, Java, Junit, TestNG, Postman, HTML, XML, DataGrip, Pentaho,PostgreSQL, Amazon Redshift, Spark, Github.

Confidential, Alexandria, VA

Software Test Engineer

Responsibilities:

• Involved in QA reviews, identifying gaps and providing recommendations to ensure that the application complies with quality and standards.
• Apply strong organizational, time-management and planning skills to deliver the release on time despite intense pressure and aggressive timelines.
• Involved in comprehensive Functional testing of systems.
• Prioritize the testing of critical test cases over others based on feedback from requirement gathering meetings.
• Extensively perform testing activities using HP ALM/Quality Center.
• Develop and execute automated Regression tests using Selenium.
• Wrote SQL queries to test data integration and performed Database testing for the Application.
• Worked with Business Analysts to define and design test scenarios and test data.
• Used 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.
• 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.
• Use Quality Center to manage requirements and traceability matrix.
• Performed data-driven tests by passing different sets of parametersto check whether the modified information 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.

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