Software Engineer Quality Assurance

Detail oriented and results focused Software engineer / QA Automation Engineer with around 8 years of professional experience in IT Industry. Extensive experience in application development, software quality assurance, all manner of SDLC methodologies including, Agile, and SCRUM. Proven skills in global resource coordination/management, framework development, training, requirements gathering, documenting functional specifications. Highly motivated and efficient Team Player, with excellent Interpersonal, Communication and analytical skills.

Profile Summary:

Around 8 years of industry experience in Software Engineering with a solid understanding of Requirements gathering, Design, Execution and Defect Reporting & Tracking.

Proficient in requirement analysis, testing various modules in a software development life cycle (SDLC) and software testing life cycle (STLC).

Extensive experience in Agile Safe methodology as well as Scrum & Waterfall.

Proficient in analyzing business users’ requirements and preparing a design model that meets the end goals.

Extensive Experience in developing, executing and maintaining Regression Test scripts using automation tools developed using python, C#, Selenium Web Driver, Selenium RC, Java, TestNG, JUnit Framework.

Execution of series of commands in a sequence to facilitate automated test execution around synapse ELT process using python-based database testing automation tool and validate the application data by comparing with source data.

Worked with the ETL processes to extract the data from sources like Oracle, Flat files, thereby loading the data into the target Data warehouse.

Strong Experience in automating Angular Web Application Testing using Tosca automation tool.

Expertise in Behavior Driven Development (BDD) framework like Cucumber to write test cases using efficient testing tool for Web Automation like Selenium.

Developed Test Cases for ETL validations by comparing Source and Target database systems.

Executed the developed Test Cases and Test Plans. Responsible for creating Test Strategy for the Data Warehouse.

Professional experience in Integration, Functional, Regression, System Testing, UAT Testing, Black Box and GUI testing.

Expertise in RESTFULL web service testing using Rest Assured framework with java. Validated JSON formatted data, different http status code like 200, 400 and 500 series.

Verified soap call response in xml formatted data, worked with added test cases and Assertion Using SOAPUI NG PRO, also used Data Source loop and data Source for Data Driven Testing from Excel or from Grid itself, used Data Sink for Automated Report generations.

Experience with bug tracking and test management tools such as JIRA, Rally, Quality Centre.

Experience in Performance Testing using Mercury Load Runner Automation tool.

Experienced in formulating Test Plans, Test cases, Test Scenarios, Test Approach and set up testing environment. Experienced in writing documents.

Self-motivated, energetic and highly ethical in all work-related assignments thus able to immediately contribute to corporate goals and objects.

Technologies:

Programming and Automation Tools

Python, Java, Unix, Protractor (with Jasmine framework), HTML, CSS, XML, JavaScript, GIT, Maven, Selenium WebDriver, Tosca,TestNG, JUnit, Cucumber, Remedy, TFS.

Webservices

Ready API (SOAP UI Tool), Rest Assured framework, Postman.

Continuous Integration & Defect Tracking Tools

Azure dev Ops, Git, Jenkins, Jira, Quality Center.

ETL Tools

Azure Synapse analytics, SSIS (SQL server Integration Service), IBM InfroSphereDatastage11.3, Informatica Power Center 8.6.1

Data & integration Tools

Azure SQL, SQL server, Oracle, Teradata, SQL Server Integration Services.

Data Analysis & Visualization

Power BI, Spotfire.

Professional Experience:

Chevron, Houston, TX Sr. Automation Testing Lead May ‘19 – Till Date

Project: Oil Field manager provides users to view, relate and analyze reservoir and field performance with comprehensive tools that includes interactive base maps with production trends, diagnostic plots, bubble maps, grid and contour maps, data filtering, dynamic grouping, reports, analysis and data exports. This tool is equipped with UI Rich Microsoft .Net components along with built in plugins. Few of the major modules include Decline Curve Analysis, Pattern management, Forecast Manager, Type Well Manager, Annotation manager and Data viewer.

Responsibilities:

As an Automation Engineer, I am involved in implementing the framework, developing automation scripts for the new User stories and maintain and run the Regression test scripts.

Create, review and analyze Functional Specifications by interacting with different Business Users, functional SMEs to generate the acceptance criteria.

Develop Test strategy, test plan/design, execute test cases to perform functional, performance, integration and regression test cases, and update documentation.

Developed SQL queries to test Data Integrity, Referential Integrity and performed Database Testing for the Application.

Built a Modular Azure test automation framework using python to validate the application data by comparing with source data.

Developed and executed various SQL queries in the Json test case files that validates the data at various stages of ETL process and analyzed the results generated in excel reports.

Analyzed and written ETL validations by creating matrix data that checks all job statuses at various batches.

Generated SQL scripts at various stages of ETL process that validates the business logic.

Develop scripts to automate the synapse jobs that load data from various sources like data lake, Azure SQL based data foundation and Synapse SQL end points.

Create and monitor synapse job triggers in Azure Synapse studio for different business units and debug issues and monitor pipeline progress.

Tested Power BI reports and generated data quality reports.

Performed End to End that include functional, integration, user interface, performance and regression testing.

Used Azure DevOps for continuous integration, tracking the user stories and defects.

Run Deployments and assist in communicating to BU's and provide any technical support needed by the users by running data quality checks.

Coordinate with SME’s and assist them in providing data validations if there are any data issues reported by Business Users.

Touch base with Sensia developers on regular basis and follow up on the enhancements/bugs reported by central team as well as feedback received from business users.

.

Tools: SQL Developer, Oracle, SSIS, Synapse, python, Tosca, azure dev Ops, ADF, Git, MS visual studio code, MS visual studio.

Malauzai Software, Austin, TX Sr. SDET Aug ‘18 to Apr ‘19

Project: Loan Management System allows a retail finance organization to optimize their loan Management process by integrating Field Investigation, Mortgage, Processing, Recovery and Property management Systems in a Central Unit. Being web-based, it gives an organization truly anytime, anywhere access.

Responsibilities:

Analyzed the Business requirement (TRD- Technical Requirement Document) and Design documents to develop Test Plan and performed Manual and Automation testing on this Web based application.

Participated in the walkthroughs with the Business Analyst and development team to understand the requirements and to formulate test scenarios.

Involved in Functionality, User Interface and Regression testing in various phases of development.

Performed Integration and Regression testing to check compatibility of new functionality with the existing functionalities of the application using Selenium WebDriver.

Extensively used Web Driver APIs such as Select, Action, JavaScript Executor (for Java Script run), Take screenshot for test script automation development.

Used Java concepts of Collections (List, Set, and Map), IO (Apache POI), XML, Properties to create dynamic framework for UI and API automation (HTTP Client).

Customized TestNG.xml for running test cases for different stages.

Shell scripting was done to execute batch jobs.

Used Maven to build and run the Selenium automation framework. Once the script got over, framework used to send the automation reports over email using continuous integration tool Jenkins and version control tool SVN.

Developed test scripts using groovy for data driven testing of SOAP Web service using SOAPUI.

Used Groovy (Set up and teardown script, Files, Looping, classes, methods) to write test scripts for SOAP Web Services.

Performing QA within an Agile development while leveraging continuous integration (CI) to keep ahead of the development pace.

Automated the test results generation by loading the results into excel files using Apache POI and Http Client libraries.

Wrote advanced Oracle SQL queries for test data generation of advanced test scenarios

Tools: JAVA, Web Driver, Rest Web Services, SQL Developer, Oracle, PLSQL, JavaScript, TestNG, Linux, Shell Scripts

Verizon Tech, Austin, TX Data Quality Engineer Jun ’17 to Sept ‘18

Project: The project objective was to implement and maintain a new Application Support Group with an automated ticketing system. The product is fully integrated, web-centric, real-time problem reporting and servicing solution that automates raising and tracking the ticket for Verizon customers, application support group and high-level managers. The project also involved creating a new Knowledge base to store the periodic, daily and recurring problems so that the ASG could gradually use it to store the information and data and provide quick updates and quick services to the users and high-level management.

Responsibilities:

Analyzed Functional Requirements Document and Use Case to create Test Plan and Test Cases.

Performed Functionality, Integration, Regression, Backend and System testing.

Performed backend testing to validate database contents by writing and executing SQL Queries.

Create and maintain any Issues and Risks that were logged by users.

Interacted and worked with the development team to solve the problems encountered in the test scenario run.

Extensively worked on creation of Data driven framework, Modular Driven Framework using, selenium WebDriver.

Followed entire SDLC life cycle in this project from Requirement, Design, Coding, Testing and implementation

Wrote and executed SQL queries in SQL Server Management Studio to perform backend testing to ensure that the front-end results are the same as the back-end results and to check the changes done by the developers

Based on Hybrid framework, developed Selenium test cases in Java using TestNG

Conducted Cross browser testing in IE, Chrome using TestNG.

Tested Hybrid mobile app using Appium and selenium.

Good understanding of working on the applications developed for touch screen devices.

Reported the bugs, Email notifications to the developers using Jira.

Reproduce functionality problems submitted by customers via technical support department

Conducting test results/bug status meeting with Development and all appropriate stakeholders

Participated in daily Scrum meetings and walkthroughs

Tools: Core Java, MySQL, JDBC, UNIX, Servlets, HTML, Selenium web driver, Junit, Appium, Jira.

Tata Consultancy Services, Hyderabad, India ETL Developer Dec ’14 to Apr ‘15

Project: Cargo System is a unique terminal management system, which can be used at single- and multi-purpose terminals. The application is used to register administrative information related to cargo and vessels, trucks and trains coming to the terminal, as well as for the follow up of the actual operations, both on the waterside and on the landside

Responsibilities:

Attended requirements, design meetings, review, analysis of requirements and design documentation.

Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/DataMart tables.

Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Created Informatica Data quality plans according to the business requirements to standardize, cleanse data and validate addresses.

Integrated data quality plans as a part of ETL processes.

Maintained SQL scripts and complex queries for analysis and extraction.

Improved efficiency for clients by training new programmers in organizational ETL processes.

Debugged existing ETL processes and did performance tuning to fix bugs.

Responsible for coding and unit testing, resolve testing issues and updated in Bugzilla.

Tools: Informatica Power Center 8.6.1, Informatica IDQ 8.6.2, Oracle 10g, SQL, PL/SQL, TOAD, SQL Server.

Goliath Inc., Hyderabad, India Software Developer May’14 to Dec’14

Project: Online Resources System – This is an application for online-business content service and promoting e-learning, e-training, e-collaboration over Internet. Its motive is to bring education, training, certification etc. and other domains on a single platform, evaluate them to collaborate, share the knowledge, resolve the problems and provide instant solution to the client. It has three kinds of users: Client, Student, Customer, Trainer and Administrator who manages the entire the portal site.

Responsibilities:

Extensively worked on design and development of Online Resource System which is capable of handling batch processing and parallel processing

Developed web GUI involving HTML, JavaScript, CSS, JSP, Servlet and beans

Involved in coding reviews and enhancement of application

Interact with product management team to understand business requirements Developed set of business logic components related to TID application modules

Designed& Developed hibernate statistics tool that used by all developers in SI to debug real time performance issues related to hibernate

Managed connectivity using JDBC for querying/inserting & data management including triggers and stored procedures

Setting up of CVS Repository for all TID applications

Developed various components of the application and unit test them

Dealt with java Beans helper classes and servlets for interacting with the UI

Written SQL Queries to interact with Oracle database

Developed Servlets, Session and Entity Beans handling business logic and data

Dealt with the database operations e.g., Calling stored procedures and stored functions

Deployed Enterprise application using WebLogic Application Server

Involved in planning & perform testing, verification & validation, quality assurance of the application

Tools: Java, JavaScript, Servlets, Oracle, MS Excel, HTML, CSS, XML, SQL, Quality Center, JSP, WebLogic server UNIX/Linux, Hibernate.

Education Details:

Masters Deree in Software Engineering, University of Houston, Clear Lake.

Bachelor’s degree in computer science and engineering, SRKR Engineering College (Sagi Ramakrishnan Raju Engineering College), India.

Contact Info:

Email: *****.****@*****.***

Mobile: +1-832-***-****

Contact this candidate