Senior Qa Automation Engineer Resume
Scottsdale, AZ
SUMMARY
- 14+ years of extensive IT experience mainly on QA Test Automation (Selenium using Java), Software Development, QA Functional and UAT Testing.
- Experience in working with Selenium IDE and Selenium Web Driver using TestNG for Automation testing and HP QC (quality Center) for test management.
- Having good experience in SalesForce, Big Data, ETL, BI, Reporting, and Automation Testing.
- Functional domain Experience in BFSI (Banking, Insurance, Capital Markets - Tax, Trade and Compliances, Forward Contract, Equity/Fixed Income Investments,).
- SalesForce experience with Platform App Builder Certification in SalesForce
- Experienced in Scaled Agile Framework 4.5 (SAFe Agilist) and earned certification
- Certified in Property and Liability Insurance Principles (INS 21) - AINS, USA.
- Certified Software Test Engineer (CSTE) - QA Institute - Florida, USA.
- Expert in Datawarehousing ETL, Hive, SQL queries in Oracle / DB2 / Netezza / Teradata / /Sybase DBs Cognos, OBIEE, BO and SAS Reports validation.
- Hands on experience in Big Data Ingestion - Metadata, Data Quality, History Catch up, and complete E2E Legacy to Big Data validation and maintenance.
- Good working Knowledge in Informatica, DVO, API - Postman, Apigee, Data Stage, QTP, Selenium.
- Proficient in Automation Framework, Scripted Components, Debug/Fixing and Regression suites.
- Good experience in Core Java, SQL Queries, Joins, HTML, XML and JSON
- Good knowledge on DevOps and CICD concepts and execution
- Good hands on experience in Agile SCRUM Methodology, SAFe Techniques, Effort Estimation, Project Tracking and Monitoring, Coordination and Project Plan and strategy.
- Expert in developing/executing software Test plan, Test script/cases and Test data preparation. Key contribution in Project Life Cycle and Design documentation.
- Strong in Data Analysis, Planning, and Problem solving capabilities. Excellent interpersonal, communication and writing skills. Good team player or in individual environment. Played in all phases of SDLC and STLC.
TECHINICAL SKILL SETS
Development Methodologies: SAFe Agile, SCRUM, LeanAgile, Iterative and Waterfall.
Tools: Rally-Kanban, and Enterprise JIRA
Databases & Tools: Multitenant -Force.com, MYSQL, SQL Server 2008, Oracle SQL Developer 1.5.5 and Sybase, Apache Hive 1.2, Oracle 10.i, DB2, Netezza, Teradata 13.11.06, Spark, Kafka, ElasticSearch, HBase, Apache Hive 1.2, Oracle 10.i, DB2, and Netezza
Database Tools: SOQL, MySQL Workbench, SQuirreL, RapidSQL, Toad 8.0 & Query Analyzer.
Reporting Tools: Tableau, Cognos 7 & 10 Series, QlikView 11, Business Objects 3.1, OBIEE, Crystal and SAS Reports.
Software Products: SalesForce, Guidewire, Infopro, ActiveBank(Temenos) and SiteCatalyst
Programming Languages: Core Java, TypeScript, Javascript, Python, C, C++, NodeJS, ASP.Net, VBScript Macro, and Shell scripting.
Operating System: Windows, Linux, IOS and UNIX
QA Tools: Selenium - Webdriver, QTest, QTP 9.2, Win Runner 7.0, QC 11.
ETL Integration Tools: Data Stage, Informatica and Cognos.
Config Mgmt Tools: GitHub, Confluence, SharePoint, Perforce and Visual Source Safe.
PROFESSIONAL EXPERIENCE
Confidential, SCOTTSDALE, AZ
Senior QA Automation Engineer
Responsibilities/Achievements:
- Analyzing of Business and Requirement Spec in Agile Stories, Designing Test Automation Approach, and Framework in Protractor POM Test Automation framework Node.js/Typescript/JavaScript
- Built Regression Suite in BDD framework using Cucumber Gherkin language
- Identify and prioritize Test Cases to automate and include in Regression Suite in Jenkins
- Write Functional Test Cases in QTest and Automate them using Cucumber Feature files
- Enhance existing Test Automation Framework in Protractor, Node.js and Javascript
- Manage Testing scripts in GitHub for Code review, Pull Request and Merge with Master
- Setup Protractor E2E UI automation nightly run for different team and make sure E2E functionality working as expected
- Running 70 Regression suite Test cases within 2 hours nightly using Jenkins
- Helped and Trained other team members to setup Protractor E2E Functional Testing
- Create APIManager class for interacting in Sales and Service Cloud and save in datasets.
- Use API Datasets data methods (queryForAccount, Asset, Site and Lead) stored in result sets.
- Developed Test Scripts to implement Features, Test Scenarios and Step-Definition forBDD (Behaviour Driven Development)usingCucumber (Gherkins format).
- Expertise in Core Java and Object Oriented Concepts (Inheritance, Polymorphism…etc).
- Good hands-on experience on various test management tools likeJira/Rally, HP-ALM and QC.
- Configure the package.json to run the e2e test in the developer systems
- Hands-on experience with all levels of testing viz.,Integration, Regression, Smoke, Sanity, Functional Testing, System testing and UAT.
- Responsible for developing the scripts to supportJenkins(CICD) of the scripts in build server.
- Performed Database Testing withSOQLand automated Data Validations usingAPI Connections.
- Conducttest case reviews, provide project related statusreporting, coordinate all release planning and lead the testing team through allproject phases.
- Demo (Show & Tell) the User Stories to all Stakeholders during Sprint Review.
- Report Project/Program Manager and Director with accurate QA Issues, Metrics & Status.
- Good Exposure toTesting Life CycleandBug Life Cycle.
Environment: Visual Studio Code, Protractor, GitHub, SourceTree, TypeScript, Core Java, Selenium (WebDriver, TestNG, JUnit), Cucumber, QTest, Yarn, Jenkins, Rally, SOQL - Inspector.
Confidential, PHOENIX, AZ
Senior QA Automation Engineer
Responsibilities
- Attend PI Planning Session, Understand features, capabilities and its priorities
- Prepare program board with Data Ingestion, enhancement and data quality activities
- Prepare High level sizing based on available capacity for PI
- Achieved huge team co-ordination between various business and technical teams.
- Design and implement the Best Data ingestion Practices.
- Finalize Metadata from various SORs and prepare initial questionnaire.
- Prepare Metadata mapping and Register with Central Data Management (CDM)
- Used Postman, Apigee & SOAPUI for rest service testing using Groovy/JavaScript.
- Performed and validated Database Testing and Data Retrieval.
- Prepare Ingestion Logic and Flow as per the Source File
- Setup File Transfer mechanism from Source to Cornerstone Landing Zone
- Align with SOR team regarding Data file layout and frequency.
- Manage and coordinate with the onshore/offshore project team.
- Review Ingestion Flow and logic created by the team.
- Communicate the project impediments and risks to the program board and get it solved on time.
- Ingest the data in Silver (Dev/Test) Environment and secure HS#3 sign-off
- Request 1 round of History/BAU data load for ingestion and validate the layout
- Secure HS#3, HS#4 Sign-off from DOT
- Show and Tell with Business/End User and secure PIV sign-off
- Request DOT to release the feeds into CSTONEDB3 as BAU feed
- Conduct daily SCRUM and status meeting with stakeholders
- Received Customer appreciation for Data Ingestion and Lead activities.
Environment: Hadoop, Hive, MapR, PIG, Cornerstone, SharePoint 10, Rally, JIRA, WinSCP, Putty, Maverick, Magellan, ServiceNow, MySQL, Apigee Edge 4.0, HiveTerminal, Soap UI 5.2.0, WiMD, Excel Macro and EventEngine
Confidential
Senior QA ETL Engineer
Responsibilities:
- Understands the project requirements, Data Model and Mappings.
- Responsible for Design and implements the Best QA Practices for the project.
- Reviewing the ETL Mapping sheet and identifying the test scenarios
- Written Test Cases for ETL to compare Source and Target database systems. Running of high performance jobs through Expertise in ETL testing experience usingMSBI(SSIS - Sql Server Intergration Services, SSRS - Sql Server Reporting Service).
- Verify data for record count match, NULL, Data Integrity, Data Completeness, and Duplicates.
- As an ETL QA lead, manages and coordinates with the onshore/offshore.
- Strong working knowledge onWeb services testing(Postman) andAPI.
- Proposes new business solution and coordinates account level activities.
- Received many customer appreciation and Satisfaction for QA Lead activities.
- He prepares Test design, Test Strategy & Test Plan documents. He reviews the test cases & test data created by the team.
- Communicates the project issues and risks to the management and get is solved right on time.
- Conduct status meeting with client team, update the status of the testing activities and follows-up on the open action items until it is closed.
- Actively involves in defect triaging and tracking.
Environment: SAAS, DataStage, QuerySurge, Big Data Hive, XML, UNIX, Autosys CA Scheduler and Cognos 7 Series Reporting.