A Kumar Email & Phone Number

Lead SQL/BI Developer with over 16 years of expertise in Data Engineering, Conversion Analysis, and Business Intelligence Development.Proficient in a diverse array of technologies including SQL Server, SSIS, SSRS, Power BI, Microsoft Azure, Conversion tools, and more.Leverages Power BI to design and develop interactive dashboards and reports, providing real-time insights to stakeholders.Demonstrates proficiency in C# programming, consistently delivering high-quality, maintainable code.Deep expertise in database design encompassing normalization, selective de-normalization, as well as conceptual, logical, and physical data modeling utilizing Erwin. Developed and maintained high-quality database solutions using MS SQL Server for both on-premise and Azure cloud environments.Currently managing database solutions with a focus on Azure Databricks, leveraging its capabilities for big data processing and analytics.Demonstrated strong SQL Server development skills, including logical and physical data modeling and design.Created effective reporting deliverables using SQL Server procedures, tailored to business needs.Experienced in integrating C# applications with various databases including SQL Server, MySQL, and PostgreSQL.Expert in implementing partitioning strategies to optimize database performance, utilizing techniques such as range, list, and hash partitioning.Utilizes Power BI’s advanced features, such as DAX and Power Query, to create complex data models and visualizations.Profound in developing OLAP cubes to facilitate multidimensional data analysis and reporting for business users.Monitored and maintained system health, security, and performance during data access operations, safeguarding database integrity.Provided technical support and problem resolution, addressing database-related issues efficiently and effectively.Monitored and managed SQL Server database