Portfolio Loading
Enter the password to view visitor and recruiter activity.
4+ years crafting data-driven solutions with SQL, Python, Power BI & Cloud data platforms.
Focused on ETL/ELT, data governance, data quality & security (RBAC), performance optimization,
and applying AI/ML — from predictive models to Generative & Agentic AI — to turn complex datasets
into strategic insights that drive smarter business decisions.
Microsoft Certified : AZ-900 | PL-300 | DP-600 | DP-700 | DP-800 | AB-100
Ashwik Bire
Data & BI Engineer
Data Analyst and BI & Automation Specialist with 4+ years of experience in data analysis, dashboard development, ETL/ELT pipelines, and reporting automation across OLTP and OLAP environments for enterprise clients. Proficient in SQL (T-SQL), Kusto Query Language (KQL), Python (Pandas, NumPy, Scikit-learn), Power BI, DAX, and TIBCO Spotfire, with hands-on exposure to Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake (ADLS Gen2), and Databricks/Apache Spark.
Actively extending this foundation into Generative AI and Agentic AI — building RAG pipelines, LLM applications, and AI copilots (Claude/GPT API, LangChain) that automate analytical workflows. 6x Microsoft Certified — most recently as an Agentic AI Business Solutions Architect (AB-100) — with a consistent record of data governance, data quality and data security (RBAC) practices, performance optimization, cloud-based data engineering, and replacing manual, error-prone processes with automated, AI/ML-driven solutions.
A working mini Power BI-style report, not a screenshot — filter it and watch the KPIs, charts, and DAX measure recalculate in real time.
Drag to project revenue growth on top of the current filter — KPIs and the trend line recalculate live, like a Power BI What-If parameter.
Click a point to drill into that month · hover for details
Click a bar to cross-filter the dashboard
Sample dataset for demonstration — modeled on the same star-schema approach used in the Sales & Business Performance Dashboard project above.
👈 Swipe to browse projects 👉
No projects match that search — try a different term or clear the filter.
A closer look at how a few of the projects above came together — the problem, the approach, and the outcome.
Raw transactional order data had no single view for leadership — revenue, product performance, and customer segments all lived in separate exports with no way to spot trends or compare periods.
Modeled the dataset in Power BI with a star schema, wrote DAX measures for YoY growth and KPI cards, and used Python for pre-cleaning and segmentation logic before loading it into the report.
Shipped an interactive executive dashboard covering the full order set with drill-down by product, region, and customer segment — turned into a reusable template for future reporting.
Vedic and Western astrology calculations are traditionally split across separate tools with dated interfaces, and neither offers AI-assisted interpretation of the results.
Built a PyQt6 desktop app combining both calculation systems in one place — Panchang, Kundali Milan — and wired in a local Ollama model so interpretations run fully offline.
A single desktop application with a holographic UI that merges traditional astrology logic with local AI, open-sourced on GitHub.
Recruiters manually re-read every resume against a job description, then hand off screener routing and interview scheduling as separate steps — slow and easy to bottleneck.
Built on the Lemma SDK to chain resume ingestion, automated JD fit scoring, screener routing, and interview scheduling into one pipeline instead of four disconnected tools.
An end-to-end AI co-pilot that takes a candidate from resume submission to a scheduled interview without manual hand-offs in between.
👈 Swipe to browse certifications 👉
Research, publications, and interdisciplinary studies exploring technology, AI, engineering, psychology, and human-centered innovation.
Two true stories — one of healing, one of learning to begin again.
Looking to build powerful data solutions or need a skilled analyst? Let's discuss how I can add value to your team.
Paste a job description below and I'll score it against Ashwik's skill set — no waiting on a human to screen it.