Madhu Kumar Killi

Connecting to data sources, importing data, and transforming data for Business Intelligence through various data sources including SQL Server, Snowflake, Anaplan, Excel & CSV files. Experience of working on hybrid models (in-memory and Direct query). Leveraged Power Query, Power BI, DAX, and SQL to construct dynamic dashboards displaying key business metrics, increasing decision-making efficiency by 35%. Implemented advanced DAX formulas to calculate custom metrics and KPIs, enhancing the analytical capabilities of Power BI reports. Created effective reports using visualizations such as Bar Chart, Clustered Column Chart, Waterfall chart, Tree Map etc,. Scheduled data refresh using Power BI Gateways to keep the dashboards and reports up to date. Excellent hands-on experience in using external tools like Tabular Editor & DAX Studio for creating calculation groups, automating the creation of bulk measures using C# scripts, performance tuning / optimization of Power BI reports. Designed & Implemented the dynamic Row Level Security for clients in accordance with security and access requirements. Experienced in migration of Reports from Power point, Qualtrics & Excel. Implemented the best practices to speed up the data refreshes or load the data model. Experience of working on Power BI reports deployment with CI/CD pipeline using Azure Devops. Provided guidance to the BI developers within the team.

Connecting to data sources, importing data, and transforming data for Business Intelligence through various data sources including SQL Server, Snowflake, Anaplan, Excel & CSV files. Experience of working on hybrid models (in-memory and Direct query). Leveraged Power Query, Power BI, DAX, and SQL to construct dynamic dashboards displaying key business metrics, increasing decision-making efficiency by 35%. Implemented advanced DAX formulas to calculate custom metrics and KPIs, enhancing the analytical capabilities of Power BI reports. Created effective reports using visualizations such as Bar Chart, Clustered Column Chart, Waterfall chart, Tree Map etc,. Scheduled data refresh using Power BI Gateways to keep the dashboards and reports up to date. Excellent hands-on experience in using external tools like Tabular Editor & DAX Studio for creating calculation groups, automating the creation of bulk measures using C# scripts, performance tuning / optimization of Power BI reports. Designed & Implemented the dynamic Row Level Security for clients in accordance with security and access requirements. Experienced in migration of Reports from Powerpoint, Qualtrics & Excel. Implemented the best practices to speed up the data refreshes or load the data model. Experience in Power BI deployment pipelines, Power BI embedded, Rest APIs. Provided guidance to the BI developers within the team.

Generated Standard Reports in COGNOS BI (Portfolio, Valuation by Country, Valuation by Currency.) Compiled & distributed periodic reporting package or preparing customized reporting packages as per client requirements and specifications. Developed, maintained & enhanced the reports created in Cognos & Excel Dashboards. Maintained report specifications and review the same to ensure accuracy and compliance to regulatory reporting policies.

Designed, built and delivered reports required to recognize patterns, trends, associations, and relationships in operational data. Catered to various reporting requirement from Internal IBM Clients on a periodical basis by importing & exporting information from different databases like COGNOS, TM1, HYPERION & EIW(Enterprise Information Warehouse).

Generated Standard Reports in COGNOS BI (Portfolio, Valuation by Country, Valuation by Currency.) Compiled & distributed periodic reporting package or preparing customized reporting packages as per client requirements and specifications. Developed, maintained & enhanced the reports created in Cognos & Excel Dashboards. Maintained report specifications and review the same to ensure accuracy and compliance with regulatory reporting policies.

Designed, built and delivered reports required to recognize patterns, trends, associations, and relationships in operational data. Catering to various reporting requirements from Internal IBM Clients on a periodical basis by importing & exporting information from different databases like COGNOS, TM1, HYPERION & EIW (Enterprise Information Warehouse).

Designed, built and delivered reports required to recognize patterns, trends, associations and relationships in operational data.

Handled credit risk reporting and analysis.