Muzafar Khan

Big Data, Data Analysis, Cloud Engineering, ETL Pipelines | Driving Scalable, High-Performance Data Solutions & Predictive Analytics

Greater Chicago Area

About

I am a Data Analyst/Engineer specializing in delivering data-driven insights and building scalable analytics solutions across healthcare, finance, and technology domains. I leverage strong expertise in SQL, cloud data platforms, and business intelligence to support operational efficiency and informed decision-making. Over 3+ years, I have grown my experience through hands-on roles at leading organizations such as UnitedHealthcare Group and Freddie Mac, strengthening my capabilities in claims, risk, and portfolio analytics, as well as standardized and ad hoc reporting across AWS-based data platforms. Key achievements include developing Tableau dashboards that reduced claims denial rates by 18%, cutting Cycle Time to Action by 30% through real-time visual analytics, and building financial and cost-benefit models that identified 12% potential savings. I have also automated reporting workflows using Excel and Power BI, reducing manual effort by up to 40% while improving data accuracy and governance in HIPAA-compliant environments. I am open to networking, new challenges, and opportunities to collaborate on analytics initiatives that transform data into actionable insights and drive measurable business impact.

Experience

  • Data Analyst at United Healthcare Group
    Aug 2023 - Present · 3 yrs

    • Migrated legacy SQL Server data to Delta Lake architecture on Azure, enhancing data accessibility and scalability. • Collaborated with cross-functional teams to gather and analyze business requirements, leading to the development of a Claims Data Optimization dashboard that reduced denial rates by 18% and improved claim cycle efficiency. • Analyzed EHR data (Epic, Cerner) to improve claims accuracy, ensure HIPAA compliance, and visualize clinical KPIs via Tableau dashboards. • Partnered with finance and operations leaders, presenting Excel-based models that identified 12% potential savings.

  • Business Data Analyst at Freddie Mac
    Oct 2022 - Apr 2023 · 7 mos

    • Developed risk exposure models and interactive dashboards (Power BI & Tableau) that visualized loan default trends, enabling portfolio reallocation strategies. • Built Excel based cost-benefit models that streamlined underwriting workflows and delinquency processing time. • Automated loan portfolio reports using Excel Power Query and PivotTables, cutting reporting effort by 40% and improving accuracy. • Conducted data reconciliation in excel between oracle and AWS Redshift sources to ensure reporting accuracy. • Conducted data quality assessments that decreased processing errors by 25%, enhancing data reliability.

  • Data Analyst at Experion Technologies
    Jul 2020 - Aug 2021 · 1 yr 2 mos

    • Utilized Python, SQL, and AWS services to extract, transform, and analyze data, improving query performance by 25%. • Managed project schedules using MS Project, achieving a 15% improvement in project timeline adherence. • Created data visualizations in MS Excel, leading to a 20% improvement in data visualization effectiveness.