We provide IT Staff Augmentation Services!

Automation Architect Resume

San Ramon, CA

PROFESSIONAL SUMMARY:

  • Over 11 years of diversified experience in IT industry with emphasis on Test Automation, manual, functional, GUI, Black box Regression, ERP, ETL, Big Data and Database testing
  • Solid work experience in test automation and framework development using UFT, QTP, ALM and open source tools like Selenium, WebDriver, CI/CD and JIRA
  • Expertise in identifying the objects in AngularJS, NodeJS, Ruby on rails, .NET and Oracle applications
  • Experienced in designing and implementing Data Driven, Keyword Driven, Hybrid, TESTNG, Junit and Page Object Model frameworks with Selenium
  • Good knowledge in Cucumber Automation Framework
  • Over 5 years of strong data base experience in Oracle ERP
  • Used tools such as Maven, Jenkins and Ant for automating software build processes
  • Deep knowledge on CI(Continuous Integration) and CD(Continuous Deployment) methodologies with Jenkins
  • Good experience in utilizing Oracle utility tool SQL Loader and expertise in Toad for developing Oracle applications
  • Expertise in ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
  • Good experience in Wealth Management System (Supply Chain system, Order Management, Inventory, Purchasing, Account receivables, Charge of Accounts and accounts payables)
  • Extensive experience in developing SQL scripts to validate the databases tables and reports for backend database testing
  • Leading both Automation and manual testing teams from onshore and offshore
  • Excellent understanding of the FIX protocol, API, Web Services, Soap and REST services
  • Excellent knowledge of Java Programming, Java script, VB Script and Descriptive Programming
  • Expertise in creating new Automation frameworks from scratch
  • Expertise in preparing test Strategy and test Plan for all types of testing
  • Experience working with analytics systems (e.g. OLAP, BI tools) and semi-structured data using NoSQL databases such as HBASE, Cassandra and MongoDB
  • Experience in setting up new automation teams, providing training, support and guidelines for best automation practices
  • Proven expertise in providing support, evaluate gaps in SRS and Use case documents and suggest identified gaps in requirements to Business Analysts; suggest User experience improvements
  • Skilled on create efficient test cases, organized and reusable code and customized objects
  • Excellent knowledge in ALM/QC, Rally, TFS, Bugzilla and JIRA for both executing the Automation scripts and manual test cases
  • Good knowledge on Data Integration/Ingestion with Sqoop, Flume and RDBMS
  • Extensive testing ETL experience using Informatica (Power Center/ Power Mart) Designer, Workflow Manager, Workflow Monitor and Server Manager
  • Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
  • Good work experience in Agile testing projects for more than 5 years
  • Good hands-on in BDD using Selenium Web Driver - Java and Junit
  • Strong Knowledge in Mobile Testing using Appium for (Android/IOS) applications
  • Implemented the automation solutions across multiple projects in organizations
  • Worked on SVN to handle and maintain the test data, build scripts and other documents related to the project
  • Estimation for new automation projects and come up with road map and drives the project till delivery using various automation testing tools
  • Work with development team to replicate defects, prioritize b2ugs, and develop robust tests
  • Daily communication with cross-functional team of developers, Team leads, Senior Architects, Business Analysts, Project Leader and Project Manager
  • Experienced in writing high quality bug reports with complete steps-to-reproduce, attach objective evidences and follow-up to bring to successful closure
  • Strong experience in End-to-End testing of Java, .Net and Oracle based Internetapplications
  • Highly adaptable to latest technologies
  • Good Module Leader and Team player and has the ability to adjust quickly to the changing environments and work levels

TECHNICAL SKILLS:

Testing Tools: Selenium, Web driver, HP UFT, QTP, SoapUI, Postman, WinRunner, TestNG, Junit

Defect Management: ALM, QC, Jira, Rally, Bugzilla, Version One

Scripting Language: VB Script, Java Script, HTML, XML, CSS

BuildTools: Maven, Ant, Jenkins (CI/CD)

Programming: Core Java, VB.NET, ASP.NET

Protocols: Cisco Tools, SFTP, FTP, HTTP, SONET, ATM, FIX, SOAP, REST

Methodologies: Agile, Scrum, V&V, Waterfall

Functionalities: Inventory, purchasing, Order Management, Payables and receivables, GL, shipping, Charge of accounts, Aviation, Insurance, Banking

Database: Oracle, Oracle ERP, Oracle apps, DB2, Kenan, Mongo DB, Cassandra

Other Tools: Eclipse, MS VSS, TFS, TOAD, GIT, VI editor, Informatica, BO

Version Control: GIT, SVN, TortoiseSVN, SharePoint, VSS

Operating systems: Windows, Linux, VMware

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Automation Architect

Responsibilities:

  • Joined as an Automation Architect to identify, design and develop the Automation framework that is suitable for various projects inside the BU
  • Directing and coordinating the implementation of test Automation
  • Designedand developed most of the Wealth Management System Automation Test Scripts
  • Supporting integration of Automated Test into the CI/CD integration
  • Created independent Test Suite to validate the end to end API life cycle using SOAPUI
  • Created number of reusable components for the TestNG framework for handling all the common components using Java
  • Attending the daily standup meetings to provide the accurate estimates to the BA and Scrum master
  • Creating the Test plans according to the User Stories and assigning them to the team to convert into manual test cases
  • Documenting the process reports regarding the best practices and areas to improving
  • Coordination and prioritization of Automation development activities and working with different development teams and software projects
  • Developed end to end Automated scenarios for EQUIP project that uses AngularJS, Ruby on Rails, J2EE and Oracle
  • Managing a team of 4 automation developers

Environment: Selenium WebDriver, TestNG, Junit, AngularJS, Ruby on Rails, Java, Agile, Oracle, SOAPUI, Postman, REST, Jenkins, ANT, Maven

Confidential, CA

Systems Analyst - Automation Architect

Responsibilities:

  • Working as an automation Architect
  • Developing test automation framework using UFT12.02 from scratch
  • Effort estimation preparation for Automation and manual testing
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
  • Utilized HP ALM to track, report, and manage defect throughout the test cycle and attended Defect Status Meeting on daily basis during testing cycle
  • Configured and connected ALM with UFT and stored all the automated test scripts into ALM
  • Attended daily standup meeting as part of SCRUM activities
  • Developed scripts using Descriptive Programming to enhance optimum coding standard
  • Preparation of Test plan, Test conditions and Test Scenarios
  • Created the Backend testing and Validated the data in the database by running SQL queries
  • Tracking offshore the testing activities and sending weekly status report to the client
  • Preparation & Execution of test cases End to End and Regression testing
  • Documented and Executed test scripts and recording defects in ALM
  • Worked closely to the web performance testing team to assess the load testing using LoadRunner
  • Executed Regression automated test suites and provide test results to the manager and the testing team
  • Interacted with developers to resolve the bugs
  • Requirements analysis, application design, architect, code development and testing
  • Developed automation scripts for data ingestion, preprocess, post ingestion process for various sources into Data Lake
  • Develop end to end data extractions using Hive, Sqoop, HBase and related Hadoop stack
  • Validating the FIX protocol message system
  • Amending automation scripts using existing VB script with the newly developed framework
  • Leading team meetings and represented the test team in status meetings
  • Conducted Various UAT meetings across USA

Environment: UFT 12.02, ALM 12, Hive, Sqoop, HBase, C#.NET, ASP.NET, AngularJS, Ruby on Rails, Java, Agile

Confidential, Chicago, IL

QA Lead Architect

Responsibilities:

  • Worked as a QA Lead for a Team of 8 in a SCRUM/AGILE project
  • Developed tests using TestNG by writing and Developed required Selenium support code in JAVA
  • Performed Cross Browser Automation using Selenium GRID with Sauce Labs Cloud Integration
  • Creating the Automation scripts based on the TFS User stories to ALM
  • Determine the scope of the overall QA team based on all the business demand, run the business maintenance work
  • Implemented Continuous Integration using Jenkins and GIT
  • Hands on testing various business rules User/Customer functionalities, and Change Processes
  • Configured ANT, Maven, Eclipse, TestNG CI/CD configuration files
  • Performed functional test automation and execution using data driven framework with Page Object Model in Selenium Web Driver and used Apache POI for the implementation
  • Coordinated with developers and record defects in JIRA to track until they are resolved
  • Extensively used SQL queries to check storage and accuracy of data in database table
  • Developing advanced SQL queries to extract, manipulate, and calculate information to fulfill data that includes identifying the tables and columns from which data is extracted
  • Contributed in Hadoop pilot Project for Data Loading
  • Prepared user documentation with screenshots for UAT
  • Automated all the API test cases by using SOAPUI tool
  • Performed Cross Browser Automation using Selenium GRID with Sauce Labs Cloud Integration
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Verified the Financial Information exchange ("FIX") Protocol between various systems
  • Delegating the work to offshore and monitoring the deliverables
  • Developed test cases from User stories
  • Developed Test Cases and Test Scripts for System and UAT Testing
  • Assisted in Load Testing with different servers based on the requirements
  • Developed dynamic reusable functions for different scripts in Java
  • Involved in preparing Test Traceability matrix to make sure the requirements are covered
  • Submit daily status reports and update test metrics on web page

Environment: WebDriver, ALM, Maven, Jenkins, ANT, SOAPUI, PowerShell Scripts, Hadoop, MongoDB, Cassandra, TFS, C#.NET, ASP.NET, IIS, SQL Server

Confidential, Bartlesville, OK

QA Lead Architect

Responsibilities:

  • Single point of contact for all testing activities in the project
  • Worked as a QA Lead for a Team of 6 in a SCRUM/AGILE project
  • Responsible for creating automation framework using POM- Page Object Model, and Data Driven framework to test the wealth management web application
  • Implemented Data driven Test scripts using WebDriver and CI/CD tools
  • Involved in predefining data mapping from ETL & BI to the relational source, and running ad-hoc queries for providing optimized reports
  • Mobile automation of android and windows app using Appium and Selenium Webdriver
  • Developed and Maintained test scripts with Selenium to automate browser & web applications under Testng Framework.
  • Worked on CQ Mobile development concepts like server-side Mobile API, Mobile Components, Emulators, Device Groups, Device Detection and Mobile request processing
  • Determine the scope of the overall QA team based on all the business demand, run the business maintenance work, resource capacity and skill set
  • Performed functional testing of SOAP & RESTful Web Services using SOAPUI Tool Used Java/Testng to run scenarios and generating report daily basis. Testing JavaScript web-based applications
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Worked with Agile Methodology for 15days sprint
  • Worked with ETL group for understating mappings for dimensions and facts
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Involved in understanding the System Requirements and new features in each release
  • Delegating the work to offshore and monitoring the deliverables
  • Involved in Stage setup and maintenance of Hadoop clusters for distributed dev, stage and production
  • Used GIT HUB as source code repositories
  • Working on data ingestion tools with Sqoop, HBase NoSQL database for continues data flow
  • Validated the FIX protocol across various systems
  • Tested unlaunched Android application using Appium and reported debugs via JIRA to the developers.
  • Developed test cases from Functional Requirements to Version One
  • Involved in Test Case reviews to update the test case documents as per review comments
  • Verified the Soap and REST API functionality with Automation
  • Involved in Acceptance Testing to make sure that Product meets the Business Requirements
  • Involved in preparing Test Traceability matrix to make sure the requirements are covered
  • Submit weekly status reports and update test metrics on web page

Environment: WebDriver, Appium, JIRA, Postman, SOAPUI, Version One, J2EE, Ruby on Rails, Informatica, HBase, Sqoop, Hadoop, HTML 5, Oracle ERP

Confidential, Atlanta, GA

QA Lead

Responsibilities:

  • Worked on multiple projects for the financial client in their highly confidential system
  • Developed effective test plans and test cases for integrations for the Wealth Management System
  • Identify areas of improvement to increase speed, quality and gain efficiencies
  • Maintain the QA team’s capacity planning, utilization and assignment allocations
  • Procurement: Configurations/Customizations included, Purchase Requisitions, RFQs, Purchase Orders, Release Strategy, Calculation Schema, and automatic creation of POs from PRs as well as at the time of Goods Receipts
  • Developed automation framework from the scratch by UFT using data driven framework
  • Created end to end Automated scenarios like Requisition, Receipt, PO, Invoice and GL validation
  • Created automation scripts for Web Sphere ecommerce suite
  • IntegratedMaven with GIT to manage and deploy project related tags
  • Developed automation scripts using Selenium WebDriver with Java, CI/CD and TestNG framework
  • Involved in Test Case reviews to update the test case documents as per review comments
  • Managed a team of 18 people in different geographical locations
  • Worked with Jenkins (CI/CD) for the continuous Integration
  • Automated 90% of the scenarios in Oracle ERP apps in SCM and Finance modules
  • Involved in EDI Testing and created the java web methods
  • Perform Manual and Automation testing on Windows and Web based applications
  • Followed the six sigma and 508 compliance standards
  • Used SOAP UI Application to test the web services, REST and WSDLs
  • Involved a bit in Hadoop Pilot Projecting
  • Participated in therelease cycle of the product which involves environments like developments QA and production
  • Review test cases written by other team members and make sure they are updated as and When the requirements change
  • Perform System Integration Tests (SIT), Acceptance Tests and Design Verification Tests (DVT)
  • Identifying the data discrepancies and data quality issues
  • Verified that all the business rules applying for the data and tables
  • Validated number of complex ETL mappings and reusable transformations for daily data loads
  • Helped ETL Developers to fix the issues quickly by reproducing the issues
  • Triage defects with Project managers, Architects, Development Leads and Business Analysts
  • Involved in Acceptance Testing to make sure that Product meets the Business Requirements
  • Reporting the defects using ALM and Jira

Environment: UFT 11, ALM 11, WebDriver, TestNG, Jenkins, GIT, Junit, core Java, Jira, Hadoop, Sqoop, Hbase, Web Sphere Commerce, J2EE, Informatica 9.1, Oracle ERP, BO 4.0

Confidential

QA Lead

Responsibilities:

  • Identifying Critical systems to carry systems integration and E2E testing
  • Given a demo of the application in development to the Client
  • Developed and executed the Automation scripts for multiple scenarios without any guidance
  • Automated 80% of the scenarios to reduce complexity using Selenium Web Driver and TestNG
  • Used core Java extensively for web Driver and TESTNG
  • Involved in Test Environment creation
  • Involved in Web Sphere Commerce manual and automation testing
  • Involved in validating mappings and workflows
  • Perform responsibilities of preparing test data as well as performed test scripts under the guidelines of Development Manager
  • Designing, creating and maintainingGIT repositories to client specifications
  • Creating and updating tables, views, working with triggers, stored procedures
  • Perform ad-hoc and Regression testing of system components
  • Created and debugged complex ETL processes using T-SQL queries, functions, stored procedures and SQL Server Agent jobs
  • Lead the team of 9 people
  • Work allocation to team members and monitoring their efforts
  • Conducting team meetings and also PR calls
  • Used Kenan DB and Teradata for implementation of testing processes
  • Involved with various Component leaders for bug fixing and status of bugs
  • Testing for new functionality for new CRs
  • Finalizing the test strategy and approach towards volume testing

Environment: Selenium, JIRA, Version One, TestNG, Java, Jenkins, PeopleSoft, Java, J2EE, Web Sphere Commerce, Informatica, Kenan, DB2, Teradata

Confidential, Atlanta

QA Lead

Responsibilities:

  • Involves with Various Component leaders for bug fixing and status of bugs
  • Involved in Automation Infrastructure Development in Quick Test using BPT
  • Prepared test cases for Automation and manual testings for the Oracle ERP
  • Extracted data from various sources like Oracle and flat files
  • Verified and updated the client on the artifacts of the HR module
  • Created different BPT components for the wealth management systemfor the web sphere suite functionality
  • Used to analyze User stories to understand the system and Objectives of Agile Testing
  • Automated complete Supply chain Management (SCM) system
  • Tested the data loaded into the Data Mart from the Data Source
  • Automated the scripts from Requisition creation to GL data validated in Finance module
  • Generated Recovery scenarios for End to End of Oracle ERP
  • Verifying verification points in data driven scenarios for GE healthcare
  • Performed Data Validation - using SQL (Toad)
  • Developed SQL queries to fetch test data from RDBMS such as Oracle and Sterling
  • Created scripts to load the more volumes of data into databases
  • Performed API testing (SOAP Web Services) using SOAP UI
  • Developed general and application specific functional libraries
  • Preparation & Execution of Functional, System and Regression test cases
  • Involved in Test plan, Test conditions and Test Scenarios
  • Enhancing the Test Scripts for Global Execution through QC/ALM
  • Strictly followed the six sigma and 508 compliance standards
  • Inter coordination between Implementation, BA teams and Client
  • Defect management process
  • Involved in Analyzing the Test Error Logs to find the root cause for the test failures

Environment: QTP 10.0, Selenium, QC 10.0, SoapUI, VersionOne, J2EE, Sterling, Web Sphere Commerce, Informatica, Oracle R11 ERP

Confidential

Automation Test Engineer

Responsibilities:

  • Understand business requirements and new features of system
  • Preparing manual Functional and Regression Test Cases for the new features
  • Documented the Test Cases in HP Quality Center
  • Reviewing the Test Cases and Executing
  • Functional testing for different modules.
  • Conducted various types of testing like Functional Testing, GUI Testing, Smoke Testing Re-Testing and Regression Testing
  • Create REST API tests using ruby test-client gem
  • Reviewing the scripts and scenarios for E2E functionalities created by team members
  • Responsible for Onsite - Offshore communication
  • Reviewing the basic and complex scripts/programs for functional testing and maintenance needs
  • Managing the test process and defect management process with the help of onsite team in QC
  • Extensively performed manual testing process to ensure the quality of the software
  • Conduct Re-Testing and Regression testing to ensure the quality of the software
  • Daily meeting with the Project manager regarding the updates of the Product
  • Participated in weekly status review and time sheet maintenance
  • Finding the Issues and reporting Bug and verify the bug fixing
  • Developed the automation scenarios by using the manual test cases in Selenium
  • Interacted with functional and database people for clarifications regarding application
  • Test Data Creation and setting up Test Environment (MS SQL, Oracle, DB2)
  • Executing the Functional and Regression Test Cases in different Iterations on Oracle and IBM DB2
  • Defect Management Using QC
  • Participated in Triage meetings

Environment: Selenium, Java, QC, J2EE, MS-SQL, Oracle, DB2, Data Stage, Business Objects

Confidential

Test Engineer

Responsibilities:

  • Analyzed the Business Requirements Document, inputting in Test Plan and prepared detailed Testcases for new functionality
  • Used automated scripts and performed functionality testing during the various phases of the application development using Selenium WebDriver.
  • Performed functional testing to identify various critical points in the application and automated it by using Selenium WebDriver with Testing
  • Identified the Test Cases based on requirement documents.
  • Regression Test cases were written and automated using Selenium Web driver.
  • Converted QTP scripts into Selenium WebDriver scripts. Used Java as Language as IDE.
  • Preparing, Reviewing and modifying the Test Cases.
  • Performing Smoke, Functional, Compatibility and User Acceptance testing.
  • Prepared test cases for Boundary Value Analysis using Black Box testing technique.
  • Designed and developed test structure for web services to validate API calls using SOAP UI.
  • Creating the Test Scripts.
  • Using Firebug to write automated test scripts using XPath.
  • Organized and prioritized requirements in Quality Center.
  • Scheduled and ran the tests using Test Lab module in HP Quality Center.

Environment: QTP, Selenium, VB.NET, ASP.NET, MS SQL

Hire Now