Business Intelligence Analyst
Jefferson City, Missouri
• Eliminated manual and labor-intensive reporting efforts to reconcile general ledger to customer accounts by replacing the process with a dynamic data warehousing solution which leverages accounting data. Project consultant gathering requirements, mapping and translating data, and facilitating meetings between technical and business teams involved. • Monitored daily changes in liquidity by assisting the Asset-Liability Management team with building and maintaining dashboards in Power BI and Tableau• Enhanced customer experience by building reporting to assist management with coaching and guidance of employees, measuring employee performance and cross sell initiatives• Increased efficiency and effectiveness of targeted marketing efforts by collaborating with Retail BI team on building Next Best Action and other propensity score models, as well as generating customer communication lists for e-mail, phone and direct mail channels• Other various ad-hoc analyses as needed using tools such as R, MS SQL Server and Visual Studio (SSRS and SSIS), MS Power BI, and MS Excel.