Ajinkya Raut

Detail-oriented and results-driven Data Analytics Professional with 5.5 years of experience in analyzing large datasets, engineering automated pipelines, and developing scalable Business Intelligence (BI) solutions. Technical expert across the Microsoft BI ecosystem and cloud data architectures, specializing in transforming complex business rules into high-performing enterprise dashboards that optimize marketing campaigns and operational workflows.

Power BI Developer / Data Analyst - Pearlstone Technology - Pune, India

(2020-12)

• Designed, developed, and deployed enterprise-grade Power BI dashboards and executive KPI scorecards to monitor multi-channel marketing performance and customer engagement metrics in real time.
• Modeled high-performance, scalable semantic data layers using Star Schema and Snowflake Schema dimensional modelling techniques, minimizing storage bottlenecks and dashboard latency.
• Authored optimized, complex SQL scripts leveraging multi-table joins, Common Table Expressions (CTEs), nested subqueries, and stored procedures to orchestrate rapid data extraction from Snowflake cloud data warehouses.
• Engineered end-to-end data transformation workflows via Power Query, incorporating advanced data cleansing, schema definition, and validation rules to ensure data integrity.
• Configured automated workspace deployment and scheduled dataset refreshes on Power BI Service, empowering cross-functional business units with live operational insights.
• Performed deep-dive root cause analysis and exploratory data analysis (EDA) on granular customer conversion data to help marketing stakeholders optimize ad spend and campaign targeting.
• Leveraged Advanced Excel (VLOOKUP, INDEX MATCH, Pivot Tables, logical formulas) to execute financial modeling, budget forecasting, and ad-hoc analytics for business leadership.
• Conceptualized and engineered an end-to-end operations dashboard architecture tracking critical business delivery metrics including Average Handle Time (AHT), First Call Resolution (FCR), and SLA compliance.
• Built production-ready ETL ingestion pipelines within Power Query to extract, parse, and clean unstructured data from internal production SQL databases and flat file streams.
• Formulated advanced DAX calculations (including Time Intelligence functions, dynamic rankings, and conditional target tracking percentages) to unlock complex matrix reporting.
• Architected advanced front-end capabilities using drill-through parameters, custom tooltips, bookmarks, and parameters to deliver an intuitive user experience from macro site performance to micro-agent evaluations.
• Established secure data governance best practices, including Row-Level Security (RLS) configurations, to safely publish and distribute automated analytics reports on Power BI Service.
• Championed the reduction of administrative reporting overhead and boosted client SLA compliance by arming operations leadership with real-time operational visibility.

Bachelor of Engineering - B.E. - Jawaharlal Darda Institute of Engineering and Technology (JDIET) (2016 - 2019)