Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Declaration
Work Availability
Personal Details
Generic
Hemangi Sawant

Hemangi Sawant

Data Analyst
Mumbai

Summary

Data Analyst with 10 years of experience in reporting and operational data management for mortgage and financial services. Developed Power BI dashboards and conducted advanced Excel analytics to deliver AI-driven insights that convert complex datasets into actionable intelligence. Improved reporting efficiency and supported strategic decision-making through data storytelling and automation, while identifying inefficiencies and recommending solutions to optimize processes.

Overview

3
3
Languages
2
2
Certifications
15
15
years of professional experience

Work History

Business Analyst for Control Report Team

Onity Group- PHH Mortgage
06.2018 - Current
  • Prepare and publish daily analytical reports supporting Risk Management decisions.
  • Analyze operational data and provide actionable insights to management.
  • Monitor files from Compliance and Audit perspectives ensuring accuracy.
  • Collaborate with Team Leads to improve productivity and reporting efficiency.
  • Identify process improvement opportunities and implement reporting checkpoints.
  • Develop and maintain Excel-based automated reports and dashboards.
  • Enhance reporting quality using analytical and automation techniques.

Quality Specialist – Collateral Based Solutions (Deed in Lieu)

Onity Group- PHH Mortgage
01.2015 - 05.2018
  • Performed final quality audits for processed loan files.
  • Ensured compliance and accuracy before resolution closure.
  • Supported optimal loan resolution outcomes.

Business Unit Analyst – Payoff Department

Onity Group- PHH Mortgage
03.2011 - 12.2014
  • Processed customer payoff quote requests to facilitate timely loan settlements.
  • Calculated loan prepayment penalties to ensure compliance with company policies.
  • Collaborated with attorneys to manage legal documentation.
  • Conducted training sessions for new employees.

Education

Bachelor of Commerce (B.Com) -

Mumbai University
01-2010

Skills

Data analysis

Data Visualization & Storytelling

Power BI expertise

Advanced Excel skills

Excel expertise

Data Modeling Techniques

SQL (Basic), Data Extraction & Transformation

Data cleaning automation

Data Quality Management

Statistical Analysis

Operational reporting

KPI tracking

Business process improvement

Regulatory Compliance

Stakeholder analysis

Accomplishments

  • Data Organization - Classified, recorded and summarized numerical and financial data to compile and keep financial records.

Certification

Microsoft Excel – Basic to Advanced Certification

Timeline

Business Analyst for Control Report Team

Onity Group- PHH Mortgage
06.2018 - Current

Quality Specialist – Collateral Based Solutions (Deed in Lieu)

Onity Group- PHH Mortgage
01.2015 - 05.2018

Business Unit Analyst – Payoff Department

Onity Group- PHH Mortgage
03.2011 - 12.2014

Bachelor of Commerce (B.Com) -

Mumbai University

Declaration

I hereby declare that the information provided above is true and correct to the best of my knowledge. Hemangi Sawant

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Personal Details

  • Date of Birth: 31st July 1989
  • Gender: Female
  • Permanent Address: A-102, Akruti Bldg., New link Road Borivali-(W), Mumbai 400091.
Hemangi SawantData Analyst