Aman Anand

A Data Professional with nearly 4 years of experience in data analysis, data engineering, and business intelligence. Proficient in dbt, SQL, Python, Advanced Excel, Power BI, and Looker. Strong skills in data integration, ETL processes, and developing robust data pipelines. Adept at communication, problem-solving, and delivering data-driven solutions to support decision-making processes. An avid learner who stays updated on the latest AI news and trends to continuously enhance my skills and knowledge.

• Proposed and initiated a pilot project to integrate AI capabilities with Snowflake, leveraging Snowpark for advanced data processing and machine learning, as well as Snowflake Worksheets for interactive data analysis.
• Improved relationship with ABACUS by developing a unique business intelligence solution to meet complex requirements.

• Post Graduate Diploma in Data Science - IIIT Bangalore
• Dbt Fundamentals, 05/01/26
• Innovating with Data and Google Cloud
• Developing Data Models With LookML

• Blogging
• Singing
• Drawing

Airtable Advertising Data Integration

• Cleaned and integrated Airtable advertising data into Snowflake using dbt, then surfaced it in BI tools for comprehensive analysis.
• Designed multiple view files and a model file to handle complex joins and dependencies, successfully delivering the project within the required timeline.

Project Maze
4 Months

• Developed a predictive model to forecast inflection points of new music releases on Spotify.
• Conducted data preprocessing, including cleaning, normalization, and feature engineering.
• Evaluated various algorithms, trained and validated the model, and conducted pilot tests, refining it for accuracy.
• Integrated the model into a production environment, enabling strategic marketing around predicted inflection points.

TikTok Trend Analysis & Revenue Insights
1 Month

• Led trend analysis project to provide insights into music streams, revenue, and song profiles on TikTok.
• Conducted data analysis and created presentations to communicate findings effectively.
• Gathered and cleaned TikTok data, focusing on music trends and user engagement metrics.
• Identified key trends in music streams and correlated them with revenue figures to determine financial impact.
• Utilized Python, Snowflake SQL, PowerPoint, and Looker for data analysis and presentation creation.

Sentiment-Based Genre Classification of Songs
1 Month

• Predicted song genres by analyzing the sentiment of their lyrics.
• Curated a diverse dataset of song lyrics and employed sentiment analysis to capture the emotional content of each word.
• Engineered features based on aggregated sentiment scores, trained multiple classification models to predict genres accurately.
• Developed a user-friendly interface for genre classification, enhancing the music discovery experience.