Aswin Ram K
Data Analyst & AI Product Builder
Summary
Data analyst and AI product builder in Tiruchirappalli, India. I turn messy data into decisions, and build AI products — RAG systems, Power BI automation and machine learning — on top of data people can trust.
Experience
Data & Business Intelligence Consultant · Self-employed
Jul 2025 — PresentTamil Nadu, India · Remote · Freelance
- Built 5+ enterprise Power BI dashboards for credit, sales and purchase analytics, cutting the reporting cycle by 40%.
- Analysed 8,000+ invoices, GST records, credit limits and purchase orders to surface credit-exposure risk by region and business unit.
- Designed and delivered a UI-driven enterprise dashboard for Papers that replaced a folder of spreadsheets.
- Built dashboards, a RAG assistant over the company's own documents, and automated, validated data entry for a garment production company.
- Built recruitment cards and hiring dashboards for private companies in Chennai.
- Handling payment data for power-sector businesses: reconciling transactions and reporting payment status.
BI & AI Consultant (freelance project) · Production company — garment manufacturing
2025Tamil Nadu, India · Remote · Freelance project
- Built Power BI sales, credit and purchase dashboards on one data model, with automated refresh and drill-down from a region to a single invoice.
- Built a RAG assistant that answers questions from the company's own documents and shows the source of every answer.
- Automated data entry: a structured template with validation of required fields, formats and duplicates before anything is saved.
Business Intelligence Analyst · VDart Inc.
Mar 2025 — May 2025Tamil Nadu, India · Internship
- Developed 5+ interactive Power BI dashboards and SQL reports on customer behaviour across 5,000+ records.
- Ran full ETL and data validation with SQL and Power Query, holding 99% data accuracy for business-critical reporting.
- Exploratory analysis surfaced customer segments and trends that helped reduce churn by 12%.
- Automated 10+ recurring reporting workflows, saving about 25 hours of manual work each month.
Market Research & Pricing Analyst · European rental market project
Jul 2024 — Jan 2025Remote · Freelance
- Ran end-to-end analysis on 50,000+ European rental listings with Python (pandas, NumPy) and SQL.
- Exploratory analysis revealed an 18% pricing variance across regions and pinpointed high-demand neighbourhoods.
- Automated the data pipelines, cutting data-prep time by 60% and enabling weekly trend monitoring.
Applied ML Engineer · NIT Trichy
Mar 2024 — May 2024Tiruchirappalli, Tamil Nadu · ML internship
- Built a face-recognition attendance system with Python, OpenCV and supervised learning, reaching 92% recognition accuracy.
- Implemented image preprocessing and real-time detection that cut false positives by 20%.
- Trained and compared SVM and KNN models with cross-validation on precision, recall and F1.
- Automated attendance for 100+ users, removing manual logging errors.
Projects
DocMind · RAG system· Building
Ask questions of your own PDFs and reports, and get answers that cite the exact passages they came from.
Python · LLMs · Sentence embeddings · FAISS / Chroma · LangChain · Streamlit
Power BI MCP· Building
An MCP bridge that lets an AI assistant query a Power BI model directly and answer business questions with the real figures.
Power BI · DAX · Model Context Protocol · Python · LLMs
Papers · enterprise dashboard· Shipped
One interactive dashboard in place of a folder of spreadsheets, so leadership sees the health of the business in one place.
Power BI · Power Query · DAX · Data modelling · Excel
Production company systems· Shipped
Sales, credit and purchase data brought into one model with self-refreshing Power BI dashboards, a RAG assistant that answers from the company's own documents, and a data-entry flow that checks every record before it is written.
Power BI · DAX · Power Query · Python · RAG
Credit & sales intelligence· Ongoing
Power BI dashboards over invoices, GST records and credit limits that made credit exposure visible and cut the reporting cycle by 40%.
Power BI · DAX · SQL · Power Query · Data modelling
European rental pricing· Shipped
End-to-end analysis of 50,000+ rental listings that found an 18% regional price gap and the neighbourhoods worth expanding into.
Python · pandas · NumPy · SQL · Data visualisation
Skills
Business Intelligence & Viz: Power BI (DAX, Data Modeling), Tableau, Looker Studio, Excel Dashboards, Data Storytelling
Data Analysis & Programming: Python (Pandas, NumPy), SQL (Joins, Subqueries), Exploratory Data Analysis, Statistical Analysis, Descriptive Statistics, KPI Analysis, Analytical Reporting, Matplotlib / Seaborn
AI & Machine Learning: Supervised Learning, Regression Models, Model Evaluation (MAE, RMSE), Feature Engineering, Scikit-learn, OpenCV, RAG / LLMs, Prompt Engineering
Data Engineering & Automation: ETL Pipelines, Power Query, Data Cleaning, Data Transformation, Data Validation, Workflow Automation, n8n
Databases: MySQL, MongoDB, SQL Optimization, Data Modeling
Tools & Platforms: GitHub, VS Code, Jupyter, Google Colab, Google Sheets, Excel (Advanced), JIRA, Notion
Education & Certifications
Mookambigai College of Engineering
B.E. in Computer Science and Engineering · GPA 8.2 / 10.0 · 2021 — 2025
Anna University, Tamil Nadu · Minor: Data Science Fundamentals
- Python for Data Analytics — LiveWire (Certified)
- Data Science with R — LiveWire (Certified)
- Machine Learning Specialization — Coursera (In Progress · 2025)
Languages: English (Professional), Tamil (Native)