Kalyan K

Business Intelligence Analyst

• Generated PowerBI dashboards with advanced page/global filters, parameters and calculated fields that allowed tracking projected KPI for product performance, and customer interactions.
• Creating a re-usable Data Models for reusability and to implement the single version of truth.
• Experience in migrating the Excel reports into Power BI Solution.
• Experience in data cleansing using Power Query (M-Code) and transforming the data to fit for the reporting structure.
• Experience in writing or enhancing the M-code by creating functions for reusability.
• Creating different reports like Summary Reports, detailed reports like Drill-through, Drill-down and dynamic Page navigation reports.
• Creating complex DAX Measures, Calculated Columns and Calculated Tables.
• Creating reports with bookmarks, page navigation and dynamically hiding visuals for better user visual experience.

• Collaborated closely with internal stakeholders to gather information related to production problems, projects, or user queries.
• Responded to specific BI requests from business development personnel, creating reports with requested information in easily understandable formats.
• Perform end to end analysis of Data using various tools and technologies.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration.
• Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data. 
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analysed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Programming tasks- Advance Dynamic SQL, Stored Procedures, Indexed Views, Functions and CTEs using T-SQL.
• Responsible for creating Company core business KPIs and Executive Dashboards for board members by just not showing the numbers but making a Data Story about it.
• Creating Technical Documentation and providing Power BI training to users for creating their own dashboards in Power BI Service.
• Experience in using external tools like DAX Studio, Tabular Editor, ALM Tool kit and Bravo.