Sneha Reddy

Assessed large datasets (Clarity and Caboodle), drew valid inferences and prepared insights in narrative or visual forms . Responsible for organization wide tableau dashboards. Developed several service line dashboards and physician scorecards. Responsible for Ambulatory and Emergency department dashboards. Involved in converting crystal reports to reporting workbench reports.

• Interpreted business questions and collaborated with engineering teams to identify data sources.
• Developed service line dashboards with appointment access metrics, quality measures, procedure volumes, Referrals, Readmissions, WRVU productivity, income statements, and quality measures for Cardiology, Neurology, Pediatrics, Women’s Health, PCP, Orthopedics, and Surgery.
• Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
• Created and automated data visualizations to present insights for Digital Front-door Initiative.
• Collaborated with stakeholders to identify business needs and data sources.
• Created dashboards to monitor and track key performance indicators.
• Developed complex dashboard and reporting tools to track physician participation, referrals, claims , RVUs, budgets, scorecards for ambulatory practices.
• Generated several ad-hoc RWB reports to evaluate clinical data like nursing safety indicators.
• Developed RADAR dashboards to evaluate access metrics like follow ups, no show rate, open encounters, next available appointments etc.
• Involved in converting crystal reports to RWB reports using Cogito SQL regarding lab and orders data.
• Involved in implementing applications like Pharmacy 340B, Physician finder (KYRUUS), Artera (Patient Chat application).

• Responsible for establishing reporting team in the hospital
• Solely responsible for end to end development of the Tableau Reporting Environment: Meeting with doctors, nurses and administrators to develop report requirements, Gathering data from a variety of databases and applications (3M, Pres-
• Ganey, Optimum, Window path, Athena, Allscripts, Track it, Icon payroll, CI Manager, Lawson) into a
• Datawarehouse, writing the SQL queries (with or without a data dictionary) mounting the queries in
• Tableau, developing visualizations and training end users how to operate Tableau
• Data warehouse reporting – 2TB database (big data)
• Gathered business requirements and performed gap analysis for implementation of data analytics in multiple departments
• Development with Tableau desktop and administration of the Tableau Online Server
• Optimizing SQL queries for Performance
• Use of Tableau Data Prep to normalize data from multiple sources
• Meaningful Use, MIPS, PCMH, PQRS measures data submission, Key Performance Indicators (KPI) Benchmarking, Revenue Cycle Management (RCM), Physician Billing, ACO quality metrics dashboard, physician performance scorecards, emergency department quality metrics
• Responsible for implementation of Premier Quality Advisor tool, used for benchmarking the quality indicators against the peer hospitals across the nation
• Responsible for implementation of data analytics website in the hospital for easy access to requesting the data, publishing hospital wide quality metrics, analytics newsletter, promoting the utilization of data to improve the workflows and data governance
• Responsible for scoping, business specifications gathering, project management and developing of data extracts for various data integration projects with Mt Sinai Main campus databases for utilizing MT Sinai’s population health, billing and Quality reporting applications at South Nassau.

• Implementation of Tableau dashboards and reports in multiple departments: Quality and
• Performance Improvement, Finance, ACO, Physician Billing, Infectious diseases, Medicine,
• Emergency and Trauma, Nursing, Patient Outcomes, Decision Support, NICU, Pediatrics, Fetal
• Medicine, Lab and Pathology, Cardiology, Family Medicine and Pharmacy
• Development of Physician scorecards and performance evaluation
• Established COVID-19 Analytics in the hospital and developed data analysis for various research projects
• Developed data analytics for various DOH quality initiatives
• Responsible for reporting on a $10 million program
• Reports were used as an example of best practices for other clinics participating in CCBH
• As of January, Acacia is the only clinic to successfully report on all measures
• Data warehouse reporting – 450GB, 3,000 tables & 750,000 columns, none with pre-existing documentation
• Worked on Nextgen EMR system
• As the only person with SQL knowledge, responsible for introducing others to SQL Server
• Management Studio and the basics of writing SQL
• Creating interactive dashboards in Tableau for executives, calling stored procedures and views from Tableau
• Used traces to find the correct columns and tables for reporting
• Training end users in the proper workflows to capture data for reporting
• Revenue cycle management (RCM) reporting
• Copious ad hoc reporting.

• Responsible for implementing Cadence (patient Scheduling) reports, used to manage the schedules for more than 400 doctors and more than 1000 patients a day
• Reporting from a 10 TB database (“Big Data”)
• Working with a team of 6 to adapt Henry Ford Customized reports using T-SQL and Crystal
• Creating new reports from scratch based on user requirements
• Ad Hoc reports and support for the epic transition
• Cadence reports like provider access, department access, copayments, schedule utilization, appointments, DAR
• Involved in the life cycle of the project, i.e., requirement gathering, design, development, testing and maintenance of the reports.

• Interacted with business representatives for gathering business requirements and to analyze the business and functional specifications
• Analyzed source data, extracted, transformed and loaded data (ETL) from legacy systems into the target data using SSIS packages
• Developed SQL queries for data analysis to build up reports and dashboards for end users
• Good knowledge in developing custom reports, utilizing formulas, setting up parameters for some dynamic reporting, creating sub-reports, incorporating the use of graphs
• Planned, designed and implemented diverse business intelligence solutions.

• Sourced and analyzed data from variety of sources like SAS data sets, MS Access, MS Excel,
• CSV, SQL Server and Flat files
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools like SAS / Graph, SAA / SQL, SAS Integration studio
• Visualization of data after performing statistics was done using tableau for graphical representations
• Created dashboards using calculated fields, groups, sets and hierarchies in Tableau
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial
• Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.