Pralhad Ayachit

Software Engineer

Bengaluru, Karnataka, India7 yrs 2 mos experience

Key Highlights

  • Expert in end-to-end BI solutions with Power BI.
  • Proven track record in data governance and quality frameworks.
  • Strong collaboration skills with stakeholders for KPI definition.
Stackforce AI infers this person is a Business Intelligence and Data Engineering expert in the Fintech sector.

Contact

Skills

Core Skills

Business IntelligenceData Engineering

Other Skills

Power BIPower PlatformSpark-SQLMicrosoft FabricData FactoryDataflowDAXGitData QualityPower AutomateSQLAdvanced ExcelManagementLeadershipPublic Speaking

About

Results-driven Analytics Engineer with over 6 years of expertise in Business Intelligence and Data Engineering. Expert in designing and deploying end-to-end BI solutions, from data integration, data modelling, to interactive dashboard creation in Power BI. Proficient in Python for automating data workflows, SQL for complex data manipulation, and implementing robust data governance and quality frameworks. Proven ability to collaborate with stakeholders to define KPIs and deliver scalable, actionable reports. Experienced with cloud data platforms like Azure Business Intelligence: Power BI (DAX, Power Query, M-Language, TMDL, Power BI Services), Tableau Data Modelling: Star/Snowflake Schema, Semantic Model, Performance Tuning Data Integration & Prep: Microsoft Fabric, Data Factory, Dataflow Gen 2, Dataiku, GCP BigQuery (foundational knowledge) Languages: Python (Pandas, Numpy), SQL (T-SQL, Spark SQL) Microsoft Power Platform: Power Apps, Power Automate Tools & Methodologies: GIT, Azure DevOps, Agile/Scrum, DAX Studio, Measure Killer Certifications - Microsoft Certified Fabric Data Engineer (DP-700) Associate Microsoft Certified Fabric Analytics Engineer (DP-600) Associate Microsoft Certified Power BI Data Analyst (PL-300) Associate

Experience

7 yrs 2 mos
Total Experience
2 yrs 4 mos
Average Tenure
2 mos
Current Experience

Blackline

Senior Software Engineer

Feb 2026Present · 2 mos · Bangalore Urban, Karnataka, India · Hybrid

Kpmg india

Senior Business Intelligence Consultant

Dec 2023Feb 2026 · 2 yrs 2 mos · Bengaluru, Karnataka, India · On-site

  • Designed and implemented a complete real-time fraud risk management solution using Power BI and Power Platform suite, resulting in approximately 40% decrease in manual efforts and cost
  • Developed a consumption layer using Spark-SQL to streamline data management in Databricks and Azure SQL tables
  • Orchestrated seamless end-to-end ETL processes in Microsoft Fabric using data factory and dataflow, resulting in 95% reduction in data errors and 50% improvement in data quality
  • Led performance improvement and resource optimization initiatives resulting in approximately 40% reduction in report refresh time, fabric capacity utilization, development efforts, visual loading time and significant improvement in DAX query performance
  • Developed a custom network graph visualization to detect collusion and visualize complex relationships between entities, significantly enhancing fraud detection capabilities
  • Developed a robust data quality framework, complemented with real-time email alert mechanism, helping data owners to monitor, control and minimize discrepancies
  • Implemented version control in Power BI by integrating Git, enabling seamless team collaboration, reducing deployment time by 30%, and ensuring consistent report versioning across development and production environments
Power BIPower PlatformSpark-SQLMicrosoft FabricData FactoryDataflow+4

Harman international

Power BI Consultant

Sep 2022Dec 2023 · 1 yr 3 mos · Pune, Maharashtra, India · Hybrid

  • Strategized and developed a Power Platform solution to monitor and control critical KPIs, resulting in a 30% reduction in production cycle time and operational cost
  • Built a scalable RLS automation framework that dynamically generates DAX filters and TMDL code from metadata, streamlining security role deployment across enterprise data models and reduce deployment time and effort by 80%
  • Enhanced user engagement and report interactivity in Power BI by implementing advanced features such as visual personalization, field parameters, and parameter binding, resulting in more dynamic and responsive dashboards
  • Developed advanced DAX measures in Power BI to perform statistical and time series analysis, enabling
  • predictive analysis and improving financial forecasting accuracy by 25%
  • Designed and implemented automated workflows using complex stored procedures and PowerAutomate flows
  • Designed and implemented a streaming semantic model for real-time data analysis in Power BI
  • Automated user management in Power BI using Power Automate flows for adding users to the workspace and assigning roles
Power BIPower PlatformDAXPower AutomateBusiness IntelligenceData Engineering

Tata consultancy services

Data Analyst

Jan 2018Aug 2021 · 3 yrs 7 mos · Pune Area, India

  • Developed interactive executive level reports and dashboards in Power BI enabling 10% faster decision making through real-time analytics
  • Designed and implemented data models in Power BI using both Star Schema and one-big table approaches, enhancing data query performance and reporting
  • Optimized Power BI report refresh performance by leveraging the XMLA endpoint to selectively refresh specific tables, reducing data load time and improving overall efficiency
  • Optimized performance in SQL with indexes and partitioning
Power BISQLData Engineering

Education

Sant Gadge Baba Amravati University, Amravati

Bachelor’s Degree — Electronics & Telecommunication Engineering

Jan 2013Jan 2017

Stackforce found 100+ more professionals with Business Intelligence & Data Engineering

Explore similar profiles based on matching skills and experience