Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

MADHAN MOHAN

Bangalore

Summary

Proven data analyst with 5 years of experience in mining, interpreting and presenting large datasets to improve spend efficiency across organizations. Led the implementation of new data analysis system and achieved a 15% reduction in errors and 20% increase in data accuracy. Adept in collaborating with cross-functional teams and delivering projects on-time and on-budget. 9 Year Experience in Reporting and Project Delivery .

Overview

15
15
years of professional experience

Work History

Data Analyst

AP Moller Maersk
Bangalore
08.2023 - 01.2025
  • Developed over 20 operational dashboards, enhancing data visibility, and driving decision-making efficiency by 30%.
  • Facilitated 10+ project transition and service delivery meetings, enhancing collaboration among technical teams, and improving service report strategies by 25%.
  • Responsible for creating and managing insightful internal reports to better inform internal stakeholders about risk profiles and to assist in the business decision-making process, to drive growth, and increase productivity.
  • Streamlined daily reporting process through automation, increasing dashboard updates from weekly to daily intervals.
  • Created data-driven insights for portfolio teams, leading to a 25% increase in project prioritization accuracy.
  • Responsible for generating scheduled daily, weekly, monthly, or ad-hoc service reports, and ensuring they are distributed to the required stakeholders within the agreed schedule(s).
  • Developed a customizable ServiceNow template, enhancing user experience, and increasing adoption rates by 25%.
  • Create the Python script for extracting the data from several data sources.
  • Through Power Automate, extract the data from the source and update it in SharePoint.
  • Automate tasks in the Jira tool for auto-assignment based on severity, and create the insight.
  • Create and manage a Power BI deployment pipeline.
  • The ETL process has been done from different data sources.
  • Analyzed and tracked data to prepare forecasts and identify trends.
  • Maintained or updated business intelligence tools, databases or dashboards.
  • Prepared detailed reports by collecting, analyzing, and summarizing information and trends.
  • Provided technical support for existing reports, dashboards or other tools.

Data Analyst

Huawei Technology
Bangalore
08.2019 - 07.2023
  • Developed a KPI dashboard in Power BI, enhancing visibility and analysis of telecommunications data for 15% faster reporting.
  • Leading the digital transformation of over 50 manual dashboards to automated ones.
  • Develop Power BI reports and effective dashboards after gathering and translating end-user requirements.
  • Data Visualization (Power BI) of Network KPIs for Management Dashboards and Detailed Analysis.
  • Create a live dashboard for the Hajj and Ramadan events to present the live updates of subscribers, traffic, and network utilization.
  • Imported data from multiple data sources into BI tools, created relationships between data, and created calculated columns and measures using DAX query.
  • Proficiency in statistics and statistical packages like Excel and Google Sheets is required for analyzing data sets.
  • Published Power BI reports in the required organizations, and made Power BI dashboards available in web clients and mobile apps.
  • Built automation of data collection from multiple sources to generate unified reports. Database health checks to ensure the integrity of network stats and entities.
  • Having experience in creating different charts, like line charts, bar charts, tables, matrix tables, and area charts.
  • Having experience in creating new measures for YTD, MTD, and QTD growth analysis in Power Desktop.
  • Experience in creating maps, such as filled maps and shape maps, and having experience in using filters, like page, visual, report, and drill-through filters.
  • Create a special event dashboard to closely monitor the major KPIs in the network.
  • Through UiPath Orchestrator, schedule the data extraction and update in the Power BI dashboard at certain intervals.
  • Create DAX queries and generate computed tables to create computed columns in Power BI.
  • Strong stakeholder communications and interpersonal skills (via email, phone, and IM).
  • Create the Working Set and cluster according to the customer requirements and for the special event in the network.
  • Managing ad-hoc customer requests related to report customization and dashboard creation.
  • Through UiPath, automated the data extraction and update in the Power BI dashboard.

Network Performance Analyst

Huawei Technology
Bangalore
04.2013 - 08.2019
  • Lead the reporting team and manage the team
  • Preparing the Governance Report, Management reports, and PPT.
  • Create the Working Set and create the template, busy hour rule, and KPIs in the NetAct, across PM, PRS, U2020.
  • Handling the performance team members.
  • Prepared special event report working set for Ramadan, Hajj, and match event.
  • Share the special event SMS with the stockholders at event time every 2 hours, including major KPIs.
  • As per the requirement, schedule the report and manage the task in the tools NetAct, Across PM, and PRS.
  • Create a report template, as per the new requirements by the stockholders.
  • Checking the performance of network elements after any activity is done.
  • Sharing the contributing site for the degradation after the RFC was completed.
  • Pre-analysis and post-analysis of the network element performance after work order implementation.
  • Create the dashboard with the updated cluster for the event time, and add new KPIs to the dashboard.
  • Automated the 100+ reports with UiPath and VBA.
  • Monitoring the main KPIs that cause degradation in the network.
  • Create the special event dashboard for the stockholders.
  • Create the trouble ticket, and escalate it to the Concern Team.
  • Preparation of SOPs for reports and user guidelines for the tools.
  • Provide training, and assign daily work to team members.
  • Reporting and documentation daily work allocation. Handling monitoring and process improvement.

Network Performance Analyst

Nokia Solutions
08.2012 - 04.2013
  • Preparation of daily and weekly Governance report.
  • Creation of TT during KPI Degradation.
  • Pre Analysis and post Analysis of the Network element performance after Work order Implementation.
  • Preparation of daily and weekly Governance report.
  • Monitoring the Major KPI in the dash board and analysis the cause of the degradation.
  • If any degradation happen in the network we will cross check with other domains.
  • Preparing the Weekly and monthly PPT to the stockholders.
  • Providing the contributing cell for the degradation.
  • Reporting, Analyzing the Capacity and Utilization of all MSC,BSC,SGSN,GGSN& RNC.
  • Creation of TT for the zero call or low cell availability.
  • Closure the TT once issue has been rectified.

Support Engineer

QG Technology
Chennai
05.2010 - 08.2012
  • Collecting the data from the difference source and preparation of the reports.
  • VSS Customer Relation Management tool through the tool we can able to monitor the products sales and the defects etc.
  • Interacted with clients to understand their requirements.
  • Communicated with the clients for issues updates in status call meeting.
  • The report generated based on the department wise and the cost center wise.
  • Two levels of support one is online support and another one is onsite support by the engineers and generate various reports.
  • Creating the trouble ticket for the issue raised.

Education

MCA - Computer Application

Jamal Mohammed College
Trichy
04.2008

Skills

  • Python
  • SQL
  • VBA
  • AWS Basics
  • Uipath
  • Power Automate Power Desktop
  • Power BI
  • Excel
  • Google Sheets
  • Service Now
  • Jira
  • Solarwinds
  • Citrix
  • URAP
  • Across PM
  • U2020
  • I2000
  • PRS

Timeline

Data Analyst

AP Moller Maersk
08.2023 - 01.2025

Data Analyst

Huawei Technology
08.2019 - 07.2023

Network Performance Analyst

Huawei Technology
04.2013 - 08.2019

Network Performance Analyst

Nokia Solutions
08.2012 - 04.2013

Support Engineer

QG Technology
05.2010 - 08.2012

MCA - Computer Application

Jamal Mohammed College

Similar Profiles

CREATE PROFILE
MADHAN MOHAN