Sathish Kumar Saparapu

Fanatics Inc E-commerce, Hyd, Telangana (9th Jan 2021 to present)

Role: Software Quality Engineer -III in Test Division: IRIS, customer-org Technologies: Postman collections, Selenium, GitLab, sauceLabs, Applitools, SFMC, Twilio

Langaues: Node.js, Javascript, postman script, Go Lang

Key Accomplishments:

Matrix:

• Developed a UI automation framework for an E-commerce application using JavaScript and Selenium.
• Executed remote runs in Sauce Labs and Appli-tools.
• Implemented the framework using the Page Object Model.
• Added multiple tests to the framework.
• Implemented multiple utilities to integrate backend APIs.

UCP API Automation:

• Designed and created an end-to-end testing framework for the Universal Communication Platform (UCP), which handles communication channels like email and SMS.
• Utilized Postman collections and Node.js for developing the framework.
• Implemented validation using Chai and Mocha.
• Created mock services for integration testing.
• Integrated with SFMC (Salesforce Mailing Service) for testing purposes.
• Incorporated Twilio for SMS testing.
• Generated test result reports using htmlextra.
• Utilized GitLab for CI/CD.
• Integrated Slack services to post the test results in dedicated channels.

Juno API Automation:

• Created end-to-end automation for Juno APIs, which includes 5+ microservices.
• Used Postman and Newman to implement automation.
• Created mock services for integration testing.
• Generated test result reports using htmlextra.
• Utilized GitLab for CI/CD.
• Integrated Slack services to post the test results in dedicated channels.

Role: Software Development Engineer in Test -II (SDET)

Division: Progress Data Direct products

Technologies: JDBC, ODBC, ODataV2, ODataV4, Web services, and REST API

Languages: Java, C, Python

Frameworks and Test Suites Worked On:

DSM Verification Suite:

• Developed a Java and TestNG framework for verifying REST APIs of Progress Hybrid data pipeline.
• Implemented JSON serialization and server API calls for verifying REST APIs.
• Utilized Jersey client for web client service.

ODVS (OData Verification Suite):

• Created a Java and TestNG framework for validating Progress Hybrid data pipeline's OData 2.0 and OData 4.0 connectivity.
• OData is an open data connectivity protocol that exposes data in RESTful APIs from RDBMS.
• Employed Jersey client for web client service.
• Conducted validation of OData calls and their respective SQL calls using JDBC.

Power BI Custom Connector for Progress ODBC Drivers:

• Developed a proof of concept (POC) for Power BI custom connector as part of the Innovation Program, which later became a feature for Progress ODBC drivers.
• The Power BI custom connector enables direct query mechanisms for ODBC data sources.
• Used Power Query SDK and M language to develop the connector.
• Created connectors for Pivotal Greenplum and PostgreSQL ODBC drivers.