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