ASHWINI RAUT
Power BI & Python Developer
About
Detail-oriented and solution-driven Power BI & Python Developer with 2.8 years of experience building automated data solutions and developing interactive Power BI dashboards. Skilled in data modeling, DAX, ETL pipelines, and integrating Power BI with PostgreSQL to deliver accurate, insightful, and business-ready analytics. Proven ability to collaborate with cross-functional teams and produce clear technical documentation.
Skills & Expertise (15)
Work Experience
Power BI & Python Developer
AIT Global India
Jul 2023 - Present
Developed ETL pipelines using Python to extract, transform, and load data from three distinct sources (meter, inverter, and site-level) into the database. Ensured data quality and accuracy through validation and cleansing techniques using Python scripting and libraries. Designed and developed interactive Power BI dashboards to visualize daily, monthly, and yearly solar production metrics. Integrated multiple data sources into a unified Power BI data model and implemented DAX measures for KPIs: total generation, corrected energy, performance ratio (PR), and device-level efficiency. Created automated data refresh schedules connected to the ETL pipeline for seamless, up-to-date reporting in Power BI. Built drill-through and drill-down reports for granular analysis of site, device, and day-level energy data. Integrated Power BI dashboards directly with PostgreSQL for real-time data retrieval and optimized SQL queries for fast performance. Optimized Power BI model performance using star schema design, calculated tables, and query reduction techniques. Collaborated with stakeholders to gather reporting requirements and translate them into actionable Power BI dashboards.
Power BI Developer
AIT Global India
Jul 2023 - Present
Designed and developed interactive dashboards for HR and IT Support Departments, integrating multiple data sources into a unified Power BI data model. Built drill-down, drill-through, and role-based access dashboards for management, HR executives, and IT support teams. Created custom KPIs such as employee headcount, attrition rate, leave utilization, ticket resolution time, and SLA compliance. Collaborated with HR and IT stakeholders to gather requirements and translate them into meaningful visual insights. Developed reusable templates, measures, and standardized reporting structures for consistency across departments. Ensured data accuracy and consistency through data validation, cleansing, and transformation using Power Query and DAX. Provided documentation and user training to ensure smooth adoption of dashboards and analytics tools.
Power Automate Developer
AIT Global India
Jul 2023 - Present
Engineered end-to-end invoice processing automation for a Healthcare client using Power Automate Cloud Flow and AI Builder to extract invoice data with high accuracy. Implemented AI Builder Document Processing within Power Automate to automate structured data extraction from healthcare invoices, eliminating manual data entry. Built Desktop Flows using Power Automate Desktop for web automation, navigating healthcare portals, scraping data, and submitting forms automatically. Automated Excel operations using Power Automate Desktop Flow to read, write, and update Excel reports with extracted invoice and operational data. Extracted and processed data from PDF documents using AI Builder and Power Automate, storing structured output into SharePoint lists for centralized tracking. Integrated Cloud Flow and Desktop Flow with SharePoint as the central data connector, automating file triggers, document uploads, and notifications. Monitored, maintained, and optimized Power Automate flows, troubleshooting failures to ensure high reliability of automated healthcare data pipelines.
Education
Master of Science - Kolhapur University
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Depends on Offer
Skills (15)
Click a skill to find developers with the same skill
