Talk to sales Try for Free
Mayank Trehan

Mayank Trehan

Data Analyst

Followers of Mayank Trehan1000 followers
location of Mayank TrehanDelhi, India

Connect with Mayank Trehan to Send Message

Connect

Connect with Mayank Trehan to Send Message

Connect

  • Timeline

  • About me

    Assistant Manager at KPMG Global Delivery Network | PMO | Financial Dashboards & Reports | Data Visualisation Consultant | Forecasting | Operational Reporting | Project Management

  • Education

    • Manav Sthali School

      1998 - 2012
      Management Business/Commerce, General

    • Manav Sthali School - India

      -
      Finance and Financial Management Services

    • Symbiosis Institute of Management Studies

      2013 - 2016
      Bachelors Finance and Financial Management Services

  • Experience

    • BMR Advisors

      May 2016 - Jun 2017
      Data Analyst

      Service Line: Risk & AdvisoryKey Role: Senior Data Analyst: May 2106 - June 2017Collecting, collating and carrying out complex data analysis in support of management & customer requests also involved in reporting statistical findings to senior managers.Developing process automation and worked on various analytical solutions using BI Tools for process automation and reporting for large Multinationals.Expertise in providing Impact and Risk Analysis across industries like manufacturing, Banking, Insurance etc Show less

    • Aon

      Jun 2017 - Jan 2019
      Data Analyst

      Service Line: Engagement & ConsultingKey Role: Data Analyst: June 2017 - 25 January 2019Manipulating, cleansing & processing data using Excel, Access.Responsible for loading, extracting and validation of client data.Analysing raw data, drawing conclusions & developing recommendations.Developing data analytical databases from complex financial source data.Carrying out specified data processing and statistical techniques.Supplying qualitative and quantitative data to colleagues & clients.Using TABLEAU, EXCEL, and ACCESS & Power BI to extract, transform & load source data from transaction systems.Working with leaders and consultants to provided end to end business solutions. Show less

    • EXL

      Jan 2019 - Oct 2020
      Business Analyst

      Service Line: ITKey Role: Tableau Developer - 28 January 2019 - PresentBuiling dashboards for onshore clients using Tableau or Power BI and Excel techniques for Business Impact Analysis, Risk assessment, Business forecasting.Providing in – depth analysis and develop BI Reports as per requirements.Currently working as an individual contributor and representing EXL to onshore clients for projects related to the US Healthcare industry.Core responsibilities include gathering requirements, understanding business objective, defining a required data structure and then building dashboards as per client requirements.Presenting completed projects after delivery to the client site. Show less

    • Verisk

      Oct 2020 - May 2021
      Business Analyst

    • KPMG

      May 2021 - now

      • Assistant Manager

        Sept 2023 - now

      • BI Consultant

        May 2021 - Sept 2023

  • Licenses & Certifications

    • Project Management Foundations

      LinkedIn
      Jun 2024
      View certificate certificate

    • Copilot for Project Management: Build an AI-Powered Budget Tracker and Forecaster (No Code Required)

      LinkedIn
      Jun 2025
      View certificate certificate

  • Honors & Awards

    • Awarded to Mayank Trehan
      Process Genius Onshore Stake Holder October 1, 2020 Recognised as Process Genius for seamless and error free delivery of dashboards for clients resulting in client appreciation.