Rituraj Pawar

Experience

1. Business Data Analyst

   United Gaming, LLC.

   Jun 2023 — Present · US

   United Gaming LLC holds over 25% market share in Georgia’s COAM (Coin Operated Amusement Machine) industry, managing 1300+ locations and over machines. I play a key role in ensuring data integrity, operational efficiency, and data-driven business decisions through advanced data management and analysis.Key Responsibilities & Achievements:• NetSuite Operationso Create new customer records and update customer statuses in Oracle NetSuite for better lifecycle tracking.o Execute and manage scripts for bulk data uploads and modifications within NetSuite.• Database Management & Optimizationo Led the development and implementation of a comprehensive relational database, improving data accuracy and accessibility by 35%.o Built automated pipelines using SQL triggers, events, and constraints to ensure data quality and reduce manual intervention.o Regularly insert, update, and maintain large datasets related to customer locations, machine swaps, and performance.• Data Analysis & Reportingo Designed SQL queries to detect underperforming machines, recommend replacements, and analyze pre- and post-swap performance improvements.o Insert and track machine swap data in the SQL database to aid long-term performance evaluations.o Created custom database views and optimized data access across departments, improving productivity by 10%.o Automated dashboards and reporting via Tableau, reducing manual reporting time by 25% and increasing insight accessibility.• Business Intelligence & Strategic Impacto Conduct statistical analysis on customer behavior, supply chain data, and machine usage, enabling 20% improvement in marketing and operational decision-making.o Proactively contributed insights that helped optimize machine placements and route-level revenue growth.

Education

• Jabalpur Engineering College

  Bachelor's degree

  2017 — 2020