Ankit Mankel

About Ankit Mankel

Quality Assurance professional with 6+ years of IT experience and proven expertise in Data Warehousing, ETL, and Database Testing. Proficient in Automation Testing using Python and Selenium. Over 4.5 years of experience in directly Interacting with client QA/Test Teams. In-depth experience in multiple DW ETL projects using tools like SSIS, Informatica, Autosys, Unix Systems, and databases like Oracle, MySQL, Teradata, MongoDB, and Snowflake, etc. Good knowledge of MS SQL Server, Management Tools such as RALLY,HP ALM,JIRA. Experienced in end-to-end project delivery, including code deployment to higher environments, utilizing CI/CD pipelines with Jenkins, UDeploy, and GitLab. Project experience with Financial, Insurance, Banking, and Telecom domains, covering areas such as Insurance Compliance, Property and Boat/Yacht Insurance, Employee Group Benefit PI Insurance, and Banking Revenue & Service Reports (turnover, profit/loss, budget variance, and operational regulatory reporting). Client handling experience across multiple projects with Tech Mahindra and Cognizant (US-based clients). Good experience in driving end-to-end Projects & QA/Testing processes across Agile (Scrum)+ Waterfall delivery methodology along with heading the Test Management Approach.• Handled numerous challenging responsibilities on Offshore team, provided QA Support, and served as a Backend Subject Matter Expert (SME). Experienced Scrum planning call with a keen ability to assess team efforts, estimations, and system complexities. Experienced in Agile methodology framework, leading Sprint Planning, Reviews, Retrospectives, and Daily Stand-ups to drive product delivery. Proven ability to collaborate in client-facing roles and cross-vendor teams.

Experience

1. Lead Assistant Manager- Qa De

   EXL

   Mar 2025 — Present · Pune, IN

   Senior Data Analyst | Insurance & BFSI DomainOver 6.5+ years of experience as Data analyst, ETL processes, and business intelligence within the Insurance and BFSI sectors. Proficient in stakeholder collaboration, requirement analysis, and delivering data-driven insights to support business decisions.Key Responsibilities and Achievements: Business Requirements Analysis:Reviewed and analyzed Business Requirements, Functional Specifications, and Detailed Design documents.Business Requirement Documents (BRDs) Creation as per organizational standards. Data Profiling and Mapping: Conducted data profiling to assess data quality and integrity.Created Source-to-Target Mapping (STTM) documents to facilitate accurate data migration and transformation.🧪 Test Planning and Execution:Developed comprehensive test plans, test cases, and test scenarios based on user stories and functional requirements.Executed test cases to validate that the system meets customer requirements and business logic. ETL and Data Warehousing:Worked with QA and DEV team for data extraction, transformation and loading processes.Managed DWH cloud solutions using platforms like Snowflake Automation and Scheduling:Involved in the creation and modification of Autosys job schedules based on project requirements.Utilized tools like WinSCP and Putty for secure file transfers and remote server. Reporting and Dashboards:Developed and maintained Business Objects (BO) and Business Intelligence (BI) dashboards to provide real-time insights into KPIs such as turnover, profit/loss, budget variance, and operational costs.🤝 Stakeholder Collaboration:Engaged with stakeholders to gather requirements, discuss project progress & provide updates during DSU meetings. Utilized Agile methodologies Quality Assurance and Defect Management:conduct regression testing after each new build to ensure system stability.Logged and tracked defects using tools like Rally and HP ALM

Education

• Institute of Management Studies (IMS), Devi Ahilya Vishwavidyalaya (DAVV)

  Master of Business Administration - MBA

  2014 — 2016

• University Institute of Technology, RGPV

  Bachelor of Engineering - BE, Electrical, Electronics and Communications Engineering

• Devi Ahilya Vishwavidyalaya (DAVV), Indore

  Master of Business Administration - MBA, Operations Management and Supervision

• University Institute of Technology, RGPV

  Bachelor of Engineering - BE

  2008 — 2013