Rohan Sadnani

Data Analyst

Vodafone Idea•  April 2024 - Present•  Mumbai

By scrutinizing the data into Excel, we were able to identify patterns, trends, and anomalies that were crucial for informed decision-making and this also involves sorting, filtering, and performing complex calculations to extract meaningful insights. • Eliciting and analyzing data using SQL as per the requirement from the stakeholders & managers. • Updating complex excel reports in the marketing team for senior level managers & CMO. • Developed simple Power BI reports in the Marketing Team.

Power Bi Developer/Data Analyst

Grab•  October 2022 - March 2024

Analyze data into a data visualisation platform which is known as Power BI. Developed, identified, designed, built, tested, optimized, and maintained relational Data Models or cubes using advanced DAX, that were scheduled through SSIS and connected live to Power BI: catering to the development of various interactive Dashboards aiding Logistics operations for Reliance Jiomart Pan India. Building cubes in Microsoft SQL Server Management Studio. Created complex, user friendly Dashboards for Business to Business (B2B) and Business to Customer (B2C) verticals of various Line of Business. Using SQL to understand and sort out the data.

Data Analyst

Colgate Palmolive•  December 2021 - June 2022

Was responsible for managing EltaMD project Examine data into a data visualisation platform which is known as Power Bi Built reports and dashboards for business stakeholders, to solve business requirements that are provided by functionals Even built the ETL pipelines in Google Data Fusion for smooth flow of data Even presented my dashboard in front of John Apostolidis, lead for DTC & B2B for EltaMD and CP Skin Health Group