Post Job Free

Resume

Sign in

Sql Server Web Services

Location:
Garner, NC
Posted:
September 20, 2023

Contact this candidate

Resume:

Avinash Gogineni adztxy@r.postjobfree.com 404-***-****

PROFESSIONAL SUMMARY

15+ years of experience in QA testing of software systems in Web based, Client/Server, cloud based, Mobile App and mainframe applications using Manual and Automated testing tools.

Extensive experience and strong knowledge of Quality Assurance in Retail, ERP, Banking, Healthcare (Hub Services in Specialty Pharma & EDI Transactions) and E - commerce domains.

Extensive Experience of QA Methodology, SDLC, Project development life cycle and QA Processes.

Expertise in creating, Master Test Plan, Test Reports, Test Cases and Test Scripts for Manual testing based on the functional specifications.

Specialized in reviewing, System Requirements, Infrastructure Requirements, Workflow Diagrams and Architectural Diagrams. Documenting Master Test Plans.

Expertise in Black-Box Testing, Functional, Automation, System, Integration, Regression, ETL Testing, MDM Testing, end-to-end testing, GUI, UAT, Database, Smoke/Sanity, Adhoc and Compatibility testing

Proficient in designing and building test cases and test plans for Identity Access Management (IAM) solutions like SailPoint IIQ and Okta

Hands on experience with validation of Joiner, Leaver, Mover and Job Transfer (JML) lifecycle events with SailPoint IIQ 8.x

Strong experience in testing the ecommerce applications in Tablet, Mobile app, Mobile web.

Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.

Expertise in MDM Testing with the tools Profisee, Stibo Systems (STEP)sle

Experienced with Verification of Master Reference Data, Control Total Checking, Data Standardization and Cleansing, Data Transformation checking, Duplicate Record verification, Attribute correctness check

Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).

Expertise and proficient in Software Testing Life Cycle (STLC) – Requirement Analysis, Test planning, Test design, Test data identification and Defect management.

Experienced coordinating and working with offshore and onsite team (QA, Dev, PM, BA, SME)

Hands on experience in implementing Agile (Sprint/Scrum) and Waterfall methodology.

Experienced in creating test scripts and performing End to End Testing in Ecommerce and ERP Domains.

Experience in performing testing on cloud-based applications Sales Force and custom configurations in SFDC.

Experience in testing custom object fields, role-based page layouts, list views, detailed views, reports in Salesforce testing in Sales cloud and service clouds.

Experience in testing standard and custom workflow rules, validation rules in salesforce applications.

Experience and strong knowledge on Oracle applications functional modules PTP (Procure to Pay), QTC (Quote to Cash).

Good working experience in automation tools: Selenium Web Driver, QTP.

Experience identifying regression test scenarios and converting into Automation scripts for reusability.

Good Experience in Web services testing using tools SOAP UI, Postman and automated by Groovy script.

Worked in DevOps, installing, configuring and integrating Automation scripts on Continuous Integration tools (CI/CD) like Jenkins for nightly test suite execution

Strong knowledge and experience in Test management tools HP Application Life Cycle Management (ALM), Quality Center (QC)

Good knowledge and experience in project building and version control tools Maven, GIT and SVN

Experience in Splunk reporting tool. Good knowledge in UNIX commands.

Experience in ETL, EDW, Data Migration testing, Report Validations using Step application Stibo systems.

Expertise in export rule checking and data format validation, Database validation for import data and Role based testing for Product Master Reference Hub.

Project Management skills including estimating, scope management, time management, risk management, change management, issue/conflict resolution, communication management, quality management, testing plans, training plans, and team management.

Acted as Project Lead in complex projects (onsite – offshore model) and good Team player.

TECHNICAL SKILLS

Operating System

Windows NT/2000/2003/Windows7, XP, Unix

Development Methodology

Agile, Waterfall, V model

Languages

Java, PL/SQL, C

Database

Oracle, SQL server, DB2

MDM Tools

STIBO Systems STEP, Profisee

Automation

Selenium web driver, QTP

Web Service Tool/Language

SoapUI, Rest API, POSTMAN, Fiddler, XML, Json, Groovy

Project Management Tools

JIRA, ALM, QC, Jira Zephyr, Version One, Remedy, Pivotal Tracker

Reporting Tools

Splunk

Mobile App Testing Tool

Emulator

File Transfer API

FTP Tools (Win SCP and File Zilla), Beyond compare

Cloud Applications

Salesforce

Framework

Cucumber, Page Object Framework

Version Control tools

GitHub, SVN

ERP Modules

PTP, OTC, ATC

Mobile Test OS /Other

Aandroid, iOS.

PROFESSIONAL EXPERIENCE

Sr. Software Quality Control Engineer Jan 2021 – till date

North Carolina Administration of Courts (State Project), Raleigh, NC

Responsibilities:

Analysis of all functional and business requirements from the functional design specification and product backlog sheets.

Responsible for Responsible in reviewing configuration in TEST and PROD environments

Responsible for test cases preparation and peer review with QA team based on PDDs.

Worked in Agile/Scrum model by participating in Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Creating the defects on the AOC SharePoint and integrate them with Tyler’s JIRA boards, and tracking the fixes and other changes on a daily basis.

Tested security and sharing rules at different levels of the organization profiles in sales force applications.

Verified dash boards, validation rules and workflow alerts and action based on client and business requirements.

Executing tests on dev, test, and production environments and Performing E2E integration testing and UI testing.

Conducted defect triage meetings with development and BA for fixes and validate back.

Performing E2E integration testing and UI testing.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Identifying and automating the regression test scenarios. Develop and execute automation scrips using Selenium webdriver

Training Judicial officers, Police officers, Magistrates, and court clerks on the functionalities and assisting them in reporting and resolving the data discrepancies and tested data security, user-roles access testing, and accessibility testing.

QA Lead Mar 2018 – Jan 2021

CareMetx LLC., Bethesda, MD

Responsibilities:

Lead team in offshore and onsite which is responsible for functional, integration, regression, and sanity testing.

Responsible in reviewing test cases prepared by QA team based on user stories.

Worked in Agile/Scrum model by participating in Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Tested integrated external applications with salesforce.com.

Configured by creating users and user profiles and created roles in Salesforce cloud applications.

Tested multiple objects such as Leads, Opportunities, Accounts and campaigns in sales cloud platform in salesforce applications.

Tested workflow rules and custom page layout based on profile in Sales and service clouds in SFDC applications.

Created reports and report folders to help managers better utilize salesforce as sales tool.

Configured and tested reports for different user profiles for specific salesforce applications.

Tested ETL maps for correctness to move data from source to target.

Validated the source database, target database and transformations.

Experience in testing middleware integration components using SOA Webservices.

Responsible in handling production deployments and prepare Sanity Test Plan to perform after production deployment.

Worked closely with Scrum Master/Project Manager/Director/Stake Holders/BAs about the status of testing efforts, state of the system and provide input on system acceptance on daily basis.

Report project status, metrics, and process innovation to Test Manager/QA Director on weekly basis as part of Weekly QA Core meeting.

Analysis of all functional and business requirements from the functional design specification and product backlog sheets

Responsible for Verification of Master Reference Data, Control Total Checking, Data Standardization and Cleansing, Data Transformation checking, Duplicate Record verification, Attribute correctness check

Involved in testing match rules for de-duplication in Profisee (MDM) tool.

Providing LOE for the user stories identified for the sprints

Prepared Test scenarios to test the web services using Postman, Soap UI tools for rest service testing.

Executing tests on dev, test, and production environments.

Conducted defect triage meetings with development and BA for fixes and validate back.

Involved in EDW E2E Testing using SQL Server

Perform backend validation in SQL server using SQL quires. Performing E2E integration testing and UI testing.

Identifying and automating the regression test scenarios using selenium webdriver.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Involved in DevOps Migration/automation processes for Build and Deploy systems.

Setting up Jenkins’s master, adding the necessary plugins and adding more slaves to support scalability and agility.

Sr QA analyst April 2017-Feb 2018

Genuine Parts Company Atlanta, GA

Responsibilities:

Analysis of all functional and business requirements from the functional design specification and product backlog sheets

Creating Jobs to run daily, weekly, and monthly basis to process ETL Jobs.

Tested the source, Target databases and Transformations.

Active participation in Sprint Planning, Review and Retro.

Providing LOE for the user stories identified for the sprints.

Preparation of Test Plan and Test Strategy document

Perform ambiguity reviews on requirements and design documents.

Prepared Test scenarios to test the web services using Postman, Soap UI tools.

Executed sessions and batches in Informatica and tracked the log file for failed sessions

Creating Jobs to run daily, weekly, and monthly basis to process ETL Jobs using Informatica.

Executing tests on dev, test, UAT and production environments.

Conducted defect triage meetings with development and BA for fixes and validate back.

Coordinating with the offshore and onsite team and update project plan and status reports

Perform backend validation in SQL server using SQL quires.

Executed SQL statements manually to execute record counts on each table loaded into system and compared with source table

Data validation of flat files using UNIX commands from FTP.

Identifying and automating the regression test scenarios using SOAP UI groovy scripting.

Maintaining the team in terms of status reporting, resource management and reporting.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Preparing User documentation for the UAT use cases.

Participating in Code reviews.

Sr. QA Analyst and QA Lead Sep 2013 - Mar 2017

The Home Depot (THD), Inc Atlanta, GA.

List of Major Projects in THD:

1.Worked in COMPASS - This project intends to retire the JDA platform and eliminate the third-party hosting arrangement with JDA for STH, STS orders and implanting in Sterling platform.

2.Worked in Project7 Blinds - The objective of Project 7 Phase III is to provide an integrated shopping experience between Homedepot.com/Blinds.com.

3.Worked in One Page Checkout - project provides a streamlined, single-view checkout experience for the customer across desktop, tablet, and mobile channels.

4.Worked in TDM (Test Data Management) - To develop and maintain a Data Setup and Data Maintenance Strategy across all LLC for all the Home Depot Online Projects. Developing Test data Tool to fetch the golden data with different requirement combinations.

Responsibilities:

Analyzed Business Requirements and Functional Specifications and developed Test Plan detailed Test Scenarios, Test Strategies and Test cases.

Creating Master Test Plan document and get it signed off from Business teams.

Participated in Agile grooming sessions, scrum meetings, retrospective/planning sprint reviews by identifying tasks and estimating story points for each task.

Created, Updated and Reviewed of Test cases and Test Scenarios as per the business requirement and executed them in ALM tool.

Maintained and coordinating the offshore and onsite team.

Experienced at testing ETL's and flat file data transfers without relying on a GUI layer.

Preparation and execution of E2E, Integration Test scenarios.

Preparing and Maintain Traceability Matrix document.

Maintain/develop the automation scripts as per new stories and changes.

Automate the test cases using Selenium Web Driver.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts

Provided estimations to automation and carried out automation testing of web services using SOAP UI, POSTMAN.

Integrated Selenium automation with continuous integration i.e., Jenkins for continuous test runs.

Monitored Jenkins jobs for test runs and raised defects for legitimate test failure

Interacted with development teams for defect fixes. Used JIRA, ALM, PVT as defect tracking tool.

Performed Integration testing to test the functionality of the modules

Created test scripts for API testing automating functional tests, regression, debugging

Fiddler tool to help Web services Rest methods integration.

WinSCP to transfer files to remote server and file management

Performed Back-end testing using SQL queries to access the main database.

Data creation and data setup using writing SQL and running delta feed jobs for the data requests which received from different teams.

Communicate risk to QA Leads and QA Manager as needed.

Responsible for preparing the Test summary and Execution status reports on daily and week basis.

Preparation of various kinds of process artifacts like Requirement Traceability Matrix, Code Review Reports, Test reports, KT documents.

QA Analyst Sept 2011 – Aug 2013

Qualcomm Inc. City, Bangalore.

Responsibilities:

Understanding the Business requirements and analysis of Business Requirement Documents (BRD), Functional and Technical Specification (FS/TS).

Preparation, execution of Test Cases and Report the defects in QC.

Performed testing on custom objects, Page layouts, custom tabs, components and triggers workflow rules on salesforce applications different sandboxes.

Involved on salesforce custom configuration by creating custom profiles, page layouts, Roles.

Created Email templates and rested in sales and service clouds in SFDC application.

Verified visual force pages, Dashboards, validation rules, roles, users and permissions.

Created and tested list view and detail view pages in SFDC as per user roles.

Developed and maintained the Traceability matrix between requirements and test cases.

Involved in the Development of Plan and Test Cases for Integration, Functional, System and Regression Testing.

Perform cross browser functionality Testing.

Performed Sanity, Functional, regression, Integration and E2E testing.

Responsible for data set up and Test environment.

Performed Back-end testing by writing SQL Statements.

Scheduling batch test, log and track defects using HP Quality Centre. Executed test cases before and after bug fixes for each build for User acceptance testing.

Actively participated in Conducting Peer reviews team meetings and walkthroughs.

Executed the test scripts on different releases and validated the actual results against the expected results.

Involved in UAT and executing sanity test in production server and production support during deployments.

Software QA Engineer Feb 2008 to Sept 2011

Motorola INC, Motorola Mobility, USA Bangalore.

List of Major Projects in Motorola Mobility:

1.Worked in MD - ecommerce Platform Replacement

2.Worked in MD NA ERP_L3 Bundle Releases

3.Worked in Global Logistics

4.Worked in Critical Patch Updates (CPU)

5.Worked in Revenue Cycle Project

Responsibilities:

Understanding the Functional Requirements and Scope of the Application

Responsible for delivering test design, test execution and test reporting of the application.

Developed QTP automated test scripts for ease of execution.

Enhanced modified test scripts as and when required.

Data creation of different interfaces using automation scripts.

Execution of Scripts as and when required. Analyzing the results and reporting defects.

Involved in system test cases and regression test cases preparation and execution.

Reporting daily execution status to all the project stake holders.

Conducting defect triage meeting and working with development team to close the defects.

Performing Back-end testing using SQL queries.

Prepared ERP oracle apps functional test suits for PTP (Procure to Pay), QTC (Quote to Cash) Modules using QTP and Manual.

Executing automated regression test suits on weekly basis and report the issues.

Preparing Test summary reports on daily/weekly basis.

Creating and Maintaining the Traceability Matrix

Conducting and participating in Peer reviews for test scenarios and test results.

Software Engineer Oct 2006 to Nov 2007

Bank of America Bangalore.

Responsibilities:

Participated in Requirement Analysis, Use-Case Analysis with Business Analysts, project Architects, Leads and developers

Developed, execution and maintenance of test cases based on functional specifications. Ensure that all the test cases are updated in the Quality Center along with test plan.

Perform the compatibility testing using different browsers. Perform IVR call testing.

Executing automated regression test suite in QTP.

Identifying regression test cases and maintain and updating for each release.

Coordinating with automation teams and helping them to understand the functionality to automate the regression test suites.

Participating in daily status meeting and update the testing status and defects status.

Participating in code review and test case review meetings.

EDUCATION QUALIFICATION

Pursued Master of Science in Computer Science (2003), Bharathidasan University, Tiruchirappalli, Tamil Nadu, India.



Contact this candidate