Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic
Rishav Chatterjee

Rishav Chatterjee

Kolkata

Summary

Dynamic Assistant Manager at PricewaterhouseCoopers having over 6 and a half years of experience with expertise in Power BI, SQL, and Python, driving a 30% increase in operational efficiency through data transformations and innovative dashboard design. Proven ability to mentor teams and optimize project management processes, ensuring high-quality execution and resource utilization. Skilled in leveraging data analytics to enhance decision-making and client outcomes.

Overview

7
7
years of professional experience

Work History

Assistant Manager

Pricewaterhousecoopers
Kolkata
06.2023 - Current
  • Lead the development of advanced Power BI reports, utilizing complex DAX functions to create interactive dashboards that drive client decision-making, saving up to.pto 20% business hours on a daily basis.
  • Craft intricate SQL queries to analyze large datasets, addressing specific client inquiries and optimizing data retrieval processes and reduced query run time by 25%.
  • Manage project timelines and maintain team performance metrics, ensuring high-quality execution of tasks while adhering to deadlines.
  • Mentor new recruits on essential tools such as Power BI and SQL, fostering a collaborative team environment and enhancing overall skill levels.
  • Streamlined project management processes using Azure DevOps, resulting in a resource utilization rate exceeding 95% and significantly improved workload distribution.
  • Optimized existing dashboards to enhance usability and performance, achieving a 30% increase in operational efficiency through innovative design and functionality.

Senior Consultant

Pricewaterhousecoopers
Kolkata
06.2022 - 06.2023
  • Transformed large-scale databases utilizing SQL, effectively employing joins, window functions, and Common Table Expressions (CTEs) to derive deeper insights.
  • Developed a project-specific SQL library to store reusable queries, improving team efficiency and reducing repetitive coding tasks.
  • Leveraged advanced DAX functions and Power Query in Power BI to create sophisticated visualizations, cutting down report development time by 40%.
  • Executed various machine learning models in Python, including Regression and Random Forest algorithms, achieving an accuracy rate of 88% for predictive analyses.
  • Designed complex dashboards with Advanced Excel and VBA, while using Alteryx to automate workflows, resulting in a 25% reduction in report generation time.
  • Ensured compliance with multi-level row-level security in Power BI reports, safeguarding sensitive client data while delivering insightful analysis.

Associate Consultant

IQVIA
Bengaluru
02.2021 - 06.2022
  • Developed innovative automated solutions and Proof of Concepts (POCs) tailored for prominent healthcare clients using Power BI, VBA, Python, and PySpark.
  • Implemented data visualization solutions that effectively addressed client needs, leading to a 20% increase in regional sales for healthcare products.
  • Analyzed large healthcare datasets using Python, creating personalized measures and comprehensive analytics to support strategic decisions and improved operational efficiency by 25%.

Research Associate

Nielsen
Kolkata
08.2018 - 02.2021
  • Enhanced data analytics capabilities by integrating customized in-house BI tools with robust software applications, including Advanced Excel and Power BI.
  • Analyzed client specifications to determine relevant KPIs, addressing specific business challenges and providing actionable recommendations.
  • Generated detailed reports and visualizations covering value, volume, price, and distribution analyses using Advanced Excel and Power BI.
  • Automated the generation of reports and dashboards using VBA, reducing development and refresh time by 50%.
  • Implemented Nielsen CPS and RMS metrics alongside IRI-based measurements to provide comprehensive insights based on Point of Sales data.

Education

PGDM Business Analytics -

IISWBM
2018

M.sc Mathematics -

University of Calcutta
2017

B.sc Mathematics (Hons) -

University of Calcutta
2015

Skills

  • MS SQL Server
  • Power BI
  • Advanced Excel
  • VBA
  • Python
  • Alteryx
  • Azure DevOps
  • Nielsen Answers Desktop
  • SAS
  • Basics of Power Apps and Power Automate
  • Microsoft Fabric (DP-600 certified)
  • Project management

Accomplishments

  • Awarded the Simply Excellent Silver Award (2019) for exceptional performance in delivering a high-stakes report for a leading Italian coffee company under tight deadlines.
  • Recognized for initiating a Quality Control System in Nielsen (GRC), significantly improving the efficiency of the report delivery process.
  • Received the Guru-Cool Award for successfully mentoring new recruits, facilitating their adaptation to in-house tools, and supporting project completion.
  • Designated as the Single Point of Contact (SPOC) for multiple premium clients in Nielsen GRC, enhancing client relations and service delivery.
  • Honored with the IQVIA Ovation Award for creating an interactive multi-country Power BI dashboard for clients in Western Europe.
  • Achieved top performance ratings at PwC, receiving multiple recognitions from a major Australian retail client for a successful remediation project.
  • Successfully secured a contract renewal with an Australian client for 3 years, resulting in cost savings of 2.5 business hours per day by identifying and reducing overpayments.

Timeline

Assistant Manager

Pricewaterhousecoopers
06.2023 - Current

Senior Consultant

Pricewaterhousecoopers
06.2022 - 06.2023

Associate Consultant

IQVIA
02.2021 - 06.2022

Research Associate

Nielsen
08.2018 - 02.2021

PGDM Business Analytics -

IISWBM

M.sc Mathematics -

University of Calcutta

B.sc Mathematics (Hons) -

University of Calcutta

Similar Profiles

CREATE PROFILE
Rishav Chatterjee