Skip to main content
Reason Raut

Reason Raut

Data Analytics | Power BI Reporting | Supply Chain Analytics

Talent
IllinoisMember since October 26, 2026
Advanced ExcelProcess ImprovementPower QueryDAXPower AutomatePower BISQLPythonSharePointPower Automate Desktop (RPA)
·

Hire this person

Send a job offer directly to this candidate

Advanced ExcelProcess ImprovementPower QueryDAXPower Automate

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)

Skills

Data AnalyticsPower BI ReportingSupply Chain Analytics

Reviews

Related