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
RDBMS/DBMS: MS SQL Server
ETL Tools: Power Query, Alteryx (Beginner)
Data Modelling: Power Pivot, DAX, Tabular Editor
Optimization Tools: DAX Studio
Ticketing Tools: Dynamic CRM, Service Now, VMC Remedy
Operating Systems: Windows 11, 10, 8, 7
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