Power Bi Engineer
CurrentClient - Cigna (April 2021 to Present)Responsibilities:• Developed Power BI model used for well model reporting.• Designed and documented the entire architecture of Power BI.• Utilized advance analysis actions, calculations, parameters, background images, maps, trendlines, groups, hierarchies and KPI dashboards.• Used various sources to pull data into Power BI such as SQL Server, Oracle etc.• Installed and configured Enterprise gateway and Personal gateway in Power BI service.• Created Workspace and content packs for business users to view the developed reports.Client - SVB (June 2019 to March 2021)Responsibilities:● Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.● Created reports using time intelligence calculations and functions.● Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.● Used Power BI to collaborate with different users and stakeholders to work on live data sources.● Oversaw data collection and consolidation for reporting. Designed and built dashboards used to monitor performance metrics.● Imported data from SQL Server to Power BI to generate reports.Client - Toyota North America (Jan 2017 to May 2019)Responsibilities:• Created interactive and highly informative Power BI reports using advanced DAX features.• Created DAX Queries to generate Calculated columns & measures in Power BI.• Generated Calculated tables in Power BI by using DAX.● Applied advanced Excel skills (pivot tables, lookups, charts) and Access database querying skills in streamlining and automating accounting processes.• Created different visualizations in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc.