Amaan Ashraf

About

Data professional automating vehicle-data workflows with Python, SQL, and GenAI. Experienced in data validation, research automation, and cross-functional collaboration, with a growing focus on data and AI engineering.

Experience

• Data Transformation Analyst II
  Mobility Global
  Apr 2026 – Present

  Designed and developed Python-based automation solutions to eliminate repetitive vehicle data research and validation tasks, reducing data processing and research time by approximately 40%. Built an end-to-end automation tool integrating the NHTSA REST API to process Excel audit files, automatically retrieve crash ratings and vehicle specifications, and populate missing attributes. Resolved Salesforce cases by analyzing client requests, researching vehicle specifications, and delivering accurate, validated data and analytical insights within defined service levels. Leveraged AI-powered tools including GenSpark Assist and NotebookLM to automate OEM documentation research, extract structured vehicle specifications, and accelerate attribute validation. Automated Excel workflows using Python (Pandas, OpenPyXL) for bulk data validation, transformation, and reporting, improving consistency and reducing manual effort. Collaborated with cross-functional teams to identify automation opportunities, document Standard Operating Procedures (SOPs), and improve enterprise data quality.

• Apprentice, Data Transformation
  S&P Global Mobility
  Oct 2025 – Apr 2026

  Executed daily data audits and validation for Powertrain, Drivetrain, Comfort & Convenience, and other vehicle attributes using Oracle SQL on ODSP databases. Performed VIN-level research using VCAT, OEM order guides, manufacturer documentation, and proprietary vehicle decoders to enrich North American automotive datasets. Optimized SQL queries and leveraged advanced Microsoft Excel techniques to improve audit efficiency and support descriptive data analysis. Collaborated with analysts and business stakeholders to resolve complex vehicle data discrepancies and maintain high data quality standards.

Education

• B.Tech.
  Jamia Millia Islamia
  Mechanical Engineering · Dec 2021 – Jun 2025
• Senior Secondary
  2020 – 2021
• Secondary
  2018 – 2019

Skills

Tools / apps / platforms

Projects

• Salesforce Case Analytics & Workflow Support
  Python, Excel

  Developed Python utilities to automate supporting research and reduce turnaround time for recurring Salesforce case types. Built pre-publication validation automation using Excel macros and scripts to catch data errors before cases were published.

• AI-Powered Vehicle Research Assistant
  GenSpark Assist, NotebookLM

  Built an AI-assisted workflow to extract structured vehicle specifications from OEM documentation and technical resources. Designed prompt-based retrieval workflows to accelerate vehicle attribute validation and standardize research outputs.

• NHTSA Attribute Automation Pipeline
  Python, Excel, NHTSA REST API

  Engineered a Python automation pipeline integrating the NHTSA REST API to programmatically retrieve and populate values for a full vehicle safety attribute across Excel audit files. Reduced manual research time by approximately 90% and built the pipeline as a reusable pattern for additional attributes.

Courses & certifications

• Machine Learning & Advanced Learning Algorithms · Coursera · 2025
• SQL & Relational Databases 101 · IBM · 2025

🏆 Achievements & awards

• SQL Gold 4 Star · 2025

  HackerRank certification/recognition.