Status: 🟢 Available for Projects & Roles
"Data is the new oil, but like oil, it must be refined to be valuable." – Peter Sondergaard
Hi there! I'm Avinash Rai, a results-oriented SQL Developer & Data Analyst with a passion for transforming raw data into actionable insights. From building robust ETL pipelines to designing impactful dashboards and automating workflows — I specialize in creating scalable, data-driven solutions that help organizations make smarter decisions.
💼 I have hands-on experience working with tools like Snowflake, Power BI, Python, SQL Server, and Alteryx, delivering solutions across domains including finance, manufacturing, HR, and healthcare.
I'm a strong believer in automation, clean design, and reproducible analytics. I enjoy building modular pipelines, interactive dashboards, and efficient SQL logic that not only solve today's problems — but are future-proof and maintainable.
- 🔄 Designing automated ETL workflows (SQL, Snowflake, Alteryx)
- 📊 Creating KPI dashboards in Power BI, Tableau, and Streamlit
- 🧹 Data cleaning, transformation, and modeling using Python (Pandas, NumPy)
- ☁️ Cloud-based data operations using AWS S3, GitHub, Streamlit Cloud
- ⚡ SQL query optimization for scalable, real-time analytics
🚀 Currently upskilling in DBT, Azure Data Factory, and Matillion for advanced data engineering workflows.
🧩 Outside of data, I'm passionate about understanding systems — from backend infrastructure to business process design. Great analytics start with asking the right questions.
📫 Feel free to connect or collaborate — I’m open to freelance roles, projects, or just a good data chat!
Snowflake • MySQL • SQL Server • Stored Procedures • Joins & Views • Query Optimization • RDBMS
SQL-based ETL • Alteryx • Snowpipe • Excel VBA • Power Query • Task Automation • Data Cleaning
Power BI (DAX, Power Query) • Tableau • Streamlit • Excel (PivotTables, Charts) • KPI Dashboards
Python (Pandas, NumPy, Scikit-learn, Regex) • Git • Jupyter Notebook
AWS (S3) • Snowflake Cloud Platform • Streamlit Cloud • GitHub
Logistic Regression • Forecasting • Sentiment Analysis (VADER) • Feature Engineering
DBT (Data Build Tool) • Azure Data Factory • Matillion
Click to Expand Full Project List 📁
- Snowflake DW with S3 + Power BI
- Automated ingestion, star schema, 8+ tables
- Real-time NLP sentiment using VADER
- 15K+ tweets, deployed with Streamlit
- Fraud detection & user behavior insight
- Query optimization and advanced joins
- Classification ML model with feature engineering
- Evaluated risk bands & accuracy
- CSV to MySQL to Power BI full-stack
- Provider Scorecard & KPI dashboards
- BI dashboards in Tableau & Power BI
- Efficiency tracking and visualization
- Historical naming trends using Matplotlib & Seaborn
- Scikit-learn ML model for customer churn
- Airline ticket forecasting using regression
"Without data, you're just another person with an opinion." – W. Edwards Deming