Mrunali Awari

Analyst

5years in Analytics

4years leading teams

5projects

3languages at B2 and above

Overview

Data Analyst focused on Power BI and business intelligence, with experience managing CRM data quality and building reporting for mortgage lending and recruitment analytics. Proficient in SQL for data extraction and validation, Power Query for transformations, and Power BI dashboards using DAX. Also uses Python/Pandas and advanced Excel for data wrangling and performance analysis.

Phone

Timeline

Data Analyst / Solo Data Lead · Lead

Pegasus Mortgage Lending · Full-Time

Nov 2023 to Jul 2026 2 Years 8 Months Fully remote

Managed CRM data quality and governance across mortgage-lending operations. Wrote SQL queries and maintained web-scraping workflows to extract, validate, and structure mortgage-agent records for multiple markets. Built and published operational Power BI reports in Power BI Desktop and Power BI Service, including scheduled refresh and access management. Analyzed campaign and pipeline performance using Excel and Python-based data wrangling.

SQL

ETL/ELT

Microsoft Excel

Pandas

Python

Power BI

Junior Power BI Developer · Junior

Radical Software · Full-Time

Jan 2021 to Jan 2023 2 Years Pune Partially remote

Transformed and cleansed raw corporate data using SQL and Power Query to feed structured reporting models. Developed Power BI Desktop dashboards and published reports to Power BI Service, handling user access and scheduled data refreshes. Performed exploratory analytics on business metrics using Python scripts and advanced Excel models.

SQL

ETL/ELT

Microsoft Excel

Pandas

Python

Power BI

Rashtrasant Tukadoji Maharaj Nagpur University

Bachelor's Degree

2014–2018 Nagpur, Maharashtra

Projects

Sales & Inventory Analysis

Combined inventory and transaction data using Power Query and Python to create analysis-ready datasets. Built Power BI dashboards that track store sales and inventory KPIs. Set up reporting outputs to monitor operational performance over time.

Customer Satisfaction & Pricing Analysis

Queried pricing and sentiment data using SQL and transformed datasets with Power Query. Developed Power BI dashboards using DAX calculations to present the analysis. Built reporting views focused on customer-related insights for decision-making.

CRM & Recruitment Database Data Quality

Improved data reliability by cleaning and deduplicating fragmented recruitment and client repositories. Used Power Query and Python workflows to standardize records and remove inconsistencies. Delivered a more consistent data source for downstream reporting and recruitment analytics.

WATI SMS Campaign & Recruitment Analytics

Segmented candidate records to prepare datasets for WATI messaging. Used SQL and Excel to organize recruitment-related attributes and track response and conversion outcomes. Focused on producing reliable, ready-to-use data for operational campaign analytics.

Mortgage Agent Contact Acquisition & Lead Pipeline

Built a validated mortgage-agent contact pipeline by extracting, cleaning, and structuring 25,000+ licensed agent records. Implemented Python workflows and Power Query preparation, with SQL checks to verify accuracy and consistency. Produced a usable dataset for outreach operations and ongoing lead management.

Technical skills

SQL

Python

Analytics

Power BI

ETL/ELT

Microsoft Excel

AI/ML

Pandas

Job preferences

Work permits: India
Citizenship: India
Employment type: Full-Time
Locations: Indi

Open to AI agents: they read this profile and start a dialog through Alionalion.io/@mrunali-awari/mcp