Shubham Ghate

Business Analyst

Amravati, Maharashtra, India3 yrs 10 mos experience

Most Likely To Switch

Key Highlights

2+ years of expertise in SQL and Big Data technologies
Developed multiple Power BI dashboards for enhanced insights
Recognized for transforming data into actionable strategies

Stackforce AI infers this person is a Data Analyst with strong expertise in SaaS and Big Data technologies.

Contact

Skills

Core Skills

Data AnalysisData Visualization

Other Skills

Advanced ExcelAirflowAnalytical SkillsAzure Data FactoryAzure Data Lake Storage Gen2Azure SynapseBusiness AnalyticsChatGPTCommunicationData AnalyticsData CleaningData ScienceEngineeringExcelExploratory Data Analysis

About

Results-driven Data Specialist offering 2+ years of expertise in SQL, Advanced Excel, Power BI, Sparksql, Pyspark, Python, and a range of Big Data technologies. Skilled in utilizing ETL tools, Databricks, Tableau, Snowflake, Azure, and Airflow to analyze complex data sets and derive meaningful insights. Recognized for reliability, teamwork, and transforming data into actionable strategies for effective decision-making.

Experience

3 yrs 10 mos

Total Experience

1 yr 3 mos

Average Tenure

1 yr 8 mos

Current Experience

Indium

Data Analyst

Oct 2024 – Present · 1 yr 8 mos · Hyderabad, Telangana, India · Remote

Client : Uber - Data & AI Analytics

Swiggy

2 roles

Business Analyst

Promoted

Apr 2023 – Sep 2024 · 1 yr 5 mos

Payroll: Futurense Technologies
Worked closely with the Marketing Performance & Operations Teams to enhance data-driven strategies, improve process efficiency, and ensure timely completion of tasks within sprint cycles.
Real-time Alerts: Implemented SQL queries and Kafka for live streaming data, achieving a ~70% impact rate with timely notifications on delays.
Query Optimization: Reduced daily workload by ~30 hours by optimizing and scheduling 90+ SQL queries on Airflow.
Power BI Dashboards: Developed and deployed 5+ Power BI dashboards, enhancing business insights and reducing analytical workload.
Root Cause Analysis: Conducted RCAs and Impact Analyses, leveraging data analysis, data analytics, and data visualization. Improved business decisions and strategies related to attrition, retention, and reliability.
Big Data Processing: Applied SparkSQL, PySpark, Python, and Hive on Databricks for efficient data
engineering and analysis.
Achievments :
Received "Special Mentions" for JFM 2024 from the AVP for successfully completing a highly complex
project and deploying an end-to-end Power BI dashboard.

SQLKafkaPower BISparkSQLPySparkPython+2

Management Information System Executive

Oct 2022 – Mar 2023 · 5 mos

Payroll : CIEL HR
SQL (Snowflake) - Writing the Queries, using joins, analytical function, sub queries to access the data from multiple tables. Optimizing SQL queries to reduce run time and increase performance.
Advanced Excel- Uses Pivot Tables, Lookup, Sumif,Index, Match , Power Query and Excel functions to find the appropriate data.
Macros(VBA)- Records the macros when working with the daily data to reduce work time and increase the efficiency (5× more).
Analysis - Presenting the raw data in a standardized format for easy understanding and making decisions right and convenient

SQLAdvanced ExcelVBAData Analysis

Endurance technologies ltd.

Engineer Intern

Jan 2021 – May 2021 · 4 mos · Aurangabad, Maharashtra, India · On-site

1. Analyzed daily production and supply levels to anticipate inventory issues and shortages.
2. Used SAP and Excel to track and record production data for efficient inventory management.
3. Delivered performance updates via PowerPoint to inform decision-making and optimize resources.

SAPExcelPowerPoint