Looking for a job

Amit Kumar

@amitkumar95

Lead Engineer at Kellton building a police department data warehouse and Power BI dashboards.

At Kellton, I designed and developed CPD_MART, a centralized SQL Server data warehouse for a US Police Department, and built more than 10 Power BI dashboards and paginated reports. I also automated refresh monitoring and optimized queries, reducing refresh duration by about 70% and execution times by about 45%.

Previously, I designed Microsoft Fabric analytics solutions at Anderson Global and led Power BI development for a global pharmaceutical client at Tata Consultancy Services. At Celebal Technologies, I led BI developers delivering analytics across insurance, BFSI, retail, and manufacturing, including more than 100 Power BI reports and dashboards.

Experience

Work history, roles, and key accomplishments

Current

Lead Engineer (Data Platform & Analytics)

Current

Kellton

Feb 2026 - Present (7 months)

Designed and developed a centralized SQL Server data warehouse using Kimball star-schema modeling for a US Police Department. Built 10+ Power BI dashboards and paginated reports, configured incremental refresh, and automated dataset refreshes using Power BI REST APIs and PowerShell.

SQL Server Kimball Power BI Paginated Reports On Premises Data Gateway Incremental Refresh Power BI REST API PowerShell T SQL Data Validation Governance

Senior Power BI Developer & Fabric Lead

Anderson Global (Active Bean Counter)

Jun 2025 - Feb 2026 (8 months)

Designed and implemented a Microsoft Fabric Medallion Architecture with ingestion pipelines for Salesforce CRM and tax advisory systems. Built Direct Lake semantic models and Power BI reporting solutions, managed deployment pipelines, and optimized performance.

Microsoft Fabric Medallion Architecture Fabric Data Factory Microsoft Fabric Dataflows Gen2 DirectLake Power BI XMLA Endpoints Tabular Editor ALMToolkit Deployment pipelines Capacity Planning

Power BI Developer (System Engineer)

Tata Consultancy Services

Apr 2024 - Jun 2025 (1 year 2 months)

Led Power BI development for a global pharmaceutical client, designing semantic models, DAX measures, and performance-optimized dashboards. Ingested data from REST/OData APIs using parameterized Power Query and conducted quality checks and performance tuning.

Power BI DAX Power Query REST APIs OData Performance Analyzer Semantic Modeling

Associate BI Consultant (Team Lead)

Celebal Technologies

Oct 2021 - Dec 2023 (2 years 2 months)

Led a team of 5 BI developers delivering cloud analytics for insurance, BFSI, retail, and manufacturing clients. Delivered Power BI Embedded solutions, developed 100+ reports, and managed BI projects end-to-end.

Power BI Power BI Embedded RLS OLS Regression Service Principal T SQL Project Management Pre Sales Salesforce Azure

Business Intelligence Developer

Vaibhav Global Limited

Jan 2020 - Oct 2021 (1 year 9 months)

Designed and developed Power BI reports and dashboards for internal business users across supply chain, inventory, and commercial performance domains. Automated relational refresh scripts and optimized T-SQL reporting views.

Power BI T SQL SQL Server Automation Reporting