Still Struggling with Tech Hiring? Discover Olibr's Solution Now!
Login / RegisterDeveloperClient
Login/Register

PRANAY GIRDE

Support analyst

  • MAHARASHTRA, MH
  • 3 years
Notice Period: Available

    Candidate's About

    Data analyst with a Master's in data science and expertise in SQL, Power BI, Tableau, and Azure. Proven track record of generating actionable insights, collaborating on diverse projects, and leveraging cutting-edge technologies for impactful results. A data-driven approach driving significant impact on organizations success.

    Work & Experience

    D

    Data Analyst

    Mar 23 - PRESENT

    Technology

    • Icon
      Data Visualization
    • Icon
      SQL (Advance)
    • Icon
      Excel
    • Icon
      Python
    • Icon
      Machine Learning
    • Icon
      Tableau

    Tools

    • Icon
      Github
    • Used Power BI to create dynamic dashboards, leading to a 20% increase in stakeholder engagement and improved business outcomes.
    • Implemented Power Automate workflows, achieving 30% operational efficiency increase and streamlining processes with less manual effort. 
    S

    Support analyst

    Mar 22 - Jan 23

    Technology

    • Icon
      SQL (Advance)
    • Icon
      Statistics
    • Icon
      Excel
    1. Develop VBA macros to automate manual tasks and increase efficiency in e-commerce operations. 
    2. Maintain a central order matrix and record orders in Excel as per e-commerce SOPs. 
    3. Collaborate with the Ecommerce Supervisor and Senior Team leader of Operations to identify process improvements and streamline operations. 
    4. Work as part of a team to ensure t...
    Read More

    Automating E-commerce Order Processing using VBA Macros

    Support analyst

    Responsibilities: 

    1. Analyze current e-commerce order processing procedures and identify areas for improvement. 

    2. Develop VBA macros to automate manual tasks such as updating order status, generating shipping labels, and sending confirmation emails to customers. 

    3. Build a central order matrix in Excel to record and track orders according to e-commerce SOPs.

     Output: 

    The output of this project will be an automated e-commerce order processing system that increases efficiency, reduces manual errors, and ensures timely order processing and shipment. The system will be built using VBA macros in Excel and will include a central order matrix that records and tracks orders according to e-commerce SOPs. The project will help Whole Foods Market streamline their e-commerce operations and provide a better experience to their customers.

    • SQL
    • Macro
    • Microsoft Excel
    View Details
    D

    Data Analyst

    Jan 20 - Sep 21

    Technology

    • Icon
      Python
    • Icon
      Power BI
    • Icon
      Kafka
    • Icon
      SQL (Advance)
    • Icon
      Data Visualization
    • Icon
      Apache Spark
    • Icon
      Problem Solving
    • Icon
      Tableau
    • Icon
      Excel

    Tools

    • Icon
      Microsoft-Azure
    • Icon
      Visual-Studio
    • Icon
      Jira
    1. Collect, clean, and manipulate large data sets using SQL and Python, ensuring data accuracy and integrity for reporting and analysis. 
    2. Create data visualizations and reports using tools such as PowerBI, Tableau, and Qlik 
    3. Use data wrangling techniques to ensure data quality and consistency, and apply NLP and geo-coding techniques to transform unstructured data int...
    Read More

    Analysis of Loan Disbursement Trends for RBI

    Data Analyst

    Responsibilities:

     1. Collect, analyze and clean loan disbursement data using SQL and Excel 

    2. Create a report summarizing the loan disbursement trends, highlighting any key insights or findings. Provide recommendations based on the analysis and predictive models developed. Ensure that the report is clear, concise, and visually appealing. 

    3. Conduct statistical analysis using Python to identify factors influencing loan disbursement 

    4. Prepare a clear and concise report with recommendations 

    Output:

     A PowerBi dashboard showcasing loan disbursement trends and a report with insights and recommendations.

    • SQL
    • Python
    • PowerBi
    • Azure databricks
    • Azure Datafactory
    View Details

    Education

    K

    Masters in Data Science

    Kingston University
    2023 - 2023
    Y

    Bachelor of Engineering in Computer

    Yeshwantrao Chavan College of Engineering
    2015 - 2019

    Certificates

    I

    Introduction to Spark SQL and DataFrames

    I

    Databases and SQL for Data Science

    IBM
    I

    Open Source Tool for Data Science

    IBM
    B

    Building Interactive dashboard

    I

    What is Data Science

    IBM
    F

    Full Professional Proficiency

    Achievements

    • Tasks Collect, clean, and manipulate large data sets using SQL and Python, ensuring data accuracy and integrity for use in reporting and analysis. Create data visualizations and reports using tools such as PowerBI, Tableau, and Qlik Use data wrangling techniques to ensure data quality and consistency, and apply NLP and geo-coding techniques to transform unstructured data into structured...