SHUBHAM BAROLIA

Uber Technologies - Team - Ad Ops

• Worked with Uber (Ad Ops and Uber Eats teams) for 5 months (June–October), writing and optimizing complex SQL queries in Presto for campaign and operational analytics.
• Managed ad-hoc tickets, modified existing queries, and generated accurate metrics for stakeholders.
• Calculated key metrics such as impressions, clickable impressions, clicks, CTR, spend, viewability, and other campaign and operational measures.
• Generated insights segmented by ad surfaces (Homefeed, Search, Cart, In-Transit/In-Ride) and ad types (banners, videos, billboards) for ads, and by restaurant performance, orders, and delivery metrics for Uber Eats.

• Conducted thorough data validation and reconciliation, resolving mismatches, and reducing discrepancies to less than 1% across multiple datasets.

• Collaborated with cross-functional teams to identify trends, improve reporting accuracy, and optimize campaign and operational performance.

• Collaborated with Hilton to create an analytics solution for guest behavior and operational performance.
• Managed large datasets from SQL Server, including bookings and revenue.
• Cleaned and transformed data with Python (Pandas) for accuracy.
• Designed Power BI dashboards to monitor KPIs like ADR, RevPAR, and Occupancy Rate.
• Implemented SCD Type 2 for historical tracking of room rates and loyalty levels.
• Automated data pipelines, reducing manual reporting time by 80%.

• Led analysis of accounts receivable data for Toshiba, a top provider of printers and related products.
• Extracted data from SQL Server databases and performed data cleaning and transformation using Python (Pandas).
• Created Power BI dashboards on Aging, Revenue, Profit, DSO, and Collections, reducing report processing time by 85%.
• Deployed SCD Type 2 for managing version control in multiple master files within the FCC Team.
• Developed payment aging calculations, improving credit control and optimizing cash flow management.

• Managed SLA trend analysis and KPI tracking for multiple accounts.
• Utilized SQL and Python for data fetching and analysis.
• Delivered insights via weekly/monthly reports to leadership.
• Created SQL and Excel dashboards for operational metrics and ad hoc client requests.
• Developed interactive Tableau dashboards for SLA compliance rates, breach trends, and root causes.
• Applied statistical techniques and EDA to identify trends and relationships.