Anchit RaoSkillsExperienceWritingEducationContactRésumé

Data · Analytics · AI Engineering

I build the data systems teams stop worrying about.

Python, SQL and Apache Airflow at the core; large language models pulled in where they earn their place. Five years across consumer hardware and consulting, building ETL pipelines, cloud data infrastructure and automation that teams rely on.

Contact MeLinkedInGitHub

Skills

Languages
PythonSQL (Postgres, Oracle)
Orchestration & ETL
Apache AirflowKestran8nETL/ELT Data PipelinesWorkflow Automation
AI / LLM
Claude IntegrationLLM APIsLLM OrchestrationPrompt EngineeringStructured Output
Data Processing & Quality
PySparkPandasPolarsGreat Expectations
Data Analysis & Visualization
Power BI (DAX, Power Query)Exploratory Data AnalysisStatistical Modeling
Cloud & Infrastructure
AWS (Glue, S3)DatabricksDelta Lake

Experience

— present

Lansing, MI

Data & Analytics Consultant

Uday Shukla Corp.

  • Owned end-to-end delivery of 8 custom data engineering and AI solutions across 6 client teams, translating ambiguous business requirements into production pipelines and integrations
  • Designed and deployed batch data pipelines in Python, SQL, and Kestra, consolidating multiple source systems and processing 3-5K records weekly for downstream analytics and AI applications
  • Integrated LLM APIs (Claude, OpenAI) into data pipelines to extract and classify request intent from unstructured email, PDF, and free-text form content that intake forms left uncategorized; replaced a manual review process consuming 2-3 hours daily across a 4-person team
  • Built n8n automation agents integrating CRM data with LLMs for a real estate client, classifying inbound requests as new leads or existing-client follow-ups, routing each to the right team, and auto-generating templated responses that fed client requirements into their tracking database; cut follow-up response time from 2+ hours to under 40 minutes
  • Architected Power BI dashboards with DAX and Power Query, turning multi-source raw data into real-time KPIs — 15+ hours of weekly manual reporting eliminated, data accuracy up 25%.

—

Milpitas, CA

Software Engineer, Data

Western Digital Inc.

  • Engineered a multilingual ingestion pipeline in Python and LLMs to process 10,000+ customer forum posts every 48 hours across 5 languages, automating translation, sentiment analysis, and issue classification; routed cases to the correct regional support teams and enabled RMA logistics to track defect frequency, cutting manual triage time 60%
  • Designed and owned 32 Airflow DAGs consolidating sales, inventory, and executive reporting across 4 source systems and 100K+ daily rows; served as sole on-call for the full pipeline fleet, replacing 30+ hours/week of manual ad-hoc requests with scheduled delivery
  • Built an automated validation pipeline with Great Expectations over a 1B+ row production database, monitoring regional SKU mapping against the master list and quantity drift between physical and reported inventory; traced recurring mismatches to faulty upload processes and drove permanent fixes with APAC and EMEA manufacturing teams
  • Led the audit and refactor of an entire production application database into a single source of truth, defining schema and naming conventions adopted by 4 teams; reduced data integrity errors 25% and supported SOX compliance reporting
  • Built a self-service Python and pandas CLI suite enabling a 34-person logistics support team to query production data without engineering involvement; drove 80% adoption before departure and improved issue resolution turnaround 35%

Writing

Notes on the tooling I use day to day: what worked, what I got wrong, and the code that ended up in production.

  • Hello, World!

    Meet the man. The myth. The future (hopefully) legend.

Read All Posts →

Education

  • MS in Computer Information SystemsBoston University · Boston, MA
  • BS in InformaticsIndiana University · Bloomington, IN

Certifications

  • Google Cloud Professional Data EngineerIn Progress
  • Databricks Certified Data Engineer Associate
  • DeepLearning.AI Data Engineering Professional
  • DeepLearning.AI Generative AI for Everyone

Let's talk

Open to data, analytics and AI engineering roles. Sending opens your mail client with everything filled in.

Or write to me directly at anchit.jv.rao@gmail.com.