Ajit Mankar

Quality Analyst

Barclays•  June 2017 - August 2025•  Pune, IN

Domain: Corporate Banking. Delivered strategic solutions to corporate clients for Billing and Pricing analysis via a web-based application enabling efficient pricing templates. Participated in project stakeholder meetings from user story refinement to demos, identified requirements and functional gaps. Managed E2E testing strategies including resource planning, effort analysis, test analysis, planning, and test case writing. Coordinated with multiple teams for E2E test implementation. Provided daily status reports on test execution, defects, defect management, and test completion using Jira and Confluence with X-Ray plugins. Worked with production teams for test sign-off and LCT purposes. Experienced in data analysis using Oracle database, improving customer banking experience. Developed and executed SQL queries to analyze customer pricing impact. Organized large data sets using advanced querying, visualization, and analytics tools. Experienced in ETL development and testing of migration from Informatica to Abinitio. Contributed to strategy formulation across business units and product lines. Evaluated and formulated queries to archive data into data warehouses including Hadoop using Hive and Oracle queries. Automated functional testing for web applications using Selenium WebDriver, reducing testing cycles by 30%. Identified and rectified 80% of critical path defects through regression testing and targeted test suites. Collaborated with developers on TDD practices, improving code quality and reducing bug rates by 10%. Created dashboards for stakeholders to analyze customer pricing and revenue. Managed archival of customer personal and revenue data into Barclays Internal Warehouse. Resolved issues related to dashboards and reporting database environment, overseeing quality assurance of imported data.