Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shanmugam N

Chennai

Summary

As an analyst, I am passionate about leveraging data to drive business insights and improve decision-making. With expertise in data cleaning, data analysis, and data visualization, I am skilled in transforming complex data sets into clear and actionable insights. I am well-versed in tools such as Google Data Studio, Microsoft Excel, Data Visualization, Data Analytics, and SQL concepts (MySQL, MS Access, MS SQL Server, and Snowflake data platform). I am constantly seeking opportunities to expand my skill set and stay up-to-date with the latest trends and technologies in the field. I am excited about the potential of data to transform industries and look forward to leveraging my skills to drive impact and achieve results.

Overview

11
11
years of professional experience

Work History

MIS Executive

Bundl Technologies Private Limited (Swiggy)
Chennai
2023.04 - Current
  • Determined data retention parameters based on organizational requirements
  • Created and maintained a report which has more than 70+ metrics and 10+ different data tables, which help AM's to handle RX partners performance and growth planning
  • Supporting account managers to find potential revenue making opportunity from brands and identifying brand's business exponential growth in different cities trend
  • Analyzing historical data for a new project and making a report to track the progress of project
  • Maintaining and publishing 20+ reports on daily basis & 10+ reports for SAM brands and base metrics of city on weekly metrics

Analyst

Lycatel BPO Pvt Ltd
Chennai
2022.03 - 2023.04
  • Day on day report preparation and invoicing for online sales of 5 different gateways & 18 countries
  • Daily sales and payment information from gateways are maintaining in MS-access
  • Developing and maintaining macros in access and excel to reduce the work load & time consuming
  • Resolving consumer escalations like undercharge, overcharge and sale missing cases for online sales

MIS Executive

Hiveloop Technology Pvt Ltd (Udaan)
Chennai
2020.03 - 2022.03
  • Prepared monthly, weekly & daily MIS reports of Staples & FMCG product sales and inventory for two T-1 Cities and four T-2 cities from TN&AP-Telangana
  • Prepared monthly, weekly & daily targets and achievement reports for Sales officers
  • Sharing the analyzed reports to Cluster Head & City & Demand Heads& TL’s(Hub reports on City)
  • Responsible for data analysis & report generation for daily, weekly & monthly as per Adhoc request
  • MIS Development, implemented advanced business performance metrics trackers and dashboards(on Looker), created and updated processes using My SQL querying concepts

Fresh Desk Executive–BD Relation

ANI Technologies Pvt Ltd (OLA Cabs), Chennai
2015.07 - 2019.03
  • Prepared Monthly, Weekly & Daily MIS reports of walk-in
  • Prepared performance report for Walk in executives
  • Prepared accounts standard procedures for vendor billing & payments & generate the report
  • Calculating and processing incentive and payouts by solving queries raised by customers
  • Creating and solving the Freshdesk and Zendesk ticket
  • Creating follow-ups for major, critical accounting issues and assigning follow up calls to tele callers.

Diploma Trainee

Nokia Networks Pvt Ltd, Oragadam
2014.06 - 2015.07
  • Planning and executing of shift production
  • Calculating materials consuming for current production projects
  • Preparing materials and SMT line for trial products
  • Maintaining material feeders
  • End to end maintenance of SMT line as weekly, monthly and yearly.

SMT Operator

Nokia Solutions and Network Pvt Ltd, Oragadam
2013.06 - 2014.05
  • Components feeding in Fuji NXT machines
  • Paste printing on PCB boards
  • Visual inspection of component mounted PCB’s.

Education

Bachelor of Science - Computer And Information Sciences

University of MADRAS
Chennai
2019-12

High School Diploma -

Aalim Muhammed Salegh Polytechnic College
Chennai
2013-04

Skills

  • Data cleaning
  • Data analysis
  • Data visualization
  • Microsoft Excel
  • Data Visualization
  • Data Analytics
  • SQL concepts
  • MySQL
  • MS Access
  • Snowflake data platform

Timeline

MIS Executive

Bundl Technologies Private Limited (Swiggy)
2023.04 - Current

Analyst

Lycatel BPO Pvt Ltd
2022.03 - 2023.04

MIS Executive

Hiveloop Technology Pvt Ltd (Udaan)
2020.03 - 2022.03

Fresh Desk Executive–BD Relation

ANI Technologies Pvt Ltd (OLA Cabs), Chennai
2015.07 - 2019.03

Diploma Trainee

Nokia Networks Pvt Ltd, Oragadam
2014.06 - 2015.07

SMT Operator

Nokia Solutions and Network Pvt Ltd, Oragadam
2013.06 - 2014.05

Bachelor of Science - Computer And Information Sciences

University of MADRAS

High School Diploma -

Aalim Muhammed Salegh Polytechnic College
Shanmugam N