D

Dimpal Agrawal

About Dimpal

Skills

  • Advanced Excel
  • Analytics
  • Banking
  • Business Analysis
  • Business Case Preparation
  • Commercial Loan
  • Data Analytics
  • Data flow
  • House loan
  • Jira
  • Microsoft Office 365
  • Mortgages
  • Postman
  • Power BI
  • Python
  • Requirement Gathering
  • Requirement management
  • Retail Loan
  • Software Testing
  • SQL
  • Team management
  • Test Planning
  • Training
  • Visio

Work Experience

2/2023-09/2024
Senior Consultant
Teamwill Consulting Group

Developed a comprehensive test plan using Scrum, outlining clear timelines, resource allocation, and key deliverables to enhance operational efficiency.

Provided high-quality project support and strategic development of the report module at BNP Paribas – Corporate Investment Banking (CIB).

Ensured seamless collaboration with clients, aligning project developments with business goals

Conducted in-depth data analysis and data modeling for asset reports, ensuring accuracy and efficiency.

Utilized Power Query and DAX to create dynamic asset report templates for enhanced reporting.

Managed issue tracking and resolution to optimize system functionality and report accuracy.

Skills - Scrum & Planning, Analytics & Data Analysis, Power BI & Excel, SQL & Issue Management, Consulting & Training, Client Communication, Flow chart

10/2021-02/2023
Lead Business Analyst(Manager)
Avanse Financial Services

Led requirement analysis with a keen eye for detail, ensuring documentation is complete, concise, and unambiguous to facilitate accurate product development.

Possess a strong understanding of loan module workflows in Pennant Lending Factory (PLF) for the Education Loans portfolio

Managed the requirement traceability matrix, tracked requirement status throughout the project, and ensured adherence to deadlines, schedules, and methodologies.

Conducted in-depth data analysis from multiple perspectives, providing insights that directly impact business decisions

Ensured system functionalities meet business requirements by overseeing testing strategies and validating project outcomes.

Leveraged Power BI to create data-driven reports for enhanced decision-making.

Applied Scrum methodologies to streamline project execution, improving collaboration and efficiency

Guided cross-functional teams, ensuring effective communication and alignment with business goals.

Skills: - Business Analysis, Loan Module Expertise, Requirement Traceability & Project Tracking, Data Analytics & Decision Making, Software Testing & Quality Assurance, Scrum & Agile Project Management, Power BI & Visualization, workflow designing, change request management, SQL

 

10/2018-10/2021
Senior Consultant
Yethi Consulting Pvt

Team Lead- Federal Financial Services Ltd., India

Lead the lending project management/implementation, end-user queries, Production issues, and internal audit. Focused to goal achievement, functional training – waiver

Team Management and Handled the requirements for multiple Retail lending projects, Handled the PAN India UAT team

Led the end-to-end implementation of front office (customer onboarding application), middle office, operation, including stakeholder requirement gathering, documentation, master data sharing, field validation, and workflow process verification, while managing client and stakeholder relationships

Skills: - Excel, Software testing, Visio, Business Analytics, SQL, Coaching, Issue management, JIRA, API, Requirement gathering, small business financing, Loan against Property, front- office, collateral, middle office, operation team, KYC, credit rating, Scrum

 

Associate Team Lead - RBL Bank, India,

Documented all the requirements of housing Loan and guided the peer for events waiver, restructuring, created the UAT scenarios for loan management system/middle office and created a requirement traceability matrix to ensure comprehensive test coverage and completion

Managed a team of manual testers and provided support to the business analyst

Validate the issues

Skills: - Business Analysis, UAT, Testing, Analytics, Peer review and coaching, housing finance/Home loan, JIRA, Waiver, loan restructuring, Loan rescheduling, Middle-office

 

Senior BA/QA - Volkswagen Financial Services, India

Documented all the requirements of payment module for auto finance system and created the UAT scenarios. Worked on Volkswagen auto loan project, created UAT scenario & test cases for Cassioape Loan Management system middle office and collection.

Performed all middle office events – payments, waiver, rescheduling, restructuring, Issue reporting

Skills: - Business Analytics, Data Analytics, UAT, Stakeholder management, JIRA, Automotive financing/Auto Loans, issue management, HP-ALM, Loan restructuring, collection activities

02/2016-10/2018
Quality Engineer
Crestech software Systems Pvt Ltd

Business Analyst/ Quality Engineer - Hero Housing Finance Ltd

Worked as Business Analyst- Quality Analyst for Mortgage for the client Hero Housing Finance Ltd, responsible for data creation

Responsible for document creation and execution of the User acceptance testing scenarios and maintaining the daily work

Responsible for bug reporting and bug tracking

Skills: - Business Analytics, Data Analytics, UAT, API, Housing financing/Mortgages, issue, front office, middle office, collection, JIRA, SQL

 

Quality Engineer - Canara Bank, India

Test case creation and execution for a banking payment application, analyzing issue logs in JIRA, and performing retesting

Skills: - Business Analytics, Testing, JIRA, Payment knowledge

 

Quality Engineer - Compro technologies Excel Simulation, India

Test case creation and test case execution for Learning Management System

Developed the checklist for all the methods of excel simulation

Performed peer reviews, reported bugs, and conducted bug retesting

Skills: - Testing, JIRA, Learning management system

09/2013-08/2015
Executive
EXL Services

Worked as an Executive at EXL Services for HIG (Hartford Insurance Group, USA),

Handling healthcare claim setup and performing validation testing for claims

Skills: - Stata ware, Excel, Analysis, Issue reporting

Education & Training

07/2022-12/2024
Master of Science
Birla Institute of Technology and Science
I have completed my master's degree in Business Analytics
08/2008-06/2011
Bachelor of Technology
Uttar Pradesh Technical University
I completed my B.tech in Computer Science and Engineering
08/2005-06/2008
Diploma
Uttar Pradesh Technical Board of Education
I did three year Engineering diploma in Electronics and Communication Engineering
Location
Vancouver
Phone
+33745600761 +3374560**** Show