Upender

ac3aug@r.postjobfree.com

609-***-****

Senior QA Engineer with around 9 years of experience in all phases of Software Testing Life Cycle (STLC); Developing Test Strategy, Test Cases, Test Plan and Automation test scripts using Selenium. Diversified experience in Automation, Manual testing and Business Analysis methodologies, serving various domains such as Healthcare, Insurance, Banking and Retail.

Professional Summary:

Around 9 years of experience in all phases of software lifecycle, developing test cases, test plan and Automation test scripts using Selenium for testing Web based applications.

Strong Knowledge of Software Development Life Cycle (SDLC) and QA Life Cycle which includes Designing, Developing and Execution of the entire QA Process and Documentation of Test plans, Test Cases and Test Scripts.

Working knowledge on software development process, project management and testing lifecycle methodologies likeWaterfall, Spiral and Agile Models.

Expertise in Manual Testing,Backend Testing,Automation Testing, UI Testing, Black-box Testing, Functional Testing, User Acceptance Testing, and Regression Testing.

Data mining using R programming to predict the outcomes of large datasets.

Good programming skills in SQL, PL/SQL, Java and experience in SQL Server, Informatica, and MS-Access.

Proficient in web development using Java & J2EE technologies including Core Java.

Knowledgeable in SQL maintenance activities such as transactional replication, SQL jobs, database backup & restores.

Expertise in ETL for fetching data from various non-relational sources and relational databases using SQL server data tools and Informatica.

Proficient in using SQL queries and Stored procedures to perform back end testing for data integrity.

Hands on experience in SSRS Reports development with C#, ASP.Netand developed various reports across all the modules in AX.

Created effective reports using visualizations such as Bar chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI

Expertise in Selenium Automation using Selenium WebDriver Java, TestNG, Cucumber, POM framework and Maven.

Experienced in making Data Driven Framework to maintain Test Suites.

Sound knowledge on JUnit, TestNG framework for Unit testing, Maven and Ant for Project building tool, Jenkins for Continuous Integration.

Expert using open source bug and defect tracking tool JIRA, Bugzilla

Proficient inusing Postman for API testing using POST, GET, PUT, and DELETE.

Experience with comprehensive understanding of all phases of Test Life Cycle, including requirements gathering, test planning, scheduling, testing, defect tracking and reporting.

Experience in using Web-debugging tools like Fire Path and Firebug for finding elements locator.

Worked closely with Business development team and to prepare the system requirement specifications based on the projects for the better products to reach the client expectations.

Experienced in analyzing Software Requirement Specifications (SRS) and System Design Specifications (SDS).

Performed in code review meetings, Defect review meetings with development and business team.

Successful UAT of multiple Microsoft dynamics AX modules, with deployment to Production and smooth data migration.

Coordinated and assisted member users with data migration from legacy systems to Microsoft Dynamics Axapta.

Performed various testing activities such as Unit testing, System integration testing, Performance testing & E2E testing both AX and other integrated applications.

Excellent communication skills and highly adaptable to new challenges related to software industry and user demands.

Ability to work under tight deadlines and rapidly changing priorities.

Flexible and versatile to adapt to any new environment and work on any project and excellent ability to learn new things quickly.

Strong application knowledge, interpersonal skills, good verbal and written communication capabilities, presentation Skills.

EDUCATION

Bachelor of Technology- Computer Science and Information Technology.

TECHNICAL SKILLS

Test Approaches

Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle

Testing Tools

Selenium WebDriver, Selenium IDE, Selenium RC, Selenium Grid, Log 4J, QTP, QC, TestNG, JUnit, Cucumber, Appium, Perfecto mobile, SoapUI.

Test Build& Integration Tools

Maven, ANT, Jenkins

Frameworks

Keyword Driven, Data Driven, Hybrid, Page Object Model (POM)

Programming Languages

JAVA, C, C++, C#, X++, SQL/PLSQL/Stored Procedures, R

Markup Languages

HTML, XML, XPath, CssSelector

Databases

MySQL, Oracle, SQL Server

Browsers

Internet Explorer, Mozilla Firefox, Google Chrome, Safari

Operating Systems

Windows XP/7/8/10, Ubuntu, LINUX, iOS

Defect Tools

JIRA, Rally, Bugzilla

MS Office Tools

Word, Excel, PowerPoint, MS Access

Utilities

Eclipse, GIT, Firebug, Fire Path

ERP

Microsoft Dynamics AX 2009, 2012 R3

ETL Tools

Informatica power center, SSIS

PROFESSIONAL EXPERIENCE

Client: Cardinal Health, Dublin, OH September 2016 – October 2017

Role: Sr. QA Automation Engineer/ETL Tester

Description: This project was web based Controlled Drug Management software separately developed to handle controlled drugs. It enabled the hospital pharmacy to trace and monitor the possession of controlled substances along all points in the distribution process. This system provided tight control at all points of the process and automatically ensured whether all issues, receipts, and return transactions were completed properly.

Responsibilities

Analyzed the Business Requirements Document (BRD), developed Test cases and Test scripts for the application under test.

Developed Test Scripts to implement Test Cases, Test Scenarios, and features for TDD (Test Driven Development), BDD (Behavior Driven Development) using Cucumber.

Wrote BDD, UAT using Gherkin format and implemented the step definitions using Cucumber.

Performed Data-Driven Tests by passing different sets of data and checked whether the information entered is updated into the database where we use Page Object Model as design pattern.

Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source system.

Created ETL test data for all ETLmapping rules to test the functionality of the Informatica Mapping.

Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations.

Configured Selenium Web Driver, Test-NG, Maven tool.

Used Maven build tool to implement the framework dependency Jar files.

Specialized in using Selenium Webdriver with TestNG frameworks in creating test scripts, test suites and HTML reports.

Experienced in Apache POI Jar for reading Excel file using Java IO operations.

Created Selenium automation scripts in java using TestNG.

Used various TestNG annotations for executing group functions in XML.

Validated database query results with test data.

Used Firebug/ IE Developer Toolkit and validate CSS Locators, html ids to identify elements and alsoSelenium IDE to capture and run the test cases.

Raised defects while doing System Integration Testing (SIT)and regression testing.

Performed defect tracking and bug classification using tools like JIRA.

Experience with cross browser and compatibility testing to test whether the web applications are working as desired in different browsers and environments using Selenium Grid.

Experienced in SOAPUI/RESTfulWeb Services Testing. Validated request and response XML, SOAP and RESTFUL Web service calls.

Performed browser compatibility testing on Windows.

Developed Test Analysis reports and Master Test Plans for each testing effort.

Performed hybrid mobile testing using Appium.

Reviewed the testing conducted by the peer testers and gave necessary suggestions.

Maintained Selenium & Java Automation Code and resources in source controls like GIT, Jenkins for improvements and new features.

Involved in Unit Testing, Handled issues in System testing and UAT.

Designed scenarios in JMeter to perform Load and Stress tests and to analyze results.

Executed some test cases manually. Compared and analyzed actual results with expected results and reported the deviations to appropriate individuals for resolution.

Environment: Selenium Web driver, Eclipse, JMeter, JIRA, Java, JavaScript, HTML, X-path, Windows, Oracle, Fire bug, Fire Path, SQL query profiler, Sure Step Software, GIT, Informatica, Appium.

Client: T D Bank, New Jersey, USA August 2015 – August 2016 Role: Sr. QA Engineer/ Sr. ERP Tester

Description: T D bank offers the same products and services as regional and major money center banks, but it differentiates by delivering personalized products to meet the communities' needs. To that extent, they have the technology to provide check imaging, bank-by-phone services, corporate cash management, debit cards an extensive ATM network and Internet banking.

Responsibilities:

Worked closely with the Developers in the review and modification of the product and its specifications using Agile-testing methodology.

Interacted with the Environment team and the Development team in prioritizing the defect list and validating known bug fixes.

Handling security roles, duties and privileges.

Worked on MS Dynamics AX modules like Bank Modules, Financial Modules (AP, AR, GL, and FA) and AOT objects.

Involved in the upgrade from AX 2009 to AX 2012 R3, including cloud environment design and configuration, code migration, and resolution of code merge conflicts and compilation errors.

Data migration from AX 2009 to AX 2012 R3 using ODBC and Delimited file formats.

Expertise in Automation testing using AXeptance tool in AX 2012 R3.

Working with the team for programming and developing GUI using .Net framework 4.6, MVC, C# with ASP.Net 4.5, Visual Studio 2015.

Created SSRS reports usingC# while integrating it with Microsoft Dynamics AX.

Extracted data from various sources like Oracle, flat files and SQL Server.

Designing and creation of complex mappings using transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Created various PL/SQL stored procedures for parametric filtration.

Responsible to design, develop and test the software(SSIS as ETLtool to maintain the data marts (Load data, analyze using SSAS and SSRS for reporting).

Tested various ETL transformation rules based on log files, data movement and with help of SQL.

Extensively used ETLmethodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using SSIS.

Created and executed automated test cases using Selenium WebDriver, TestNG.

Used AutoIT, Robot API tools in automation for Mouse movements, Keystrokes, Window control manipulations and print pop-ups which is not possible using selenium Webdriver.

Tested REST and SOAP Services using SOAPUI and validated responses against the database.

Developed test plan to identify test strategies to outline plan for black box testing. Created test cases and test scenarios to conduct functional and system testing.

Extensively used Selenium APIs such as Select for selecting multiple values from list, Action for various key and mouse event with different Locators (Xpath, CSS, id, Link text).

Extensively worked with Rally, also worked with Add-ins to upload Test cases, Test Scripts and Test documents.

Used Rallyas a bug tracking, issue tracking and project management software.

Worked on Savings Account and other accounts, updated the accounts writing SQL queries.

Developed, enhanced and maintained a large and complex suite of both GUI and API based Automated Regression tests.

Performed Cross browser compatibility testing using Chrome, Firefox, IE browsers.

Shared my understanding of the systems intended structure and behavior with fellow testers and stakeholders.

Coordinated with developers to promptly resolve system bugs and ensure full compliance with business and operational requirements.

Environment: Selenium WebDriver, Java, Oracle, TestNG, Windows Server 2008 R2, Microsoft Dynamics AX 2009, X++, SSRS, SQL Server 2008 R2, T-SQL, Windows Server 2012 R2, Microsoft Dynamics AX 2012 R3, Team foundation server (TFS), Enterprise portal setup,C#, ASP.NET, Visual studio 2015, SQL server data tools, Rally, AXeptance.

Client:AMICA Mutual Insurance, Rhode Island, USA February 2013 – July 2015

Role: QA Tester

Description: AMICA is a leading insurance provider to a wide range of customers with multiple customizable policies and in this project customers enrolled in the policy as an investment. A policy holder would be benefitted with different policy return options available depending upon the tenure of the policy.

Responsibilities:

•Developed automated test scripts using Selenium and in Java Eclipse.

•Used core Java concepts that includes Collections, Exception handling, Garbage collection extensively for coding business related activities.

•Involved in writing Multi-Threading Synchronization concepts in Java Programs.

•Involved in test cases review by development team, product management and modified the test cases based on their feedback.

•Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

•Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.

•Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.

•Developed ANT based build scripts to run Selenium Automation.

•Used ANT to manage a project's build, reporting and documentation from a central piece of information as well injected in Jenkins for continuous build.

•Reported defects through Jira and performing Regression to resolve bugs fixes.

•Extensively involved in resolving bugs fixes with Development Team.

•Performed Regression testing for new builds and every modification in the application using Selenium WebDriver.

•Performed cross-browser testing.

•Used Firebug Tool to identify the Object's id, Name, XPath, link in the application.

•Executed test cases on multiple platform using Selenium GRID.

•Performed Data Driven testing on web services using SOAPUI.

•Responsible for updating and maintenance of existing selenium scripts.

•Performed testing on web services using SOAPUI with XML web services and SOAP.

•Created positive and negative assertions based on the business requirements.

•Used SVNas version controlandfor maintaining, updating codes in the files and directoriesfor each release, QA, Integration and staging environments.

•Monitored the jobs which could be SVN checkout using Jenkins

•Used Jenkins as continuous integration tool to schedule and run the automated test scripts.

•Actively participated in daily Scrum meetings and involved in bi-weekly Sprint releases.

Environment: Selenium WebDriver, Java, JavaScript, HTML, Junit, Cucumber, Jenkins, ANT, CSS, Firebug, XPath, Web Services, SOAP UI, XML, Eclipse, Jira, Windows, Unix, Oracle 11g, Informatica, Agile Methodology.

Client: GE Power, Atlanta, USA June 2011 – January 2013

Role: QA Tester

Description:GE Power is a global leader in power generation with deep domain expertise to help customers produce electricity from a wide spectrum of fuel sources. It’s innovative technologies and digital offerings help make power affordable, reliable, accessible and sustainable.

Responsibilities:

Reviewed Project Artifacts, analyzed Requirements, designed the test plan and provided weekly status report that includes testing metrics, test logs and test summary reports.

Conducted walkthrough meetings with SDLC team to understand the functionality, risk and operation management of the application.

Validated Requirements Traceability Matrix (RTM) and Users Requirement documents to prepare SIT test plan and test scenarios.

Conducted manual and automated testing for functional and non-functional test cases.

Created test data for QTP scripts, used external data sources and excel sheets to import test data.

Performed ETL testing using SQL server integration services (SSIS)for data validation during production reconciliation.

Developed SQL Queries to query Database to test the back-end of the application.

Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.

Effectively managed the testing process using Quality Centre to manage the requirement and test case and have a clear traceability between them.

Document the defects using the Quality Centre and track them to completion by communicating and coordinating with the development as well as support groups.

Coordinated with the onshore and offshore resources.

Set up the test environment and was responsible for migration between Development Environment and Testing Environment.

Created and executed test cases to test SAS products of GE integrated with base applications for rewards and marketing reports.

Worked on testing SOAP services using SOAP UI.

Worked in QTP to execute test script and updated existing script based upon new requirements

Environment: Quality Center, JIRA, HP QTP, Visual basic, SQL Server2008/2008 R2, SQL Profiler, SQL server data tools, Trace parser, SSIS, SSAS, SSRS.

Client: Tricon Infotech Pvt. Ltd, Bangalore, India July 2008-May 2011

Role: Junior QA Tester

Description: Onehealth solutions- One Health is a health care app, which brings the customers/patients and the doctors together. The users can consult physician online, get healthcare tips, and manage personal health care. It also lets patient’s health to be monitored by the doctors easily.

Responsibilities:

Created System / Regression and Acceptance testing activities like creation of test setup, test plan, test data creation, environment setup etc.

Developed and executed the test cases, scenarios, report and follow-up on bugs with the development team for resolution.

Involved in verification and validation of test results, defect management and implementation of changes into production.

Performed validations on Web Forms using .NET Validation Controls.

Implemented integration of code behind web forms development in C#.NET with Data Access layer using ADO.NET SQL Server 2008.

Performed required field, comparison, range, custom validations of the input controls of the Web Forms.

Used ADO.NET extensively for database interactions using Data Reader, Data Adapter, Data view and Datasets.

Worked with offshore team in coordinating well with onsite project and team members.

Involved in creation of system or acceptance test cases bases on component specs, requirements and design inputs.

Confidently created Traceability matrix based on the Functional requirement of the client needs.

Performed bug classificationand defect trackingusing tools like JIRA.

Maintained a bug lists for critical issues such as PHI information of patients is fully confidential.

Wrote Structure Query Language (SQL) queries to check patient’s health records in application table and for data verification to perform Backend Testing against Oracle Database.

Worked with development team in creating patient web forms and web based configuration tools.

Environment:Oracle 10G, Jira,Android, IOS and WEB, SSIS, Firebug, XPath, Web Services, Waterfall methodology, C#, ADO.Net, SQL Server 2008.

Contact this candidate