Ruchi Rao

Business Intelligence Analyst @Blumetra Solutions

Houston, TX, US

Delivering end-to-end BI, data governance, and analytics solutions across government, finance, and pharmaceutical sectors. Procure-to-Pay Automation: Integrated AWS Clearlake data with Tableau dashboards, enhancing visibility by 35%. Led gap analysis and KPI development for PR, Budget, Spend, and Contracting metrics. Authored user stories, validated data via Redshift SQL, and led UAT with full sign-off. Marketing & Customer Analytics (Banking): Led workshops to define reporting use cases and performed data profiling. Created Tableau dashboards to visualize customer, campaign, and branch data. Supported Snowflake migration, improving data accuracy and usability. CIO Dashboards (Pharma): Defined reporting scope using Jira and Zoom data. Built Tableau dashboards for IT ticketing metrics, improving resolution tracking by 100%. Supported QA validation and story creation in Agile sprints. Snowflake Migration: Migrated 20+ Tableau dashboards from MS Access to Snowflake. Debugged SQL issues, fixed worksheet filters, and reconnected pipelines. Updated 30+ Python scripts to support improved ETL performance and unit testing. Data Governance (State Government): Consolidated metadata from MySQL into Informatica CDGC. Built workflows, business glossary, and lineage; applied PII classifications and quality rules. Trained 10+ stakeholders, improving adoption by 40%.

University of Illinois Urbana-Champaign

Master of Science - MS

Rajiv Gandhi Prodyogiki Vishwavidyalaya

Bachelor of Engineering - BE

Rajiv Gandhi Prodyogiki Vishwavidyalaya

Master of Technology - MTech