Summary
Overview
Work History
Skills
Projects
Education
Disclaimer
Languages
Timeline
Hi, I’m

Sanyogita Mahajan

Data Analyst
Gurgaon,Haryana
Sanyogita Mahajan

Summary

Data Analyst with 2.5 years of experience specializing in transforming complex data into actionable insights.

Proficient in SQL, Advanced Excel, and Power BI, with a strong understanding of Python. Demonstrated ability to

leverage analytical skills to support decision-making processes, streamline operations, and drive business growth.

Adept at data visualization, statistical analysis, and creating comprehensive reports. Excellent problem-solving skills and a keen attention to detail, ensuring data accuracy and integrity.

Overview

3
years of professional experience
5
years of post-secondary education

Work History

Clarksons Limited
Gurgaon , Haryana

Data Analyst
03.2023 - Current

Job overview

  • Extracted the raw data using complex SQL queries aligned with the business requirements and transformed the data into the reporting dataset for further analysis.
  • Carried out the most part of ETL process at source level using SQL queries and some at Power Query using functions, parameters etc.
  • Developed the sustainable and scalable data model as per the requirement for the transformed dataset.
  • Written complex DAX functions to carried out informative analysis from the data and create actionable insights.
  • Developed Power BI dashboards to track and visualize shipping KPIs, providing real-time insights to stakeholders and reducing reporting time by 25%.
  • Collaborated with logistics and operations teams to understand requirements and deliver customized Power BI reports, enhancing visibility into supply chain performance.
  • Owned the report publishing, RLS implementation for the developed reports at the Power BI service (Saas).

Morningstar
Mumbai , Maharashtra

Data Analyst
01.2022 - 03.2023

Job overview

  • Designed and developed dynamic Power BI dashboards, providing actionable insights and supporting data-driven decision-making for various business units.
  • Utilized Advanced Excel functions, including VLOOKUP, INDEX-MATCH, and pivot tables, to analyze and visualize complex datasets, improving reporting accuracy by 30%.
  • Automated routine data processing tasks in Excel using macros and VBA, reducing manual effort and increasing efficiency by 25%.
  • Conducted comprehensive data analysis using Power BI to identify key performance indicators (KPIs) and trends, enhancing business strategy formulation.
  • Integrated multiple data sources into Power BI, creating unified dashboards that streamlined data access and improved cross-departmental collaboration.
  • Created detailed Power BI reports and presentations for executive leadership, effectively communicating data insights and business performance.
  • Handled the Power BI report publishing and RLS implementation to the power bi workspace

Skills

  • SQL Server (SSMS)
  • Azure Synapse Analytics
  • Power BI Power Query (ETL)
  • Power BI Desktop
  • Data Modelling
  • DAX Queries
  • Power BI Services Platform
  • Power BI Reporting
  • Power BI Dashboards
  • Power BI Apps
  • RLS (DRLS and Embedded)
  • Power BI Dataflow
  • Deployment Pipelines
  • Technical Documentation
  • Macros and VBA
  • Lookup Functions
  • MIS Reporting
  • DAX Studio
  • Tabular Editor

Projects

Projects

Project 1: Asset Usage Report, Portfolio Activity and Project Management Reports

Developed and deployed embedded reports of the user usage and activities within active state of subscriptions of clients to the subscription system platform which can be accessible by stakeholder to review and track the business activities. 

Project 2: Watkins Wellness Freight and Sales Analysis

Logistic Watkins Wellness (Freight Analysis and Sales Analysis), Developed fresh business-oriented Power BI Reports, Power BI Dashboards, Paginated Report and Power BI Apps for the TRUCK and TRAX logistic systems generated logistic data, stored at Azure Synapse. Developed Optimized Report and Model for sales data with historical insights as well as the forecasted insights using AI techniques in Power BI.

Project 3: HR Aggregated Report

This report displays a traditional online, dynamic aggregate report. This report will allow group to see the results for participants that have completed assess competencies to the internal and client admin.

Education

University of Mumbai
Mumbai

MBA from Operations Management
08.2020 - 06.2022

University Overview

University of Pune
Pune

Bachelor Of Engineering from Electrical Engineering
08.2016 - 07.2019

University Overview

Disclaimer

Disclaimer

I hereby declare that the details and information given above are complete and true to the best of my knowledge.

Languages

English
Proficient
C2
Hindi
Proficient
C2

Timeline

Data Analyst
Clarksons Limited
03.2023 - Current
Data Analyst
Morningstar
01.2022 - 03.2023
University of Mumbai
MBA from Operations Management
08.2020 - 06.2022
University of Pune
Bachelor Of Engineering from Electrical Engineering
08.2016 - 07.2019

Similar Profiles

  • KOJO HASTINGS

    KOJO HASTINGSKOJO HASTINGS

    CEO at Genelec Capital Limited, Genelec Support Services Limited•Genelec Infrastructure Development Services Limited•Zenith Hygiene Systems Ghana LimitedCEO at Genelec Capital Limited, Genelec Support Services Limited•Genelec Infrastructure Development Services Limited•Zenith Hygiene Systems Ghana Limited

    View Profile
  • Mayank Pareek

    Mayank PareekMayank Pareek

    Sap Hana Module User, Oracle ERP User at Adarsh Marketing, Asian Paints Limited ,Berger Paints India Limited, JSW Paints Private LimitedSap Hana Module User, Oracle ERP User at Adarsh Marketing, Asian Paints Limited ,Berger Paints India Limited, JSW Paints Private Limited

    View Profile
  • Mukesh Verma

    Mukesh VermaMukesh Verma

    Dy. Manager (Mechanical) at Utility Powertech Limited (A Joint Venture of NTPC Limited &Reliance Infrastructure Limited)Dy. Manager (Mechanical) at Utility Powertech Limited (A Joint Venture of NTPC Limited &Reliance Infrastructure Limited)

    View Profile
Sanyogita MahajanData Analyst