Summary
Overview
Work History
Education
Skills
Certification
Interests
Timeline
Generic

ALOK RAJ

Data Analyst
Bengaluru,KA

Summary

Diligent Power BI Data Analyst with robust background in data analysis and project leadership. Expertise in data modeling, Automation and insightful reporting that drives business decisions. Demonstrated analytical skills and proficiency in SQL and Python.

Overview

9
9
years of professional experience
33
33
years of post-secondary education
4
4
Certifications
3
3
Languages

Work History

Lead Data Analyst

Ernst & Young (EY)
07.2024 - Current
  • Designed and optimized dashboards in Power BI with bookmarks, drill-through, and paginated reports.
  • Built data models and performed transformations in Power Query.
  • Optimized report performance using Tabular Editor and DAX Studio.
  • Created SQL scripts and stored procedures for backend operations.
  • Collaborated with stakeholders to meet business requirements.
  • Developed custom dashboards in Power BI for real-time tracking of key performance metrics across departments.
  • Managed a team of junior analysts, providing mentorship and ensuring high-quality deliverables.
  • Collaborated with cross-functional teams to develop analytical tools and methodologies for solving complex business problems.
  • Created and automated data visualizations to present insights and tell compelling stories.

Team Lead / Senior Software Engineer

Mindtree
01.2020 - 12.2022
  • I worked on Microsoft's Worldwide Learning LMS project.
  • Set up the Power BI environment and publish dashboards.
  • Handled infrastructure support and resolved global LMS tool issues.
  • Integrated data from multiple systems using Azure Web Services.
  • Provided first-level support and resolved incidents using CRM.
  • Led cross-functional teams for successful project execution while maintaining strong collaboration among team members.

Application Development Analyst / Associate

Accenture
05.2016 - 12.2019
  • Administered Documentum and eRoom platforms.
  • Managed middleware components and ServiceNow incident/change processes.
  • Developed Power BI dashboards for a pharma client.
  • Managed Windows servers, and optimized backend reporting.
  • Worked with SQL for data extraction and transformation.
  • Reduced application errors by conducting thorough testing procedures and promptly addressing issues.
  • Optimized application performance by monitoring system metrics and making necessary adjustments.

Education

MBA - Business Management

NMIMS University
Mumbai, India
04.2001 - 01.2020

Bachelor of Science - Mechanical Engineering (Automobile)

KIIT University
Bhubaneswar
04.2001 - 01.2016

Skills

Reporting Tools: Power BI, Excel, Paginated Reports

Certification

Microsoft Power BI Analyst Associate – PL-300

Interests

Photography

Timeline

Lead Data Analyst

Ernst & Young (EY)
07.2024 - Current

Team Lead / Senior Software Engineer

Mindtree
01.2020 - 12.2022

Application Development Analyst / Associate

Accenture
05.2016 - 12.2019

MBA - Business Management

NMIMS University
04.2001 - 01.2020

Bachelor of Science - Mechanical Engineering (Automobile)

KIIT University
04.2001 - 01.2016
ALOK RAJData Analyst