Software Engineer - Axdev Technologies Private Limited
(2018-01)
Software Engineer - National Grid
Experience with advanced power BI topics such as complex calculations, table calculations, geographic mapping, and performance optimization.
- Designed and developed Power BI graphical and visualization solutions based on business requirement
- Involved in setting standards and best practice for newly growing team
- Created standard templates for the team to follow
- Automated Power Query refresh using power shell script and windows task scheduler
- Prepared best practice documents on Power BI Designed and documented the entire Architecture of Power BI POC
- Expertise in writing complex DAX functions in Power BI and Power Pivot
- Created visualizations and reports based on the requirement
- Shared reports/dashboards by creating Content Packs and created reports to view in Power BI Mobile
- Involved in configuring Gateway for Power BI to access on-premise data and Monitored Scheduled Datasets Refresh
- Interacting with onsite counterparts and business directly for understanding the requirement
Software Engineer - GlaxoSmithKline- GSK
- Analyzed prepared cubes for reporting requirements through slice and dice, drill-down, roll up, and pivot
- Writing complex DAX functions in Power BI Desktop and Power Pivot reports
- Created Workspace and content packs for business users to view the developed reports
- Involved in Installation, Configuration and Deployment of Reports using Power BI Desktop
- Designed and developed the reports according to the requirements using Power BI Desktop and Power pivot
- Providing continued maintenance and development of bug fixes for the existing and new Power BI
- Created Templates/Dashboard for various departments as per the requirement
- Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard
- Designed and documented the entire Architecture of Power bi POC
- Wrote calculated columns, Measures query's in Power pivot to show good data analysis techniques
- Weekly presentation to the business users about the Region Revenue Dashboard reports and their changes as required
- Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
- Worked on all types of transformations that are available in Power bi query editor