Business Analyst | McKinsey & Deloitte Certified | SQL | Advanced Excel | Tableau | Power BI

Bachelor of Commerce - B.Com, Business, Management & Marketing
Swami Sahajanand Snatkottar Mahavidyalaya Ghazipur
Join Jiya and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal BossBusiness Analyst | McKinsey & Deloitte Certified | SQL | Advanced Excel | Tableau | Power BI
I built four analytics dashboards — in Excel, Tableau, Power BI, and SQL — before finishing my degree. Each one started with a real business question: why is attrition spiking, which product categories are bleeding margin, where is revenue concentration risk hiding. I didn't wait for a job to start doing analyst work. Over six months at Analyst Club, I completed 20+ consulting engagements — writing BRDs, SRDs, and FRDs from scratch, sizing markets using top-down and bottom-up modeling, and presenting findings to stakeholders who needed a decision, not a data dump. Selected work: → HR Analytics Dashboard (Excel): processed 1,470 employee records, surfaced a 16.12% attrition rate. → Profitability Dashboard (Tableau): visualized margin data across 15+ categories, 100+ products. → Sales & Performance Dashboard (Power BI): analyzed $9.6M in sales across 7 product lines. → Revenue Analysis (SQL): queried 50,000+ transactional records across 15+ product categories. Certified by McKinsey Forward Program (strategic communication & management consulting) and Deloitte Data Analytics Job Simulation (data analysis & forensic technology). I'm currently looking for a Business Analytics internship ideally at a startup or fast-moving team where I can own the pipeline from raw data to a dashboard that actually changes a decision. If you're hiring for an analyst role and want someone who can write SQL, build stakeholder-ready dashboards, and document the requirements behind both - Email me: jiya48967@gmail.com
Varanasi
Business Analyst Trainee at Analyst Club, Sep 2025 - Feb 2026 · 6 mos, • Extracted actionable business intelligence from 50,000+ transactional records across 4 end-to-end analytics projects (Excel, Tableau, Power BI, SQL) surfacing a 16.12% employee attrition rate, a 39.84% profit margin, and $9.6M in sales performance data to support business planning decisions. • Authored complete business requirement documents (BRDs, SRDs, FRDs) across 20+ real-world consulting engagements using MECE frameworks and SCQA structured top-down analysis, translating stakeholder discovery sessions into structured user stories, process flows, and requirement drafts. • Built and deployed 4 executive dashboards in Tableau and Power BI visualizing margin data across 100+ products and 15+ categories, and tracking KPIs across 106,000+ orders improving profitability decision-making efficiency by 30%.
Bachelor of Commerce - B.Com, Business, Management & Marketing, Swami Sahajanand Snatkottar Mahavidyalaya Ghazipur