I am a Business Intelligence professional. I have worked with Mortgage Industry, and currently working with a consulting firm. I have gained significant amount of experience working with Colaberry Inc. using SQL, ETL, SSIS, and Microsoft Power BI tools, Agile methodology (Software Development Life Cycle), collaborating with Scrum masters, Product owners, developers and testers, participated in sprint planning as well as sprint review and daily scrum meetings. I use DAX to create calculated columns and measures to enable me manipulate data into beautiful visualization and reports. Possess strong leadership and communication skills from working directly with senior managers.
Power Bi Developer
March 2018 - Present
Extracted data multiple Sources (Files and folders, SQL server Databases, Power Platform, Other Databases, online services, and other Websites), transformed the data and Loaded into the tables using power query and Imports.
• Performed data modelling using Power Pivot. Set up table relationships and created Star Schema in Power BI.
• Created Interactive Visuals and Reports using slicers, drill down, drill -through and tooltips for both Mobile Views and desktop View in Power BI Desktop.
• Built Power BI reports and dashboards to report Key Performance Indicators (KPI), and metrics that facilitated reporting and analysis of clients’ data.
• Developed and shared Power BI reports and dashboards with various user groups in Power BI service
• Implemented incremental refresh within Power BI, scheduled refreshes and maintained gateways.
• Designed SSIS packages to extract data from multiple sources such as Flat files, Microsoft excel, folders, XML files, and databases. Performed transformations on the data to verify validity, accuracy, completeness, split data, and combined data. Some of the transformations utilized include lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Designed and develop Dashboards and Reports using SSRS, developed various types of complex reports like Drill Down, Drill Through, scorecards and parametrized, Gauges, Pie Chart, Bar Chart, color coded maps Tables and Matrix in a customized format as per business requirements.
• Responsible for defining, designing, and leading implementation of Power BI Reports and dashboards for clients.
• Created calculated columns and measures using DAX Language for KPI’s in Power BI Desktop.