Headline

Aspiring Data Analyst | SQL · Python · Power BI · Tableau | Cut Reporting Time 30% Across 15K+ Records | Agentic AI & Gen AI

About

I turn raw data into decisions that businesses actually act on. I'm a Computer Science undergraduate (AKTU, 2027) and Data Analyst with 6 months of hands-on internship experience building end-to-end analytical solutions — from writing complex SQL queries and Python ETL pipelines to delivering automated Power BI and Tableau dashboards that cut reporting time by 30% and saved 8+ hours of manual work every month. During my internship at Labmentix Pvt Ltd, I worked across the full data cycle — gathering business requirements, cleaning and transforming 15,000+ transaction records, conducting EDA, performing A/B testing analysis, building DAX-driven data models, and presenting insights directly to senior stakeholders. Every output I delivered had a measurable business outcome attached. What I work with: →Languages: Python (Pandas, NumPy, Scikit-learn) · SQL (CTEs, Window Functions, Aggregations) · MySQL ,PostgreSql → BI & Viz: Power BI (DAX) · Tableau · Excel Dashboards · Looker Studio → Methods: EDA · A/B Testing · Regression · Predictive Modeling · RFM & Cohort Analysis · ETL Pipelines → Tools: Jupyter · Git · GitHub Projects I'm proud of: → Built a fraud detection ML pipeline (XGBoost) achieving 89% accuracy on 12,000+ financial transactions → Designed a Tableau sales dashboard analyzing 20,000+ records with RFM segmentation and automated SQL reporting What I'm building toward: I'm actively learning Agentic AI and Generative AI to automate analytical workflows and integrate LLM-powered tools into data pipelines — because the next generation of data analysts won't just analyze data, they'll build systems that do it intelligently. Certified by Deloitte (Forage) · Oracle Cloud Infrastructure · Currently pursuing Google Data Analytics (Coursera) Open to Data Analyst, Business Analyst, and BI Analyst roles — full-time or internship. 📩yakansha1106@gmail.com

Location

Kanpur

Work experience

Data Analyst at Labmentix Private Limited, Jul 2025 - Jan 2026 · 7 mos, Remote, Full-cycle data analyst role covering SQL querying, Python-based ETL development, BI dashboard delivery, EDA, A/B testing analysis, and stakeholder reporting across business operations data. What I delivered: → Analyzed 15,000+ business transaction records using SQL (CTEs, window functions) and Advanced Excel — identified revenue trends, seasonal anomalies, and data quality issues that improved KPI reporting accuracy for senior management → Built automated Power BI and Excel dashboards tracking 10+ KPIs (revenue growth, conversion rate, churn rate, AOV, customer retention) using DAX data models — reduced manual reporting time by 30% and cut turnaround from 4 hours to under 1 hour → Developed Python (Pandas) ETL pipelines for end-to-end data extraction, cleaning, transformation, and loading — eliminated manual preprocessing errors and ensured reliable, consistent data delivery to all BI workflows → Conducted EDA and A/B testing analysis using hypothesis testing and descriptive statistics across multiple datasets — surfaced statistically significant insights that directly informed operational decisions and process improvements → Automated weekly and monthly reporting pipelines using Python scripting and Excel macros — saved 8+ hours/month of manual effort and ensured consistent, audit-ready delivery of business insights to stakeholders → Gathered and translated business requirements from cross-functional stakeholders into SQL queries, data models, and dashboard specs — working within Agile sprint cycles using JIRA for task management Skills used: SQL · Python · Pandas · Power BI · DAX · Tableau · ETL Pipelines · EDA · A/B Testing · Hypothesis Testing · Data Modeling · Excel · JIRA · Agile · Stakeholder Reporting · Data Storytelling

Education

Bachelor of Technology - BTech, Computer Science & Data Science, PSIT Kanpur (Pranveer Singh Institute of Technology)

Basic school, kendriya vidyalaya