Shubhang Jain

Data Analyst

Jabalpur, Madhya Pradesh 12+ yrs exp 70 · Very Good

About

Data Analyst with 3+ years of experience in SQL, Power BI and Advanced Excel, delivering data-driven insights and business reporting solutions. Expertise in complex SQL, ETL, data transformation, KPI development and interactive Power BI dashboards for business decision-making. Skilled in translating business requirements into actionable insights, automating reporting and working with cross-functional stakeholders. Brings 9+ years of business ownership experience, combining strong analytical thinking, commercial judgment and stakeholder management.

Skills & Expertise

No skills listed yet

Work Experience

Data Analyst

Yellow Stack Technologies

Apr 2023 - Present

Developed complex SQL queries using joins, CTEs, window functions and CASE logic for data extraction, transformation, validation and ad-hoc analysis. Built and optimized ETL workflows and analytical datasets in Snowflake to support scalable reporting and business analytics. Designed interactive Power BI dashboards and KPI reports to track performance trends, approval rates, delinquency and other business metrics. Performed data cleaning, transformation, validation and exploratory data analysis (EDA) across multiple data sources to improve reporting accuracy. Automated recurring reporting using SQL and Advanced Excel, including PivotTables and advanced formulas reducing manual reporting effort. Collaborated with business stakeholders and cross-functional teams to gather requirements, define KPIs and translate business needs into analytical solutions. Presented analytical findings and maintained reporting documentation and data governance standards to support consistent decision-making.

Owner / Manager

Jain Super Mart

Apr 2014 - Mar 2023

Managed end-to-end retail operations including sales, procurement, inventory, pricing and vendor management, analyzing 5,000+ monthly transactions. Applied sales, demand and inventory analysis to improve purchasing decisions and achieve 15% annual sales growth. Identified slow-moving products and optimized replenishment strategies, reducing inventory waste by 18%.