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
04.2023 - 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
03.2022 - 04.2023
- 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
03.2020 - 03.2022
- 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
07.2015 - 03.2019
- 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
06.2014 - 07.2015
- 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
06.2013 - 05.2014
- 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
Chennai12-2019
High School Diploma -
Aalim Muhammed Salegh Polytechnic College
Chennai04-2013
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)
04.2023 - Current
Analyst
Lycatel BPO Pvt Ltd
03.2022 - 04.2023
MIS Executive
Hiveloop Technology Pvt Ltd (Udaan)
03.2020 - 03.2022
Fresh Desk Executive–BD Relation
ANI Technologies Pvt Ltd (OLA Cabs), Chennai
07.2015 - 03.2019
Diploma Trainee
Nokia Networks Pvt Ltd, Oragadam
06.2014 - 07.2015
SMT Operator
Nokia Solutions and Network Pvt Ltd, Oragadam
06.2013 - 05.2014
Bachelor of Science - Computer And Information Sciences
University of MADRAS
High School Diploma -
Aalim Muhammed Salegh Polytechnic College
Similar Profiles
Yogesh ChaudharyYogesh Chaudhary
Account Manager - Inside Sales at Bundl Technologies Private Limited - Swiggy DineoutAccount Manager - Inside Sales at Bundl Technologies Private Limited - Swiggy Dineout
Sonal AgarwalSonal Agarwal
Customer Success Manager at Monnai Technology India Private LimitedCustomer Success Manager at Monnai Technology India Private Limited
Swagat RaySwagat Ray
Project Manager Administration at GENESTORE INDIA PRIVATE LIMITEDProject Manager Administration at GENESTORE INDIA PRIVATE LIMITED