Rahul P Puranik

Experience

• 

  Gutsy Innovation

  Jul 2018 - Nov 2019

  Data Analyst
• 

  Tesco Bengaluru

  Dec 2019 - Jun 2022

  Data Reporting Analyst

  · Analyzed the daily, weekly and yearly data of the distribution depots and stores and gave a detailed distribution of each depot.· Managing the retail operational reporting requirements for company’s distribution portfolio for Central Europe and UK.· Created Reporting Tools using VBA and Power query which help in reducing manually intervention and helped save time up to 10hrs per week and also preventing from wrong data reporting.· Created interactive dashboards in excel, Power BI and Tableau as per the stakeholders. · Modeled data to generate reports with appropriate KPIs based on stakeholder requirements.· Reduced reporting time and errors by automating reports and also helped in migrating from excel based database to Microsoft server studio.· Co-ordinated with various teams on several process improvement projects with my data analysis and problem solving skills. · Transformed automation platforms from VBA to Power Query for 6 projects· Migrated data from legacy system (excel spreadsheets, text files) to SQL server database using SSIS.· Improved excel template size from 3MB each to 90kb thus improving the speed and efficiencies of the macros. Show less

• 

  Nuance Communications

  Jun 2022 - Aug 2023

  Business Intelligence Analyst
• 

  Microsoft

  Aug 2023 - now

  Business Intelligence Analyst