Ansh Shah

Business Intelligence Analyst at Equity Residential | UIUC MSIM Grad

Chicago, Illinois, United States

About

With a Master of Science in Information Science from the University of Illinois Urbana-Champaign, I serve as a Data Scientist at COUNTRY Financial®, where my core competencies include large-scale data processing and advanced analytics using Python and SQL. My educational journey fortified my expertise in data science, enabling me to build and optimize data pipelines and deliver actionable insights through in-depth data analysis. At COUNTRY Financial®, our team optimized data retrieval processes, significantly reducing response times and enhancing precision. My work entailed automating deployment audits and collaborating with cross-functional teams to implement scalable data solutions. My commitment to accuracy and efficiency in data management aligns with our organizational culture, and I bring a diverse perspective to our data-driven strategies, contributing to a culture of continuous improvement and innovation.

Experience

  • Business Intelligence Analyst at Equity Residential
    Oct 2025 - Present · 10 mos

  • COUNTRY Financial® (3 yrs 3 mos)
    • Data Scientist
      Jul 2023 - Oct 2025 · 2 yrs 4 mos

      • Built and optimized data ingestion pipelines with audit balancing, ensuring data consistency and alignment between incoming files and target systems. • Automated deployment audits by developing a Python-based script to detect mismatches between edge node locations and GitLab repositories caused by manual deployments. • Conducted in-depth analysis of business-critical data, using SQL and Python to identify trends, troubleshoot inconsistencies, and deliver actionable insights. • Resolved data anomalies in large datasets by identifying root causes of inconsistencies, ensuring accuracy for downstream reporting and analytics. • Collaborated with cross-functional teams to define and implement scalable data solutions that addressed business requirements and improved operational efficiency. • Developed and automated workflows for data quality checks, reducing manual intervention and enhancing reliability across data pipelines. • Improved pipeline performance by integrating advanced error-checking mechanisms, reducing downtime and ensuring high data processing speeds. • Partnered with stakeholders to understand and address data needs, delivering tailored solutions that aligned with organizational goals. • Designed and implemented processes to ensure compliance with data governance standards, minimizing risks associated with data inaccuracies.

    • Data Science and Project Management Intern
      Aug 2022 - Jun 2023 · 11 mos

      • Optimized data retrieval process by converting legacy Hive Query Language code hosted on the Azure cloud environment into PySpark code and reduced query response time by 73% • Performed data audit on 50K+ historical files using classification techniques such SVM and XGBoost, to generate a filtered dataset of ~1K claim cases • Designed a Python model to increase high precision matches by 89% between NICB contacts pulled from MySQL Database and existing claim contacts to detect insurance fraud

  • Technology Intern at ARCO a Family of Construction Companies
    May 2022 - Aug 2022 · 4 mos

    •Developed a Python Data Wrangling procedure for 10K rows of Construction Data from different sources, lowering processing time by 23% and increasing accuracy by 5% •Conducted root cause analysis to estimate the project completion date by analysing relationships and trends among variables using SQL and Python, resulting in improved precision planning by 38% •Translated analysing needs to identify cheapest source of Steel raw material into SQL queries that extracted data, and created relevant interactive Power BI Dashboards to present to stakeholders

  • Gies College of Business - University of Illinois Urbana-Champaign (8 mos)
    • Teaching Assistant - Statistics for Management Decisions
      Dec 2021 - May 2022 · 6 mos

    • Course Assistant
      Oct 2021 - May 2022 · 8 mos

  • Assistant Manager - Graduate Engineering Trainee at Jio Platforms Limited (JPL)
    Sep 2020 - Jul 2021 · 11 mos

    •Evaluated results for features of the Jio Fibre broadband, and smart home solutions for JioHome, by analysing 70K+ rows of users’ networking data using SQL •Designed dashboards using Tableau by quantifying the performance metrics of the platform which improved the efficiency of the platform by 9% •Deployed Python code to develop 2 web-based data retrieval systems that conducted descriptive and multivariate statistical analysis using SQL •Supported UAT testing by identifying and resolving 120+ production issues and actively participated in 35+ critical and successful release activities