DoTadda, Inc.

Providing user experience and application development advisory services for DoTadda as a member of the Advisory Board.

DoTadda, Inc. Advisory Board Member - User Experience/Development

Packt

For businesses, data analysis and visualization are essential for making informed decisions. However, the limitations of Excel can make these tasks time-consuming and difficult. That's why Extending Excel with Python and R is a game changer.

This comprehensive guide shows you how to integrate Python and R with Excel to automate tasks, execute statistical analysis, and create powerful visualizations. As you progress, you’ll find out how to perform exploratory data analysis, time series analysis, and even integrate APIs for maximum efficiency. Whether you're a beginner or an expert, this book has everything you need to unlock Excel's full potential and take your data analysis skills to the next level.

By the end of this book, you will be able to import data from Excel, manipulate it in R or Python, and perform the necessary analysis in your preferred framework while pushing the results back to Excel for sharing with others as needed.

Author

Stony Brook Medicine

- Leads PFS analyst team in detailed systems analysis projects involving design and development of subsystems, enhancement of existing systems, and formulation of proposals.
- Provides central support for the department to address system problems.
- Works with end users to update configuration and complete system testing.
- Develop training programs to instruct Patient Accounting staff on how to utilize system features and provide regular updates for system enhancements and/or changes.
- Act as liaison between Patient Accounting, Patient Access and IT departments.
- Maintain the Contract Management system to verify appropriate contractual allowances.
- Develop and monitor PFS system work queues.
- Assists with daily maintenance and reconciliation processes.
- Reviews and assists in departmental data and reporting needs.
- Manage and supervise analysis team through the monitoring of quality and productivity.
- Leads internal teams and special projects as requested.

Manager of Applications

Manchu Technology Corp.

- SQL Scripting / Stored Procedures
- Report writing - Simple and complex
- Trend Analysis / Time Series Analysis
- Data Visualization

Senior Data Scientist

Long Island Community Hospital

Actively develop an R package for data analysis called LICHospitalR

Time Series Modeling of items such as:
-    Length of Stay
-    Excess Days
-    Readmissions
-    Excess Readmissions
-    Discharges/Arrivals

Create internal benchmarks via SQL Stored Procedures

Streamline / Automate reports

Build Classification models for items such as:
-    Readmissions
-    Credit Ratings

Survival Analysis of Bad Debts

LeapFrog / Q-HIP

Data Scientist / IT Manager

Reports to Senior Director of Revenue Cycle. Some duties include:
- Preparing daily and monthly statistical and financial reports and analysis.  
- Maintain the hospital’s Contract Management system
- Conduct Revenue Cycle related audits with a focus on charge capture and missed revenue opportunities
- Compile information required for hospital productivity tracking
- Prepares the statistics for the monthly internal financial statements
- Assist in the maintenance of the hospital’s Charge Master
- Complete surveys for third parties and regulatory agencies and provide reimbursement, statistical information and analysis to internal users as the need arises.  

Current Projects:
- HCRA Audit
- ALOS Prediction
- Boston WorkStation automation implementation for Insurance status checking

Finished Projects:
- Readmission Prediction
- Automation of back end insurance verification with automatic pre-certification posting to medical record
- CJR analysis for mandatory bundled payment program
- Medicaid Accelerated Exchange (DSRIP), SQL Scripting, data analysis and presentation

Decision Support Analyst III

NYU Langone Medical Center

- Handling support tickets, which also include functionality requests.
- Implementation
- TDR's (Technical Dress Rehersals)
- Build testing e.g. New Practice, ICD-10, Meaningful Use
- Best Practice Advisory for patients at risk of Lung Cancer
- Creating a rule so any department can turn off requisition printing
- Meaningful Use Quality Measure Optimization

Epic Analyst I

Brookhaven Memorial Hospital Medical Center

- Develop and implement plans for data collection, analysis and reporting of clinical outcomes. 
- Produce complex reports of descriptive and analytic data in support of performance improvement programs and facilitate continuous data development.
- Perform necessary database and statistical analyses in order to evaluate trends in process, resource utilization, patient outcomes, satisfaction levels, cost and functional outcomes.
- Communicate analytic reports to all appropriate stakeholders and report on various metrics to measure the success of the decisions reached by clinical performance improvement teams.
- Readmission Task Force, perform clinical and demographic trending and forecasting. 
- Work with the LIHN network in order to support existing best practices and develop new benchmarkss
- Clinical trending and forecasting
- Blood Utilization Committee, collect, analyze and interpret data to present to the committee with the intention of blood use reduction
- Sepsis Committee, collect, analyze and interpret Sepsis TAT for sepsis patients in order to help identify if thresholds are being met or exceeded
- Readmissions Task Force

Clinical Decision Support Analyst

Hamilton Institute

On a volunteer basis I accepted to be the Managing Director of the Hamilton Institute.

The Hamilton Institute is a not-for-profit organization overseen by the International High IQ Society. The Hamilton Institute's mission is to provide a platform for amateur scholars to present their ideas and publish their work in a formal setting.

Formerly located in New York City, now in the Netherlands, the Hamilton Institute is a great platform for collaborative ideas and brings together smart people from all over the world. We look forward to seeing it grow and become one of the web’s most visible and influential centers of knowledge.

Managing Director / Volunteer

John T. Mather Memorial Hospital

- Responsible for managing operational evaluation and redesign for various clinical processes based upon priorities set by the Chief Medical Officer.
- Work products must include methodologies for measuring and tracking success of new and/or redesigned processes relative to established baseline outcomes. 
- Quantify results in terms of goal-driven aims. Works directly with leadership to envision and develop projects that have direct measurable impact on stated goals set by Administration. These goals will be stated in terms of People, Service, Quality and Safety and/or Innovation and Growth.
- Readmission TaskForce

Performance Improvement Analyst

- Contact patients on a daily basis in order to obtain demographic data pertinent to their medical chart for their upcoming surgical procedure. 
- Collect patient insurance information and submit through RECONDO in order to start the verification process and to assess eligibility for in and outpatient procedures. 
- Make pre-surgical testing appointment per anesthesia and hospital protocol in order to ensure the best medical care possible.
- Handle daily co-pay reconciliation and deposits

Registrar

Community Housing Innovations Inc.

- Maintain daily housing census and log daily house activity for legal records
- Coordinate housing clients with Emergency Services as needed
- Coordinate with CPS when necessary to comply with state and local laws for child safety

House Monitor

As a graduate of the Public Health Program at SUNY Stony Brook, I want to take the skills learned to construct a useful analysis of current public health issues in a pro-active fashion with a focus on predictive analytics for the health care industry. I carry a distinct vision that encompasses all aspects of healthcare where data is not a replacement but rather an enhancement to how medicine is approached. My career goals focus on a path that takes me to the CIO role.

Authored several #r #packages which can be found here: https://github.com/spsanderson

Feeling stuck with Excel for data analysis? 

You're not alone! Excel is fantastic, but for truly powerful insights and visualizations, it can fall short. 

My new book which was co-authored by David Kun, Extending Excel with Python & R, shows you how to leverage the strengths of BOTH worlds! 

Here's what you'll gain:
🧐 * Advanced data manipulation & cleaning
💻 * Powerful statistical analysis & modeling
📉 * Eye-catching data visualizations
🌟 * Seamless integration back to Excel

Even if you're new to coding, this book is your guide!

Unlock the full potential of your data & impress your colleagues! 

Reserve your copy today: link in the comments
#dataanalysis #python #R #excel #datavisualization #booklaunch

Packt
Apeksha Shetty
Nivedita Singh
Tiksha Lad

Steven Paul Sanderson II, MPH

R - install.packages("healthyverse") | SQL | some Python | Author

Taplio

Steven Paul Sanderson II, MPH's Linkedin Analytics

Steven Paul Sanderson II, MPH

Steven Paul Sanderson II, MPH's Best Posts (last 30 days)

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Steven Paul Sanderson II, MPH's Linkedin Analytics

Steven Paul Sanderson II, MPH

Steven Paul Sanderson II, MPH's Best Posts .css-qqfgvy{font-size:var(--chakra-fontSizes-md);}(last 30 days)

Want to drive more opportunities from LinkedIn?

Steven Paul Sanderson II, MPH's Linkedin Analytics

Steven Paul Sanderson II, MPH's Best Posts (last 30 days)