Power BI Developer with 4+ years in Business Intelligence & Data Analytics
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Power BI Developer with 4+ years of experience in Business Intelligence, data analytics, dashboard development, and SQL development. Skilled in Power BI Desktop, Power BI Service, DAX, Power Query, data modelling, and ETL processes. At Venky's India, delivered enterprise inventory and batch operations dashboards covering 100+ active operations - reducing dashboard refresh time by 35% and cutting manual reporting effort by 60%. Proven ability to design star schema data models, write optimised SQL queries, and translate complex business requirements into actionable Power BI reports and KPI dashboards.
YCMOU University
Bachelor of Arts · Psychology
August 1, 2018 – June 30, 2018
Venky's India Private Ltd
Power BI Developer
July 1, 2024 – Present
Pune, Maharashtra, India
Code Red Software Private Ltd
Associate Software Engineer (Power BI Developer)
February 1, 2022 – July 1, 2024
Pune, Maharashtra, India
Inventory & Stock Valuation Dashboard
July 1, 2024 – Present
Reduced dashboard refresh time by 35% and eliminated 60% of manual inventory reporting through Power BI automation, query folding, and optimised SQL using CTEs, joins, and aggregations. Implemented incremental refresh policies for large fact tables; restructured source queries to push transformation logic to SQL Server, reducing Power BI in-memory load. Engineered advanced DAX measures for opening/closing stock, inventory aging buckets, stock valuation, and max-date logic — including time-intelligence measures for period-over-period comparisons and dynamic rank-based SKU analysis. Defined relationships, cardinality, and cross-filter directions across a star schema (1 fact + 6 dimension tables) to ensure correct DAX evaluation context across all visuals. Built drill-through reports for warehouse-wise and product-wise inventory analysis with conditional formatting for instant anomaly detection; reduced stock investigation time from hours to minutes. Performed end-to-end data validation and reconciliation against ERP source systems, including a dedicated dashboard validation page showing row-level reconciliation between Power BI totals and source exports.
Batch Operations Performance Dashboard
July 1, 2024 – Present
Automated operational reports across 100+ live production batches, reducing manual tracking effort by 50% by replacing daily spreadsheet compilation with scheduled Power BI refreshes and threshold-based alert visuals. Developed DAX measures for FCR, mortality %, feed cost per kg, and production efficiency KPIs parameterised by batch age for fair like-for-like comparison; variance measures (actual vs. standard) automatically flagged underperforming batches. Built parameter-driven scatter charts with configurable management threshold lines, segmenting 100+ batches into performance tiers at a glance. Integrated five operational data sources (feed records, weighment logs, mortality registers, batch schedules, cost tables) into a unified Power BI model using Power Query; resolved data quality issues including duplicates, missing batch IDs, and date inconsistencies. Designed standard-vs.-actual comparative dashboards with conditional colour coding and a batch ranking page — enabling management to identify underperforming batches in under 30 seconds.
Cultural Fit Analysis
The candidate's experience across two companies, including a current role at a large Indian company (Venky's India Private Ltd) and a previous role at a software firm (Code Red Software Private Ltd), indicates adaptability to different organizational cultures. Their project diversity, ranging from inventory and batch operations to sales analytics, shows a broad application of Power BI skills. The transition into Business Intelligence and data analytics from a Psychology background in 2022 suggests a proactive learning attitude and a drive for career change, which can be a positive cultural indicator. The 'Best Employee of the Month' award further highlights a commitment to excellence.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills through their ability to optimize queries and dashboard performance, resolve data quality issues, and implement complex DAX logic. Their experience in collaborating with stakeholders for UAT sign-off indicates good communication and teamwork. The projects highlight a results-oriented approach, focusing on reducing manual effort and improving reporting efficiency.