Data Analyst / Tableau Developer - Cincinnati Children's Hospital Medical Center - Cincinnati, OH
(2024-06)
Cincinnati Children's Hospital Medical Center launched an enterprise analytics modernization initiative to centralize clinical, operational, and research reporting into a unified Tableau and Power BI analytics platform. The program involved migrating legacy Excel and SSRS-based reports to interactive dashboards backed by Snowflake and Azure SQL data sources, improving visibility into patient outcomes, bed utilization, surgical volumes, emergency department throughput, and quality measure performance across the hospital's clinical and administrative divisions. As a Data Analyst and Tableau Developer on the Enterprise Analytics team, responsible for designing and deploying interactive clinical and operational dashboards, building optimized data models in Snowflake and Azure SQL, developing ETL pipelines for data ingestion from EHR and administrative systems, and partnering with clinical leadership, quality improvement teams, and research faculty to translate analytical requirements into production-ready visualizations.
- Designed and developed interactive Tableau dashboards for clinical operations monitoring, tracking patient admission volumes, average length of stay, bed occupancy rates, readmission trends, and emergency department wait times, providing clinical leadership with real-time visibility into hospital performance across inpatient and outpatient service lines.
- Built and optimized dimensional data models (star and snowflake schemas) in Snowflake and Azure SQL Database, structuring fact and dimension tables for clinical encounters, procedure volumes, diagnosis groupings, and patient demographics to support high-performance analytical queries for quality reporting and research workloads.
- Developed ETL pipelines using Azure Data Factory (ADF) for automated data ingestion and transformation from Epic EHR, billing systems, and departmental data sources, scheduling incremental data refreshes to maintain dashboard currency while ensuring PHI handling compliance with HIPAA security requirements.
- Authored complex SQL queries using CTEs, window functions, and stored procedures for data extraction and transformation across Snowflake and Azure SQL, supporting readmission rate calculations, surgical volume trending, patient acuity analysis, and quality measure denominator and numerator logic for CMS and Joint Commission reporting.
- Created Power BI Paginated Reports using Report Builder for regulatory and compliance reporting, incorporating parameterized drill-through for quality measure detail, scheduled delivery to department chiefs and quality officers, and detailed patient cohort breakdowns required for CMS quality program submissions and accreditation reviews.
- Developed Tableau LOD expressions, table calculations, and parameter-driven filters to enable dynamic analysis of clinical performance indicators, allowing quality improvement teams to slice outcome data by service line, attending physician, diagnosis group, payer type, and patient age cohort.
- Integrated Python (Pandas, NumPy, Matplotlib) scripts for advanced data preparation, statistical analysis of clinical outcome trends, and cohort-based variance analysis, supplementing Tableau and Power BI visualizations with statistical validation for research faculty presentations and quality committee reviews.
- Implemented Row-Level Security (RLS) across Tableau Server and Power BI Service to enforce data access controls by department, service line, and clinical role, ensuring that protected health information was visible only to authorized clinical and administrative users in compliance with HIPAA privacy and security requirements.
- Partnered with clinical stakeholders across pediatric specialties, quality improvement, and hospital operations to define KPIs, reporting hierarchies, and visualization standards, conducting requirements workshops and iterating on dashboard prototypes through clinician feedback cycles before production deployment.
- Automated dataset refreshes and report distribution workflows using Power Automate and Tableau Server schedules, eliminating manual report generation and ensuring clinical leadership and department heads received updated dashboards at the start of each business day.
- Conducted data validation, reconciliation, and user acceptance testing to ensure consistency between dashboard outputs, Epic EHR source records, and finance team general ledger totals, resolving data discrepancies before each quarterly reporting cycle.
- Created and maintained data dictionaries, transformation logic documentation, and dashboard user guides to support ongoing governance, audit readiness, and onboarding of new analysts into the enterprise analytics platform.
Data Analyst / BI Developer - Dell Technologies - Hyderabad, India
(2020-03 - 2022-12)
Dell Technologies undertook a global data visualization and analytics enhancement program to unify financial, sales, and operational reporting across regional business units. The objective was to modernize the existing BI infrastructure by integrating Power BI and Tableau with Azure SQL and Python-based data automation, providing leadership with real-time insights into revenue performance, product line profitability, and supply chain efficiency across Dell's global commercial and consumer business segments. As a Data Analyst and BI Developer on the Global Analytics team, responsible for designing and implementing analytical dashboards in Tableau and Power BI, building optimized data models in Azure SQL Database, developing ETL workflows using Azure Data Factory and SSIS, and collaborating with finance, operations, and product leadership teams across US and APAC regions to deliver actionable business intelligence.
- Designed and delivered interactive Tableau and Power BI dashboards for revenue tracking, product line profitability analysis, and global sales performance monitoring, enabling regional business leaders to visualize KPIs around quota attainment, deal pipeline health, and margin trends across commercial and consumer segments.
- Built and maintained data models (star and snowflake schemas) in Azure SQL Database, structuring sales transaction, inventory, and supply chain data into fact and dimension tables optimized for high-performance analytical queries across Tableau and Power BI reporting workloads.
- Developed ETL pipelines using Azure Data Factory (ADF) and SSIS for automated data ingestion and transformation from CRM, ERP, and regional sales systems, scheduling nightly and weekly data refresh cycles to maintain reporting currency across global time zones.
- Authored complex T-SQL queries, stored procedures, and views for data extraction, aggregation, and transformation, supporting sales pipeline analysis, inventory turnover calculations, product lifecycle reporting, and supply chain lead time trending across multiple geographies.
- Created Power BI Paginated Reports using Report Builder for operational and compliance reporting, developing DAX measures for revenue variance calculations, cost-of-goods-sold trending, and quarter-over-quarter growth analysis with advanced parameterization and drill-through features.
- Utilized Tableau Prep for data cleansing, transformation, and source standardization across multi-regional datasets, resolving data quality issues in product master records, currency conversion fields, and regional sales territory mappings before data entered the reporting warehouse.
- Developed Tableau LOD expressions and table calculations for multi-layered sales analytics, enabling drill-down from aggregate revenue figures to individual transaction detail with filtering by product family, sales region, account segment, and sales representative.
- Integrated Python (Pandas, NumPy, Matplotlib) for advanced statistical modeling, trend forecasting for quarterly revenue projections, and variance analysis between forecast and actual performance, providing finance leadership with data-backed inputs for planning cycles.
- Implemented Row-Level Security (RLS) and user-based data filters across Power BI Service and Tableau Server to enforce data access controls by region, business unit, and management level, ensuring sensitive revenue and margin data was accessible only to authorized stakeholders.
- Published dashboards to Power BI Service and Tableau Server, managing refresh schedules, access permissions, and subscription-based report delivery for stakeholder groups across finance, operations, and executive leadership in US, EMEA, and APAC regions.
- Partnered with business stakeholders and finance analysts across global teams to define KPIs, business logic, and visualization standards aligned with corporate goals, conducting weekly review sessions and iterating on dashboard designs through user feedback cycles.
- Created data dictionaries, transformation logic documentation, and dashboard usage guides to support ongoing governance, compliance, and user adoption across the global analytics platform.
Junior Data Analyst - MetLife - Hyderabad, India
(2018-06 - 2020-02)
MetLife's Global Technology and Operations center in Hyderabad supported the company's enterprise data analytics and reporting function, providing BI solutions for insurance product performance monitoring, claims data analysis, and actuarial reporting across MetLife's life insurance, group benefits, and retirement product lines. The analytics team was responsible for building standardized reporting templates, automating recurring data extraction workflows, and migrating legacy Excel-based reports to interactive Tableau visualizations. As a Junior Data Analyst, responsible for writing SQL queries for data extraction and validation across claims and policy databases, assisting in the development of Tableau dashboards for insurance operations, performing data quality assessments and profiling, and supporting senior analysts with reporting deliverables and UAT coordination.
- Developed SQL queries for data extraction, transformation, and validation across policy administration, claims processing, and premium billing databases, supporting daily and weekly reporting needs for underwriting, claims operations, and finance stakeholders.
- Assisted in the design and development of Tableau dashboards for claims processing performance tracking, policy lapse rate analysis, and premium collection monitoring, creating visualizations that replaced manual Excel-based reporting workflows used by regional operations managers.
- Performed data profiling and quality assessments across source systems, identifying data inconsistencies in policyholder records, agent codes, and claims transaction records, documenting findings and recommending data cleansing actions to the data governance team.
- Built Excel-based reports and pivot table analyses for weekly business reviews, providing operations managers with summarized views of claims settlement turnaround times, new business issuance volumes, and policy persistency rates across product lines and distribution channels.
- Supported the migration of legacy Excel and Access-based reports to Tableau Server, assisting with data source connection configuration, calculated field creation, and dashboard formatting to align with MetLife's global visualization standards and branding guidelines.
- Created automated data extraction scripts using Python (Pandas) to consolidate and cleanse data from multiple flat file sources before loading into the reporting database, reducing manual data preparation time for recurring monthly reports.
- Participated in UAT coordination, developing test scenarios for dashboard accuracy validation, data refresh verification, and filter functionality testing, documenting defects and tracking resolution through JIRA across quarterly release cycles.
- Maintained reporting documentation including data dictionaries, transformation logic notes, and dashboard user guides, supporting knowledge transfer and onboarding for new team members joining the analytics function.
