Shivam Saxena

Cigna Healthcare Ltd

Developed the Automation Framework to test the Billing Data transfer functionality and Data Validation in Cigna Healthcare Application.

Framework Design

• Designed to automate the processing of Billing files in the healthcare domain.
• Streamlines and Enhances the accuracy in Billing Operations.
• Integrates the SQL Server for Data Management.
• Utilizes Python Scripting, Selenium, Robot Framework in Test Automation Development.

Key Features

• File Parsing : Parses various billing file formats (e.g JSON to CSV) to extract relevant data.
• Data Validation : Performs validation checks to ensure data accuracy and compliance with regulations.
• Orchestrates the end to end billing process from the ingestion to the final reporting.

Scalability and Flexibility

• Designed to handle large volumes of billing files efficiently.
• Automation Framework Architecture allows for easy customization and expansion as business requirements evolve.

Shell Information Technology International B.V.

Developed Automation Framework to Test Shell Oil Pricing Application in both retail and wholesale Areas.

Test Planning & Design

• Formulated effective test plans to ensure that it adheres to the requirements of the clients and users
• Maintain the timely builds and monitor the automation test results for any failures and fix the failed scripts on time-to-time basis due to environment issues.
• Responsible for testing the APIs calls using postman, requests, pytest.
• Develop and maintain automation-testing framework with team for Interfaces UI & API automation using Selenium, pytest, python scripting, requests and SQL to reduce manual efforts by 80%.

Scripting & Coding

• Executed component-based approach and developed automation scripts to reduce maintenance costs by 50%
• Maintained suitable coding standards for the entire project life cycle to avoid repetition of coding errors.

Test Report Review & Documentation

• Coordinated with the 20 members functional team to review the test reports.
• Implemented continuous integration and deployment pipelines using Jenkins, reducing the time required for test execution and reporting.

Debugging & Troubleshooting

• Located root cause, debug and analyze by reviewing logs , troubleshooting the issues and configurations.
• Documented test report on a daily basis to analyze the existing errors and performed the necessary troubleshoot

FORD MOTORS

Application Development

Developed the Python Automation Framework to test the functional features of Ford Motors SYNC Application which use to run on Infotainment System

• Examined and implemented required changes to improve the functionality the existing software application (SYNC Application).
• Develop and maintain automation-testing framework with team for UI automation on SYNC Features using Selenium, pytest, python and SQL to reduce manual efforts.
• Collaborated with cross-functional teams to define test scenarios, test cases, and test data for new features and enhancements.

System Testing & Documentation

• Setup the Automation framework using Selenium WebDriver to run test cases in multiple browsers and platforms.
• Performed Regression testing on new builds, every modification in the application using Selenium WebDriver.
• Performed all aspects of verification including Smoke testing, Functional Testing, and Regression testing on major functionalities of the application.
• Developed and maintained a scalable and robust test automation framework using pytest, improving the efficiency and reliability of test execution.

Bug Tracking & Troubleshooting

• Investigated issues in 10+ applications and developed a solution to fix them on time
• Managed bug tracking system and performed troubleshoot and resolved issues to improve performance by 20%