Abhinaya Murugesan
Singapore
Summary
Experienced Senior Business Intelligence Analyst with 8+ years of expertise using SQL, Tableau, Power BI, SSRS Report Builder, and Python to extract insights from raw data. Proficient in business intelligence and data engineering across Retail, Finance, Healthcare, and Digital Marketing sectors. Skilled at translating complex data into practical solutions, bridging technical analysis with strategic business needs for high-quality outcomes.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Business Intelligence Consultant
Rackspace Techology
08.2019 - Current
- Company Overview: Data driven consulting firm that utilises business intelligence and machine learning to empower business users
- Developed Tableau dashboards for new cost allocation methodology to assign direct and indirect costs to various business units of a banking client successfully delivering end to end industrial build of dashboards.
- Led a team of 15+ in a fast-paced migration project and delivered over 300 Power BI reports for healthcare client while addressing design changes and performance to ensure seamless transition into new reporting tool for customer.
- Point of contact with stakeholders for migration planning, delivery and issue-handling.
- Created complex logics in Tableau prep flow to be consumed by Tableau workbooks.
- Designed a consolidated data modelling solution for optimization of service capacity
- Created KPIs using DAX functions for effective visualization in Power BI and utilized performance analyser and DAX Studio to optimise dashboard performance for bank client.
- Built data models based on star/snowflake schema and created compelling visuals in Power BI.
- Performed data reconciliation between database and reports in SQL.
- Conducted workshops to capture business requirements and design an ETL solution .
- Created ETL pipelines to ingest and transform data using Microsoft Azure Data Factory.
Data Analytics Engineer
MSI Global Pte Ltd
08.2018 - 07.2019
- Company Overview: Commercial arm of LTA whose expertise lies in Automatic Fare Collection and Ticketing Systems and Transport Planning
- Standardized gate health monitoring by creating dashboards in Tableau and PowerBI and automated the monitoring process by integrating with servers resulting in 40% reduction in time invested on report generation
- Created an algorithm in python to detect multiple fare card usage by commuters with the objective of accounting for the anomalous transactions.
- Created an alert mechanism in python to detect any anomaly in gate usage that enables the maintenance team to proactively monitor gate throughput.
- Involved in the prediction of missing entry and exit locations, using spss modeler, that enables LTA to provide more accurate fare calculation.
- Built a scoring model to detect anomaly in commuter pattern using Rstudio.
Data Science Intern
TABSQUARE
08.2017 - 05.2018
- Company Overview: Leverages technology to provide next generation e-menu solutions enabling restaurants to take data-driven decisions
- Analyzed category level transactional data of restaurant products by performing data visualisation in Tableau for category penetration, category placement and item level analysis including item adoption and best sellers
- Performed Market Basket Analysis for cross sell opportunities and identified optimal pricing points for fast moving products.
- Used SQL to pull data and Automated cross sell algorithm, best sellers algorithm and item adoption algorithm in Rstudio saving 50% of analysis time
- Combined all algorithms created into a single platform in R shiny to enable access of algorithm to multiple users.
- Analyzed customer feedback data in RStudio by using n-grams and pos tags to form wordclouds, and positive and negative dictionaries to form sentiment distribution charts.
Management Trainee
ARAM REALTY PVT LTD
02.2016 - 11.2016
- Company Overview: Company is involved in property development, construction of buildings and housing and realestate
- Collected and compared competitor data to derive pricing strategy for project.
- Collected data on demography, purchasing capacity of individuals and locational advantages to decide product mix.
Catalog Associate - Performance Evaluation: Rated as ‘Exceeded Expectation’
AMAZON DEVELOPMENT CENTRE
07.2014 - 01.2016
- Performed time and motion study on team to reduce unnecessary steps and improve production goals. Production target was increased by 10 % upon project completion.
- Worked with the Onshore team to standardize the SOP to reduces inventory checks. It saved 5% of cost and 10 % of time at the warehouse centers.
- Executed a vendor compliance project aimed at reducing the inflow of tickets to associates. This will be done by modifying the SOP and training the warehouse associates to adopt the modified SOP.
Education
Master of Technology - Enterprise Business Analytics
National University of Singapore
07.2018
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration
05.2016
Bachelor of Technology - Industrial Biotechnology
Anna University
Chennai India05.2014
Skills
- Reporting Tools
- Tableau
- PowerBI
- Power BI Report Builder (SSRS Reports)
- SPSS Modeler
- Languages
- SQL
- Python
- ETL Tools
- Azure Data Factory
- AWS Glue
- DBT
Certification
- Microsoft Certified- Fabric Analytics Engineer Associate [DP-600]
- Microsoft Certified: Fabric Data Engineer Associate [DP-700]
- AWS Certified Data Engineer-Associate [DEA-C01].
ADDITIONAL (SKILLS AND AWARDS)
- Certificate: Microsoft Certified- Fabric Analytics Engineer Associate [DP-600], Microsoft Certified: Fabric Data Engineer Associate [DP-700], AWS Certified Data Engineer-Associate [DEA-C01].
- Awards: First amongst Equals Award – Amazon [2015]; Extra Mile Award - Amazon [2016]
- Work Authorization: Indian (Citizen), Singapore(Work Permit)
Timeline
Senior Business Intelligence Consultant
Rackspace Techology
08.2019 - Current
Data Analytics Engineer
MSI Global Pte Ltd
08.2018 - 07.2019
Data Science Intern
TABSQUARE
08.2017 - 05.2018
Management Trainee
ARAM REALTY PVT LTD
02.2016 - 11.2016
Catalog Associate - Performance Evaluation: Rated as ‘Exceeded Expectation’
AMAZON DEVELOPMENT CENTRE
07.2014 - 01.2016
Executive Diploma - Supply Chain Management
Loyola Institute of Business Administration
Master of Technology - Enterprise Business Analytics
National University of Singapore
Bachelor of Technology - Industrial Biotechnology
Anna University
Similar Profiles
TZU CHIEH PANTZU CHIEH PAN
Process Engineer at Powertech Techology Inc.Process Engineer at Powertech Techology Inc.
SUHE YUSUHE YU
Intern Sectary Assistant at Xinda Eletronic Techology Co, Ltd.Intern Sectary Assistant at Xinda Eletronic Techology Co, Ltd.
Fiona XIEFiona XIE
Financial Accountant at MEIFAN TECHOLOGY AUSTRALIA PTY LTDFinancial Accountant at MEIFAN TECHOLOGY AUSTRALIA PTY LTD
Goolnora ArslanovaGoolnora Arslanova
KYC Analyst at Crédit Agricole CIBKYC Analyst at Crédit Agricole CIB
Eugene TeeEugene Tee
Business Sales and Service Manager at Standard Chartered BankBusiness Sales and Service Manager at Standard Chartered Bank