Power Bi Developer
• As a part of the Project Phoenix Team, I created 8 Control Reconciliation Reports for the purpose of highlighting detailed variances and/or discrepancies between other related master reports in the project. • As a part of the Project Thrones Team, the main task was to develop 2 multi-page divestment reports for the team that would essentially replicate and automate the existing manual Transition and Final Accounting statements. • Implemented and configured various Power BI visualizations for the reports, including Tables, Matrix, Single and Multiple Row Cards, Stacked Bar and Column Charts, Donut Chart, Slicers, etc. to display specific analytics for the team’s business needs. • Installed and configured Power BI On-premise Gateway for published report to access and refresh files located on network drive. • Sourced data from Azure Data Lake by writing complex queries and creating views from Fact and Dimensional tables to retrieve required data. Data extrapolation from flat files was also used as a reporting source. • Developed and thoroughly documented SSIS packages for the purpose of ETL to load fact and dimensional tables from TEXT and CSV flat files into the Data Mart in the Azure SQL Database .
