Summary
Overview
Work History
Education
Skills
Projects
Languages
Relevant Coursework
Certification
References
Timeline
Generic

Ragini Raut

Euless,TX

Summary

Insight-driven business analyst with a Master’s in Business Analytics and over 3 years of experience analyzing sales, behavioral, and survey data to drive strategic decisions. Proficient in Excel (VBA), SQL, R, Python, and Tableau for predictive modeling, KPI tracking, and dashboard development. Skilled at translating complex data into clear, actionable insights that enhance customer experience, and support cross-functional teams.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Business Analyst Intern

Code Gravity LLC
Irving, Texas
05.2024 - 12.2025
  • Used BI tools (Tableau, Excel, SQL) to analyze sales and customer data, driving a 15% boost in lead conversions, and a 10% rise in customer satisfaction.
  • Conducted a survey and behavioral analysis with R, SPSS, and Qualtrics, improving campaign ROI by 12% through targeted insights.
  • Defined reporting requirements and optimized dashboards, reducing reporting time by 30%.
  • Performed gap and root cause analysis, cutting data errors by 40%, and improving processing speed by 25%.
  • Built reusable models and QA protocols to standardize reporting, and scale insights delivery across teams.

Marketing And Business Strategy Officer

Dwarikas' Group of Hotels and Resorts
Kathmandu, Nepal
05.2022 - 08.2025
  • Expanded international reach by 35% and cut CPA by 8% by partnering with 35 travel influencers and optimizing content based on engagement analytics.
  • Built Tableau dashboards integrating sales, campaign, and web-behavior data; trimmed weekly reporting time from 6 hrs to 45 min, and surfaced top-performing promotions in real time.
  • Analyzed 1.2 M web sessions with Python/R , uncovering off-season booking patterns that drove a 10% revenue lift through targeted 'staycation' offers.
  • Aligned agency creative with data-driven KPIs, increasing click-through rate (CTR) by 22%, and raising ROAS from 3.1 to 4.0 across three paid-media channels.

Instructional Assistant

GBrint Ryan College Of Business, UNT
Denton, Texas
01.2024 - 05.2025
  • Supported over 150 students per semester in applying statistical and analytical techniques—regression, ANOVA, hypothesis testing—using Excel and SPSS for business analysis projects.
  • Facilitated 10+ hours of weekly lab sessions focused on translating theory into practice through case-based exercises, using tools like Excel, SPSS, and SQL.
  • Guided students in analyzing survey and behavioral data, helping them draw actionable insights aligned with real-world business challenges.
  • Collaborated with faculty to align course content with student needs, enhancing understanding of data interpretation and business impact.

Business Analyst

Dropshipping Nepal Pvt. Ltd
Kathmandu, Nepal
09.2022 - 07.2023
  • Analyzed sales and inventory data using Python and Excel (Solver), improving inventory turnover by 35%, and lowering holding costs through just-in-time distribution.
  • Built interactive dashboards in Excel and Tableau, showcasing top-selling and highest-rated products, enabling proactive inventory management, and reducing stockouts.
  • Designed and analyzed customer feedback surveys using SPSS and Excel, uncovering behavioral patterns that informed product strategy, and improved customer satisfaction.
  • Wrote and optimized SQL queries to extract and merge sales and behavioral data from multiple sources, generating insights for campaign and supply chain decisions.
  • Collaborated with vendors and cross-functional teams to improve data quality and align supply planning, enhancing delivery accuracy, and operational efficiency.

Education

Master of Science - Business Analytics

University of North Texas
Denton, TX
05-2025

BBA - Finance

Kathmandu University School of Management
Kathmandu, Nepal
12-2022

Skills

Technical skills

  • Tools: Excel (VBA, Solver, Power Pivot), Tableau, Power BI, and SQL
  • Languages: Python, R, SQL
  • Analytics: regression, A/B testing, hypothesis testing, segmentation, correlation analysis
  • Platforms: Salesforce, SPSS, Stata, SAS
  • Soft skills: strategic thinking, stakeholder communication, data storytelling

Core competencies

  • Sales and customer insights
  • Market research and survey design
  • Executive reporting and dashboards
  • SQL and data integration
  • Strategic decision support

Projects

Capstone: Dropout Rate Prediction in Texas Counties | Python, PCA, Random Forest, R, Tableau
Built predictive models using PCA and Random Forest to analyze dropout trends across demographics and policies; achieved 92.6% R² accuracy. Delivered insights on CTE vs. Title I policy impact, guiding future interventions.

Sales Forecasting for Retailers Using AI | Prophet, Python, Tableau
Developed a time-series forecasting model to predict retail sales based on seasonal and external factors. Enabled improved inventory and procurement planning, reducing stockouts and excess ordering.

Water Consumption Forecast – Denton County | Excel, Python, Regression Models
Forecasted future water demand using regression and visualization tools to support local utility resource planning and efficient allocation.

EV Registration Trend Analysis (Washington) | Tableau, Government Data
Analyzed and visualized electric vehicle adoption patterns using state registration data. Identified regional trends and growth segments to support environmental planning and policy insight.

Languages

English
Professional
Nepali
Native/ Bilingual
Hindi
Professional
Spanish
Limited

Relevant Coursework

  • Statistical Methods for Data Science
  • Data Visualization & Dashboarding
  • Survey Design and Analysis
  • Advanced Excel for Analytics
  • Machine Learning with R and Python

Certification

  • Google Analytics Certification
  • 2024 Advanced Machine Learning and Deep Learning Projects
  • AI Fundamentals (Demystifying AI and How can you use AI)
  • Google Cloud Platform Certification
  • Tableau Desktop Specialist

References

References available upon request.

Timeline

Business Analyst Intern

Code Gravity LLC
05.2024 - 12.2025

Instructional Assistant

GBrint Ryan College Of Business, UNT
01.2024 - 05.2025

Business Analyst

Dropshipping Nepal Pvt. Ltd
09.2022 - 07.2023

Marketing And Business Strategy Officer

Dwarikas' Group of Hotels and Resorts
05.2022 - 08.2025

Master of Science - Business Analytics

University of North Texas

BBA - Finance

Kathmandu University School of Management

Similar Profiles

CREATE PROFILE
Ragini Raut