SUMMARY

• Highly experienced levels of proficiency with 14 years of Development, Testing, Deployment, Enhancement and Maintenance of software web - based systems in various domains including but not limited to Health Care, Service, Insurance, Finance and Banking.
• Strong experience in testing applications built using technologies like Data Warehousing (Data Migration, Data Base Upgrades, Data Transfer and ETL), Internet / Web, Client-Server
• Business Requirement Gathering, Analysis and Documentation
• Strong analytical skills necessary to make positive impact on the project.
• Experience working with AWK scripting.
• Experienced in testing data loads in Enterprise Data Warehouse/Data Marts
• Experience in Defect/Incident Tracking and Management tools like JIRA/Xray, Clear Quest, HP ALM
• Used SQL queries to do data verification in databases.
• Having work Experience on Selenium Webdriver/Cucumber
• Extensively working as a Software Development Engineer in Test.
• Extensive experience in Functional testing, Integration testing, Regression testing, GUI testing, Browser Compatibility testing, Ad-hoc testing, System Testing, Performance Testing, Build Verification Testing.
• Developed Test Plans, Test Cases using S/W requirements and Design documents.
• Write and maintain business requirements, test plans and defects in the respective modules in HP ALM.
• Experience in Testing Rest API ‘s using Rest assured and Postman.
• Experience with JMeter for Performance testing
• Expert in verifying the accuracy and completeness of data after a data migration, replication, integration or other similar movement or transformation exercise using Informatica Data Validation Option (DVO).
• Experienced in testing reports using Business Intelligence (BI) Tools like MicroStrategy, Cognos, Business Objects and Essbase.

PROFESSIONAL EXPERIENCE

Confidential

Senior Automation Engineer/Test Lead

Responsibilities:

• Build CI/CD pipeline using Jenkins, Selenium Cucumber BDD Framework
• Regression test cases were written and automated using Selenium.
• Develop test framework using Junit/TestNG.
• Created the Common libraries/Functions.
• Created a configuration that will launch a Junit test for Regression testing.
• Used Postgres for data base testing.
• Extensively used JIRA/X-ray for test data management
• Used Cucumber tag to link the feature file and step definition.
• Cucumber and selenium web driver integration with JAR files in POM.xml
• Used Data.Jason for test data creation.
• Eclipse is used as an IDE.
• Used GIT commands to pull/push/clone the code from Bitbucket.
• Experienced with Selenium framework to automate functional tests.
• Mentored Junior testers
• Used JMeter for Performance testing.
• Tested Rest API using Rest assured and Postman.
• Established automated test methods and techniques using Selenium, develops test plans and requirements, writes test procedures, and reports, and conducts tests.
• Generated dashboard with Cucumber reports showing Features/Scenarios/Steps
• Used 508 tools (Dragon and SortSite for testing accessibility)
• Used Informatica Tool to execute the Jobs, monitor and to test the scenarios like source to stage, stage to target, Reference code checks, Referential Integrity checks, Natural Key uniqueness, Audit balance control checks etc.
• When the Informatica workflow fails, helped in performing root cause analysis through logs, querying the tables, and pinpointing the exact cause of the application failure and shared the findings across the development team.
• Created different scenarios Developed SQL queries to validate data in Data warehouse and Data mart.
• As a Testing Lead for EDW, used Informatica DVO tool to create table pairs to test the scenarios like source to stage, stage to target, Reference code checks, Referential Integrity checks, Natural Key uniqueness etc.
• Created SQL views for the table pairs in DVO.
• Generated Reports out of DVO for the leadership team to give a sense of the test coverage via DVO scripts.

Environment: PGAdmin Postgres, MS Excel, MS Word, MS Power Point, Jira, Xray, WinSCP, Putty, Selenium Webdriver, Cucumber, Eclipse, Jenkins, Java, Spring suite, GIT, Maven, Postman, JMeter, AWS, Dragon, SortSite, Power Center Informatica, TOAD

Confidential

Test Lead

Responsibilities:

• As a Test Lead for Health Claims Data Warehouse, put out the test plan after discussions with the test team and have it reviewed and approved by the management/development team.
• Participated in all agile scrum meetings starting from Sprint planning where we divide the epic into small stories, create task for the stories, estimate the points.
• Coordinated and worked closely with Operations team on the release activities.
• Wrote SQL loader script to load the source files data (both Fixed and Delimited data) into Oracle tables for comparing data with the target tables.
• Responsible for Defining QA strategy, approach, and execution of the projects. Conducted internal team meetings to know the status of the Progress.
• As a team lead escalation point for all matters related to testing and quality assurance and operate as a primary point of contact.
• Helped testers in developing test scenarios, test cases and test data based on the requirement documents and make sure team covered all the business requirements.
• Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.
• Used DataStage Director Tool to execute the Jobs, monitor and to test the scenarios like source to stage, stage to target, Reference code checks, Referential Integrity checks, Natural Key uniqueness, Audit balance control checks etc.
• When the DataStage Job load fails, helped in performing root cause analysis through logs, querying the tables, and pinpointing the exact cause of the application failure and shared the findings across the development team.
• Created different scenarios Developed SQL queries to validate data in Data warehouse and Data mart.
• Experienced with Selenium framework/Ansible to automate unit test and functional tests.
• Build CI/CD pipeline using Jenkins, Selenium Framework and Ansible
• Regression test cases were written and automated using Selenium.
• Develop test framework using TestNG.
• Created the Common libraries/Functions.
• Developed scripts in Unix shell to meet new business requirements.
• Used Firebug to find/inspect HTML elements present in the page.
• Used Xpath and CSS to locate an element based on associated class.
• Conducted Cross Browser Testing.
• Design and writing the automation scripts.
• Mentored Junior testers
• Used JMeter for Performance testing.
• Tested Rest API using Rest assured and Postman.
• Established automated test methods and techniques using Selenium, develops test plans and requirements, writes test procedures, and reports, and conducts tests.

Environment: IBM DataStage and QualityStage 9.1/11.5, Linux, Windows 7, TOAD, Oracle 12c, Oracle SQL Loader, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, HP ALM, Jira, Cognos, WinSCP, Putty, Windows Task Scheduler, Selenium Webdriver, Eclipse, Jenkins, Java, Spring suite, Jenkins, GIT, Maven, Rest assured, Postman, JMeter