Mrunali Awari
Data Analyst
About
Analytical, detail-oriented, and results-driven Data Analyst with experience across end-to-end Data Analysis, Data Management, and visualization. Proficient in executing Data Sanitation and building interactive reporting suites across Power BI Desktop, Power Query, and Power BI Service. Expert at blending quantitative scripting in SQL and Python with Advanced Excel capabilities to model datasets, optimize recruitment and CRM architecture, and deliver operational insights across mortgage, real estate, and retail domains.
Skills & Expertise (24)
Work Experience
Data Analyst / Solo Data Lead
Pegasus Mortgage Lending
Nov 2023 - Jul 2026
Lead end-to-end Data Management and governance for company-wide CRM architectures; established automated Data Sanitation rules to resolve data fragmentation. Wrote custom SQL queries and automated scraping routines to extract, validate, and structure high-volume agent records across Canadian and Florida market databases. Designed, deployed, and published interactive operational reporting models via Power BI Desktop and Power BI Service (HRA, HRC, BD, and BSU suites). Utilized Advanced Excel (VLOOKUP, HLOOKUP, Pivot Tables) alongside Python data wrangling scripts to evaluate SMS campaign performance and pipeline conversion rates.
Junior Power BI Developer
Radical Software
Jan 2021 - Jan 2023
Leveraged Power Query for complex ETL pipelines, connecting raw corporate databases using SQL queries to transform, sanitize, and load data into structured models. Built end-to-end visual reports in Power BI Desktop and published them to Power BI Service, managing user access controls and automated data refresh cycles. Employed Python scripts and Advanced Excel models (Pivot Tables, complex formulas) to perform exploratory Data Analysis on cross-industry business metrics.
Education
Bachelor of Engineering (B.E.) in Electrical Engineering - RTMNU University
- · Afghanistan
Higher Secondary Certificate (12th Standard) – Computer Science - Maharashtra State Board
- · Afghanistan
Secondary School Certificate (10th Standard) - Maharashtra State Board
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Not Open to Relocation
Skills (24)
Click a skill to find developers with the same skill
