• Create reports and dashboards using Microsoft Power BI to give insights to end users.• Develop DAX queries for measures, calculated columns, and calculated tables• Maintain and enhance existing reports and dashboards developed in Microsoft Power BI based on users’ feedback.• Testing and debugging of reports and dashboards.• Create data models and Optimize SQL queries.• Schedule refresh, set up incremental refresh, and create row-level security in Power BI.• Develop ETL solution to Extract, Transform and Load data to data warehouse databases using SSIS.• Publish Power BI Reports in Power BI Service, manage paginated reports, mobile reports, and make Reports & Dashboards available in Web Servers and mobile apps for the end users to have self-service analysis.• Troubleshoot ETL, SQL, and Power BI technical issues/bugs.• Defined the report layout and identified datasets for report generation.• Developed reports using complex T-SQL queries, user-defined functions, stored procedures, and views.• Responsible for documentation.• Provide the status update to the senior management and stakeholders.

• Import data from various sources such as SQL Server DB, Azure SQL DB, CSV File, Excel to Power BI Desktop to generate reports for Business Intelligence.• Developed complex DAX functions in Power BI.• Write Calculated column, Calculated tables and Measures using DAX in Power Bi Desktop useful for the Key Performance Indicators (KPIs).• Create Tabular reports, Matrix reports, Charts, Graphs, and applicable dashboards using Power BI and SSRS to demonstrate KPIs as per business user requirements.• Weekly presentations of reports and status to the business users to get the feedback.• Maintain and modify existing Power BI reports and dashboards based on users’ feedbacks.• Develop ETL solution to Extract, Transform and Load data to data warehouse databases using SSIS.• Create SSIS packages to read data from heterogeneous sources and transform data using transformations, tasks, and containers such as Derived columns, Data Conversion, OLE DB Command, Merge Join, Conditional Split, Look Up, Sort, Union All, Multicast, File System Task, Script Task, SendMail Task, among others.• Publish Power BI Reports in Power BI Service, manage paginated reports, mobile reports and make Reports & Dashboards available in Web Server and mobile apps for the end users to have self-service analysis.• Defined the report layout and identified datasets for the report generation.• Developed reports using complex T-SQL queries, user defined functions, stored procedures, and views.• Involved in Testing and Debugging the Stored Procedures and T-SQL.• Optimized SQL queries for improved Performance and availability.• Used SSRS to generate Sub-Reports, Drilldown, Drill-through, and Parameterized report.• Involved in full System Development Life Cycle (SDLC) including requirement gathering, analysis, design, development, testing and implementation of various medium and large-scale client/server applications in a structured development environment.

• Developed and generated reports for end users, verifying accuracy for all data entry and ensuring consistent procedures were followed.• Created various SSIS packages for data movement and management of historical data from various heterogeneous data sources.• Executed in-depth data validation on data from various stakeholders as well as presented data models to business teams and stakeholders for review.• Facilitated the development of several complex reports and incorporated various formatting techniques like interactive sorting and grouping to create user friendly reports.