During my time at Concannon, Miller & Co. I gained experience in automating and analyzing data surrounding the world of accounting. Projects that I took on included:Loading, cleaning, and transforming accounting data to efficiently create queries to be used in Power Bi DashboardingBuilding a Power Bi dashboard for managers and shareholders to monitor workflow status related to accounting and tax services; Data was synched daily from practice management solutions to deliver accurate reports in real-timeDeveloped a Power Bi dashboard integrated with McDonalds point-of-sales data. This dashboard was dynamically engineered via DAX to analyze sales, costs, and inventory for 1,000 McDonald’s locationsDeveloped SQL scripts to clean and transform point of sale data into reports ready for consumption and use by staff accountantsMapped and preformed data validation from point-of-sale user portals with data received in batch in filesAssisted in the development of automated processes using UiPath StudioDeveloped Excel Automations in UiPath to clean, manipulate, and move dataParticipated in brainstorm sessions to transform business automation practicesPreformed bank reconciliations and deposit verifications within Quick Books Online Assisted in formatting Excel workbooks with various functions which improved the efficiency of staff accountantsThis experience allowed me to be creative and innovative when working data analytics, something that I aspire to use for the rest of my career.