System Engineer
Current• Executed robust Extraction, Transformation, and Loading (ETL) processes in Power BI, integrating diverse data sources and ensuring seamless data flow.• Worked in Data Transformations using Power Query Editor, employing techniques such as Pivot, Unpivot, column splitting, Append, Merge, and Sort to optimize data loading.• Formulated and maintained Data Models, establishing relationships based on Star/Snowflake schemas for enhanced data organization.• Experienced in creation of calculated columns and calculated measures using DAX Iterative functions.• Created the dashboard with different visualizations such as Pie-charts, bar-charts, cards, Donut chart etc. based on customer/ business needs.• Enhanced report interactivity by implementing bookmarks and drill-through features using buttons and actions.• Implemented Row Level security (Static/Dynamic) to safeguard data integrity based on user or user group specifications.• Published dashboards using gateways for Dataset Refresh, facilitating seamless sharing across teams, clients, and end-users.• Fostered collaboration with team members, customers, and end-users in crafting analytical solutions aligned with organizational objectives.
