Learn Data Skills
Beta
Ryan Szabo

Ryan Szabo

Senior Consultant

IBM

Technologies

My Portfolio Highlights

My New Track

Associate Data Scientist in R (previously Data Scientist with R)

My New Course

Introduction to Python

Champion of data integrity, ensuring accuracy in the age of information overload.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to ChatGPT

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

IBM Consulting | Sep 2012 - Present

Senior Consultant

Serves as dedicated analytic consultant and data subject matter expert for the Ohio Medicaid and 7 other state agencies. •Provides analytic consulting to over 150 State of Ohio data analyst through report definition peer review, report criteria development, and subject matter expertise in Ohio Medicaid claims, eligibility, provider, financial transactions, and MDS 3.0 nursing facility assessment data. •Delivers quarterly data analyst user group presentations on advanced reporting application features and reviews of analytic projects using Ohio Medicaid data. Accomplished Business Analyst tasks during major application upgrade projects to source data directly from the Ohio Medicaid source data systems. •Reviewed source system reference documentation to complete source to target mapping document for hand-off to Data Architects •Led multiple requirements gathering sessions with Ohio Medicaid power users and subject matter experts (SME) to complete gap analysis and project requirements deliverables •Wrote ad-hoc SQL queries using Oracle SQL Developer, Apache Hive, and Cloudera Impala to interrogate and profile source system data •Developed and executed test plans to validate custom business rules across claims, financial transactions, provider, and Minimum Data Set (MDS) 3.0 data sources to populate target application data fields •Wrote advanced ad-hoc SQL queries to research data anomalies and to define solutions to deliver on Ohio Medicaid business user requirements •Reviewed and developed customized rules to ensure source system data is represented accurately and consistently in the application •Worked closely with team members to explain source system data relationships to enhance overall team understanding of the new source data
Show More

Western Reserve Health System | Jul 2009 - Sep 2012

Contract Analyst

● Perform financial analyses used in contract negotiations with major health insurance plans ● Recovered more than $20,000 in physician and hospital underpayments from contract performance audits ● Created series of quarterly reports detailing physician charges, physician payments, and new patient demographics for physicians in largest two group practices ● Produce quarterly audit of payments by contract for Summa Western Reserve Hospital ● Maintain fee schedule and charge tables in practice management software system for 5 physician groups ● Determined charges for new services provided by physician group clients from Oct 2009 to Jan 2011 ● Coordinate with insurance plan representatives to assess member benefits, determine plan coverage guidelines, and solve systematic payment errors ● Designed, constructed, and currently maintain Microsoft Access database storing physician group charges and contracted rate data

My Education

Take a look at my formal education

Bachelor of Arts (B.A.), EconomicsOhio University | 2008

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free