Akshay Ghuge
Pune
Summary
Results-driven Quality Engineering Specialist with expertise in ETL testing and automation at Citi. Proficient in Java and Selenium WebDriver, I successfully developed an automation framework that enhanced testing efficiency. Adept at JIRA for task management, I excel in collaboration and problem-solving, ensuring high-quality deliverables in fast-paced environments.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Specialist -quality engineering
Citi
01.2024 - Current
- Data and logic validation are done for the ETL process. Stage layer is for purely data validation and in fact and summary layer there is mostly derived logic validation. Tableau and Gateway report are created and those are end point for the above ETL processed data. These report’s UI validation is part of QA validations. Performance check of reports and support to testing efforts of portal and entitlements check are the responsibility of QA. Created and enhanced the TestNG based BDD Maven project for automating the performance check of the report on client portal.
- Creating manual test cases for the ETL layer validation based on the stage, fact and summary layer.
- After the changes are deployed by Dev then validate it thoroughly if there is enhancements then validate it also do regression check for it as well.
- Take all necessary evidence recorded and SQL queries and provide as the test results into the test case Jira for task.
- Validate the UI dashboard check the respective functionality and validate its data with the respective DB table data logic. Document the evidence for the UI report validation and provide as the test results into the test case Jira for task.
- Do the validation checks for the other projects such as client portal product validation and Reports enhancement validations.
- Running weekly the automation suite created for performance checks of the dashboards on client portal and publishing it to the leads.
- Keeping updates of weekly Jira planned also daily UI report stability checks and report onboarding on Infinity Automation web application.
Specialist -quality engineering
Citi
07.2022 - 12.2023
- For CITI working the ETL testing. At initial stages it was manual testing of ETL. Its about data validation from 2 tables creating scenarios to test that 2 tables. There are 4 stages to test i.e. flow of testing is from pre stage >Stage>Fact>Summary.
- Then created automation framework to test this ETL testing. For All scenarios(around 14 TC’s) currently are created in automation framework. This automation framework on Citi FAST framework for regression testing and to save time of testing during testing at first. Its efficiently used for its regression and time saving purpose.
- Also doing the manual testing of tableau dashboards.
- Creating the manual test cases for ETL testing.
- Understand the BRD to create the business test cases for ETL.
- Cover all coverage of ETL in testing scenarios.
- For all 4 stages stage, fact, summary and pre stage execute the test cases and find the defects if any.
- Created the automation framework in java for this ETL testing.
- Automation framework have validations covered for all testing scenarios.
- Create excel for test result for manual test cases execution of ETL TC’s.
- In automation execution report is generated on Email and logs of it are attached into that same Email.
- Create SQL scripts according to the testing scenario’s.
- Update the TC’s On testing Jira’s accordingly and execute it.
- Create test cases for tableau dashboard manual testing and execute it.
- Create the excel with test result for the execution of those tableau test cases.
Consultant
Morgan Stanley
07.2020 - 06.2022
- Company Overview: Morgan Stanley helps people, Government raise and institute raise, manage and distribute the capital they need to achieve their goals.
- In this project we are working on different banking application of the client. Mobile application and Desktop application is there for our working. Client have to maintain data of client for banking, trending and investment. There is also Web application from bank for its customers.
- Also currently working in agile project on API. Providing a common working between two organizations.
- Understand Functionality of Test cases and automate them.
- For mobile testing have to write script in java selenium using perfecto, according Test case functionality.
- Developed Test script in Java in IntelliJ with Lean FT for Desktop application testing.
- For Functionality have to refer HP-ALM manual test cases.
- Execute Test cases in both Eclipse and IntelliJ respective of mobile and Desktop testing.
- Writing Scripts for Automation.
- Working on Rest API.
- Documenting Test Plan, Test Scenarios and Test cases.
- Planning for integration testing between two services.
- Works on JMeter and Postman.
- Morgan Stanley helps people, Government raise and institute raise, manage and distribute the capital they need to achieve their goals.
Education
SSE - Class 10
Maharashtra State Board
HSE - Class 12
Maharashtra State Board
MBA - IT
Pune University
BE - CE
Pune University
Skills
- Windows 10
- JIRA
- HP ALM
- Oracle
- Selenium WebDriver
- Java
Professional Organizations - Total Experience
5 Years + Exp.(3.5 -4 years + in automation and other in manual) and Currently working at LTI Mindtree (07/2022 – present)
Skills Profile
Windows 10, JIRA, HP ALM, Oracle, Selenium WebDriver, Java, JIRA, HP ALM, Good Communication skills. Having over 5+ years’ experience in Software Testing, Quality Assurance with a Capgemini from as a Manual and Automation Tester. currently working in LTI Mindtree as specialist -quality engineering.
Accomplishments
- Star Performer of the month -July,August-2024
Certification
- ISTQB Foundation Level -2022
- GAQM Professional Selenium Tester -2024
Timeline
Specialist -quality engineering
Citi
01.2024 - Current
Specialist -quality engineering
Citi
07.2022 - 12.2023
Consultant
Morgan Stanley
07.2020 - 06.2022
SSE - Class 10
Maharashtra State Board
HSE - Class 12
Maharashtra State Board
MBA - IT
Pune University
BE - CE
Pune University
Similar Profiles
Daniela WongDaniela Wong
Executive Assistant to the Managing Director at CitiExecutive Assistant to the Managing Director at Citi
Antima RaiAntima Rai
Senior Business Analyst at CITISenior Business Analyst at CITI
Marquisha PrinceMarquisha Prince
Application Processor at CitiApplication Processor at Citi
Navneeth DilipNavneeth Dilip
KYC Analyst at CitiKYC Analyst at Citi
MOHIT SINGHMOHIT SINGH
Fiber Network Planner at Tech MahindraFiber Network Planner at Tech Mahindra