Sachin Rathod
Data Analyst @Harlem Children's Zone
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Harlem Children's Zone
NY, US
Orchestrated data ingestion workflows using Azure Data Factory & Databricks to integrate multimodal clinical, pharmacy & claims data from systems such as Epic, Allscripts, Cerner, Facets & QNXT into Azure Data Lake Storage Gen2.• Consolidated disparate EHR, claims and enrollment data sources (Epic, Cerner, QNXT) into a unified data model, increasing analytics data availability by 97% for population health initiatives and clinical research.• Automated end-to-end ETL pipelines using SSIS and Alteryx for transforming raw EHR, claims and Rx data into curated star-schema marts optimized for clinical quality and operational reporting.• Standardized interoperability across clinical systems by implementing HL7 v2, HL7 v3 and FHIR protocols, enabling seamless real-time data exchange and semantic harmonization across provider networks.• Analysed and processed healthcare EDI X12 transactions including 270/271 (eligibility), 837 (claims) and 835 (remittance advice), generating operational insights into claim denials, member eligibility trends and provider payment cycles.• Implemented risk adjustment models and propensity score matching techniques to support CMS, Medicare Advantage and HEDIS reporting, ensuring accuracy in RAF scoring, GAPS-in-care identification and value-based care metrics.• Developed and deployed machine learning–based readmission risk prediction models using Scikit-learn and XGBoost, reducing 30-day readmission rates by 18% across Medicare patient populations.• Partnered with Data Governance & Compliance teams to implement PHI/PII masking, lineage tracking & HIPAA-aligned data quality checks using Great Expectations & Azure Purview, achieving audit-readiness for internal and federal reviews.
EDUCATION
Pace University - Seidenberg School of Computer Science and Information Systems
Master's degree, Cyber Security
Smt.Kashibai Navale college of Engineering
Bachelor of Engineering - BE, Computer Engineering
ABOUT SACHIN RATHOD
Data Analyst with 5+ years of experience orchestrating end-to-end data solutions and driving strategic insights across the healthcare and financial sectors. • Expert in designing, automating and optimizing complex ETL pipelines using Azure Data Factory, Databricks, SSIS, Alteryx and Informatica PowerCenter to integrate diverse multimodal data from systems like Epic, Cerner, QNXT, Oracle and Hadoop into scalable data environments including Azure Data Lake Storage Gen2, SQL Server and PostgreSQL. • Proficient in advanced statistical analysis, implementing risk adjustment models, propensity score matching and developing machine learning-based prediction models (readmission risk, fraud detection) utilizing Python (Scikit-learn, XGBoost, StatsModels, Spark) and R (ARIMA, SARIMA). • Skilled in optimizing high-volume SQL, PL/SQL queries, ensuring data integrity & implementing robust data governance, PHI/PII masking & regulatory compliance frameworks such as HIPAA, GDPR, Basel IFRS 9 & RBI guidelines. • Adept at designing and deploying impactful executive-level dashboards with Tableau and Power BI to visualize key performance indicators and support critical business and clinical decision-making.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.