Prathamesh Kakade

Experience

• 

  Careerraiser.in

  Jun 2020 - Jun 2021

  Data Analyst

  • Built multiple Power BI dashboards to visualize data related to bill generation, sales, revenue, issue resolution, and warehousing, leading to a 15% improvement in overall comprehension within the company. • Forecasted sales and revenue trends over the past six years, providing crucial insights for strategic decision-making. • Integrated data from diverse sources into PostgreSQL and implemented a thorough data cleaning process using SQL queries and Python, resulting in a 20% reduction in data processing time. • Attended regular training sessions with employees on Power BI usage, contributing to a 30% increase in user proficiency. Show less

• 

  C5i

  Oct 2021 - Apr 2022

  Data Analyst

  •Developed Power BI visual reports from the ground up, utilizing advanced functions and table expertise, optimizing joins, sub-queries, and data blending processes, resulting in a 30% reduction in manual workload.•Coordinated with clients to define KPIs, revamped reports and dashboards for robust business monitoring.•Extracted data from diverse sources and crafted visually appealing, optimized dashboards customized to meet specific requirements, facilitating 20% quicker comprehension for stakeholders.•Demonstrated quality assurance, and debugging complex SQL queries for optimization, saving 10% processing time.•Conducted rigorous data quality checks, resulting in a 25% improvement in data accuracy.•Ensured all customer requirements were accomplished with 90% precision along with maintaining documentations. Show less

• 

  UB Campus Dining & Shops

  Sept 2022 - Dec 2022

  Student Employee
• 

  University at Buffalo

  Dec 2022 - Dec 2023

  Student Library Assistant

  • Collected information from UB Libraries' weekly survey report and employed Power Query Editor to cleanse data, producing pertinent insights for weekly activity strategizing. • Utilized Integrated Library System (ILS) to fulfil student requests through efficient book scanning, software system management, and streamlined book lending processes. • Assisted to an average of 1000 patrons daily, offering reference support to librarians and directions as needed. • Collaborated with a team of 5 colleagues to coordinate and host weekly library activities, fostering a positive and engaging environment. Show less

• 

  Follett

  May 2023 - Jun 2023

  Seasonal Retail Sales Associate
• 

  Sightline Payments

  Apr 2024 - now

  Analyst, Finance & Analytics