Hi, I'm Madhukumar Gowroju
Results-driven Data Analyst and Power BI Developer with 4+ years of experience at Tata Consultancy Services. Specializing in building high-performance dashboards, complex DAX calculations, data modeling, and SQL optimization. Passionate about transforming raw data into actionable business intelligence that drives strategic decision-making.
About Me
Who I Am
Results-driven Data Analyst and Power BI Developer with 4+ years of experience at Tata Consultancy Services. Specializing in building high-performance dashboards, complex DAX calculations, data modeling, and SQL optimization. Passionate about transforming raw data into actionable business intelligence that drives strategic decision-making.
Data Analyst | Power BI Developer
Tata Consultancy Services (TCS)| May 2022 - Present
- Delivered 30% improvement in report performance by optimizing Power BI data models, reducing unnecessary columns, and improving query efficiency.
- Accelerated dashboard refresh times by 50% by converting complex manual Excel/SQL reporting into optimized SQL queries and Power BI transformations.
- Reduced manual reporting effort by 30% by implementing automated Power BI datasets, scheduled refresh, and reusable report templates.
Work Experience
Data Analyst | Power BI Developer
Tata Consultancy Services (TCS)
Delivered 30% improvement in report performance by optimizing Power BI data models, reducing unnecessary columns, and improving query efficiency.
Accelerated dashboard refresh times by 50% by converting complex manual Excel/SQL reporting into optimized SQL queries and Power BI transformations.
Reduced manual reporting effort by 30% by implementing automated Power BI datasets, scheduled refresh, and reusable report templates.
Improved data availability and business reporting speed by 25% by building real-time/near real-time reporting pipelines using SQL and Power BI refresh automation.
Automated KPI monitoring and report distribution using Power BI Service eliminating manual checks and saving over 5 hours per week.
Technical Skills
Featured Projects
- Connected Power BI to multiple data sources such as SQL databases, Excel, and flat files for real-time and scheduled reporting.
- Performed data transformation and cleaning using Power Query (M language) to prepare structured datasets for analysis.
- Created advanced calculations using DAX including measures for KPIs, time intelligence, and aggregations.
- Built business KPIs like SLA, Orders, Customer churn rate, ARPU and visualizations like bar charts, line graphs, slicers, and drill-through reports.
- Implemented row-level security (RLS) to restrict data access based on user roles.
- Optimized report performance by reducing data load, using proper data types, and minimizing unnecessary visuals.
- Published and shared reports via Power BI Service, enabling collaboration and scheduled data refresh.
Certifications & Achievements
Certifications
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Validated expertise in Power BI data modeling, visualization, and analytics.
Microsoft Certified: Azure Data Fundamentals
Microsoft
Foundation-level understanding of core data concepts and Azure data services.
Key Achievements
Education
Bachelor of Technology in Mechanical Engineering
GEC - JNTUK
Get In Touch
Let's Connect
Have a project, collaboration idea, or just want to say hi? Reach out!