System Engineer
Current• Experienced in connecting with multiple data sources like SQL Server, Oracle and Excel from Power BI to build complex datasets.• Extensively used transformations like Merge Queries, Append Queries, Adding Custom Columns, Splitting and Merging the Columns.• Developed reports and dashboards using Power BI Desktop, data visualization, analytics, and insights creation for data-driven decision- making.• Hands on Experience with Visual level, Page level, Report level Drill Through filters for filtering the data in a report and creating hierarchies in reports.• Migration of data from one source to other source, used Power Query to reshape data with calculated columns and measures.• Automated report and dashboard updates based on set frequency of refresh cycles, decreased manual effort spent on generating reports by 90%.• Provided training and support to end-users on data understanding and report/dashboard navigation.• Built re-usable report components using bookmarks and buttons.• Ensured data security through authentication methods such as Row Level Security.
