Nick B

Experience

1. Sr Data Analyst Power Bi Consultant

   U.S. Bank

   Mar 2021 — Present · Minneapolis, MN, US

   Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees). • Interact with business users to identify dashboard strategies, wire frames and analysis presentations.• Delivered multiple dashboards Mitigate Risk, Track Critical Dates, Portfolio Summary, Optimize Cost, Browse Properties, Manage Transactions and C&W performance summary.• Delivered multiple reports; Critical Dates, Target market Rent vs Offers, Lease Holdovers, Transaction Schedules, Mark to market variance, Upcoming expansions/Area, Portfolio ownership overview, largest site cost summary, Upcoming expirations/Area, Building cost/Area, Regional cost Summary, options lease, opportunity lease and lease scoring summary.• Continuously analyze existing KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps.• Delivered UAT test cases; validated the quality and integrity of the data included in the Reporting Packages and Dashboards.• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.• Involved in the competitive market analysis research for the Production team to provide insight into enhancements using Power BI.• Deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source.• Creating custom complex data analytics in Microsoft Power BI to identify trends within quality data and find new sources of revenue within customer data.• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder.