VIGNESH MURUGAN
Business Intelligence Analyst
Chennai
Summary
Prudent Senior Data Analyst with 7.5+ years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings.
Overview
7
7
years of professional experience
5
5
years of post-secondary education
Work History
Senior Data Analyst
Disprz
6 2021 - Current
- Design and implement product usage and developing visual reports, dashboards and KPI scorecards using Power BI desktop in collaboration with the product and engineering teams.
- Develop / code small utilities to aggregate customer usage data into a single unified view.
- Utilize Python for data manipulation, analysis, and visualization.
- Analyst product usage patterns across customers and suggest ways to improve usage.
- Connect to data sources,api, importing data and transforming data for Data Analysis.
- Identified untapped revenue opportunities by conducting thorough market research and competitor analysis using collected datasets using Azure Synapse data warehouse.
Business Intelligence Analyst
Samunnati Financial
01.2019 - 06.2021
- Developed performance dashboard which helped the management and HR team to track the performance of the relationship managers and incentivise business employee accordingly.
- Developed Tele-Calling dashboard to combined three different data points into single point for Tele Calling team to track over due, demand and paid details of clients and avoid clients before getting into over due.
- Developed Projected PAR 90 dashboard which helped the internal stakeholder to make decision before the clients getting into non performing asset.
- Worked on building business metrics like collection efficiency, repayment efficiency with multiple cuts which helped stakeholders in finding the key customers and zones.
- Developed and Maintains the Data Management to process data with help of Azure platform.
- Worked on data presentation to BOD, Internal Stakeholder(SteerCom) and Investors to represent the business numbers.
Business Intelligence Engineer
Aaum Analytics
12.2016 - 01.2019
- Developed and maintains the DATAMART to normalize the data and gathered all the data points into single zone to easily extract the data as mush fast they want from KBT report.
- Query optimization and performance tuning for better performance of sql query in order to reduce the cpu execution memory.
- Developed report format to upload in the data into credit portal like master,amex,visa to get the payment.
- Developed invoice and creditnote report to integrate with the application.
Education
Bachelor of Science - Computer Science
VIT University
Vellore 07.2011 - 05.2014
Master of Computer Applications - Computer Application
VIT University
Chennai 07.2014 - 04.2016
Skills
SQL
Power BI
Python
Excel
EDA
Data Analytics
Azure Synapse
Pyspark
Data Modeling
Azure Data Pipeline
Agile Methodology
Accomplishments
- Appreciated and appraised for creating DATAMART as per the customers specification. Highly appreciated by clients for achieving high accuracy of data.
- Appreciated and appraised for creating CHATBOT using RASA framework as per the Stakeholder specification. Highly appreciated by Business Heads for achieving high accuracy of data.
Timeline
Business Intelligence Analyst
Samunnati Financial
01.2019 - 06.2021
Business Intelligence Engineer
Aaum Analytics
12.2016 - 01.2019
Master of Computer Applications - Computer Application
VIT University
07.2014 - 04.2016
Bachelor of Science - Computer Science
VIT University
07.2011 - 05.2014
Senior Data Analyst
Disprz
6 2021 - Current