Looking for a job

Ruchita Shah

@ruchitashah

SQL and Tableau Developer at MedStar Health, building dashboards and SQL analyses for healthcare revenue cycle operations.

United States

Message

At MedStar Health, I support healthcare applications including NextGen and InstaMed, investigate payment posting and insurance discrepancies, and develop SQL queries and Tableau dashboards to generate insights for revenue cycle operations.

At S&P Global, I developed Tableau dashboards and financial reports for Board of Directors, Marketing, and Finance stakeholders. I also automated data pipelines with PySpark and Apache Airflow; AWS Glue and Redshift helped streamline pipelines and reduce report generation time by 20%.

At NIH, I developed Tableau dashboards and SQL scripts, and used PySpark to work with large datasets. I also automated UAT regression testing with Selenium and TestNG, and contributed to a web reporting enhancement that reduced financial tracking analysis delay by 30%.

Earlier, at T. Rowe Price and Uber, I developed SQL solutions, Tableau dashboards, and reporting workflows. My work has included revenue, budget, and forecast KPIs, data warehouse ETL with SSIS, and database development with Oracle PL/SQL.

Experience

Work history, roles, and key accomplishments

Current

Application Analyst 1

Current

MedStar Health

Jan 2025 - Present (1 year 9 months)

Supports healthcare applications including NextGen, InstaMed, Asana, and Cisco Webex Analyzer. Analyzes business requirements, resolves payment issues, and facilitates Agile ceremonies.

SQL Tableau RStudio Asana Agile Scrum UAT Root Cause Analysis Process documentation

SQL and Tableau Developer

S&P Global

Mar 2022 - Dec 2024 (2 years 9 months)

Developed and maintained Tableau dashboards for financial metrics, automated data pipelines with PySpark and Airflow, and optimized performance. Collaborated with stakeholders to translate business needs into visual solutions.

SQL Tableau PySpark Airflow AWS Redshift AWS Glue Pl SQL Business Objects Data Visualization Performance Optimization UAT

SQL and Tableau Developer

NIH

Dec 2020 - Feb 2022 (1 year 2 months)

Developed Tableau dashboards and SQL scripts for data analysis, automated regression testing with Selenium and TestNG, and implemented advanced visualizations. Reduced financial tracking analysis delay by 30%.

SQL Tableau PySpark Selenium TestNG Oracle Power BI Data Visualization A B Testing Regression Testing

SQL Developer / Tableau Developer

T. Rowe Price

Sep 2019 - Nov 2020 (1 year 2 months)

Developed SQL queries and Tableau dashboards for KPIs, implemented Row-Level Security in Power BI, and conducted UAT. Optimized data retrieval efficiency in the loan and mortgage domain.

SQL Tableau Power BI Power Query Jira Postman Rest Assured A B Testing Data Blending RLS

Graduate Research Assistant

Rochester Institute of Technology

Sep 2018 - Aug 2019 (11 months)

Managed SQL Server tasks and prepared scripts for data access and reporting. Analyzed patient appointment data and applied statistical models including logistic regression and topic modeling.

SQL MySQL R Excel Logistic Regression Topic modeling LDA TF IDF Naïve Bayes Data Analysis

SQL Developer

Uber

Apr 2014 - Mar 2016 (1 year 11 months)

Developed Oracle PL/SQL packages and procedures, SSRS reports, and ETL processes in SSIS. Performed SQL performance tuning and automated database maintenance.