Shubham Ghate Email & Phone Number

Amravati, Mh, In

Bengaluru, Karnataka, India

•Utilized Snowflake for data warehousing and analytics, ensuring efficient data management.•Applied SQL skills to extract, manipulate, and analyze data from various relational databases.•Leveraged Databricks for big data processing, data engineering, and data science tasks.•Implemented job scheduling automation for SQL queries using Airflow, improving workflow efficiency.In my role as a Business Analyst, I have successfully leverage these skills to drive data-driven insights and support informed decision-making processes.

Bengaluru, Karnataka, India

•Executed an end-to-end Big Data project focused on Stock Market Analysis.•Constructed data pipelines employing Sqoop and MySQL JDBC connectors.•Utilized the powerful capabilities of Hive, PySpark, Spark SQL, and Spark Streaming for comprehensive data analysis.•Extracted valuable insights from the analysis.•Proficient in SQL as a powerful tool for managing and querying relational databases working with aggregate functions, subqueries, window functions, CTEs.•Optimizing SQL queries to reduce run time and increase performance using Indexing, Store procedure & functions.

Kolkata, West Bengal, India

•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

•Data Analysis - Identifying, analyzing, and interpreting trends or patterns in complex data sets to extract key insights that support decision making•Proficiently employing SQL and Python to handle data analysis tasks.•Adept at visualizing results through Tableau to present findings effectively.

Aurangabad, Maharashtra, India

Analyzed daily production and supply levels to anticipate inventory problems and shortages and record production.