About me

Hello, I'm Aasish Tammana, an AI and data analytics specialist with a Master's in Computer Science (Robotics - Artificial Intelligence) from Arizona State University, completed in May 2024 with a GPA of 4.00/4.00. My expertise spans artificial intelligence, automation, and data analytics, with deep experience in building custom AI tools, implementing LLMs for automation, and leveraging Python libraries such as Pandas, NumPy, Scikit-learn, and OpenAI API to create intelligent solutions.

My recent work centers on AI at Altium (acquired by Renesas in 2024), where I build custom tools for component classification, datasheet parsing, and knowledge‑base generation as part of the Product Foundry team. In the BI team, I performed TAM analysis and developed end‑to‑end automation systems. I also helped drive academic partnerships and institutional adoption (40+ colleges), integrating Altium into curricula and expanding the company’s footprint with enduring commercial impact. Earlier at Deloitte, I focused on data analytics—developing SQL/Python pipelines and Power BI reporting to deliver decision‑ready insights.

As a volunteer at ChemCopilot, I contributed to building AI-powered tooling for chemical formulation and sustainability analytics, aligning with their PLM-LIMS-ERP integrated platform. I worked on Copilots and automation pipelines to help teams calculate Scope emissions, analyze BOM data, and validate regulatory constraints, enabling traceable, compliant, and greener product development. My focus areas included Python, LLMs, vector search, and data modeling to support formulation decisions across cost, toxicity, and carbon footprint.

During my time at Arizona State University, I engaged in critical research under Professor Pitu Mirchandani at the DHS Center for Accelerating Operational Efficiency. My work focused on data visualization and Statistical Inference in the context of homeland security operations, particularly analyzing the COVID-19 pandemic's impact through spatial-temporal data analysis. This research enhanced my expertise in data analytics within public health domains.

I possess a robust skill set that includes expertise in AI tool development, LLM integration, OpenAI API, LangChain, CNN-based detection, automation pipelines, and knowledge base generation, alongside proficiency in data tools like Snowflake SQL, Azure Databricks, Microsoft Power BI, Tableau, AWS S3, and programming languages such as Python, C, and SQL. In addition to my AI and data-centric endeavors, I actively engage in robotics projects, utilizing my skills in hardware and software integration to develop and deploy complex systems that combine sensors, actuators, and controllers. I strive to create seamless interactions between the physical and digital worlds.

When I'm not immersed in technology, I enjoy exploring the outdoors, engaging in creative projects, and socializing. Thank you for taking the time to delve into my professional journey. I am eager to explore new challenges and opportunities where I can bring my AI, automation, and data analytics expertise to bear on meaningful projects. Should you have any questions or wish to discuss potential collaborations, I am more than open to conversations. Let's connect and explore how we can drive innovation and excellence!

Resume

Education

  1. Arizona State University Tempe, Arizona, US

    Masters of Robotics and Autonomous Systems(AI); GPA: 4.00/4.00 Aug, 2022 - May, 2024

    Data Visualization, Python for Rapid Engineering, Data Processing at Scale, Machine Learning, Knowledge Representation, Artificial Intelligence, Statistical Machine Learning, Game Theory

  2. PES University Bengaluru, Karnataka, India

    B.Tech in Electronics and Communication Engineering; GPA: 8.47/10.0 Aug, 2016 - May, 2020 Minors in Computer Science and Engineering; GPA: 9.5/10.0 Aug, 2016 - May, 2020

    Data Structures, Algorithms, Database Management, Introduction to Computing, Digital Image Processing, Embedded Systems, Logic Design, Computer Networks, VLSI, Signal Processing

Experience

  1. Altium (acquired by Renesas in 2024) La Jolla, California, US

    Developer June, 2024 - Present
    • Devised custom AI tools for computerized component classification, datasheet parsing and enrichment, reference design recommendation, and block diagram extraction. Implemented knowledge base generation to accelerate engineering workflows.

    • Designed intelligent automation pipelines for electronic design, including CNN–based schematic and component detection, schematic and datasheets retrieval, and processing workflows for LLM distillation.

    • Developed a Python based system that translates natural language queries into Altium Designer's PCB Query format using EDIF netlist analysis and custom scoring, implementing intelligent component filtering on Altium's Filter pane.

    • Performed Total Addressable Market (TAM) analysis by integrating 330M+ LinkedIn profiles with Altium's software usage data using Python and SQL in Snowflake. Analyzed user job descriptions to identify potential users and categorized them into specific personas by leveraging LLMs for classification to target relevant users informing strategic market entry decisions.

    • Programmed an end-to-end caricature drawing system to demonstrate Renesas 365 using Python, OpenCV, and G-code generation to convert camera images into SVG drawings for a Rotrics DexArm, controlled by a Renesas RZ/V2L processor. Integrated paper detection via VL6180 time of flight sensor with Renesas RA0E1 microcontroller (I2C/UART).

    • Created a unified Employee Entity by establishing link tables using Data Vault 2.0, deduplicating data from UKG, Jira, and Salesforce.

    • Conducted discrepancy analysis between Salesforce Opportunities data and corresponding Snowflake database, identifying and resolving inconsistencies in counts and opportunity close dates to ensure accurate daily data integration for reporting.

    • Integrated an AI chatbot (Anything LLM-GPT 3.5) within the company intranet to answer queries based on the documentation hosted on the website. The Python based tool was containerized as a Docker image for streamlined deployment.

    • Drove Altium's market penetration through data-driven strategic marketing, securing 40+ college partnerships and integrating Altium's curriculum, which expanded the company's operational footprint with enduring commercial impact.

  2. ChemCopilot (Technical Contribution) Remote, California, US

    Developer July, 2024 - Apr, 2025
    • Architected 7 AI agents using LangGraph for chemical sustainability workflows (BOM generation, toxicity analysis, CO₂ estimation, ingredient substitution, ESG reporting) with multi-agent orchestration, state management, and parallel processing across database queries, web search, and vector similarity matching. Created using Python, LangChain, OpenAI, Streamlit, Tavily, and SQLite.

    • Engineered context-aware natural language to SQL translation system with prompt engineering for real time data retrieval from 50k+ beauty product records and 600k+ chemical toxicity datasets. Implemented FAISS-based RAG system for semantic document search across thousands of chemical specifications, enabling accurate toxicity profiling and regulatory compliance validation.

    • Designed molecular similarity search engine using SMILES fingerprinting for intelligent ingredient substitution recommendations. Built what-if analysis engine enabling instant environmental and financial impact assessment for sustainable formulation decisions, with automated sustainability scoring algorithms, interactive visualization generation (Sankey diagrams, decomposition charts).

  3. Arizona State University Tempe, AZ, US

    Graduate Research Assistant under Professor Pitu Mirchandani May, 2023 - Dec, 2023
    • Conducted an extensive analysis of COVID-19 trends, with a particular focus on the years 2020 to 2023. My research delved into the dynamics of the pandemic, the effectiveness of measures implemented, and their influence on different U.S. states. Specifically Arizona, Alabama, and Vermont served as insightful case studies.

    • Leveraged spatial-temporal data analysis to explore the relationships between COVID-19 vaccinations, masking policies, and case trends. We aimed to determine the extent to which these interventions contributed to reducing the spread of the virus.

    • Explored trends, spikes, and declines in COVID-19 cases, hospitalizations, and deaths. My work shed light on the complexities of the pandemic and the multifaceted factors influencing its trajectory.

    • Identified and depicted critical hospital staffing shortage data, providing valuable insights into the challenges faced by healthcare facilities during the pandemic.

  4. Deloitte India (Offices of the US) Bengaluru, Karnataka, India

    Data Analyst / Engineer Aug, 2020 - July, 2022
    • Built and delivered 20+ comprehensive reports (time series charts, graphs, maps, KPIs) using Power BI and SQL (Azure Databricks Spark), providing stakeholders with actionable business insights and guiding strategic decision-making.

    • Transformed unstructured data into detailed data models and mappings to track and analyze spend, payments, and supplier utilization, achieving 100% compliance and enhancing operational efficiency.

    • Optimized SQL query performance using Joins, CTE's, window functions and sub-queries resulting in increased interface responsiveness of dashboards related to Procurement, Legal, Security by 40%.

    • Automated integration of 8 public datasets on immunocompromised individuals using AWS lambda (Python), Power Query to establish real-world evidence (RWE) and assess COVID-19 impact in devising vaccination strategies.

    • Configured source-to-target connection and designed data flow mappings in Informatica BDM for ETL jobs. Achieved 100% workload automation by scheduling and supervising Tidal data lake job loads, ensuring seamless integration.

    • Led user acceptance and A/B testing to implement 200+ critical feature enhancements. Documented technical design to support data management and guide future developments.

  5. Nokia Solutions and Networks Bengaluru, Karnataka, India

    Intern March, 2020 - Aug, 2020
    • Revamped a tool from Go language to Python to accept a template Call Session Control Function (CSCF) file used for managing signaling from end users to generate 10 generic XMLs and eliminate manual efforts.

    • Wrote Bash scripts to perform MD5 checks for four file systems to ensure information is in the same state.

Work

Altium

ChemCopilot

  • BOM Agent

    AI Agent

    LangGraph

    BOM Generation

    BOM Agent

    Architected an intelligent Bill of Materials (BOM) generator for beauty products using LangGraph, LangChain, and OpenAI. The agent automates the creation of detailed BOMs based on product descriptions, integrating web search capabilities via Tavily API and database lookups from SQLite databases.

    Implemented state management with BOMAgentState using StateGraph workflow, functional group categorization for ingredients specific to product categories, AI-powered consolidation using GPT-4 for information processing, and automated CSV output generation with ingredient percentages and functional groups.

    Python
    LangGraph
    LangChain
    OpenAI
    SQLite
    Tavily
  • Energy Agent

    AI Agent

    Energy Analysis

    Carbon Footprint

    Energy Agent

    Engineered an intelligent energy analysis and CO₂ estimation system for BOM ingredients using LangGraph and state-specific energy calculations. The agent analyzes energy requirements and calculates CO₂ emissions based on US state-specific energy grids and production processes from GHG databases.

    Implemented database integration with GHG databases for production process lookups, state-specific CO₂ equivalent calculations (g/kWh), energy requirement analysis (GJ/ton), consolidated energy analysis output, and web search fallback via Tavily API when database information is insufficient.

    Python
    LangGraph
    OpenAI
    SQLite
    Tavily
    Pandas
  • Toxicity Agent

    AI Agent

    Toxicity Analysis

    Regulatory Compliance

    Toxicity Agent

    Developed an intelligent toxicity analysis system for BOM ingredients using LangGraph and OpenAI. The agent analyzes toxicity levels for product ingredients by querying SQLite databases and performing web searches via Tavily API when database information is insufficient.

    Implemented automated toxicity value calculation with minimum non-zero value determination, critical effects identification, unit standardization, and comprehensive CSV output generation. The system leverages AI-powered processing for information consolidation and provides detailed toxicity profiles for regulatory compliance validation.

    Python
    LangGraph
    OpenAI
    SQLite
    Tavily
    Pandas
  • Visualization Agent

    AI Agent

    Data Visualization

    Impact Analysis

    Visualization Agent

    Built a comprehensive visualization system using LangGraph that merges energy and toxicity analysis data to generate interactive visualizations. The agent creates Sankey diagrams, donut charts, and decomposition plots to illustrate sustainability impacts and enable what-if analysis for formulation decisions.

    Implemented data merging and validation workflows, automated sustainability scoring algorithms, interactive visualization generation with Plotly and Matplotlib, footprint decomposition analysis, and comprehensive impact assessment combining toxicity, energy, and cost metrics for real-time formulation analysis.

    Python
    LangGraph
    Plotly
    Matplotlib
    Pandas
    OpenAI
  • Consolidation Agent

    AI Agent

    Data Integration

    PostgreSQL

    Consolidation Agent

    Developed a comprehensive consolidation agent using LangGraph that integrates outputs from multiple specialized agents (BOM, toxicity, energy) into unified sustainability reports. The agent queries PostgreSQL databases to consolidate energy and toxicity data from consolidated database tables.

    Implemented state management with BOMAgentState for multi-agent coordination, PostgreSQL integration for consolidated data retrieval, automated ingredient processing with functional group assignment, production process mapping, and comprehensive output generation combining all analysis dimensions into actionable sustainability insights.

    Python
    LangGraph
    PostgreSQL
    SQLAlchemy
    Pandas
    OpenAI
  • SMILES Agent

    AI Agent

    Molecular Similarity

    SMILES Fingerprinting

    SMILES Agent

    Designed a molecular similarity search engine using SMILES fingerprinting and ChemBERTa embeddings for intelligent ingredient analysis. The agent converts chemical names to SMILES strings, generates molecular fingerprints, and performs vector-based similarity searches across chemical databases.

    Implemented SMILES string conversion using OPSIN and PubChem APIs, Morgan fingerprint generation with RDKit, ChemBERTa-77M-MTR model integration for molecular embeddings, FAISS-based vector search for similarity matching, and PostgreSQL integration for querying consolidated chemical databases.

    Python
    RDKit
    ChemBERTa
    FAISS
    PostgreSQL
    Transformers
  • Substitution Agent

    AI Agent

    Ingredient Substitution

    Sustainability

    Substitution Agent

    Architected an intelligent ingredient substitution system using LangGraph that identifies sustainable alternatives for product ingredients. The agent uses chemical similarity, toxicity filtering, and energy analysis to recommend non-toxic substitutes with improved environmental profiles.

    Implemented state management with SubAgentState, LLM-powered candidate identification for organic compound substitutions, toxicity filtering using Tavily web search and AI analysis, energy data computation for substitution candidates, and comprehensive output generation with environmental impact assessment for sustainable formulation decisions.

    Python
    LangGraph
    OpenAI
    Tavily
    PostgreSQL
    SQLAlchemy
  • Report Agent

    AI Agent

    RAG System

    ESG Reporting

    Report Agent

    Architected a comprehensive ESG reporting and research assistant using LangGraph with multi-agent orchestration and analyst personas. The agent generates detailed ESG reports by leveraging FAISS-based RAG systems for semantic document search across thousands of chemical specifications and regulatory documents.

    Implemented vector store creation with FAISS for sub-second retrieval, LangGraph-based research workflows with multiple analyst personas conducting parallel interviews, web search integration via Tavily and Wikipedia, automated ESG report generation aligned with GRI, SASB, and ISSB standards, and comprehensive regulatory compliance validation.

    Python
    LangGraph
    FAISS
    RAG
    OpenAI
    Tavily

Deloitte

  • Procurement Analytics Hub Overview

    Business Intelligence

    Power BI

    Data Visualization

    Procurement Analytics Hub - Takeda

    Architected and developed comprehensive procurement analytics platform for Takeda Pharmaceutical as part of the "One Takeda" transformation initiative. Created unified reporting framework with 20+ interactive Power BI dashboards tracking procurement KPIs across compliance, supplier management, spend analytics, and operational efficiency.

    Designed Level 2 (summary) and Level 3 (drill-down) dashboard architecture with landing pages and navigation structure. Implemented multi-dimensional filtering, cross-filtering capabilities, dynamic DAX measures, and drill-through functionality enabling stakeholders to navigate from executive summaries to detailed transaction-level analysis across procurement operations spanning multiple regions.

    Power BI
    DAX
    Business Intelligence
    Data Visualization
    Interactive Dashboards
  • Compliance & Policy Dashboards

    Data Visualization

    Compliance Analytics

    Power BI

    Compliance & Policy Dashboards

    Developed specialized compliance dashboards tracking Purchase Order (PO) compliance, Purchase Requisition (PR) compliance, and policy adherence metrics. Created visualizations enabling stakeholders to monitor compliance rates, policy violations, and threshold adherence across regions, suppliers, and management units.

    Built PO Compliance Dashboard with compliance trend analysis over time, regional compliance comparisons, supplier-level compliance tracking, and retrospective PO identification. Developed PR Compliance Dashboard tracking procurement early engagement, threshold compliance, split requisition detection, and policy violation analysis. Implemented drill-down capabilities allowing users to navigate from summary KPIs to detailed transaction-level data for root cause analysis.

    Power BI
    Compliance Analytics
    DAX Measures
    Data Visualization
  • Supplier Management Dashboards

    Data Visualization

    Supplier Management

    Geographic Analytics

    Supplier Management Dashboards

    Created comprehensive supplier analytics dashboards including Supplier Utilization Dashboard, Preferred/Qualified Suppliers Dashboard, New Suppliers Dashboard, Supplier Performance Dashboard, and Supplier Enablement e-Invoicing Dashboard. Developed geographic visualizations mapping supplier distribution across regions and countries.

    Implemented supplier segmentation analytics tracking preferred vs. qualified suppliers, new supplier identification post-policy changes, supplier compliance metrics, and utilization patterns. Built treemap visualizations for supplier distribution analysis, time-series charts tracking supplier onboarding trends, world map visualizations for geographic supplier analysis, and detailed supplier performance scorecards.

    Power BI
    Geographic Analytics
    Supplier Management
    Data Visualization
  • Spend Analytics Dashboards

    Data Visualization

    Spend Analytics

    Financial Analytics

    Spend Analytics Dashboards

    Developed comprehensive spend analytics dashboards including Combined Spend Dashboard, Direct Spend Dashboard, DPO Spend Dashboard, DPO Cash Release Tracking Dashboard, Procurement Value Tracking Dashboard, Committed Spend Dashboard, Spend Under Category Plan Dashboard, and Price/Spend Forecasting Dashboard.

    Created unified spend views combining data from multiple source systems, category-based spend analysis, payment terms optimization tracking, cash flow analysis, committed spend tracking, category planning alignment, and predictive spend forecasting. Implemented time-series visualizations, category breakdowns, regional spend comparisons, and trend analysis enabling strategic procurement decision-making.

    Power BI
    Spend Analytics
    Financial Analytics
    Data Visualization
  • Operational & Strategic Dashboards

    Data Visualization

    Operational Analytics

    Power BI

    Operational & Strategic Dashboards

    Developed operational and strategic procurement dashboards including Travel Analytics Dashboard, Segmentation Dashboard, Ethical Sourcing Dashboard, Contracting Dashboard, eSourcing Dashboard, and WOW (Ways of Working) Behavioral KPIs Dashboard.

    Created Travel Analytics Dashboard with rolling 12-month trend analysis, year-over-year comparisons, traveler location analysis, and category-specific scorecards for airfare, hotel, car rental, and rail. Built Segmentation Dashboard for supplier and spend segmentation analysis, Contracting Dashboard for contract lifecycle management, eSourcing Dashboard for sourcing event performance tracking, and Ethical Sourcing Dashboard for sustainability tracking.

    Power BI
    Operational Analytics
    Travel Analytics
    Data Visualization
  • SQL Query Optimization & Data Engineering

    Data Engineering

    SQL Optimization

    Performance Tuning

    SQL Query Optimization & Data Engineering

    Optimized complex SQL queries for procurement analytics dashboards using Azure Databricks Spark SQL. Significantly improved dashboard responsiveness through strategic query design, leveraging advanced SQL techniques including CTEs, window functions, joins, and sub-queries.

    Implemented query performance tuning techniques including partition pruning for time-based queries, index optimization on key columns, strategic join selection (INNER, LEFT, RIGHT), and aggregation optimization. Developed efficient data transformation logic enabling real-time analytics on large-scale procurement transaction data, supporting all visualization dashboards with optimized data retrieval.

    SQL
    Azure Databricks
    Spark SQL
    Query Optimization
    Performance Tuning
  • Data Modeling & ETL Architecture

    Data Modeling

    ETL

    Data Architecture

    Data Modeling & ETL Architecture

    Architected comprehensive data models for procurement analytics, transforming unstructured data from SAP Ariba and SAP ERP into structured, analytics-ready datasets. Designed star schema data models with fact and dimension tables for efficient querying and reporting across all dashboards.

    Configured Informatica BDM for ETL pipelines, designed source-to-target mappings, and implemented automated data workflows using Tidal Data Lake for job scheduling. Created data models tracking purchase orders, invoices, requisitions, suppliers, and spend across multiple dimensions including time, geography, category, and organization hierarchies. Ensured data quality and consistency enabling reliable visualization and analytics.

    Data Modeling
    Informatica BDM
    ETL
    Star Schema
    Data Architecture

Projects

Research

Contact

Contact Form