Tommy Thai

Tommy Thai Email and Phone Number

Senior Data Analyst @ LA Care | ex-Intuit, Paramount @ LA Care Provider
Tommy Thai's Location
Los Angeles, California, United States, United States
Tommy Thai's Contact Details

Tommy Thai work email

Tommy Thai personal email

n/a
About Tommy Thai

I have worked as a business data analyst at Intuit, a business intelligence analyst at Paramount, and a business intelligence engineer at Worldwide Facilities, LLC, applying my skills in Tableau, Databricks, GCP, and SQL to various domains and industries.At Intuit, I built and maintained Tableau dashboards using external data sources from multiple partners to monitor the key performance indicators of different shows and platforms. I also handled the NFL stakeholder reporting and provided insights on the top performing devices and teams. At Paramount, I transitioned the Adobe Analytics reports for the streaming lines of business to Tableau dashboards through Google BigQuery for a holistic view of content consumption. At Worldwide Facilities, LLC, I restructured and built the database ETL pipeline from scratch to provide a SQL-based data architecture for improved business performance. I also created a VBA-automated Excel tool to reduce the data load time and developed numerous Tableau reporting processes for live data visualization to upper management. I am eager to learn new skills and technologies, and to bring my experience and expertise to new challenges and opportunities.Skills: AWS Athena, Databricks, Git, GCP BigQuery, Tableau, SQL, Adobe Analytics, Python, Excel, VBA, SAS

Tommy Thai's Current Company Details
LA Care Provider

La Care Provider

View
Senior Data Analyst @ LA Care | ex-Intuit, Paramount
Tommy Thai Work Experience Details
  • La Care Provider
    Senior Data Analyst
    La Care Provider Jan 2024 - Present
    ➤ Designed comprehensive dashboards to detect & recover $110M claim overpayments from providers, driving stakeholder insight into financial recovery efforts➤ Created claims tracking Tableau dashboard to identify leading providers driving highest volume➤ Streamlined review process for classifying claims overpayment, facilitating efficient claim return processes identifying $2M in monthly savings➤ Analyzed historical claims data to identify patterns in overpayment requests, driving strategic development of preventative measures against future inaccuracies
  • Intuit
    Senior Data Analyst
    Intuit Oct 2022 - Jun 2023
    Mountain View, California, Us
    ➤ Produced and maintained Tableau, DataBricks dashboards to track customer attribution metrics, improving user acquisition and retention by 12%➤ Collaborated with stakeholders providing insights improving marketing campaign performance by raising customer retention nearly 10% in TurboTax app customer touchpoints➤ Owned & streamlined AWS data pipelines processing 40+ GB of data through AWS Athena, Git & in-house ETL system ➤ Remediated data pipeline issues driving 15% TurboTax mobile app underperformance
  • Paramount
    Business Intelligence Analyst
    Paramount Aug 2021 - Sep 2022
    New York, Us
    ➤ Built Tableau dashboards utilizing external data sources from MVPD partners (Amazon Prime, Apple TV, DirecTV, YoutubeTV) to show the health of key KPIs on show level data across 10+ platforms like desktop, web, and mobile➤ Developed & launched Tableau dashboards from Adobe Analytics reports to GCP for Paramount+ & CBS TVE lines of business; established a unified reporting framework that improved data accessibility for over 10 key business teams➤ Automated NFL reports through Python ETL & provided key insights on top performing devices & teams➤ Extracted YoutubeTV partner API data through json normalized dataframe for automated reporting
  • Worldwide Facilities, Llc
    Data Analyst
    Worldwide Facilities, Llc Sep 2020 - Jul 2021
    Us
    ➤ Redesigned and optimized ETL pipeline from ground up to provide SQL-based data architecture which improved monthly data load by 90%➤ Created VBA-automated Excel tool to allow for more efficient database update process, reducing monthly data load time from 2 weeks to under 1 week➤ Developed numerous Tableau reporting processes for live data visualization to upper management
  • Blue Shield Of California
    Data Analyst, Experienced
    Blue Shield Of California Nov 2019 - Sep 2020
    Oakland, California, Us
    ➤ Owned SQL development efforts for Large Group Pricing Department reducing reporting processing time by 30%➤ Refined Excel quoting model for ASO/SA clients (1000+) using VBA/SQL based on requests from key business stakeholders➤ Re-engineered existing VBA and SQL stored procedures to improve quoting model efficiency and reduced manual work by 40%
  • Blue Shield Of California
    Actuarial Analyst
    Blue Shield Of California Oct 2016 - Nov 2019
    Oakland, California, Us
    ➤ Handled database pipeline through SAS SQL by consolidating millions of member level data (MMRs, Capitation, Eligibility, Claims) from multiple external sources➤ Led data migration & integration of company acquisition into Medicare database➤ Responsible for pricing and gross margin analysis of products for multiple lines of business in over 10 counties➤ Created quarterly experience report to view operating income with providers and identify financial opportunities for internal and external stakeholders➤ Utilized complex forecast data analytics in Excel to project gross margin using trends and projections➤ Created monthly gross margin variance reports to reconcile revenue and claims coming from database with financial reports for senior management➤ Updated monthly accrual reports for accounting department to account for liabilities incurred before government revenue received
  • Farmers Insurance
    Actuarial Intern, Commercial Auto Pricing
    Farmers Insurance Jun 2015 - Sep 2015
    Woodland Hills, Ca, Us
    ➤ Created Excel Tool for product managers to analyze rate impacto Integrated pricing calculations to automate pricing & revision process for key productso Allowed for a more efficient Excel-SQL transfer time (~20 minutes to 2 minutes) for large databases (~200,000 policies)➤ Created SQL stored procedure to allow for efficient nested querying from SQL Server to temp tables➤ Ensured 99% coverage pricing accuracy by reconciling calculated coverage premiums with actual policy premiums

Tommy Thai Skills

Corporate Fp&a Microsoft Office Data Analysis Data Modeling Financial Reporting R Microsoft Excel Vba Visual Basic For Applications Sas Mysql Property And Casualty Insurance Sql

Tommy Thai Education Details

  • Uc Santa Barbara
    Uc Santa Barbara
    Actuarial Science

Frequently Asked Questions about Tommy Thai

What company does Tommy Thai work for?

Tommy Thai works for La Care Provider

What is Tommy Thai's role at the current company?

Tommy Thai's current role is Senior Data Analyst @ LA Care | ex-Intuit, Paramount.

What is Tommy Thai's email address?

Tommy Thai's email address is to****@****unt.com

What schools did Tommy Thai attend?

Tommy Thai attended Uc Santa Barbara.

What skills is Tommy Thai known for?

Tommy Thai has skills like Corporate Fp&a, Microsoft Office, Data Analysis, Data Modeling, Financial Reporting, R, Microsoft Excel, Vba, Visual Basic For Applications, Sas, Mysql, Property And Casualty Insurance.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.