Power BI Developer with 4+ years in Business Intelligence solutions
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
BI Developer with 4 years of hands-on experience delivering enterprise Business Intelligence solutions for the US Public Safety sector. Skilled in Power BI, SSAS, SSIS, SQL Server, DAX, and Power Query with a strong track record of building centralized data warehouses, OLAP cubes, and multi-device dashboards for Police and Fire Records Management Systems serving county-level agencies across the United States. Cut ETL load times by 40%, grew report adoption among 200+ users by 30%, and sustained 99% pipeline accuracy. Awarded Quarterly Best Performer at ProPhoenix Consultancy Services.
AKT Memorial College of Engineering, Anna University
B. E · Mechanical Engineering
N/A – Present
Shanmuga Industries Government Higher Secondary School
HSC · Higher Secondary Certificate
N/A – Present
Government High School
SSLC · Secondary School Certificate
N/A – Present
ProPhoenix Consultancy Services Pvt. Ltd.
Software Engineer - BI Developer
June 1, 2022 – Present
Chennai, Tamil Nadu, India
Police RMS & EZ Fire Records - Public Safety BI Platform
June 1, 2022 – Present
Architected a Police Data Warehouse comprising 15 data marts using ER Studio, supporting 8+ analytical reporting workloads and serving as the single source of truth for county-level incident forecasting. Delivered 15 SSAS OLAP cubes for Police RMS and 10 cubes for Fire/NFIRS, each with KPIs, partitions, usage-based aggregations, and designation-based role-level security. Constructed two SSIS packages to handle full initial data load and daily incremental ETL from OLTP to Data Warehouse, using Data Conversion, Derived Column, Lookup, and SCD transformations. Tuned SSIS packages following Microsoft best practices, reducing the nightly DW load window by over 35%; scheduled via SQL Agent Jobs with Package Configurations for zero-touch automation. Implemented SQL Data Mining models for incident forecasting, projecting crime and fire trends up to 6 months ahead to support proactive law enforcement planning. Established database indexes, maintenance plans, and automated backup strategies covering 15+ OLTP, DW, and OLAP databases to guarantee high availability and recoverability.
Power BI Multi-Device Dashboard Platform - Public Safety
June 1, 2022 – Present
Installed and configured Power BI Report Server on SQL Server 2016 Enterprise Edition, enabling fully on-premises publishing and eliminating cloud licensing costs for the client. Designed interactive drill-through dashboards for incident analytics, enabling one-click navigation from summary KPIs to individual records — used by 150+ officers and department heads. Optimized 10+ report layouts for cross-device compatibility across tablets, iPhones, Android devices, and Windows, ensuring consistent access for both field personnel and leadership. Integrated datasets with SSAS cubes and SQL Server, ensuring data consistency and real-time accuracy for all report consumers across Police and Fire command structures.
Quarterly Best Performer at ProPhoenix Consultancy Services for outstanding contribution to BI development and delivery.
ProPhoenix Consultancy Services
June 1, 2026 – Present
Runner-up in Chess and Carrom Competition at ProPhoenix Annual Day.
ProPhoenix Annual Day
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's experience in public safety projects demonstrates a focus on impactful, mission-critical applications. The certifications, though not strictly technical, indicate engagement within their current company. The breadth of skills across data warehousing, ETL, and reporting tools suggests adaptability and a willingness to tackle diverse technical challenges, which aligns well with a dynamic team environment.
Soft Skills & Operational Fit
The candidate's experience includes leading Agile Scrum ceremonies and producing comprehensive documentation, indicating strong organizational, leadership, and communication skills. The ability to streamline processes and improve team collaboration suggests a good operational fit for roles requiring structured development and clear communication.