Reason Raut
Data Analytics | Power BI Reporting | Supply Chain Analytics
Hire this person
Send a job offer directly to this candidate
About
Data Analyst with 5+ years of analytical experience across supply chain, customer service, and financial services, including hands-on work with large operational datasets, reporting, data validation, automation, and root-cause analysis. Use SQL, Python, Power BI, Power Query, and advanced Excel to extract, transform, reconcile, and analyze data; identify trends and anomalies; build dashboards and repeatable analytical workflows; and translate business requirements into clear metrics, rules, and actionable insights. Experienced partnering with cross-functional stakeholders, investigating data discrepancies, documenting analytical logic, and communicating recommendations that support operational and financial decisions.
Experience
Supply Chain Analyst at Dometic Inc. (2026-01 – Present)
- Analyze large-scale demand, inventory, purchasing, supplier, customer-service, and item-master data across a 15,000+ SKU portfolio, integrating multiple operational sources into repeatable analytical views for planning and management decisions.
- Use SQL, Python, Power Query, Power BI, and advanced Excel to extract, clean, transform, validate, reconcile, and analyze data; apply business rules and exception logic to improve data quality, consistency, and analytical reliability.
- Build and maintain Power BI dashboards and Excel reporting that track KPIs, trends, anomalies, and operational exceptions, enabling users to move from portfolio-level performance to SKU-level root causes.
- Investigate data discrepancies and persistent performance anomalies across demand, inventory, purchase orders, customer activity, and supplier records; isolate root causes and recommend corrective actions.
- Develop reusable Python analytical workflows for trend analysis, exception detection, scenario testing, forecasting, and data validation, reducing manual review of large datasets and improving repeatability.
- Partner with Sales, Customer Service, Operations, buyers, and other stakeholders to clarify analytical needs, define useful metrics and business rules, and translate business questions into reporting and decision-support outputs.
- Quantify operational and financial impact by connecting changes in demand, inventory, open purchase orders, supplier lead times, and service risk; help stakeholders prioritize actions based on materiality and business impact.
- Build automated reporting and refresh workflows using Power BI, Excel, Python, Power Automate, and SharePoint to improve turnaround time, process visibility, and consistency of recurring analysis.
- Create exception-based analytical views that combine demand, on-hand inventory, inbound supply, and lead-time data to identify supply constraints, excess exposure, and items requiring targeted follow-up.
- Improved analytical visibility and planning discipline, contributing to an approximately 5% increase in customer service level versus 2025 while maintaining focus on inventory right-sizing and operational efficiency.
- Built Python-based processes to clean, standardize, validate, aggregate, and segment demand and item-master data, applying active-item, product-line, date, and business-rule controls to improve data quality and repeatability.
- Developed inventory and open-PO analyses that combine historical demand, on-hand stock, supplier lead times, incoming supply, turns, and coverage to identify shortages, excess exposure, and actionable exceptions.
- Established a Python-driven SLOB analytics process to identify slow-moving, obsolete, and excess inventory, quantify exposure, rank exceptions, and support corrective actions with management and buyers.
- Developed statistical analyses using demand variability, service-level targets, forecast error, item segmentation, and lead-time inputs to evaluate risk and support data-driven inventory decisions.
Customer Service Business Analyst at Dometic Inc. (2025-01 – 2025-12)
- Analyzed customer demand, fill-rate performance, service failures, inventory gaps, and deduction data to identify trends, anomalies, and root causes; translated findings into operational corrective actions.
- Performed detailed validation and reconciliation of customer and operational data, investigating discrepancies across service performance, demand, inventory, and supporting records to determine root causes.
- Partnered with Customer Service, Sales, Operations, and Supply Chain stakeholders to clarify reporting needs, validate findings, review recurring issues, and convert analysis into corrective actions and process improvements.
- Analyzed and disputed customer fines and deductions, supporting more than $110K in reversals/waivers through data validation, case-level analysis, evidence review, and clear communication of findings.
- Built a centralized fine-tracking and analytical workflow using Power Automate, Excel, and SharePoint, reducing report-preparation time by more than 70% and improving visibility into recurring causes and trends.
Retail Fine Analyst Intern at Dometic Inc. (2024-06 – 2024-12)
- Analyzed customer compliance and service deduction data, reversing or waiving approximately $49K in penalties and using root-cause analysis to help reduce new deductions by 52%.
- Investigated recurring EDI and operational data issues with cross-functional teams, identifying root causes and helping reduce EDI-related fines by 64% for a key customer.
Relationship Manager / Business Development at Sanima Bank Limited (2018-02 – 2022-12)
- Analyzed customer financial, credit, and transactional data to identify trends, anomalies, risk indicators, and performance drivers, translating findings into portfolio and business decisions.
- Led a four-person team within the credit function, coordinating workload, reviewing analyses, and supporting timely customer and portfolio decisions.
- Developed analytical reports and management insights supporting customer segmentation, business development, product decisions, process improvement, and risk mitigation.
Education
M.S. in Management Information Systems - Business Analytics – Southern Illinois University Edwardsville (2024-12)
Master of Business Administration in Finance – Pokhara University (2020-01)