KIRAN KHARATMAL

• Designed test plans that increased software efficiency by 20% and ensured client satisfaction (98% approval rate)
• Verified and validated data within automated pipelines, achieving 99.9% accuracy
• Collaborated with teams to identify requirements, developing testing strategies that reduced defect escape rate by 15%
• Identified and recommended process improvements, aligning with industry best practices

Additional Activities:

• Comprehensively assessed testing & automation capabilities, proposing actionable changes
• Analyzed and identified critical gaps in Agile/Scrum QA processes, leading to improved efficiency
• Recommendations:
• Identified and addressed key process, tool, and infrastructure gaps
• Provided insights into industry best practices and bridged internal discrepancies
• Proposed and outlined specific changes for optimized QA operations.
• Adhered to standardized software quality assurance best practices, policies and processes.

• C2H Conversion from Metrix IT Solutions)
• Successfully performed activities like Report Validation, Data mining and Data analysis on Data warehousing
• Systems, Defining and Tracking Quality Assurance Metrics, creation, and validation of SQL Scripts for KPI
• Reports
• Performed Integration testing between various modules
• Created SQL queries to extract data from database and to check data flow through frontend and backend
• Executed SQL server agent jobs to load data into target system
• Done target database validation to perform
• ETL testing for quality, quantity, and format of data
• Debugging and Troubleshooting ETL data flow using Azure Databricks
• Executing different pipelines for data flow using Azure Data Factory BI System Testing
• Responsible for maintaining documentation of all testing activities and presenting in Daily, Weekly Meetings
• Involved in various team management activities and designed various test strategies
• Reduced UAT defects to 2% from 5% in Last one year by implementing role-based testing.
• Led cross-functional teams to ensure timely delivery of high-quality products.
• Mentored junior test engineers, enhancing their skillsets and overall team performance.

• Performed Integration testing between various modules
• Created SQL queries to extract data from database and to check data flow through frontend and backend thus reducing the UAT defects by 90%
• Executed SQL server agent jobs to load data into target system
• Done target database validation to perform ETL testing for quality, quantity, and format of data.
• Debugging and Troubleshooting ETL data flow using Azure Databricks
• Executing different pipelines for data flow using Azure Data Factory BI System Testing
• Successfully performed activities like Report Validation, Data mining and Data analysis on Data warehousing
• Systems, Defining and Tracking Quality Assurance Metrics, creation, and validation of SQL Scripts for KPI
• Responsible to maintain documentation of all testing activities and presenting in Daily, Weekly Meetings.

• Worked widely with Customer Relationship Management and Telecom Billing applications and worked on multiple testing projects spreading across domains like Telecom, Healthcare and AgroTech including payments and Billing processes
• Understand and analyzed customer requirements related to various platforms like CRM, E-commerce web and Mobile applications used by Telecom, Agrotech and Healthcare industries
• Effective co-ordination between development team and testing team
• Performed integration testing between various modules
• Developed test scenarios and test procedures based on test requirements for web and mobile applications
• Participated in web and mobile application walkthrough and business review meetings
• Followed up with developers regarding status of raised errors and ensured complete resolution of issues
• Created SQL queries to extract data from database and to check data flow through frontend and backend
• Execute test cases, registered defects, and test summary reports in Tools like Trello, Jira-Xray, HPALM, etc
• Executed SQL server agent jobs to load data into target system
• Validated data transformations like aggregated, joins, data conversions etc
• Validated source and target table mapping in SSIS designer
• Executed SSIS packages at initial phase of development
• Developed test data scripts, based on ETL mapping artifacts
• Done target database validation, perform ETL testing for quality, quantity, and format of data
• BI System Testing
• Validated data that has been migrated from source system to target system is uniform in terms of quality, quantity, and form
• Created SQL scripts for Tableau reports
• Validated LSAC reports data against data in data warehouse
• Validated data transformations like aggregated, joins, data conversions etc
• Create strategies and test cases for applications that use ETL components
• Validated data in cube, checked dimensions data against facts
• Improved software quality by designing and executing comprehensive test plans.
• Streamlined testing processes for increased efficiency in identifying and resolving defects.