Mayuri Kakde
Data Analyst | Power BI Developer | Business Intelligence & Cloud Analytics
Hire this person
Send a job offer directly to this candidate
About
Data Analyst with 2+ years of experience across cloud data engineering, financial reporting, and sales analytics — the throughline being end-to-end ownership: building the pipeline that lands the data, modeling it correctly, and shipping the Power BI dashboard stakeholders actually use. Delivered as an on-site analytics consultant embedded within Cognizant and Tech Mahindra engagements via Code Icons Technology, working directly with client stakeholders on AWS-based ETL pipelines, DAX-driven financial reporting, and multi-region sales analytics at 10M+ record scale.
Experience
Data Analyst at Code Icons Technology (2024-06 – Present)
- Designed and built an end-to-end cloud ETL pipeline on a Bronze-Silver-Gold architecture, processing 500K+ daily records across 15+ tables while enforcing data quality checks at every ingestion, transformation, and cataloging stage.
- Optimized Amazon Athena queries through partitioning, cutting data scan costs by ~40% — an estimated ₹50,000/month in AWS savings.
- Built Power BI dashboards on curated datasets, integrating Python-based anomaly detection to flag unusual business patterns for 30+ stakeholders.
- Configured CloudWatch monitoring and alerting across pipeline stages, sustaining 99.5% uptime and reducing time-to-detect for pipeline failures.
- Built a 6-page interactive financial dashboard used by 50+ finance managers in monthly business reviews, tracking revenue, expenditure, budget utilization, and WIP metrics across business units.
- Automated ETL from SQL Server and Excel via Power Query, cutting 8+ hours of manual effort per reporting cycle.
- Authored advanced DAX time-intelligence measures (YTD, MTD, YoY, SAMEPERIODLASTYEAR) driving Matrix, Funnel, and Pie drill-down views for leadership.
- Implemented Row-Level Security and scheduled Power BI Gateway refreshes, enforcing role-based access to sensitive financial data.
- Delivered an 8-page multi-region sales analytics dashboard with automated daily refresh for 20+ stakeholders, cutting manual reporting time by 60%.
- Built and optimized 20+ DAX measures (YTD, MoM, YoY, RANKX) across 5 regions to support sales strategy and executive decisions.
- Designed a scalable Star Schema model and Power Query ETL processing 10M+ sales records, with validation checks for high reliability.
- Built KPI scorecards and drill-through reports with advanced filtering for real-time tracking of sales goals.
Data Analyst (AWS Cloud Data Pipeline & Business Analytics) at Cognizant (2024-06 – Present)
Data Analyst (Financial Performance Analysis Dashboard) at Cognizant (2024-06 – Present)
Data Analyst (Sales Performance Analysis Dashboard) at Tech Mahindra (2024-06 – Present)
Education
Bachelor of Technology (B.Tech) in Information Technology – GH Raisoni College of Engineering, Nagpur (2023-05)
