Arpit Amin

Highly analytical and results-driven Business Data Analyst with 5 years of experience leading Business Intelligence (BI) and analytics initiatives across Banking, Technology, and Retail. Expert in gathering requirements, building SQL-driven data pipelines, designing interactive dashboards in Power BI and Tableau to deliver insights that improve operational outcomes. Proven track record of optimizing data workflows to achieve a 60% reduction in manual effort and ensuring high-integrity datasets for enterprise reporting.

Skilled in writing complex SQL queries, stored procedures, and performing Exploratory Data Analysis (EDA) to support strategic decision-making and risk mitigation.

Business Data Analyst at Citadel Mortgages (2024-08 – Present)

Led BI solutions for tracking and forecasting loan portfolio performance. Designed an advanced dashboard suite and risk score system that improved loan exposure visibility by 30% and supported enhanced compliance reporting.

• Automated recurring analytics via Power BI Service, reducing manual reporting effort by 60%.
• Delivered data-driven insights that directly informed credit policy and risk mitigation strategies.
• Built predictive score models to assess default probability based on borrower history.
• Performed Python-based EDA to validate data quality and identify early delinquency indicators.
• Engineered ETL pipelines using SQL to integrate multi-source data into a Medallion Architecture.
• Analyzed large-scale loan portfolio for performance, delinquency trends, and credit risk exposure.
• Designed Power BI dashboards to visualize loan disbursements, default rates, and regional exposure.
• Created portfolio risk heatmaps and executive dashboards for quarterly board and compliance reviews.
• Developed Tableau dashboards to perform exploratory analysis and validate Power BI insights for loan performance monitoring.
• Collaborated with credit and compliance teams to gather requirements, document BRD and FRD, define KPIs, and translate needs into BI specifications.

Business Data Analyst at MBC Managed IT Services (2023-03 – 2024-06)

Supported a company-wide data governance framework by delivering BI tools that standardized data definitions, enhanced quality visibility, and improved issue resolution time by 40%.

• Delivered BI solutions to support enterprise-level data governance and quality initiatives.
• Improved data issue resolution time by 40% through Power BI and Jira integrated reporting.
• Used Advanced SQL to detect anomalies, duplicates, and inconsistencies across CRM and ERP.
• Conducted Python-based data profiling to assess completeness, consistency, timeliness, and validity.
• Designed Power BI dashboards to track data quality KPIs and governance compliance metrics.
• Automated dashboards connected to Jira for tracking data quality issue backlogs and resolution timelines.
• Developed DAX-driven trend analysis to monitor recurring data quality issues and resolution progress.
• Published refreshable dashboards via Power BI Service for governance council and leadership reviews.

Business Data Analyst at Rexall (2021-02 – 2022-12)

Led the development of a churn prediction dashboard and retention framework that reduced churn by 18% in one year while improving customer segmentation strategies and loyalty program success.

• Reduced customer churn by 18% through Power BI analytics and SQL-based customer segmentation.
• Built churn risk models based on purchase frequency, inactivity duration, and return behavior.
• Conducted exploratory analysis in Python to validate segmentation and churn indicators.
• Architected semantic data models and DAX-driven dashboards to track customer behavior and churn across demographics.
• Implemented DAX logic to flag high-risk customers and trigger alerts for business teams.
• Integrated CRM feedback scores with churn indicators to create a 360-degree customer view.
• Automated weekly churn dashboards with drill-down and filtering capabilities.

Graduate Certificate in Project Management – Durham College

Fast Track in Mechanical Engineering Technician – Design – Centennial College

Bachelor of Engineering in Mechanical – North Maharashtra University