Sunil Kumar Panda
Associate Consultant
**************@*****.***
***, ****** ***** ***** ****** Layout Banglore,Karnataka India linkedin.com/in/sunil-kumar-panda-435751136
A professional with 4.3 years of experience in Software Quality Assurance. Expertise in managing software testing including test strategy, test plan development, test cases/ test script creation, test case execution, risk and defect management using JIRA. QA Expertise: Data Quality Assurance, DB & web application Automation Testing, Bug Logging with Jira, Defect Management, Team Management. WORK EXPERIENCE
SOFTWARE QA ENGINEER 1
IQVIA (Manpower India payroll) 10/2019 – 09/2021
Achievements/Tasks Bangalore
- Reconcile records with the source data, datatype check, ensures no spam data & duplicate data loaded, check all the keys are in place, check applied transformation logic as per TDD, data threshold validation check, accuracy of the implemented business rule.
- Hands on experience in writing SQL queries & ETL Testing with python framework. Statistical analysis of cyclic market data.
- Good Knowledge on healthcare domain.
-Hands on experience on migration project.
- Actively participated in Test design,Test plan & Review session with peers and onshore stakeholders.
- Test data preparation for Functional and Integration testing.
- Good knowledge of Functional, Integration and System Testing.
- Developed a front-end application with python Tkinter library for test data creation form automation test framework.
- Experience in manual & automation testing (Selenium with python), Database Testing and API testing.
ASSOCIATE CONSULTANT
CAPGEMINI (IKEA) 09/2021 – TILL DATE
Achievements/Tasks Bangalore
Design Traceability matrix for mapping customer requirements.
Participate in Scrum meeting to discuss about project progress report every day.
Responsible for Test Case Writing, Execution, Bug Tracking and Reporting.
Responsible for web-based Testing including Functional, Non-Functional, Retesting and regression testing.
Involved in executing SQL Query to perform database testing in SQL Server.
Involved in Web service testing using POSTMAN tool.
Used REST API tool for Web service functionality testing.
Extensive Experience in TMP & defect management process using tool such as Zephyr. Good understanding in PYTHON library like Pandas, NumPy, selenium,pytest and implemented test script with OOPS Concept.
Experience in writing Xpath expression and CSS. Executed test scripts on Firefox and Google chrome.
Performed Cross browser testing using Automation through Selenium Webdriver.
Experience in identifying object locators and creating Page Factory for all the pages available in application.
Handling Synchronization (Implicit, Explicit waits), Handling Popups, i-Frames, List Box & Actions, TestNG & Annotations, designing POM (Page Object Model) classes.
Ability to learn new software quickly. Effective communicator with all levels of Project management, business, developers
EDUCATION
BTech In ME
Institute of Technical Education & Research
08/2014 – 06/2018 Odisha, India, GPA-8.27
Kendriya Vidyalaya No-1
03/2012 – 06/2014 Odisha, India, %-74.2
SKILLS
SELENIUM SQL MANUAL TESTING
AUTOMATION TESTING ETL TESTING
PYTHON AZURE HTML CSS
COURSE/CERTIFICATION
COMPLETED
Qspiders Software Testing Training Institute
Bangalore,03/2019 – 08/2019
AZURE DP-900 certification completed
successfully. Online, Microsoft– 06/2021
PROJECTS
Automation of end-to-end testing process
using integrated framework.
Used different python library to establish
connection to the databases & automate
web application.
Developed a regression testing framework with
python Pandas Selenium, Robot framework,
Pandas & NumPy libraries.
ACHIEVEMENTS
Participated in Various Testing Competitions
within and outside the organization (like
Hackathons, etc.)
LANGUAGES
English
Full Professional Proficiency
Hindi
Full Professional Proficiency
Odia
Full Professional Proficiency
INTERESTS
Data Science Functional Testing
AI ML Appium
Playwright API TESTING