Artafarin Niknia

Artafarin Niknia Email: -Ph: - Professional Summary: Over 5 + years of experience as an Automation Test Engineer and Manual Tester. Expert in all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), including Implementation, Documentation and Testing on Web based applications and Client-Server applications, in the domains of Retail, Health Care, and Banking. Hands-on with Waterfall and Agile techniques like Scrum and performed Gap Analysis, Business Requirement Document, and use case scenario document. Experienced in formulating Test Plans, Test cases, Test Scenarios, Test Approach and set up testing environment. Expertise in different types of testing like Automation testing, Manual testing, Integration testing, System testing, Smoke testing, Regression testing, Performance testing, Functional testing and User Acceptance Testing. Experience in working with open source tools such as Selenium IDE, Selenium RC, Selenium Web Driver, Selenium Grid, Cucumber, JUnit, Eclipse. Experience testing SOA with Restful/SOAP Web Services. Expertise in developing test scripts using Selenium WebDriver executed automated test scripts & analyzed the results. Worked on Continuous Integration Process using Jenkins, TestNG and Maven. Expertise in Grouping of Test Cases, Test Methods and Test Suites for regression and functional testing using the TestNG annotations like Groups, Parameter, Data Provider. Design & Develop data driven framework from scratch using Selenium WebDriver, TestNg, Apache POI API and Page Object Model Design Pattern. Extensively used XPATH, Regular expression and classes to perform UI actions. Exported output / reports for all automated testing results. Integrated successfully build deployment tools like Jenkins, Maven with Selenium Automation frameworks for nightly regressions. Have done database testing by using Oracle SQL. Knowledge in Java and OOP (Object Oriented Programming); Wrote custom SQL queries for data validation on back-end database, Oracle Proven ability in working individually or as part of the team, Problem solving, reporting and assisting to Manage. Experience: Blue Cross Blue Shield Sep 2018 - Oct 2019 QA Tester/ETL Tester Jacksonville, FL Responsibilities: Review functional and design specifications to ensure full understanding of individual deliverables. Identify test requirements from specifications, map test case requirements and design test coverage plan. Develop, document and maintain functional test cases and other test artifacts like the test data, and data validation. Defects were tracked and prioritized using HP ALM/Quality Center and analyzed the variation between expected results and actual results. Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX & MS Excel. Tested ETL mappings and worked in source to staging area to validate the multiple source system data with SQL queries. Involved in backend Data warehouse ETL testing with SQL, check the data integrity and referential integrity. Coordinated between offshore and onsite team and managed the entire project for testing needs. Debugged the SQL-Statements and stored procedures for various business scenarios. Performed extensive data validations against Data Warehouse. Logged and tracked defects on a release basis using HP ALM/Quality Center. Tested and validated the Report Net reports by running similar SQL queries against the source system(s). Performed transformation and data quality for various data feeds coming from different source systems. Tested reports developed by Business Objects Universes for both ad hoc and canned reporting Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping. Created test cases and tested Business Objects reports using HP Quality Center/ALM. Created complex SQL queries for data validation to verify the ETL mapping rules. Analyzed the Requirement Traceability Matrix, daily test status reports, weekly defects report, and risk analysis, including regular communications with the business team. Tested several reports developed in Business Objects. Norfolk SouthernApr 2018 – Aug 2018 QA Engineer Atlanta, GA Responsibilities: Assessed & analyzed user stories and Conducted Sprint planning, Scrum Meetings. Conducted defect triage meetings among various team members Prepared Test cases for positive and negative test scenarios as referred in the user stories keeping in mind the Boundary Value Limitations, Equivalence classes. Initiated a mandatory RCA for any type of defects missed with constant upgrade to regression suite. Configured Maven, Log4j configuration files, prepared documentation for setting up Selenium and Eclipse Environment on Local Work Spaces. Developed automation scripts for automating Functional and Regression testing using Selenium WebDriver, Eclipse, TestNG, Java, Maven, Log4j and JDBC. Performed Integration and Regression testing to check new functionality doesn't break the existing functionality of the application using Selenium. Used Apache POI to extract test data from external Excel files. Developed Hybrid framework (Page Object Model pattern with Data Driven framework) to retrieve test actions, test data from Excel files and SQL Databases. Implemented TestNG automation framework for the smoke test. Handled Selenium WebDriver features like implicit wait and explicit wait under synchronization. Handled the special mouse events and selected the options from the tab menu using Selenium Actions builder, mouse hover, and synchronization. Performed Cross and Parallel Browser testing on different browsers like Internet Explorer, Safari, Chrome and Firefox where multiple states can be executed at the same time. Managed the framework dependency jars using Maven. Used Maven to perform build from Jenkins Continuous Integration. Executed test cases using TestNG parameters, data providers, suites, parallel suites and groups. Extensively worked in locating a web elements using ID, name, class name, linkText, CSS selector and XPATH. Involved in testing alerts and pop-ups using Selenium WebDriver. Extensively used XPATH, Regular expression and classes to perform UI actions. Exported output / reports for all automated testing results. Written Scenarios, Scenario outlines and step definitions using Gherkin in Cucumber for BDD (Behavior Driven Development) and ATDD (Acceptance-Test Driven Development). Tested SOAP and RESTFUL web services using different assertions like HTTP assertion, security assertions, and XPATH assertions in SOAPUI. Environment: Java, Selenium WebDriver 2.53.0, TestNG, Eclipse, Oracle, Toad, XML, HTML, SoapUI, Maven, Jenkins, Cucumber, Gherkin, Apache POI Ensono IncOct 2017 - to Mar 2018 QA Test Engineer Downer Grovers,IL Responsibilities: Extensively involved in analyzing Business Requirements, created testing strategies, testing plans and prepared detailed test cases for the Application under Test (AUT). Developed automation test scripts using Selenium Web Driver and Java. Developed Data Driven Test scripts as well as running these scripts for Message processing, Registration, and Reports testing using Selenium WebDriver. Created test cases, test plans, tested API’s, wrote JUnit test cases, executed code coverage and wrote automation scripts using Selenium WebDriver. Developed and executed test cases for EWS (Enterprise Web Services) / SOAP and RESTful services using Soap UI. Developed and design necessary test plan and test scripts for functional and performance testing using, Selenium Web Driver, TestNG, Maven, Jenkins and JMeter. Created the JUnit test cases for the different web applications using Eclipse IDE. Automated web application using Selenium WebDriver and Cucumber framework. Test case creation in Ruby according to the user stories and performing regular and regression automation testing. Integrated Automation scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for nightly batch run of the Script. Developed scripts using Selenium-web driver and Ruby API to automate web based applications Performed SOA / web services testing using SOAP UI; wrote adaptors to test / invoke web services. Behavior-Driven Development (BDD) implementation with Cucumber gherkin and Jenkins Continuous Integration. Extended data driven framework and developed re-usable functions across the application. Used JUnit Test to automate functional and regression testing across integrated environments. Used ANT to build and run the Selenium WebDriver automation framework. Once the script got over, framework used to send the automation reports over email. Triggered the automation jobs using Jenkins to get the cucumber JSON reports. Extensive experience in using Testing tools such as UFT, ALM, Rally and Apache JMeter. Integrated the test suites to Jenkins to execute them automatically after every successful deployment. Performed back-end testing on Oracle and SQL Server databases by writing SQL queries to make sure the contents displayed on the UI correct as per requirements specifications. Recorded JMeter user scripts implementing parameterization both manually and by data driven wizards in JMeter. Performed defect reporting and bug tracking using JIRA and also followed up with development team to verify bug fixes, and update bug status. Environment: Java, Selenium WebDriver, QC/ ALM, Eclipse, Junit, ANT, Jenkins, JSON, JMeter, REST, SoapUI, HTML, Git, Agile, SQL, Oracle, JIRA, Windows and UNIX. Wells FargoJan 2016 - Sep 2017 QA Test EngineerRaleigh, NC Responsibilities: Analyzed business requirement documents and design specification documents. Participated in studying system process flows (includes front, middle and back office) to frame test strategies, quantifying Manual and Automation tests. Created test plan and test scenarios based on the requirement documents. Created and maintained requirement traceability matrix (RTM) for overall requirements coverage (Gap Analysis). Prepared test scripts for the System, Product and User Acceptance Testing (UAT) based on requirements. Created SQL queries to verify data in target databases. Conducted manual execution of test cases, evaluated the results with expected results to ensure application is functioning in a stable way and logged defects in QC. Performed XML testing through QTP using XML checkpoints. Performed extensive Data Driven Testing using concepts of Parameterization. Generated and executed test scripts by creating Test Suite for Batch Testing in Quality Center. Used Recovery Scenario Manager to handle various exceptions. Created data driven tests in QTP with global parameters and local parameters. Generated reports and documents and communicated test results on daily basis. Analyzed the results gathered during test scenario execution. Participated in status review meetings with developers and QA team. Maintained consolidated weekly status reports and test logs and reviewed with QA manager periodically. Exported/Imported excel files in automation tools (QTP) to run tests. Environment: Java 7, UNIX, XML, Weblogic, IE, Firefox, Chrome, Load Runner, Quality Center, Quick Test Pro, SQL, Oracle. Sina Hospital June 2014-Nov 2015 QA Analyst Tehran, Iran Responsibilities: Involved in Business analysis and requirements gathering. Gained domain knowledge on property and casualty insurance like general liability, automobile, medical-professional liability, personal liability etc., Written the SQL scripts to validate ETLs developed by Informatica. Executed Informatica to test the ETL processes. Used the Data Stage Designer to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database Validated Informatica ETL mappings and transformations like joiner, update strategy and lookup. Involved in conducting Functionality, Negative/Positive, and Security testing manually. Experienced with Informatica Power Center workflow manager and workflow monitor. Used Informatica workflow monitor-to-monitor workflows and review session log files. Experience in preparing the traceability matrix, test scenarios and test cases. Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report and requirement traceability using Quality Center. Reviewed the test cases written based on the Change Request document. Tested data migration to ensure that integrity of data was not compromised. Experienced in writing complex SQL queries for testing data in oracle targets. Worked on issues with migration from development to testing. Prepared test data to validate ETL rules wherever necessary. Accessed source files from UNIX environment. Written several complex SQL queries for validating SAP BO Reports. Reviewed the test cases written based on the Change Request document. Preparation of System Test Results after Test case execution. Developed SQL loader scripts to load the data into the custom table. Environment: Informatica, Oracle 10g, Quality center, SQL, UNIX, Toad, SAP BO, MS Office, Windows Education: Bachelor of Industrial engineering Master of exercise physiology Skills Jira, Selenium, Selenium webdriver, Testng, Java, Apache, Linux, Testing tools, Software testing, Manual, QA, Quality Assurance Other Activities & Interests: Athlete 2000 - 2016 Member of University Swimming team Two National Achievement as a Swimmer