Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Languages
Timeline
Generic

RAJASEKAR S

Chennai

Summary

Data professional and a Power BI Specialist with 12+ years of experience in Banking and Logistics. Creating dashboards, reports, data models, and performance-related outputs. As an expert in business analytics and BI expertise, I am able to map business requirements, convert them into an operational dashboard, and produce effective insights. With skills in data science, I can also perform complex analytics on massive data sets.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Data Analyst - Power BI Specialist

Hyundai Motor India
03.2012 - Current
  • Expertise in preparing MIS reports, SOPs, audit reports, process documents, dashboards, models, KPI reports, business scenarios, prototypes, functional and technical specifications, business reviews, ad hoc reports, and productivity reports
  • Developed a comprehensive Power BI dashboard to visualize sales performance metrics
  • Utilized DAX to calculate key performance indicators (KPIs) and created interactive visualizations to track sales trends, top-performing products, and regional breakdowns
  • Led a team in designing and implementing a Power BI dashboard to optimize supply chain operations
  • Created a data model to integrate data from various sources, including ERP and inventory systems
  • Developed custom DAX measures to calculate lead times, inventory levels, and delivery performance metrics
  • Implemented interactive visualizations to identify bottlenecks and improve decision-making
  • Researched trend of Daily, Weekly and Monthly Inventory Shipment Data
  • Implemented advanced data analysis skills by gathering requirements, filtering, transforming, cleaning, mapping, standardizing and validating data, preparing pivot tables, charts, graphs, reports and so on using analytical tools and presenting statistical findings to clients and senior management for decision-making
  • Creating and developing dashboard for market indicators and team KPIs
  • Excel VBA automation Macros are written for automating manual Excel-related work
  • Extracted and interpreted data patterns to translate findings into actionable outcomes
  • Used business objects, business intelligence, and other reporting tools to extract data from data solutions and data warehouses
  • Analyzed large amounts of data to identify trends and find patterns, signals, and hidden stories within data
  • Leveraged text, charts, and graphs to communicate findings in understandable format
  • Project summary – Around 40+ Dashboards: Customer Satisfaction Dashboard, Marketing Campaign Performance Dashboard, HR Analytics Dashboard, Operational Efficiency Dashboard, Financial Forecasting Dashboard, Supply Chain Optimization Dashboard, Sales Performance Dashboard, Key Performance Indicator (KPI) Dashboard, Interactive Data Visualization, Sales Territory Dashboard, Customer Acquisition Cost Dashboard, Social Media Analytics Dashboard, Inventory Management Dashboard

Junior Logistics Specialist

Maersk
08.2010 - 02.2012
  • Using Agile methodology, execution team reports were automated using formulated Template and Excel VBA, saving 20 FTE tasks
  • Expertise in preparing MIS reports, SOPs, audit reports, process documents, dashboards, models, KPI reports, business scenarios, prototypes, functional and technical specifications, business reviews, ad hoc reports, and productivity reports
  • Developed dashboards in HTML to provide real-time business intelligence insights
  • Developed complex SQL queries to analyze large datasets for trends and insights and obtain complex data from tables in on-site and remote databases
  • Excel VBA automation Macros are written for automating manual Excel-related work

Education

Master of Business Administration - System management

Madras University
01.2015

Bachelor of Arts - Commerce

Gurunanak College
Chennai
01.2010

10th & 12th Standard -

Sri Ahobila math oriental higher secondary school
Chennai

Skills

  • Power BI
  • MS SQL and Databases
  • VBA: Excel Automation
  • Advanced Microsoft Excel
  • DAX: Data Analysis Expressions
  • Power Query
  • Power Pivot
  • Data Visualization
  • Advanced Analytics
  • Database querying
  • Data Modelling
  • Report Automation
  • Dashboard Specialist
  • Data quality
  • SAP module
  • Business intelligence
  • Advanced Excel
  • SQL expertise
  • Advanced analytics
  • ETL processes
  • Dashboard creation

Certification

  • Business Reporting Specialist using Power BI
  • Report Automation Specialist using VBA Programming
  • Data Warehouse ETL specialists using BI & SQL
  • Data Analysis & Dashboard Associate using Power BI
  • VBA Developer
  • MIS Reporting & Business Modeling Specialist using MS-Excel
  • MS Advanced Excel – Associate
  • SAP

Accomplishments

  • Delivered on 30% efficiency and automation of the process which started with 600 members in 4 sites through continuous improvements, power bi deployment and the excel automations.
  • Yearly recognition of Star Award obtained in the year 2021 & 2023
  • Yearly recognition of 100% Attendance award obtained in the year 2021 & 2022

Projects

Customer Satisfaction Dashboard Marketing Campaign Performance Dashboard HR Analytics Dashboard Operational Efficiency Dashboard Financial Forecasting Dashboard Supply Chain Optimization Dashboard Sales Performance Dashboard Key Performance Indicator (KPI) Dashboard Interactive Data Visualization Sales Territory Dashboard Customer Acquisition Cost Dashboard Social Media Analytics Dashboard Inventory Management Dashboard

Languages

  • English, Proficient
  • Tamil, Native
  • Hindi, Basic

Timeline

Senior Data Analyst - Power BI Specialist

Hyundai Motor India
03.2012 - Current

Junior Logistics Specialist

Maersk
08.2010 - 02.2012

Master of Business Administration - System management

Madras University

Bachelor of Arts - Commerce

Gurunanak College

10th & 12th Standard -

Sri Ahobila math oriental higher secondary school

Similar Profiles

CREATE PROFILE
RAJASEKAR S